Database purge ?


Advanced search

Message boards : Number crunching : Database purge ?

Sort
Author Message
entigy

Joined: Mar 11 10
Posts: 1
ID: 26814
Credit: 361,348
RAC: 0
Message 7028 - Posted 10 Feb 2013 16:20:55 UTC

When, if ever, does the database get purged of old results ?
I have no hosts running this project any more, but there is one result (returned over 12 months ago) that is preventing me from removing the one host still listed under "My Computers".

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

Joined: Jan 26 11
Posts: 17
ID: 37208
Credit: 114,943
RAC: 0
Message 7029 - Posted 10 Feb 2013 21:48:05 UTC - in response to Message ID 7028 .
Last modified: 10 Feb 2013 21:48:38 UTC

When, if ever, does the database get purged of old results ?
I have no hosts running this project any more, but there is one result (returned over 12 months ago) that is preventing me from removing the one host still listed under "My Computers".


I suppose not before it causes some serious problems again (look at: Consistant 0% Progress topic). Although right now I can't really remember if it was the main reason.. oh well.
ID: 7029 | Rating: 0 | rate: Rate + / Rate - Report as offensive
Boyu Zhang
Forum moderator
Project administrator
Project developer
Project tester

Joined: May 5 10
Posts: 88
ID: 28821
Credit: 2,013,795
RAC: 0
Message 7035 - Posted 14 Feb 2013 19:00:11 UTC - in response to Message ID 7028 .

It should be fixed now. We purge the database regularly, the reason that the result did not get removed if because that the "client state" of that result was "uploading" for some reason, so the database purger did not remove it.

But it should be removed now.

Thanks!
Boyu

When, if ever, does the database get purged of old results ?
I have no hosts running this project any more, but there is one result (returned over 12 months ago) that is preventing me from removing the one host still listed under "My Computers".

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

Joined: Aug 29 09
Posts: 56
ID: 17736
Credit: 2,500,425
RAC: 0
Message 7051 - Posted 26 Feb 2013 23:07:54 UTC
Last modified: 26 Feb 2013 23:11:19 UTC

I guess the database purge doesn't work as expected as it most likely uses the workunit table as the leading relation.

There are results though that are not attached to a workunit anymore, e.g. :

resultid=34595540 is an "orphan".

I have reported it somewhere else in this forum already but those results are still there.

p.s.: here is my old report about this problem.

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

Message boards : Number crunching : Database purge ?

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(72) 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=714"
    }
  }
  [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(72) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      object(BoincThread)#3 (16) {
        ["id"]=>
        string(3) "714"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(5) "26814"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(16) "Database purge ?"
        ["timestamp"]=>
        string(10) "1361920074"
        ["views"]=>
        string(2) "76"
        ["replies"]=>
        string(1) "3"
        ["activity"]=>
        string(19) "5.4830167390323e-30"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1360513255"
        ["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) "714"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(5) "26814"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(16) "Database purge ?"
      ["timestamp"]=>
      string(10) "1361920074"
      ["views"]=>
      string(2) "76"
      ["replies"]=>
      string(1) "3"
      ["activity"]=>
      string(19) "5.4830167390323e-30"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1360513255"
      ["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=714