Hi!

Maciek> Hi, Maciek> MySQL 3.23.36 crashes (SEGV) during execution of mysqldump program. I've Maciek> encountered this problem before in different mysql versions. It doesn't Maciek> happen everytime. Below you can find any information I thought could be Maciek> useful.

Maciek> mysqldump is run from a script that makes backup of the whole db.

Maciek> mysqldump -u $DBLOGIN -p$DBPASS -T Maciek> $BACKUPDIR/$DATE/$db --all --fields-terminated-by='~END~' $db

Could you please check if the following patch fixes this:

===== sql/field.cc 1.38 vs edited ===== *** /tmp/field.cc-1.38-3281 Mon Apr 16 14:05:55 2001 --- edited/sql/field.cc Mon Apr 16 14:18:25 2001 *************** *** 1791,1797 **** #endif memcpy_fixed((byte*) &nr,ptr,sizeof(nr));

! val_buffer->alloc(max(field_length,70)); char *to=(char*) val_buffer->ptr();

if (dec >= NOT_FIXED_DEC) --- 1791,1798 ---- #endif memcpy_fixed((byte*) &nr,ptr,sizeof(nr));

! uint to_length=max(field_length,70); ! val_buffer->alloc(to_length); char *to=(char*) val_buffer->ptr();

if (dec >= NOT_FIXED_DEC) *************** *** 1841,1848 **** while (tmp_dec--) *to++= *pos++; #else ! #ifdef HAVE_SNPRINTF_ ! sprintf(to,val_buffer->length(),"%.*f",dec,nr); #else sprintf(to,"%.*f",dec,nr); #endif --- 1842,1850 ---- while (tmp_dec--) *to++= *pos++; #else ! #ifdef HAVE_SNPRINTF ! to[to_length-1]=0; // Safety ! snprintf(to,to_length-1,"%.*f",dec,nr); #else sprintf(to,"%.*f",dec,nr); #endif

Another option is to change the FLOAT column to DOUBLE and check if this helps!

Regards, Monty