'Server Can't Open Database'
log in

Advanced search

Message boards : Number crunching : 'Server Can't Open Database'

1 · 2 · Next
Author Message
JLDun
Send message
Joined: 19 Nov 15
Posts: 13
Credit: 214,300
RAC: 23
Message 1301 - Posted: 27 Dec 2016, 0:50:45 UTC

For host 62881.\r\n\r\nIt even happens after a detach/reattach. I have two other Droids connected that can still get work.
____________

Profile Dingo
Send message
Joined: 13 Nov 15
Posts: 1
Credit: 1,614,810
RAC: 2,690
Message 1302 - Posted: 27 Dec 2016, 1:23:41 UTC
Last modified: 27 Dec 2016, 1:28:13 UTC

Yes seems to be an problem reading the database\r\n\r\n

\r\n26-Dec-16 6:20:09 PM | GoofyxGrid@Home | update requested by user\r\n26-Dec-16 6:20:11 PM | GoofyxGrid@Home | Sending scheduler request: Requested by user.\r\n26-Dec-16 6:20:11 PM | GoofyxGrid@Home | Reporting 3 completed tasks\r\n26-Dec-16 6:20:11 PM | GoofyxGrid@Home | Requesting new tasks for CPU\r\n26-Dec-16 6:20:22 PM | GoofyxGrid@Home | Scheduler request completed: got 0 new tasks\r\n26-Dec-16 6:20:22 PM | GoofyxGrid@Home | Server can't open database\r\n\r\n
\r\n\r\nIt is also affecting the web pages;\r\n\r\n
\r\nWarning: mysqli::query(): Couldn't fetch mysqli in /home/boincadm/goofyx_grid/html/inc/db_conn.inc on line 65\r\nDatabase Error\r\n\r\nWarning: mysqli::query(): Couldn't fetch mysqli in /home/boincadm/goofyx_grid/html/inc/db_conn.inc on line 65\r\nDatabase Error\r\n\r\nWarning: mysqli::escape_string(): Couldn't fetch mysqli in /home/boincadm/goofyx_grid/html/inc/db_conn.inc on line 229\r\n\r\nWarning: mysqli::query(): Couldn't fetch mysqli in /home/boincadm/goofyx_grid/html/inc/db_conn.inc on line 65\r\nDatabase Error\r\nUnable to handle request\r\nlog in\r\ndatabase error on query select count(*) as total from goofyx_grid.user where teamid=156

____________
\r\n\r\nProud Founder and member of \r\nHave a look at my WebCam

Dr Who Fan
Avatar
Send message
Joined: 4 Dec 15
Posts: 80
Credit: 913,890
RAC: 2,535
Message 1305 - Posted: 27 Dec 2016, 7:10:39 UTC

DATABASE/SERVER PROBLEMS\r\n

