You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Aug 29, 2024. It is now read-only.
Angelika Ehlers edited this page Dec 12, 2017
·
11 revisions
Issue:
When loading data into postgres db (seeding of db or reload from backup for example) the following error shows
psql: ERROR: unexpected data beyond EOF in block 1314 of relation base/17835/122175
HINT: This has been seen to occur with buggy kernels; consider updating your system.
Once this error occurs postgresql does not start up.
Troubleshooting Steps:
Connect to postgresql pod.
In the /var/lib/pgsql/data/userdata_broken/pg_log/postgresql*.log the lines similar to the ones below are recorded:
WARNING: corrupted statistics file "pg_stat_tmp/global.stat"
LOG: incomplete startup packet
ERROR: unexpected data beyond EOF in block 321 of relation base/68243/373021
HINT: This has been seen to occur with buggy kernels; consider updating your system.
STATEMENT: ...
FATAL: the database system is starting up
Solution:
Increase the max_wal_size postgresql setting (max_wal_size = 2GB)