故障诊断

    1、clock synchronization error: this node is more than 500ms away from at least half of the known nodes (0 of 1 are within the offset)

    2、ERROR:bini server exited with error:failed to create engines:could not open rocksdb instance:Invalid argument :bini_comparator:does not match existing comparator drdb_comparator

    在集群升级或集群中加入新节点时,需要保证启动命令中指定的存储路径是空,如果使用原有存储路径,会导致版本不一致的错误。

    3、WARNING 084/172733(9466):Server psql/DRDB-node1 is DOWN,reason: Layer4 connection problem, info:“Connection refused”,check duration:0ms

    4、pg:rejected:DELETE without WHERE clause(sql_safe_updates = true)

    这个错误是数据库的保护机制,如果在执行delete或update操作时,没有指定where语句,会提示此信息。可以加 where 1=1 绕过此报错。

    5、pq: cannot write to : error response from server:

    Method Not Allowed

    使用dump命令导出数据时,如果出现以上错误,需要开启httpd的put操作。