Gallery 3 issue again . . . Working fine for weeks, then goes blank
|
elfinstrider
Joined: 2006-03-10
Posts: 15 |
Posted: Wed, 2009-11-04 02:56
|
|
I'm running the latest experimental G3 code and I'm finding that this issue crops up every couple of weeks. Everything installs fine, everything works fine, then one day, I get a blank page. I can go to upgrader. I can do the install. . . but G3 doesn't want to go. Looking at my log, I'm getting: 2009-11-03 05:29:29 -08:00 --- error: There was an SQL error: Got error 12 from storage engine - SELECT * FROM (`caches`) WHERE `key` = 'f5c7444726e7a4137ca2db3bbd509a17' Now, I've dumped the caches table, but it's still gone. I could kill everything and reinstall again, but this probably will probably just come back. Perhaps there's something in the code running a bit amuck and filling up a session table or something, but I can't find it. Thoughts? |
|
| Login or register to post comments |
Posts: 16328
System error: 12 = Cannot allocate memory
http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
Ask you host about this error.
Also google said: "I have had this issue happening when there was no more room left on the hard drive..."
Perhaps your host is limiting resources? Could be related to a G2 issue with resources as well:
FAQ: I seem to be running into some sort of MySQL query limit, is there anything that can be done?
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 15
I'll ask, but I'm doubtful that it's a hard drive issue, I have almost a terabyte of space. At least I'm supposed to.
I'll look into it, but any other thoughts would be great.
-s
Posts: 16328
Remember that in most hosted environments the DB is on a different server and might not be accounted for in the 'hosted' space of your claimed terabyte.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 15
Very true, but we're running some pretty heavy custom scripts that can bring smaller dedicateds to their knees and I'm certain they have more overhead than Gallery3. . . if they don't there is something wrong.
I'm working with the host with it as well, just a very strange issue and its repeatable.
Going to post the log, in case anyone has an idea or wants to see. Domain name has been censored
2009-11-03 05:29:29 -08:00 --- error: There was an SQL error: Got error 12 from storage engine - SELECT *
FROM (`caches`)
WHERE `key` = 'f5c7444726e7a4137ca2db3bbd509a17'
#0 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/drivers/Database/Mysql.php(99): Mysql_Result->__construct(false, Resource id #20, true, 'SELECT *?FROM (...')
#1 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Database.php(259): Database_Mysql_Driver->query('SELECT *?FROM (...')
#2 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/MY_Database.php(56): Database_Core->query('SELECT *?FROM (...')
#3 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Database.php(898): Database->query('SELECT *?FROM (...')
#4 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/drivers/Cache/Database.php(123): Database_Core->getwhere('caches', Array)
#5 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Cache.php(119): Cache_Database_Driver->get('f5c7444726e7a41...')
#6 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/Gallery_View.php(84): Cache_Core->get('f5c7444726e7a41...')
#7 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/Theme_View.php(213): Gallery_View_Core->combine_files(Array, 'css')
#8 [internal function]: Theme_View_Core->__call('head', Array)
#9 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/themes/default/views/page.html.php(71): Theme_View->head()
#10 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Controller.php(74): include('/nfs/c05/h04/mn...')
#11 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/View.php(272): Controller_Core->_kohana_load_view('/nfs/c05/h04/mn...', Array)
#12 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/MY_View.php(39): View_Core->render(false, false)
#13 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/View.php(244): View->render()
#14 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/controllers/albums.php(78): View_Core->__toString()
#15 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/controllers/rest.php(91): Albums_Controller->_show(Object(Item_Model))
#16 [internal function]: REST_Controller->__call(460, Array)
#17 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/core/Kohana.php(291): ReflectionMethod->invokeArgs(Object(Albums_Controller), Array)
#18 [internal function]: Kohana::instance()
#19 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/core/Event.php(209): call_user_func(Array)
#20 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/core/Bootstrap.php(55): Event::run('system.execute')
#21 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/index.php(86): require('/nfs/c05/h04/mn...')
#22 {main}
2009-11-03 05:34:43 -08:00 --- error: There was an SQL error: Got error 12 from storage engine - SELECT *
FROM (`caches`)
WHERE `key` = 'f5c7444726e7a4137ca2db3bbd509a17'
Posts: 15
Alright, after tweaking a LOT, I found I'm able to dump the session tables and functionality comes back. ..
Here's another read from the server logs, its still pointing to a memory issue, but the amount seems quite small.
Thoughts?
2009-11-04 13:11:07 -08:00 --- error: Uncaught Kohana_Database_Exception: There was an SQL error: Out of memory (Needed 521520 bytes) - SHOW TABLES FROM `db77913_egimages` in file system/libraries/drivers/Database/Mysql.php on line 371
2009-11-04 13:11:07 -08:00 --- error: #0 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/drivers/Database/Mysql.php(99): Mysql_Result->__construct(false, Resource id #21, true, 'SHOW TABLES FRO...')
#1 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/drivers/Database/Mysql.php(285): Database_Mysql_Driver->query('SHOW TABLES FRO...')
#2 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Database.php(1195): Database_Mysql_Driver->list_tables()
#3 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/MY_Database.php(79): Database_Core->list_tables()
#4 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/MY_Database.php(54): Database->add_table_prefixes('SELECT `value`?...')
#5 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/libraries/Database.php(861): Database->query('SELECT `value`?...')
#6 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/helpers/module.php(340): Database_Core->get()
#7 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/modules/gallery/libraries/I18n.php(65): module_Core::get_var('gallery', 'default_locale')
#8 [internal function]: I18n_Core::instance()
#9 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/core/Event.php(209): call_user_func(Array)
#10 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/system/core/Bootstrap.php(46): Event::run('system.ready')
#11 /nfs/c05/h04/mnt/77913/domains/domainname.com/html/gallery/index.php(86): require('/nfs/c05/h04/mn...')
#12 {main}
Posts: 15
Reinstalled, reloaded and once again after a few days, I'm seeing the same error again.
Media Temple is looking at it, but does anyone else see this problem anywhere?
Anyone else hosting on Media Temple?
Posts: 15
I've worked with (mt) a little regarding the G3 install, this is their response as looking through the logs and finding some issues.
-----------------
The MySQL container has been rebooted to kill any longstanding MySQL queries that were running causing resource outages. I would suggest to let the container run for another 24-72hours. Then, run the Slow Query Report via the Account Center. Try to cut down on any slow queries that are generated and this will free up more resources on the Container. If optimizations to MySQL are not helping, an upgrade to the Container might need to be considered. If you have any further questions regarding your (mt) Media Temple services, please feel free to contact us at any time.
Best Regards,
-----------------
I'm going to post the report to see if there's anything to be optimized.