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 > >> br...@apache.org > >> http://brettporter.wordpress.com/ > >> http://au.linkedin.com/in/brettporter > >> > >> > >> > >> > >> > > -- > Brett Porter > br...@apache.org > http://brettporter.wordpress.com/ > http://au.linkedin.com/in/brettporter > > > > >
