Page 1 of 1

Weird error

Posted: Tue Sep 19, 2006 10:49 am
by pickle
Hi all,

I got this weird error on my OpenBSD server last night. Errors identical to this were generated for about 3 hours then the error went away. During this time, a 2nd server was not able to contact this server.

The error was:

Code: Select all

060918 22:34:02  Aborted connection 10895 to db: 'mydb' user: 'myuser' host: `localhost' (Got an error writing communication packets)
I'm confused as to why mysql would be writing communication packets to itself - especially when communicating over localhost, which uses sockets, rather than the network.
Has anyone come across this before?

Posted: Thu Sep 21, 2006 3:27 am
by Benjamin
Have a look at..

http://marc.theaimsgroup.com/?l=php-dev ... 130973&w=2
http://marc.theaimsgroup.com/?l=php-dev ... 431876&w=2

Might want to make sure your using mysql_close() as well.

Posted: Thu Sep 21, 2006 9:46 am
by pickle
Thanks for the tip. I'm not sure this applies though, as I'm not using a persistant connection. I do know for a fact that I'm not using mysql_close(). PHP is supposed to close all DB connections at script end, so I haven't bothered.

It's one thing to have an error - it's another thing to have no error for a year, then an error for 3 hours, then no error again.

Thanks again.