Weird error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Weird error

Post 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?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply