Strange exception on a select statement.. nowhere on web

Databases
1

I can’t seem to find this anywhere online… wondering if anyone here has any insight into it?

SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine’

Query looks like:

‘SELECT
v.description as desc,
m.name as mfg,
p.mfgpartno as part,
p.productid as ProdID
FROM
broker_parts.etilize_prods_short as cps
LEFT JOIN
TechSpecs.product p ON p.productid = cps.productid
LEFT JOIN
TechSpecs.manufacturer m ON p.manufacturerid = m.manufacturerid
LEFT JOIN
TechSpecs.view_productdescriptions_full v ON cps.productid = v.productid
WHERE
cps.partkey=\‘343056b21\’ GROUP by p.productid’,

and much much more, but it is all just input data like the customers name / email and all that…

[B]Must be coming from the creation of a temp table?!

Anyone know? Plenty of free space and memory on the machine…[/B]

2

OK, well based on this post (found by adding myISAM to my original search), looks like rebuilding the table (by altering it) will sometimes help…

3

Wow that was fast! The only thing is though, this looks like it is an InnoDB issue and all these tables are MyISAM?

Also, thanks for your reply! But I just confirmed and it’s definitely looking like MyISAM…

Tim

4

Searching for “Got error -1 from storage engine” returned this result #1 which points to [URL=“http://forums.devshed.com/showthread.php?p=1259160#post1259160”]this.