12/27/2016 01:06:04 | GoofyxGrid@Home | Server can't open database
\r\n\r\nAlso see my post in "UPLOAD/DOWNLOAD Problems: Server NOT responding" [urlhttp://goofyxgridathome.net/forum_thread.php?id=80&postid=1303]Message 1303[/url]
____________
\r\n

Dr Who Fan
Avatar
Send message
Joined: 4 Dec 15
Posts: 80
Credit: 913,890
RAC: 2,535
Message 1306 - Posted: 27 Dec 2016, 7:10:53 UTC
Last modified: 27 Dec 2016, 7:11:19 UTC

DATABASE/SERVER PROBLEMS\r\n

12/27/2016 01:06:04 | GoofyxGrid@Home | Server can't open database
\r\n\r\nAlso see my post in "UPLOAD/DOWNLOAD Problems: Server NOT responding" Message 1303
____________
\r\n

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1307 - Posted: 27 Dec 2016, 7:54:48 UTC - in response to Message 1306.

Every problems with server has the same source.\r\nOn my OVH server disk it's dead <- AGAIN :(\r\nThis time I lost 2 disks <- one from every raid 1 I have.\r\n\r\nI will try to change server in next 2 days.

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1310 - Posted: 27 Dec 2016, 13:20:20 UTC - in response to Message 1307.

Every problems with server has the same source.\r\nOn my OVH server disk it's dead <- AGAIN :(\r\nThis time I lost 2 disks <- one from every raid 1 I have.\r\n\r\nI will try to change server in next 2 days.
\r\nI set up boinc project on new server and now I am starting to moving data.\r\nI hope that everythink go good and I started new server tonight

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1311 - Posted: 27 Dec 2016, 23:05:18 UTC - in response to Message 1310.

Project slowly starting on new enviroment.\r\nWhole things need time to start in full speed and some adjustment <- so I have to ask you for patience.\r\n\r\nI am starting to generating first series of WU

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1328 - Posted: 29 Dec 2016, 20:21:04 UTC - in response to Message 1311.

Ok after 5 hours on analyzed every system logs (linux, mysql, apache2) I came to one result. GoofyxGrid was under (if I can that) "attack" of seo/spammers bots which generate so much transfer and mysql connection that my server couldn't do more than killing existing connection.
I count about 4 bots <- in my config files I block now 8 diffrent bots.

Profile Bryan
Send message
Joined: 12 Nov 15
Posts: 8
Credit: 100,471,520
RAC: 67
Message 1331 - Posted: 29 Dec 2016, 22:20:14 UTC - in response to Message 1328.

I'm having a lot of problems in the USA getting work. Most of the time that I request work I'm being told that project communications failed and BOINC goes into backoff mode.

The uploads are very quick without any problems.

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1332 - Posted: 29 Dec 2016, 22:40:28 UTC - in response to Message 1331.

I'm having a lot of problems in the USA getting work. Most of the time that I request work I'm being told that project communications failed and BOINC goes into backoff mode.

The uploads are very quick without any problems.

if after manualy refrest project everythink back to normal?

JLDun
Send message
Joined: 19 Nov 15
Posts: 13
Credit: 214,300
RAC: 23
Message 1333 - Posted: 30 Dec 2016, 0:14:29 UTC

I just tried connecting (partially because this is my phone and I don't bounce when out) and I can connect.
____________

Profile Bryan
Send message
Joined: 12 Nov 15
Posts: 8
Credit: 100,471,520
RAC: 67
Message 1334 - Posted: 30 Dec 2016, 0:15:04 UTC - in response to Message 1332.

I'm having a lot of problems in the USA getting work. Most of the time that I request work I'm being told that project communications failed and BOINC goes into backoff mode.

The uploads are very quick without any problems.

if after manualy refrest project everythink back to normal?


I left the house for 2 hours and when I came back all machines were pulling work without a problem :) There appears to be reliable communications again.

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1335 - Posted: 30 Dec 2016, 0:21:29 UTC - in response to Message 1334.

I'm having a lot of problems in the USA getting work. Most of the time that I request work I'm being told that project communications failed and BOINC goes into backoff mode.

The uploads are very quick without any problems.

if after manualy refrest project everythink back to normal?


I left the house for 2 hours and when I came back all machines were pulling work without a problem :) There appears to be reliable communications again.

good to hear that :)

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1336 - Posted: 30 Dec 2016, 19:41:20 UTC - in response to Message 1328.

Ok after 5 hours on analyzed every system logs (linux, mysql, apache2) I came to one result. GoofyxGrid was under (if I can that) "attack" of seo/spammers bots which generate so much transfer and mysql connection that my server couldn't do more than killing existing connection.
I count about 4 bots <- in my config files I block now 8 diffrent bots.

From yesterday I am watching into my logs and thanks of this now I am blocking not 8 but 15 bots. Second good info for is that I don't need to check logs every day... now it's enought to look on htop to known if server has problem with bots or not in real time :)

Profile Tarmo Ilves
Avatar
Send message
Joined: 18 Jan 16
Posts: 22
Credit: 23,841,120
RAC: 102,500
Message 1337 - Posted: 31 Dec 2016, 8:23:49 UTC

I'm getting a lot of errors
is this something wrong on my end or what?

