vue8.0版本数据库导入失败

bug反馈 未结 1 151
黄迪
黄迪 VIP2 2021-01-22 13:50:18   最后修改:2021-01-22 14:00:57
收藏
产品:vue 版本:8.0
img[/userfiles/fly/ac49399502974d568b0ac0a6683137b4/files/1611294445795.] MySQL5.7.32 linux系统 [hr] [pre] [SQL] Query jeeplus-vue-base start [ERR] 1153 - Got a packet bigger than 'max_allowed_packet' bytes [ERR] 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) DEFAULT NULL, `STR_PROP_2` varchar(512) DEFAULT NULL, `STR_PROP_3` varchar(512) DEFAULT NULL, `INT_PROP_1` int(11) DEFAULT NULL, `INT_PROP_2` int(11) DEFAULT NULL, `LONG_PROP_1` bigint(20) DEFAULT NULL, `LONG_PROP_2` bigint(20) DEFAULT NULL, `DEC_PROP_1` decimal(13,4) DEFAULT NULL, `DEC_PROP_2` decimal(13,4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) DEFAULT NULL, `BOOL_PROP_2` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Table structure for `qrtz_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; 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) DEFAULT NULL, `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, `PRIORITY` int(11) DEFAULT NULL, `TRIGGER_STATE` varchar(16) NOT NULL, `TRIGGER_TYPE` varchar(8) NOT NULL, `START_TIME` bigint(13) NOT NULL, `END_TIME` bigint(13) DEFAULT NULL, `CALENDAR_NAME` varchar(200) DEFAULT NULL, `MISFIRE_INSTR` smallint(2) DEFAULT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of `qrtz_triggers` -- ---------------------------- BEGIN; INSERT INTO `qrtz_triggers` VALUES ('clusteredScheduler', '测试任务', '1', '测试任务', '1', null, '1571994670000', '1571994665000', '5', 'ERROR', 'CRON', '1571927405000', '0', null, '0', ''), ('QuartzScheduler', '测试任务', '1', '测试任务', '1', null, '1556111685000', '1556111680000', '5', 'ACQUIRED', 'CRON', '1546164478000', '0', null, '0', ''), ('schedulerFactoryBean', '测试任务', '1', '测试任务', '1', null, '1507993455000', '1507993450000', '5', 'PAUSED', 'CRON', '1501749032000', '0', null, '0', ''); COMMIT; -- ---------------------------- -- Table structure for `sys_area` -- ---------------------------- DROP TABLE IF EXISTS `sys_area`; CREATE TABLE `sys_area` ( `id` varchar(64) NOT NULL COMMENT '编号', `parent_id` varchar(64) NOT NULL COMMENT '父级编号', `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号', `name` varchar(100) NOT NULL COMMENT '名称', `sort` decimal(10,0) NOT NULL COMMENT '排序', `code` varchar(100) DEFAULT NULL COMMENT '区域编码', `type` char(1) DEFAULT NULL COMMENT '区域类型', `create_by` varchar(64) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息', `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `sys_area_parent_id` (`parent_id`), KEY `sys_area_del_flag` (`del_flag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='区域表'; [/pre] [pre] -- ---------------------------- -- Records of `sys_area` -- ---------------------------- BEGIN; INSERT INTO `sys_area` VALUES ('100000', '0', '0,', '中国', '1', '100000', '1', '1', '2015-01-01 00:00:00', '1', '2020-02-06 14:20:55', '', '0'), ('110000', '100000', '0,100000,', '北京', '2', '110000', '2', '1', '2015-01-01 00:00:00', '1', '2020-04-08 16:59:35', '', '0'), ('110100', '110000', '0,100000,110000,', '北京市', '3', '110100', '3', '1', '2015-01-01 00:00:00', [ERR] 1146 - Table 'test_jeeplus_boot.sys_log' doesn't exist [ERR] INSERT INTO `sys_log` VALUES ('b6336efa564a4ce8998cd9d07aa6488e', '1', '系统登录', '1', '2020-03-28 12:27:51', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36', '/extension/actCategory/treeData', 'GET', '', ''), ('b65717cd86af45659ec9a23f20ecbec8', '1', '系统登录', '1', '2020-02-02 16:47:57', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36', '/extension/formCategory/treeData', 'GET', '', ''), ('b6ccba645be94d058d558ffae1f3b646', '1', '系统登录', '1', '2020-04-12 20:30:06', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36', '/sys/user/getMenus', 'GET', '', ''), ('b729db4e081d48f6b1cbd2f8f0b6895f', '2', '系统管理-菜单管理-删除', '1', '2020-09-06 10:25:31', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.83 Safari/537.36', '/sys/menu/delete/', 'DELETE', 0x69643d6561356361613764376435313439333138366135653662623033303864353066, ''), ('b73b7472f7bb44648b64361f3ede34a1', '1', '系统登录', '1', '2020-07-29 23:48:54', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36', '/sys/user/queryById', 'GET', 0x69643d31, ''), ('b75fcd421ff445f298c1340cd4c94de0', '1', '系统登录', '1', '2020-08-16 12:24:58', '127.0.0.1', 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Mobile Safari/537.36', '/sys/user/info', 'GET', '', ''), ('b775b187d7b84098ab450282762950eb', '1', '系统登录', '1', '2020-04-22 21:20:12', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.4 Safari/605.1.15', '/sys/user/getMenus', 'GET', '', ''), ('b7850fe7adb4429b9f7e473317cca69f', '2', '个人中心-通告管理-删除', '1', '2020-08-21 11:14:47', '127.0.0.1', 'Mozilla/5.0 (Linux; Android 10; LIO-AN00; HMSCore 5.0.1.313) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 HuaweiBrowser/10.1.4.301 Mobile Safari/537.36', '/notify/oaNotify/delete', 'DELETE', 0x69643d3739383165383639383664343435303461363764643636306263363235383637, ''), ('b7a0518b72e642c59a7b62dfebed87f8', '1', '系统登录', '1', '2020-09-11 11:05:40', '127.0.0.1', 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Mobile Safari/537.36', '/sys/user/info', 'GET', '', ''), ('b7bcc247e3584697a841b73bad2f728a', '2', '动态表单-表单设计器-删除', '1', '2020-06-06 17:15:27', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '/form/make/delete', 'DELETE', 0x6964733d63386131313635326638343734363039626638663836303738336335386232372c3132323466393863316264653466313338626135343539306665616632323735, ''), ('b7ca91e30ec94306b91c329256169a56', '3', '', '1', '2021-01-07 15:07:36', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', '/flowable/form/submitTaskFormData', 'POST', 0x70726f63496e7349643d39363539333262642d353062362d313165622d623231352d616364653438303031313232267461736b49643d39363762383765322d353062362d313165622d623231352d6163646534383030313132322661737369676e65653d26636f6d6d656e742e6d6573736167653d26636f6d6d656e742e747970653d616772656526636f6d6d656e742e7374617475733de5908ce6848f26636f6d6d656e742e757365724964733d26636f6d6d656e742e61737369676e65653d26646174613d7b226167726565223a747275652c226469736167726565223a66616c73652c227469746c65223a22e7aea1e79086e5919820e59ca820323032312d30312d30372031343a353920e58f91e8b5b7e4ba86205be8afb7e58187e6b581e7a88b315d222c2261737369676e6565222e2e2e, 0x6f72672e666c6f7761626c652e636f6d6d6f6e2e656e67696e652e6170692e466c6f7761626c654f7074696d69737469634c6f636b696e67457863657074696f6e3a20486973746f7269635461736b496e7374616e6365456e746974795b69643d39363762383765322d353062362d31316 [ERR] 1146 - Table 'test_jeeplus_boot.test_zb' doesn't exist [ERR] INSERT INTO `test_zb` VALUES ('id', 'label', 'area', 'time', 'value'), ('1001', '南京市A股上市公司净利润', '南京', '2018.1', '42.08'), ('1002', '南京市A股上市公司净利润', '南京', '2018.2', '42.08'), ('1003', '南京市A股上市公司净利润', '南京', '2018.3', '42.08'), ('1004', '南京市A股上市公司净利润', '南京', '2018.4', '47.51'), ('1005', '南京市A股上市公司净利润', '南京', '2018.5', '47.51'), ('1006', '南京市A股上市公司净利润', '南京', '2018.6', '47.51'), ('1007', '南京市A股上市公司净利润', '南京', '2018.7', '52.8'), ('1008', '南京市A股上市公司净利润', '南京', '2018.8', '52.8'), ('1009', '南京市A股上市公司净利润', '南京', '2018.9', '52.8'), ('1010', '南京市A股上市公司净利润', '南京', '2018.10', '43.96'), ('1011', '南京市A股上市公司净利润', '南京', '2018.11', '43.96'), ('1012', '南京市A股上市公司净利润', '南京', '2018.12', '43.96'), ('1013', '南京市A股上市公司净利润', '南京', '2019.1', '45.26'), ('1014', '南京市A股上市公司净利润', '南京', '2019.2', '45.26'), ('1015', '南京市A股上市公司净利润', '南京', '2019.3', '45.26'), ('1016', '南京市A股上市公司净利润', '南京', '2019.4', '51.88'), ('1017', '南京市A股上市公司净利润', '南京', '2019.5', '51.88'), ('1018', '南京市A股上市公司净利润', '南京', '2019.6', '51.88'), ('1019', '南京市A股上市公司净利润', '南京', '2019.7', '54.49'), ('1020', '南京市A股上市公司净利润', '南京', '2019.8', '54.49'), ('1021', '南京市A股上市公司净利润', '南京', '2019.9', '54.49'), ('1022', '南京市A股上市公司净利润', '南京', '2019.10', '55.88'), ('1023', '南京市A股上市公司净利润', '南京', '2019.11', '55.88'), ('1024', '南京市A股上市公司净利润', '南京', '2019.12', '55.88'), ('1025', '南京市A股上市公司净利润', '南京', '2020.1', '41.32'), ('1026', '南京市A股上市公司净利润', '南京', '2020.2', '41.32'), ('1027', '南京市A股上市公司净利润', '南京', '2020.3', '41.32'), ('1028', '南京市A股上市公司净利润', '南京', '2020.4', '55.23'), ('1029', '南京市A股上市公司净利润', '南京', '2020.5', '55.23'), ('1030', '南京市A股上市公司净利润', '南京', '2020.6', '55.23'), ('1031', '南京市A股上市公司净利润', '南京', '2020.7', '57.18'), ('1032', '南京市A股上市公司净利润', '南京', '2020.8', '57.18'), ('1033', '南京市A股上市公司净利润', '南京', '2020.9', '57.18'), ('1034', '消费意愿指数', '南京', '2018.1', '122.3'), ('1035', '消费意愿指数', '南京', '2018.2', '122.6'), ('1036', '消费意愿指数', '南京', '2018.3', '122.3'), ('1037', '消费意愿指数', '南京', '2018.4', '122.9'), ('1038', '消费意愿指数', '南京', '2018.5', '122.9'), ('1039', '消费意愿指数', '南京', '2018.6', '118.2'), ('1040', '消费意愿指数', '南京', '2018.7', '119.7'), ('1041', '消费意愿指数', '南京', '2018.8', '118.6'), ('1042', '消费意愿指数', '南京', '2018.9', '118.5'), ('1043', '消费意愿指数', '南京', '2018.10', '119.1'), ('1044', '消费意愿指数', '南京', '2018.11', '122.1'), ('1045', '消费意愿指数', '南京', '2018.12', '123'), ('1046', '消费意愿指数', '南京', '2019.1', '123.7'), ('1047', '消费意愿指数', '南京', '2019.2', '126'), ('1048', '消费意愿指数', '南京', '2019.3', '124.1'), ('1049', '消费意愿指数', '南京', '2019.4', '125.3'), ('1050', '消费意愿指数', '南京', '2019.5', '123.4'), ('1051', '消费意愿指数', '南京', '2019.6', '125.9'), ('1052', '消费意愿指数', '南京', '2019.7', '124.4'), ('1053', '消费意愿指数', '南京', '2019.8', '122.4'), ('1054', '消费意愿指数', '南京', '2019.9', '124.1'), ('1055', '消费意愿指数', '南京', '2019.10', '124.3'), ('1056', '消费意愿指数', '南京', '2019.11', '124.5'), ('1057', '消费意愿指数', '南京', '2019.12', '124.7'), ('1058', '消费意愿指数', '南京', '2020.1', '123.3'), ('1059', '消费意愿指数', '南京', '2020.2', '89.3'), ('1060', '消费意愿指数', '南京', '2020.3', '94.3'), ('1061', '消费意愿指数', '南京', '2020.4', '106.4'), ('1062', '消费意愿指数', '南京', '2020.5', '119.6'), ('1063', '消费意愿指数', '南京', '2020.6', '122.6'), ('1064', '消费意愿指数', '南京', '2020.7', '122.9'), ('1065', '消费意愿指数', '南京', '2020.8', '123.2'), ('1066', '消费意愿指数', '南京', '2020.9', '123.7'), ('1067', '二手房房价水平', '南京', '2018.1', '25757'), ('1068', '二手房房价水平', '南京', '2018.2', '25691'), ('1069', '二手房房价水平', '南京', '2018.3', '26844'), ('1070', '二手房房价水平', '南京', '2018.4', '26839'), ('1071', '二手房房价水平', '南京', '2018.5', '26889'), ('1072', '二手房房价水平', '南京', '2018.6', '26953'), ('1073', '二手房房价水平', '南京', '2018.7', '26191'), ('1074', '二手房房价水平', '南京', '2018.8', '26386'), ('1075', '二手房房价水平', '南京', '2018.9', '27117'), ('1076', '二手房房价水平', '南京', '2018.10', '27129'), ('1077', '二手房房价水平', '南京', '2018.11', '27335'), ('1078', '二手房房价水平', '南京', '2018.12', '27568'), ('1079', '二手房房价水平', '南京', '2019.1', '27751'), ('1080', '二手房房价水平', '南京', '2019.2', '28581'), ('1081', '二手房房价水平', '南京', '2019.3', '29039'), ('1082', '二手房房价水平', '南京', '2019.4', '29047'), ('1083', '二手房房价水平', '南京', '2019.5', '29177'), ('1084', '二手房房价水平', '南京', '2019.6', '28776'), ('1085', '二手房房价水 [SQL] Finished with error [/pre]
回帖
  • 黄迪 VIP2 (楼主)
    2021-01-22 14:08:00
    已解决 修改my.ini max_allowed_packet=256M
    0 回复