Discussion:
error quartz - relation "qrtz_locks" does not exist - grails 1.1rc2
Pedro Herrera
2009-03-01 15:47:15 UTC
Permalink
Hi,
when I change the attribute jdbcStore to 'true' in QuartzConfig.groovy
the following error shows up :


Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured during job
recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException:
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
[See nested exception: org.postgresql.util.PSQLException: ERROR: relation
"qrtz_locks" does not exist]]

what´s wrong ?

Herrera
--
View this message in context: http://www.nabble.com/error-quartz----relation-%22qrtz_locks%22-does-not-exist---grails-1.1rc2-tp22274285p22274285.html
Sent from the grails - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Burt Beckwith
2009-03-01 15:51:15 UTC
Permalink
Did you create the database tables? It's not sufficient to set jdbcStore=true - you need to create the tables using one of the scripts in plugins/quartz/src/templates/sql

Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in QuartzConfig.groovy
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured during job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
[See nested exception: org.postgresql.util.PSQLException: ERROR: relation
"qrtz_locks" does not exist]]
whatŽs wrong ?
Herrera
Pedro Herrera
2009-03-01 16:23:01 UTC
Permalink
Are you sure ? this tables and scripts didn´t come within installation.

grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .

Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the scripts in
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in QuartzConfig.groovy
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured during job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
[See nested exception: org.postgresql.util.PSQLException: ERROR: relation
"qrtz_locks" does not exist]]
what´s wrong ?
Herrera
--
View this message in context: http://www.nabble.com/error-quartz----relation-%22qrtz_locks%22-does-not-exist---grails-1.1rc2-tp22274285p22274672.html
Sent from the grails - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Burt Beckwith
2009-03-01 16:34:42 UTC
Permalink
You might have an earlier version of the snapshot. I just downloaded the plugin zip and it does contain the scripts. They're also available here: http://plugins.grails.org/grails-quartz/tags/LATEST_RELEASE/src/templates/sql/

Burt
Are you sure ? this tables and scripts didnŽt come within installation.
grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .
Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the scripts in
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in QuartzConfig.groovy
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured during job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
[See nested exception: org.postgresql.util.PSQLException: ERROR: relation
"qrtz_locks" does not exist]]
whatŽs wrong ?
Herrera
Pedro Herrera
2009-03-01 16:53:01 UTC
Permalink
thanks. I´ve gotten the last available version using grails install-plugin
quartz . There are some errors reported in JIRA to this release
(quartz-0.4.1-SNAPSHOT) .
http://jira.codehaus.org/browse/GRAILSPLUGINS/component/12770 JIRA

I´m going to install the latest stable version of the plugin (0.3.3).

Thanks a lot
Post by Burt Beckwith
You might have an earlier version of the snapshot. I just downloaded the
http://plugins.grails.org/grails-quartz/tags/LATEST_RELEASE/src/templates/sql/
Burt
Post by Pedro Herrera
Are you sure ? this tables and scripts didn´t come within installation.
grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .
Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the scripts
in
Post by Burt Beckwith
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in
QuartzConfig.groovy
Post by Burt Beckwith
Post by Pedro Herrera
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating
Post by Burt Beckwith
Post by Pedro Herrera
bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured
during
Post by Burt Beckwith
Post by Pedro Herrera
job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
relation
Post by Burt Beckwith
Post by Pedro Herrera
"qrtz_locks" does not exist]]
what´s wrong ?
Herrera
--
View this message in context: http://www.nabble.com/error-quartz----relation-%22qrtz_locks%22-does-not-exist---grails-1.1rc2-tp22274285p22274981.html
Sent from the grails - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Pedro Herrera
2009-03-02 01:29:26 UTC
Permalink
Another question :
I created the tables, but quartz can´t find them("relation "qrtz_locks"
does not exist") because is inside schema. How to do to quartz recognize
tables within schemas ? I setted default_schema = 'appSchema' in
Datasource.xml .

Herrera
Post by Burt Beckwith
You might have an earlier version of the snapshot. I just downloaded the
http://plugins.grails.org/grails-quartz/tags/LATEST_RELEASE/src/templates/sql/
Burt
Post by Pedro Herrera
Are you sure ? this tables and scripts didn´t come within installation.
grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .
Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the scripts
in
Post by Burt Beckwith
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in
QuartzConfig.groovy
Post by Burt Beckwith
Post by Pedro Herrera
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating
Post by Burt Beckwith
Post by Pedro Herrera
bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured
during
Post by Burt Beckwith
Post by Pedro Herrera
job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
relation
Post by Burt Beckwith
Post by Pedro Herrera
"qrtz_locks" does not exist]]
what´s wrong ?
Herrera
--
View this message in context: http://www.nabble.com/error-quartz----relation-%22qrtz_locks%22-does-not-exist---grails-1.1rc2-tp22274285p22280613.html
Sent from the grails - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Burt Beckwith
2009-03-02 01:42:22 UTC
Permalink
I'm not sure that this is the right way to do this, but there's an 'org.quartz.jobStore.tablePrefix' property that defaults to 'QRTZ_' that you might be able change to 'yourschema.QRTZ_'. See the Quartz documentation for the format of quartz.properties (you can put it either in src/java or grails-app/conf to get it into the classpath and override the defaults).

