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 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. > -- sig MySkype (yoyo_rkn)Skype Me! <skype:yoyo_rkn?chat> , myICQ 139003243 , myIRC <irc://irc.euirc.net/rechenkraft> ------------------------------------------------------------------------ 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 <irc://irc.euirc.net/rechenkraft> ------------------------------------------------------------------------ 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 <irc://irc.euirc.net/rechenkraft> _______________________________________________ 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.
