Zen Cart Logo
Forums / General Questions / Fatal error 1030: Got error -1 from storage engine. GoDaddy server

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

Views: 1,679

Results 1 to 14 of 14
12 Jul 2016, 8:04 PM
#1
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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

12 Jul 2016, 9:08 PM
#2
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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

12 Jul 2016, 9:17 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

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

mespe:

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.

20 Jul 2016, 8:43 PM
#4
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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)

20 Jul 2016, 8:46 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

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

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.

20 Jul 2016, 11:02 PM
#6
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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

20 Jul 2016, 11:04 PM
#7
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

20-Jul-2016 08:27:02 America/Phoenix] Request URI: /store/index.php?main_page=index&cPath=27&sort=20a&page=2&zenid=34a1bbbc7240e22e41b0a2e419e4023b, 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

20 Jul 2016, 11:05 PM
#8
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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

21 Jul 2016, 3:37 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

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

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.

21 Jul 2016, 8:00 PM
#10
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

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

21 Jul 2016, 8:08 PM
#11
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,777
Plugin Contributions:
11

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

Shouldn't have any problem with ten times that. Time to make it GoneDaddy.

Their site says 200M is the max

22 Jul 2016, 4:11 AM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

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

mespe:

well back to godaddy support,,, is a 4.6Meg DB large? too large for 2400 parts and 300 customers?
No, that's small.
But maybe you've filled your server with thousands of product images and product spec PDFs and other files, that are all causing you to use up all the allotted disk space they give you. If your hosting control panel can't tell you how much space you've used and how much is still allowed, then call them and ask.

23 Aug 2016, 2:14 AM
#13
mespe avatar

mespe

Zen Follower

Join Date:
Sep 2014
Location:
ohio
Posts:
216
Plugin Contributions:
0

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

I'm using 4 gig of 150 gig disk space
Still getting errors ugg

23 Aug 2016, 6:16 PM
#14
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

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

The two errors you've quoted are indicative of file-system problems on your server. These are not Zen Cart issues; they're issues with MySQL and the server filesystem.
You'll need to work with the server's tech support staff to resolve it.
If they're uncooperative or you find the server unreliable (which it appears to be IMO) then perhaps you might need to find another host who cares that the server runs properly. (every time I say that everyone asks my opinion on a good host, so I'll tell you now to click the "Services" link at the top of this page for some ideas to consider, but do your own research before choosing one)