Burt
Post by Pedro Herrera
I created the tables, but quartz can´t find them("relation "qrtz_locks"
does not exist") because is inside schema. How to do to quartz recognize
tables within schemas ? I setted default_schema = 'appSchema' in
Datasource.xml .
Herrera
Post by Burt Beckwith
You might have an earlier version of the snapshot. I just downloaded the
http://plugins.grails.org/grails-quartz/tags/LATEST_RELEASE/src/templates/sql/
Burt
Post by Pedro Herrera
Are you sure ? this tables and scripts didn´t come within installation.
grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .
Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the scripts
in
Post by Burt Beckwith
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in
QuartzConfig.groovy
Post by Burt Beckwith
Post by Pedro Herrera
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating
Post by Burt Beckwith
Post by Pedro Herrera
bean
with name 'quartzScheduler': Invocation of init method failed; nested
exception is org.quartz.SchedulerConfigException: Failure occured
during
Post by Burt Beckwith
Post by Pedro Herrera
job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist
relation
Post by Burt Beckwith
Post by Pedro Herrera
"qrtz_locks" does not exist]]
what´s wrong ?
Herrera
---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Pedro Herrera
2009-03-02 10:32:03 UTC
Permalink
Burt,

I tried to create a quartz.properties with property
org.quartz.jobStore.tablePrefix = mcenter.QRTZ_ , but doesn´t work ;

I putted in src/java, grails-app/conf and inside QuartzConfig.groovy and
the same error occurs("relation "qrtz_locks" does not exist").... :=(

Thanks

Herrera
Post by Burt Beckwith
I'm not sure that this is the right way to do this, but there's an
'org.quartz.jobStore.tablePrefix' property that defaults to 'QRTZ_' that
you might be able change to 'yourschema.QRTZ_'. See the Quartz
documentation for the format of quartz.properties (you can put it either
in src/java or grails-app/conf to get it into the classpath and override
the defaults).
Burt
Post by Pedro Herrera
I created the tables, but quartz can´t find them("relation "qrtz_locks"
does not exist") because is inside schema. How to do to quartz recognize
tables within schemas ? I setted default_schema = 'appSchema' in
Datasource.xml .
Herrera
Post by Burt Beckwith
You might have an earlier version of the snapshot. I just downloaded
the
Post by Burt Beckwith
plugin zip and it does contain the scripts. They're also available
http://plugins.grails.org/grails-quartz/tags/LATEST_RELEASE/src/templates/sql/
Post by Burt Beckwith
Burt
Post by Pedro Herrera
Are you sure ? this tables and scripts didn´t come within
installation.
Post by Burt Beckwith
Post by Pedro Herrera
grails 1.1rc2 , quartz-0.4.1-SNAPSHOT .
Herrera
Post by Burt Beckwith
Did you create the database tables? It's not sufficient to set
jdbcStore=true - you need to create the tables using one of the
scripts
Post by Burt Beckwith
Post by Pedro Herrera
in
Post by Burt Beckwith
plugins/quartz/src/templates/sql
Burt
Post by Pedro Herrera
Hi,
when I change the attribute jdbcStore to 'true' in
QuartzConfig.groovy
Post by Burt Beckwith
Post by Pedro Herrera
Running Grails application..
2009-03-01 12:34:58,093 [main] ERROR context.ContextLoader -
Context
Post by Burt Beckwith
Post by Pedro Herrera
Post by Burt Beckwith
Post by Pedro Herrera
initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating
Post by Burt Beckwith
Post by Pedro Herrera
bean
with name 'quartzScheduler': Invocation of init method failed;
nested
Post by Burt Beckwith
Post by Pedro Herrera
Post by Burt Beckwith
Post by Pedro Herrera
exception is org.quartz.SchedulerConfigException: Failure occured
during
Post by Burt Beckwith
Post by Pedro Herrera
job
Failure obtaining db row lock: ERROR: relation "qrtz_locks" does
not
Post by Burt Beckwith
Post by Pedro Herrera
Post by Burt Beckwith
Post by Pedro Herrera
exist
relation
Post by Burt Beckwith
Post by Pedro Herrera
"qrtz_locks" does not exist]]
what´s wrong ?
Herrera
---------------------------------------------------------------------
http://xircles.codehaus.org/manage_email
--
View this message in context: http://www.nabble.com/error-quartz----relation-%22qrtz_locks%22-does-not-exist---grails-1.1rc2-tp22274285p22285652.html
Sent from the grails - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
Loading...