random blank page

Gallery URL = http://www.photosbybailini.com/g2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.4.9 cgi
Webserver = Apache
Database = mysqlt 5.0.83-log, lock.system=database
Toolkits = ArchiveUpload, Exif, Getid3, LinkItemToolkit, NetPBM, Thumbnail, SquareThumb, ImageMagick
Acceleration = partial/3600, partial/3600
Operating system = Linux cgi0701.int.bizland.net 2.6.34.4-nx #1 SMP Tue Aug 24 21:13:13 EDT 2010 i686
Default theme = carbon
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8
Rows in GalleryAccessMap table = 1079
Rows in GalleryAccessSubscriberMap table = 77293
Rows in GalleryUser table = 221
Rows in GalleryItem table = 77290
Rows in GalleryAlbumItem table = 2697
Rows in GalleryCacheMap table = 173283

Hello,
I have had Gallery 2 installed for two years without any major problems. A couple of months ago, I started getting database errors. The techs at my hosting company, Powweb, said some items were corrupted and were able to fix it. Then, a couple of weeks ago I started getting ERROR_LOCK_TIMEOUT. Switching from File to Database Locking seemed to fix it. Recently, I've started getting a blank page when accessing random pages. For example, when I add a print to my basket or when I try to "Continue to Checkout". It seems to frequently go blank when opening main.php

I've gone through the FAQ and generated the attached debug logs. I've tried changing between mysql, mysqlt, and mysqli to no avail. I've tried to delete the database cache, but Failed with this output:

Last Run Details:

Unable to delete directory: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/entity
Successfully deleted directory: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme
Unable to delete directory: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module

I'm at a loss for what else to try. Any help is greatly appreciated.
Thanks

Thanks nivekiam for taking the time to look at this problem.
Well, unfortunately, "living with it" is not an option. Without a working gallery, I'm out of business.

So, it sounds like there's nothing really to "fix". The problem is that I've outgrown the usefulness of my host. Can you suggest a host that could handle this kind of Gallery? I'm in Ontario, Canada if that makes any difference.
How complicated is moving a Gallery this size to another host? Is that something I could get done in Paid Support?

My show season ends in about a month. Is there anything I can do (other than deleting 10s of thousands of proofs) to keep it running until then?
I was planning on switching to something like Zenfolio, but not til my winter down time.

I'll be covering our Provincial Championships this weekend. If there is something that you or another developer can do, I'd be happy to pay for support to have it working on Monday.

What's my "bread crumb"? I'll try switching to Matrix and see what happens.

I've tried switching to Matrix, but still get the blank pages.

Thanks for your input, suprsidr. If you could tell me where to put that code, I'll give it a try. It doesn't really say which file to add it to.
I'm a photographer, not an IT tech, so if you could explain it in layman's terms it would help me out alot.

I also want to add:
That site is extremely slow from my end.
I'm sure you are pushing the limits of your host with that many photos. Are you saying cannot "Archive" some of them?
Disable && uninstall any modules you don't need:

• ArchiveUpload - do you use that feature?
• Exif - again, using it?
• Getid3 - absolutely useless, definately remove.
• LinkItemToolkit - linking to any external photos or movies?
• NetPBM - if ImageMagick is working netpbm is redundant.
• SquareThumb - looks like you're using this, would not be my personal choice.
• ImageMagick - the best image toolkit, if its working properly definitely keep it.

Basically any module listed under the display or extra data categories adds extra cycles to each request:
Random highlight - could be the root of your problem.
New Items, Rating, Comments.... - only if you need them.

-s

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

I've disabled a number of plug ins.

Deleting the Module Settings cache returned this:
Deleting dir: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/httpauth
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/albumselect/0/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/albumselect/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/albumselect
Permission denied removing file /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/archiveupload/0/0/0.incGi42uO
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/archiveupload/0/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/archiveupload/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/archiveupload
Permission denied removing file /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module/captcha/0/0/0.inccP0aiS
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module
Unable to recreate dir: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/module

Since I disabled the album select and archive upload, I'm guessing that is the reason for those errors.

