禅道出现无法访问情况
回贴
回帖数
1
阅读数
1424
发表时间
2022-12-30 16:12:31
1、禅道版本禅道18.0.beta2
2、部署环境： CentOS 7.6
3、部署平台：阿里云轻量服务器
4、部署方式：zbox一键部署
5、问题描述：禅道经常出现无法访问情况，服务器端口已经在防火墙上开放。
6、mysql日志：
2022-12-29 16:19:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-12-29 16:19:09 0 [Note] InnoDB: Number of transaction pools: 1
2022-12-29 16:19:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-12-29 16:19:09 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-12-29 16:19:09 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-29 16:19:09 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-29 16:19:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-29 16:19:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-29 16:19:09 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-29 16:19:09 0 [Note] InnoDB: 10.7.6 started; log sequence number 7043324; transaction id 11849
2022-12-29 16:19:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-29 16:19:09 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2022-12-29 16:19:09 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-12-29 16:19:09 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-12-29 16:19:09 0 [Note] /opt/zbox/run/mysql/mariadbd: ready for connections.
Version: '10.7.6-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3307 Source distribution
2022-12-29 16:19:09 0 [Note] InnoDB: Buffer pool(s) load completed at 221229 16:19:09
2022-12-29 16:35:51 6 [Warning] Aborted connection 6 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 16:54:10 230 [Warning] Aborted connection 230 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 16:54:10 115 [Warning] Aborted connection 115 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:04:01 277 [Warning] Aborted connection 277 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:06:40 366 [Warning] Aborted connection 366 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:07:19 439 [Warning] Aborted connection 439 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:12:03 495 [Warning] Aborted connection 495 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:12:03 572 [Warning] Aborted connection 572 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:12:03 571 [Warning] Aborted connection 571 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:14:36 580 [Warning] Aborted connection 580 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:15:35 627 [Warning] Aborted connection 627 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:19:09 710 [Warning] Aborted connection 710 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:42:36 682 [Warning] Aborted connection 682 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:49:39 970 [Warning] Aborted connection 970 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 17:49:40 929 [Warning] Aborted connection 929 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:00:02 987 [Warning] Aborted connection 987 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:00:02 1035 [Warning] Aborted connection 1035 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:06:54 1039 [Warning] Aborted connection 1039 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:08:17 1085 [Warning] Aborted connection 1085 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:08:17 1132 [Warning] Aborted connection 1132 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-29 18:08:18 1134 [Warning] Aborted connection 1134 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:08:24 1172 [Warning] Aborted connection 1172 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:08:24 1271 [Warning] Aborted connection 1271 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:28:20 1387 [Warning] Aborted connection 1387 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:28:20 1282 [Warning] Aborted connection 1282 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:32:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-12-30 15:32:26 0 [Note] InnoDB: Number of transaction pools: 1
2022-12-30 15:32:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-12-30 15:32:26 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-12-30 15:32:26 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-30 15:32:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7043324,7043324
2022-12-30 15:32:26 0 [Note] InnoDB: Starting final batch to recover 209 pages from redo log.
2022-12-30 15:32:26 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 15:32:26 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-12-30 15:32:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-30 15:32:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-30 15:32:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 15:32:26 0 [Note] InnoDB: 10.7.6 started; log sequence number 11367737; transaction id 30124
2022-12-30 15:32:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 15:32:26 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2022-12-30 15:32:26 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-12-30 15:32:26 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-12-30 15:32:26 0 [Note] /opt/zbox/run/mysql/mariadbd: ready for connections.
Version: '10.7.6-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3307 Source distribution
2022-12-30 15:32:26 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 15:32:26
2022-12-30 15:36:44 152 [Warning] Aborted connection 152 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:36:45 154 [Warning] Aborted connection 154 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:47:35 4 [Warning] Aborted connection 4 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:52:18 248 [Warning] Aborted connection 248 to db: 'zentao' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-12-30 15:54:51 0 [Note] /opt/zbox/run/mysql/mariadbd (initiated by: unknown): Normal shutdown
2022-12-30 15:54:51 0 [Note] InnoDB: FTS optimize thread exiting.
2022-12-30 15:54:51 0 [Note] InnoDB: Starting shutdown...
2022-12-30 15:54:51 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/zbox/data/mysql/ib_buffer_pool
2022-12-30 15:54:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 221230 15:54:51
2022-12-30 15:54:51 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-12-30 15:54:51 0 [Note] InnoDB: Shutdown completed; log sequence number 11459792; transaction id 30509
2022-12-30 15:54:51 0 [Note] /opt/zbox/run/mysql/mariadbd: Shutdown complete
2022-12-30 15:55:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-12-30 15:55:46 0 [Note] InnoDB: Number of transaction pools: 1
2022-12-30 15:55:46 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-12-30 15:55:46 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-12-30 15:55:46 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-30 15:55:46 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 15:55:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-30 15:55:46 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-30 15:55:46 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 15:55:46 0 [Note] InnoDB: 10.7.6 started; log sequence number 11459792; transaction id 30510
2022-12-30 15:55:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 15:55:46 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2022-12-30 15:55:46 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-12-30 15:55:46 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-12-30 15:55:46 0 [Note] /opt/zbox/run/mysql/mariadbd: ready for connections.
Version: '10.7.6-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3307 Source distribution
2022-12-30 15:55:46 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 15:55:46
[Sat Dec 24 23:04:01.838625 2022] [mpm_event:notice] [pid 1500:tid 140594265950016] AH00489: Apache/2.4.52 (Unix) OpenSSL/1.0.2k-fips configured -- resuming normal operations
[Sat Dec 24 23:04:01.838720 2022] [core:notice] [pid 1500:tid 140594265950016] AH00094: Command line: '/opt/zbox/run/apache/httpd'
[Sat Dec 24 23:25:13.683776 2022] [mpm_event:notice] [pid 1500:tid 140594265950016] AH00491: caught SIGTERM, shutting down
[Sat Dec 24 23:25:21.431062 2022] [mpm_event:notice] [pid 2264:tid 140360485656384] AH00489: Apache/2.4.52 (Unix) OpenSSL/1.0.2k-fips configured -- resuming normal operations
[Sat Dec 24 23:25:21.431132 2022] [core:notice] [pid 2264:tid 140360485656384] AH00094: Command line: '/opt/zbox/run/apache/httpd'
[Tue Dec 27 17:48:17.418523 2022] [core:warn] [pid 1471:tid 140509132715840] AH00098: pid file /opt/zbox/tmp/apache/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Tue Dec 27 17:48:17.421047 2022] [mpm_event:notice] [pid 1471:tid 140509132715840] AH00489: Apache/2.4.52 (Unix) OpenSSL/1.0.2k-fips configured -- resuming normal operations
[Tue Dec 27 17:48:17.421089 2022] [core:notice] [pid 1471:tid 140509132715840] AH00094: Command line: '/opt/zbox/run/apache/httpd'
[Tue Dec 27 17:50:01.519651 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1472 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:01.519718 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1473 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:02.520906 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1480 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:03.522617 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1799 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:03.522669 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1856 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:04.526196 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1885 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:10.531236 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1948 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:10.531275 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1965 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:11.532374 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1941 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:19.538201 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2149 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:20.539330 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1940 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:20.539379 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2148 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:44.561624 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2241 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:45.562732 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2213 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:45.562787 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2242 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:56.579298 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 1884 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:56.579342 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2364 exit signal Segmentation fault (11)
[Tue Dec 27 17:50:57.580866 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2120 exit signal Segmentation fault (11)
[Tue Dec 27 17:56:08.332084 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2392 exit signal Segmentation fault (11)
[Tue Dec 27 17:56:08.354127 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2448 exit signal Segmentation fault (11)
[Tue Dec 27 17:56:09.355707 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2420 exit signal Segmentation fault (11)
[Tue Dec 27 17:56:09.355760 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2656 exit signal Segmentation fault (11)
[Tue Dec 27 17:56:10.357955 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2685 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:15.111702 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2772 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:17.131436 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2769 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:17.131559 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2770 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:23.138539 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2713 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:24.140428 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2919 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:26.141551 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2714 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:26.141588 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2976 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:27.142816 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2975 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:28.144584 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 2947 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:28.144628 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3031 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:29.148067 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3060 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:32.150181 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3116 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:32.150225 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3121 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:40.156946 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3124 exit signal Segmentation fault (11)
[Tue Dec 27 18:03:41.158902 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3115 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:16.760459 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3339 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:17.762356 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3227 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:18.765141 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3059 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:19.766118 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3379 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:20.767889 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3416 exit signal Segmentation fault (11)
[Tue Dec 27 18:36:21.769436 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3444 exit signal Segmentation fault (11)
[Tue Dec 27 22:11:10.339891 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3905 exit signal Segmentation fault (11)
[Tue Dec 27 22:11:10.340938 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 3943 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:42.594170 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4074 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:42.594327 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4115 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:47.601107 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4044 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:47.601216 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4180 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:51.605852 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4236 exit signal Segmentation fault (11)
[Tue Dec 27 23:00:52.608259 2022] [core:notice] [pid 1471:tid 140509132715840] AH00052: child pid 4208 exit signal Segmentation fault (11)
[Thu Dec 29 16:18:58.001138 2022] [mpm_event:notice] [pid 1471:tid 140509132715840] AH00491: caught SIGTERM, shut
于涛
您好，根据日志分析来看的话，没有明显的error信息，其中数据库有个Warning，这个可能和数据库以及服务器配置有关，可以尝试
- 检查是否启用了skip-name-resolve，检查主机根据其ip地址而不是其主机名进行身份验证。
- 尝试增加mysql的net_read_timeout和net_write_timeout值，看看是否减少了错误的数量。
2022-12-30 16:16:17 于涛 回帖
联系人
刘斌/高级客户经理
电话(微信)
17685869372
QQ号码
526288068
联系邮箱
liubin@chandao.com
联系我们
刘斌
高级客户经理
电话(微信)
17685869372
QQ号码
526288068
联系邮箱
liubin@chandao.com
名额有限
完善信息领取项目管理礼包
270+项目管理实践
100+项目管理视频
50+项目管理知识模版
去完善
刘斌/高级客户经理
联系客服领取礼包
