21307 Posts in 5737 Topics by 2603 members
General Questions
SilverStripe Forums » General Questions » Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 467 Views |
-
Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
30 April 2012 at 10:51am
Hi,
On a client's SS site, we're intermittently getting the following error:
Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
At line 525 in /home/clientsite/public_html/sapphire/core/model/MySQLDatabase.phpuser_error(Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine,256) line 525 of MySQLDatabase.php MySQLDatabase->databaseError(Couldn't run query: SHOW FULL FIELDS IN "Member" | Got error 28 from storage engine,256) line 123 of MySQLDatabase.php MySQLDatabase->query(SHOW FULL FIELDS IN "Member",256) line 129 of DB.php DB::query(SHOW FULL FIELDS IN "Member") line 332 of MySQLDatabase.php MySQLDatabase->fieldList(Member) line 320 of DB.php DB::fieldList(Member) line 871 of Security.php Security::database_is_ready() line 81 of Controller.php Controller->init() line 136 of Controller.php Controller->handleRequest(SS_HTTPRequest) line 282 of Director.php Director::handleRequest(SS_HTTPRequest,Session) line 125 of Director.php Director::direct(/Security/ping) line 127 of main.php
Any ideas? What is "Error 28"?
I've already done a /dev/build?flush=all, and unfortunately can't debug as it is only happening of the production server.
Thank you very much.
VWD -
Re: Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
4 May 2012 at 1:37am
I think "error 28" relates to disk space - could be wrong but I remember it from a recent migration check the size and contents of your tmp/cache folder.
How many members do you have on the site? alot?
-
Re: Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
5 May 2012 at 7:14am
G'day Barry,
Thanks for your suggestion. The site does a good bit of headroom, at least 450MB of storage, left. Also there are only a couple of users.
It's an odd one - haven't had it repeat for nearly a week despite the same usage of the site.
Will wait and see and dig into the code RE: error 28.
Thank you for your help.
VWD.
| 467 Views | ||
|
Page:
1
|
Go to Top |
