search

yaobinshi / test1

test for scratch
MIT License
0 stars 0 forks source link

db errors during upload from url #213

Open yaobinshi opened 9 years ago

yaobinshi commented 9 years ago

Author Name: Mark Donohoe Original Redmine Issue: 129, http://www.fossology.org/issues/129 Original Date: 2011/12/17 Original Assignee: Alex Norton

While uploading from url the file RedHat.tar.gz from fonightly.usa.hp.com/~markd, I was watching the fososlogy log and items like this appeared:

2011-12-16 11:12:16 scheduler [8629] :: JOB[27].ununpack[8926]: agent status changed: AG_SPAWNED -> AG_RUNNING 2011-12-16 11:12:46 scheduler [8629] :: ERROR 0�g.6: failed to perform database exec 2011-12-16 11:12:46 scheduler [8629] :: ERROR sql: " Update jobqueue SET jq_itemsprocessed = 27 WHERE jq_pk = '5923';" 2011-12-16 11:12:46 scheduler [8629] :: ERROR postgresql error: ERROR: column "jq_itemsprocessed" of relation "jobqueue" does not exist 2011-12-16 11:12:46 scheduler [8629] :: LINE 1: Update jobqueue SET jq_itemsprocessed = 27 W... 2011-12-16 11:12:46 scheduler [8629] :: ^ 2011-12-16 11:13:16 scheduler [8629] :: ERROR 0�g.6: failed to perform database exec 2011-12-16 11:13:16 scheduler [8629] :: ERROR sql: " Update jobqueue SET jq_itemsprocessed = 27 WHERE jq_pk = '15158';" 2011-12-16 11:13:16 scheduler [8629] :: ERROR postgresql error: ERROR: column "jq_itemsprocessed" of relation "jobqueue" does not exist 2011-12-16 11:13:16 scheduler [8629] :: LINE 1: Update jobqueue SET jq_itemsprocessed = 27 W... 2011-12-16 11:13:16 scheduler [8629] :: ^ 2011-12-16 11:13:26 scheduler [8629] :: SIGNALS: received sigchld for pid 8926 2011-12-16 11:13:26 scheduler [8629] :: JOB[27].ununpack[8926]: successfully removed from the system 2011-12-16 11:13:26 scheduler [8629] :: JOB[27]: job status changed: JOB_STARTED => JOB_COMPLETE

It looks like some code has not been updated to the new jobq tables?

This was done using svn rev: 5260, on snape.ostt.

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Bob Gobeille Original Date: 2011/12/18 18:41:16 +0000

I do not see these errors on svn 5261. Has this been fixed?

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Mary Laser Original Date: 2011/12/20 00:01:20 +0000

mark is trying to reproduce

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Mark Donohoe Original Date: 2012/01/13 18:24:30 +0000

Alex,

I am no longer seeing these messages, but with the latest code: svn rev: 5390, on 4privet, deleteing a file resulting in these messages in the fossology log, but the upload appears to have been removed.

2012-01-13 04:13:23 scheduler [3743] :: ERROR database.c.324: unable to select the upload id for job 160 2012-01-13 04:13:23 scheduler [3743] :: ERROR postgresql error: 2012-01-13 04:13:23 scheduler [3743] :: ERROR database.c.324: unable to select the upload id for job 160 2012-01-13 04:13:23 scheduler [3743] :: ERROR postgresql error:

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Mark Donohoe Original Date: 2012/01/13 18:51:02 +0000

One more thing, the scheduler died after that error, it was no longer running when I uploaded the next job, restart it and the new job was processed.

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Alex Norton Original Date: 2012/01/13 21:38:04 +0000

Mark Donohoe wrote:

2012-01-13 04:13:23 scheduler [3743] :: ERROR database.c.324: unable to select the upload id for job 160 2012-01-13 04:13:23 scheduler [3743] :: ERROR postgresql error: 2012-01-13 04:13:23 scheduler [3743] :: ERROR database.c.324: unable to select the upload id for job 160 2012-01-13 04:13:23 scheduler [3743] :: ERROR postgresql error:

These were related to issue 375 and should be fixed that this point. Other than this I don't believe the scheduler is a having this error anymore so I'm moving it to resolved.

yaobinshi commented 9 years ago

Original Redmine Comment Author Name: Mark Donohoe Original Date: 2012/01/20 00:08:21 +0000

This has been verified and I will close it.