You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by Ben Lidgey <BL...@movenetworks.com> on 2009/12/07 13:30:30 UTC

Exceptions when purging repository

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

Re: Exceptions when purging repository

Posted by "ben.lidgey" <be...@lidgey.co.uk>.
Hi Deng

A restart seems to have fixed it.

Ben


Deng Ching-2 wrote:
> 
> Hi Ben,
> 
> Does the error still persist even if Archiva is re-started?
> 
> Thanks,
> Deng
> 
> 

-- 
View this message in context: http://old.nabble.com/Exceptions-when-purging-repository-tp26687668p26690744.html
Sent from the archiva-users mailing list archive at Nabble.com.

Re: Exceptions when purging repository

Posted by Deng Ching <oc...@apache.org>.
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 <BL...@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