archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "L. J." <apache.maill...@gmail.com>
Subject Re: Archiva 1.3.4 DB error for
Date Fri, 25 Mar 2011 08:52:15 GMT
Yes, did the fresh install a couple of times before reporting this error.

On Thu, Mar 24, 2011 at 11:22 PM, Brett Porter <brett@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 <brett@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
>
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message