<core_client_version>7.4.23</core_client_version> <![CDATA[ <stderr_txt> 04:48:37 (21890): called boinc_finish </stderr_txt> <message> finish file present too long </message>

____________

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1338 - Posted: 2 Jan 2017, 7:30:16 UTC - in response to Message 1337.

I'm getting a lot of errors
is this something wrong on my end or what?
<core_client_version>7.4.23</core_client_version> <![CDATA[ <stderr_txt> 04:48:37 (21890): called boinc_finish </stderr_txt> <message> finish file present too long </message>

You have hidden hosts list. What is host id?

Profile Tarmo Ilves
Avatar
Send message
Joined: 18 Jan 16
Posts: 22
Credit: 23,841,120
RAC: 102,500
Message 1339 - Posted: 2 Jan 2017, 7:45:17 UTC - in response to Message 1338.

I'm getting a lot of errors
is this something wrong on my end or what?
<core_client_version>7.4.23</core_client_version> <![CDATA[ <stderr_txt> 04:48:37 (21890): called boinc_finish </stderr_txt> <message> finish file present too long </message>

You have hidden hosts list. What is host id?

It is completely random.
Multiple hosts reporting errors.
I made hosts visible now.
____________

Profile [boinc@poland]goofyx
Project administrator
Project developer
Project scientist
Help desk expert
Send message
Joined: 8 Nov 15
Posts: 540
Credit: 9,002,054
RAC: 8,283
Message 1340 - Posted: 2 Jan 2017, 10:30:37 UTC - in response to Message 1339.

I'm getting a lot of errors
is this something wrong on my end or what?
<core_client_version>7.4.23</core_client_version> <![CDATA[ <stderr_txt> 04:48:37 (21890): called boinc_finish </stderr_txt> <message> finish file present too long </message>

You have hidden hosts list. What is host id?

It is completely random.
Multiple hosts reporting errors.
I made hosts visible now.

I check some of your host.
For now you have 3-4 error for 200-220 good result <- for now is nothing to worry.

Profile Saenger
Avatar
Send message
Joined: 19 Nov 15
Posts: 9
Credit: 339,520
RAC: 1,066
Message 1387 - Posted: 4 Feb 2017, 15:09:12 UTC
Last modified: 4 Feb 2017, 15:09:22 UTC

I can't get new work, and the error mesage is (at least once) the one from the title of this thread:

Sa 04 Feb 2017 15:14:30 CET | GoofyxGrid@Home | Sending scheduler request: To report completed tasks. Sa 04 Feb 2017 15:14:30 CET | GoofyxGrid@Home | Reporting 1 completed tasks Sa 04 Feb 2017 15:14:30 CET | GoofyxGrid@Home | Not requesting tasks: non CPU intensive Sa 04 Feb 2017 15:14:41 CET | GoofyxGrid@Home | Scheduler request completed Sa 04 Feb 2017 15:14:41 CET | GoofyxGrid@Home | Server error: feeder not running Sa 04 Feb 2017 15:44:44 CET | GoofyxGrid@Home | Sending scheduler request: Requested by project. Sa 04 Feb 2017 15:44:44 CET | GoofyxGrid@Home | Reporting 4 completed tasks Sa 04 Feb 2017 15:44:44 CET | GoofyxGrid@Home | Requesting new tasks for CPU Sa 04 Feb 2017 15:45:50 CET | GoofyxGrid@Home | Scheduler request completed: got 0 new tasks Sa 04 Feb 2017 15:45:50 CET | GoofyxGrid@Home | Server can't open database

What's wrong?
____________
Grüße vom Sänger

Profile Saenger
Avatar
Send message
Joined: 19 Nov 15
Posts: 9
Credit: 339,520
RAC: 1,066
Message 1388 - Posted: 4 Feb 2017, 15:18:16 UTC - in response to Message 1387.
Last modified: 4 Feb 2017, 15:19:37 UTC

I can't get new work, and the error mesage is (at least once) the one from the title of this thread:

I got work, first just one, then another two WUs. As the server status says, there are no unsent WUs from Monkeys v3 - Generator/Word seed, this seems to be reasonable.

There are a lot of data base errors on the main page as well, is therer any connection?

P.S.: I got kicked out of my account while typing this, but a few steps back in my browser were enough to get logged in again, strange stuff...
____________
Grüße vom Sänger

1 · 2 · Next

Message boards : Number crunching : 'Server Can't Open Database'


Main page · Your account · Message boards


Copyright © 2018 Goofyx

Generated 26 Sep 2018, 12:16:54 UTC