Deleting Theme Settings cache returned this:
Deleting dir: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme/carbon/0/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme/carbon/0
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme/carbon
Unable to remove directory /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme
Unable to recreate dir: /home/users/web/b17/pow.andrewb/htdocs/g2/g2data/cache/theme

I could not delete the Albums and Photo Data cache due to server time out.

All other caches deleted successfully (except, of course, Install/Upgrade log files and Thumbnails and Resizes)

My server error log is attached. I cleared it last night when I started getting these blank pages, so the errors are fresh.

Still getting blank pages, though.
Any other ideas...??

And that would be a restriction on PowWeb's servers. Either their settings are low or you've got a busy site.

I also didn't notice this before, database locking. Try changing that to file locking under Site Admin > General (first page you land on)

You might be able to delete the cache manually using the /lib/support tool explained here:
FAQ: How can I clear cached data? I'm not sure if the delete cache tool under the maintenance section makes DB calls, but I know the tool under /lib/support does not, it just tries to delete the directories.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

hey Hey!

I don't know what I did, or maybe the techs at Powweb did, but it seems to be working now!
The bread crumbs, the shopping card buttons, and the Admin Maintenance tasks all seem to be working properly

Could you do me the favour of checking it from your end?

Latest system info:
Gallery URL = http://www.photosbybailini.com/g2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.4.9 cgi
Webserver = Apache
Database = mysqlt 5.0.83-log, lock.system=flock
Toolkits = ImageMagick
Acceleration = partial/3600, partial/3600
Operating system = Linux cgi0702.int.bizland.net 2.6.33.3-nx #1 SMP Tue May 11 14:02:11 EDT 2010 i686
Default theme = carbon
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8
Rows in GalleryAccessMap table = 1079
Rows in GalleryAccessSubscriberMap table = 77293
Rows in GalleryUser table = 221
Rows in GalleryItem table = 77290
Rows in GalleryAlbumItem table = 2697
Rows in GalleryCacheMap table = 303

Also, the locking system is still set to file. Should I change that back to database to avoid the ERROR_LOCK_TIMEOUT that I was getting before?

Thank you, THANK YOU for all your help!

I'll definitely keep on top of the cache maintenance from now on. I had never tried deleting the database cache until I started getting the lock timeouts, then the process wouldn't finish due to the resource limits on the server.

Now that it's clean, I'm hoping it won't be so difficult to keep it that way.

Once again.... THANK YOU to both suprsidr and yourself.

From here, I'll gladly be going to your "Donate" page!

It's slow IMO. Even before the caches were cleared and even if I revisit a page, just clicking on a thumbnail to go to the next page, nothing happens for a few seconds. Once the page actually starts loading it's not bad. I've seen worse and yours wouldn't drive me away, but it could some other people. The ones I've seen that were worse I've just stopped browsing them.

Your site is hard to browse because it seems to take 8+ clicks to get to the actual photos for a lot of stuff, but that's all in how you're photos are organized in albums.

For example on this page (which I've visited a few times now, so it's in cache)
http://www.photosbybailini.com/g2/v/Equine/2008_Equine/

I click on the Richland Park album (which I've done a few times now, so it's also in cache), it takes a few seconds before anything happens. I'm not clearing my browser cache or anything and a lot of that could/should be cached by Gallery. You could probably ramp up the "Acceleration" under Site Admin > Performance and set Guests to Full Acceleration.

Check out my G2 install below for a comparison. Granted it's not as large as yours by any means, but with G2's architecture size shouldn't matter and if it does it's many times larger than your G2 install (or probably any G2 install you've seen)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

Yeah, some plugins like that don't lend themselves well to big galleries

Do'h I forgot about the cart. I had it stuck in my head that you didn't have any real dynamic content being displayed.

Partial Acceleration if anything is helping the speed of your site. I just turned off all acceleration and caching and cleared out the database and template cache on my site. So you can see what it's like now. I could add a few thousand photos and a few 100 albums, but IMO that would just be wasting resources and as I'm on a shared host and I like to play Mr. Nice Neighbor

O.k. Actually I'm in the process of adding several thousand photos to a test G2 install on my VPS right now, once that's done, I'll PM you a link so you can check that out.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here