pls help for below error started getting all of a sudden "http://www.wallpaperhungama.com"
http://www.wallpaperhungama.com/lib/support/index.php?phpinfo
g2data directory permission is -R 777
Gallery URL = http://www.wallpaperhungama.com/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.17 cgi
Webserver = Apache
Database = mysqlt 5.0.95-community, lock.system=flock
Toolkits = ArchiveUpload, Gd, Getid3, LinkItemToolkit, SquareThumb, Thumbnail, ImageMagick
Acceleration = none, none
Operating system = Linux accord.host-care.com 2.6.18-308.1.1.el5 #1 SMP Wed Mar 7 04:16:51 EST 2012 x86_64
Default theme = matrixad
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0
Rows in GalleryAccessMap table = 127
Rows in GalleryAccessSubscriberMap table = 48816
Rows in GalleryUser table = 116
Rows in GalleryItem table = 48798
Rows in GalleryAlbumItem table = 397
Rows in GalleryCacheMap table = 0
Adding items
Memory used: 12752176, total: 32M
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage.class at line 641 (GalleryCoreApi::error)
in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry)
in modules/imageblock/classes/ImageBlockHelper.class at line 980 (GalleryCoreApi::getMapEntry)
in modules/imageblock/classes/ImageBlockHelper.class at line 830 (ImageBlockHelper::getDisabledFlag)
in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 59 (ImageBlockHelper::handleEvent)
in modules/core/classes/GalleryCoreApi.class at line 2238 (GalleryEventHelper_simple::postEvent)
in modules/core/classes/GalleryEntity.class at line 285 (GalleryCoreApi::postEvent)
in modules/core/classes/GalleryItem.class at line 414 (GalleryEntity::save)
in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 183 (GalleryItem::save)
in modules/core/classes/GalleryCoreApi.class at line 1668 (GalleryItemHelper_medium::addItemToAlbum)
in modules/itemadd/ItemAddFromWeb.inc at line 118 (GalleryCoreApi::addItemToAlbum)
in modules/core/ItemAdd.inc at line 159 (ItemAddFromWeb::handleRequest)
in ??? at line 0 (ItemAddController::handleRequestWithProgressBar)
in modules/core/classes/GalleryTemplateAdapter.class at line 1092
in g2data/smarty/templates_c/%%2922992769/matrixad/%%A5^A57^A578EA16%%theme.tpl.php at line 119 (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
Debug Output
file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/rewrite/classes/parsers/modrewrite/ModRewriteUrlGenerator.class) getParameter modrewrite.galleryLocation for rewrite plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/rewrite/0/0/0.inc) getParameter shortUrls for rewrite plugin getParameter session.lifetime for core plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/core/0/0/0.inc) getParameter session.inactivityTimeout for core plugin (mysqli): SET NAMES "utf8" (mysqli): SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1 (mysqli): SELECT g_userId, g_remoteIdentifier, g_creationTimestamp, g_modificationTimestamp, g_data FROM g2_SessionMap WHERE g_id='94285330c7ba51d8567c7d71dbc5ccb2' controller core.ItemAdd, view Loading plugin core Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/module.inc) core plugin successfully instantiated file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/versions.dat) file(/home/funkruti/public_html/wallpaperhungama.com/g2data/versions.dat, ) [1342849612] can't guarantee 5 -- extending! file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/ItemAdd.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/5/6/56336.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/itemadd/ItemAddFromWeb.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/ProgressBar.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok getParameter smarty.compile_check for core plugin getParameter id.anonymousUser for core plugin getParameter id.adminGroup for core plugin (mysqli): SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=6 AND g_groupId=3 LIMIT 1 getParameter default.theme for core plugin Loading plugin matrixad Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/themes/matrixad/theme.inc) matrixad plugin successfully instantiated Check the version of the matrixad plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrixad plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/theme/matrixad/0/0/0.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/theme/matrixad/5/6/56336.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/theme/_all/localUrlMap.txt) getParameter misc.markup for core plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/geturls/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/rating/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/search/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/imageblock/Preloads.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/imageblock/0/0/0.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/imageframe/classes/ImageFrameImpl.class) Loading plugin imageframe Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/imageframe/module.inc) imageframe plugin successfully instantiated Check the version of the imageframe plugin The version of the imageframe plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/icons/classes/IconsImpl.class) getParameter iconpack for icons plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/icons/0/0/0.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok (mysqli): SELECT g_parentSequence FROM g2_ItemAttributesMap WHERE g_itemId=56336 (mysqli): SELECT g2_Group.g_id, g2_Group.g_groupName FROM g2_UserGroupMap, g2_Group WHERE g2_Group.g_id = g2_UserGroupMap.g_groupId AND g2_UserGroupMap.g_userId = 6 ORDER BY g2_Group.g_groupName LIMIT 18446744073709551615 (mysqli): SELECT g2_AccessSubscriberMap.g_itemId, BIT_OR(g2_AccessMap.g_permission) FROM g2_AccessMap, g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId IN (7,54,25372) AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND g2_AccessMap.g_userOrGroupId IN (6,4,2,3) GROUP BY g2_AccessSubscriberMap.g_itemId [1342849613] can't guarantee 30 -- extending! (mysqli): SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g2_PermissionSetMap file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/0/0/7.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/0/5/54.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/2/5/25372.inc) (mysqli): SELECT g2_AccessSubscriberMap.g_itemId, BIT_OR(g2_AccessMap.g_permission) FROM g2_AccessMap, g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId IN (56336) AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND g2_AccessMap.g_userOrGroupId IN (6,4,2,3) GROUP BY g2_AccessSubscriberMap.g_itemId [1342849614] can't guarantee 30 -- extending! Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok getParameter id.adminGroup for core plugin getParameter id.anonymousUser for core plugin Loading plugin register Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/register/module.inc) register plugin successfully instantiated Check the version of the register plugin The version of the register plugin is ok getParameter id.anonymousUser for core plugin Loading plugin linksinthehead Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/linksinthehead/module.inc) linksinthehead plugin successfully instantiated Check the version of the linksinthehead plugin The version of the linksinthehead plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/linksinthehead/0/0/0.inc) getParameter default.theme for core plugin Loading plugin matrixad matrixad plugin successfully instantiated Check the version of the matrixad plugin The version of the matrixad plugin is ok file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/smarty/templates_c/%%2922992769/matrixad) is_dir(/home/funkruti/public_html/wallpaperhungama.com/g2data/smarty/templates_c/%%2922992769/matrixad) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/smarty/templates_c/%%2922992769/matrixad) is_writeable(/home/funkruti/public_html/wallpaperhungama.com/g2data/smarty/templates_c/%%2922992769/matrixad) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/smarty/templates_c/%%2922992769/matrixad/v_14) file_exists(/home/funkruti/public_html/wallpaperhungama.com/lib/yui/utilities.js) stat(/home/funkruti/public_html/wallpaperhungama.com/lib/yui/utilities.js) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/rating/rating.js) stat(/home/funkruti/public_html/wallpaperhungama.com/modules/rating/rating.js) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/search/SearchBlock.js) stat(/home/funkruti/public_html/wallpaperhungama.com/modules/search/SearchBlock.js) file_exists(/home/funkruti/public_html/wallpaperhungama.com/lib/yui/container-min.js) stat(/home/funkruti/public_html/wallpaperhungama.com/lib/yui/container-min.js) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/_all/0/0/CombinedJavascript_dcd441c002593cfc38bc1dd65b814bd0.inc) getParameter misc.markup for core plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/../../themes/matrixad/local/theme.css) Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok getParameter lock.system for core plugin fopen(/home/funkruti/public_html/wallpaperhungama.com/g2data/locks/56336, wb+, 0) flock(Resource id #101, 5, ) getParameter fromweb for itemadd plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/itemadd/0/0/0.inc) getParameter id.adminGroup for core plugin Loading plugin itemadd Class not defined, trying to include it. file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/itemadd/module.inc) itemadd plugin successfully instantiated Check the version of the itemadd plugin The version of the itemadd plugin is ok tempnam(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/, add) fsockopen(mass.in, 80, , , 5) fwrite(Resource id #105, ..., ) fflush(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) feof(Resource id #105) fgets(Resource id #105, 4096) fopen(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/addnwzMml, wb, 0) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fread(Resource id #105, 4096) fwrite(Resource id #106, ..., ) feof(Resource id #105) fclose(Resource id #106) fclose(Resource id #105) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/_all/0/0/GalleryMimeTypeHelper_mimeData.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/core/classes/GalleryPhotoItem.class) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/addnwzMml) is_uploaded_file(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/addnwzMml) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/addnwzMml) (mysqli): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_FileSystemEntity WHERE g2_ChildEntity.g_parentId = 56336 AND UPPER(g2_FileSystemEntity.g_pathComponent) = 'VIMALARAMAN-SAREE-STILLS-4.JPG' AND g2_ChildEntity.g_id = g2_FileSystemEntity.g_id (mysqli): SET NAMES "utf8" (mysqli): update g2_SequenceId set id=LAST_INSERT_ID(id+1); (mysqli): SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId AND g2_Schema.g_type = 'entity' AND g2_PluginMap.g_active = 1 copy(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/addnwzMml, /home/funkruti/public_html/wallpaperhungama.com/g2data/albums/Celebrities/Tollywood/Vimala Raman/vimalaraman-saree-stills-4.jpg) getParameter permissions.file for core plugin getParameter permissions.directory for core plugin filesize(/home/funkruti/public_html/wallpaperhungama.com/g2data/albums/Celebrities/Tollywood/Vimala Raman/vimalaraman-saree-stills-4.jpg) filesize(/home/funkruti/public_html/wallpaperhungama.com/g2data/albums/Celebrities/Tollywood/Vimala Raman/vimalaraman-saree-stills-4.jpg) file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/entity/4/0/401814-fast.inc) (mysqli): SELECT g2_TkPropertyMimeTypeMap.g_toolkitId FROM g2_TkPropertyMap, g2_TkPropertyMimeTypeMap WHERE g2_TkPropertyMap.g_name = g2_TkPropertyMimeTypeMap.g_propertyName AND g2_TkPropertyMimeTypeMap.g_mimeType = 'image/jpeg' AND g2_TkPropertyMap.g_name = 'colorspace' file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/imagemagick/classes/ImageMagickToolkit.class) getParameter path for imagemagick plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/imagemagick/0/0/0.inc) getParameter binary for imagemagick plugin getParameter exec.beNice for core plugin Executing: ( "/usr/local/bin/identify" "-format" "%r" "/home/funkruti/public_html/wallpaperhungama.com/g2data/albums/Celebrities/Tollywood/Vimala Raman/vimalaraman-saree-stills-4.jpg" ) 2>"/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/g2dbgPpvlW9" getParameter exec.expectedStatus for core plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/g2dbgPpvlW9) filesize(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/g2dbgPpvlW9) unlink(/home/funkruti/public_html/wallpaperhungama.com/g2data/tmp/g2dbgPpvlW9) Regular Output: DirectClass sRGB Error Output: Status: 0 (expected 0) (mysqli): SELECT g2_TkPropertyMimeTypeMap.g_toolkitId FROM g2_TkPropertyMap, g2_TkPropertyMimeTypeMap WHERE g2_TkPropertyMap.g_name = g2_TkPropertyMimeTypeMap.g_propertyName AND g2_TkPropertyMimeTypeMap.g_mimeType = 'image/jpeg' AND g2_TkPropertyMap.g_name = 'dimensions' file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/gd/classes/GdToolkit.class) getimagesize(/home/funkruti/public_html/wallpaperhungama.com/g2data/albums/Celebrities/Tollywood/Vimala Raman/vimalaraman-saree-stills-4.jpg) (mysqli): SELECT g2_TkPropertyMimeTypeMap.g_toolkitId FROM g2_TkPropertyMap, g2_TkPropertyMimeTypeMap WHERE g2_TkPropertyMap.g_name = g2_TkPropertyMimeTypeMap.g_propertyName AND g2_TkPropertyMimeTypeMap.g_mimeType = 'image/jpeg' AND g2_TkPropertyMap.g_name = 'originationTimestamp' (mysqli): SELECT g_accessListId FROM g2_AccessSubscriberMap WHERE g_itemId=56336 LIMIT 1 (mysqli): BEGIN (mysqli): INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (401814,203385) (mysqli): DELETE FROM g2_CacheMap WHERE g_itemId IN (401814,56336) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/permalinks/module.inc) getParameter autoPermalink for permalinks plugin file_exists(/home/funkruti/public_html/wallpaperhungama.com/g2data/cache/module/permalinks/0/0/0.inc) file_exists(/home/funkruti/public_html/wallpaperhungama.com/modules/imageblock/classes/ImageBlockHelper.class) mysqli error: [1286: Unknown table engine 'InnoDB'] in EXECUTE("SELECT g_itemId FROM g2_ImageBlockDisabledMap WHERE g_itemId=56336") (mysqli): SELECT g_itemId FROM g2_ImageBlockDisabledMap WHERE g_itemId=56336 Query: SELECT g_itemId FROM g2_ImageBlockDisabledMap WHERE g_itemId=56336 failed. Unknown table engine 'InnoDB'
1286: Unknown table engine 'InnoDB'
http://www.wallpaperhungama.com
http://www.funkruti.com/
http://www.24rocking.com/
Posts: 20
[Solved] deactivated imageblock
Posts: 8339
The ImageblockCacheMap table can grow very large. Yours may have crashed and was in need of repair.
Since you've deactivated the plugin, check the table via phpMyAdmin or similar tool and see if that table(or any table) is marked as crashed and needs repair.
-s
Posts: 20
Hi suprsidr thanks for prompt reply and yes some tables seems to be crashed
here is the output of mysqlcheck -r output
please help me out....
g2_ImageBlockCacheMap
note : Table does not support optimize, doing recreate + analyze instead
status : OK
g2_ImageBlockDisabledMap
note : Table does not support optimize, doing recreate + analyze instead
status : OK
g2_SimpleviewerParameterMap
note : Table does not support optimize, doing recreate + analyze instead
status : OK
g2_TagItemMap
note : Table does not support optimize, doing recreate + analyze instead
status : OK
g2_TagMap
note : Table does not support optimize, doing recreate + analyze instead
status : OK