Hi Olivier,

 

we were not able to fix this yet.

 

But now we have new diagnostics log data, after the error occurred again yesterday:

 

Unexpected jobqueue status - record id 1522147023170, expecting active status, saw 4

https://gist.githubusercontent.com/schuch/16f617eed064b004cb69a2f929b08ca8/raw/46b9585bf73bb7eaf5e3b28aeb87610525afc9ca/Unexpected%2520jobqueue%2520status%2520-%2520record%2520id%25201522147023170,%2520expecting%2520active%2520status,%2520saw%25204

 

Unexpected jobqueue status - record id 1541529864711, expecting active status, saw 4

https://gist.githubusercontent.com/schuch/d73672e44b0edd5a9184170c9ee417a5/raw/f55b1c023056ef8e310d99489a0b6f9dfcaaa585/Unexpected%2520jobqueue%2520status%2520-%2520record%2520id%25201541529864711,%2520expecting%2520active%2520status,%2520saw%25204

 

@Karl, maybe you can get some ideas from that log data?

 

Cheers,

Markus

 

Von: Olivier Tavard <olivier.tavard@francelabs.com>
Gesendet: Dienstag, 21. Mai 2019 11:00
An: user@manifoldcf.apache.org
Betreff: Re: Error: Unexpected jobqueue status - record id X, expecting active status, saw 4 (MySQL compatible Database)

 

Hi Markus,

 

We have the same error (with postgresql database). Did the error occur again since your last mail ?

Did you change something on your MCF configuration to fix this ?

 

Thanks,

Best regards,

 

Olivier 

 



Le 13 févr. 2019 à 13:58, Markus Schuch <markus.schuch@deutschebahn.com> a écrit :

 

Hi Karl,

 

we set the diagnostigs logger to level debug.

 

I will get back when the error occurs again.

 

Cheers,

Markus

 



Pflichtangaben anzeigen

Nähere Informationen zur Datenverarbeitung im DB-Konzern finden Sie hier: 
http://www.deutschebahn.com/de/konzern/datenschutz

 

Le 12 févr. 2019 à 17:41, Karl Wright <daddywri@gmail.com> a écrit :

 

Hi Marcus,

 

There's a properties.xml debugging logger you can enable that will keep track of what's happening with transactions, so that when an error of this kinds is reported, information about why the situation is unexpected is dumped to the log.  The logger is called "diagnostics" e.g. "org.apache.manifoldcf.diagnostics".

 

Karl

 

 

On Tue, Feb 12, 2019 at 10:53 AM Markus Schuch <markus.schuch@deutschebahn.com> wrote:

Hi,

we are seeing "Error: Unexpected jobqueue status - record id 1484612513829, expecting active status, saw 4" from time to time.
I didn’t report it, because we were running on an old MCF version, and there were some bugreports relating to this error that are resolved in newer versions.

Now we have upgraded to latest and greatest and the error still occurred. So want to start to track this down.

Out setup is:

  • ManifoldCF 2.12, running in a Docker Container based on Redhat Linux, OpenJDK 8
  • AWS RDS Database (Aurora MySQL -> 5.6 compatible)
  • Single Process Setup


We run several Jobs (run once mode) over night with schedule windows and max runtime settings. Some of the time windows are overlapping.
At normal days some Jobs finish during their time window, some go to WAITING and will go on in the next night.

The error mostly hits at a Sharepoint Repository Job.
We have the impression, that the error is somehow related to situations, when service interruptions (e.g. connection issues) occur in other jobs.

 

Maybe all this is related to fundamental problems with the database or the JDBC driver

(Karl expressed his concerns about that in the maybe-related https://issues.apache.org/jira/browse/CONNECTORS-1581 ticket)

On the other hand, there were similar bugreports in the past concerning unexpected jobqueue status and there were resolved.

Mayby there is a chance this can also be analyzed and fixed, but I do not really know where to start.


Has anybody ideas how we can track this down / debug this to get to the bottom of the problem?
What could be the first step in the analysis?

Many thanks in advance
Markus

May be related bugreports:

 

[0] https://issues.apache.org/jira/browse/CONNECTORS-1395
[1] https://issues.apache.org/jira/browse/CONNECTORS-1180
[2] https://issues.apache.org/jira/browse/CONNECTORS-590
[3] https://issues.apache.org/jira/browse/CONNECTORS-246

 

--

Markus Schuch

Web Business (T.IPB 26)

 

DB Systel GmbH

Jürgen-Ponto-Platz 1, 60329 Frankfurt a. Main

 



Pflichtangaben anzeigen

Nähere Informationen zur Datenverarbeitung im DB-Konzern finden Sie hier: http://www.deutschebahn.com/de/konzern/datenschutz

 




Pflichtangaben anzeigen

Nähere Informationen zur Datenverarbeitung im DB-Konzern finden Sie hier: http://www.deutschebahn.com/de/konzern/datenschutz