hi sirs,
 
i met a serious bug on inserting a 900+KB data into a LONGBLOB column.
 
the error shows
 
 "MySQL server has gone away on executingSQL=
  INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid)
  VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) "
 
it seems occurring only on insertions of "big data", eg. data>500KB. but when the
error occurs, it still has no problem to inset smaller data, eg. 100KB- data. so the
fault might happen only to big data insertion.
 
i'm using MySQL 3.22.25.
 
this is schema of table 'ebody': (it has 75 rows now)
 
create table ebody( 
 bid     integer auto_increment not null,
 msgid   varchar(80) not null, 
 body    longtext,  
 length  integer,  
 subj    varchar(128),  
 pri     tinyint,  
 rtime   datetime,  
 froms   varchar(80),  
 tos     text,   
 ccs     text,   
 bccs    text,   
 nattach tinyint,  
 #
 KEY i_msgid (msgid(8)), 
 PRIMARY KEY (bid)
 );
 
for your easier insepction, i also attach log message of my application which
is a Perl5 script and is NOT running under mod_perl.
 
at your earliest convenience, please advise me on how to go on inserting big data
to this table. eg., should i need to upgrade to 2.23.31 for this problem.
 
thanks a lot.
Peter Pan
 
 
Mailhost=vmail.unknown.com
Domain=unknown.com
child 177 working: SOCKIO::Socket::INET=GLOB(0x85f2e50)TOARRAY(0x85f2e44)FROMMSG
---------- SMTP server 177 starts ----------
---MIME headers---
subject=4444444
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------5747514527BE3D5B45C15B20"
mime-version=1.0
date=Mon, 22 Jan 2001 07:38:19 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------5747514527BE3D5B45C15B20
Attachment: 1.14R2 B1 (to all).zip (163700 bytes)
(177): LOCK TABLES ebody WRITE
(177): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(177): SELECT last_insert_id() FROM ebody
(177): UNLOCK TABLES
(177): SELECT value FROM sption WHERE name='blocks'
(177): SELECT uid FROM alias WHERE alias='panpipi'
user([EMAIL PROTECTED])=1
(177): SELECT options,blocks FROM eption WHERE uid=1
(177): SELECT areply,signature FROM eption WHERE uid=1
(177): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(177): SELECT filters FROM eption WHERE uid=1
(177): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(177): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(177): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(177): INSERT INTO email(bid,fid,oid,filtered) VALUES('75','0','1',?)
---------- SMTP server 177 exits ----------
child 179 working: SOCKIO::Socket::INET=GLOB(0x85f5200)TOARRAY(0x814878c)FROMMSG
---------- SMTP server 179 starts ----------
---MIME headers---
subject=all.zip
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------C6046A0F3A7DD29D3AE1F1B9"
mime-version=1.0
date=Mon, 22 Jan 2001 07:38:21 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------C6046A0F3A7DD29D3AE1F1B9
Attachment: 1.14R2 B1 (to all).zip (163700 bytes)
(179): LOCK TABLES ebody WRITE
(179): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(179): SELECT last_insert_id() FROM ebody
(179): UNLOCK TABLES
(179): SELECT value FROM sption WHERE name='blocks'
(179): SELECT uid FROM alias WHERE alias='panpipi'
user([EMAIL PROTECTED])=1
(179): SELECT options,blocks FROM eption WHERE uid=1
(179): SELECT areply,signature FROM eption WHERE uid=1
(179): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(179): SELECT filters FROM eption WHERE uid=1
(179): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(179): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(179): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(179): INSERT INTO email(bid,fid,oid,filtered) VALUES('76','0','1',?)
---------- SMTP server 179 exits ----------
child 182 working: SOCKIO::Socket::INET=GLOB(0x85f2e5c)TOARRAY(0x85f2e2c)FROMMSG
---------- SMTP server 182 starts ----------
---MIME headers---
subject=99999
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------83A59136D174F01D5551A302"
mime-version=1.0
date=Mon, 22 Jan 2001 07:40:02 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------83A59136D174F01D5551A302
Attachment: J-Pcrystal.zip (1348720 bytes)
(182): LOCK TABLES ebody WRITE
(182): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(182): UNLOCK TABLES
MySQL server has gone away on executeSQL=INSERT INTO 
ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) at 
/usr/local/apache/htdocs/perl/myMail.pm line 149
Database handle destroyed without explicit disconnect.
child 201 working: SOCKIO::Socket::INET=GLOB(0x85f5224)TOARRAY(0x81f90e0)FROMMSG
---------- SMTP server 201 starts ----------
---MIME headers---
subject=999999
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------53564481286C2FC5148B7CF1"
mime-version=1.0
date=Mon, 22 Jan 2001 07:46:02 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------53564481286C2FC5148B7CF1
Attachment: admin.bmp (3111231 bytes)
(201): LOCK TABLES ebody WRITE
(201): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(201): UNLOCK TABLES
MySQL server has gone away on executeSQL=INSERT INTO 
ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) at 
/usr/local/apache/htdocs/perl/myMail.pm line 149
Database handle destroyed without explicit disconnect.
child 231 working: SOCKIO::Socket::INET=GLOB(0x85f52f0)TOARRAY(0x85f2e44)FROMMSG
---------- SMTP server 231 starts ----------
---MIME headers---
subject=999999
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------F3CC5B55EB03AE88EECB6AAC"
mime-version=1.0
date=Mon, 22 Jan 2001 08:02:39 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------F3CC5B55EB03AE88EECB6AAC
Attachment: J-Pcrystal.zip (1348720 bytes)
(231): LOCK TABLES ebody WRITE
(231): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(231): UNLOCK TABLES
MySQL server has gone away on executeSQL=INSERT INTO 
ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) at 
/usr/local/apache/htdocs/perl/myMail.pm line 149
Database handle destroyed without explicit disconnect.
child 244 working: SOCKIO::Socket::INET=GLOB(0x85f502c)TOARRAY(0x814878c)FROMMSG
---------- SMTP server 244 starts ----------
---MIME headers---
subject=xxxxx
[EMAIL PROTECTED]
from=pipi <[EMAIL PROTECTED]>
content-type=multipart/mixed; boundary="------------C13C0BBD6074997BCAA44F84"
mime-version=1.0
date=Mon, 22 Jan 2001 08:14:35 +0800
message-id=<[EMAIL PROTECTED]>
x-mailer=Mozilla 4.05 [en] (Win95; I)
---end MIME headers---
Local: [EMAIL PROTECTED]
Relay: 
boundary=------------C13C0BBD6074997BCAA44F84
Attachment: 1.14R1 B13 (to David).zip (77012 bytes)
(244): LOCK TABLES ebody WRITE
(244): INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) 
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?)
(244): SELECT last_insert_id() FROM ebody
(244): UNLOCK TABLES
(244): SELECT value FROM sption WHERE name='blocks'
(244): SELECT uid FROM alias WHERE alias='panpipi'
user([EMAIL PROTECTED])=1
(244): SELECT options,blocks FROM eption WHERE uid=1
(244): SELECT areply,signature FROM eption WHERE uid=1
(244): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(244): SELECT filters FROM eption WHERE uid=1
(244): SELECT date_add(curdate(),INTERVAL curtime() HOUR_SECOND)
(244): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(244): SELECT sum(size) FROM email,ebody WHERE oid='1' AND email.bid=ebody.bid
(244): INSERT INTO email(bid,fid,oid,filtered) VALUES('77','0','1',?)
---------- SMTP server 244 exits ----------

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

Reply via email to