Product Knowledge Base

Space shortcuts

Page tree

The Job Scheduler needs InnoDB tables.

For this, a CREATE TABLE statement ends with TYPE= InnoDB in MySQL 4 and with ENGINE=InnoDB in MySQL 5.

Until MySQL 5.4 was Type=InnoDB as far backward compatible, but since MySQL 5.5 an error is thrown.

We have therefore modified the SQL statements to 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 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:

 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.