Dear All,
As per the provided link, the pg_resetwal command was executed successfully, and the services have been started. However, a *rollback transaction error* is appearing in the Tomcat catalina.out logs. The below error is also being reported, which indicates that database corruption may have occurred. PANIC: failed to add item to index page in "idx_item_sign" ERROR: index "pg_toast_141429_index" contains unexpected zero page at block 36363 PANIC: failed to add item to index page in "idx_item_01" Call getNextException to see other errors in the batch. ERROR: index "pg_toast_141429_index" contains unexpected zero page at block 36363 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. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Thanks. Regards, Loganathan P On Thu, 10 Sept, 2026, 9:50 pm Justin, <[email protected]> wrote: > [image: Boxbe] <https://www.boxbe.com/overview> Justin ( > [email protected]) added themselves to your Guest List > <https://www.boxbe.com/approved-list?tc_serial=61917440713&tc_rand=1585156446&utm_source=stf&utm_medium=email&utm_campaign=ANNO_TEST&utm_content=001&&key=8wjRYIh46LJ6dE25PyHFzg291h29QWo5BEURoaJDhHQ%3D&token=6i4cGPgwYFsgpwUZk23giIkjm2oHnaZOdaiMz1Rq2f7%2F1mwo91MVbrKWhSTsZ2JW> > | Remove them > <https://www.boxbe.com/anno?action=remove&tc_serial=61917440713&tc_rand=1585156446&utm_source=stf&utm_medium=email&utm_campaign=ANNO_TEST&utm_content=001&&key=8wjRYIh46LJ6dE25PyHFzg291h29QWo5BEURoaJDhHQ%3D&token=6i4cGPgwYFsgpwUZk23giIkjm2oHnaZOdaiMz1Rq2f7%2F1mwo91MVbrKWhSTsZ2JW> > | Block them > <https://www.boxbe.com/anno?action=add&disp=b&tc_serial=61917440713&tc_rand=1585156446&utm_source=stf&utm_medium=email&utm_campaign=ANNO_TEST&utm_content=001&&key=8wjRYIh46LJ6dE25PyHFzg291h29QWo5BEURoaJDhHQ%3D&token=6i4cGPgwYFsgpwUZk23giIkjm2oHnaZOdaiMz1Rq2f7%2F1mwo91MVbrKWhSTsZ2JW> > > > On Thu, Sep 10, 2026 at 11:02 AM Oli Sennhauser < > [email protected]> wrote: > >> Hi Loganathan >> >> >> I am a complete PostgreSQL noob! Reading the manual (after googling) I >> found this: https://www.postgresql.org/docs/current/app-pgresetwal.html >> >> When I tried to simulate your situation I ended up with this: >> >> >> >> > Loganathan, and Oli. > Yes you can use pg_resetwal to get PG to start to get more records that > would be lost otherwise. > > CAN NOT STRESS THIS ENOUGH using pg_resetwal is the last ditch option > after exploring all other options. Use this to fetch what data can be > fetched. DO NOT USE a database that has used pg_resetwal for any other > activity other than getting missing records. > > make a backup of the database before executing pg_walreset. There are > other options to get the data out of the PostgreSQL tables but the catalog > has to be intact. pg_class, pg_attribute, pg_type. loose those tables > the database is toast > > Would like to see the DR and backup methods that was being used. If normal > housekeeping included purging WAL directories there is a very big > disconnect between the sysadmins and dbas > > Best of luck >
