just a short notice to answer my own question, without further
importance:
So my question: what is the sql-command to find those 6 jobs in the database?
The command "select id from job where status=0" shows 13 jobs, and modifying
their status does not change the "6 jobs queued" in the UI.
It turned out that those 6 jobs QUEUED (status=0) where 6 jobs
INSTANTIATED (status=6); deleting those from the DB or stopping the
workflows with the REST-interface made them disappear from the UI
statistics tab.
Regards, Andreas
Andreas Krieger schrieb am Tue, 4 Sep 2012 betreff "MH 1.3.1 hangs on...":
Hi,
we upgraded MH 1.3.0 to MH 1.3.1 following Gregs recommendations on
http://opencast.jira.com/wiki/display/MHDOC/Upgrading+Matterhorn+v+1.3 .
Now we have a stalled system, any upload/ingest will hang forever with status
"Initializing"; if I suspend and resume the workflow, it goes to "Inspecting
Media Package" but stalls there also (no log entry about inspecting).
The log files dont show much; just these 2 lines when ingesting an mp4 file:
2012-09-04 12:28:44 INFO (IngestServiceImpl:829) - Adding element of type
Track to mediapackage f6160b6b-d65f-40a7-ba34-8e98db23cf81
2012-09-04 12:28:44 INFO (IngestServiceImpl:829) - Adding element of type
Catalog to mediapackage f6160b6b-d65f-40a7-ba34-8e98db23cf81
On the Statistics tab I see that there are 6 jobs queued, so one of the
suspects is that there is something wrong with the db-entries;
So my question: what is the sql-command to find those 6 jobs in the database?
The command "select id from job where status=0" shows 13 jobs, and modifying
their status does not change the "6 jobs queued" in the UI.
Any help/experiences appreciated on where to push/pull to get the system
running again.
Regards, Andreas
-----------------------
[email protected]
01/58801 DW 41523
mobil: 0664/60 588 4523
TU Wien
DVR-Nummer: 0005886
-----------------------
-----------------------
BSc [email protected]
01/58801 DW 41523
mobil: 0664/60 588 4523
TU Wien
DVR-Nummer: 0005886
-----------------------
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
