1.检查配置文件 my.cnf
如果存在修改为如下值,没有则添加
- innodb_large_prefix = 1
- innodb_file_per_table = 1
- innodb_file_format = Barracuda
2.修改建表语句,添加 row_format=dynamic
drop table if exists QRTZ_SCHEDULER_STATE;
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 ROW_FORMAT=DYNAMIC;