After upgrading to 2.0, I began to see intermittent "error -1 from storage engine..." and (less often) "error 28 from storage engine" ... always related to lines 617 or 602 in taxonomy.module.

In my efforts to make the error repeatable, tried a Rebuild Permissions. This generated the errors below (with only minor variations if any) every time I ran it. Even disabling Taxon Mgr did not stop them. However, uninstalling it did.

 * user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10915 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10916 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10917 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10918 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10919 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10920 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 10921 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.

These are the same error codes and taxonomy.module lines that appeared in the random errors I've been getting also, but there has been more variety in the "random" ones. Samples below...

 * user warning: Got error -1 from storage engine query: SELECT t.tid, t.* FROM term_data t INNER JOIN term_node r ON r.tid = t.tid WHERE t.vid = 1 AND r.vid = 11785 ORDER BY weight in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 602.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 11760 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.
    * user warning: Got error -1 from storage engine query: SELECT t.tid, t.* FROM term_data t INNER JOIN term_node r ON r.tid = t.tid WHERE t.vid = 1 AND r.vid = 11760 ORDER BY weight in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 602.
    * user warning: Got error -1 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 11759 ORDER BY v.weight, t.weight, t.name in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 617.

And also, less often...
user warning: Incorrect key file for table '/var/lib/mysql/tmp/#sql_58e_1.MYI'; try to repair it query: SELECT DISTINCT(t.tid), t.* FROM term_data t INNER JOIN term_node r ON r.tid = t.tid LEFT JOIN forum_access fa ON t.tid = fa.tid LEFT JOIN acl acl_fa ON acl_fa.name = t.tid AND acl_fa.module = 'forum_access' LEFT JOIN acl_user aclu_fa ON aclu_fa.acl_id = acl_fa.acl_id AND aclu_fa.uid = 124 WHERE ((fa.grant_view >= 1 AND fa.rid IN (2, 4, 7, 8, 11, 16, 19)) OR fa.tid IS NULL OR aclu_fa.uid = 124) AND ( t.vid = 1 AND r.vid = 11931 )ORDER BY weight in /home/folder/public_html/modules/taxonomy/taxonomy.module on line 602.

I don't know yet if the "random" ones have cleared up. But if there are none in the logs in next 24 hrs or so, that would be clear indication they are gone and it would seem that uninstalling TM cured them.

Comments

mh86’s picture

mh86 commented
Status: Active » Postponed (maintainer needs more info)

The queries are definitely correct - I even tried them on my MySQL database.
For me it seems like your database is having some problems, never seen an error "-1" before
Let me know, if you can find out more about this issue, but I can't fix the problem in the Taxonomy Manager, because I don't see any connection to this problem and the queries are okay.

aharown07’s picture

aharown07 commented

Thanks. That helps. I didn't really know how to test the queries.
If the "database is having some problems" ... what might one do about that? My knowledge of mysql is barely even rudimentary.

mh86’s picture

mh86 commented

Well, you can search about this problem, if someone else had similar errors. Or just try a fresh drupal installation (maybe on a different server) and check if the same problems remains

aharown07’s picture

aharown07 commented

Thanks, but did alot of searching already. Can't seem to find anybody who even knows what an "error -1" is.
Have too much dev time in this to start over and the errors are intermittent so... without a few dozen users to test, it would take a week to find out if I'd fixed it or not.

During somewhat busy times, I see the errors (usually in sets of three or four) about once an hour. So if I can find fixes to try on the live site, knowing whether it worked or not would only take a few hours.

Edit: I shd clarify that I'm talking here about the random errors. With TM installed I could--last I knew--reproduce some of the errors by running Rebuild Permissions. Have an issue open at ACL also, but so far no clues there either.

aharown07’s picture

aharown07 commented

Fixed now I think. Handling it over here...
http://drupal.org/node/568894#comment-2022176

aharown07’s picture

aharown07 commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)