本帖最后由 少辉 于 2025-6-6 11:42 编辑 以下是我的greatsql数据库群集的错误日志输出的信息: 2025-06-06T01:04:13.570576+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 881; events assigned = 670721; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T01:33:31.232100+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1758; events assigned = 672769; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T01:48:12.079326+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 881; events assigned = 673793; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T02:17:27.823950+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1755; events assigned = 675841; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T02:32:08.956207+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 881; events assigned = 676865; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T03:01:27.379957+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1759; events assigned = 678913; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T03:16:09.061864+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 679937; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T03:45:25.763894+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1756; events assigned = 681985; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T04:00:06.522172+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 881; events assigned = 683009; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T04:29:24.372946+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1758; events assigned = 685057; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T04:44:06.249063+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 686081; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T05:13:23.204906+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1757; events assigned = 688129; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T05:28:02.800951+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 879; events assigned = 689153; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T05:57:20.683292+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1758; events assigned = 691201; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T06:12:02.378264+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 692225; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T06:41:18.988682+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1756; events assigned = 694273; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T06:56:00.255095+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 695297; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T07:25:16.613018+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1756; events assigned = 697345; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T07:39:58.435201+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 698369; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T08:09:17.681346+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1759; events assigned = 700417; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T08:23:58.314361+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 881; events assigned = 701441; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T08:53:10.733754+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1752; events assigned = 703489; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T09:07:52.674352+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 882; events assigned = 704513; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T09:37:12.875556+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1760; events assigned = 706561; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T09:51:55.075934+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 883; events assigned = 707585; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T10:21:01.580843+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1746; events assigned = 709633; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 2025-06-06T10:35:33.544070+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 872; events assigned = 710657; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 以上信息是在从库上找到的,基本上每10多分钟到30分钟左右就会输出一条类似这样的信息:2025-06-06T10:35:33.544070+08:00 3978 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 872; events assigned = 710657; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 86956100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0 我检查了群集状态,状态显示正常,测试插入几条数据到主库后,从库也能正常同步,就是一直出这个错误信息,我还检查了一下各台数据库服务器的上时间,时间上显示都是一样的,没有差异,我不知道为什么会出现这些信息到错误日志上,现在不知道从哪下手去解决这个问题。我查询到MySQL 8.0.32 ~ 8.0.33会大量产生 waited at clock conflicts错误日志的bug,直到MySQL 8.0.34-36后才修复。现在我使用的greatsql的版本是GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64.tar.xz。这个版本是不是也有这个bug。 |
少辉
7 天前
| ||
yejr
7 天前
| ||
reddey
7 天前
| ||
yejr
7 天前
| ||
合作电话:010-64087828
社区邮箱:greatsql@greatdb.com