mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > No Prime Left Behind

Reply
 
Thread Tools
Old 2020-01-11, 14:10   #551
unconnected
 
unconnected's Avatar
 
May 2009
Russia, Moscow

3×19×43 Posts
Default

Gary, if you've successfully started mysql server, run mysql client and execute 'drop database prpnet1470' query in it.
unconnected is online now   Reply With Quote
Old 2020-01-11, 14:11   #552
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

B2016 Posts
Default

I'm going to rename this thread Gary's Great Adventure - All I ever wanted to know about MYSQL but were to afraid to ask
MyDogBuster is offline   Reply With Quote
Old 2020-01-11, 20:06   #553
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

236778 Posts
Default

Haha. Good one Ian. I will move the applicable posts over to the "Server outrages" thread after the issue is completely resolved.


...trying the recent suggestions shortly.
gd_barnes is offline   Reply With Quote
Old 2020-01-11, 20:57   #554
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

1017510 Posts
Default

I seem to be in a vicious loop here.

As previously specified I added the command:
innodb_force_recovery = 5
to the var/mysql/my.cnf file

I rebooted the machine and checked the MySQL status using:
sudo service mysql status

It looked good.

After logging into MySQL I tried to drop prpnet1470 with:
drop database prpnet1470;

I got the following error:
ERROR 2013 (HY000): Lost connection to MySQL server during query

So...MySQL isn't starting properly due to this error and I am unable to drop the offending DB due to this error.

Any suggestions?

I will try increasing the force_recovery even higher to see if that does anything.

Last fiddled with by gd_barnes on 2020-01-11 at 20:58
gd_barnes is offline   Reply With Quote
Old 2020-01-11, 21:03   #555
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

236778 Posts
Default

So here is my latest attempt to start MySQL after changing my.cnf to:
innodb_force_recovery = 6

gary@jeepford:~$ sudo service mysql stop
* Stopping MySQL database server mysqld [ OK ]
gary@jeepford:~$ sudo service mysql start
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So...MySQL seems to start OK but is still giving this error message.

I'm stuck.
gd_barnes is offline   Reply With Quote
Old 2020-01-11, 21:07   #556
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

2,423 Posts
Default

modify /etc/my.cnf with the following settings:



net_read_timeout=600
net_write_timeout=180
wait_timeout=86400
interactive_timeout=86400
max_allowed_packet=128M



Maybe the timeout is too short

Last fiddled with by rebirther on 2020-01-11 at 21:07
rebirther is offline   Reply With Quote
Old 2020-01-11, 21:17   #557
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

52×11×37 Posts
Default

I picked another random database to drop that is no longer used: prpnet1466

The database dropped just fine.

Trying Reb's suggestion next...
gd_barnes is offline   Reply With Quote
Old 2020-01-11, 21:39   #558
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

236778 Posts
Default

Adding the parameters in Reb's recent suggestion made no difference when attempting to drop database prpnet1470.

Maybe I could just manually give myself access to all of the root and mysql files where prpnet1470 is located and delete them all. Just a crazy thought.
gd_barnes is offline   Reply With Quote
Old 2020-01-11, 21:51   #559
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

45678 Posts
Default

Quote:
Originally Posted by gd_barnes View Post
Adding the parameters in Reb's recent suggestion made no difference when attempting to drop database prpnet1470.

Maybe I could just manually give myself access to all of the root and mysql files where prpnet1470 is located and delete them all. Just a crazy thought.

How big is this database? If its bigger than max_allowed_packet=128M increase the value
rebirther is offline   Reply With Quote
Old 2020-01-12, 00:10   #560
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

52×11×37 Posts
Default

Quote:
Originally Posted by rebirther View Post
How big is this database? If its bigger than max_allowed_packet=128M increase the value
That's not the problem. I dumped one huge database that was 4.2 GB and it dumped fine.

Problem database prpnet1470 is about 200 MB so I increased the packet size to 256M, rebooted the machine, got MySQL up and running and tried to dump it. No difference.

Error:
Error 2013: Lost connection to MySQL server during query when dumping table `CandidateTestResult` at row: 251210

This error occurs after dumping 131.6 MB of the file.

Last fiddled with by gd_barnes on 2020-01-12 at 00:23
gd_barnes is offline   Reply With Quote
Old 2020-01-12, 00:14   #561
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

52·11·37 Posts
Default

A little more info:

I am able to do selects on all of the databases with the exception of the CandidateTestResult table on database prpnet1470. I can do selects on other tables in that one.

So no data will be lost except a small amount on prpnet1470.

But I cannot do any deletes on any table. My suspicion is that no table can be updated in any way...insert, update, or delete. That is why all of the prpnet servers start up just fine but when they try to receive a completed test an SQL error happens.

This begs the question: Why does one corrupt database affect MySQL in total such that other databases cannot be updated?

Last fiddled with by gd_barnes on 2020-01-12 at 00:15
gd_barnes is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
What exactly is sent to the server? paul0 NFS@Home 2 2015-03-12 23:00
Server bug -- new? Christenson Information & Answers 5 2011-07-12 21:44
Server Down? Grant Information & Answers 13 2008-11-24 19:37
New ECM-server available andi314 Factoring 3 2003-08-31 11:22
New Server Hardware and price quotes, Funding the server Angular PrimeNet 32 2002-12-09 01:12

All times are UTC. The time now is 09:13.

Sat Aug 8 09:13:46 UTC 2020 up 22 days, 5 hrs, 1 user, load averages: 2.17, 2.27, 2.15

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.