hi Monty,
i already ftp to ftp://support.mysql.com/pub/mysql/secret a
zip of scripts for your kindly inspection at the "MySQL has gone
away..." fault happening when i want to insert a big row to my ebody table which
contains a LONGTEXT (or LONGBLOB) column. the scripts are
- blob.pl: a small Perl5 script. it first read a big file (i used a 6MB file) into a variable $blob. then it tries to insert variable $blob to ebody table via DBI. it is not necessary to be 6MB to see the fault. 900KB is enough.
- ebody: my table schema.
- myDBI.pm: a utility Perl5 script of mine just doing more abstraction of popular DBI.pm.
to avoid further table
corruption of my production database, i created ebody into the
MySQL-accompanying "test" database and did the blob.pl test. the fault is still
there....MySQL has just gone away with the wind....
since i could not see
if i succeeded in FTP the zip file to your ftp site, i also attach the file in
this message.
thanks a lot for the kindly
attention. i really appreciate it.
peter
----- Original Message
-----
From: Michael Widenius
<[EMAIL PROTECTED]>
To: Huang-Ming <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 22,
2001 2:17 PM
Subject: MySQL constantly
crash on BLOB insertions...
>
> >>>>> "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes:
>
> Huang-Ming> hi sirs,
> Huang-Ming> i met a serious bug on inserting a 900+KB data into a LONGBLOB column.
>
> Huang-Ming> the error shows
>
> Huang-Ming> "MySQL server has gone away on executingSQL=
> Huang-Ming> INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid)
> Huang-Ming> VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) "
>
> Huang-Ming> it seems occurring only on insertions of "big data", eg. data>500KB. but when the
> Huang-Ming> error occurs, it still has no problem to inset smaller data, eg. 100KB- data. so the
> Huang-Ming> fault might happen only to big data insertion.
>
> Huang-Ming> i'm using MySQL 3.22.25.
>
> Huang-Ming> this is schema of table 'ebody': (it has 75 rows now)
>
> Huang-Ming> create table ebody(
> Huang-Ming> bid integer auto_increment not null,
> Huang-Ming> msgid varchar(80) not null,
> Huang-Ming> body longtext,
> Huang-Ming> length integer,
> Huang-Ming> subj varchar(128),
> Huang-Ming> pri tinyint,
> Huang-Ming> rtime datetime,
> Huang-Ming> froms varchar(80),
> Huang-Ming> tos text,
> Huang-Ming> ccs text,
> Huang-Ming> bccs text,
> Huang-Ming> nattach tinyint,
> Huang-Ming> #
> Huang-Ming> KEY i_msgid (msgid(8)),
> Huang-Ming> PRIMARY KEY (bid)
> Huang-Ming> );
>
> Huang-Ming> for your easier insepction, i also attach log message of my application which
> Huang-Ming> is a Perl5 script and is NOT running under mod_perl.
>
> Huang-Ming> at your earliest convenience, please advise me on how to go on inserting big data
> Huang-Ming> to this table. eg., should i need to upgrade to 2.23.31 for this problem.
>
> Huang-Ming> thanks a lot.
> Huang-Ming> Peter Pan
>
> Unfortunately I couldn't read your test with my email reader.
> If you can ftp a full test program to:
>
> ftp://support.mysql.com/pub/mysql/secret
>
> we shall take a look at this!
>
> Regards,
> Monty
>
mysql-blob-fault.zip--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
