Database error. unable to upload
log in

Advanced search

Message boards : Number crunching : Database error. unable to upload

1 · 2 · Next
Author Message
Profile [AF>Quebec]MDodier
Send message
Joined: 14 Mar 10
Posts: 14
Credit: 1,471,985,835
RAC: 1,426,288
Message 22141 - Posted: 25 Mar 2016, 16:57:43 UTC

there is a database error message appearing in the status page.

I'm unable to upload the workunit, I worked on!
____________

Profile Robert Pick
Send message
Joined: 17 Oct 10
Posts: 13
Credit: 41,134,618
RAC: 425
Message 22142 - Posted: 25 Mar 2016, 17:01:22 UTC

Neither can I!
Pick

Profile BarryAZ
Send message
Joined: 21 Aug 09
Posts: 251
Credit: 13,316,353,597
RAC: 23,616,634
Message 22143 - Posted: 25 Mar 2016, 17:32:47 UTC
Last modified: 25 Mar 2016, 17:33:50 UTC

Server status page says, that all is well -- but clearly something is amiss.

This failure mode is unusual.


3/25/2016 10:33:10 AM | Collatz Conjecture | Scheduler request failed: HTTP internal server error

Tackleway
Send message
Joined: 29 Sep 13
Posts: 53
Credit: 1,743,351,926
RAC: 1,753,922
Message 22144 - Posted: 25 Mar 2016, 17:54:37 UTC - in response to Message 22143.

Looks like the user data base crashed just after 15:42:49 UTC
which was my last receipt of work from the project.

If nobody is attending the server, we'll have nothing now until after the
(25th) 08:00:00 UTC tomorrow, the time when the refresh seems to occur.

I've got just 1.5 hrs GPU work left here then my reserve projects kick in.

Rgds.
____________

Profile BarryAZ
Send message
Joined: 21 Aug 09
Posts: 251
Credit: 13,316,353,597
RAC: 23,616,634
Message 22145 - Posted: 25 Mar 2016, 17:57:48 UTC - in response to Message 22144.

The curious thing is that we can still access the user stats -- often enough when the data base goes walkabout that is unavailable.

I sent a message off to Slicker -- not sure if he'll be able to look into it until late tonight.
____________

Tackleway
Send message
Joined: 29 Sep 13
Posts: 53
Credit: 1,743,351,926
RAC: 1,753,922
Message 22147 - Posted: 25 Mar 2016, 18:53:33 UTC - in response to Message 22145.

Yes, most unusual. 'Tasks' will open but 'Computers on this account'
opens but advises an error, as below?

https://boinc.thesonntags.com/collatz//hosts_user.php

Don't forget it's a holiday weekend for many so Jon may be off in the
woods until Tuesday!!!
____________

jjwhalen
Avatar
Send message
Joined: 17 Apr 10
Posts: 20
Credit: 202,526,055
RAC: 0
Message 22148 - Posted: 25 Mar 2016, 19:25:33 UTC

It's been a long time (for this project) since the database crashed. The nightly maintenance seems to be doing a good job.

My RAC almost hit 800,000 this time. Curses! Foiled again! :)

davo-[rot]
Send message
Joined: 10 Feb 10
Posts: 2
Credit: 167,964,788
RAC: 34
Message 22149 - Posted: 25 Mar 2016, 22:10:51 UTC

Well apparently the database crashed that sucks i just hit 2.6 mill rac with my one gtx980. been pushing 4 mill a day with a single card. :)
just when i got it optimized perfectly with fiddleing with seive size and lut size.

numbermaniac
Send message
Joined: 26 Jul 14
Posts: 30
Credit: 6,014,522
RAC: 13,700
Message 22151 - Posted: 25 Mar 2016, 22:18:59 UTC

It's stuffed me up even further. Due to the error, when my phone contacted the server it couldn't find my phone in my computer list and apparently it's created a new CPID for me. Now it says my phone has generated 0 credit, but the total credit still seems to be correct.

Profile bcavnaugh
Avatar
Send message
Joined: 24 Mar 14
Posts: 19
Credit: 1,640,909,557
RAC: 2,124,564
Message 22152 - Posted: 25 Mar 2016, 23:38:53 UTC

Is Anyone Working the Database Error?

Profile Slicker
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 11 Jun 09
Posts: 2525
Credit: 740,580,099
RAC: 1
Message 22153 - Posted: 26 Mar 2016, 2:18:30 UTC

Fixed. MySQL said it was out of memory. After restarting it and doing the monthly maintenance a few days early, it seems to be running OK. I guess I really need to work on getting the large sieve WU daemons set up. That should help with fewer WUs, fewer results, fewer client-host communications, etc.

