I have a reproduceable problem loading long values on 7.4.3.27 (build 027-121-048-452) with LOGWRITER OFF on Linux SUSE 8.0 (2.4.19-ac4).
The data was extracted from a database running under 7.4.3.25 via a tableextract command like this:
DATAEXTRACT FOR DATALOAD TABLE my_table
OUTFILE '/mydir/my_commandfile.fmt'
OUTFILE '/mydir/my_datafile.dat'
LONGFILE long_data_column '/mydir/my_longfile.long'The table has 2 columns (col1 CHAR(16), col2 LONG BYTE ) and about 30.000 rows.
my_datafile.dat is about 800 k
my_longfile.long is about 280mb
when I'm starting the upload, everything some values are inserted, as I can see in the sql-studio. Then the load on the machine goes up, the machine becomes nonresponsive, and the only way to stop this is a hardware reboot. After that none of the values is in the database. I managed to upload smaller tables one by one without any problems (30.000 rows and longfiles with size of < 250mb maximum load of 4), but when I put more DATALOAD-statements into one batchfile I get the same effect. Could somebody give me a hint what's going wrong here?
regards, max
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
