PDOException: SQLSTATE[HY000]: [#1498596]

Comment	File	Size	Author
#1	error.jpg	413.3 KB	konstantin che

Comment #1

konstantin che commented 24 March 2012 at 18:08

Status	File	Size
new	error.jpg	413.3 KB

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => ru [:source] => Attachments added to other displays to achieve multiple views in the same view. [:context] => ) in locale() (line 683 of C:\Users\Kostya\Dropbox\www\www\autosalon\modules\locale\locale.module).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => ru [:source] => Attachments added to other displays to achieve multiple views in the same view. [:context] => ) in locale() (line 683 of C:\Users\Kostya\Dropbox\www\www\autosalon\modules\locale\locale.module).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 206 of C:\Users\Kostya\Dropbox\www\www\autosalon\includes\session.inc).

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 18655651064f6e15f45bf207.58113368 ) in lock_release_all() (line 269 of C:\Users\Kostya\Dropbox\www\www\autosalon\includes\lock.inc).

Log in or register to post comments

Comment #2

konstantin che commented 25 March 2012 at 14:45

I solved the problem this way: set max_allowed_packet = 4M to the file my.ini

The problem occurs only with the included Russian language.

Log in or register to post comments

Comment #3

romualdk commented 12 August 2012 at 19:35

Thanks !

Log in or register to post comments

Comment #4

Chimos commented 28 January 2013 at 16:11

Hi,

I posted a similar issue (or maybe the same) here: http://drupal.org/node/1872098
And I posted it there, because I thought it was an Intenationalization (i18) issue.

In the solution provided in #2:

I solved the problem this way: set max_allowed_packet = 4M to the file my.ini

The problem occurs only with the included Russian language.

Is my.ini a server config file? My site is in production in a remote shared server.. Can I solve this without accessing the server / hosting admin? I contacted the aministrators of this hosting and they told me this is a problem in my code.

Thanks

EDIT: Finally it seems it was a problem of the hosting admin ¬¬, they say they changed the parameter value to 64M:
max_allowed_packet = 64M

Log in or register to post comments

Comment #5

hfvd commented 23 January 2013 at 08:54

It also occurs in the Dutch language with D7.19

Log in or register to post comments

Comment #6

vmunoz commented 26 March 2013 at 08:26

Also Spanish. Solved editing max_allowed_packet.

Log in or register to post comments

Comment #7

abiyub commented 2 April 2014 at 15:27

Issue summary:

View changes

i faced the same issue!! this is so helpful: if you chancge the max_allowed_packet = 4M or 8M, it will work fine. this happens when you install modules. in my case it happend when i am installing feeds, and job_schedualer modules.

good luck