search

thegooddata / social

GNU General Public License v2.0
0 stars 0 forks source link

Database Error on Preproduction server #46

Open josereyero opened 9 years ago

josereyero commented 9 years ago

Getting this databse back-end error when visiting any page, apparently meaning there's no space left on device.

PDOException: SQLSTATE[HY000]: General error: 
                                  1030 Got error 28 from storage engine: SELECT 
                                  td.*, tn.nid AS node_nid, tv.name AS          
                                  vocabulary, tv.machine_name AS                
                                  vocabulary_machine_name                       
                                  FROM .....

Note the line "Got error 28 from storage engine"

Reference http://www.cyberciti.biz/faq/mysql-error-28-and-solution/

atrandafir commented 9 years ago

Looking into it. Some time ago we've setup a fake data generator on preproduction and it has filled up the database. I'll try to remove old records and see if we can free some space.

atrandafir commented 9 years ago

@josereyero I've connected to the database and trucated two big tables from the webapp. As far as I understand now it should free the space, the database is working now.

josereyero commented 9 years ago

Thanks, I can confirm it's working.

josereyero commented 9 years ago

Getting the same error on Production Server, please take a look.