You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by "L. J." <ap...@gmail.com> on 2011/03/25 02:10:53 UTC

Archiva 1.3.4 DB error for

After upgrading to 1.3.4 standalone with fresh DB, I am seeing the following
every time it runs"Database - Unprocessed Artifacts Scanning", is this
normal? anyone has the similar issue?


2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
- Executing task from queue with job name: DatabaseTask
2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
- Task: Updating unprocessed artifacts
2011-03-24 18:08:21,317 [Thread-15] ERROR taskQueueExecutor#database-update
- Error executing task
edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
javax.jdo.JDODataStoreException: Failed to read the result set : ResultSet
not open. Operation 'next' not permitted. Verify that autocommit is OFF.
ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify that
autocommit is OFF.
        at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
        at
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
        at
org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
        at
org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
        at
org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
        at
org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
        at
org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
        at
org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
        at
org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
        at
org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
        at
edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
        at java.lang.Thread.run(Thread.java:595)

        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
        at
org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.waitForTask(ThreadedTaskQueueExecutor.java:159)
        at
org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:127)
Caused by: javax.jdo.JDODataStoreException: Failed to read the result set :
ResultSet not open. Operation 'next' not permitted. Verify that autocommit
is OFF.
ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify that
autocommit is OFF.
        at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
        at
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
        at
org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
        at
org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
        at
org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
        at
org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
        at
org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
        at
org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
        at
org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
        at
org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
        at
edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
        at java.lang.Thread.run(Thread.java:595)

        at
org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:155)
        at
org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
        at
org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
        at
org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
        at
org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
        at
org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
        at
org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
        at
org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
        at
org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
        at
org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
        at
org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
        at
edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
        at java.lang.Thread.run(Thread.java:595)

Re: Archiva 1.3.4 DB error for

Posted by Brett Porter <br...@apache.org>.
On 25/03/2011, at 7:52 PM, L. J. wrote:

> Yes, did the fresh install a couple of times before reporting this error.

In that case I'm uncertain. Could you consider using a different database (H2, Postgres, MySQL)?


- Brett

--
Brett Porter
brett@apache.org
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter

Re: Archiva 1.3.4 DB error for

Posted by "L. J." <ap...@gmail.com>.
Yes, did the fresh install a couple of times before reporting this error.

On Thu, Mar 24, 2011 at 11:22 PM, Brett Porter <br...@apache.org> wrote:

> That's a result of it not running properly, yes.
>
> Can you try deleting the database and rescanning the repository to see if
> it self-corrects?
>
> - Brett
>
> On 25/03/2011, at 4:10 PM, L. J. wrote:
>
> > Not sure what are the side effects, but all the followings show blank
> after
> > searching most of the artfacts
> >
> > Dependencies | Dependency Tree | Used By | Mailing Lists
> >
> > Is this normal?
> >
> > On Thu, Mar 24, 2011 at 8:05 PM, Brett Porter <br...@apache.org> wrote:
> >
> >> I haven't seen it - are you suffering any negative side effects?
> >>
> >> On 25/03/2011, at 12:10 PM, L. J. wrote:
> >>
> >>> After upgrading to 1.3.4 standalone with fresh DB, I am seeing the
> >> following
> >>> every time it runs"Database - Unprocessed Artifacts Scanning", is this
> >>> normal? anyone has the similar issue?
> >>>
> >>>
> >>> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> >>>
> >>
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> >>> - Executing task from queue with job name: DatabaseTask
> >>> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> >>>
> >>
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> >>> - Task: Updating unprocessed artifacts
> >>> 2011-03-24 18:08:21,317 [Thread-15] ERROR
> >> taskQueueExecutor#database-update
> >>> - Error executing task
> >>> edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
> >>> javax.jdo.JDODataStoreException: Failed to read the result set :
> >> ResultSet
> >>> not open. Operation 'next' not permitted. Verify that autocommit is
> OFF.
> >>> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
> >> that
> >>> autocommit is OFF.
> >>>       at
> >>> org.apache.derby.iapi.error.StandardException.newException(Unknown
> >> Source)
> >>>       at
> >>>
> >>
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> >>> Source)
> >>>       at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> >>> Source)
> >>>       at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> >>>       at
> >>>
> >>
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >>>       at
> >>>
> >>
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >>>       at java.lang.Thread.run(Thread.java:595)
> >>>
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
> >>>       at
> >>>
> >>
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.waitForTask(ThreadedTaskQueueExecutor.java:159)
> >>>       at
> >>>
> >>
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:127)
> >>> Caused by: javax.jdo.JDODataStoreException: Failed to read the result
> set
> >> :
> >>> ResultSet not open. Operation 'next' not permitted. Verify that
> >> autocommit
> >>> is OFF.
> >>> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
> >> that
> >>> autocommit is OFF.
> >>>       at
> >>> org.apache.derby.iapi.error.StandardException.newException(Unknown
> >> Source)
> >>>       at
> >>>
> >>
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> >>> Source)
> >>>       at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> >>> Source)
> >>>       at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> >>>       at
> >>>
> >>
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >>>       at
> >>>
> >>
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >>>       at java.lang.Thread.run(Thread.java:595)
> >>>
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:155)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >>>       at
> >>>
> >>
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >>>       at
> >>>
> >>
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >>>       at
> >>>
> >>
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >>>       at
> >>>
> >>
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >>>       at
> >>>
> >>
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >>>       at java.lang.Thread.run(Thread.java:595)
> >>
> >> --
> >> Brett Porter
> >> brett@apache.org
> >> http://brettporter.wordpress.com/
> >> http://au.linkedin.com/in/brettporter
> >>
> >>
> >>
> >>
> >>
>
> --
> Brett Porter
> brett@apache.org
> http://brettporter.wordpress.com/
> http://au.linkedin.com/in/brettporter
>
>
>
>
>

