hi Monty,
thanks for the response.
i'm writing a small test script to insert similar big stuff to my table and if the
"gone away" fault is still outstanding, i'll send it to you, along with current
contents of my database.
thanks again.
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
>