Re: Mysql 3.23-14 keeps dieing on me...

[Michal Matula - BillBoard.cz]

Dear Scott,

we ran into simillar problem also, although without those fatal consequences with 
having to reboot etc. We have discovered that this message usually appears when you do 
not explicitely close your connection to MySQL from your scripts before they end up. 
So - before your script ends up , please try to use mysql_close or something simmilar. 

Hope this helps.

Michal 


Michal Matula
BillBoard.cz team
___________________________________
BillBoard.cz - free advertisiment on internet 
http://www.billboard.cz


----- Original Message ----- 
From: "Scott McDaniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 12:16 AM
Subject: Mysql 3.23-14 keeps dieing on me...


> 
> Dear Everyone,
> 
> I am presently running Mysql 3.23-14 server on a dual processor Linux box.
> It is the only service on the server while interactions are done via a web
> interface (Perl CGI) on a separate web server.
> 
> About once an hour, I get the error:
> Aborted connection 52 to db: 'ihost' user: 'web' (Got an error reading
> communication packets)
> 
> Immediately there after, the server fails to respond any more and I must
> kill all the mysqld processes and re-run safe_mysqld.
> 
> I have restarted the process numerous times, I have rebooted the server, I
> have run myisamchk -r on the MYI files and I have check every log looking
> for more information.
> 
> This database holds email account information.  This information is
> modified via a web frontend with Perl CGI doing all the updates.  At any
> given time, there are roughly 10-20 people using the web interface. I have
> restarted apache on the remote web server and still the problem exits.
> 
> Please email possible solutions to [EMAIL PROTECTED]  If you need more
> information, I can provide more information.
> 
> Sincerely,
> Scott McDaniel
> 
> 
> ########################################################
> Scott McDaniel          
> Network Engineer        WorkPhone [800] 239-3000
> ITC^Deltacom            WorkPhone (334) 321-3511 
> 306 Alabama Street      Fax   (334) 321-3599 
> Auburn, AL 36832        Pager   [800] 294-4183 
> EMAIL                         [EMAIL PROTECTED] 
> ICQ#                                     6855702                     
> Instant Messanger                    Penguin0600 
> WEB                    http://scott.deltacom.net
> ########################################################
> 
> 
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php