| 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.
...
MySQL 4 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 'Engine=InnoDB'
In this case you must change in all SQL files (./db/mysql/*.sql) the ENGINh1. 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 TYPEInnoDB to ENGINETYPE=InnoDB to ENGINEInnoDB.
Furthermore, missing three 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; |
| Code Block |
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; |
| Code Block |
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.