archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deng Ching <och...@apache.org>
Subject Re: Exceptions when purging repository
Date Tue, 08 Dec 2009 03:56:21 GMT
Hi Ben,

Does the error still persist even if Archiva is re-started?

Thanks,
Deng

On Mon, Dec 7, 2009 at 8:30 PM, Ben Lidgey <BLidgey@movenetworks.com> wrote:

> Hi
>
> We are getting exceptions when the repository purge is taking place where
> it cannot delete artifacts as it thinks the database connection is
> read-only:
>
> javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM
> SA.ARCHIVA_ARTIFACT WHERE ARTIFACT_ID = ? AND CLASSIFIER = ? AND GROUP_ID =
> ? AND REPOSITORY_ID = ? AND FILE_TYPE = ? AND VERSION = ?
> at
> org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:288)
>        at
> org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611)
>
> [snip]
>
> NestedThrowablesStackTrace:
> ERROR 25502: An SQL data change is not permitted for a read-only
> connection, user or database.
>        at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>
>
> Has anyone seen this before? I can't find any docs or related issues. We
> are running Archiva 1.2.2 in Tomcat 5.5.17 using the Derby databases. The
> archiva instance is configured in Tomcat conf/Catalina/localhost/archiva.xml
> as follows:
>
> <?xml version="1.0" encoding="UTF-8"?>
>  <Context path="/archiva"
>          docBase="${catalina.home}/archiva/apache-archiva-CURRENT.war">
>
>  <Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource"
>           username="sa"
>           password=""
>           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>
> url="jdbc:derby:/home/devadmin/data/maven/archiva/database/users;create=true"
> />
>
>  <Resource name="jdbc/archiva" auth="Container" type="javax.sql.DataSource"
>           username="sa"
>           password=""
>           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>
> url="jdbc:derby:/home/devadmin/data/maven/archiva/database/archiva;create=true"
> />
>
>  <Resource name="mail/Session" auth="Container"
>            type="javax.mail.Session"
>            mail.smtp.host="localhost"/>
>  </Context>
>
>
> Thanks
>
> Ben

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