Bug #54720 Mysql Server crashes and automatically restart where updating temporary table
Submitted: 23 Jun 2010 6:44 Modified: 27 Jul 2011 6:38
Reporter: Satyapal Garhwal Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:5.1.50 OS:Linux ( RED HAT Enterprise Linux 2.6.9-55.ELsmp)
Assigned to: CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[23 Jun 2010 6:46] Satyapal Garhwal
Attaching server log file

Attachment: optimusdb.fjdc.com.err (application/octet-stream, text), 63.88 KiB.

[23 Jun 2010 10:19] Satyapal Garhwal
This is store procedure where error occurs and servere crashes

Attachment: sp_inv_fg_reconciliation_proc.sql (application/unknown, text), 14.66 KiB.

[23 Jun 2010 11:14] Satyapal Garhwal
These are ddl and dml for table created using mysql admin utility

Attachment: table_ddl_dml.rar (application/octet-stream, text), 128.94 KiB.

[24 Jun 2010 6:33] Satyapal Garhwal
this is ddl and dml of core parameter master

Attachment: parameter_bkup.sql (application/unknown, text), 155.22 KiB.

[25 Jun 2010 9:39] Satyapal Garhwal
snding my.cnf file (configuration file )

Attachment: my.cnf (application/octet-stream, text), 7.35 KiB.

[28 Jun 2010 13:10] Satyapal Garhwal
u can see outpput of linux top command if thsis this the situation then server creashes

Attachment: top.rar (application/octet-stream, text), 65.25 KiB.