服务器配置---分开设置三个服务器端口后无法登陆

danielhuang

管理员好！

  1、 我如果将三个服务器设置相同的端口，可以登陆系统，分开设置，就无法登陆系统，登陆界面一直转圈。是怎么回事呢？日志如下
  2、正常登陆时，APP配置二维码扫描无法连接，但是用钉钉在局域网可以登陆，是哪里出了问题，还是这个是正常的？
****************************************
* application server start completed.
* port: 20030.
****************************************
****************************************
* web server start completed.
* port: 80.
****************************************
2023-06-28 17:21:07.128 [ContextQuartzScheduler-x_query_service_processing_Worker-2] INFO com.x.query.service.processing.schedule.HighFreqDocument - high freq index document start at:2023-06-28 17:21:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2023-06-28 17:21:07.128 [ContextQuartzScheduler-x_query_service_processing_Worker-1] INFO com.x.query.service.processing.schedule.HighFreqWorkCompleted - high freq index workCompleted start at:2023-06-28 17:21:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2023-06-28 17:21:56.040 [ContextQuartzScheduler-x_program_center_Worker-1] INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.calendar.assemble.control.schedule.AlarmTrigger, cron: 0/30 * * * * ?, node: oa.cqsdgi.com, application: com.x.base.core.project.x_calendar_assemble_control.
2023-06-28 17:22:00.615 [ContextQuartzScheduler-x_calendar_assemble_control_Worker-1] INFO com.x.calendar.assemble.control.schedule.AlarmTrigger - The trigger for calendar alarm execute completed.Wed Jun 28 17:22:00 GMT+08:00 2023
2023-06-28 17:22:03.423 [ContextQuartzScheduler-x_query_service_processing_Worker-2] INFO com.x.query.service.processing.schedule.HighFreqWork - high freq index work start at:2023-06-28 17:22:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2023-06-28 17:22:10.951 [ContextQuartzScheduler-x_program_center_Worker-1] INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.processplatform.assemble.surface.schedule.CleanKeyLock, cron: 2 0/2 * * * ?, node: oa.cqsdgi.com, application: com.x.base.core.project.x_processplatform_assemble_surface.
2023-06-28 17:22:21.070 [ContextQuartzScheduler-x_program_center_Worker-1] ERROR com.alibaba.druid.pool.DruidDataSource - recyle error
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:3099) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:699) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:964) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:694) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:414) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:311) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1941) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:336) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5047) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_releaseConnection(StatFilter.java:689) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5043) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:271) ~[druid-1.2.14.jar:?]
        at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.close(LoggingConnectionDecorator.java:378) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.free(JDBCStoreManager.java:1675) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.close(JDBCStoreManager.java:1657) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:461) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~[classes/:?]
        at java.util.concurrent.ConcurrentHashMap$EntrySpliterator.forEachRemaining(ConcurrentHashMap.java:3645) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.program.center.schedule.FireSchedule.fire(FireSchedule.java:49) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~[classes/:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.1.jar:?]
2023-06-28 17:22:21.070 [ContextQuartzScheduler-x_program_center_Worker-1] ERROR com.x.program.center.schedule.FireSchedule - id:dca3d146-1558-4082-9fee-0a94a79accb8, name:com.x.program.center.schedule.FireSchedule, message:Read timed out {prepstmnt 1113237302 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01], exceptionrg.apache.openjpa.persistence.PersistenceException.
org.apache.openjpa.persistence.PersistenceException: Read timed out {prepstmnt 1113237302 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~[classes/:?]
        at java.util.concurrent.ConcurrentHashMap$EntrySpliterator.forEachRemaining(ConcurrentHashMap.java:3645) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.program.center.schedule.FireSchedule.fire(FireSchedule.java:49) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~[classes/:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Read timed out {prepstmnt 1113237302 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
        ... 15 more
2023-06-28 17:22:31.103 [ContextQuartzScheduler-x_program_center_Worker-1] ERROR com.alibaba.druid.pool.DruidDataSource - recyle error
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:3099) ~[mssql-jdbc-7.2.2.jre8.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:699) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:964) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:694) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:414) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:311) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1941) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:336) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5047) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_releaseConnection(StatFilter.java:689) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5043) ~[druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:271) ~[druid-1.2.14.jar:?]
        at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.close(LoggingConnectionDecorator.java:378) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.free(JDBCStoreManager.java:1675) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.close(JDBCStoreManager.java:1657) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:461) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~[classes/:?]
        at java.util.concurrent.ConcurrentHashMap$EntrySpliterator.forEachRemaining(ConcurrentHashMap.java:3645) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.program.center.schedule.FireSchedule.fire(FireSchedule.java:49) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~[classes/:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.1.jar:?]
2023-06-28 17:23:02.429 [ContextQuartzScheduler-x_query_service_processing_Worker-2] INFO com.x.query.service.processing.schedule.HighFreqWorkCompleted - high freq index workCompleted start at:2023-06-28 17:23:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2023-06-28 17:23:02.335 [ContextQuartzScheduler-x_query_service_processing_Worker-1] INFO com.x.query.service.processing.schedule.HighFreqDocument - high freq index document start at:2023-06-28 17:23:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2023-06-28 17:23:24.742 [ContextQuartzScheduler-x_program_center_Worker-1] ERROR com.x.program.center.schedule.FireSchedule - id:ed5e2244-0112-413e-be68-2c47cbddc11c, name:com.x.program.center.schedule.FireSchedule, message:Read timed out {prepstmnt 592443473 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01], exceptionrg.apache.openjpa.persistence.PersistenceException.
org.apache.openjpa.persistence.PersistenceException: Read timed out {prepstmnt 592443473 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~[classes/:?]
        at java.util.concurrent.ConcurrentHashMap$EntrySpliterator.forEachRemaining(ConcurrentHashMap.java:3645) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.program.center.schedule.FireSchedule.fire(FireSchedule.java:49) ~[classes/:?]
        at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~[classes/:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Read timed out {prepstmnt 592443473 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xstackTrace, t0.xsuccess, t0.xtype FROM CTE_SCHEDULELOG t0 WHERE (t0.xclassName = ?) ORDER BY t0.xfireTime DESC OFFSET 0 ROWS  FETCH NEXT 1 ROWS ONLY } [code=0, state=08S01]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
        ... 15 more

启蒙星

我看你日志有很多数据库连接的报错，单端口不报错？连接的是同个数据库吗？

danielhuang

启蒙星 发表于 2023-6-29 17:21
我看你日志有很多数据库连接的报错，单端口不报错？连接的是同个数据库吗？ ...

是同一个MSSQL SERVER ，端口只设置的同一个，如果我分开设置，就登录不了系统，我换成mysql也是这样，而且感觉，MSSMQL比MYSQL访问的速度要快些！