Unable to deploy to Artifactory (HTTP Error 500)
|
View:
New views
2 Messages
—
Rating Filter:
Alert me
|
 |
Unable to deploy to Artifactory (HTTP Error 500)
by Peter Niederwieser
::
Rate this Message:
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 |
|
|
Re: Unable to deploy to Artifactory (HTTP Error 500)
by Yoav Landman
::
Rate this Message:
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 <pniederw@...> wrote:
------------------------------------------------------------------------------ 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 Artifactory-users@... https://lists.sourceforge.net/lists/listinfo/artifactory-users |
| Free embeddable forum powered by Nabble | Forum Help |