Re: Archiva 1.3.4 DB error for

Posted by Brett Porter <br...@apache.org>.
That's a result of it not running properly, yes.

Can you try deleting the database and rescanning the repository to see if it self-corrects?

- Brett

On 25/03/2011, at 4:10 PM, L. J. wrote:

> Not sure what are the side effects, but all the followings show blank after
> searching most of the artfacts
> 
> Dependencies | Dependency Tree | Used By | Mailing Lists
> 
> Is this normal?
> 
> On Thu, Mar 24, 2011 at 8:05 PM, Brett Porter <br...@apache.org> wrote:
> 
>> I haven't seen it - are you suffering any negative side effects?
>> 
>> On 25/03/2011, at 12:10 PM, L. J. wrote:
>> 
>>> After upgrading to 1.3.4 standalone with fresh DB, I am seeing the
>> following
>>> every time it runs"Database - Unprocessed Artifacts Scanning", is this
>>> normal? anyone has the similar issue?
>>> 
>>> 
>>> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
>>> 
>> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
>>> - Executing task from queue with job name: DatabaseTask
>>> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
>>> 
>> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
>>> - Task: Updating unprocessed artifacts
>>> 2011-03-24 18:08:21,317 [Thread-15] ERROR
>> taskQueueExecutor#database-update
>>> - Error executing task
>>> edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
>>> javax.jdo.JDODataStoreException: Failed to read the result set :
>> ResultSet
>>> not open. Operation 'next' not permitted. Verify that autocommit is OFF.
>>> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
>> that
>>> autocommit is OFF.
>>>       at
>>> org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>>>       at
>>> 
>> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
>>> Source)
>>>       at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
>>> Source)
>>>       at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>>>       at
>>> 
>> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>>>       at
>>> 
>> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>>>       at
>>> 
>> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>>>       at
>>> 
>> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>>>       at
>>> 
>> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>>>       at java.lang.Thread.run(Thread.java:595)
>>> 
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
>>>       at
>>> 
>> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.waitForTask(ThreadedTaskQueueExecutor.java:159)
>>>       at
>>> 
>> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:127)
>>> Caused by: javax.jdo.JDODataStoreException: Failed to read the result set
>> :
>>> ResultSet not open. Operation 'next' not permitted. Verify that
>> autocommit
>>> is OFF.
>>> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
>> that
>>> autocommit is OFF.
>>>       at
>>> org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>>>       at
>>> 
>> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
>>> Source)
>>>       at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
>>> Source)
>>>       at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>>>       at
>>> 
>> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>>>       at
>>> 
>> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>>>       at
>>> 
>> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>>>       at
>>> 
>> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>>>       at
>>> 
>> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>>>       at java.lang.Thread.run(Thread.java:595)
>>> 
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:155)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>>>       at
>>> 
>> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>>>       at
>>> 
>> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>>>       at
>>> 
>> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>>>       at
>>> 
>> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>>>       at
>>> 
>> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>>>       at
>>> 
>> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>>>       at
>>> 
>> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>>>       at
>>> 
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>>>       at java.lang.Thread.run(Thread.java:595)
>> 
>> --
>> Brett Porter
>> brett@apache.org
>> http://brettporter.wordpress.com/
>> http://au.linkedin.com/in/brettporter
>> 
>> 
>> 
>> 
>> 

--
Brett Porter
brett@apache.org
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter

Re: Archiva 1.3.4 DB error for

Posted by "L. J." <ap...@gmail.com>.
Not sure what are the side effects, but all the followings show blank after
searching most of the artfacts

Dependencies | Dependency Tree | Used By | Mailing Lists

Is this normal?

On Thu, Mar 24, 2011 at 8:05 PM, Brett Porter <br...@apache.org> wrote:

