Storage Errrors - none of the articles / searches so far are helpful
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 01:37
|
|
Hi Guys, I have a dedicated, and up to date Debian box running on some decent hardware. Its sole purpose is gallery. Now taht i have a new SLR camera, when i attempt to add more than a few photos at once ( a few at a time is OK), I get errors like this ; Error (ERROR_STORAGE_FAILURE) * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1149 (gallerycoreapi::error) I have tried several things , from several articles, (on this forum and others) ... cleared caches, ruled out templates, performed database cleanups / checks, bumped every limit that I could find in php, mysql, etc ... yet i still get these errors. Some of the articles seem to "blame" mysql and the solution is to just wait and do image uploads in dribs and drabs??? Does anyone have a better solution? I have complete control of the box and can do what i like with it, so open to any suggestions. Cheers, brad. |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Mon, 2009-10-05 01:45
|
|
Enable debug mode FAQ: How to set/use Gallery in debug mode? What image toolkits do you have enabled and in what priority Diable the EXIF module as well. Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 02:11
|
|
Thanks for the reply. I have also tried turning off EXIF modules to no avail. It is onyl if i upload more than a few at a time ... so it's got to be breaching some sort of limit ... despite gallery having unbridled access to thsi machine (from what my amateur knowledge can establish) Gallery info : http://www.darb.net/forgallery/g2info.txt Debug : http://www.darb.net/forgallery/debug-dump.htm PHPINFO dump : http://www.darb.net/forgallery/phpinfodump.htm cheers! |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Mon, 2009-10-05 02:43
|
|
From your error : Quote:
mysqlt error: [1213: Deadlock found when trying to get lock; try restarting transaction] I am no DB expert so try google on this error Dave _____________________________________________ |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 03:27
|
|
thanks, but unfortunately the same error even with database locking (vs file locking) switched on |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Mon, 2009-10-05 13:25
|
|
The google is your friend Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 14:04
|
|
yeah ive done a lot of googling on the error, but cant work out / do not understand what the fix is, or what i need to do. Some articles ive come across (makers of webmail software and other apps) have said its up to the vendor to work around, but i really have no idea. |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 14:33
|
|
ok ive turned off innodb_table_locks to OFF .. and it seems to have affected |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Mon, 2009-10-05 22:53
|
|
Let me know how it works out, so I can add it to the 'locks' FAQ. Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 23:12
|
|
spoke too soon! it's doing it again this morning |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Mon, 2009-10-05 23:36
|
|
Might be a code issue, but I don't have a clue what, because it works just fine on my 3 different hosts. Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Mon, 2009-10-05 23:51
|
|
yeah mate has worked fine for me for yeaaars ... its only recently, since a mysql upgrade (just using apt-get in debian to do it). Have run various mysql db checks and what not ... all come back OK. |
|
|
nivekiam
Joined: 2002-12-10
Posts: 16504 |
Posted: Tue, 2009-10-06 00:00
|
|
Quote:
because it works just fine on my 3 different hosts. And 1,000s or 10,000s of others Since this started after an update.... It's got to be some security update that's in there. The way Debian updates stuff, it once something goes stable, it doesn't get anything new, just security updates and maybe bug fixes depending on the fix. At least that's my understanding. Might be time to look into updating Etch to Lenny |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Tue, 2009-10-06 00:30
|
|
yeah im not discounting that it may be the OS / Mysql ... just trying to work out how to actually diagnose that, it appears only to be issue with gallery (other apps are behaving unfortunately) |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Tue, 2009-10-06 00:40
|
|
ps dave wheres the "locks" FAQ ?? I have searched , can't find?!? sorry if its blatantly obvious!! I am getting lock errors when deleting too |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Tue, 2009-10-06 00:46
|
|
FAQ: I suddenly got an "ERROR_LOCK_TIMEOUT" message, what do I do? Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Tue, 2009-10-06 01:08
|
|
Cool have just done everything suggested in that FAQ , to no avail |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Tue, 2009-10-06 01:42
|
|
Ok interstingly i stumbled across another setting which i chose to change, in config.php ... for the storage type , I've made it just "mysql" instead of mysqlt (mysqli obviously doesnt work at all) ... and it hasnt hiccuped again since. Given I'm tempting fate by saying the above, I'll see how it goes over the next 24hrs... |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Wed, 2009-10-07 05:21
|
|
still completely OK since making that change. |
|
|
floridave
Joined: 2003-12-22
Posts: 27300 |
Posted: Wed, 2009-10-07 13:19
|
|
Thanks for getting back to us. Glad it worked out. I added some info to two FAQs. Dave |
|
|
darb
Joined: 2007-05-07
Posts: 21 |
Posted: Sun, 2009-10-11 03:50
|
|
thanks dave, i found another forum article : http://gallery.menalto.com/node/23294 Where someone had the same issue .... if mysqli is enabled in the config.php, this error occurs ... I dont understand enougha bout it as to why, but i do now that my gallery install set mysqli as the default... |
|
