mersenneforum.org  

Go Back   mersenneforum.org > Search Forums

Showing results 1 to 25 of 137
Search took 0.02 seconds.
Search: Posts Made By: gd_barnes
Forum: No Prime Left Behind 2020-03-05, 12:23
Replies: 568
Views: 85,752
Posted By gd_barnes
I assume these recent posts are not related to...

I assume these recent posts are not related to NPLB's PRPnet servers, which appear to be working fine.
Forum: No Prime Left Behind 2020-01-12, 03:44
Replies: 568
Views: 85,752
Posted By gd_barnes
Servers are back up! Thank you everyone for...

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...
Forum: No Prime Left Behind 2020-01-12, 00:14
Replies: 568
Views: 85,752
Posted By gd_barnes
A little more info: I am able to do selects...

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...
Forum: No Prime Left Behind 2020-01-12, 00:10
Replies: 568
Views: 85,752
Posted By gd_barnes
That's not the problem. I dumped one huge...

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,...
Forum: No Prime Left Behind 2020-01-11, 21:39
Replies: 568
Views: 85,752
Posted By gd_barnes
Adding the parameters in Reb's recent suggestion...

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...
Forum: No Prime Left Behind 2020-01-11, 21:17
Replies: 568
Views: 85,752
Posted By gd_barnes
I picked another random database to drop that is...

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

The database dropped just fine.

Trying Reb's suggestion next...
Forum: No Prime Left Behind 2020-01-11, 21:03
Replies: 568
Views: 85,752
Posted By gd_barnes
So here is my latest attempt to start MySQL after...

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 ...
Forum: No Prime Left Behind 2020-01-11, 20:57
Replies: 568
Views: 85,752
Posted By gd_barnes
I seem to be in a vicious loop here. As...

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...
Forum: No Prime Left Behind 2020-01-11, 20:06
Replies: 568
Views: 85,752
Posted By gd_barnes
Haha. Good one Ian. I will move the applicable...

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.
Forum: No Prime Left Behind 2020-01-11, 10:17
Replies: 568
Views: 85,752
Posted By gd_barnes
With all of your help I've made quite a bit of...

With all of your help I've made quite a bit of progress.

I changed the recovery command to:
innodb_force_recovery = 5

That successfully started MySQL and allowed me to dump the databases.
...
Forum: No Prime Left Behind 2020-01-11, 06:05
Replies: 568
Views: 85,752
Posted By gd_barnes
This did not work. I got the following...

This did not work. I got the following gibberish:


gary@jeepford:~$ sudo mysqld --skip-grant-tables
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have...
Forum: No Prime Left Behind 2020-01-11, 01:42
Replies: 568
Views: 85,752
Posted By gd_barnes
So...after doing steps 2 and 3 and running into...

So...after doing steps 2 and 3 and running into that previous error on step 4...I thought I would try step 5 with the following command:

root@jeepford:/etc/mysql# mysqldump -u gary -p prpnet1300 >...
Forum: No Prime Left Behind 2020-01-10, 22:55
Replies: 568
Views: 85,752
Posted By gd_barnes
Using the link in Reb's post as a reference. ...

Using the link in Reb's post as a reference.

I was able to log in as root and backup the files in step #2.

Per step #3 I edited /etc/mysql/my.cnf to have the command:
innodb_force_recovery = 1...
Forum: No Prime Left Behind 2020-01-10, 21:02
Replies: 568
Views: 85,752
Posted By gd_barnes
I am trying Rebirther's suggested link. I was...

I am trying Rebirther's suggested link. I was able to stop the SQL server in step 1. But I am unable to do steps 2 or 3 because I do not have permissions.

I get the following message:
You do...
Forum: No Prime Left Behind 2020-01-10, 08:45
Replies: 568
Views: 85,752
Posted By gd_barnes
Here are the first few pages after shutting...

Here are the first few pages after shutting machine down and turning it back on:


Jan 10 02:06:07 jeepford syslogd 1.5.0#5ubuntu3: restart.
Jan 10 02:06:07 jeepford anacron[3197]: Job...
Forum: No Prime Left Behind 2020-01-10, 08:39
Replies: 568
Views: 85,752
Posted By gd_barnes
Here are the last few pages. I hope this is...

Here are the last few pages. I hope this is enough.


Jan 10 02:34:22 jeepford mysqld[8351]: This could be because you hit a bug. It is also possible that this binary
Jan 10 02:34:22 jeepford...
Forum: No Prime Left Behind 2020-01-10, 08:09
Replies: 568
Views: 85,752
Posted By gd_barnes
Dmitry, Here is a screen shot of my recent...

Dmitry,

Here is a screen shot of my recent attempt to do what you suggested:


gary@jeepford:~$ sudo service mysql status
[sudo] password for gary:
* MySQL is stopped.
gary@jeepford:~$...
Forum: No Prime Left Behind 2020-01-09, 23:53
Replies: 568
Views: 85,752
Posted By gd_barnes
The NPLB and CRUS PRPnet servers are down and...

The NPLB and CRUS PRPnet servers are down and have been for over 12 hours.

It is not a computer issue. The NPLB and CRUS web pages are OK and I am able to update them.

I am getting a MySQL...
Forum: No Prime Left Behind 2019-05-06, 20:25
Replies: 568
Views: 85,752
Posted By gd_barnes
Bad power supply in server machine. Replaced. ...

Bad power supply in server machine. Replaced. Everything looks good now. :smile:
Forum: No Prime Left Behind 2019-05-06, 00:47
Replies: 568
Views: 85,752
Posted By gd_barnes
The server machine continues to reboot itself. ...

The server machine continues to reboot itself. It may be a day before I can get it fixed.
Forum: No Prime Left Behind 2019-04-15, 02:33
Replies: 568
Views: 85,752
Posted By gd_barnes
Server and ports are back up. Sorry about the...

Server and ports are back up. Sorry about the outage.
Forum: No Prime Left Behind 2019-01-13, 04:28
Replies: 568
Views: 85,752
Posted By gd_barnes
It was down for 2-3 hours due to a power blip and...

It was down for 2-3 hours due to a power blip and a stubborn ethernet splitter. It's been back up for several hours now.
Forum: No Prime Left Behind 2017-12-14, 07:45
Replies: 568
Views: 85,752
Posted By gd_barnes
I found the problem on my end. For some reason...

I found the problem on my end. For some reason the machine had lost its internet connection although the servers continued working just fine. I stopped the servers, rebooted it, restarted the...
Forum: No Prime Left Behind 2017-12-12, 21:51
Replies: 568
Views: 85,752
Posted By gd_barnes
Dave, I noticed this too. The first time I...

Dave,

I noticed this too. The first time I noticed it was a couple of days ago. I don't know if it is related to your change but the timing does seem coincidental. Can you check into this? ...
Forum: No Prime Left Behind 2017-12-03, 09:00
Replies: 568
Views: 85,752
Posted By gd_barnes
Oustanding! Thank you Max!

Oustanding! Thank you Max!
Showing results 1 to 25 of 137

 
All times are UTC. The time now is 21:45.

Sat Mar 28 21:45:51 UTC 2020 up 3 days, 19:18, 2 users, load averages: 1.99, 1.68, 1.66

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.