PSQL TimescaleDB，错误:数据库系统处于恢复模式

Question

我们在一台单独的服务器(带有Ubuntu18.04LTS的VM)上有一个应用程序管道和Postgres-12(TimescaleDB，通过Patroni管理)。

我们正面临着一个数据库的问题，它突然停留在恢复模式，而且我们无法从psql客户端访问它，select查询也挂起了。

一个小时后或延迟一小时后，一切都恢复正常(因为我当前的管道终止了)，并且能够对DB服务器运行查询。

主数据库错误详细信息：

2020-11-03 18:35:08.612 IST [9773] [unknown]@[unknown] LOG:  connection received: host=x.x.x.x port=58780
2020-11-03 18:35:08.612 IST [9773]  FATAL:  the database system is in recovery mode
2020-11-03 18:35:08.596 IST [18276]  LOG:  could not send data to client: Broken pipe

副本服务器错误详细信息：

2020-11-03 18:34:55 IST [18316]: [85649-1] user=postgres,db=postgres,app=[unknown],client=x.x.x.x LOG:  duration: 10.228 ms  statement: SELECT * FROM pg_stat_bgwriter;
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-11-03 18:35:08 IST [18322]: [2-1] user=,db=,app=,client= FATAL:  could not receive data from WAL stream: SSL SYSCALL error: EOF detected
2020-11-03 18:35:08 IST [20500]: [1-1] user=,db=,app=,client= FATAL:  could not connect to the primary server: FATAL:  the database system is in recovery mode
        FATAL:  the database system is in recovery mode

管道错误详细信息：

Job aborted due to stage failure: Task 4 in stage 0.0 failed 3 times, most recent failure: Lost task 4.2 in stage 0.0 (TID 29, ip-x-x-x-x.ap-southeast-1.compute.internal, executor 19): org.postgresql.util.PSQLException: FATAL: the database system is in recovery mode at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:454) at org.postgresql.Driver.connect(Driver.java:256) at org.apache.spark.sql.execution.datasources.jdbc.DriverWrapper.connect(DriverWrapper.scala:45)

请对这个问题有什么建议？

Answer 1

您运行的是什么版本的TimescaleDB？特别是，如果您尝试查询已读副本，则1.7.x会出现一些问题；我们建议升级到1.7.4。

(否则，没有太多关于可能发生的事情的信息。)

https://github.com/timescale/timescaledb/releases/tag/1.7.4