Ok,
I updated max_allowed_packet to 16M and the same problem still occurrs.
I think the issue is with fork because DBD errors out right after the
first db insert that the child process does.
Is there a bug for this?
I have DBI->trace(3) turned on and the errors it gives are not very
descriptive see below.
Any ideas out there?
-> finish for DBD::mysql::st (DBI::st=HASH(0x103bdb58)~0x1039b82c)
<- finish= 1 at spammer.cgi line 211
-> finish for DBD::mysql::st (DBI::st=HASH(0x103f3ca0)~0x103f3c88)
<- finish= 1 at spammer.cgi line 212
-> finish for DBD::mysql::st (DBI::st=HASH(0x103f3d6c)~0x103f3cd0)
<- finish= 1 at spammer.cgi line 213
-> finish for DBD::mysql::st (DBI::st=HASH(0x103f5428)~0x103f53b0)
<- finish= 1 at spammer.cgi line 214
-> finish for DBD::mysql::st (DBI::st=HASH(0x103f54d0)~0x103f5458)
<- finish= 1 at spammer.cgi line 215
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x103b5d34)~0x103bdb28)
imp_dbh->svsock: 10141950
ERROR EVENT 2013 'Lost connection to MySQL server during query' on
DBI::st=HASH(0x1039b82c)
Lost connection to MySQL server during query error 2013 recorded: Lost
connection to MySQL server during query
<- dbd_st_execute -2 rows
!! ERROR: 2013 'Lost connection to MySQL server during query'
<- execute= undef at spammer.cgi line 161
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at /home/hotbacon/admin-cgi/spammer.cgi line 161.
-> errstr in DBD::_::common for DBD::mysql::db
(DBI::db=HASH(0x103b5d34)~0x103bdb28)
<- errstr= ( 'Lost connection to MySQL server during query' ) [1
items] at spammer.cgi line 161
Lost connection to MySQL server during query at
/home/hotbacon/admin-cgi/spammer.cgi line 161.
-> finish for DBD::mysql::st (DBI::st=HASH(0x103ac714)~0x1039ed68)
<- finish= 1 at admin_login.pm line 135
-> finish for DBD::mysql::st (DBI::st=HASH(0x103ac840)~0x101c00a4)
<- finish= 1 at admin_login.pm line 136
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x103ac834)~0x103ac8a0)
imp_dbh->svsock: 103a0868
On Fri, 5 Oct 2001, Jani Tolonen wrote:
> Alex Menendez writes:
> > Hello, All
>
> Hi Alex,
>
> > I built a spammer cgi some time ago that sends opt-in email to a list
> > of recipients stored in a member account db. It has ran fine in the
> > past. However, recently it is generating 2013 errors (Lost connection to
> > Mysql server during query) .
> <cut>
> > | message |
> > mediumtext
> <cut>
>
> You've got a mediumtext field in your table, which can accept max 16Mb
> characters. Please make sure that your max_allowed_packet is the same.
>
> E.g. start MySQL daemon with 'mysqld -O max_allowed_packet=16M'
>
> Regards,
>
> - Jani
>
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
> <___/ www.mysql.com
>
---------------------------------------------------------------------
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
