Unable to deploy to Artifactory (HTTP Error 500)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Unable to deploy to Artifactory (HTTP Error 500)

Peter Niederwieser

I'm trying to deploy from Hudson to libs-snapshots-local on Artifactory 2.0.5
under the root (admin) user. However I get the exception shown below. Any
advice?

Cheers,
Peter

009-07-17 20:10:05,302 [ERROR] (o.a.j.c.p.b.u.ConnectionRecoveryManager:447)
- could not execute statement, reason: An SQL data change is not permitted
for a read-only connection, user or database., state/code: 25502/30000
2009-07-17 20:10:05,803 [ERROR]
(o.a.j.c.p.b.u.ConnectionRecoveryManager:447) - could not execute statement,
reason: An SQL data change is not permitted for a read-only connection, user
or database., state/code: 25502/30000
2009-07-17 20:10:05,804 [WARN ] (o.a.j.j.ArtifactoryDbDataStoreImpl:676) -
Can not delete records:An SQL data change is not permitted for a read-only
connection, user or database.
2009-07-17 20:10:05,804 [ERROR] (o.a.j.JcrServiceImpl:787) - Jackrabbit's
datastore garbage collector execution failed.
org.apache.jackrabbit.core.data.DataStoreException: Can not delete records:
An SQL data change is not permitted for a read-only connection, user or
database.
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.convert(ArtifactoryDbDataStoreImpl.java:681)
[artifactory-update-2.0.5.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.cleanUnreferencedItems(ArtifactoryDbDataStoreImpl.java:433)
[artifactory-update-2.0.5.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryGarbageCollector.deleteUnused(ArtifactoryGarbageCollector.java:313)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.jcr.JcrServiceImpl.garbageCollect(JcrServiceImpl.java:777)
[artifactory-core-2.0.5.jar:na]
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) [na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[na:1.6.0_07]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_07]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
[spring-aop-2.5.5.jar:2.5.5]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
[spring-aop-2.5.5.jar:2.5.5]
at $Proxy37.garbageCollect(Unknown Source) [na:na]
at
org.artifactory.jcr.schedule.JcrGarbageCollector.onExecute(JcrGarbageCollector.java:37)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.jcr.schedule.JcrGarbageCollector.onExecute(JcrGarbageCollector.java:30)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.schedule.quartz.QuartzCommand.execute(QuartzCommand.java:42)
[artifactory-core-2.0.5.jar:na]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
[quartz-1.6.3.jar:1.6.3]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
[na:1.6.0_07]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
[na:1.6.0_07]
at java.lang.Thread.run(Thread.java:619) [na:1.6.0_07]
Caused by: java.sql.SQLException: An SQL data change is not permitted for a
read-only connection, user or database.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
[derby-10.4.2.0.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:365)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:292)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:257)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:237)
[jackrabbit-core-1.4.9.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.cleanUnreferencedItems(ArtifactoryDbDataStoreImpl.java:420)
[artifactory-update-2.0.5.jar:na]
... 15 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: An SQL data change
is not permitted for a read-only connection, user or database.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) [derby-10.4.2.0.jar:na]
... 29 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: 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) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.exe.ace8afc026x0122x7e19xbceex00001173da783.fillResultSet(Unknown
Source) [na:na]
at
org.apache.derby.exe.ace8afc026x0122x7e19xbceex00001173da783.execute(Unknown
Source) [na:na]
at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
[derby-10.4.2.0.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) [derby-10.4.2.0.jar:na]
... 23 common frames omitted
--
View this message in context: http://www.nabble.com/Unable-to-deploy-to-Artifactory-%28HTTP-Error-500%29-tp24539434p24539434.html
Sent from the Artifactory-Users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Artifactory-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/artifactory-users
Reply | Threaded
Open this post in threaded view
|

Re: Unable to deploy to Artifactory (HTTP Error 500)

Yoav Landman
Administrator
Hello Peter,

The user under which Artifactory runs (not Hudson) probably doesn't have write permissions on the data files under $ARTIFACTORY_HOME/data.
It typically happens if Artifactory was started once as root, by mistake - this changes the ownership on storage files, so they become read-only for Artifactory  when being run under a less powerful user.

