Database error 2006 while doing query MySQL server has gone

[satyrvs]

Hello, when i process the queue to send a message, the following error occurs. Could help me to solve this problem.

thank you very much.

---------------------------------------------------
PHPlist version 2.10.3
---------------------------------------------------
Started
Processing has started, 1 message(s) to process.
It is safe to click your "stop" button now, report will be sent by email to (email)
Processing message 30
Looking for users
Found them: 3859 to process
Process Killed by other process
Script stage: 5
1 messages sent in 38.03 seconds (94 msgs/hr)
Finished this run
Waiting for 3600 seconds before reloading
---------------------------------------------------
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away

[H2B2]

Might be the max_questions issue, in which case the server configuration (php.ini) limits the allowed number of database queries per hour.

You could take a look at these posts:
http://forums.phplist.com/viewtopic.php?p=23248#23248
http://forums.phplist.com/viewtopic.php?p=13972#13972
http://forum.powweb.com/showthread.php? ... adid=23735

[Hernol]

Mmm, seems to be a Mysql bug, check this out http://bugs.mysql.com/bug.php?id=3643
Re you running v4.1.2?

[satyrvs]

OK, thanks. I'll check now this with my ISP.

In the meanwhile, before your post-reply i did the process queue again and have this diferente error:

--------------------------------------------------
Started
A process for this page is already running and it was still alive 592 seconds ago
Sleeping for 20 seconds, aborting will quit
<div>Database error 0 while doing query MySQL server has gone away</div>
Script stage: 1
Finished, Nothing to do
Finished, All done
--------------------------------------------------

Could you identify this error type?

[satyrvs]

Hello, i've:
PHP List version 2.10.3
PHP version 4.4.2
MySQL version 5.0.27

[satyrvs]

Hello,

I'd contacted my ISP for this problem, and my ISP's answer was:

[quote]"The script is a bit old and does not support the version 5.0 from MySQL. the server have MySQL version 5."[/quote]

It's true? How can i fix this problem?

[H2B2]

Though it is true that phplist has not been fully tested with a MySQL 5 setup, a number of users are effectively using phplist with MySQL 5.

It seems to me your ISP is taking the easy way out, and apparently does not seem to be inclined to increase the max_questions setting.

So you might try the 'trick' suggested by unitedauctionllp to increase the max_questions, which basically consists of adding a few database users in phplist's config.php file. See: http://forums.phplist.com/viewtopic.php?p=23248#23248

Also read this:
http://forums.phplist.com/viewtopic.php?p=13972#13972
http://forum.powweb.com/showthread.php? ... adid=23735

[satyrvs]

Hi,

I had created 4 news database users with the same password of the first user. Updated my config.php with the array pf users.

Did the "process queue" and get the same error message:

Process Killed by other process
(...)
1 messages sent in 38.01 seconds (94 msgs/hr)
(...)
Database error 2006 while doing query MySQL server has gone away (repeated 14 times)


I'm stressing This newsletter is so urgent! Any quick solution to help me!?


Edited:
Also got new info from my ISP:
"In your server you have a limit of 500 messages per hour and your MySQL server don't have any querie limits"

[H2B2]

In that case, I dont know what could be the problem.

You might search the forum for "Database error 2006" and see in something useful comes up.

[bioclef]

Hi all,

I've the sample problem and I think this is a common one. I did tried to migrate my database to MySQL for but unsuccessful.

So, I'd forwarded the problem to our support department. And this is what one of the engineers replied.

----
We investigated the issue and it looks like some problem with the PHPList application itself. We raised the memory limits for the account just to see if this will resolve the issue, unfortunately on the several we got the following output:
==================
A process for this page is already running and it was still alive 363 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 384 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 405 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 466 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 487 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 508 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 569 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 590 seconds ago
Sleeping for 20 seconds, aborting will quit
Database error 2008 while doing query MySQL client ran out of memory

0 new rules found
0 bounces not matched
0 bounces matched to existing rules
Database error 2013 while doing query Lost connection to MySQL server during query
==================

I have more than 7000 bounces for processing. Could it be because of that?

I really hope that someone will help me on this issue. It's urgent. Thanks so much.

[zeuschicago]

I just upgrade my sever to mySql 5.x (because 4.1.x was end-of-lifed for support on 12/31/06 and started seeing this error message right after upgrading

"Database error 2006 MySQL server has gone away"

has anyone had luck fixing this?

Z

p.s. I am running on a dedicated servers, max_questions is not set

[mdellinger]

Was there ever a resolution to this problem, I am having the same issue.

Started
Processing has started, 1 message(s) to process.
It is safe to click your "stop" button now, report will be sent by email to ----
Processing message 25
Looking for users
Found them: 2 to process
Process Killed by other process
Script stage: 5
1 emails failed (will retry later)
Finished this run
Waiting for 3600 seconds before reloading

and then:

Database error 2013 while doing query Lost connection to MySQL server during query
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away

This is really starting to stress me out too and I don't know how to resolve this. I'm setting this up for a client and there's only about 300 in the mailing list, but we tried mailing out twice and it only made it through about 105. I'm running in test mode now, but I can't keep sending out emails to test this out.

[Dragonrider]

I don't know if it helps, but doing a search in Google comes up with a number of applications that are suffering the same error, not just phpList.

The MySQL forums have a thread on the issue, there's one on the vBulletin forum too, OSCommerce as well.

I've looked at the MySQL forum thread, but have to admit been totally flummoxed!

Just found a post from the second page of Google results which I can understand. "Restarted MySQL and the problem went away". Might that help?

[mdellinger]

This is still giving me issues.

The client I'm doing this for is using GoDaddy, and I don't see any way to restart MySQL.

This is really a problem because I can only really 'test' this out when I'm sending out a newsletter to everyone. When I run phpList in 'test mode' everything works fine.

[database error]

I moved a mailing list over from Mailman to phpList. I am also receive the same error ... and our site is also on godaddy dot com and so I wonder if it is something at their end too? Co-hosting. No control over mySQL.

As the process cant end I am a bit concerned that the mail that we sent to users has not been received. Small list of 1,000 users. I tried leaving settings as default. I tried changing them to batch and changing time periods to avoid obvious "spamming" (e.g. 10 a minute). No difference. I also note that godaddy does not seem to allow for IMAP in their php installation and so I also notice is that there are no bounces (and no email notification has been received). This concerns me because I would expect their to be some bounces and makes me wonder if anything has actually gone out.

It seems to have gotten through 900 plus but has been stuck on the final 70 odd odd for the last 12 hours or more. Are there more complete logs anywhere?


Thanks.

Process queue says;

Started
A process for this page is already running and it was still alive 204 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 265 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 286 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 307 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 368 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 389 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 450 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 471 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 492 seconds ago
Sleeping for 20 seconds, aborting will quit
A process for this page is already running and it was still alive 553 seconds ago
Sleeping for 20 seconds, aborting will quit
Sending in batches of 10 emails
<div>Database error 0 while doing query MySQL server has gone away</div>
Script stage: 1
Finished, Nothing to do
Finished, All done

Database error 2013 while doing query Lost connection to MySQL server during query
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away
Database error 2006 while doing query MySQL server has gone away

Started
Sending in batches of 10 emails
Processing has started, 2 message(s) to process.
Please leave this window open. You have batch processing enabled, so it will reload several times to send the messages. Reports will be sent by email to info@...
Processing message 15
Looking for users
Found them: 74 to process
Process Killed by other process
Script stage: 5
1 messages sent in 44.46 seconds (80 msgs/hr)
Finished this run
Waiting for 60 seconds before reloading

Naturally, I have not done anything to Kill the process