Error (ERROR_STORAGE_FAILURE)

poseidon2050

Joined: 2004-11-30
Posts: 3
Posted: Tue, 2004-11-30 23:45

in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 233 (gallerystatus::error)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 181 (mysqldatabasestorage::_getconnection)
in modules/core/classes/GalleryStorage.class at line 483 (mysqldatabasestorage::init)
in install/steps/InstallCoreModuleStep.class at line 51 (gallerystorage::isinstalled)
in install/index.php at line 148 (installcoremodulestep::loadtemplatedata)

file_exists(/home/tuning/public_html/gallery/g2data/sessions/3e4d8a9b371329f47ae893f8bae3e343)
file_exists(/home/tuning/public_html/gallery/g2data/cache/module/core/0/0/0.inc)
mysql error: [: Connection error to server 'localhost' with user
'tuning_admin'] in PCONNECT(localhost, ?, ?, tuning_nuke)

Warning: mysql_pconnect() has been disabled for security reasons
in
/home/tuning/public_html/gallery/lib/adodb/drivers/adodb-mysql.inc.php
on line 355
localhost: Connection error to server 'localhost' with user
'tuning_admin'

mysql error: [: Connection error to server 'localhost' with user
'tuning_admin'] in PCONNECT(localhost, ?, ?, tuning_nuke)

Warning: mysql_pconnect() has been disabled for security reasons
in
/home/tuning/public_html/gallery/lib/adodb/drivers/adodb-mysql.inc.php
on line 355
localhost: Connection error to server 'localhost' with user
'tuning_admin'

realpath(/home/tuning/public_html/gallery/modules/core/classes/../../../)

 
Mezon

Joined: 2004-11-30
Posts: 7
Posted: Wed, 2004-12-01 00:36

your server's admin has disabled mysql_pconnect() function - unless you are the admin, there isn't much you can do about it...

i recommend bugging the developers, mysql_pconnect() is known to be buggy, unstable, and most admins hate it wholeheartedly...

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2004-12-03 06:13

Mezon, can you offer up some references to support that claim? It's not that I don't believe you, it's just that I haven't had any problems with pconnect in the past few years, and haven't heard of too many issues from the various commercial sites that I know use them.

Either way, I added a new feature to G2 to allow you to disable them in your config.php. Add this line:

$storeConfig['usePersistentConnections'] = false;

right before:

$gallery->setConfig('storage.config', $storeConfig);

and we won't use pconnect.

 
dmbfansim

Joined: 2004-12-20
Posts: 1
Posted: Mon, 2004-12-20 22:49

bharat,

i added that line of code to the config.php file. i am still getting this error when install the gallery core:

"Warning: mysql_pconnect() has been disabled for security reasons
in
/usr/home/www/dmbfansim/simeons.net/docs/gallery2/lib/adodb/drivers/adodb-mysql.inc.php
on line 355"

thanks,
simeon

 
fryfrog

Joined: 2002-10-30
Posts: 3236
Posted: Tue, 2004-12-21 00:48

Of course I am sure that you updated your gallery 2 from cvs or nightly builds? Just adding the configuration to config.php doesn't magically get the code to support it, though in your support bharat forgot to tell you to update :)

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Tue, 2004-12-21 02:14

True. Though I expected that the "I added a new feature" line would indicate that it's not in his version of G2. Unless I magically got the l33t powers to hack his box :-)

Fryfrog is correct -- please get the latest snapshot and try with the flag I suggest above.

 
rso

Joined: 2006-05-15
Posts: 6
Posted: Tue, 2006-05-23 17:03

Hi,

I got this error

Quote:
Error (ERROR_STORAGE_FAILURE)

when my /var slice in FreeBSD was full too.
Check the error file of your mysql to see if that is the case.

 
glen_di_persio

Joined: 2006-10-22
Posts: 3
Posted: Tue, 2007-06-12 14:19

I got an ERROR_STORAGE_FAILURE when uploading a ton of images and using MySQL. I tracked it down with logged debugging, and found this in the log file:

