Servers appear hung up


Advanced search

Message boards : Number crunching : Servers appear hung up

Sort
Author Message
BigMike
Avatar

Joined: Oct 3 08
Posts: 2
ID: 1960
Credit: 6,377
RAC: 0
Message 4465 - Posted 6 Oct 2008 14:46:59 UTC

The Server Status page is showing quite a backup, and it's been that way for at least a day. Is it the servers, or is the page not being updated?

==Mike
____________
Don't believe everything you think.

ID: 4465 | Rating: 0 | rate: Rate + / Rate - Report as offensive
Profile Trilce Estrada
Forum moderator
Project administrator
Project developer
Project tester

Joined: Sep 19 06
Posts: 189
ID: 119
Credit: 1,217,236
RAC: 0
Message 4469 - Posted 6 Oct 2008 15:36:32 UTC - in response to Message ID 4465 .

Most of the time is the Web page, it is not updated very frequently. You can see that something is wrong when it appears to be 0 tasks ready to be sent, in that case there is something really wrong, otherwise is just the Web page that is not updated

ID: 4469 | Rating: 0 | rate: Rate + / Rate - Report as offensive
BigMike
Avatar

Joined: Oct 3 08
Posts: 2
ID: 1960
Credit: 6,377
RAC: 0
Message 4473 - Posted 6 Oct 2008 17:25:15 UTC - in response to Message ID 4469 .

Most of the time is the Web page, it is not updated very frequently.

My concern is that the page has looked like this pretty much all weekend:

State #
Results ready to send 845
Results in progress 32,338
Workunits waiting for validation 62
Workunits waiting for assimilation 63
Workunits waiting for deletion 328
Results waiting for deletion 2,169
Transitioner backlog (hours) 0


Not only do the numbers seem high, but the Worklunits Waiting numbers are not changing. I haven't been paying attention to the others, but I think they're pretty much unchanged also.

==Mike
____________
Don't believe everything you think.
ID: 4473 | Rating: 0 | rate: Rate + / Rate - Report as offensive
Profile Trilce Estrada
Forum moderator
Project administrator
Project developer
Project tester

Joined: Sep 19 06
Posts: 189
ID: 119
Credit: 1,217,236
RAC: 0
Message 4475 - Posted 6 Oct 2008 17:52:30 UTC - in response to Message ID 4473 .


Not only do the numbers seem high, but the Worklunits Waiting numbers are not changing. I haven't been paying attention to the others, but I think they're pretty much unchanged also.


Hi Mike, I went through the DB and I found that there were some wu's not purged correctly (mostly of very old applications). Now the numbers should be lower and change more frequently (at least those for waiting something)

Thank you =)
ID: 4475 | Rating: 0 | rate: Rate + / Rate - Report as offensive

Message boards : Number crunching : Servers appear hung up

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)#9 (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=348"
    }
  }
  [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)#9 (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) "348"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(4) "1960"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(22) "Servers appear hung up"
        ["timestamp"]=>
        string(10) "1223315550"
        ["views"]=>
        string(3) "238"
        ["replies"]=>
        string(1) "3"
        ["activity"]=>
        string(19) "1.3151551770954e-98"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1223304419"
        ["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) "348"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(4) "1960"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(22) "Servers appear hung up"
      ["timestamp"]=>
      string(10) "1223315550"
      ["views"]=>
      string(3) "238"
      ["replies"]=>
      string(1) "3"
      ["activity"]=>
      string(19) "1.3151551770954e-98"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1223304419"
      ["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=348