SQL exception
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
SQL exception
by Patrick Petermair
::
Rate this Message:
Hi!
We are getting strange exceptions at start-up with the artifactory installation at one of our customers. Anyone know how to fix this or what it means? 2008-05-06 13:20:53,879 [INFO ] (KeyVals.java :87{10}) - Previous Artifactory revision is '1154'. Current revision is '1154'. 2008-05-06 13:20:54,113 [INFO ] (SchedulerFactoryBean.java:879{10}) - Starting Quartz Scheduler now 2008-05-06 13:20:54,504 [INFO ] (SchedulerFactoryBean.java:977{10}) - Shutting down Quartz Scheduler 2008-05-06 13:20:54,504 [ERROR] (JobRunShell.java:211{10}) - Job DEFAULT.backupJobDetail threw an unhandled Exception: org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name 'backup': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:147) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:247) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:236) at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:790) at org.artifactory.webapp.spring.ArtifactoryWebApplicationContext.beanForType(ArtifactoryWebApplicationContext.java:68) at org.artifactory.webapp.spring.ArtifactoryWebApplicationContext.getBackup(ArtifactoryWebApplicationContext.java:59) at org.artifactory.backup.BackupJob.execute(BackupJob.java:22) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529) 2008-05-06 13:20:54,520 [ERROR] (QuartzScheduler.java:2156{10}) - Job (DEFAULT.backupJobDetail threw an exception. org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name 'backup': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!)] at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529) Caused by: org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name 'backup': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:147) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:247) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:236) at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:790) at org.artifactory.webapp.spring.ArtifactoryWebApplicationContext.beanForType(ArtifactoryWebApplicationContext.java:68) at org.artifactory.webapp.spring.ArtifactoryWebApplicationContext.getBackup(ArtifactoryWebApplicationContext.java:59) at org.artifactory.backup.BackupJob.execute(BackupJob.java:22) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ... 1 more 2008-05-06 13:20:54,566 [WARN ] (DatabaseFileSystem.java:1068{10}) - execute failed, about to econnect... 2008-05-07 13:59:02,821 [INFO ] (KeyVals.java :87{10}) - Previous Artifactory revision is '1154'. Current revision is '1154'. 2008-05-07 13:59:03,071 [INFO ] (SchedulerFactoryBean.java:879{10}) - Starting Quartz Scheduler now 2008-05-07 13:59:03,493 [ERROR] (QuartzScheduler.java:2156{10}) - An error occured while firing trigger 'DEFAULT.backupTrigger' org.quartz.JobPersistenceException: Couldn't store trigger: INSERT on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL080429141242161' for key (backupJobDetail,DEFAULT). The statement has been rolled back. [See nested exception: java.sql.SQLException: INSERT on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL080429141242161' for key (backupJobDetail,DEFAULT). The statement has been rolled back.] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1182) at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2847) at org.quartz.impl.jdbcjobstore.JobStoreSupport$37.execute(JobStoreSupport.java:2757) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3662) at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2751) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:313) Caused by: java.sql.SQLException: INSERT on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL080429141242161' for key (backupJobDetail,DEFAULT). The statement has been rolled back. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.artifactory.scheduling.DerbyDelegate.insertTrigger(DerbyDelegate.java:186) at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1170) ... 5 more Caused by: ERROR 23503: INSERT on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL080429141242161' for key (backupJobDetail,DEFAULT). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source) at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 10 more 2008-05-07 13:59:03,509 [INFO ] (BackupHelper.java:88{10}) - Backup activated with cron expression '0 0 /12 * * ?'. 2008-05-07 14:05:58,738 [INFO ] (AbstractApplicationContext.java:672{10}) - Closing org.artifactory.webapp.spring.ArtifactoryWebApplicationContext@e51b2c: display name [Root WebApplicationContext]; startup date [Wed May 07 13:58:56 CEST 2008]; root of context hierarchy 2008-05-07 14:05:58,754 [INFO ] (SchedulerFactoryBean.java:977{10}) - Shutting down Quartz Scheduler 2008-05-07 14:05:58,801 [WARN ] (DatabaseFileSystem.java:1068{10}) - execute failed, about to reconnect... |
|
|
Re: SQL exception
by ewryan
::
Rate this Message:
I am receiving the same exception. Were you able to resolve this issue?
|
|
|
Re: SQL exception
by Yoav Landman
::
Rate this Message:
Is that still reproducible after temporarily moving away the folder $ARTIFACTORY_HOME/appdb and restarting Artifactory? (note that your security deifnitions will be reset to the defaults by doing so).
On Wed, Jun 4, 2008 at 8:08 PM, ewryan <ewryan@...> wrote:
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Artifactory-users mailing list Artifactory-users@... https://lists.sourceforge.net/lists/listinfo/artifactory-users |
| Free Forum Powered by Nabble | Forum Help |