>>>>> "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
---------------------------------------------------------------------
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
