Results 1 to 32 of 32

Thread: Database problem?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    369
    Quote Originally Posted by Bok View Post
    So WEP is missing for you?
    Not missing, WEP was flipping to and fro round 1,000,000 credits yesterday -both servers not picking up DHEP's last update, which would give me yet another 1,000,000+ credits project.


  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,493
    Blog Entries
    13
    Well that sounds exactly like the issue I mentioned above where one database was not being updated. Is it ok today?

  3. #3
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    369
    It is much better, only DHEP (Distr. Hardware Evolution) still refuses to update


  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,493
    Blog Entries
    13
    the db_dump.xml file is giving a 403 error

    -bash-4.2$ wget http://dhep.ga/boinc/stats/db_dump.xml
    --2018-12-07 14:04:34-- http://dhep.ga/boinc/stats/db_dump.xml
    Resolving dhep.ga (dhep.ga)... 139.184.49.229
    Connecting to dhep.ga (dhep.ga)|139.184.49.229|:80... connected.
    HTTP request sent, awaiting response... 301 Moved Permanently
    Location: https://www.dhep.ga/boinc/stats/db_dump.xml [following]
    --2018-12-07 14:04:34-- https://www.dhep.ga/boinc/stats/db_dump.xml
    Resolving www.dhep.ga (www.dhep.ga)... 139.184.49.229
    Connecting to www.dhep.ga (www.dhep.ga)|139.184.49.229|:443... connected.
    HTTP request sent, awaiting response... 403 Forbidden
    2018-12-07 14:04:35 ERROR 403: Forbidden.


    I've asked Michael to take a look. I can work around that if need be as it doesn't really change.

  5. #5
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,493
    Blog Entries
    13
    the db_dump.xml file is giving a 403 error

    -bash-4.2$ wget http://dhep.ga/boinc/stats/db_dump.xml
    --2018-12-07 14:04:34-- http://dhep.ga/boinc/stats/db_dump.xml
    Resolving dhep.ga (dhep.ga)... 139.184.49.229
    Connecting to dhep.ga (dhep.ga)|139.184.49.229|:80... connected.
    HTTP request sent, awaiting response... 301 Moved Permanently
    Location: https://www.dhep.ga/boinc/stats/db_dump.xml [following]
    --2018-12-07 14:04:34-- https://www.dhep.ga/boinc/stats/db_dump.xml
    Resolving www.dhep.ga (www.dhep.ga)... 139.184.49.229
    Connecting to www.dhep.ga (www.dhep.ga)|139.184.49.229|:443... connected.
    HTTP request sent, awaiting response... 403 Forbidden
    2018-12-07 14:04:35 ERROR 403: Forbidden.


    I've asked Michael to take a look. I can work around that if need be as it doesn't really change.

  6. #6
    Quote Originally Posted by Dirk Broer View Post
    Not missing, WEP was flipping to and fro round 1,000,000 credits yesterday -both servers not picking up DHEP's last update, which would give me yet another 1,000,000+ credits project.
    NFS is doing this too. An update with values for the day, then later everyone has zeros.

  7. #7
    Multiple people with the same rank on E@H. Team Overclock.net. Team credit is out of order as well but its by the default sort.
    https://imgur.com/a/bX03KSL

    Other teams are also showing similar things.

  8. #8
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,493
    Blog Entries
    13
    I had a feeling this would happen...it's due to the new option at Einstein@Home where users have to opt-in to have their data exported for the 3rd party stats, they have just enabled it by the looks of it and I'm showing the #users in the xml has dropped from ~469,000 to just 2619!!!!

    Code:
    MariaDB [dcfree]> select active_this_run,count(*) from boinc_user where proj = 'eah' group by active_this_run;
    +-----------------+----------+
    | active_this_run | count(*) |
    +-----------------+----------+
    |            7269 |        1 |
    |            7270 |   466126 |
    |            7272 |     2619 |
    +-----------------+----------+
    3 rows in set (1 min 11.18 sec)
    Luckily I've deferred the automatic deletion of users which we are supposed to do, which is why the projranks and such are messed up but this is a total mess....

  9. #9
    Ah yeah. Makes sense. I had just went in and enabled stats export at LHC for this as well so I'm guessing stats will be garbled for that project at some point.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •