ST Alpha - "It is varchar(22). I don't know why I can't run it with Order By, by I keep getting this error:" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "GregW: How big is the field you are sorting on, or what datatype is it? -- nm" by Beryllium

It is varchar(22). I don't know why I can't run it with Order By, by I keep getting this error:

Posted by GregW (aka not2fast) Aug 23 '12, 14:15

java.sql.SQLException: Error writing file '/data01/tmp/MYIaxp8t' (Errcode: 28)

That filesystem has over 100GB free on both the source and target systems. I don't know which one it is referring to.

Unfortunately, I am a bit lost once it gets into java and mysql.

Responses:

bad permissions on /data01/tmp ? -- nm - zork Aug 23, 15:09
what is the query that causes that error? -- nm - Beryllium Aug 23, 15:01 7
- It is a simple select. - GregW Aug 23, 15:05 6
  - and what do you want to do with it? -- nm - Beryllium Aug 23, 15:09 5
    - I am running a tool that extracts the data to my DB2 server where I will use it to load our new database. - GregW Aug 23, 15:14 4
      - Really? It doesn't use disk files for sorting? -- nm - GregW Aug 23, 15:21 1
        
        mysql might - but since you're invoking it from java, I think it's trying to create an in-memory result set that is too large -- nm - Beryllium Aug 23, 15:22
      - You might want to forget java and just use mysqldump ... or even the mysql command itself to make a CSV -- (link) - Beryllium Aug 23, 15:19
      - well, it sounds like what you're telling it to do is "select 200 million rows into RAM", which ... isn't useful. -- nm - Beryllium Aug 23, 15:17
Are you creating temp tables? -- nm - JaxSean Aug 23, 14:20 1
- No -- nm - GregW Aug 23, 14:29

Post a message top

It is varchar(22). I don't know why I can't run it with Order By, by I keep getting this error:

Replies are disabled on threads older than 7 days.