What file does the database table creation? After getting everything installed and uploading a couple of packages I found that the copyright job isn't running. In looking at the log I see that it tries to do a select from the copyright table. I don't have this table in the db. FYI: I did the install from the RHEL5 rpm. Log snippet is posted below.
Thanks, -Matt 2010-08-13 14:04:32 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:04:32 2010 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: Could not select table copyright. Database said: "relation "copyright" does not exist at character 19" 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: Could not select table copyright. Database said: "relation "copyright" does not exist at character 19" 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: sql=SELECT ct_pk FROM copyright LIMIT 1 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: sql=SELECT ct_pk FROM copyright LIMIT 1 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed to spawn after 70 seconds 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed command was: '/usr/lib/fossology/agents/copyright/run.py --model /usr/share/fossology/model.dat --agent' 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=FREEING(2) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[13] 'agent=sqlagent host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] died prematurely (was state FREE, signal was 0) 2010-08-13 14:05:42 scheduler[8247] : Thread 7: 2010-08-13 14:05:42 scheduler[8247] : PID: 12691 2010-08-13 14:05:42 scheduler[8247] : Pipes: in=0->0 / out=0->0 2010-08-13 14:05:42 scheduler[8247] : Attr: 'agent=copyright host=localhost ' 2010-08-13 14:05:42 scheduler[8247] : Command: '/usr/lib/fossology/agents/copyright/run.py --model /usr/share/fossology/model.dat --agent' 2010-08-13 14:05:42 scheduler[8247] : Parm: '' 2010-08-13 14:05:42 scheduler[8247] : Heartbeat: Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : State: Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Status: 1 (FREE) 2010-08-13 14:05:42 scheduler[8247] : Spawn: 3 at Fri Aug 13 14:00:50 2010 2010-08-13 14:05:42 scheduler[8247] : DB: 2010-08-13 14:05:42 scheduler[8247] : IsDB: 0 2010-08-13 14:05:42 scheduler[8247] : DBJobKey: 0 2010-08-13 14:05:42 scheduler[8247] : DBMSQrow: 0 2010-08-13 14:05:42 scheduler[8247] : DBagent: 24 _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
