I'm not sure how result.mod_time got marked as "not null". In any case, I changed the code to work even if this has happened. -- David
On 17-Jul-2013 9:29 PM, Kevin Vinsen wrote:
It's all working now as I manually adjusted the database. It was one I started a year or so ago. I used the migrate instructions found here - http://boinc.berkeley.edu/trac/wiki/ToolUpgrade Regards Kevin On 18/07/2013, at 12:13 PM, Bernd Machenschalk <[email protected]<mailto:[email protected]>> wrote: Your DB schema seems broken. mod_time is an automatic column that should be set by the DB itself, apparently that doesn't happen in your configuration. How did you create the new database? Best, Bernd Kevin Vinsen <[email protected]<mailto:[email protected]>> schrieb: Folks I've just migrated the POGS project to a new VPC environment in the AWS cloud. Everything started - I could added work units, the transitioner was running, but now it's failing with the following error. [2013/07/18 00:35:01] Executing command: transitioner -d 3 2013-07-18 00:35:02.1015 Starting 2013-07-18 00:35:02.1086 [debug] doing a pass 2013-07-18 00:35:02.1121 [debug] [WU#1903944 IC1339_area1956929] 2 results: unsent 0, in_progress 1, over 1 (success 0, error 0, couldnt_send 0, no_reply 1, didnt_need 0) 2013-07-18 00:35:02.1121 [WU#1903944 IC1339_area1956929] Generating 1 more results (2 target - 0 unsent - 1 in progress - 0 success) Database error: Column 'mod_time' cannot be null query=insert into result values (0, 1374107702, 1903944, 2, 0, 0, 0, 0, 0, 0, 0, 'IC1339_area1956929_2', 0.000000000000000e+00, '<file_info> <name>IC1339_area1956929_2_0</name> <generated_locally/> <upload_when_present/> <max_nbytes>5000000</max_nbytes> <url>http://pogs.theskynet.org/pogs_cgi/file_upload_handler</url><http://pogs.theskynet.org/pogs_cgi/file_upload_handler%3C/url%3E>;
<gzip_when_done/>
</file_info> <result> <file_ref> <file_name>IC1339_area1956929_2_0</file_name> <open_name>output.fit</open_name> <copy_file/> </file_ref> </result>', '', '', 0, 0, 0, 0.000000000000000e+00, 0.000000000000000e+00, 0.000000000000000e+00, 103216494, 0, 1, 0, 0, 5, null, 0, 0, 0, 0, -1) Anyone any ideas why this is happening? Regards Kevin ________________________________ boinc_dev mailing list [email protected]<mailto:[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. _______________________________________________ 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.
_______________________________________________ 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.
