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