Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
2 Major
-
Resolution: Not a Bug
-
Affects Version/s: 2.1.5
-
Fix Version/s: None
-
Component/s: JDBC JobStores
-
Labels:None
-
Terracotta Target:Vicente_Holding
Description
we have applied mysql db creation script from v 2.1.5
CREATE TABLE QRTZ_SCHEDULER_STATE (
SCHED_NAME VARCHAR(120) NOT NULL,
INSTANCE_NAME VARCHAR(200) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
TYPE=InnoDB;
1. it doesn't have a default value like in migration script
alter table qrtz_scheduler_state add column sched_name varchar(120) not null DEFAULT 'TestScheduler';
2. why it tries to add column without specifying SCHED_NAME field?
INSERT INTO QRTZ_SCHEDULER_STATE (INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('PersistentQuartz', 1345034381285, 20000);
I'm confused it has the next row in database
| PersistentQuartzScheduler | PersistentQuartz | 1345202815277 | 20000 |
the name column should match the name of your scheduler (in the quartz.properties).