mersenneforum.org  

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

Reply
 
Thread Tools
Old 2017-12-01, 04:00   #507
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

2·36·7 Posts
Default

I sent a PM to Max asking for his help.

I looked at the router config on the new machine and everything looks fine to me. Obviously something needs to be changed somewhere.
gd_barnes is offline   Reply With Quote
Old 2017-12-01, 12:28   #508
AMDave
 
AMDave's Avatar
 
Jan 2006
deep in a while-loop

2·7·47 Posts
Default

when the connection is restored I need to do some DB maintenance to restore the stats.
The main table is busted due to HDD write corruption when the mobo hicupped

Here is the excerpt from the logfile that I get.

Code:
Completed local_port_status at Fri Dec  1 06:00:09 2017

DBD::mysql::st execute failed: Table './nplbstats/results' is marked as crashed and last (automatic?) repair failed at /home/nplb/scripts/refresh_database.pl line 476.
DBD::mysql::st execute failed: Table './nplbstats/results' is marked as crashed and last (automatic?) repair failed at /home/nplb/scripts/refresh_database.pl line 675.
DBD::mysql::st execute failed: Table './nplbstats/results' is marked as crashed and last (automatic?) repair failed at /home/nplb/scripts/refresh_database.pl line 805.
Starting refresh_database at Fri Dec  1 06:00:09 2017
AMDave is offline   Reply With Quote
Old 2017-12-02, 01:56   #509
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

624910 Posts
Default

Dave's guess was exactly right, it's a silly router issue: the port-forwards for the Internet-facing servers are bound to the MAC address of the Ethernet port on Jeepford's old motherboard. (We've been using a DHCP reservation instead of directly configuring Jeepford's static IP ever since we set up Gary's new router a year or two ago.)

I can fix this easily, but to do so I need access to the router's configuration page, which would be easy if not for the fact that (due to this issue) I don't have remote access to Gary's network. So, I've PM'd him directions to download and run a handy-dandy little utility called "ngrok" which will bypass the router and create a direct tunnel to Jeepford, which I can use to get in and fix this.

Last fiddled with by mdettweiler on 2017-12-02 at 01:57
mdettweiler is offline   Reply With Quote
Old 2017-12-02, 07:27   #510
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

2×36×7 Posts
Default

OK I just got home. I will begin doing what Max requested. I will update this post if everything goes successfully.

Once Max has access to my "new" Jeepford machine I have no doubt that he will be able to fix the problem quickly.

Edit: Max, everything that you asked for in the PM has been done. Let me know if I need to do anything else.

Last fiddled with by gd_barnes on 2017-12-02 at 08:29 Reason: edit
gd_barnes is offline   Reply With Quote
Old 2017-12-03, 04:58   #511
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3·2,083 Posts
Default

All fixed! The router configuration has been updated and everything is once again reachable from the Internet. I see that clients have already happily connected to the PRPnet servers and gotten some long-awaited tests.

Gary, I'll send you some directions (with screenshots!) for how to do this yourself in case it ever happens again. I'll also send them to Dave. The fewer maintenance tasks that "only one of us can do", the better.
mdettweiler is offline   Reply With Quote
Old 2017-12-03, 09:00   #512
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

2×36×7 Posts
Default

Quote:
Originally Posted by mdettweiler View Post
All fixed! The router configuration has been updated and everything is once again reachable from the Internet. I see that clients have already happily connected to the PRPnet servers and gotten some long-awaited tests.

Gary, I'll send you some directions (with screenshots!) for how to do this yourself in case it ever happens again. I'll also send them to Dave. The fewer maintenance tasks that "only one of us can do", the better.
Oustanding! Thank you Max!
gd_barnes is offline   Reply With Quote
Old 2017-12-06, 07:41   #513
odicin
 
Sep 2011
Potsdam, Germany

24×7 Posts
Default

@Dave: It seems that the NPLB port report for all 3 ports stuck at 2017-09-29.

Regards Odi

Last fiddled with by odicin on 2017-12-06 at 07:41
odicin is offline   Reply With Quote
Old 2017-12-07, 09:13   #514
AMDave
 
AMDave's Avatar
 
Jan 2006
deep in a while-loop

2×7×47 Posts
Default

Hi Odi
/me waves
That's correct.
I have confirmed control of the stats server is restored, but it is a non-trivial task to restore the broken results table from the last backup before it broke, reprocess the result files up to the point where it broke & then process the data that has accumulated.
I work in a different city to where I live so I opted to defer it to this weekend when I can get a good run at it with my mind on the tasks.
However, your contributions are being recorded correctly and will be included in the stats when I restore the processes in the next day or two.
AMDave is offline   Reply With Quote
Old 2017-12-12, 12:03   #515
AMDave
 
AMDave's Avatar
 
Jan 2006
deep in a while-loop

2×7×47 Posts
Default

Apologies fro the stats blip.
http://stats.free-dc.org/stats.php?page=proj&proj=nplb
The hardware issue has been resolved and the corrupted database table has been rectified.
Move along. Nothing to see here.
https://www.youtube.com/watch?v=pdFl__NlOpA

Last fiddled with by AMDave on 2017-12-12 at 12:04
AMDave is offline   Reply With Quote
Old 2017-12-12, 13:18   #516
AMDave
 
AMDave's Avatar
 
Jan 2006
deep in a while-loop

65810 Posts
Default

NPLB stats database refresh rescheduled from every hour to 3-hourly to improve resource utilisation.
AMDave is offline   Reply With Quote
Old 2017-12-12, 20:06   #517
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

3×823 Posts
Default

Some CRUS tables are also not updating and are empty.
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 19:29.

Wed Sep 30 19:29:49 UTC 2020 up 20 days, 16:40, 0 users, load averages: 1.45, 1.74, 1.75

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.