Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

mysql errors - help!!!

Quote Reply
mysql errors - help!!!
hi

I'm having problems with my GM install and mysql. Mysql seems to keep dying (I think) which means I'm getting errors when users log into the system.

Looking through the mysql error log there are lots of these...

Code:
040801 17:00:53 Aborted connection 8474 to db: 'webmail' user: 'USERNAME' host: `localhost' (Got an error reading communication packets)

To fix the problem I repair the tables and restart mysql... but I'm getting a bit over doing that!

The problem is causing the following error when logging in..

Code:
A fatal error has occured:

DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /mnt/raid/path/to/my/gmail/admin/GT/SQL/Driver.pm line 543.

Can anyone help?????

Thanks!

Regan

Last edited by:

ryel01: Aug 31, 2004, 7:36 PM
Quote Reply
Re: [ryel01] mysql errors - help!!! In reply to
Not really know if the following thread could be of any help:


http://www.gossamer-threads.com/...guest=9250637#242244


HyTC
Quote Reply
Re: [ryel01] mysql errors - help!!! In reply to
Hi,

When you see:

DBD::mysql::st fetchrow_hashref failed: fetch() without execute()
Turn on debug mode and have a look at what $GT::SQL::error says, it should provide more info on the problem.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: [ryel01] mysql errors - help!!! In reply to
Just an observation.
Similar errors fill up the logs for Mysql Version 4.0.20 Max and so also was the case with 3.xx. The only version where the logs were clean of this random error is 4.0.16 and 4.0.18. We are planning to downgrade the Mysql version to one of these and see if the problems go away.

If you are on freebsd you could also follow this thread to see if this can be of help:

http://lists.freebsd.org/...004-June/007625.html

HyTC