However, I would still like to learn if it is possible to recover the database in situations like this, instead of rebuilding it from the scratch or restoring from a backup. There is nothing important in the database. This is likely data corruption due to unclean Docker shutdown. $PWD/data/postgresql:/var/lib/postgresql/dataĪfter unclean shutdown the instance no longer starts with FATAL: xlog flush request 0/2CEFA910 is not satisfied - flushed only to 0/1B48258 error: dex-timeseriesdb |ĭex-timeseriesdb | PostgreSQL Database directory appears to contain a database Skipping initializationĭex-timeseriesdb | 18:50:47.330 UTC LOG: starting PostgreSQL 12.6 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bitĭex-timeseriesdb | 18:50:47.330 UTC LOG: listening on IPv4 address "0.0.0.0", port 5432ĭex-timeseriesdb | 18:50:47.330 UTC LOG: listening on IPv6 address "::", port 5432ĭex-timeseriesdb | 18:50:47.336 UTC LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"ĭex-timeseriesdb | 18:50:47.486 UTC LOG: database system shutdown was interrupted last known up at 18:47:35 UTCĭex-timeseriesdb | 18:50:49.629 UTC LOG: database system was not properly shut down automatic recovery in progressĭex-timeseriesdb | 18:50:49.645 UTC LOG: redo starts at 0/1B46C68ĭex-timeseriesdb | 18:50:49.648 UTC LOG: invalid record length at 0/1B48258: wanted 24, got 0ĭex-timeseriesdb | 18:50:49.648 UTC LOG: redo done at 0/1B48220ĭex-timeseriesdb | 18:50:49.697 UTC LOG: request to flush past end of generated WAL request 0/2CEFA910, currpos 0/1B48258ĭex-timeseriesdb | 18:50:49.697 UTC CONTEXT: writing block 0 of relation base/13455/16573_vmĭex-timeseriesdb | 18:50:49.697 UTC FATAL: xlog flush request 0/2CEFA910 is not satisfied - flushed only to 0/1B48258ĭex-timeseriesdb | 18:50:49.701 UTC LOG: startup process (PID 21) exited with exit code 1ĭex-timeseriesdb | 18:50:49.701 UTC LOG: aborting startup due to startup process failureĭex-timeseriesdb | 18:50:49.744 UTC LOG: database system is shut down I have a Docker PostgreSQL (TimescaleDB) developer instance with a local Linux volume mapping.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |