Hi Guys. I've updated to CVS to get the bulk watermarking functionality. It's working beautifully but now Remote won't log in on one of my sites. I have 2 g2 installs running the same version:
Gallery version = 2.2-svn core 1.1.21
PHP version = 4.4.3 apache
Webserver = Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.3 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Database = mysql 4.1.21-standard, lock.system=flock
Toolkits = Exif, Gd, ImageMagick, ArchiveUpload
Acceleration = full/86400, full/900
Operating system = Linux server.sportingimages.info 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686
Default theme = matrixsi
gettext = disabled
Locale = en_US
Browser = Mozilla/5.0 (Windows NT 5.1; U; en) Opera 9.00
Rows in GalleryAccessMap table = 795
Rows in GalleryAccessSubscriberMap table = 538058
Rows in GalleryUser table = 5
Rows in GalleryItem table = 524290
Rows in GalleryAlbumItem table = 7990
Rows in GalleryCacheMap table = 18453
The one I'm having problems with is a huge gallery (520000 images, as you can see). So previously remote took a couple of minutes to fetch the albums. Now it just gives me the following error (full log attached):
Quote:
7859|TRACE|GalComm2 |Connecting to: http://sportingimages.com.au/gallery/main.php
7859|TRACE|GalComm2 |Path: /gallery/main.php
7859|TRACE|GalComm |Sending cookie: GALLERYSID=c03b051dfab7034e50953cf0b858c039; expires=Wed Dec 13 00:40:48 EST 2006; path=/; domain=.sportingimages.com.au
37453|TRACE|GalComm2 |Content-type: text/plain; charset=UTF-8
37453|TRACE|GalComm2 |Error: Error (ERROR_STORAGE_FAILURE)<b>in</b> modules/core/classes/GalleryStorage.class <b>at line</b> 480 (gallerycoreapi::error)
<b>in</b> modules/core/classes/Gallery.class <b>at line</b> 202 (mysqlstorage::search)
<b>in</b> modules/core/classes/helpers/GalleryItemHelper_medium.class <b>at line</b> 71 (gallery::search)
<b>in</b> modules/core/classes/GalleryCoreApi.class <b>at line</b> 1505 (galleryitemhelper_medium::fetchallitemids)
<b>in</b> modules/remote/GalleryRemote.inc <b>at line</b> 276 (gallerycoreapi::fetchallitemids)
<b>in</b> modules/remote/GalleryRemote.inc <b>at line</b> 86 (galleryremotecontroller::fetchalbums)
<b>in</b> main.php <b>at line</b> 211 (galleryremotecontroller::handlerequest)
<b>in</b> main.php <b>at line</b> 94
<b>in</b> main.php <b>at line</b> 83
#__GR2PROTO__
debug_user=admin
debug_time=28.738s
debug_exception=
37453|TRACE|GalComm2 |Short response: #__GR2PROTO__
debug_user=admin
debug_time=28.738s
debug_exception=
I've searched exhaustively. Deleted template cache, deleted database cache, optimized database, and checked the database for crashed tables. All are fine. Adding images from local server works fine, in fact, since upgrading the server to a new dual core system and upgrading gallery to SVN we can now add images in blocks of 500 rather than having to do 50 at a time to prevent it from timing out and adding them twice.
The gallery remote endlessly fetching albums behaviour occurs on 2 computers at 2 seperate locations (I don't have a log for the other machine). Both were able to connect fine before SVN upgrade, both are exhibiting the same behaviour now.
Any ideas?
Cheers
Jaymis
jaymismakeswebsites
Posted: Tue, 2006-11-21 14:57
