could not read transaction log directory ...?

From: Michael Brusser <michael(at)synchronicity(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: could not read transaction log directory ...?
Date: 2003-05-07 19:31:07
Message-ID: DEEIJKLFNJGBEMBLBAHCIEDHDCAA.michael@synchronicity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Running some process on Postgres 7.3.2 I consistently end up with a crash.
This happens on Linux RedHat 6.2, kernel 2.2
Here's the fragment from the database log.

2003-05-07 14:38:48 LOG: recycled transaction log file 0000000000000005
2003-05-07 14:48:56 LOG: recycled transaction log file 0000000000000006
2003-05-07 15:04:10 LOG: recycled transaction log file 0000000000000007
2003-05-07 15:04:10 PANIC: could not read transaction log directory -
(<my_dir_path>/pg_xlog): Unknown error 523
2003-05-07 15:04:11 LOG: server process (pid 449) was terminated by signal
6
2003-05-07 15:04:11 LOG: terminating any other active server processes
2003-05-07 15:04:11 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2003-05-07 15:04:11 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.

The process is loading database with a large number of records,
it runs for about 20-30 minutes before it crashes.
Problem apparently originated in function MoveOfflineLogs (xlog.c)
At this point there are two files in the transaction log directory:
16777216 May 7 15:04 0000000000000008
16777216 May 7 14:55 0000000000000009

Does anyone have an idea why this could happen?

Thanks,
Mike.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-05-07 19:45:37 Re: CIDR in pg_hba.conf
Previous Message Andrew Dunstan 2003-05-07 19:12:42 Re: CIDR in pg_hba.conf