jjwhalen
Avatar
Send message
Joined: 17 Apr 10
Posts: 20
Credit: 202,526,055
RAC: 0
Message 22156 - Posted: 26 Mar 2016, 2:35:37 UTC

Cool.

Tackleway
Send message
Joined: 29 Sep 13
Posts: 53
Credit: 1,743,351,926
RAC: 1,753,922
Message 22158 - Posted: 26 Mar 2016, 2:45:46 UTC - in response to Message 22153.
Last modified: 26 Mar 2016, 2:47:14 UTC

Hi Jon, thanks so much for the info.
Wishing you and yours a very happy Easter.
____________

Profile BarryAZ
Send message
Joined: 21 Aug 09
Posts: 251
Credit: 13,316,353,597
RAC: 23,616,634
Message 22159 - Posted: 26 Mar 2016, 6:38:49 UTC

Looks like the server is coping with some intense reporting / uploading congestion at the moment.

Helix Von Smelix
Send message
Joined: 2 Aug 10
Posts: 43
Credit: 10,195,645,004
RAC: 1,508,438
Message 22161 - Posted: 26 Mar 2016, 14:31:26 UTC - in response to Message 22159.

I have one box acting normally with connection every 5 mins.
Others with "can't resolve host name", very strange!

Profile Thomas Krajewsky
Avatar
Send message
Joined: 2 Feb 10
Posts: 13
Credit: 379,296,674
RAC: 0
Message 22162 - Posted: 26 Mar 2016, 14:55:27 UTC - in response to Message 22161.

I have one box acting normally with connection every 5 mins.
Others with "can't resolve host name", very strange!


The same here:

C:\>nslookup boinc.thesonntags.com 8.8.8.8
Server: google-public-dns-a.google.com
Address: 8.8.8.8

Nicht autorisierende Antwort:
Name: boinc.thesonntags.com


C:\>nslookup boinc.thesonntags.com 145.253.2.11
Server: dns1.arcor-ip.de
Address: 145.253.2.11

Nicht autorisierende Antwort:
Name: boinc.thesonntags.com


C:\>nslookup boinc.thesonntags.com 208.67.220.220
Server: resolver2.opendns.com
Address: 208.67.220.220

Nicht autorisierende Antwort:
Name: boinc.thesonntags.com


C:\>


(But i can reach this forum with firefox on my laptop, where DNS-Cache has an entry for 'boinc.thesonntags.com')

Small workaround: Edit your hosts-file and add
    50.158.27.76 thesonntags.com
    50.158.27.76 boinc.thesonntags.com

until DNS is fixed.

Helix Von Smelix
Send message
Joined: 2 Aug 10
Posts: 43
Credit: 10,195,645,004
RAC: 1,508,438
Message 22163 - Posted: 26 Mar 2016, 17:43:16 UTC - in response to Message 22162.

cheers, I should have thought of that.
I think I emptied the server of WU's temporarily

Profile FourOh
Send message
Joined: 6 Jan 14
Posts: 2
Credit: 1,456,982,024
RAC: 9,678,848
Message 22164 - Posted: 26 Mar 2016, 18:39:17 UTC

Some of my hosts are reporting and receiving work, while others still cannot connect. On one of the stranded hosts, I detached and re-attached, but I get the error message "Project Temporarily Unavailable."

Could be a DNS issue? My hosts at home are connecting, hosts at two other locations are not.

Profile FourOh
Send message
Joined: 6 Jan 14
Posts: 2
Credit: 1,456,982,024
RAC: 9,678,848
Message 22165 - Posted: 26 Mar 2016, 18:50:11 UTC - in response to Message 22162.
Last modified: 26 Mar 2016, 18:58:35 UTC



Small workaround: Edit your hosts-file and add
    50.158.27.76 thesonntags.com
    50.158.27.76 boinc.thesonntags.com

until DNS is fixed.



Could you be more specific about where to make this edit? What file should I look for and where should it be?

.....
Found it: %SystemRoot%\System32\drivers\etc\

Profile Slicker
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 11 Jun 09
Posts: 2525
Credit: 740,580,099
RAC: 1
Message 22166 - Posted: 26 Mar 2016, 20:20:38 UTC - in response to Message 22162.

The CNAME records aren't being resolved back to the domain. e.g. boinc.thesonntags.com should point to thesonntags.com which should be 50.158.27.76. That, or the A record for the domain isn't working for some reason. I added an A record for boinc.thesonntags.com as well as a generic "@" host which I believe will fix the issue but it will take a while for that to propagate to all the name servers.

1 · 2 · Next
Post to thread

Message boards : Number crunching : Database error. unable to upload


Main page · Your account · Message boards


Copyright © 2018 Jon Sonntag; All rights reserved.