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 4 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 Typeh1. 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.

MySQL4 user gets a database error during the setup for 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.

MySQL5.5 user gets a database error during the setup for releases &lth1. 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:

 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;

Start the ./install/scheduler_install_tables.(cmd|sh) script.

  • No labels