V2.1 to V2.2

I've tried to upgrade my gallery from V2.1 to V2.24 and I"m getting a error while upgradeing the core.

Anyone can help

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage.class at line 480 (GalleryCoreApi::error)
* in modules/core/classes/Gallery.class at line 202 (GalleryStorage::search)
* in modules/core/CoreModuleExtras.inc at line 1979 (Gallery::search)
* in modules/core/module.inc at line 433 (CoreModuleExtras::upgrade)
* in modules/core/classes/GalleryModule.class at line 160 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 85 (GalleryModule::installOrUpgrade)
* in upgrade/index.php at line 185 (UpgradeCoreModuleStep::processRequest)

Upgrade (or install) core module
Entering CoreModuleExtras::upgrade
Old version: 1.1.0.2 New version: 1.2.0.6

(mysql): SHOW CREATE TABLE `g2_Schema`

The current version is 1.1.0.x

(mysql):
SELECT
g2_MimeTypeMap.g_extension,
g2_MimeTypeMap.g_mimeType,
g2_MimeTypeMap.g_viewable
FROM
g2_MimeTypeMap
ORDER BY
g2_MimeTypeMap.g_extension DESC

file_exists(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/modules/core/classes/GalleryStorage/schema.tpl)
file(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/modules/core/classes/GalleryStorage/schema.tpl,
)

(mysql): SHOW TABLES

(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema

(mysql): UPDATE g2_Item SET g_renderer = NULL

(mysql):
SELECT
g2_Entity.g_id, g2_Entity.g_entityType
FROM
g2_Entity
WHERE
g2_Entity.g_entityType IN ('PanoramaPhotoItem',
'PanoramaDerivativeImage')

mysql error: [2008: MySQL client ran out of memory] in EXECUTE("
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap, g2_Entity
WHERE
g2_AccessSubscriberMap.g_accessListId = 0
AND
g2_AccessSubscriberMap.g_itemId = g2_Entity.g_id
AND
g2_Entity.g_entityType IN
('GalleryDerivativeImage','GalleryUser','GalleryGroup','GalleryComment')
")

(mysql):
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap, g2_Entity
WHERE
g2_AccessSubscriberMap.g_accessListId = 0
AND
g2_AccessSubscriberMap.g_itemId = g2_Entity.g_id
AND
g2_Entity.g_entityType IN
('GalleryDerivativeImage','GalleryUser','GalleryGroup','GalleryComment')

Warning: mysql_query() [function.mysql-query]: Unable to save
result set in
/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/lib/adodb/drivers/adodb-mysql.inc.php
on line 507

2008: MySQL client ran out of memory

ADOConnection._Execute(
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap, g2_Entity
WHERE
g2_AccessSubscri...) % line 870,
file: adodb.inc.php
ADOConnection.Execute(
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap, g2_Entity
WHERE
g2_AccessSubscri..., Array[4]) % line
473, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryAccessSubscriberMap::itemId]
FROM
[GalleryAccessSubscriberMap], [GalleryEntity]
WHERE
..., Array[4], Array[0]) % line 202,
file: Gallery.class
Gallery.search(
SELECT
[GalleryAccessSubscriberMap::itemId]
FROM
[GalleryAccessSubscriberMap], [GalleryEntity]
WHERE
..., Array[4]) % line 1979, file: CoreModuleExtras.inc
CoreModuleExtras.upgrade(Object:CoreModule, null,
Object:StatusTemplate) % line 433,
file: module.inc

realpath(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/modules/core/classes/../../../)
realpath(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/)
Error: Failed to upgrade the core module, this is the error stack trace:
Error (ERROR_STORAGE_FAILURE)in
modules/core/classes/GalleryStorage.class at line 480
(GalleryCoreApi::error)
in modules/core/classes/Gallery.class at line 202
(GalleryStorage::search)
in modules/core/CoreModuleExtras.inc at line 1979
(Gallery::search)
in modules/core/module.inc at line 433
(CoreModuleExtras::upgrade)
in modules/core/classes/GalleryModule.class at line 160
(CoreModule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 85
(GalleryModule::installOrUpgrade)
in upgrade/index.php at line 185
(UpgradeCoreModuleStep::processRequest)

realpath(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/modules/core/classes/../../../)
realpath(/hermes/web01/b2019/pow.saintlaurentfoot/htdocs/gallery2/)

do you have a backup of your database from before the upgrade?

here's the error. i haven't seen this before in the context of gallery, so it's pretty rare.

> mysql error: [2008: MySQL client ran out of memory] in EXECUTE("

	      SELECT
		g2_AccessSubscriberMap.g_itemId
	      FROM
		g2_AccessSubscriberMap, g2_Entity
	      WHERE
		g2_AccessSubscriberMap.g_accessListId = 0
	      AND
		g2_AccessSubscriberMap.g_itemId = g2_Entity.g_id
	      AND
		g2_Entity.g_entityType IN ('GalleryDerivativeImage','GalleryUser','GalleryGroup','GalleryComment')

> ")

-> mysql error: [2008: MySQL client ran out of memory

maybe you should ask your webhost what the per process memory limits / mysql's limits are.

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