Database clear out?


Advanced search

Message boards : Number crunching : Database clear out?

Sort
Author Message
Profile MacDitch
Volunteer tester

Joined: Sep 13 06
Posts: 27
ID: 24
Credit: 377,838
RAC: 0
Message 3452 - Posted 26 Jun 2007 14:26:06 UTC

I have a load of old/duplicate hosts which I can't get rid of due to them still having work units assigned to them. Is there any chance of the database being cleared out during the move?

I appreciate that this is not a big deal and that you probably have more important issues, but it would be nice to do some clean-up. :)

Cheers

Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 3458 - Posted 30 Jun 2007 10:05:53 UTC - in response to Message ID 3452 .

We can merge duplicate hosts for you. Just let us know which ones you want to have merged. If you want you can write an email with the host numbers to dockingadmin@utep.edu

Cheers
Andre


I have a load of old/duplicate hosts which I can't get rid of due to them still having work units assigned to them. Is there any chance of the database being cleared out during the move?

I appreciate that this is not a big deal and that you probably have more important issues, but it would be nice to do some clean-up. :)

Cheers


____________
D@H the greatest project in the world... a while from now!

Message boards : Number crunching : Database clear out?

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=265"
    }
  }
  [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) "265"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(2) "24"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(19) "Database clear out?"
        ["timestamp"]=>
        string(10) "1183197953"
        ["views"]=>
        string(3) "900"
        ["replies"]=>
        string(1) "1"
        ["activity"]=>
        string(20) "6.0009086719113e-119"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1182867966"
        ["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) "265"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(2) "24"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(19) "Database clear out?"
      ["timestamp"]=>
      string(10) "1183197953"
      ["views"]=>
      string(3) "900"
      ["replies"]=>
      string(1) "1"
      ["activity"]=>
      string(20) "6.0009086719113e-119"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1182867966"
      ["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=265