mySQL server has gone away

[Don Chambers]

Occasionally - and far more often than I like - I get the following when using spartacus:

Code: Select all

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_spartacus:bacfc9bb08ee14c2e4fdbb8ce2566244/last_crc_sidebar', 'afcbbfc8bea5b81e18da215df19f8775', '0')

/ MySQL server has gone away

I also have frequent long delays before receiving any response from spartacus and during other admin/back-end operations.

Any ideas?

[garvinhicking]

Hi!

Please check your MySQL server error log, this is definitely a MySQL problem (or a PHP client libary problem). It is not caused by Serendipity.

Regards,
Garvin

[Don Chambers]

I wish I could Garvin - but it is a shared server, and I do not have access to any of the logs. Care to speculate without any logs?

I have had numerous problems ... timeouts when using ftp, frequent delays using spartacus, and of course, errors like the one I mentioned. Is there a chance these errors could have something to do with my ISP, and not on the server? I've also wondered if any of this could be related to my use of xampp... obviously, the error is not coming from an s9y installation on my sandbox, just wondering if the fact that it is running could cause problems when I am trying to access a real server.

[garvinhicking]

Hi!

I wish I could Garvin - but it is a shared server, and I do not have access to any of the logs. Care to speculate without any logs?

Impossible to speculate without logs. My guess: The mysql server is overloaded or the connection ressources are too limited.

The error is definitely on your server. Your ISP/route to the host has nothing to do with it, because the mysql error happens from within the webserver, completely independent from your local route.

Regards,
Garvin

[Don Chambers]

Thanks Garvin. That particular hosting account has been problematic from the beginning.... I think they have me stuck on some high-load server. I simply cannot justify the expense of a dedicated server, even if virtual. But, perhaps I'll give them a call and yell at them again just for fun!