Product Knowledge Base

Space shortcuts

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

The Job Scheduler needs InnoDB tables.

For this, a CREATE TABLE statement ends with TYPh1. InnoDB in MySQL 4 and with ENGINEInnoDB in MySQL 5.

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

We have therefore modified the SQL statements to ENGINEInnoDB 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. InnoDB to TYPEInnoDB and start the ./install/scheduler_install_tables.(cmd|sh) script.

MySQL &gth1. 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 TYPh1. 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.

  • No labels