> I haven't seen it - are you suffering any negative side effects?
>
> On 25/03/2011, at 12:10 PM, L. J. wrote:
>
> > After upgrading to 1.3.4 standalone with fresh DB, I am seeing the
> following
> > every time it runs"Database - Unprocessed Artifacts Scanning", is this
> > normal? anyone has the similar issue?
> >
> >
> > 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> >
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> > - Executing task from queue with job name: DatabaseTask
> > 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> >
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> > - Task: Updating unprocessed artifacts
> > 2011-03-24 18:08:21,317 [Thread-15] ERROR
> taskQueueExecutor#database-update
> > - Error executing task
> > edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
> > javax.jdo.JDODataStoreException: Failed to read the result set :
> ResultSet
> > not open. Operation 'next' not permitted. Verify that autocommit is OFF.
> > ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
> that
> > autocommit is OFF.
> >        at
> > org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> >        at
> >
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> > Source)
> >        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> > Source)
> >        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> >        at
> >
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >        at
> >
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >        at
> >
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >        at
> >
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >        at
> >
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >        at
> >
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >        at
> >
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >        at java.lang.Thread.run(Thread.java:595)
> >
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
> >        at
> >
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.waitForTask(ThreadedTaskQueueExecutor.java:159)
> >        at
> >
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:127)
> > Caused by: javax.jdo.JDODataStoreException: Failed to read the result set
> :
> > ResultSet not open. Operation 'next' not permitted. Verify that
> autocommit
> > is OFF.
> > ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify
> that
> > autocommit is OFF.
> >        at
> > org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> >        at
> >
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> > Source)
> >        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> > Source)
> >        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> >        at
> >
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >        at
> >
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >        at
> >
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >        at
> >
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >        at
> >
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >        at
> >
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >        at
> >
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >        at java.lang.Thread.run(Thread.java:595)
> >
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:155)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
> >        at
> >
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
> >        at
> >
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
> >        at
> >
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
> >        at
> >
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
> >        at
> >
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
> >        at
> >
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
> >        at
> >
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> >        at
> >
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> >        at
> >
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> >        at java.lang.Thread.run(Thread.java:595)
>
> --
> Brett Porter
> brett@apache.org
> http://brettporter.wordpress.com/
> http://au.linkedin.com/in/brettporter
>
>
>
>
>

Re: Archiva 1.3.4 DB error for

Posted by Brett Porter <br...@apache.org>.
I haven't seen it - are you suffering any negative side effects?

On 25/03/2011, at 12:10 PM, L. J. wrote:

> After upgrading to 1.3.4 standalone with fresh DB, I am seeing the following
> every time it runs"Database - Unprocessed Artifacts Scanning", is this
> normal? anyone has the similar issue?
> 
> 
> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> - Executing task from queue with job name: DatabaseTask
> 2011-03-24 18:08:00,018 [pool-1-thread-1] INFO
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor
> - Task: Updating unprocessed artifacts
> 2011-03-24 18:08:21,317 [Thread-15] ERROR taskQueueExecutor#database-update
> - Error executing task
> edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
> javax.jdo.JDODataStoreException: Failed to read the result set : ResultSet
> not open. Operation 'next' not permitted. Verify that autocommit is OFF.
> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify that
> autocommit is OFF.
>        at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>        at
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> Source)
>        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
>        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>        at
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>        at
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>        at
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>        at
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>        at
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>        at
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>        at
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>        at
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>        at java.lang.Thread.run(Thread.java:595)
> 
>        at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
>        at
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.waitForTask(ThreadedTaskQueueExecutor.java:159)
>        at
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:127)
> Caused by: javax.jdo.JDODataStoreException: Failed to read the result set :
> ResultSet not open. Operation 'next' not permitted. Verify that autocommit
> is OFF.
> ERROR XCL16: ResultSet not open. Operation 'next' not permitted. Verify that
> autocommit is OFF.
>        at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>        at
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> Source)
>        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
>        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>        at
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:148)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>        at
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>        at
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>        at
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>        at
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>        at
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>        at
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>        at
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>        at java.lang.Thread.run(Thread.java:595)
> 
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:155)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult$QueryResultIterator.next(ForwardQueryResult.java:300)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:130)
>        at
> org.jpox.store.rdbms.query.ForwardQueryResult.closingConnection(ForwardQueryResult.java:191)
>        at
> org.jpox.AbstractPersistenceManager.notifyQueriesOfConnectionClose(AbstractPersistenceManager.java:3622)
>        at
> org.jpox.AbstractPersistenceManager.preRollback(AbstractPersistenceManager.java:3634)
>        at
> org.jpox.store.rdbms.RDBMSNonmanagedTransaction.rollback(RDBMSNonmanagedTransaction.java:495)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.rollbackIfActive(JdoAccess.java:528)
>        at
> org.apache.maven.archiva.database.jdo.JdoAccess.queryObjects(JdoAccess.java:244)
>        at
> org.apache.maven.archiva.database.jdo.JdoArtifactDAO.queryArtifacts(JdoArtifactDAO.java:89)
>        at
> org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:74)
>        at
> org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
>        at
> org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
>        at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
>        at java.lang.Thread.run(Thread.java:595)

--
Brett Porter
brett@apache.org
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter