archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Porter <br...@apache.org>
Subject Re: Archiva 1.3.4 DB error for
Date Fri, 25 Mar 2011 06:22:41 GMT
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
View raw message