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
