search

hasadna / open-bus

:bus: Analysing Israel's public transport data
93 stars 27 forks source link

check repeated stride DB errors #371

Closed OriHoch closed 2 years ago

OriHoch commented 2 years ago

latest logs:

2022-01-25 22:31:24.265 UTC [26] LOG:  checkpoints are occurring too frequently (8 seconds apart)
2022-01-25 22:31:24.265 UTC [26] HINT:  Consider increasing the configuration parameter "max_wal_size".
2022-01-25 22:31:33.584 UTC [26] LOG:  checkpoints are occurring too frequently (9 seconds apart)
2022-01-25 22:31:33.584 UTC [26] HINT:  Consider increasing the configuration parameter "max_wal_size".
2022-01-26 00:28:39.052 UTC [525] LOG:  unexpected EOF on client connection with an open transaction
2022-01-26 00:29:11.830 UTC [43] LOG:  unexpected EOF on client connection with an open transaction
2022-01-26 06:54:22.284 UTC [26] LOG:  checkpoints are occurring too frequently (23 seconds apart)
2022-01-26 06:54:22.284 UTC [26] HINT:  Consider increasing the configuration parameter "max_wal_size".
2022-01-26 06:54:46.206 UTC [26] LOG:  checkpoints are occurring too frequently (24 seconds apart)
2022-01-26 06:54:46.206 UTC [26] HINT:  Consider increasing the configuration parameter "max_wal_size".
2022-01-26 07:00:08.712 UTC [640] LOG:  unexpected EOF on client connection with an open transaction
OriHoch commented 2 years ago

increased wal_size: https://github.com/hasadna/hasadna-k8s/commit/35c17f584771dc525581903182064ebaee77117e