Jump to content

Recommended Posts

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

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...