Gallery 3 Server Add Stalls

russellw

Joined: 2014-02-02
Posts: 1
Posted: Sun, 2014-02-02 02:12

Good morning

I have upgraded from G2 to G3 (latest release) and because there were issues with doing the G2 import (it imported albums, comments etc. but no images) have been using the server add module instead.

It seems to be able to import one image at a time but then stalls.

The logs show the following:

2014-02-01 23:06:24 +00:00 --- error: Database_Exception [ 44 ]: #2006: MySQL server has gone away [ SELECT * FROM `caches`
WHERE `key` IN ('3103dfb1e0baac644433276c75d15569') ]
/gallery3/system/libraries/Database_Mysqli_Result.php [ 27 ]
#0 /gallery3/system/libraries/Database_Mysqli.php(79): Database_Mysqli_Result_Core->__construct(false, 'SELECT *?FROM `...', Object(mysqli), true)
#1 /gallery3/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute('SELECT *?FROM `...')
#2 /gallery3/modules/gallery/libraries/MY_Database.php(48): Database_Core->query('SELECT *?FROM `...')
#3 /gallery3/system/libraries/Database_Builder.php(973): Database->query('SELECT *?FROM `...')
#4 /gallery3/modules/gallery/libraries/drivers/Cache/Database.php(105): Database_Builder_Core->execute()
#5 /gallery3/system/libraries/Cache.php(141): Cache_Database_Driver->get(Array, true)
#6 /gallery3/modules/gallery/models/task.php(58): Cache_Core->get('3103dfb1e0baac6...')
#7 /gallery3/modules/gallery/helpers/task.php(104): Task_Model_Core->log('exception 'Data...')
#8 /gallery3/modules/server_add/controllers/server_add.php(122): task_Core::run('13')
#9 [internal function]: Server_Add_Controller->run('13')
#10 /gallery3/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Server_Add_Controller), Array)
#11 [internal function]: Kohana_Core::instance(NULL)
#12 /gallery3/system/core/Event.php(208): call_user_func_array(Array, Array)
#13 /gallery3/application/Bootstrap.php(67): Event_Core::run('system.execute')
#14 /gallery3/index.php(116): require('/gal...')
#15 {main}

It's an owned server.
Centos 5.10
PHP 5.3.28.2
mySQL 5.0.95-5

The connection timeouts are set reasonably high and nothing else running on the server is having mySQL timeout issues which it looks like this is.

Any pointers appreciated.

Cheers
Russ