Thanks! Now I'm using only one db_purge daemon (without --mod parameter) and it is working.
Henri. 2015-01-26 19:30 GMT+02:00 yoyo <[email protected]>: > There seems to be a space missing in "secondand". > Workaround could be to remove the --mod option. > yoyo > > Henri Heinonen schrieb: > > After updating the server software I get this: > cat db_purge_1.log > ---- > 2015-01-26 08:52:38.3242 [debug] Purged result [41508740] from database > 2015-01-26 08:52:38.4294 [debug] Purged workunit [40823137] from database > 2015-01-26 08:52:38.4295 Archived 24 workunits and 24 results > 2015-01-26 08:52:38.4295 [debug] Currently open archive files contain 43862 > workunits > 2015-01-26 08:52:38.4295 Sleeping.... > GOT STOP SIGNAL > 2015-01-26 09:00:50.4366 Quitting due to SIGHUP > 2015-01-26 09:00:50.4366 Closed archive files with 43862 workunits > [2015/01/26 09:02:52] Executing command: db_purge_1 -d 3 --no_archive > --min_age_days 0.6 --mod 3 1 > 2015-01-26 09:03:11.4415 Starting > Database error: You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > 'secondand id % 3 = 1 limit 1000' at line 1 > query=select * from workunit where file_delete_state=2 and > mod_time<current_timestamp() - interval 51840 secondand id % 3 = 1 limit > 1000 > 2015-01-26 09:03:11.4428 [debug] DB connection lost, exiting > 2015-01-26 09:03:11.4428 Closed archive files with 0 workunits > ---- > > Also, lots of red in the new status > page:http://www.bitcoinutopia.net/bitcoinutopia/server_status.php > Not so much red in the old status > page:http://www.bitcoinutopia.net/bitcoinutopia/server_status_old.php > > > Henri. > _______________________________________________ > boinc_dev mailing > [email protected]http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > > > > > -- > MySkype (yoyo_rkn)[image: Skype Me™!] , myICQ 139003243 , myIRC > ------------------------------ > Rechenkraft.net e.V. <http://www.rechenkraft.net> - Verein zur Förderung > von Bildung, Forschung und Wissenschaft durch Einsatz vernetzter Computer > weitere interessante Projekte > <http://www.rechenkraft.net/wiki/index.php?title=Projekt%C3%BCbersicht>und > Hilfe <http://www.rechenkraft.net/phpBB/viewforum.php?f=19>auf unserer > Webseite www.Rechenkraft.net <http://www.rechenkraft.net> und im Chat > ------------------------------ > Rechenkraft.net e.V. <http://www.rechenkraft.net/> - Non-profit > association for the promotion of education, research and science through > the use of networked computers > other interesting projects > <http://www.rechenkraft.net/wiki/index.php?title=Projekt%C3%BCbersicht>and > help <http://www.rechenkraft.net/phpBB/viewforum.php?f=19> on our website > www.Rechenkraft.net <http://www.rechenkraft.net> and on IRC > >
_______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
