yugabyte version 2.7.1.1
This is createing table sql:
CREATE SEQUENCE IF NOT EXISTS xxl_job_info_id_seq;
-- Table Definition
CREATE TABLE "public"."xxl_job_info" (
"id" int4 NOT NULL DEFAULT nextval('xxl_job_info_id_seq'::regclass),
"job_group" int4 NOT NULL,
"job_desc" varchar NOT NULL,
"add_time" timestamp,
"update_time" timestamp,
"author" varchar,
"alarm_email" varchar,
"schedule_type" varchar NOT NULL,
"schedule_conf" varchar,
"misfire_strategy" varchar NOT NULL,
"executor_route_strategy" varchar,
"executor_handler" varchar,
"executor_param" varchar,
"executor_block_strategy" varchar,
"executor_timeout" int4 NOT NULL,
"executor_fail_retry_count" int4 NOT NULL,
"glue_type" varchar NOT NULL,
"glue_source" text,
"glue_remark" varchar,
"glue_updatetime" timestamp,
"child_jobid" varchar,
"trigger_status" int2 NOT NULL,
"trigger_last_time" int8 NOT NULL,
"trigger_next_time" int8 NOT NULL
);
Here is insert sql :
INSERT INTO xxl_job_info (
job_group,
job_desc,
add_time,
update_time,
author,
alarm_email,
schedule_type,
schedule_conf,
misfire_strategy,
executor_route_strategy,
executor_handler,
executor_param,
executor_block_strategy,
executor_timeout,
executor_fail_retry_count,
glue_type,
glue_source,
glue_remark,
glue_updatetime,
child_jobid,
trigger_status,
trigger_last_time,
trigger_next_time
)
VALUES
(
3,
'task description',
now(),
now(),
'lyn',
'',
'NONE',
'',
'FIRE_ONCE_NOW',
'ROUND',
'testJob',
'executorParam',
'SERIAL_EXECUTION',
5,
5,
'BEAN',
'',
'',
now(),
'',
1,
666,
777
);
And when I use the update sql to modify the values, it works.
I don't see any error in creating process:
I test some other way: When I create another table(with different table name) using above creating tabel sql, inserting works well. But it works wrong when I delete xxl_job_info, then recreate it with same name.
Maybe there is some dirty data in db, how could I find it ?