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)
* in modules/core/classes/GalleryStorage.class at line 547 (gallerystorageextras::removeallmapentries)
* in modules/core/classes/GalleryCoreApi.class at line 2975 (mysqlstorage::removeallmapentries)
* in modules/imageblock/classes/ImageBlockHelper.class at line 777 (gallerycoreapi::removeallmapentries)
* in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 59 (imageblockhelper::handleevent)
* in modules/core/classes/GalleryCoreApi.class at line 2238 (galleryeventhelper_simple::postevent)
* in modules/core/classes/GalleryItem.class at line 440 (gallerycoreapi::postevent)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 183 (galleryphotoitem::save)
* in modules/core/classes/GalleryCoreApi.class at line 1668 (galleryitemhelper_medium::additemtoalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 313 (gallerycoreapi::additemtoalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 190 (itemaddfromserver::additem)
* in modules/core/ItemAdd.inc at line 159 (itemaddfromserver::handlerequest)
* in ??? at line 0 (itemaddcontroller::handlerequestwithprogressbar)
* in modules/core/classes/GalleryTemplateAdapter.class at line 1092
* in /storage/g2data/smarty/templates_c/%%2312554500/carbon/%%2E^2E1^2E11E2E2%%theme.tpl.php at line 141 (gallerytemplateadapter::trailer)
* in lib/smarty/Smarty.class.php at line 1255
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 241 (gallerysmarty::fetch)
* in main.php at line 506 (gallerytemplate::display)
* in main.php at line 104
* in main.php at line 88
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.
Posted: Mon, 2009-10-05 01:37
Posts: 16320
Enable debug mode FAQ: How to set/use Gallery in debug mode?
try the operation again and post results.
What image toolkits do you have enabled and in what priority
FAQ: What information is required when I ask for help in the forums?
Diable the EXIF module as well.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
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!
Posts: 16320
From your error :
I am no DB expert so try google on this error
Also try a different locking:
site admin -> General : Locking System
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
thanks, but unfortunately the same error even with database locking (vs file locking) switched on
Posts: 16320
The google is your friend
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
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.
Posts: 21
ok ive turned off innodb_table_locks to OFF .. and it seems to have affected
so far...
Posts: 16320
Let me know how it works out, so I can add it to the 'locks' FAQ.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
spoke too soon! it's doing it again this morning
SPoke to a hosting manager where the server is hosted and has said all is up to date and fine tuned just right ... must be something askew with the G2 code?!
Posts: 16320
Might be a code issue, but I don't have a clue what, because it works just fine on my 3 different hosts.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
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.
Posts: 9283
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
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 21
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)
Posts: 21
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
Posts: 16320
FAQ: I suddenly got an "ERROR_LOCK_TIMEOUT" message, what do I do?
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
Cool have just done everything suggested in that FAQ , to no avail
Posts: 21
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...
Posts: 21
still completely OK since making that change.
Posts: 16320
Thanks for getting back to us. Glad it worked out. I added some info to two FAQs.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
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...