1、创建数据库
mysql> CREATE DATABASE dolphinscheduler DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
2、创建用户
mysql> CREATE USER 'dolphinscheduler'@'%' IDENTIFIED BY 'dolphinscheduler';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
-- 这个是密码过于简单的原因，进行如下操作即可
mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
-- 再一次进行操作即可了
mysql> CREATE USER 'dolphinscheduler'@'%' IDENTIFIED BY 'dolphinscheduler';
Query OK, 0 rows affected (0.00 sec)
3、赋予用户相应权限
mysql> GRANT ALL PRIVILEGES ON dolphinscheduler.* TO 'dolphinscheduler'@'%';
Query OK, 0 rows affected (0.00 sec)
-- 刷新当前配置
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4、修改数据源配置文件
[lqs@nwh120 conf]$ pwd
/home/lqs/module/dolphinscheduler-1.3.9-install/conf
[lqs@nwh120 conf]$ vim datasource.properties
修改如下内容：
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://nwh120:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=dolphinscheduler
spring.datasource.password=dolphinscheduler
5、拷贝MySQL驱动到DolphinScheduler的解压目录下的lib中
[lqs@nwh120 dolphinscheduler-1.3.9-install]$ cp /home/lqs/software/mysql-connector-java-5.1.27-bin.jar lib/
6、执行数据库初始化脚本
数据库初始化脚本位于DolphinScheduler解压安装目录下的script目录中，即/home/lqs/module/dolphinscheduler-1.3.9-install
[lqs@nwh120 dolphinscheduler-1.3.9-install]$ script/create-dolphinscheduler.sh
输入如下：
19:53:40.086 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.cpu.isalist
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.io.unicode.encoding
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.cpu.endian
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vendor.url.bug
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: file.separator
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vendor
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.boot.class.path
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.ext.dirs
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.version
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.info
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: awt.toolkit
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.language
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.specification.vendor
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.java.command
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.home
19:53:40.088 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.arch.data.model
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.specification.version
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.class.path
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.name
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: file.encoding
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.specification.version
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.awt.printerjob
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.timezone
19:53:40.089 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.home
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: os.version
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.management.compiler
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.specification.name
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.class.version
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.library.path
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.jnu.encoding
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: os.name
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.specification.vendor
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.io.tmpdir
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: line.separator
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.endorsed.dirs
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: os.arch
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.awt.graphicsenv
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.runtime.version
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.specification.name
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.dir
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: user.country
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.java.launcher
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.os.patch.level
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.name
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: file.encoding.pkg
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: path.separator
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.vendor
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vendor.url
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: sun.boot.library.path
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.vm.version
19:53:40.092 [main] INFO org.apache.dolphinscheduler.dao.utils.PropertyUtils - Overriding property from system property: java.runtime.name
_ _ |_ _ _|_. ___ _ | _
| | |\/|_)(_| | |_\ |_)||_|_\
/ |
3.2.0
19:53:40.899 [main] INFO ru.yandex.clickhouse.ClickHouseDriver - Driver registered
19:53:41.088 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
19:53:41.105 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Start initializing the DolphinScheduler manager table structure
19:53:41.108 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ /* Navicat MySQL Data Transfer Source Server : xx.xx Source Server Version : 50725 Source Host : 192.168.xx.xx:3306 Source Database : escheduler Target Server Type : MYSQL Target Server Version : 50725 File Encoding : 65001 Date: 2019-03-23 11:47:30 */ SET FOREIGN_KEY_CHECKS=0
19:53:41.110 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.110 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_alert
19:53:41.110 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.110 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_alert`
19:53:41.110 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_alert` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `title` varchar(64) DEFAULT NULL COMMENT 'title', `show_type` tinyint(4) DEFAULT NULL COMMENT 'send email type,0:TABLE,1:TEXT', `content` text COMMENT 'Message content (can be email, can be SMS. Mail is stored in JSON map, and SMS is string)', `alert_type` tinyint(4) DEFAULT NULL COMMENT '0:email,1:sms', `alert_status` tinyint(4) DEFAULT '0' COMMENT '0:wait running,1:success,2:failed', `log` text COMMENT 'log', `alertgroup_id` int(11) DEFAULT NULL COMMENT 'alert group id', `receivers` text COMMENT 'receivers', `receivers_cc` text COMMENT 'cc', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.115 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.115 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_alertgroup
19:53:41.115 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.115 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_alertgroup`
19:53:41.115 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_alertgroup` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `group_name` varchar(255) DEFAULT NULL COMMENT 'group name', `group_type` tinyint(4) DEFAULT NULL COMMENT 'Group type (message 0, SMS 1...)', `desc` varchar(255) DEFAULT NULL COMMENT 'description', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.119 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.119 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_command
19:53:41.119 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.119 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_command`
19:53:41.119 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_command` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `command_type` tinyint(4) DEFAULT NULL COMMENT 'Command type: 0 start workflow, 1 start execution from current node, 2 resume fault-tolerant workflow, 3 resume pause process, 4 start execution from failed node, 5 complement, 6 schedule, 7 rerun, 8 pause, 9 stop, 10 resume waiting thread', `process_definition_id` int(11) DEFAULT NULL COMMENT 'process definition id', `command_param` text COMMENT 'json command parameters', `task_depend_type` tinyint(4) DEFAULT NULL COMMENT 'Node dependency type: 0 current node, 1 forward, 2 backward', `failure_strategy` tinyint(4) DEFAULT '0' COMMENT 'Failed policy: 0 end, 1 continue', `warning_type` tinyint(4) DEFAULT '0' COMMENT 'Alarm type: 0 is not sent, 1 process is sent successfully, 2 process is sent failed, 3 process is sent successfully and all failures are sent', `warning_group_id` int(11) DEFAULT NULL COMMENT 'warning group', `schedule_time` datetime DEFAULT NULL COMMENT 'schedule time', `start_time` datetime DEFAULT NULL COMMENT 'start time', `executor_id` int(11) DEFAULT NULL COMMENT 'executor id', `dependence` varchar(255) DEFAULT NULL COMMENT 'dependence', `update_time` datetime DEFAULT NULL COMMENT 'update time', `process_instance_priority` int(11) DEFAULT NULL COMMENT 'process instance priority: 0 Highest,1 High,2 Medium,3 Low,4 Lowest', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.122 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.122 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_datasource
19:53:41.122 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.122 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_datasource`
19:53:41.122 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_datasource` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `name` varchar(64) NOT NULL COMMENT 'data source name', `note` varchar(256) DEFAULT NULL COMMENT 'description', `type` tinyint(4) NOT NULL COMMENT 'data source type: 0:mysql,1:postgresql,2:hive,3:spark', `user_id` int(11) NOT NULL COMMENT 'the creator id', `connection_params` text NOT NULL COMMENT 'json connection params', `create_time` datetime NOT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.125 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.125 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_master_server
19:53:41.125 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.125 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_master_server`
19:53:41.126 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_master_server` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `host` varchar(45) DEFAULT NULL COMMENT 'ip', `port` int(11) DEFAULT NULL COMMENT 'port', `zk_directory` varchar(64) DEFAULT NULL COMMENT 'the server path in zk directory', `res_info` varchar(256) DEFAULT NULL COMMENT 'json resource information:{"cpu":xxx,"memroy":xxx}', `create_time` datetime DEFAULT NULL COMMENT 'create time', `last_heartbeat_time` datetime DEFAULT NULL COMMENT 'last head beat time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.130 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.130 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_process_definition
19:53:41.130 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.130 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_process_definition`
19:53:41.130 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_process_definition` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `name` varchar(255) DEFAULT NULL COMMENT 'process definition name', `version` int(11) DEFAULT NULL COMMENT 'process definition version', `release_state` tinyint(4) DEFAULT NULL COMMENT 'process definition release state：0:offline,1:online', `project_id` int(11) DEFAULT NULL COMMENT 'project id', `user_id` int(11) DEFAULT NULL COMMENT 'process definition creator id', `process_definition_json` longtext COMMENT 'process definition json content', `desc` text COMMENT 'process definition description', `global_params` text COMMENT 'global parameters', `flag` tinyint(4) DEFAULT NULL COMMENT '0 not available, 1 available', `locations` text COMMENT 'Node location information', `connects` text COMMENT 'Node connection information', `receivers` text COMMENT 'receivers', `receivers_cc` text COMMENT 'cc', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`), KEY `process_definition_index` (`project_id`,`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.134 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.134 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_process_instance
19:53:41.134 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.134 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_process_instance`
19:53:41.135 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_process_instance` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `name` varchar(255) DEFAULT NULL COMMENT 'process instance name', `process_definition_id` int(11) DEFAULT NULL COMMENT 'process definition id', `state` tinyint(4) DEFAULT NULL COMMENT 'process instance Status: 0 commit succeeded, 1 running, 2 prepare to pause, 3 pause, 4 prepare to stop, 5 stop, 6 fail, 7 succeed, 8 need fault tolerance, 9 kill, 10 wait for thread, 11 wait for dependency to complete', `recovery` tinyint(4) DEFAULT NULL COMMENT 'process instance failover flag：0:normal,1:failover instance', `start_time` datetime DEFAULT NULL COMMENT 'process instance start time', `end_time` datetime DEFAULT NULL COMMENT 'process instance end time', `run_times` int(11) DEFAULT NULL COMMENT 'process instance run times', `host` varchar(45) DEFAULT NULL COMMENT 'process instance host', `command_type` tinyint(4) DEFAULT NULL COMMENT 'command type', `command_param` text COMMENT 'json command parameters', `task_depend_type` tinyint(4) DEFAULT NULL COMMENT 'task depend type. 0: only current node,1:before the node,2:later nodes', `max_try_times` tinyint(4) DEFAULT '0' COMMENT 'max try times', `failure_strategy` tinyint(4) DEFAULT '0' COMMENT 'failure strategy. 0:end the process when node failed,1:continue running the other nodes when node failed', `warning_type` tinyint(4) DEFAULT '0' COMMENT 'warning type. 0:no warning,1:warning if process success,2:warning if process failed,3:warning if success', `warning_group_id` int(11) DEFAULT NULL COMMENT 'warning group id', `schedule_time` datetime DEFAULT NULL COMMENT 'schedule time', `command_start_time` datetime DEFAULT NULL COMMENT 'command start time', `global_params` text COMMENT 'global parameters', `process_instance_json` longtext COMMENT 'process instance json(copy的process definition 的json)', `flag` tinyint(4) DEFAULT '1' COMMENT 'flag', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_sub_process` int(11) DEFAULT '0' COMMENT 'flag, whether the process is sub process', `executor_id` int(11) NOT NULL COMMENT 'executor id', `locations` text COMMENT 'Node location information', `connects` text COMMENT 'Node connection information', `history_cmd` text COMMENT 'history commands of process instance operation', `dependence_schedule_times` text COMMENT 'depend schedule fire time', `process_instance_priority` int(11) DEFAULT NULL COMMENT 'process instance priority. 0 Highest,1 High,2 Medium,3 Low,4 Lowest', PRIMARY KEY (`id`), KEY `process_instance_index` (`process_definition_id`,`id`) USING BTREE, KEY `start_time_index` (`start_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.139 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.139 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_project
19:53:41.139 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.139 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_project`
19:53:41.139 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_project` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `name` varchar(100) DEFAULT NULL COMMENT 'project name', `desc` varchar(200) DEFAULT NULL COMMENT 'project description', `user_id` int(11) DEFAULT NULL COMMENT 'creator id', `flag` tinyint(4) DEFAULT '1' COMMENT '0 not available, 1 available', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`), KEY `user_id_index` (`user_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.143 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.143 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_queue
19:53:41.143 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.143 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_queue`
19:53:41.144 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_queue` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `queue_name` varchar(64) DEFAULT NULL COMMENT 'queue name', `queue` varchar(64) DEFAULT NULL COMMENT 'yarn queue name', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.147 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.147 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_datasource_user
19:53:41.147 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.147 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_datasource_user`
19:53:41.147 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_datasource_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id` int(11) NOT NULL COMMENT 'user id', `datasource_id` int(11) DEFAULT NULL COMMENT 'data source id', `perm` int(11) DEFAULT '1' COMMENT 'limits of authority', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.150 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.150 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_process_instance
19:53:41.150 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.150 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_process_instance`
19:53:41.150 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_process_instance` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `parent_process_instance_id` int(11) DEFAULT NULL COMMENT 'parent process instance id', `parent_task_instance_id` int(11) DEFAULT NULL COMMENT 'parent process instance id', `process_instance_id` int(11) DEFAULT NULL COMMENT 'child process instance id', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.153 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.153 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_project_user
19:53:41.153 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.153 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_project_user`
19:53:41.154 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_project_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id` int(11) NOT NULL COMMENT 'user id', `project_id` int(11) DEFAULT NULL COMMENT 'project id', `perm` int(11) DEFAULT '1' COMMENT 'limits of authority', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`), KEY `user_id_index` (`user_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.169 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.169 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_resources_user
19:53:41.169 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.169 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_resources_user`
19:53:41.170 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_resources_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT 'user id', `resources_id` int(11) DEFAULT NULL COMMENT 'resource id', `perm` int(11) DEFAULT '1' COMMENT 'limits of authority', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.173 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.173 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_udfs_user
19:53:41.173 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.173 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_udfs_user`
19:53:41.173 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_udfs_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id` int(11) NOT NULL COMMENT 'userid', `udf_id` int(11) DEFAULT NULL COMMENT 'udf id', `perm` int(11) DEFAULT '1' COMMENT 'limits of authority', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.176 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.176 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_relation_user_alertgroup
19:53:41.176 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.176 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_relation_user_alertgroup`
19:53:41.177 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_relation_user_alertgroup` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `alertgroup_id` int(11) DEFAULT NULL COMMENT 'alert group id', `user_id` int(11) DEFAULT NULL COMMENT 'user id', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
19:53:41.180 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.180 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_resources
19:53:41.180 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.180 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_resources`
19:53:41.181 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_resources` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `alias` varchar(64) DEFAULT NULL COMMENT 'alias', `file_name` varchar(64) DEFAULT NULL COMMENT 'file name', `desc` varchar(256) DEFAULT NULL COMMENT 'description', `user_id` int(11) DEFAULT NULL COMMENT 'user id', `type` tinyint(4) DEFAULT NULL COMMENT 'resource type,0:FILE，1:UDF', `size` bigint(20) DEFAULT NULL COMMENT 'resource size', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.184 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.184 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_schedules
19:53:41.184 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.184 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_schedules`
19:53:41.184 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_schedules` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `process_definition_id` int(11) NOT NULL COMMENT 'process definition id', `start_time` datetime NOT NULL COMMENT 'start time', `end_time` datetime NOT NULL COMMENT 'end time', `crontab` varchar(256) NOT NULL COMMENT 'crontab description', `failure_strategy` tinyint(4) NOT NULL COMMENT 'failure strategy. 0:end,1:continue', `user_id` int(11) NOT NULL COMMENT 'user id', `release_state` tinyint(4) NOT NULL COMMENT 'release state. 0:offline,1:online ', `warning_type` tinyint(4) NOT NULL COMMENT 'Alarm type: 0 is not sent, 1 process is sent successfully, 2 process is sent failed, 3 process is sent successfully and all failures are sent', `warning_group_id` int(11) DEFAULT NULL COMMENT 'alert group id', `process_instance_priority` int(11) DEFAULT NULL COMMENT 'process instance priority：0 Highest,1 High,2 Medium,3 Low,4 Lowest', `create_time` datetime NOT NULL COMMENT 'create time', `update_time` datetime NOT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.187 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.187 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_session
19:53:41.187 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.187 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_session`
19:53:41.187 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_session` ( `id` varchar(64) NOT NULL COMMENT 'key', `user_id` int(11) DEFAULT NULL COMMENT 'user id', `ip` varchar(45) DEFAULT NULL COMMENT 'ip', `last_login_time` datetime DEFAULT NULL COMMENT 'last login time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.190 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.190 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_task_instance
19:53:41.190 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.190 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_task_instance`
19:53:41.191 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_task_instance` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `name` varchar(255) DEFAULT NULL COMMENT 'task name', `task_type` varchar(64) DEFAULT NULL COMMENT 'task type', `process_definition_id` int(11) DEFAULT NULL COMMENT 'process definition id', `process_instance_id` int(11) DEFAULT NULL COMMENT 'process instance id', `task_json` longtext COMMENT 'task content json', `state` tinyint(4) DEFAULT NULL COMMENT 'Status: 0 commit succeeded, 1 running, 2 prepare to pause, 3 pause, 4 prepare to stop, 5 stop, 6 fail, 7 succeed, 8 need fault tolerance, 9 kill, 10 wait for thread, 11 wait for dependency to complete', `submit_time` datetime DEFAULT NULL COMMENT 'task submit time', `start_time` datetime DEFAULT NULL COMMENT 'task start time', `end_time` datetime DEFAULT NULL COMMENT 'task end time', `host` varchar(45) DEFAULT NULL COMMENT 'host of task running on', `execute_path` varchar(200) DEFAULT NULL COMMENT 'task execute path in the host', `log_path` varchar(200) DEFAULT NULL COMMENT 'task log path', `alert_flag` tinyint(4) DEFAULT NULL COMMENT 'whether alert', `retry_times` int(4) DEFAULT '0' COMMENT 'task retry times', `pid` int(4) DEFAULT NULL COMMENT 'pid of task', `app_link` varchar(255) DEFAULT NULL COMMENT 'yarn app id', `flag` tinyint(4) DEFAULT '1' COMMENT '0 not available, 1 available', `retry_interval` int(4) DEFAULT NULL COMMENT 'retry interval when task failed ', `max_retry_times` int(2) DEFAULT NULL COMMENT 'max retry times', `task_instance_priority` int(11) DEFAULT NULL COMMENT 'task instance priority:0 Highest,1 High,2 Medium,3 Low,4 Lowest', PRIMARY KEY (`id`), KEY `process_instance_id` (`process_instance_id`) USING BTREE, KEY `task_instance_index` (`process_definition_id`,`process_instance_id`) USING BTREE, CONSTRAINT `foreign_key_instance_id` FOREIGN KEY (`process_instance_id`) REFERENCES `t_escheduler_process_instance` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.196 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.196 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_tenant
19:53:41.196 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.196 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_tenant`
19:53:41.196 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_tenant` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `tenant_code` varchar(64) DEFAULT NULL COMMENT 'tenant code', `tenant_name` varchar(64) DEFAULT NULL COMMENT 'tenant name', `desc` varchar(256) DEFAULT NULL COMMENT 'description', `queue_id` int(11) DEFAULT NULL COMMENT 'queue id', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.199 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.199 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_udfs
19:53:41.199 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.199 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_udfs`
19:53:41.199 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_udfs` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id` int(11) NOT NULL COMMENT 'user id', `func_name` varchar(100) NOT NULL COMMENT 'UDF function name', `class_name` varchar(255) NOT NULL COMMENT 'class of udf', `type` tinyint(4) NOT NULL COMMENT 'Udf function type', `arg_types` varchar(255) DEFAULT NULL COMMENT 'arguments types', `database` varchar(255) DEFAULT NULL COMMENT 'data base', `desc` varchar(255) DEFAULT NULL COMMENT 'description', `resource_id` int(11) NOT NULL COMMENT 'resource id', `resource_name` varchar(255) NOT NULL COMMENT 'resource name', `create_time` datetime NOT NULL COMMENT 'create time', `update_time` datetime NOT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.202 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.202 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_user
19:53:41.202 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.202 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_user`
19:53:41.203 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'user id', `user_name` varchar(64) DEFAULT NULL COMMENT 'user name', `user_password` varchar(64) DEFAULT NULL COMMENT 'user password', `user_type` tinyint(4) DEFAULT NULL COMMENT 'user type, 0:administrator，1:ordinary user', `email` varchar(64) DEFAULT NULL COMMENT 'email', `phone` varchar(11) DEFAULT NULL COMMENT 'phone', `tenant_id` int(11) DEFAULT NULL COMMENT 'tenant id', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`), UNIQUE KEY `user_name_unique` (`user_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.207 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.207 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Table structure for t_escheduler_worker_server
19:53:41.207 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ----------------------------
19:53:41.207 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS `t_escheduler_worker_server`
19:53:41.207 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE `t_escheduler_worker_server` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `host` varchar(45) DEFAULT NULL COMMENT 'ip', `port` int(11) DEFAULT NULL COMMENT 'process id', `zk_directory` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'zk path', `res_info` varchar(255) DEFAULT NULL COMMENT 'json resource info,{"cpu":xxx,"memroy":xxx}', `create_time` datetime DEFAULT NULL COMMENT 'create time', `last_heartbeat_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
19:53:41.211 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /*drop table first */ DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS
19:53:41.211 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS
19:53:41.211 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE
19:53:41.212 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_LOCKS
19:53:41.212 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS
19:53:41.212 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS
19:53:41.213 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS
19:53:41.213 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS
19:53:41.213 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_TRIGGERS
19:53:41.214 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_JOB_DETAILS
19:53:41.214 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP TABLE IF EXISTS QRTZ_CALENDARS
19:53:41.214 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_JOB_DETAILS( SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, DESCRIPTION VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE VARCHAR(1) NOT NULL, IS_NONCONCURRENT VARCHAR(1) NOT NULL, IS_UPDATE_DATA VARCHAR(1) NOT NULL, REQUESTS_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BLOB NULL, PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)) ENGINE=InnoDB
19:53:41.217 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, DESCRIPTION VARCHAR(250) NULL, NEXT_FIRE_TIME BIGINT(13) NULL, PREV_FIRE_TIME BIGINT(13) NULL, PRIORITY INTEGER NULL, TRIGGER_STATE VARCHAR(16) NOT NULL, TRIGGER_TYPE VARCHAR(8) NOT NULL, START_TIME BIGINT(13) NOT NULL, END_TIME BIGINT(13) NULL, CALENDAR_NAME VARCHAR(200) NULL, MISFIRE_INSTR SMALLINT(2) NULL, JOB_DATA BLOB NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)) ENGINE=InnoDB
19:53:41.220 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_SIMPLE_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, REPEAT_COUNT BIGINT(7) NOT NULL, REPEAT_INTERVAL BIGINT(12) NOT NULL, TIMES_TRIGGERED BIGINT(10) NOT NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) ENGINE=InnoDB
19:53:41.223 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_CRON_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, CRON_EXPRESSION VARCHAR(120) NOT NULL, TIME_ZONE_ID VARCHAR(80), PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) ENGINE=InnoDB
19:53:41.226 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_SIMPROP_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, STR_PROP_1 VARCHAR(512) NULL, STR_PROP_2 VARCHAR(512) NULL, STR_PROP_3 VARCHAR(512) NULL, INT_PROP_1 INT NULL, INT_PROP_2 INT NULL, LONG_PROP_1 BIGINT NULL, LONG_PROP_2 BIGINT NULL, DEC_PROP_1 NUMERIC(13,4) NULL, DEC_PROP_2 NUMERIC(13,4) NULL, BOOL_PROP_1 VARCHAR(1) NULL, BOOL_PROP_2 VARCHAR(1) NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) ENGINE=InnoDB
19:53:41.229 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_BLOB_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, BLOB_DATA BLOB NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) ENGINE=InnoDB
19:53:41.232 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_CALENDARS ( SCHED_NAME VARCHAR(120) NOT NULL, CALENDAR_NAME VARCHAR(200) NOT NULL, CALENDAR BLOB NOT NULL, PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)) ENGINE=InnoDB
19:53:41.235 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)) ENGINE=InnoDB
19:53:41.238 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_FIRED_TRIGGERS ( SCHED_NAME VARCHAR(120) NOT NULL, ENTRY_ID VARCHAR(95) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, INSTANCE_NAME VARCHAR(200) NOT NULL, FIRED_TIME BIGINT(13) NOT NULL, SCHED_TIME BIGINT(13) NOT NULL, PRIORITY INTEGER NOT NULL, STATE VARCHAR(16) NOT NULL, JOB_NAME VARCHAR(200) NULL, JOB_GROUP VARCHAR(200) NULL, IS_NONCONCURRENT VARCHAR(1) NULL, REQUESTS_RECOVERY VARCHAR(1) NULL, PRIMARY KEY (SCHED_NAME,ENTRY_ID)) ENGINE=InnoDB
19:53:41.240 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_SCHEDULER_STATE ( SCHED_NAME VARCHAR(120) NOT NULL, INSTANCE_NAME VARCHAR(200) NOT NULL, LAST_CHECKIN_TIME BIGINT(13) NOT NULL, CHECKIN_INTERVAL BIGINT(13) NOT NULL, PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)) ENGINE=InnoDB
19:53:41.243 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE TABLE QRTZ_LOCKS ( SCHED_NAME VARCHAR(120) NOT NULL, LOCK_NAME VARCHAR(40) NOT NULL, PRIMARY KEY (SCHED_NAME,LOCK_NAME)) ENGINE=InnoDB
19:53:41.246 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY)
19:53:41.249 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP)
19:53:41.252 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)
19:53:41.255 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP)
19:53:41.257 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME)
19:53:41.260 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)
19:53:41.263 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE)
19:53:41.265 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE)
19:53:41.267 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE)
19:53:41.270 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME)
19:53:41.273 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME)
19:53:41.276 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME)
19:53:41.278 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE)
19:53:41.280 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE)
19:53:41.283 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME)
19:53:41.285 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY)
19:53:41.288 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)
19:53:41.290 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP)
19:53:41.292 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
19:53:41.295 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)
19:53:41.297 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: commit
19:53:41.298 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Records of t_escheduler_user,user : admin , password : dolphinscheduler123
19:53:41.298 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ INSERT INTO `t_escheduler_user` VALUES ('1', 'admin', '7ad2410b2f4c074479a8937a28a22b8f', '0', 'xxx@qq.com', '', '0', '2018-03-27 15:48:50', '2018-10-24 17:40:22')
19:53:41.299 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: INSERT INTO `t_escheduler_alertgroup` VALUES (1, 'default admin warning group', '0', 'default admin warning group','2018-11-29 10:20:39', '2018-11-29 10:20:39')
19:53:41.300 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: INSERT INTO `t_escheduler_relation_user_alertgroup` VALUES ('1', '1', '1', '2018-11-29 10:22:33', '2018-11-29 10:22:33')
19:53:41.300 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- Records of t_escheduler_queue,default queue name : default
19:53:41.300 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: INSERT INTO `t_escheduler_queue` VALUES ('1', 'default', 'default')
19:53:41.302 [main] INFO org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler - init DolphinScheduler finished
19:53:41.313 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.0.0 to 1.0.1
19:53:41.313 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.313 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.313 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.313 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_queue_C_create_time
19:53:41.313 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_queue_C_create_time
19:53:41.314 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_queue_C_create_time() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_queue' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='create_time') THEN ALTER TABLE t_escheduler_queue ADD COLUMN create_time datetime DEFAULT NULL COMMENT 'create time' AFTER queue; END IF; END;
19:53:41.314 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_queue_C_create_time
19:53:41.344 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_queue_C_create_time
19:53:41.345 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_queue_C_update_time
19:53:41.345 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_queue_C_update_time
19:53:41.345 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_queue_C_update_time() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_queue' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='update_time') THEN ALTER TABLE t_escheduler_queue ADD COLUMN update_time datetime DEFAULT NULL COMMENT 'update time' AFTER create_time; END IF; END;
19:53:41.346 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_queue_C_update_time
19:53:41.376 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_queue_C_update_time
19:53:41.377 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.0.1_schema/mysql/dolphinscheduler_dml.sql
19:53:41.378 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.0.1 to 1.0.2
19:53:41.378 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.379 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.379 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.379 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_version
19:53:41.379 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_version
19:53:41.379 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_version() BEGIN drop table if exists t_escheduler_version; CREATE TABLE IF NOT EXISTS `t_escheduler_version` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(200) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `version_UNIQUE` (`version`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='version'; END;
19:53:41.380 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_version
19:53:41.383 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_version
19:53:41.384 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_user_C_queue
19:53:41.384 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_user_C_queue
19:53:41.384 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_user_C_queue() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_user' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='queue') THEN ALTER TABLE t_escheduler_user ADD COLUMN queue varchar(64) COMMENT 'queue' AFTER update_time; END IF; END;
19:53:41.385 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_user_C_queue
19:53:41.416 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_user_C_queue
19:53:41.417 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_access_token
19:53:41.417 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_access_token
19:53:41.417 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_access_token() BEGIN drop table if exists t_escheduler_access_token; CREATE TABLE IF NOT EXISTS `t_escheduler_access_token` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id` int(11) DEFAULT NULL COMMENT 'user id', `token` varchar(64) DEFAULT NULL COMMENT 'token', `expire_time` datetime DEFAULT NULL COMMENT 'end time of token ', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; END;
19:53:41.418 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_access_token
19:53:41.421 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_access_token
19:53:41.421 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_error_command
19:53:41.421 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_error_command
19:53:41.422 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_error_command() BEGIN drop table if exists t_escheduler_error_command; CREATE TABLE IF NOT EXISTS `t_escheduler_error_command` ( `id` int(11) NOT NULL COMMENT 'key', `command_type` tinyint(4) NULL DEFAULT NULL COMMENT 'command type', `executor_id` int(11) NULL DEFAULT NULL COMMENT 'executor id', `process_definition_id` int(11) NULL DEFAULT NULL COMMENT 'process definition id', `command_param` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'json command parameters', `task_depend_type` tinyint(4) NULL DEFAULT NULL COMMENT 'task depend type', `failure_strategy` tinyint(4) NULL DEFAULT 0 COMMENT 'failure strategy', `warning_type` tinyint(4) NULL DEFAULT 0 COMMENT 'warning type', `warning_group_id` int(11) NULL DEFAULT NULL COMMENT 'warning group id', `schedule_time` datetime NULL DEFAULT NULL COMMENT 'scheduler time', `start_time` datetime NULL DEFAULT NULL COMMENT 'start time', `update_time` datetime NULL DEFAULT NULL COMMENT 'update time', `dependence` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'dependence', `process_instance_priority` int(11) NULL DEFAULT NULL COMMENT 'process instance priority, 0 Highest,1 High,2 Medium,3 Low,4 Lowest', `worker_group_id` int(11) NULL DEFAULT -1 COMMENT 'worker group id', `message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'message', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT=1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; END;
19:53:41.422 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_error_command
19:53:41.426 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_error_command
19:53:41.426 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_worker_group
19:53:41.426 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_worker_group
19:53:41.427 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_worker_group() BEGIN drop table if exists t_escheduler_worker_group; CREATE TABLE IF NOT EXISTS `t_escheduler_worker_group` ( `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(256) NULL DEFAULT NULL COMMENT 'worker group name', `ip_list` varchar(256) NULL DEFAULT NULL COMMENT 'worker ip list. split by [,] ', `create_time` datetime NULL DEFAULT NULL COMMENT 'create time', `update_time` datetime NULL DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT=1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; END;
19:53:41.427 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_worker_group
19:53:41.432 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_worker_group
19:53:41.432 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_task_instance_C_worker_group_id
19:53:41.432 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_task_instance_C_worker_group_id
19:53:41.433 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_task_instance_C_worker_group_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='worker_group_id') THEN ALTER TABLE t_escheduler_task_instance ADD COLUMN `worker_group_id` int(11) NULL DEFAULT -1 COMMENT 'worker group id' AFTER `task_instance_priority`; END IF; END;
19:53:41.433 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_task_instance_C_worker_group_id
19:53:41.440 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_task_instance_C_worker_group_id
19:53:41.441 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_command_C_worker_group_id
19:53:41.441 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_command_C_worker_group_id
19:53:41.441 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_command_C_worker_group_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_command' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='worker_group_id') THEN ALTER TABLE t_escheduler_command ADD COLUMN `worker_group_id` int(11) NULL DEFAULT -1 COMMENT 'worker group id' AFTER `process_instance_priority`; END IF; END;
19:53:41.442 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_command_C_worker_group_id
19:53:41.447 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_command_C_worker_group_id
19:53:41.447 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_schedules_C_worker_group_id
19:53:41.447 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_schedules_C_worker_group_id
19:53:41.448 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_schedules_C_worker_group_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_schedules' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='worker_group_id') THEN ALTER TABLE t_escheduler_schedules ADD COLUMN `worker_group_id` int(11) NULL DEFAULT -1 COMMENT 'worker group id' AFTER `process_instance_priority`; END IF; END;
19:53:41.448 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_schedules_C_worker_group_id
19:53:41.453 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_schedules_C_worker_group_id
19:53:41.453 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_process_instance_C_worker_group_id
19:53:41.453 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_process_instance_C_worker_group_id
19:53:41.454 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_worker_group_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='worker_group_id') THEN ALTER TABLE t_escheduler_process_instance ADD COLUMN `worker_group_id` int(11) NULL DEFAULT -1 COMMENT 'worker group id' AFTER `process_instance_priority`; END IF; END;
19:53:41.454 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_process_instance_C_worker_group_id
19:53:41.460 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_worker_group_id
19:53:41.461 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_process_instance_C_timeout
19:53:41.461 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_process_instance_C_timeout
19:53:41.461 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_timeout() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='timeout') THEN ALTER TABLE `t_escheduler_process_instance` ADD COLUMN `timeout` int(11) NULL DEFAULT 0 COMMENT 'time out' AFTER `worker_group_id`; END IF; END;
19:53:41.462 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_process_instance_C_timeout
19:53:41.468 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_timeout
19:53:41.469 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_process_definition_C_timeout
19:53:41.469 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_process_definition_C_timeout
19:53:41.469 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_process_definition_C_timeout() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='timeout') THEN ALTER TABLE `t_escheduler_process_definition` ADD COLUMN `timeout` int(11) NULL DEFAULT 0 COMMENT 'time out' AFTER `create_time`; END IF; END;
19:53:41.470 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_process_definition_C_timeout
19:53:41.475 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_process_definition_C_timeout
19:53:41.476 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.0.2_schema/mysql/dolphinscheduler_dml.sql
19:53:41.476 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ INSERT INTO `t_escheduler_version` (`version`) VALUES ('1.0.2')
19:53:41.486 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt enter cache
19:53:41.487 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.0.2 to 1.1.0
19:53:41.487 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.487 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.487 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.487 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_process_definition_C_tenant_id
19:53:41.487 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_process_definition_C_tenant_id
19:53:41.488 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_process_definition_C_tenant_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='tenant_id') THEN ALTER TABLE `t_escheduler_process_definition` ADD COLUMN `tenant_id` int(11) NOT NULL DEFAULT -1 COMMENT 'tenant id' AFTER `timeout`; END IF; END;
19:53:41.488 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_process_definition_C_tenant_id
19:53:41.493 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_process_definition_C_tenant_id
19:53:41.494 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_escheduler_T_t_escheduler_process_instance_C_tenant_id
19:53:41.494 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_escheduler_T_t_escheduler_process_instance_C_tenant_id
19:53:41.494 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_tenant_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_escheduler_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='tenant_id') THEN ALTER TABLE `t_escheduler_process_instance` ADD COLUMN `tenant_id` int(11) NOT NULL DEFAULT -1 COMMENT 'tenant id' AFTER `timeout`; END IF; END;
19:53:41.495 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_escheduler_T_t_escheduler_process_instance_C_tenant_id
19:53:41.500 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_escheduler_T_t_escheduler_process_instance_C_tenant_id
19:53:41.501 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.1.0_schema/mysql/dolphinscheduler_dml.sql
19:53:41.503 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.1.0 to 1.2.0
19:53:41.503 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.504 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.504 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.504 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_access_token
19:53:41.504 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_access_token
19:53:41.505 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_access_token() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_access_token' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_access_token RENAME t_ds_access_token; END IF; END;
19:53:41.505 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_access_token
19:53:41.507 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_access_token
19:53:41.508 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_alert
19:53:41.508 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_alert
19:53:41.508 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_alert() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_alert' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_alert RENAME t_ds_alert; END IF; END;
19:53:41.509 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_alert
19:53:41.510 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_alert
19:53:41.510 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_alertgroup
19:53:41.510 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_alertgroup
19:53:41.511 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_alertgroup() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_alertgroup' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_alertgroup RENAME t_ds_alertgroup; END IF; END;
19:53:41.511 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_alertgroup
19:53:41.513 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_alertgroup
19:53:41.513 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_command
19:53:41.513 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_command
19:53:41.513 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_command() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_command' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_command RENAME t_ds_command; END IF; END;
19:53:41.514 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_command
19:53:41.515 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_command
19:53:41.516 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_datasource
19:53:41.516 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_datasource
19:53:41.516 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_datasource() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_datasource' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_datasource RENAME t_ds_datasource; END IF; END;
19:53:41.516 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_datasource
19:53:41.518 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_datasource
19:53:41.519 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_error_command
19:53:41.519 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_error_command
19:53:41.519 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_error_command() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_error_command' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_error_command RENAME t_ds_error_command; END IF; END;
19:53:41.519 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_error_command
19:53:41.521 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_error_command
19:53:41.521 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_master_server
19:53:41.521 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_master_server
19:53:41.522 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_master_server() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_master_server' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_master_server RENAME t_ds_master_server; END IF; END;
19:53:41.522 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_master_server
19:53:41.524 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_master_server
19:53:41.524 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_process_definition
19:53:41.524 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_process_definition
19:53:41.524 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_process_definition() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_process_definition RENAME t_ds_process_definition; END IF; END;
19:53:41.525 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_process_definition
19:53:41.526 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_process_definition
19:53:41.527 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_process_instance
19:53:41.527 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_process_instance
19:53:41.527 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_process_instance() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_process_instance RENAME t_ds_process_instance; END IF; END;
19:53:41.528 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_process_instance
19:53:41.529 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_process_instance
19:53:41.530 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_project
19:53:41.530 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_project
19:53:41.530 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_project() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_project' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_project RENAME t_ds_project; END IF; END;
19:53:41.530 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_project
19:53:41.532 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_project
19:53:41.532 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_queue
19:53:41.532 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_queue
19:53:41.533 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_queue() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_queue' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_queue RENAME t_ds_queue; END IF; END;
19:53:41.533 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_queue
19:53:41.534 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_queue
19:53:41.535 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_datasource_user
19:53:41.535 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_datasource_user
19:53:41.535 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_datasource_user() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_datasource_user' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_datasource_user RENAME t_ds_relation_datasource_user; END IF; END;
19:53:41.535 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_datasource_user
19:53:41.537 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_datasource_user
19:53:41.537 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_process_instance
19:53:41.537 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_process_instance
19:53:41.537 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_process_instance() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_process_instance RENAME t_ds_relation_process_instance; END IF; END;
19:53:41.538 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_process_instance
19:53:41.539 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_process_instance
19:53:41.540 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_project_user
19:53:41.540 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_project_user
19:53:41.540 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_project_user() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_project_user' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_project_user RENAME t_ds_relation_project_user; END IF; END;
19:53:41.540 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_project_user
19:53:41.542 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_project_user
19:53:41.542 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_resources_user
19:53:41.543 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_resources_user
19:53:41.543 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_resources_user() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_resources_user' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_resources_user RENAME t_ds_relation_resources_user; END IF; END;
19:53:41.543 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_resources_user
19:53:41.545 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_resources_user
19:53:41.546 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_udfs_user
19:53:41.546 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_udfs_user
19:53:41.546 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_udfs_user() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_udfs_user' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_udfs_user RENAME t_ds_relation_udfs_user; END IF; END;
19:53:41.547 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_udfs_user
19:53:41.549 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_udfs_user
19:53:41.550 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_relation_user_alertgroup
19:53:41.550 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_user_alertgroup
19:53:41.550 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_relation_user_alertgroup() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_relation_user_alertgroup' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_relation_user_alertgroup RENAME t_ds_relation_user_alertgroup; END IF; END;
19:53:41.551 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_relation_user_alertgroup
19:53:41.553 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_relation_user_alertgroup
19:53:41.553 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_resources
19:53:41.553 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_resources
19:53:41.554 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_resources() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_resources' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_resources RENAME t_ds_resources; END IF; END;
19:53:41.554 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_resources
19:53:41.556 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_resources
19:53:41.557 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_schedules
19:53:41.557 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_schedules
19:53:41.557 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_schedules() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_schedules' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_schedules RENAME t_ds_schedules; END IF; END;
19:53:41.558 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_schedules
19:53:41.559 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_schedules
19:53:41.560 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_session
19:53:41.560 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_session
19:53:41.560 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_session() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_session' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_session RENAME t_ds_session; END IF; END;
19:53:41.561 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_session
19:53:41.562 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_session
19:53:41.562 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_task_instance
19:53:41.562 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_task_instance
19:53:41.563 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_task_instance() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_task_instance RENAME t_ds_task_instance; END IF; END;
19:53:41.563 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_task_instance
19:53:41.565 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_task_instance
19:53:41.565 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_tenant
19:53:41.565 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_tenant
19:53:41.566 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_tenant() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_tenant' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_tenant RENAME t_ds_tenant; END IF; END;
19:53:41.566 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_tenant
19:53:41.568 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_tenant
19:53:41.568 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_udfs
19:53:41.568 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_udfs
19:53:41.569 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_udfs() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_udfs' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_udfs RENAME t_ds_udfs; END IF; END;
19:53:41.569 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_udfs
19:53:41.571 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_udfs
19:53:41.571 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_user
19:53:41.572 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_user
19:53:41.572 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_user() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_user' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_user RENAME t_ds_user; END IF; END;
19:53:41.573 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_user
19:53:41.575 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_user
19:53:41.576 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_version
19:53:41.576 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_version
19:53:41.576 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_version() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_version' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_version RENAME t_ds_version; END IF; END;
19:53:41.577 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_version
19:53:41.579 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_version
19:53:41.580 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_worker_group
19:53:41.580 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_worker_group
19:53:41.580 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_worker_group() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_worker_group' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_worker_group RENAME t_ds_worker_group; END IF; END;
19:53:41.581 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_worker_group
19:53:41.583 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_worker_group
19:53:41.584 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ut_dolphin_T_t_ds_worker_server
19:53:41.584 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_worker_server
19:53:41.584 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ut_dolphin_T_t_ds_worker_server() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_escheduler_worker_server' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_escheduler_worker_server RENAME t_ds_worker_server; END IF; END;
19:53:41.585 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ut_dolphin_T_t_ds_worker_server
19:53:41.587 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ut_dolphin_T_t_ds_worker_server
19:53:41.588 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_alertgroup_C_desc
19:53:41.588 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_alertgroup_C_desc
19:53:41.588 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_alertgroup_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_alertgroup' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_alertgroup CHANGE COLUMN `desc` description varchar(255); END IF; END;
19:53:41.588 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_alertgroup_C_desc
19:53:41.591 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_alertgroup_C_desc
19:53:41.591 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_process_definition_C_desc
19:53:41.591 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_definition_C_desc
19:53:41.592 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_process_definition_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_process_definition CHANGE COLUMN `desc` description text; END IF; END;
19:53:41.592 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_process_definition_C_desc
19:53:41.595 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_process_definition_C_desc
19:53:41.595 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_project_C_desc
19:53:41.595 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_project_C_desc
19:53:41.596 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_project_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_project' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_project CHANGE COLUMN `desc` description varchar(200); END IF; END;
19:53:41.597 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_project_C_desc
19:53:41.599 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_project_C_desc
19:53:41.599 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_resources_C_desc
19:53:41.599 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_resources_C_desc
19:53:41.599 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_resources_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_resources' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_resources CHANGE COLUMN `desc` description varchar(256); END IF; END;
19:53:41.600 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_resources_C_desc
19:53:41.602 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_resources_C_desc
19:53:41.603 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_tenant_C_desc
19:53:41.603 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_tenant_C_desc
19:53:41.603 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_tenant_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_tenant' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_tenant CHANGE COLUMN `desc` description varchar(256); END IF; END;
19:53:41.603 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_tenant_C_desc
19:53:41.617 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_tenant_C_desc
19:53:41.618 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_udfs_C_desc
19:53:41.618 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_udfs_C_desc
19:53:41.618 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_udfs_C_desc() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_udfs' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME='desc') THEN ALTER TABLE t_ds_udfs CHANGE COLUMN `desc` description varchar(255); END IF; END;
19:53:41.619 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_udfs_C_desc
19:53:41.621 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_udfs_C_desc
19:53:41.621 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.2.0_schema/mysql/dolphinscheduler_dml.sql
19:53:41.621 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.622 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: SET FOREIGN_KEY_CHECKS=0
19:53:41.622 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_CRON_TRIGGERS SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.622 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_TRIGGERS SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.623 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_FIRED_TRIGGERS SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.623 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_JOB_DETAILS SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.623 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_JOB_DETAILS SET JOB_CLASS_NAME='org.apache.dolphinscheduler.dao.quartz.ProcessScheduleJob' WHERE JOB_CLASS_NAME='cn.escheduler.server.quartz.ProcessScheduleJob'
19:53:41.623 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_LOCKS SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.624 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_SCHEDULER_STATE SET SCHED_NAME='DolphinScheduler' WHERE SCHED_NAME='EasyScheduler'
19:53:41.624 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_user SET phone = '' WHERE phone = 'xx'
19:53:41.627 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt enter cache
19:53:41.627 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.2.0 to 1.3.0
19:53:41.627 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.627 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.627 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.628 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_process_definition_A_modify_by
19:53:41.628 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_definition_A_modify_by
19:53:41.628 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_process_definition_A_modify_by() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='modify_by') THEN ALTER TABLE t_ds_process_definition ADD `modify_by` varchar(36) DEFAULT '' COMMENT 'modify user'; END IF; END;
19:53:41.629 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_process_definition_A_modify_by
19:53:41.634 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_process_definition_A_modify_by
19:53:41.634 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_task_instance_A_executor_id
19:53:41.635 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_task_instance_A_executor_id
19:53:41.635 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_task_instance_A_executor_id() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='executor_id') THEN ALTER TABLE t_ds_task_instance ADD `executor_id` int(11) DEFAULT NULL COMMENT 'executor id'; END IF; END;
19:53:41.635 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_task_instance_A_executor_id
19:53:41.640 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_task_instance_A_executor_id
19:53:41.641 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_task_instance_C_app_link
19:53:41.641 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_task_instance_C_app_link
19:53:41.641 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_task_instance_C_app_link() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='app_link') THEN ALTER TABLE t_ds_task_instance CHANGE `app_link` `app_link` text COMMENT 'yarn app id'; END IF; END;
19:53:41.642 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_task_instance_C_app_link
19:53:41.650 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_task_instance_C_app_link
19:53:41.650 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_dolphin_T_t_ds_resources_A_pid
19:53:41.650 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_dolphin_T_t_ds_resources_A_pid
19:53:41.651 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_dolphin_T_t_ds_resources_A_pid() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_resources' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='pid') THEN ALTER TABLE t_ds_resources ADD `pid` int(11) DEFAULT -1 COMMENT 'parent id'; END IF; END;
19:53:41.651 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_dolphin_T_t_ds_resources_A_pid
19:53:41.655 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_dolphin_T_t_ds_resources_A_pid
19:53:41.656 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_dolphin_T_t_ds_resources_A_full_name
19:53:41.656 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_dolphin_T_t_ds_resources_A_full_name
19:53:41.656 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_dolphin_T_t_ds_resources_A_full_name() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_resources' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='full_name') THEN ALTER TABLE t_ds_resources ADD `full_name` varchar(255) DEFAULT NULL COMMENT 'full name'; END IF; END;
19:53:41.657 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_dolphin_T_t_ds_resources_A_full_name
19:53:41.661 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_dolphin_T_t_ds_resources_A_full_name
19:53:41.662 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_dolphin_T_t_ds_resources_A_pid
19:53:41.662 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_dolphin_T_t_ds_resources_is_directory
19:53:41.662 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_dolphin_T_t_ds_resources_is_directory() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_resources' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='is_directory') THEN ALTER TABLE t_ds_resources ADD `is_directory` tinyint(1) DEFAULT 0 COMMENT 'is directory'; END IF; END;
19:53:41.662 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_dolphin_T_t_ds_resources_is_directory
19:53:41.667 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_dolphin_T_t_ds_resources_is_directory
19:53:41.667 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- ac_dolphin_T_t_ds_process_definition_A_resource_ids
19:53:41.667 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS ac_dolphin_T_t_ds_process_definition_A_resource_ids
19:53:41.667 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE ac_dolphin_T_t_ds_process_definition_A_resource_ids() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='resource_ids') THEN ALTER TABLE t_ds_process_definition ADD `resource_ids` varchar(255) DEFAULT NULL COMMENT 'resource ids'; END IF; END;
19:53:41.668 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ac_dolphin_T_t_ds_process_definition_A_resource_ids
19:53:41.672 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE ac_dolphin_T_t_ds_process_definition_A_resource_ids
19:53:41.673 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_process_instance_R_worker_group_id
19:53:41.673 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_instance_R_worker_group_id
19:53:41.673 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_process_instance_R_worker_group_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='worker_group_id') THEN ALTER TABLE t_ds_process_instance change `worker_group_id` `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group'; END IF; END;
19:53:41.673 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_process_instance_R_worker_group_id
19:53:41.680 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_process_instance_R_worker_group_id
19:53:41.680 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_task_instance_R_worker_group_id
19:53:41.680 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_task_instance_R_worker_group_id
19:53:41.681 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_task_instance_R_worker_group_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='worker_group_id') THEN ALTER TABLE t_ds_task_instance change `worker_group_id` `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group'; END IF; END;
19:53:41.681 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_task_instance_R_worker_group_id
19:53:41.687 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_task_instance_R_worker_group_id
19:53:41.687 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_schedules_R_worker_group_id
19:53:41.687 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_schedules_R_worker_group_id
19:53:41.688 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_schedules_R_worker_group_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_schedules' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='worker_group_id') THEN ALTER TABLE t_ds_schedules change `worker_group_id` `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group'; END IF; END;
19:53:41.688 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_schedules_R_worker_group_id
19:53:41.694 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_schedules_R_worker_group_id
19:53:41.695 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_command_R_worker_group_id
19:53:41.695 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_command_R_worker_group_id
19:53:41.695 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_command_R_worker_group_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_command' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='worker_group_id') THEN ALTER TABLE t_ds_command change `worker_group_id` `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group'; END IF; END;
19:53:41.696 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_command_R_worker_group_id
19:53:41.702 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_command_R_worker_group_id
19:53:41.702 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_error_command_R_worker_group_id
19:53:41.702 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_error_command_R_worker_group_id
19:53:41.703 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_error_command_R_worker_group_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_error_command' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='worker_group_id') THEN ALTER TABLE t_ds_error_command change `worker_group_id` `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group'; END IF; END;
19:53:41.703 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_error_command_R_worker_group_id
19:53:41.709 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_error_command_R_worker_group_id
19:53:41.709 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_process_definition_A_process_definition_unique
19:53:41.709 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_definition_A_process_definition_unique
19:53:41.710 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_process_definition_A_process_definition_unique() BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.STATISTICS WHERE TABLE_NAME='t_ds_process_definition' AND TABLE_SCHEMA=(SELECT DATABASE()) AND INDEX_NAME ='process_definition_unique') THEN ALTER TABLE t_ds_process_definition ADD UNIQUE KEY `process_definition_unique` (`name`,`project_id`); END IF; END;
19:53:41.710 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_process_definition_A_process_definition_unique
19:53:41.714 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_process_definition_A_process_definition_unique
19:53:41.716 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.0_schema/mysql/dolphinscheduler_dml.sql
19:53:41.716 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.716 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: SET FOREIGN_KEY_CHECKS=0
19:53:41.716 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_resources SET pid=-1,is_directory=false WHERE pid IS NULL
19:53:41.717 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_resources SET full_name = concat('/',alias) WHERE pid=-1 and full_name IS NULL
19:53:41.718 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE QRTZ_JOB_DETAILS SET JOB_CLASS_NAME='org.apache.dolphinscheduler.service.quartz.ProcessScheduleJob' WHERE JOB_CLASS_NAME='org.apache.dolphinscheduler.server.quartz.ProcessScheduleJob'
19:53:41.718 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_process_instance instance SET `worker_group`=IFNULL((SELECT name from t_ds_worker_group WHERE instance.worker_group=CONCAT(id,'')),'default')
19:53:41.719 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_task_instance instance SET `worker_group`=IFNULL((SELECT name from t_ds_worker_group WHERE instance.worker_group=CONCAT(id,'')),'default')
19:53:41.720 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_schedules schedule SET `worker_group`=IFNULL((SELECT name from t_ds_worker_group WHERE schedule.worker_group=CONCAT(id,'')),'default')
19:53:41.720 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_command command SET `worker_group`=IFNULL((SELECT name from t_ds_worker_group WHERE command.worker_group=CONCAT(id,'')),'default')
19:53:41.721 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_error_command command SET `worker_group`=IFNULL((SELECT name from t_ds_worker_group WHERE command.worker_group=CONCAT(id,'')),'default')
19:53:41.721 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_user SET phone = '' WHERE phone = 'xx'
19:53:41.728 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt enter cache
19:53:41.729 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt enter cache
19:53:41.729 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.3.0 to 1.3.2
19:53:41.729 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.729 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.730 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.2_schema/mysql/dolphinscheduler_dml.sql
19:53:41.730 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.730 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: SET FOREIGN_KEY_CHECKS=0
19:53:41.730 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: UPDATE t_ds_user SET phone = '' WHERE phone = 'xx'
19:53:41.734 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt enter cache
19:53:41.735 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.3.2 to 1.3.3
19:53:41.735 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.735 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.739 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.740 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- add t_ds_resources_un
19:53:41.740 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE IF EXISTS uc_dolphin_T_t_ds_resources_un
19:53:41.740 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_resources_un() BEGIN IF NOT EXISTS ( SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME = 't_ds_resources' AND CONSTRAINT_NAME = 't_ds_resources_un' ) THEN ALTER TABLE t_ds_resources ADD CONSTRAINT t_ds_resources_un UNIQUE KEY (full_name,`type`); END IF; END;
19:53:41.741 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_resources_un()
19:53:41.745 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE IF EXISTS uc_dolphin_T_t_ds_resources_un
19:53:41.746 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.3_schema/mysql/dolphinscheduler_dml.sql
19:53:41.750 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.3.3 to 1.3.5
19:53:41.751 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.751 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.751 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.751 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_process_instance_R_host
19:53:41.751 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_instance_R_host
19:53:41.752 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_process_instance_R_host() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_process_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='host') THEN ALTER TABLE t_ds_process_instance MODIFY COLUMN `host` varchar(135); END IF; END;
19:53:41.752 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_process_instance_R_host
19:53:41.763 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_process_instance_R_host
19:53:41.764 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_task_instance_R_host
19:53:41.764 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_task_instance_R_host
19:53:41.764 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_task_instance_R_host() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_task_instance' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='host') THEN ALTER TABLE t_ds_task_instance MODIFY COLUMN `host` varchar(135); END IF; END;
19:53:41.765 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_task_instance_R_host
19:53:41.773 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_task_instance_R_host
19:53:41.773 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.5_schema/mysql/dolphinscheduler_dml.sql
19:53:41.777 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.3.5 to 1.3.6
19:53:41.777 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.777 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.777 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.778 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_worker_group_R_ip_list
19:53:41.778 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_worker_group_R_ip_list
19:53:41.778 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_worker_group_R_ip_list() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_worker_group' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='ip_list') THEN ALTER TABLE t_ds_worker_group CHANGE COLUMN `ip_list` `addr_list` text; ALTER TABLE t_ds_worker_group MODIFY COLUMN `name` varchar(255) NOT NULL; ALTER TABLE t_ds_worker_group ADD UNIQUE KEY `name_unique` (`name`); END IF; END;
19:53:41.779 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_worker_group_R_ip_list
19:53:41.795 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_worker_group_R_ip_list
19:53:41.796 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_qrtz_fired_triggers_R_entry_id
19:53:41.796 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_qrtz_fired_triggers_R_entry_id
19:53:41.796 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_qrtz_fired_triggers_R_entry_id() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='QRTZ_FIRED_TRIGGERS' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='entry_id') THEN ALTER TABLE QRTZ_FIRED_TRIGGERS MODIFY COLUMN `entry_id` varchar(200); END IF; END;
19:53:41.797 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_qrtz_fired_triggers_R_entry_id
19:53:41.807 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_qrtz_fired_triggers_R_entry_id
19:53:41.808 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.6_schema/mysql/dolphinscheduler_dml.sql
19:53:41.811 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - upgrade DolphinScheduler metadata version from 1.3.6 to 1.3.7
19:53:41.811 [main] INFO org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager - Begin upgrading DolphinScheduler's table structure
19:53:41.811 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - dolphinscheduler
19:53:41.811 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: /* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
19:53:41.811 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_datasource_R_note
19:53:41.811 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_datasource_R_note
19:53:41.811 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_datasource_R_note() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_datasource' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='note') THEN ALTER TABLE t_ds_datasource MODIFY COLUMN `note` varchar(255) DEFAULT NULL COMMENT 'description'; END IF; END;
19:53:41.812 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_datasource_R_note
19:53:41.818 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_datasource_R_note
19:53:41.819 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_resources_R_description
19:53:41.819 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_resources_R_description
19:53:41.819 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_resources_R_description() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_resources' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='description') THEN ALTER TABLE t_ds_resources MODIFY COLUMN `description` varchar(255) DEFAULT NULL; END IF; END;
19:53:41.819 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_resources_R_description
19:53:41.825 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_resources_R_description
19:53:41.825 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_schedules_R_crontab
19:53:41.825 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_schedules_R_crontab
19:53:41.826 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_schedules_R_crontab() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_schedules' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='crontab') THEN ALTER TABLE t_ds_schedules MODIFY COLUMN `crontab` varchar(255) NOT NULL COMMENT 'crontab description'; ALTER TABLE t_ds_schedules MODIFY COLUMN `worker_group` varchar(64) DEFAULT '' COMMENT 'worker group id'; END IF; END;
19:53:41.826 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_schedules_R_crontab
19:53:41.832 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_schedules_R_crontab
19:53:41.832 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_tenant_R_description
19:53:41.832 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_tenant_R_description
19:53:41.833 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_tenant_R_description() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_tenant' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='description') THEN ALTER TABLE t_ds_tenant MODIFY COLUMN `description` varchar(255) DEFAULT NULL; END IF; END;
19:53:41.833 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_tenant_R_description
19:53:41.838 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_tenant_R_description
19:53:41.838 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - -- uc_dolphin_T_t_ds_worker_group_R_name
19:53:41.838 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_worker_group_R_name
19:53:41.839 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CREATE PROCEDURE uc_dolphin_T_t_ds_worker_group_R_name() BEGIN IF EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME='t_ds_worker_group' AND TABLE_SCHEMA=(SELECT DATABASE()) AND COLUMN_NAME ='name') THEN ALTER TABLE t_ds_worker_group MODIFY COLUMN `name` varchar(255) NOT NULL COMMENT 'worker group name'; END IF; END;
19:53:41.839 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL uc_dolphin_T_t_ds_worker_group_R_name
19:53:41.840 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: DROP PROCEDURE uc_dolphin_T_t_ds_worker_group_R_name
19:53:41.841 [main] INFO org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - sqlSQLFilePath/home/lqs/module/dolphinscheduler-1.3.9-install/sql/upgrade/1.3.7_schema/mysql/dolphinscheduler_dml.sql
19:53:41.844 [main] INFO org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler - upgrade DolphinScheduler finished
19:53:41.844 [main] INFO org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler - create DolphinScheduler success
7、配置一键部署脚本
a、修改解压目录下的conf/config目录下的install_config.conf文件
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# NOTICE : If the following config has special characters in the variable `.*[]^${}\+?|()@#&`, Please escape, for example, `[` escape to `\[`
# postgresql or mysql
dbtype="mysql"
# db config
# db address and port
dbhost="nwh120:3306"
# db username
username="dolphinscheduler"
# database name
dbname="dolphinscheduler"
# db passwprd
# NOTICE: if there are special characters, please use the \ to escape, for example, `[` escape to `\[`
password="dolphinscheduler"
# zk cluster
zkQuorum="nwh120:2181,nwh121:2181,nwh122:2181"
# Note: the target installation path for dolphinscheduler, please not config as the same as the current path (pwd)
installPath="/home/lqs/module/dolphinscheduler"
# deployment user
# Note: the deployment user needs to have sudo privileges and permissions to operate hdfs. If hdfs is enabled, the root directory needs to be created by itself
deployUser="lqs"
# alert config
# mail server host
mailServerHost="smtp.exmail.qq.com"
# mail server port
# note: Different protocols and encryption methods correspond to different ports, when SSL/TLS is enabled, make sure the port is correct.
mailServerPort="25"
# sender
mailSender="xxxxxxxxxx"
# user
mailUser="xxxxxxxxxx"
# sender password
# note: The mail.passwd is email service authorization code, not the email login password.
mailPassword="xxxxxxxxxx"
# TLS mail protocol support
starttlsEnable="true"
# SSL mail protocol support
# only one of TLS and SSL can be in the true state.
sslEnable="false"
#note: sslTrust is the same as mailServerHost
sslTrust="smtp.exmail.qq.com"
# user data local directory path, please make sure the directory exists and have read write permissions
dataBasedirPath="/tmp/dolphinscheduler"
# resource storage type: HDFS, S3, NONE
resourceStorageType="HDFS"
# resource store on HDFS/S3 path, resource file will store to this hadoop hdfs path, self configuration, please make sure the directory exists on hdfs and have read write permissions. "/dolphinscheduler" is recommended
resourceUploadPath="/dolphinscheduler"
# if resourceStorageType is HDFS，defaultFS write namenode address，HA you need to put core-site.xml and hdfs-site.xml in the conf directory.
# if S3，write S3 address，HA，for example ：s3a://dolphinscheduler，
# Note，s3 be sure to create the root directory /dolphinscheduler
defaultFS="hdfs://nwh120:8020"
# if resourceStorageType is S3, the following three configuration is required, otherwise please ignore
s3Endpoint="http://192.168.xx.xx:9010"
s3AccessKey="xxxxxxxxxx"
s3SecretKey="xxxxxxxxxx"
# resourcemanager port, the default value is 8088 if not specified
resourceManagerHttpAddressPort="8088"
# if resourcemanager HA is enabled, please set the HA IPs; if resourcemanager is single, keep this value empty
yarnHaIps=
# if resourcemanager HA is enabled or not use resourcemanager, please keep the default value; If resourcemanager is single, you only need to replace ds1 to actual resourcemanager hostname
singleYarnIp="nwh121"
# who have permissions to create directory under HDFS/S3 root path
# Note: if kerberos is enabled, please config hdfsRootUser=
hdfsRootUser="lqs"
# kerberos config
# whether kerberos starts, if kerberos starts, following four items need to config, otherwise please ignore
kerberosStartUp="false"
# kdc krb5 config file path
krb5ConfPath="$installPath/conf/krb5.conf"
# keytab username
keytabUserName="hdfs-mycluster@ESZ.COM"
# username keytab path
keytabPath="$installPath/conf/hdfs.headless.keytab"
# kerberos expire time, the unit is hour
kerberosExpireTime="2"
# api server port
apiServerPort="12345"
# install hosts
# Note: install the scheduled hostname list. If it is pseudo-distributed, just write a pseudo-distributed hostname
ips="nwh120,nwh121,nwh122"
# ssh port, default 22
# Note: if ssh port is not default, modify here
sshPort="22"
# run master machine
# Note: list of hosts hostname for deploying master
masters="nwh120"
# run worker machine
# note: need to write the worker group name of each worker, the default value is "default"
workers="nwh120:default,nwh121:default,nwh122:default"
# run alert machine
# note: list of machine hostnames for deploying alert server
alertServer="nwh120"
# run api machine
# note: list of machine hostnames for deploying api server
apiServers="nwh120"
8、一键部署DolphinScheduler
a、启动Zookeeper集群
b、一键部署并启动DolphinScheduler
[lqs@nwh120 dolphinscheduler-1.3.9]$ pwd
/home/lqs/module/dolphinscheduler-1.3.9
[lqs@nwh120 dolphinscheduler-1.3.9]$ ./install.sh
出现一下进程时说明启动成功
网页访问：http://nwh120:12345/dolphinscheduler
默认登录账号：admin
密码：dolphinscheduler123
