Stevie Mysql Issues

[uedit]

Hello

 

SERVER - Stevie

Cpanel - uedit

 

I was uploading some MYSQL tables but after the first table(which was succesfully uploaded), I cannot upload the rest of the table and I am getting the #2002 error. When I run the 'SHOW TABLES' command, it shows the names of all the tables that were meant to be uploaded but I cannot see these tables on phpmyadmin nor I can access then through command line. It says import.php missing. These error starting popping like 10 minutes before. Please, can you help me out, how can I fix these errors?

 

Thanks and Regards

Mark Johnson

[UVray]

I take it this is still an ongoing problem? I can select from my tables, but can't modify them. I get the following error

 

#1030 - Got error -1 from storage engine

[wolstech]

Mysql has been broken on Stevie since the server crashed on Monday. Error 2002 (can't connect to database) and error 1036 (got -1 from storage engine) are the two common errors everybody is seeing. All tables using InnoDB are read-only.

 

See http://www.helionet.org/index/topic/18427-stevie-mysql-issues/

[wolstech]

It is, and as far as I know, there's no estimated time as to when it'll be fixed. The most I know is that the repair work is quite time-consuming, so I'd expect it to take a few days at least.

 

In the mean time, tables using the MyISAM engine work fine assuming the DB server is up (there's been a lot of #2002 "Can't connect" errors too). MyISAM also tolerates abuse from issues like crashes much better than InnoDB.

 

http://www.helionet.org/index/topic/18447-mysql-issues/

[ccwu]

Hello,

 

When I visit my own site today, it shows either "Error displaying the error page: Application Instantiation Error" or SQL=INSERT INTO `kifzg_session` (`session_id`, `client_id`, `time`) VALUES ('f59aaea0ce0eef2ece3d900e9cf57b70', 0, '1393154172').

 

I didn't change anything or any setting before the error. So I have no idea what happen. What should I do to solve this problem? Or, someone can help me?

 

My account is: ccwu.

My site link is http://ccwu.heliohost.org/

 

Thank you!

[luckymuse]

Well the site I'm working on is down again, here's the error:

 

Got error -1 from storage engine SQL=INSERT INTO `ynfc4_session` (`session_id`, `client_id`, `time`) VALUES ('74e381503582c63a885dc3a3bd00e4cf', 0, '1393183137')

 

Was an innoDB error after stevie crashed, then it changed to this kind of error, then it was working fine for a day or so now it's back to this.

http://captainbludde.heliohost.org

[khoirulamsori]

I'm having trouble during the installation of the software in Softaculous. Every time I click on the install button always appears:

 

"The following errors were found:

Could not make the query numbered: 6

MySQL Error No: 2013

MySQL Error: Lost connection to MySQL server during query".

 

I only have 1 database. In cpanel there is only showing one database, but in the phpmyadmin showing 4 database (including my database). The third database is the property of the software I installed, but found the problem.

[mbs]

Username: mbs

Server: stevie

domain: mybollywoodstore.com

 

Tried installing magento through softacullous but keep getting Mysql error: 2013. Seems to be the problem everyone is talking about since the crash, but its been days please fix it. I also have problems with the webmails - since days for roundcube and today even for Horde. I asked a friend and he to seems to be having the same problems.

 

Friend's Username: f3info

Server: stevie

domain: f3infotechsolutions.com

[wolstech]

Are you on Stevie? If so, the issue is likely to do with the ongoing mysql issues on that server, and most you can do is wait. If not, it's possible that the issue is due to load or other reasons.

[stellon]

Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[meon]

Dear sir,

I've been trying to install drupal via softaculous for last 3 days.. However it fails every time giving me a nasty mysql error.

 

Error details:

The following errors were found :

• Could not make the query numbered : 6
  MySQL Error No : 2013
  MySQL Error : Lost connection to MySQL server during query
  

I am aware that other people are also having trouble with mysql post stevie crash. However i want to ask when these issues will get solved.Attaching the screenshot. Hope it helps.

[Robdog75]

Good news for me is I've stopped receiving the error logs via email nearly every hour. Still getting database backups though. I tried to edit my database this morning, but no dice! keep getting #2013 error connection to server lost. I take it the server is still down?

[wolstech]

Dear sir, I've been trying to install drupal via softaculous for last 3 days.. However it fails every time giving me a nasty mysql error. Error details: The following errors were found :

• Could not make the query numbered : 6 MySQL Error No : 2013 MySQL Error : Lost connection to MySQL server during query

Everybody is getting that, among other errors. I get it when I try dropping or creating tables.

 

The errors I know of that are related to the crash are:

• #2002: Cannot connect to server (server just went down)
  
• #2013: Lost connection during query (usually happens when you CREATE TABLE or DROP TABLE, but also during other queries)
  
• #1030: Got -1 from storage engine (happens with any INSERT/UPDATE/DELETE to an InnoDB table, and probably on ALTER as well)
  

 

I am aware that other people are also having trouble with mysql post stevie crash. However i want to ask when these issues will get solved.

There hasn't been any update on the progress of repairs as far as I know. When there are updates they'll likely be posted in one of these two topics:

 

http://www.helionet.org/index/topic/18447-mysql-issues/

 

http://www.helionet.org/index/topic/18427-stevie-mysql-issues/

[jeret]

Hi I have a web on Stevie server, and I have wordpress installed. I am having frequent database connection error. Even now as I type this problem even when I am not updating the site I have the error.

 

 

Thanks.

[jeret]

Hi i am having frequent database connection error on stevie server. I have wordpress installed. It happens when i am working on my site and also sometimes when i just browse the site.

 

Thanks.