主题 : jeecms连接linux下的mysql报错
级别: 秀才
UID: 138983
积分:53 加为好友
威望: 0 精华: 0
主题:4 回复:18
注册时间:2021-09-14
在线时长:0
1#   发表于:2022-01-17 10:03:37  IP:111.96.*.*
jeecms在windows下连接mysql数据库正常,然后把数据库全部拷贝到Linux下的mysql后,连接linux下的mysql就报错了,麻烦看看怎么回事。


2022-01-17 09:53:08.446 [localhost-startStop-1] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: com.jeecms.component.QuartzConfiguration$AutowiringSpringBeanJobFactory@388c6c17 
2022-01-17 09:53:08.484 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成数据统计任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.485 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志统计任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.487 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志告警任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.488 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志预警任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.489 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 粉丝统计任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.491 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 内容统计任务启动失败, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:08.492 [pool-1-thread-1] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 定时清除日志, time:Mon Jan 17 09:53:08 CST 2022 
2022-01-17 09:53:11.108 [localhost-startStop-1] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Initializing ExecutorService 
2022-01-17 09:53:11.132 [localhost-startStop-1] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Initializing ExecutorService 'taskExecutor' 
2022-01-17 09:53:11.858 [localhost-startStop-1] INFO  o.flowable.spring.SpringProcessEngineConfiguration - Found 1 Engine Configurators in total: 
2022-01-17 09:53:11.858 [localhost-startStop-1] INFO  o.flowable.spring.SpringProcessEngineConfiguration - class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000) 
2022-01-17 09:53:11.858 [localhost-startStop-1] INFO  o.flowable.spring.SpringProcessEngineConfiguration - Executing beforeInit() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000) 
2022-01-17 09:53:13.197 [localhost-startStop-1] INFO  o.flowable.spring.SpringProcessEngineConfiguration - Executing configure() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000) 
2022-01-17 09:53:13.268 [localhost-startStop-1] INFO  org.flowable.idm.engine.impl.db.IdmDbSchemaManager - performing create on identity with resource org/flowable/idm/db/create/flowable.mysql.create.identity.sql 
2022-01-17 09:53:13.269 [localhost-startStop-1] INFO  org.flowable.idm.engine.impl.db.IdmDbSchemaManager - Found MySQL: majorVersion=5 minorVersion=7 
2022-01-17 09:53:13.604 [localhost-startStop-1] ERROR org.flowable.idm.engine.impl.db.IdmDbSchemaManager - problem during schema create, statement alter table ACT_ID_MEMBERSHIP 
add constraint ACT_FK_MEMB_GROUP 
foreign key (GROUP_ID_) 
references ACT_ID_GROUP (ID_) 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-10eb_69'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
级别: 秀才
UID: 138983
积分:53 加为好友
威望: 0 精华: 0
主题:4 回复:18
注册时间:2021-09-14
在线时长:0
2#   发表于:2022-01-17 10:04:41  IP:111.96.*.*
图片看的更直观一些
级别: 总版主
UID: 10736
积分:148366 加为好友
威望: 205 精华: 42
主题:287 回复:126119
注册时间:2010-09-08
在线时长:14.92
3#   发表于:2022-01-17 10:09:35  IP:59.202.*.*
linux下数据库没有忽略大小写,设置下数据库忽略大小写,然后重新导入库
路漫漫其修远兮,吾将上下而求索!
级别: 秀才
UID: 138983
积分:53 加为好友
威望: 0 精华: 0
主题:4 回复:18
注册时间:2021-09-14
在线时长:0
4#   发表于:2022-01-17 10:18:53  IP:111.96.*.*
回复第3楼
解决了,就是这个问题,谢谢
级别: 总版主
UID: 10736
积分:148366 加为好友
威望: 205 精华: 42
主题:287 回复:126119
注册时间:2010-09-08
在线时长:14.92
5#   发表于:2022-01-17 10:25:03  IP:59.202.*.*
路漫漫其修远兮,吾将上下而求索!
1 共1页