GreatSQL社区

搜索

[讨论中] 错误日志输出waited at clock conflicts 错误信息

129 5 7 天前
本帖最后由 少辉 于 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。
全部回复(5)
yejr 7 天前
出现这种日志通常是因为MGR各节点间的系统时钟不同步导致事务冲突,这种情况会影响集群稳定性,需要及时处理,就是在各节点上都配置正确的时间同步服务
少辉 7 天前
yejr 发表于 2025-6-6 12:58
出现这种日志通常是因为MGR各节点间的系统时钟不同步导致事务冲突,这种情况会影响集群稳定性,需要及时处 ...

我的3台服务器的时间都是这样的,ubuntu@nfcgw02:~$ timedatectl status
               Local time: Fri 2025-06-06 15:36:58 CST
           Universal time: Fri 2025-06-06 07:36:58 UTC
                 RTC time: Fri 2025-06-06 07:36:58
                Time zone: Asia/Shanghai (CST, +0800)
System clock synchronized: yes
              NTP service: active
          RTC in local TZ: no
,应该不是时间问题
yejr 7 天前
少辉 发表于 2025-6-6 15:39
我的3台服务器的时间都是这样的,ubuntu@nfcgw02:~$ timedatectl status
               Local time: Fri ...

这只是个note级别的【提示】信息,不是【报错】

可以先参考这篇文章:https://mp.weixin.qq.com/s/XrqLZHm9Bbje9eS45T2VIw
reddey 7 天前
yejr 发表于 2025-6-6 16:55
这只是个note级别的【提示】信息,不是【报错】

可以先参考这篇文章:https://mp.weixin.qq.com/s/XrqLZ ...

这个是NOTE级别的,也就是可以忽略不管是吧。
yejr 7 天前
reddey 发表于 2025-6-6 17:20
这个是NOTE级别的,也就是可以忽略不管是吧。

是的,note只是提示,通常都可以不用处理,仅关注即可
少辉

3

主题

0

博客

18

贡献

新手上路

Rank: 1

积分
27

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2025-6-13 18:39 , Processed in 0.020960 second(s), 14 queries , Redis On.
快速回复 返回顶部 返回列表