HTH,

Yoav

On Fri, Jul 17, 2009 at 10:25 PM, Peter Niederwieser <[hidden email]> wrote:

I'm trying to deploy from Hudson to libs-snapshots-local on Artifactory 2.0.5
under the root (admin) user. However I get the exception shown below. Any
advice?

Cheers,
Peter

009-07-17 20:10:05,302 [ERROR] (o.a.j.c.p.b.u.ConnectionRecoveryManager:447)
- could not execute statement, reason: An SQL data change is not permitted
for a read-only connection, user or database., state/code: 25502/30000
2009-07-17 20:10:05,803 [ERROR]
(o.a.j.c.p.b.u.ConnectionRecoveryManager:447) - could not execute statement,
reason: An SQL data change is not permitted for a read-only connection, user
or database., state/code: 25502/30000
2009-07-17 20:10:05,804 [WARN ] (o.a.j.j.ArtifactoryDbDataStoreImpl:676) -
Can not delete records:An SQL data change is not permitted for a read-only
connection, user or database.
2009-07-17 20:10:05,804 [ERROR] (o.a.j.JcrServiceImpl:787) - Jackrabbit's
datastore garbage collector execution failed.
org.apache.jackrabbit.core.data.DataStoreException: Can not delete records:
An SQL data change is not permitted for a read-only connection, user or
database.
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.convert(ArtifactoryDbDataStoreImpl.java:681)
[artifactory-update-2.0.5.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.cleanUnreferencedItems(ArtifactoryDbDataStoreImpl.java:433)
[artifactory-update-2.0.5.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryGarbageCollector.deleteUnused(ArtifactoryGarbageCollector.java:313)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.jcr.JcrServiceImpl.garbageCollect(JcrServiceImpl.java:777)
[artifactory-core-2.0.5.jar:na]
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) [na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[na:1.6.0_07]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_07]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
[spring-aop-2.5.5.jar:2.5.5]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
[spring-aop-2.5.5.jar:2.5.5]
at $Proxy37.garbageCollect(Unknown Source) [na:na]
at
org.artifactory.jcr.schedule.JcrGarbageCollector.onExecute(JcrGarbageCollector.java:37)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.jcr.schedule.JcrGarbageCollector.onExecute(JcrGarbageCollector.java:30)
[artifactory-core-2.0.5.jar:na]
at
org.artifactory.schedule.quartz.QuartzCommand.execute(QuartzCommand.java:42)
[artifactory-core-2.0.5.jar:na]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
[quartz-1.6.3.jar:1.6.3]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
[na:1.6.0_07]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
[na:1.6.0_07]
at java.lang.Thread.run(Thread.java:619) [na:1.6.0_07]
Caused by: java.sql.SQLException: An SQL data change is not permitted for a
read-only connection, user or database.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
[derby-10.4.2.0.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:365)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:292)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:257)
[jackrabbit-core-1.4.9.jar:na]
at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:237)
[jackrabbit-core-1.4.9.jar:na]
at
org.artifactory.jcr.jackrabbit.ArtifactoryDbDataStoreImpl.cleanUnreferencedItems(ArtifactoryDbDataStoreImpl.java:420)
[artifactory-update-2.0.5.jar:na]
... 15 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: An SQL data change
is not permitted for a read-only connection, user or database.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) [derby-10.4.2.0.jar:na]
... 29 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: 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) [derby-10.4.2.0.jar:na]
at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown
Source) [derby-10.4.2.0.jar:na]
at
org.apache.derby.exe.ace8afc026x0122x7e19xbceex00001173da783.fillResultSet(Unknown
Source) [na:na]
at
org.apache.derby.exe.ace8afc026x0122x7e19xbceex00001173da783.execute(Unknown
Source) [na:na]
at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
[derby-10.4.2.0.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) [derby-10.4.2.0.jar:na]
... 23 common frames omitted
--
View this message in context: http://www.nabble.com/Unable-to-deploy-to-Artifactory-%28HTTP-Error-500%29-tp24539434p24539434.html
Sent from the Artifactory-Users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Artifactory-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/artifactory-users


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Artifactory-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/artifactory-users