| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
The Job Scheduler needs InnoDB tables.
For this, a CREATE TABLE statement ends with TYPh1. TYPE= InnoDB in MySQL 4 and with ENGINEInnoDB ENGINE=InnoDB in MySQL 5.
Until MySQL 5.4 was Typeh1. Type=InnoDB as far backward compatible, but since MySQL 5.5 an error is thrown.
We have therefore modified the SQL statements to ENGINEInnoDB ENGINE=InnoDB for Job Scheduler releases > 1.3.10.1132.Who still uses MySQL4
MySQL 4 user gets a database error during the setup for Job Scheduler releases > 1.3.10.1132
setup:ERROR 1064 (00000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Engine=InnoDB'
In this case you must change in all SQL files (./db/mysql/*.sql) the ENGINh1. InnoDB to TYPEInnoDB and start ENGINE=InnoDB to TYPEInnoDB and start the ./install/scheduler_install_tables.(cmd|sh) script.
MySQL >= 5.5 user gets a database error during the setup for Job Scheduler releases <= 1.3.10.1132
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=InnoDB'
In this case you must change in all SQL files (./db/mysql/*.sql) the TYPE=InnoDB to ENGINEInnoDB.
Furthermore, missing four CREATE TABLE statements.
Insert the following CREATE TABLEs to ./db/mysql/scheduler.sql:
| Code Block |
|---|
CREATE TABLE IF NOT EXISTS SCHEDULER_JOBS (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PATH" varchar(255) CHARACTER SET latin1 NOT NULL,
"STOPPED" int(1) NOT NULL DEFAULT 0,
"NEXT_START_TIME" varchar(24) ,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAINS (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PATH" varchar(255) CHARACTER SET latin1 NOT NULL,
"STOPPED" int(1) NOT NULL DEFAULT 0,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAIN_NODES (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"JOB_CHAIN" varchar(255) CHARACTER SET latin1 NOT NULL,
"ORDER_STATE" varchar(100) CHARACTER SET latin1 NOT NULL,
"ACTION" varchar(100) ,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","JOB_CHAIN","ORDER_STATE")
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS SCHEDULER_CLUSTERS (
"MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"SCHEDULER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PRECEDENCE" int(11),
"LAST_HEART_BEAT" int(11),
"NEXT_HEART_BEAT" int(11),
"ACTIVE" int(1),
"EXCLUSIVE" int(1),
"DEAD" int(1),
"COMMAND" varchar(250),
"HTTP_URL" varchar(100),
"DEACTIVATING_MEMBER_ID" varchar(100),
"XML" longtext,
PRIMARY KEY ("MEMBER_ID")
) ENGINE=InnoDB;
|
Start the ./install/scheduler_install_tables.(cmd|sh) script.