could not read transaction log directory

Поиск
Список
Период
Сортировка
От Michael Brusser
Тема could not read transaction log directory
Дата
Msg-id DEEIJKLFNJGBEMBLBAHCIEDIDCAA.michael@synchronicity.com
обсуждение исходный текст
Список pgadmin-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.


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: "Adam H. Pendleton"
Дата:
Сообщение: Pgadmin III and wxWindows
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Pgadmin III and wxWindows