- 论坛徽章:
- 0
|
刚迁移过来的数据库起来后报了一堆错误:
2010-12-21 00:53:07.871 CST,,,30873,,4d0f88d1.7899,4919,,2010-12-21 00:48:17 CST,,0,LOG,00000,"last_statrequest 2010-12-21 00:53:21.972521+08 is later than collector's time 2010-12-21 00:53:07.870957+08",,,,,,,,,""
2010-12-21 00:53:27.263 CST,,,31193,,4d0f89ee.79d9,1,,2010-12-21 00:53:02 CST,2/0,0,WARNING,01000,"pgstat wait timeout",,,,,,,,,""
系统DATE输出发现时钟频率严重不对:
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:19 CST 2010
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:20 CST 2010
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:40 CST 2010
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:41 CST 2010
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:23 CST 2010
postgres@db-192-168-173-64-sns-space-> date
Tue Dec 21 00:52:24 CST 2010
看起来像是有两个硬件时钟在跑。
因此导致PostgreSQL认为时间错乱,抛出以上日志。
目前怀疑是IBM X3950服务器两台做堆叠后需操作系统兼容性不佳造成的,重启系统后恢复正常。 |
|