mersenneforum.org  

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

Reply
 
Thread Tools
Old 2020-01-12, 02:04   #562
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

11×257 Posts
Default

Wild assed guess. I'm going to say that the MYSQL software is corrupt. Try installing
the MYSQL software again . I'm pretty sure that won't touch your data. Be sure the MYSQL service is stopped.
MyDogBuster is offline   Reply With Quote
Old 2020-01-12, 03:44   #563
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

235048 Posts
Default

Servers are back up!

Thank you everyone for your help!

I was able to determine that several of the databases were corrupt so I dropped them all, recreated them, and reloaded them...all except my personal prpnet1470. All of the PRPnet servers work great now!

The problem was probably related to too many rows in prpnet1470 being hit by too many clients because that is where the problem started.

Bring on those machines!

I'm very sorry about the problem.

Last fiddled with by gd_barnes on 2020-01-12 at 03:44
gd_barnes is offline   Reply With Quote
Old 2020-02-21, 19:44   #564
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

42518 Posts
Default

Hey Guys, now Iam affected after windows 10 has decided to give me a bluescreen, I cant take further actions, stucking at:


mysqldump: Got error: 1146: Table 'sr5.app' doesn't exist when using LOCK TABLES


Looks like a lot of tables are bad, enable skip lock tables doesnt help.


Any hints?


Update log:
[ERROR] Cannot find or open table sr5/app from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.


I think the files are lost.

Last fiddled with by rebirther on 2020-02-21 at 19:49
rebirther 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 21:40.

Fri Feb 21 21:40:49 UTC 2020 up 21 days, 16:12, 2 users, load averages: 3.31, 3.07, 3.01

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.