Fatal error 1030: Got error -1 from storage engine. GoDaddy server

[mespe]

here are a couple of them,,, how to I troubleshoot these?


[11-Jul-2016 08:47:36 America/Phoenix] Request URI: /store/index.php?main_page=index&cPath=45_46, IP address: 66.249.79.182
#1 trigger_error() called at [.../includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [.../includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [.../includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [.../includes/templates/responsive_classic/templates/tpl_index_product_list.php:47]
#5 require(.../includes/templates/responsive_classic/templates/tpl_index_product_list.php) called at [.../includes/modules/pages/index/main_template_vars.php:236]
#6 require(.../includes/modules/pages/index/main_template_vars.php) called at [.../includes/templates/responsive_classic/common/tpl_main_page.php:171]
#7 require(.../includes/templates/responsive_classic/common/tpl_main_page.php) called at [.../index.php:97]

[11-Jul-2016 08:47:36 America/Phoenix] PHP Fatal error: 1030:Got error -1 from storage engine :: select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '46' order by p.products_sort_order, pd.products_name ==> (as called by) .../includes/templates/responsive_classic/templates/tpl_index_product_list.php on line 47 <== in .../includes/classes/db/mysql/query_factory.php on line 167



[11-Jul-2016 22:27:26 America/Phoenix] PHP Fatal error: 1030:Got error -1 from storage engine :: select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '17' order by p.products_sort_order, pd.products_name ==> (as called by) .../includes/templates/responsive_classic/templates/tpl_index_product_list.php on line 47 <== in .../includes/classes/db/mysql/query_factory.php on line 167

[mespe]

here's another when my admin caUSED a "warning,,, refresh page"

[12-Jul-2016 14:00:17 America/Phoenix] Request URI: .../admin/configuration.php?gID=33&zenAdminID=sumnumber, IP address: 127.0.0.1.176
#1 trigger_error() called at [/.../includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/.../includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/.../includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/.../admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php:79]
#5 zcObserverLogWriterDatabase->checkLogSchema() called at [/.../admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php:18]
#6 zcObserverLogWriterDatabase->__construct() called at [/.../includes/autoload_func.php:79]
#7 require(/.../includes/autoload_func.php) called at [/.../admin/includes/application_top.php:171]
#8 require(/.../admin/includes/application_top.php) called at [/.../admin/configuration.php:10]

[12-Jul-2016 14:00:17 America/Phoenix] PHP Fatal error: 126:Incorrect key file for table '/tmp/mysqltmp/#sql_11b0_0.MYI'; try to repair it :: show fields from zen_admin_activity_log ==> (as called by) /.../admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php on line 79 <== in /.../includes/classes/db/mysql/query_factory.php on line 167

[DrByte]

PHP Fatal error: 126:Incorrect key file for table '/tmp/mysqltmp/#sql_11b0_0.MYI'; try to repair it :: show fields from zen_admin_activity_log ...

Your MySQL database has damaged tables, and is having difficulty creating temporary tables (ie: the /tmp/mysqltmp/ directory). This is sometimes because your hosting account is out of disk space. Sometimes it's a server-side permissions issue which your hosting company will need to resolve.

[mespe]

So I contacted Godaddy, and the support rep said that he would repair the damaged db. But I'm still getting those random America/Phoenix] PHP Fatal error: 1030:Got error -1 from storage engine :: about 10 times today alone (according to the log)

[DrByte]

Are they all occurring with the same SQL statement, or at the same place in PHP code execution. Any patterns to the files involved (other than query_factory since it's the thing that always sends the actual query)?

You may need to get GoDaddy to fix whatever is causing their databases to get damaged all the time.

[mespe]

1 trigger_error() called at [/.../includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/.../includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/.../includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/.../includes/modules/responsive_classic/product_listing.php:75]
#5 include(/.../includes/modules/responsive_classic/product_listing.php) called at [/.../includes/templates/responsive_classic/templates/tpl_modules_product_listing.php:11]
#6 require(/.../includes/templates/responsive_classic/templates/tpl_modules_product_listing.php) called at [/.../includes/templates/responsive_classic/templates/tpl_index_product_list.php:109]
#7 require(/.../includes/templates/responsive_classic/templates/tpl_index_product_list.php) called at [/.../includes/modules/pages/index/main_template_vars.php:236]
#8 require(/.../includes/modules/pages/index/main_template_vars.php) called at [/.../includes/templates/responsive_classic/common/tpl_main_page.php:171]
#9 require(/.../includes/templates/responsive_classic/common/tpl_main_page.php) called at [/.../index.php:97]

[20-Jul-2016 08:22:08 America/Phoenix] PHP Fatal error: 1030:Got error -1 from storage engine :: select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '26' order by p.products_sort_order, pd.products_name limit 40, 20 ==> (as called by) /.../includes/modules/responsive_classic/product_listing.php on line 75 <== in /.../includes/classes/db/mysql/query_factory.php on line 167

[mespe]

20-Jul-2016 08:27:02 America/Phoenix] Request URI: /store/index.php?main_page=index&cPath=27&sort=20a&page=2&zenid=34a1bbbc7240e22e41b0a2e 419e4023b, IP address: 78.57.244.200
#1 trigger_error() called at [.../includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [.../includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [.../includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [.../includes/templates/responsive_classic/templates/tpl_index_product_list.php:47]
#5 require(.../includes/templates/responsive_classic/templates/tpl_index_product_list.php) called at [.../includes/modules/pages/index/main_template_vars.php:236]
#6 require(.../includes/modules/pages/index/main_template_vars.php) called at [.../includes/templates/responsive_classic/common/tpl_main_page.php:171]
#7 require(.../includes/templates/responsive_classic/common/tpl_main_page.php) called at [.../index.php:97]

[20-Jul-2016 08:27:02 America/Phoenix] PHP Fatal error: 1030:Got error -1 from storage engine :: select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '27' order by p.products_sort_order, pd.products_name ==> (as called by) .../includes/templates/responsive_classic/templates/tpl_index_product_list.php on line 47 <== in .../includes/classes/db/mysql/query_factory.php on line 167

[mespe]

No not always the same, ,,, i also get the error on the backend,,, but a dif error number,,,
[20-Jul-2016 13:23:09 America/Phoenix] Request URI: /store/admin/login.php?camefrom=index.php&zenAdminID=wdfdwfwwffdfdfdfdfdfdfdfdfd, IP address: 111.216.52.176
#1 trigger_error() called at [.../includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [.../includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [.../includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [.../admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php:79]
#5 zcObserverLogWriterDatabase->checkLogSchema() called at [...admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php:18]
#6 zcObserverLogWriterDatabase->__construct() called at [.../includes/autoload_func.php:79]
#7 require(.../includes/autoload_func.php) called at [.../admin/includes/application_top.php:171]
#8 require(.../admin/includes/application_top.php) called at [.../admin/login.php:9]

[20-Jul-2016 13:23:09 America/Phoenix] PHP Fatal error: 126:Incorrect key file for table '/tmp/mysqltmp/#sql_11b0_0.MYI'; try to repair it :: show fields from zen_admin_activity_log ==> (as called by) ...admin/includes/classes/class.admin.zcObserverLogWriterDatabase.php on line 79 <== in .../includes/classes/db/mysql/query_factory.php on line 167

[DrByte]

Ya, those are all indicating database instability.
This could be a result of having run out of disk space / disk quota on your hosting account (and therefore the database is unable to store data properly, resulting in damaged and lost data).
Or it could be a result of the servers having some serious stability problems.

[mespe]

well back to godaddy support,,, is a 4.6Meg DB large? too large for 2400 parts and 300 customers?