...
We have therefore modified the SQL statements to ENGINEInnoDB for Job Scheduler releases > 1.3.10.1132.Who still uses
MySQL4 user gets a database error during the setup for 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 the ./install/scheduler_install_tables.(cmd|sh) script.
MySQL5.5 user gets a database error during the setup for releases <h1. 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 ENGINE=InnoDB.
Furthermore, missing three 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;
|
Start the ./install/scheduler_install_tables.(cmd|sh) script.