Hi all,

Toni Epple [mailto:[EMAIL PROTECTED] wrote:

> Subject: DATALOAD long causes system crash on 7.4.3.27
> 
> 
> 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 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. 
> 

the described problem was solved by upgrading the db to 7.4.03.30.

Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to