I encountered a strange problem while using timescaledb (version 2.11.1) and postgreSQL(version 15.2)：the following error messages are often printed in the logs, about once a day。
2023-09-27 09:55:19.105 HKT [10344] INFO: 00000: timescaledb loaded
2023-09-27 09:55:19.105 HKT [10344] LOCATION: _PG_init, loader.c:712
2023-09-27 09:55:19.106 HKT [10344] LOG: 00000: database system was interrupted; last known up at 2023-09-27 09:31:45 HKT
2023-09-27 09:55:19.106 HKT [10344] LOCATION: StartupXLOG, xlog.c:4964
2023-09-27 09:55:19.112 HKT [18252] INFO: 00000: timescaledb loaded
2023-09-27 09:55:19.112 HKT [18252] LOCATION: _PG_init, loader.c:712
2023-09-27 09:55:19.122 HKT [15628] INFO: 00000: timescaledb loaded
2023-09-27 09:55:19.122 HKT [15628] LOCATION: _PG_init, loader.c:712
2023-09-27 09:55:20.434 HKT [10344] LOG: 00000: database system was not properly shut down; automatic recovery in progress
2023-09-27 09:55:20.434 HKT [10344] LOCATION: InitWalRecovery, xlogrecovery.c:879
2023-09-27 09:55:20.445 HKT [10344] LOG: 00000: redo starts at 0/290A5320
2023-09-27 09:55:20.445 HKT [10344] LOCATION: PerformWalRecovery, xlogrecovery.c:1642
2023-09-27 09:55:20.447 HKT [10344] LOG: 00000: invalid record length at 0/290AEA20: wanted 24, got 0
2023-09-27 09:55:20.447 HKT [10344] LOCATION: ReadRecord, xlogrecovery.c:3064
2023-09-27 09:55:20.447 HKT [10344] LOG: 00000: redo done at 0/290AE9E8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2023-09-27 09:55:20.447 HKT [10344] LOCATION: PerformWalRecovery, xlogrecovery.c:1780
2023-09-27 09:55:20.458 HKT [18252] LOG: 00000: checkpoint starting: end-of-recovery immediate wait
2023-09-27 09:55:20.458 HKT [18252] LOCATION: LogCheckpointStart, xlog.c:6099
2023-09-27 09:55:20.505 HKT [18252] LOG: 00000: checkpoint complete: wrote 9 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.026 s, sync=0.014 s, total=0.049 s; sync files=9, longest=0.005 s, average=0.002 s; distance=37 kB, estimate=37 kB
2023-09-27 09:55:20.505 HKT [18252] LOCATION: LogCheckpointEnd, xlog.c:6188
“timescaledb loaded” printed in log several times per minute.
I use timescaledb for compression (schedule interval 2hours) and continuous aggregation (schedule interval 15min)。The log level is LOG, it shoud not affect the operation of postgresql? but sometims there are logs: “FATAL: the database system is in recovery mode” “FATAL: the database system is not yet accepting connections”。
There is another FATAL error， Why does PostgreSQL not print detailed error messages， like exception stack of java program。
2023-09-28 06:38:25.249 HKT [30568] [] [00000] []INFO: 00000: timescaledb loaded
2023-09-28 06:38:25.249 HKT [30568] [] [00000] []LOCATION: _PG_init, loader.c:712
2023-09-28 06:38:25.250 HKT [30568] [] [00000] []DEBUG: 00000: loaded library "timescaledb"
2023-09-28 06:38:25.250 HKT [30568] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.251 HKT [30568] [] [00000] []DEBUG: 00000: loaded library "pg_stat_statements"
2023-09-28 06:38:25.251 HKT [30568] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.252 HKT [30568] [] [00000] []LOG: 00000: database system was interrupted; last known up at 2023-09-28 05:58:01 HKT
2023-09-28 06:38:25.252 HKT [30568] [] [00000] []LOCATION: StartupXLOG, xlog.c:4964
2023-09-28 06:38:25.252 HKT [30568] [] [00000] []DEBUG: 00000: removing all temporary WAL segments
2023-09-28 06:38:25.252 HKT [30568] [] [00000] []LOCATION: RemoveTempXlogFiles, xlog.c:3527
2023-09-28 06:38:25.269 HKT [7240] [] [00000] []INFO: 00000: timescaledb loaded
2023-09-28 06:38:25.269 HKT [7240] [] [00000] []LOCATION: _PG_init, loader.c:712
2023-09-28 06:38:25.270 HKT [7240] [] [00000] []DEBUG: 00000: loaded library "timescaledb"
2023-09-28 06:38:25.270 HKT [7240] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.271 HKT [7240] [] [00000] []DEBUG: 00000: loaded library "pg_stat_statements"
2023-09-28 06:38:25.271 HKT [7240] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.272 HKT [7240] [] [00000] []DEBUG: 00000: checkpointer updated shared memory configuration values
2023-09-28 06:38:25.272 HKT [7240] [] [00000] []LOCATION: UpdateSharedMemoryConfig, checkpointer.c:1330
2023-09-28 06:38:25.295 HKT [23132] [] [00000] []INFO: 00000: timescaledb loaded
2023-09-28 06:38:25.295 HKT [23132] [] [00000] []LOCATION: _PG_init, loader.c:712
2023-09-28 06:38:25.296 HKT [23132] [] [00000] []DEBUG: 00000: loaded library "timescaledb"
2023-09-28 06:38:25.296 HKT [23132] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.298 HKT [23132] [] [00000] []DEBUG: 00000: loaded library "pg_stat_statements"
2023-09-28 06:38:25.298 HKT [23132] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.303 HKT [35472] [] [00000] []INFO: 00000: timescaledb loaded
2023-09-28 06:38:25.303 HKT [35472] [] [00000] []LOCATION: _PG_init, loader.c:712
2023-09-28 06:38:25.304 HKT [35472] [] [00000] []DEBUG: 00000: loaded library "timescaledb"
2023-09-28 06:38:25.304 HKT [35472] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.305 HKT [35472] [] [00000] []DEBUG: 00000: loaded library "pg_stat_statements"
2023-09-28 06:38:25.305 HKT [35472] [] [00000] []LOCATION: load_libraries, miscinit.c:1670
2023-09-28 06:38:25.305 HKT [35472] [[unknown]] [00000] [127.0.0.1(49216)]LOG: 00000: connection received: host=127.0.0.1 port=49216
2023-09-28 06:38:25.305 HKT [35472] [[unknown]] [00000] [127.0.0.1(49216)]LOCATION: BackendInitialize, postmaster.c:4403
2023-09-28 06:38:25.306 HKT [35472] [xxx] [57P03] [127.0.0.1(49216)]FATAL: 57P03: the database system is in recovery mode
2023-09-28 06:38:25.306 HKT [35472] [xxx] [57P03] [127.0.0.1(49216)]LOCATION: ProcessStartupPacket, postmaster.c:2412