Re: PostgreSQL Service Unable to Start After Archive Log delete

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, <zzzzz(dot)graf(at)gmail(dot)com> wrote:

> [image: Boxbe] <https://www.boxbe.com/overview> Justin (
> zzzzz(dot)graf(at)gmail(dot)com) 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 <
> oli(dot)sennhauser(at)fromdual(dot)com> 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
>