主题 : jeecms1.4x |
级别: 童生
![]() |
1# 发表于:2020-07-13 13:23:26 IP:58.207.*.*
|
||||
---|---|---|---|---|---|
级别: 童生
![]() |
2# 发表于:2020-07-13 13:24:16 IP:58.207.*.*
启动后,访问一直出现这个问题,怎么解决呀?
|
||
---|---|---|---|
级别: 童生
![]() |
4# 发表于:2020-07-13 13:38:16 IP:58.207.*.*
Exception in thread "Quartz Scheduler [schedulerFactoryBean]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecms14.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecms14.QRTZ_LOCKS' doesn't exist]]
at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:733) Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecms14.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecms14.QRTZ_LOCKS' doesn't exist]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:697) at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:539) at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:730) Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecms14.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecms14.QRTZ_LOCKS' doesn't exist] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3842) at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:839) at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:695) ... 3 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecms14.QRTZ_LOCKS' doesn't exist 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) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96) ... 7 more |
||
---|---|---|---|
级别: 童生
![]() |
5# 发表于:2020-07-13 13:38:35 IP:58.207.*.*
回复第3楼有一张表不存在
|
||
---|---|---|---|
级别: 童生
![]() |
7# 发表于:2020-07-13 13:55:24 IP:58.207.*.*
回复第6楼:表是存在的而且我觉得这个错误不应该导致我项目启动后,无法访问系统呀?这是为什么呢?求指导。
|
||
---|---|---|---|
级别: 童生
![]() |
9# 发表于:2020-07-13 14:14:15 IP:58.207.*.*
回复第8楼:我设置了数据库表不区分大小写后成功启动,但是在访问http://localhost:8080/的时候还是会出现那些,页面也无法正常访问。
2020-07-13 14:12:47.874 [http-nio-8080-exec-6] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/header.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:47.879 [http-nio-8080-exec-5] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/icon/iconfont.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:47.897 [http-nio-8080-exec-3] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/reset.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:47.899 [http-nio-8080-exec-2] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/jSlider.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:47.963 [http-nio-8080-exec-4] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/index.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:50.257 [http-nio-8080-exec-8] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/fonts/iconfont.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:50.413 [http-nio-8080-exec-7] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/jquery.my-message.1.1.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:50.593 [http-nio-8080-exec-9] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery-1.12.4.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:51.102 [http-nio-8080-exec-10] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/sm.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:51.190 [http-nio-8080-exec-11] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/crypto-js.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:52.561 [http-nio-8080-exec-12] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/header.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:52.769 [http-nio-8080-exec-13] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.my-message.1.1.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:52.937 [http-nio-8080-exec-14] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.validate.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:53.849 [http-nio-8080-exec-15] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.page.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:53.881 [http-nio-8080-exec-16] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/chinese.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:54.694 [http-nio-8080-exec-17] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/public.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:54.926 [http-nio-8080-exec-18] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/icon/iconfont.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:*121 [http-nio-8080-exec-20] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/app.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:56.479 [http-nio-8080-exec-21] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/permCheck.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:56.609 [http-nio-8080-exec-19] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/images/index/logo-title.png] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:57.014 [http-nio-8080-exec-22] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/images/index/logo-foot.png] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:57.180 [http-nio-8080-exec-25] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/fonts/iconfont.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:12:59.769 [http-nio-8080-exec-24] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/jquery.my-message.1.1.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:02.019 [http-nio-8080-exec-28] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery-1.12.4.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:04.580 [http-nio-8080-exec-29] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/sm.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:06.037 [http-nio-8080-exec-23] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/images/index/chatu.png] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:06.825 [http-nio-8080-exec-26] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/crypto-js.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:08.996 [http-nio-8080-exec-27] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.my-message.1.1.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:10.800 [http-nio-8080-exec-30] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/footer.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:10.845 [http-nio-8080-exec-33] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/unslider.min.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:10.887 [http-nio-8080-exec-34] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/index.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:10.921 [http-nio-8080-exec-37] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/front.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:10.951 [http-nio-8080-exec-32] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.jSlider.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:11.285 [http-nio-8080-exec-40] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.validate.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:13.794 [http-nio-8080-exec-36] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.page.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:16.053 [http-nio-8080-exec-31] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/chinese.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:18.523 [http-nio-8080-exec-39] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/public.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:21.020 [http-nio-8080-exec-45] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/app.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:23.252 [http-nio-8080-exec-42] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/permCheck.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:26.985 [http-nio-8080-exec-49] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/css/footer.css] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:30.229 [http-nio-8080-exec-48] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/images/index/logo-foot.png] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:30.240 [http-nio-8080-exec-53] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/front.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:32.710 [http-nio-8080-exec-35] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/jquery.jSlider.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:35.009 [http-nio-8080-exec-41] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/unslider.min.js] in DispatcherServlet with name 'frontDispatcherServlet' 2020-07-13 14:13:37.356 [http-nio-8080-exec-44] WARN org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/r/cms/www/default/js/index.js] in DispatcherServlet with name 'frontDispatcherServlet' |
||
---|---|---|---|
级别: 童生
![]() |
10# 发表于:2020-07-13 14:17:54 IP:58.207.*.*
![]() |
||
---|---|---|---|