Add Items from local server ERRORS

nnikola

Joined: 2004-06-30
Posts: 27
Posted: Wed, 2008-10-29 14:58

Hi,

After it insert few albums I see this error:

Error (ERROR_STORAGE_FAILURE) : Empty sequence id!

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 494 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 1871 (gallerystorageextras::_getuniqueidwithconnection)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 446 (mysqlstorage::getuniqueid)
* in modules/core/classes/GalleryStorage.class at line 346 (gallerystorageextras::newentity)
* in modules/core/classes/GalleryEntity.class at line 168 (mysqlstorage::newentity)
* in modules/core/classes/GalleryChildEntity.class at line 69 (galleryentity::create)
* in modules/core/classes/GalleryFileSystemEntity.class at line 93 (gallerychildentity::create)
* in modules/core/classes/GalleryItem.class at line 192 (galleryfilesystementity::create)
* in modules/core/classes/GalleryAlbumItem.class at line 95 (galleryitem::create)
* in modules/core/classes/helpers/GalleryItemHelper_advanced.class at line 234 (galleryalbumitem::create)
* in modules/core/classes/GalleryCoreApi.class at line 1646 (galleryitemhelper_advanced::createalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 351 (gallerycoreapi::createalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 242 (itemaddfromserver::adddirectory)
* 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 g2data/smarty/templates_c/%%307764054/matrix/%%3A^3A8^3A818B59%%theme.tpl.php at line 75 (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 fresh installation of last version of gallery.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-10-29 16:43

Please post your system info:
FAQ: What information is required when I ask for help in the forums?

Also put gallery into Debug mode, try to upload photos and on the page you get the error, copy and paste the debug output at the bottom of the page into a text file, zip it and attach to another post.

FAQ: How to set/use Gallery in debug mode?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
nnikola

Joined: 2004-06-30
Posts: 27
Posted: Wed, 2008-10-29 17:14

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 apache
Webserver = Apache/1.3.41 (Unix) PHP/4.4.9 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8b
Database = mysqlt 5.0.51a-community, lock.system=flock
Toolkits = Exif, Getid3, LinkItemToolkit, Thumbnail, Gd
Acceleration = none, none
Operating system = Linux server.fotoglasi.com 2.6.18-92.1.13.el5 #1 SMP Wed Sep 24 19:33:52 EDT 2008 i686
Default theme = matrix
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-GB; rv:1.9.0.2) Gecko/2008091618 Firefox/3.0.2
Rows in GalleryAccessMap table = 32
Rows in GalleryAccessSubscriberMap table = 3
Rows in GalleryUser table = 2
Rows in GalleryItem table = 1
Rows in GalleryAlbumItem table = 1
Rows in GalleryCacheMap table = 0

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-10-29 17:43

Looks like the connection to the database is getting lost:

Quote:
2006: MySQL server has gone away

You could try setting $storeConfig['usePersistentConnections'] = false; to $storeConfig['usePersistentConnections'] = true;

Don't know what else to say other than checking with your host or server config.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
nnikola

Joined: 2004-06-30
Posts: 27
Posted: Wed, 2008-10-29 17:51
Quote:
$storeConfig['usePersistentConnections'] = true;

Didn't help.

What should I tell to hosting support ?
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-10-29 18:02

I'd ask them what could be causing my database connection to fail and start from there. You could point them to the debug log and show them the 2006: MySQL server has gone away message.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
nnikola

Joined: 2004-06-30
Posts: 27
Posted: Wed, 2008-10-29 20:10

Support checked server and told everything is ok.
They told me: Typically, "MySQL has gone away" means that the the time between two queries exceeded one of the connection timeouts. It can sometimes be due to MySQL crashes, but the logs don't any.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2008-10-29 20:20

Does it work when you upload a small number (like 1) image? Does it work through other methods? How big are these files?

Try disabling modules you are not using, Exif, getid3, etc. Even if you are using EXIF, I would try disabling it for a test.

I would also try a using a different image toolkit other than GD. Your server most likely had ImageMagick and/or NetPMB installed. Install those toolkits, test/configure them and disable GD. Then try it.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
dia19

Joined: 2005-02-22
Posts: 15
Posted: Thu, 2008-11-06 20:29

Any other ideas for this guy? I'm having the exact same problem. Tried all the above suggestions and no help. Here's my info:

Last Run Details:

Gallery URL = http://aggiewhoop.com/gallery2/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 = 5.2.5 cgi 
Webserver = Apache/1.3.41 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a 
Database = mysqlt 5.0.51a-community, lock.system=flock 
Toolkits = ArchiveUpload, ImageMagick, LinkItemToolkit, Thumbnail 
Acceleration = none, none 
Operating system = Linux sh108.surpasshosting.com 2.6.9-55.0.9.ELsmp #1 SMP Thu Sep 27 18:28:00 EDT 2007 x86_64 
Default theme = matrix 
gettext = enabled 
Locale = en_US 
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/0.3.154.9 Safari/525.19 
Rows in GalleryAccessMap table = 31 
Rows in GalleryAccessSubscriberMap table = 161 
Rows in GalleryUser table = 2 
Rows in GalleryItem table = 160 
Rows in GalleryAlbumItem table = 6 
Rows in GalleryCacheMap table = 0

I read something online that said this:
"You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row"

Could that have anything to do with it? I havent tried it since I dont have access to the file but might contact the server administrator.

I am able to upload files via the local server but have to do in small batches which is a pain. Before I updated to 2.3 I would have to do the same but instead got "HTTP Error 500 - Internal server error".

I looked at the FAQ and went through phpMyAdmin and looked at the id and tried that method but it didnt work either. Also, it doesnt appear I'm affected by sql limiting the amount of connections since I can do this multiple times in a row.

Any other ideas?
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2008-11-06 20:45

Doubt it's the same problem. Post a link to phpinfo and put gallery into debug mode (as described above) and try adding a larger number of files that will generate the error. For Error 500 messages you need take a look at the error logs on the server, check your control panel or contact your host for that info.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
dia19

Joined: 2005-02-22
Posts: 15
Posted: Thu, 2008-11-06 22:40

I am no longer getting Error 500, that was pre v2.3. Here are the files:

http://www.aggiewhoop.com/gallery2/phpinfo.php

Error Log: http://www.aggiewhoop.com/errorlog.txt

Debug Console Log: http://www.aggiewhoop.com/debugconsole.txt
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2008-11-06 22:50

That debug info is from the Smarty Debug popup. There should be other debug output at the bottom of the page (not the popup). That's the debug info we need to look at.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
dia19

Joined: 2005-02-22
Posts: 15
Posted: Thu, 2008-11-06 22:52

Look at the middle link. I think that was the one you need.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2008-11-06 23:07

Sorry, didn't see/notice the debug output there before.

Quote:
mysqlt error: [2006: MySQL server has gone away

Quote:
Looks like the connection to the database is getting lost:

You could try setting $storeConfig['usePersistentConnections'] = false; to $storeConfig['usePersistentConnections'] = true;

Don't know what else to say other than checking with your host or server config.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
dia19

Joined: 2005-02-22
Posts: 15
Posted: Thu, 2008-11-06 23:40

Yeah I tried that awhile ago since I saw you post it. If you have any other ideas let me know. If I cant get this worked out I'll have to start transfering pictures 20 at a time like before.

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2008-11-07 04:06

The only other thing I can think of is to check with your host then.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here