Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
[Solved] Fatal Error in Gdn_Database.Query : Got error 28 from storage engine*
KCRift
New
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
0
Comments
Mysql error "28 from storage engine" - means "not enough disk space".
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
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"
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/
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
I had the same problem. Problem was solved by removing the old database and creating a new
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.