错误:
2019-06-17T05:00:11 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 58P01 NativeError: 1 Message: ERROR: could not access file "pglogical": No such file or directory;, Error while executing the query [1022502] (ar_odbc_stmt.c:2546)
2019-06-17T05:00:11 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 42P01 NativeError: 1 Message: ERROR: relation "pglogical.replication_set" does not exist;, No query has been executed with that handle [1022502] (ar_odbc_stmt.c:3722)
我们大约每隔3个月就会遇到这个错误。重新启动任务可以解决问题,但是恢复操作无法正常工作。
复制槽存在,但似乎处于不活跃状态:
postgres=> select * from pg_replication_slots ;
slot_name | plugin | slot_type | datoid | database | active | active_pid | xmin | catalog_xmin | restart_lsn
----------------------------------------------------------------+---------------+-----------+--------+---------------+--------+------------+------+--------------+--------------
juvmrynv47ajpwrc_00016389_f28d6802_db75_43d6_8058_315783e9b1b2 | test_decoding | logical | 16389 | postgres | f | | | 148271120 | 8DF/B292FB48
(1 row)
RetCode: SQL_ERROR SqlState: XX000 NativeError: 1 Message: ERROR: pglogical不在shared_preload_libraries中;执行查询时出错 [1022502] (ar_odbc_stmt.c:2581)
RetCode: SQL_ERROR SqlState: 42P01 NativeError: 1 Message: ERROR: 关系“pglogical.replication_set”不存在;没有使用该句柄执行任何查询 [1022502] (ar_odbc_stmt.c:3752)
- prakharjainCREATE EXTENSION pglogical;
命令。您应该会注意到 pglogical 模式。有关详细信息请参见相关文章。 - bvj