Server cannot open database


Advanced search

Message boards : Number crunching : Server cannot open database

Sort
Author Message
Ananas

Joined: Aug 29 09
Posts: 56
ID: 17736
Credit: 2,500,425
RAC: 0
Message 6552 - Posted 29 Jan 2012 12:43:29 UTC
Last modified: 29 Jan 2012 12:45:46 UTC

This message might be a result of generating new work but it might as well be a hint that something is broken. The database itself is running (or I wouldn't be able to post) but the scheduler cannot reach it and the server is extremely laggy.

If it is caused be a very hard working work generator, you should probably switch to maintenance mode, as reporting/requesting currently doesn't do much anyway.

ID: 6552 | Rating: 0 | rate: Rate + / Rate - Report as offensive
JanBogutzki

Joined: Jan 27 12
Posts: 2
ID: 49325
Credit: 68,551
RAC: 0
Message 6553 - Posted 29 Jan 2012 13:52:36 UTC

Same error here:

29.01.2012 14:44:24 | Docking | Server can't open database

when i tried to go to the website in this moment, a mysql error, that there are too many connections welcomed me... possibly this is the source of the problem.

____________
test PHP online : md5 , preg_match , ...

ID: 6553 | Rating: 0 | rate: Rate + / Rate - Report as offensive

Message boards : Number crunching : Server cannot open database

Database Error
: The MySQL server is running with the --read-only option so it cannot execute this statement 
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(47) "/boinc/projects/docking/html_v2/inc/db_conn.inc"
    ["line"]=>
    int(97)
    ["function"]=>
    string(8) "do_query"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#7 (2) {
      ["db_conn"]=>
      resource(60) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(51) "update DBNAME.thread set views=views+1 where id=636"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(48) "/boinc/projects/docking/html_v2/inc/forum_db.inc"
    ["line"]=>
    int(60)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#7 (2) {
      ["db_conn"]=>
      resource(60) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      object(BoincThread)#3 (16) {
        ["id"]=>
        string(3) "636"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(5) "17736"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(27) "Server cannot open database"
        ["timestamp"]=>
        string(10) "1327845156"
        ["views"]=>
        string(2) "39"
        ["replies"]=>
        string(1) "1"
        ["activity"]=>
        string(18) "7.039380362578e-47"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1327841009"
        ["hidden"]=>
        string(1) "0"
        ["sticky"]=>
        string(1) "0"
        ["locked"]=>
        string(1) "0"
      }
      [1]=>
      &string(6) "thread"
      [2]=>
      &string(13) "views=views+1"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(63) "/boinc/projects/docking/html_v2/user/community/forum/thread.php"
    ["line"]=>
    int(184)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(11) "BoincThread"
    ["object"]=>
    object(BoincThread)#3 (16) {
      ["id"]=>
      string(3) "636"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(5) "17736"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(27) "Server cannot open database"
      ["timestamp"]=>
      string(10) "1327845156"
      ["views"]=>
      string(2) "39"
      ["replies"]=>
      string(1) "1"
      ["activity"]=>
      string(18) "7.039380362578e-47"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1327841009"
      ["hidden"]=>
      string(1) "0"
      ["sticky"]=>
      string(1) "0"
      ["locked"]=>
      string(1) "0"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(13) "views=views+1"
    }
  }
}
query: update docking.thread set views=views+1 where id=636