[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-13 Thread Markus Schuch (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16767116#comment-16767116
 ] 

Markus Schuch commented on CONNECTORS-1581:
---

Was not able to reproduce. Everything was cleaned up properly after deleting 
multiple jobs with >1.000.000 records, even when i poked around with database, 
database connection, the manifoldcf process and the outputrepo.

It is possible, that the error occured while using an older version of the 
mariadb jdbc driver (which we updated frequently in our setup), but since lack 
of time i won't invest to explore this further.

> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-12 Thread Karl Wright (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16766037#comment-16766037
 ] 

Karl Wright commented on CONNECTORS-1581:
-

It's possible that the problem is due to funkiness in MySQL.  We've had a lot 
of trouble lately because MySQL no longer seems to be properly enforcing 
transaction integrity in at least some circumstances.  OR it could be the 
open-source MySQL driver we're using; maybe that needs an upgrade?

At any rate, removal of jobqueue rows MUST precede removal of job table rows; 
there's a constraint in place in fact.  So if you get to the point where that 
constraint has been violated, you're pretty certain it's a database issue. :-(


> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-12 Thread Markus Schuch (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16766020#comment-16766020
 ] 

Markus Schuch commented on CONNECTORS-1581:
---

I checked for related data in all other tables with a jobid relation and found 
no other records.
After deleting the records from the jobqueue the error disappeared. 

Now i am testing to reproduce the situation by
- restarting / killing manifoldcf during cleanup
- restarting / killing output repository connection during cleanup
- disconnecting the database during cleanup

> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-11 Thread Markus Schuch (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765186#comment-16765186
 ] 

Markus Schuch commented on CONNECTORS-1581:
---

{quote}How did you wind up in that situation though?{quote}
I do not know. We definetly did not temper with the database manually.

I will do some tests by removing some jobs within our setup to see if i can 
reprocuce this.

> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-11 Thread Karl Wright (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765178#comment-16765178
 ] 

Karl Wright commented on CONNECTORS-1581:
-

Yes if the job ID doesn't show up anywhere it's safe to delete.
How did you wind up in that situation though?

Karl


On Mon, Feb 11, 2019 at 12:15 PM Markus Schuch (JIRA) 



> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-11 Thread Markus Schuch (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765173#comment-16765173
 ] 

Markus Schuch commented on CONNECTORS-1581:
---

{code}
select jobid, count(jobid), jobs.description from jobqueue left outer join jobs 
on jobs.id = jobqueue.jobid group by jobid;
{code}
actually returns 1 row with documents not having a existing job.
These items belong to a job that we deleted some time ago. For some reason the 
cleanup did not work properly.

[~kwri...@metacarta.com] Is it safe to delete those rows from the jobqeue table?

> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Assignee: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-08 Thread Karl Wright (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763667#comment-16763667
 ] 

Karl Wright commented on CONNECTORS-1581:
-

I am pretty concerned that the database layer is fundamentally not working 
right.  The fact that the set priority thread recovers argues that there is a 
database failure that silently resolves.  This is bizarre.

If the thread actually finally starts, then you should be good to go other than 
the concerns expressed above.


> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-08 Thread Markus Schuch (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763567#comment-16763567
 ] 

Markus Schuch commented on CONNECTORS-1581:
---

JDBC driver is mariadb javaclient 2.3.0.

I will enable {{org.apache.manifoldcf.db}} debug logging to see which job ids 
are involved.

What is the impact of this error happening in the "set priority thread"?
The exception is logged several times but then it stops and startup seems to 
complete without further problems.

We didn't see any problems so far.

> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (CONNECTORS-1581) [Set priority thread] Error tossed: null during startup

2019-02-08 Thread Karl Wright (JIRA)


[ 
https://issues.apache.org/jira/browse/CONNECTORS-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763530#comment-16763530
 ] 

Karl Wright commented on CONNECTORS-1581:
-

Here's the code that's throwing an NPE:

{code}
// Compute the list of connector instances we will need.
// This has a side effect of fetching all job descriptions too.
Set connectionNames = new HashSet();
for (int i = 0; i < descs.length; i++)
{
  DocumentDescription dd = descs[i];
  IJobDescription job = jobDescriptionMap.get(dd.getJobID());
  if (job == null)
  {
job = jobManager.load(dd.getJobID(),true);
jobDescriptionMap.put(dd.getJobID(),job);
  }
  connectionNames.add(job.getConnectionName());
}
{code}

The problem is, apparently, that jobManager.load() is coming back null.  
I have no idea why this would happen but clearly the problem has to do with the 
database implementation, perhaps the mysql driver being used?


> [Set priority thread] Error tossed: null during startup
> ---
>
> Key: CONNECTORS-1581
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1581
> Project: ManifoldCF
>  Issue Type: Bug
> Environment: •ManifoldCF 2.12, running in a Docker Container 
> based on Redhat Linux, OpenJDK 8 
> • AWS RDS Database (Aurora MySQL -> 5.6 compatible, utf8 (collation 
> utf8_bin))
> • Single Process Setup
>Reporter: Markus Schuch
>Priority: Major
>
> We see the following {{NullPointerException}} at startup:
> {code}
> [Set priority thread] FATAL org.apache.manifoldcf.crawlerthreads- Error 
> tossed: null
> java.lang.NullPointerException
> at 
> org.apache.manifoldcf.crawler.system.ManifoldCF.writeDocumentPriorities(ManifoldCF.java:1202)
> at 
> org.apache.manifoldcf.crawler.system.SetPriorityThread.run(SetPriorityThread.java:141)
> {code}
> What could be the cause of that?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)