Log:
mysqli error: [1406: Data too long for column 'g_data' at row 1] in EXECUTE("UPDATE g2_SessionMap SET g_userId=6, g_remoteIdentifier='...', g_creationTimestamp=1181614877, g_modificationTimestamp=1181619477, g_data='really long value' WHERE g_id='...'")

Resolution:
-delete the newly added images (or folder) from g2data
-run this command in mysql - assumes your DB is UTF8
alter table g2_sessionmap
modify column g_data LONGTEXT
character set utf8
collate utf8_general_ci
default null;
-add the images (or again) and presto!

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2007-06-12 23:31

this will be fixed in G2.2.2. and G2.3. the session data field will be larger.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage

 
zztype

Joined: 2004-12-27
Posts: 5
Posted: Sat, 2008-08-02 19:05

I have this happening suddenly. Out of 8 gallery installs on my server, 4 of them have experienced this or similar errors. This one was working last night. It stopped working just after midnight last night while the gallery's owner was working in it.

I checked the database and all fields are busy. I did a dump backup, but the file appears relatively empty. There were several albums and hundreds of photos in this gallery before it died.

http://www.hennesseyspaddleboarding.com/gallery/

This galley has been in operation for several years, was upgraded from G1 to G2.

Please advise.

Now, all that shows up at the gallery install is this the error below:

Error

Error (ERROR_STORAGE_FAILURE) :
in modules/core/classes/GalleryStorage.class at line 624 (GalleryCoreApi::error)
in modules/core/classes/GalleryCoreApi.class at line 2800 (GalleryStorage::getMapEntry)
in modules/core/classes/GallerySession.class at line 851 (GalleryCoreApi::getMapEntry)
in modules/core/classes/GallerySession.class at line 231 (GallerySession::_loadSessionData)
in modules/core/classes/Gallery.class at line 287 (GallerySession::init)
in init.inc at line 118 (Gallery::initSession)
in main.php at line 76

 
cleoent

Joined: 2008-03-13
Posts: 20
Posted: Mon, 2008-08-18 20:40

i'm having this problem, any updates?

 
silverfox

Joined: 2004-10-08
Posts: 21
Posted: Sun, 2009-01-04 23:53

Please try repairing your database tables.

This can be done easily from phpmyadmin. Many web hosts include a mysql manager that can do this as well.

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 06:07

After a year without any problems I'm now unable to upload or delate images. I get the following errors..

An error has occurred while interacting with the database.

The exact nature of database errors is not captured unless Gallery debug mode is enabled in config.php. Before seeking support for this error please enable buffered debug output and retry the operation. Look near the bottom of the lengthy debug output to find error details.
Back to the Gallery

Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1128 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage.class at line 528 (gallerystorageextras::removeallmapentries)
in modules/core/classes/GalleryCoreApi.class at line 2858 (mysqlstorage::removeallmapentries)
in modules/imageblock/classes/ImageBlockHelper.class at line 747 (gallerycoreapi::removeallmapentries)
in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (imageblockhelper::handleevent)
in modules/core/classes/GalleryCoreApi.class at line 2140 (galleryeventhelper_simple::postevent)
in modules/core/classes/helpers/GalleryPermissionHelper_advanced.class at line 96 (gallerycoreapi::postevent)
in modules/core/classes/helpers/GalleryPermissionHelper_advanced.class at line 149 (gallerypermissionhelper_advanced::_postgroupevent)
in modules/core/classes/GalleryCoreApi.class at line 756 (gallerypermissionhelper_advanced::removegrouppermission)
in modules/password/classes/PasswordHelper.class at line 700 (gallerycoreapi::removegrouppermission)
in modules/password/module.inc at line 226 (passwordhelper::handlenewitem)
in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (passwordmodule::handleevent)
in modules/core/classes/GalleryCoreApi.class at line 2140 (galleryeventhelper_simple::postevent)
in modules/core/classes/GalleryEntity.class at line 285 (gallerycoreapi::postevent)
in modules/core/classes/GalleryItem.class at line 412 (galleryfilesystementity::save)
in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 183 (galleryphotoitem::save)
in modules/core/classes/GalleryCoreApi.class at line 1583 (galleryitemhelper_medium::additemtoalbum)
in modules/core/ItemAddFromBrowser.inc at line 112 (gallerycoreapi::additemtoalbum)
in modules/core/ItemAdd.inc at line 84 (itemaddfrombrowser::handlerequest)
in main.php at line 231 (itemaddcontroller::handlerequest)
in main.php at line 94
in main.php at line 83
System Information
Gallery version 2.2.5
PHP version 4.3.11 cgi-fcgi
Webserver Apache/1.3.37 (Unix) mod_ssl/2.8.28 OpenSSL/0.9.6b FrontPage/5.0.2.2510 mod_fastcgi/2.4.2
Database mysql 4.1.14
Toolkits NetPBM, Gd
Operating system FreeBSD hostingprod.com 4.11-YAHOO-20080312 FreeBSD 4.11-YAHOO-20080312 #0: i386
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 1.1.4322; InfoPath.3)

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2010-06-14 10:53

