|
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
