服务器配置---分开设置三个服务器端口后无法登陆
本帖最后由 danielhuang 于 2023-6-28 17:32 编辑管理员好！
1、 我如果将三个服务器设置相同的端口，可以登陆系统，分开设置，就无法登陆系统，登陆界面一直转圈。是怎么回事呢？日志如下
2、正常登陆时，APP配置二维码扫描无法连接，但是用钉钉在局域网可以登陆，是哪里出了问题，还是这个是正常的？
****************************************
* application server start completed.
* port: 20030.
****************************************
****************************************
* web server start completed.
* port: 80.
****************************************
2023-06-28 17:21:07.128 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 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 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 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 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 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 ERROR com.alibaba.druid.pool.DruidDataSource - recyle error
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) ~
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) ~
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:3099) ~
at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:699) ~
at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:964) ~
at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:694) ~
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:414) ~
at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:311) ~
at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1941) ~
at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:336) ~
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5047) ~
at com.alibaba.druid.filter.stat.StatFilter.dataSource_releaseConnection(StatFilter.java:689) ~
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5043) ~
at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:271) ~
at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.close(LoggingConnectionDecorator.java:378) ~
at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.free(JDBCStoreManager.java:1675) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.close(JDBCStoreManager.java:1657) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:461) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~
at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~
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) ~
at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~
2023-06-28 17:22:21.070 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 ROWSFETCH NEXT 1 ROWS ONLY } , exception:org.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 ROWSFETCH NEXT 1 ROWS ONLY }
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~
at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~
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) ~
at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~
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 ROWSFETCH NEXT 1 ROWS ONLY }
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~
... 15 more
2023-06-28 17:22:31.103 ERROR com.alibaba.druid.pool.DruidDataSource - recyle error
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) ~
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) ~
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:3099) ~
at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:699) ~
at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:964) ~
at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:694) ~
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:414) ~
at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:311) ~
at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1941) ~
at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:336) ~
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5047) ~
at com.alibaba.druid.filter.stat.StatFilter.dataSource_releaseConnection(StatFilter.java:689) ~
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5043) ~
at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:271) ~
at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.close(LoggingConnectionDecorator.java:378) ~
at org.apache.openjpa.lib.jdbc.DelegatingConnection.close(DelegatingConnection.java:195) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.free(JDBCStoreManager.java:1675) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.close(JDBCStoreManager.java:1657) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:461) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~
at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~
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) ~
at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~
2023-06-28 17:23:02.429 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 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 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 ROWSFETCH NEXT 1 ROWS ONLY } , exception:org.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 ROWSFETCH NEXT 1 ROWS ONLY }
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.program.center.schedule.FireSchedule.getLastStartTime(FireSchedule.java:90) ~
at com.x.program.center.schedule.FireSchedule.lambda$fire$0(FireSchedule.java:57) ~
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) ~
at com.x.program.center.schedule.FireSchedule.execute(FireSchedule.java:39) ~
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~
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 ROWSFETCH NEXT 1 ROWS ONLY }
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~
... 15 more
我看你日志有很多数据库连接的报错，单端口不报错？连接的是同个数据库吗？ 本帖最后由 danielhuang 于 2023-6-30 10:21 编辑
启蒙星 发表于 2023-6-29 17:21
我看你日志有很多数据库连接的报错，单端口不报错？连接的是同个数据库吗？ ...
是同一个MSSQL SERVER ，端口只设置的同一个，如果我分开设置，就登录不了系统，我换成mysql也是这样，而且感觉，MSSMQL比MYSQL访问的速度要快些！
页:
[1]