Gallery Admin -> Maintenance -> Clear Database Cache

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

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 15:21

After a few years of without any problems I'm now unable to upload or delate images. I get the following erros..

Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1128 (gallerycoreapi::error)
in

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 15:23

I cleared the database cashe but still get the same errors..

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2010-06-14 15:39
 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 17:56

How can I tell which is corrupted?

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2010-06-14 18:01

in phpMyAdmin there is usually a pointer to crashed/corrupted tables.
I'm not saying yours are corrupted or crashed - but may have overhead.
Its safe to run repair and/or optimize on all tables though.

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

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 18:32

Repaired and optimized tables.... I have 40 table(s) size is 142.7 KiB with 0 B overhead..

Is i go in and delete a photo I get the following error, but when I go back in the photo has infact been deleted.

Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1128 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage.class at line 528 (gallerystorageextras::removeallmapentries)
in modules/core/classes/GalleryCoreApi.class at line 2858 (mysqlstorage::removeallmapentries)
in modules/imageblock/classes/ImageBlockHelper.class at line 747 (gallerycoreapi::removeallmapentries)
in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (imageblockhelper::handleevent)
in modules/core/classes/GalleryCoreApi.class at line 2140 (galleryeventhelper_simple::postevent)
in modules/core/classes/GalleryItem.class at line 341 (gallerycoreapi::postevent)
in modules/core/classes/GalleryDataItem.class at line 236 (galleryitem::delete)
in modules/core/classes/helpers/GalleryEntityHelper_medium.class at line 113 (galleryphotoitem::delete)
in modules/core/classes/GalleryCoreApi.class at line 2271 (galleryentityhelper_medium::deleteentitybyid)
in modules/core/ItemDelete.inc at line 79 (gallerycoreapi::deleteentitybyid)
in main.php at line 231 (itemdeletecontroller::handlerequest)
in main.php at line 94
in main.php at line 83

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2010-06-14 18:48
Quote:
Gallery version 2.2.5

Time to upgrade... its easy just use the preinstaller.

Without seeing some http/php logs I'd just be guessing any further.

The one time I had a similar issue, my /var partition was full and I had to dump some log files to free up space.
You could ask your host to see if they spot any issues.
Otherwise upgrading may fix your problem - and is always recommended.

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

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 18:59

Upgrade what? Gallery? mysql?

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 19:27

I went back in and found one database with a large overhead.. I repaired and optimized it and it looks like it solved the problem...
I can once again delete add and edit...

Thanks for all your help, much appreciated.
Don

 
dpsall2001

Joined: 2008-07-04
Posts: 8
Posted: Mon, 2010-06-14 21:03

How hard is it to install The E2 XML Media Player for Gallery2

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2010-06-14 21:21