[Solved] Fatal Error in Gdn_Database.Query : Got error 28 from storage engine*

KCRift

I have seen several references to this on the web, and I have a ticket into my host...but I wanted to see if there was any insight here. The only reason I am questioning it being my host is because I added in some plugins this week. The problems did NOT start right away, I added a few things on Monday and it started going wonky on Thursday.

Thanks!

****START MY ERROR MESSAGE******

Fatal Error in Gdn_Database.Query();

Got error 28 from storage engine
show columns from `GDN_User`
The error occurred on or near: /home2/koboldco/public_html/library/database/class.database.php
283:          $PDOStatement = $this->Connection()->query($Sql);
284:       }
285: 
286:       if ($PDOStatement === FALSE) {
287:          trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
288:       }
289:       
290:       // Did this query modify data in any way?
291:       if ($ReturnType == 'ID') {
Backtrace:
/home2/koboldco/public_html/library/database/class.database.phpPHP::Gdn_ErrorHandler();
[/home2/koboldco/public_html/library/database/class.database.php:287] PHP::trigger_error();
[/home2/koboldco/public_html/library/database/class.sqldriver.php:1650] Gdn_Database->Query();
[/home2/koboldco/public_html/library/database/class.mysqldriver.php:139] Gdn_SQLDriver->Query();
[/home2/koboldco/public_html/library/core/class.schema.php:66] Gdn_MySQLDriver->FetchTableSchema();
[/home2/koboldco/public_html/library/core/class.schema.php:41] Gdn_Schema->Fetch();
[/home2/koboldco/public_html/library/core/class.model.php:171] Gdn_Schema->__construct();
[/home2/koboldco/public_html/applications/dashboard/models/class.usermodel.php:775] Gdn_Model->DefineSchema();
[/home2/koboldco/public_html/library/core/class.session.php:307] UserModel->Save();
[/home2/koboldco/public_html/library/core/class.auth.php:36] Gdn_Session->Start();
[/home2/koboldco/public_html/bootstrap.php:168] Gdn_Auth->StartAuthenticator();
[/home2/koboldco/public_html/index.php:41] PHP::require_once();
Variables in local scope:
[Sql] 'show columns from `GDN_User`'
[InputParameters] array (
)
[Options] array (
  'ReturnType' => 'DataSet',
)
[ReturnType] 'DataSet'
[PDOStatement] false

vrijvlinder

Mysql error "28 from storage engine" - means "not enough disk space".

KCRift

Thanks for the response - That's what I had found up to this point as well. Anything else it COULD be?

I heard back from the host and they are "looking into it"

vrijvlinder

Check your disk space usage.You could delete temp files. But it could also be that the memory allocation setting for that data base is wrong, if the issue is not actual missing memory space.

Here are some resources to get familiar with and troubleshoot some may not apply to your system but you can see what it's all about and what to look for in your own. Your host will likely help you resolve this but it does not hurt to learn about it:

http://www.laurencegellert.com/2011/07/mysql-maintenance-tasks-for-innodb-with-mysql-5-1/

http://www.laurencegellert.com/2011/07/memory-based-simultaneous-user-limit/

mikado

I had the same problem. Problem was solved by removing the old database and creating a new

KCRift

Thank you very much for all of the responses! It did in fact end up being a full hard drive somewhere (associated with the /tmp) - it was fixed by the host. Some other website on the shared host had a runaway app that was filling up the disk.