Обсуждение: PostgreSQL XID exceeded crash.
Hi!, I am having an XID issue with PostgreSQL, while doing a pg_restore from a 200MB saved database I get a server crash, searching through the debug messages I have found that PostgreSQL crashes due to a exausted XID resource with a message that looks this way (sorry for the Spanish log) UBICACIÓN: StartupXLOG, xlog.c:4820 LOG: 00000: el límite para el reciclaje de ID de transacciones es 2147484146, limitado por base de datos «postgres» That is, 2GB identifiers available. No the problem is localized I can think o several ways to fix it: 1. Increment XID capacity. I dont think this will work because with time I will reach the maximum value. 2. Reset XID counter?, I don't even know if this makes sense. 3. Do not make transactions?. In some cases I make thousands of SELECTS and I know the data being used it not going to be modified. If I close transactions the XID would decrement?... I do not really understand why this counter keeps growing without decrementing. I have read in http://www.thescripts.com/forum/thread173882.html that with the command pg_resetxlog I can tweak the XID but I am not sure if this is a safe way to fix the issue. Thanks :) Mario.
Mario Lopez wrote: > Hi!, > > I am having an XID issue with PostgreSQL, while doing a pg_restore from > a 200MB saved database I get a server crash, searching through the debug > messages I have found that PostgreSQL crashes due to a exausted XID > resource with a message that looks this way (sorry for the Spanish log) > > UBICACIÓN: StartupXLOG, xlog.c:4820 > LOG: 00000: el límite para el reciclaje de ID de transacciones es > 2147484146, limitado por base de datos «postgres» This is not a problem. If you see a crash, the message is elsewhere -- the message should start with ERROR, FATAL or PANIC. LOG is normal operation. I suggest you look at the log more closely. Maybe the error is the line above; LOCATION lines (UBICACIÓN) are located just below the log entry they are annotating. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Hi Alvaro, Ok, maybe is not a crash but this issue makes postgresql reap all of it's child processes and restart operations, after this error I get in pg_restore this message: pg_restore: [archivador (bd)] Error durante PROCESAMIENTO DE TABLA DE CONTENIDOS: pg_restore: [archivador (bd)] Error en entrada de la tabla de contenidos 1893; 0 1615776 TABLE DATA xxxxx postgres pg_restore: [archivador (bd)] could not execute query: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Command was: INSERT INTO xxxxx VALUES (1755298, 2, 117, 28, 1155, 52457, 1, 1, '', '', '', '', NULL); pg_restore: [archivador (bd)] could not execute query: sin resultado desde el servidor I have a attached a log from the XID exhausted resources till it reaps all of it's child processes, which ends in a crash from pg_restore or any application using this table. Thanks. Alvaro Herrera escribió: > Mario Lopez wrote: > >> Hi!, >> >> I am having an XID issue with PostgreSQL, while doing a pg_restore from >> a 200MB saved database I get a server crash, searching through the debug >> messages I have found that PostgreSQL crashes due to a exausted XID >> resource with a message that looks this way (sorry for the Spanish log) >> >> UBICACIÓN: StartupXLOG, xlog.c:4820 >> LOG: 00000: el límite para el reciclaje de ID de transacciones es >> 2147484146, limitado por base de datos «postgres» >> > > This is not a problem. If you see a crash, the message is elsewhere -- > the message should start with ERROR, FATAL or PANIC. LOG is normal > operation. I suggest you look at the log more closely. > > Maybe the error is the line above; LOCATION lines (UBICACIÓN) are > located just below the log entry they are annotating. > > DEBUG: 00000: StartTransactionCommand UBICACI�N: start_xact_command, postgres.c:1983 DEBUG: 00000: StartTransaction UBICACI�N: ShowTransactionState, xact.c:3930 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 273609597/1/0, nestlvl: 1, children:<> UBICACI�N: ShowTransactionStateRec, xact.c:3955 DEBUG: 00000: reaping dead processes UBICACI�N: reaper, postmaster.c:2021 DEBUG: 00000: proceso de servidor (PID 31622) termin� con c�digo de salida 255 UBICACI�N: LogChildExit, postmaster.c:2419 LOG: 00000: proceso de servidor (PID 31622) termin� con c�digo de salida 255 UBICACI�N: LogChildExit, postmaster.c:2419 LOG: 00000: terminando todos los otros procesos de servidor activos UBICACI�N: HandleChildCrash, postmaster.c:2309 DEBUG: 00000: sending SIGQUIT to process 31308 UBICACI�N: HandleChildCrash, postmaster.c:2362 DEBUG: 00000: sending SIGQUIT to process 31309 UBICACI�N: HandleChildCrash, postmaster.c:2396 DEBUG: 00000: reaping dead processes UBICACI�N: reaper, postmaster.c:2021 LOG: 00000: todos los procesos fueron terminados; reinicializando UBICACI�N: reaper, postmaster.c:2209 DEBUG: 00000: shmem_exit(0) UBICACI�N: shmem_exit, ipc.c:126 DEBUG: 00000: invoking IpcMemoryCreate(size=110387200) UBICACI�N: CreateSharedMemoryAndSemaphores, ipci.c:99 LOG: 00000: el sistema de bases de datos fue interrumpido en 2006-09-04 13:40:56 CEST UBICACI�N: StartupXLOG, xlog.c:4373 LOG: 00000: el registro de checkpoint est� en 1/8C1A12A8 UBICACI�N: StartupXLOG, xlog.c:4441 LOG: 00000: registro de redo en 1/8C1A12A8; registro de undo en 0/0; apagado FALSE UBICACI�N: StartupXLOG, xlog.c:4468 LOG: 00000: siguiente ID de transacci�n: 273407288; siguiente OID: 11724975 UBICACI�N: StartupXLOG, xlog.c:4471 LOG: 00000: siguiente MultiXactId: 5; siguiente MultiXactOffset: 10 UBICACI�N: StartupXLOG, xlog.c:4474 LOG: 00000: el sistema de bases de datos no fue apagado apropiadamente; se est� efectuando la recuperaci�n autom�tica UBICACI�N: StartupXLOG, xlog.c:4531 LOG: 00000: redo comienza en 1/8C1A12EC UBICACI�N: StartupXLOG, xlog.c:4568 LOG: 00000: conexi�n recibida: host=[local] UBICACI�N: BackendRun, postmaster.c:2699 DEBUG: 00000: forked new backend, pid=32029 socket=6 UBICACI�N: BackendStartup, postmaster.c:2520 FATAL: 57P03: el sistema de base de datos est� inici�ndose UBICACI�N: ProcessStartupPacket, postmaster.c:1589 DEBUG: 00000: proc_exit(0) UBICACI�N: proc_exit, ipc.c:95 DEBUG: 00000: shmem_exit(0) UBICACI�N: shmem_exit, ipc.c:126 DEBUG: 00000: exit(0) UBICACI�N: proc_exit, ipc.c:113 DEBUG: 00000: reaping dead processes UBICACI�N: reaper, postmaster.c:2021 DEBUG: 00000: proceso de servidor (PID 32029) termin� con c�digo de salida 0 UBICACI�N: LogChildExit, postmaster.c:2419 LOG: 00000: registro de longitud cero en 1/8E845664 UBICACI�N: ReadRecord, xlog.c:2763 LOG: 00000: redo listo en 1/8E84563C UBICACI�N: StartupXLOG, xlog.c:4626 LOG: 00000: conexi�n recibida: host=[local] UBICACI�N: BackendRun, postmaster.c:2699 DEBUG: 00000: forked new backend, pid=32032 socket=6 UBICACI�N: BackendStartup, postmaster.c:2520 FATAL: 57P03: el sistema de base de datos est� inici�ndose UBICACI�N: ProcessStartupPacket, postmaster.c:1589 DEBUG: 00000: proc_exit(0) UBICACI�N: proc_exit, ipc.c:95 DEBUG: 00000: shmem_exit(0) UBICACI�N: shmem_exit, ipc.c:126 DEBUG: 00000: exit(0) UBICACI�N: proc_exit, ipc.c:113 DEBUG: 00000: reaping dead processes UBICACI�N: reaper, postmaster.c:2021 DEBUG: 00000: proceso de servidor (PID 32032) termin� con c�digo de salida 0 UBICACI�N: LogChildExit, postmaster.c:2419 LOG: 00000: el sistema de bases de datos est� listo UBICACI�N: StartupXLOG, xlog.c:4820 LOG: 00000: el l�mite para el reciclaje de ID de transacciones es 2147484146, limitado por base de datos �postgres� UBICACI�N: SetTransactionIdLimit, varsup.c:234 DEBUG: 00000: proc_exit(0) UBICACI�N: proc_exit, ipc.c:95 DEBUG: 00000: shmem_exit(0) UBICACI�N: shmem_exit, ipc.c:126 DEBUG: 00000: exit(0) UBICACI�N: proc_exit, ipc.c:113 DEBUG: 00000: reaping dead processes UBICACI�N: reaper, postmaster.c:2021 LOG: 00000: conexi�n recibida: host=[local] UBICACI�N: BackendRun, postmaster.c:2699 LOG: 00000: conexi�n autorizada: usuario=postgres database=postgres UBICACI�N: BackendRun, postmaster.c:2769 DEBUG: 00000: postmaster child[32040]: starting with ( UBICACI�N: BackendRun, postmaster.c:2847 DEBUG: 00000: postgres UBICACI�N: BackendRun, postmaster.c:2850 DEBUG: 00000: -v196608 UBICACI�N: BackendRun, postmaster.c:2850 DEBUG: 00000: -p UBICACI�N: BackendRun, postmaster.c:2850 DEBUG: 00000: postgres UBICACI�N: BackendRun, postmaster.c:2850 DEBUG: 00000: ) UBICACI�N: BackendRun, postmaster.c:2852 DEBUG: 00000: InitPostgres UBICACI�N: PostgresMain, postgres.c:2946 DEBUG: 00000: StartTransaction UBICACI�N: ShowTransactionState, xact.c:3930 UBICACI�N: ShowTransactionStateRec, xact.c:3955 DEBUG: 00000: CommitTransaction
Mario Lopez wrote: > Hi Alvaro, > > Ok, maybe is not a crash but this issue makes postgresql reap all of > it's child processes and restart operations, after this error I get in > pg_restore this message: > > pg_restore: [archivador (bd)] Error durante PROCESAMIENTO DE TABLA DE > CONTENIDOS: > pg_restore: [archivador (bd)] Error en entrada de la tabla de contenidos > 1893; 0 1615776 TABLE DATA xxxxx postgres > pg_restore: [archivador (bd)] could not execute query: server closed the > connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > Command was: INSERT INTO xxxxx VALUES (1755298, 2, 117, 28, 1155, > 52457, 1, 1, '', '', '', '', NULL); > pg_restore: [archivador (bd)] could not execute query: sin resultado > desde el servidor > > I have a attached a log from the XID exhausted resources till it reaps > all of it's child processes, which ends in a crash from pg_restore or > any application using this table. The actual problem is shown in these lines: DEBUG: 00000: reaping dead processes UBICACION: reaper, postmaster.c:2021 DEBUG: 00000: proceso de servidor (PID 31622) termino con codigo de salida 255 UBICACION: LogChildExit, postmaster.c:2419 LOG: 00000: proceso de servidor (PID 31622) termino con codigo de salida 255 What you need to find out is why is this process is terminating with code 255. What is it anyway? If you added %p to log_line_prefix we could have a better idea of what is it and what is it doing. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Hola Alvaro, The process that are being reaped are postgresql child processes, more precisely the process that is attending my queryes... Here I have another log that has the %p %i and %x in that order but I see no clear difference. Thanks. Alvaro Herrera escribió: > Mario Lopez wrote: > >> Hi Alvaro, >> >> Ok, maybe is not a crash but this issue makes postgresql reap all of >> it's child processes and restart operations, after this error I get in >> pg_restore this message: >> >> pg_restore: [archivador (bd)] Error durante PROCESAMIENTO DE TABLA DE >> CONTENIDOS: >> pg_restore: [archivador (bd)] Error en entrada de la tabla de contenidos >> 1893; 0 1615776 TABLE DATA xxxxx postgres >> pg_restore: [archivador (bd)] could not execute query: server closed the >> connection unexpectedly >> This probably means the server terminated abnormally >> before or while processing the request. >> Command was: INSERT INTO xxxxx VALUES (1755298, 2, 117, 28, 1155, >> 52457, 1, 1, '', '', '', '', NULL); >> pg_restore: [archivador (bd)] could not execute query: sin resultado >> desde el servidor >> >> I have a attached a log from the XID exhausted resources till it reaps >> all of it's child processes, which ends in a crash from pg_restore or >> any application using this table. >> > > The actual problem is shown in these lines: > > DEBUG: 00000: reaping dead processes > UBICACION: reaper, postmaster.c:2021 > DEBUG: 00000: proceso de servidor (PID 31622) termino con codigo de salida 255 > UBICACION: LogChildExit, postmaster.c:2419 > LOG: 00000: proceso de servidor (PID 31622) termino con codigo de salida 255 > > > What you need to find out is why is this process is terminating with > code 255. What is it anyway? If you added %p to log_line_prefix we > could have a better idea of what is it and what is it doing. > > PID:3559 CMD_TAG:INSERT XID:273990712 DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:273990712/1/0, nestlvl: 1, children: <> PID:3559 CMD_TAG:INSERT XID:273990712 UBICACI�N: ShowTransactionStateRec, xact.c:3955 PID:3559 CMD_TAG:idle XID:0 DEBUG: 00000: StartTransactionCommand PID:3559 CMD_TAG:idle XID:0 UBICACI�N: start_xact_command, postgres.c:1983 PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: StartTransaction PID:3559 CMD_TAG:idle XID:273990713 UBICACI�N: ShowTransactionState, xact.c:3930 PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:273990713/1/0, nestlvl: 1, children: <> PID:3559 CMD_TAG:idle XID:273990713 UBICACI�N: ShowTransactionStateRec, xact.c:3955 PID:3559 CMD_TAG:INSERT XID:273990713 DEBUG: 00000: ProcessQuery PID:3559 CMD_TAG:INSERT XID:273990713 UBICACI�N: ProcessQuery, pquery.c:128 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3524 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 3559) termin� con c�digo de salida 255 PID:3524 CMD_TAG: XID: UBICACI�N: LogChildExit, postmaster.c:2419 PID:3524 CMD_TAG: XID: LOG: 00000: proceso de servidor (PID 3559) termin� con c�digo de salida 255 PID:3524 CMD_TAG: XID: UBICACI�N: LogChildExit, postmaster.c:2419 PID:3524 CMD_TAG: XID: LOG: 00000: terminando todos los otros procesos de servidor activos PID:3524 CMD_TAG: XID: UBICACI�N: HandleChildCrash, postmaster.c:2309 PID:3524 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 3526 PID:3524 CMD_TAG: XID: UBICACI�N: HandleChildCrash, postmaster.c:2362 PID:3524 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 3527 PID:3524 CMD_TAG: XID: UBICACI�N: HandleChildCrash, postmaster.c:2396 PID:3524 CMD_TAG: XID: LOG: 00000: todos los procesos fueron terminados; reinicializando PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2209 PID:3524 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3524 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3524 CMD_TAG: XID: DEBUG: 00000: invoking IpcMemoryCreate(size=110387200) PID:3524 CMD_TAG: XID: UBICACI�N: CreateSharedMemoryAndSemaphores, ipci.c:99 PID:3612 CMD_TAG: XID: LOG: 00000: el sistema de bases de datos fue interrumpido en 2006-09-04 16:08:06 CEST PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4373 PID:3612 CMD_TAG: XID: LOG: 00000: el registro de checkpoint est� en 1/9307E6A0 PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4441 PID:3612 CMD_TAG: XID: LOG: 00000: registro de redo en 1/93000058; registro de undo en 0/0; apagado FALSE PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4468 PID:3612 CMD_TAG: XID: LOG: 00000: siguiente ID de transacci�n: 273975270; siguiente OID: 12298416 PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4471 PID:3612 CMD_TAG: XID: LOG: 00000: siguiente MultiXactId: 5; siguiente MultiXactOffset: 10 PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4474 PID:3612 CMD_TAG: XID: LOG: 00000: el sistema de bases de datos no fue apagado apropiadamente; se est� efectuando la recuperaci�nautom�tica PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4531 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3612 CMD_TAG: XID: LOG: 00000: redo comienza en 1/93000058 PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4568 PID:3612 CMD_TAG: XID: LOG: 00000: registro de longitud cero en 1/9323006C PID:3612 CMD_TAG: XID: UBICACI�N: ReadRecord, xlog.c:2763 PID:3612 CMD_TAG: XID: LOG: 00000: redo listo en 1/93230044 PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4626 PID:3612 CMD_TAG: XID: DEBUG: 00000: el archivo de registro de transacciones �000000010000000100000092� ha sido reciclado PID:3612 CMD_TAG: XID: UBICACI�N: MoveOfflineLogs, xlog.c:2407 PID:3612 CMD_TAG: XID: DEBUG: 00000: el archivo de registro de transacciones �000000010000000100000090� ha sido reciclado PID:3612 CMD_TAG: XID: UBICACI�N: MoveOfflineLogs, xlog.c:2407 PID:3612 CMD_TAG: XID: DEBUG: 00000: el archivo de registro de transacciones �000000010000000100000091� ha sido reciclado PID:3612 CMD_TAG: XID: UBICACI�N: MoveOfflineLogs, xlog.c:2407 PID:3612 CMD_TAG: XID: LOG: 00000: el sistema de bases de datos est� listo PID:3612 CMD_TAG: XID: UBICACI�N: StartupXLOG, xlog.c:4820 PID:3612 CMD_TAG: XID: LOG: 00000: el l�mite para el reciclaje de ID de transacciones es 2147484146, limitado por base dedatos �postgres� PID:3612 CMD_TAG: XID: UBICACI�N: SetTransactionIdLimit, varsup.c:234 PID:3612 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3612 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3612 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3612 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3612 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3612 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3650 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3650 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3650 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3650 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3650 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3650 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3675 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3675 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3675 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3675 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3675 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3675 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3700 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3700 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3700 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3700 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3700 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3700 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3725 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3725 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3725 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3725 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3725 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3725 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3750 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3750 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3750 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3750 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3750 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3750 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3775 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3775 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3775 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3775 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3775 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3775 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3800 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3800 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3800 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3800 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3800 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3800 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3826 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3826 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3826 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3826 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3826 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3826 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3853 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3853 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3853 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3853 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3853 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3853 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3878 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3878 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3878 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3878 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3878 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3878 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3903 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3903 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3903 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3903 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3903 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3903 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3928 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3928 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3928 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3928 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3928 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3928 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3953 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3953 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3953 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3953 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3953 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3953 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:3979 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:3979 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:3979 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:3979 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:3979 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:3979 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:4004 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:4004 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:4004 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:4004 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:4004 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:4004 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:4029 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:4029 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:4029 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:4029 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:4029 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:4029 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021 PID:4054 CMD_TAG: XID: DEBUG: 00000: proc_exit(0) PID:4054 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:95 PID:4054 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:4054 CMD_TAG: XID: UBICACI�N: shmem_exit, ipc.c:126 PID:4054 CMD_TAG: XID: DEBUG: 00000: exit(0) PID:4054 CMD_TAG: XID: UBICACI�N: proc_exit, ipc.c:113 PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:3524 CMD_TAG: XID: UBICACI�N: reaper, postmaster.c:2021
Hola, Mario Lopez wrote: > Hola Alvaro, > > The process that are being reaped are postgresql child processes, more > precisely the process that is attending my queryes... > > Here I have another log that has the %p %i and %x in that order but I > see no clear difference. I see the same as you: the process that dies is the one that was doing the INSERT. There's no stated reason for the failure however ... the process just exits with code 255. I don't remember seeing this before. Is there anything on the kernel messages? I doubt it's the kernel, because we'd be seeing something about getting a signal, and I don't think it would be this reproducible. Maybe someone else has an idea? The previous-to-last message below is "server process exited with exit code 255". What PostgreSQL version is this exactly? Maybe this is the case where proc_exit() is called when it was already running? i.e. proc_exit(proc_exit_inprogress)? Alas, no, I see that that would return with exit code 1, not 255. > PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: StartTransaction > PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionState, xact.c:3930 > PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:273990713/1/0, nestlvl: 1, children: <> > PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionStateRec, xact.c:3955 > PID:3559 CMD_TAG:INSERT XID:273990713 DEBUG: 00000: ProcessQuery > PID:3559 CMD_TAG:INSERT XID:273990713 UBICACI?N: ProcessQuery, pquery.c:128 > PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes > PID:3524 CMD_TAG: XID: UBICACI?N: reaper, postmaster.c:2021 > PID:3524 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 3559) termin? con c?digo de salida 255 > PID:3524 CMD_TAG: XID: UBICACI?N: LogChildExit, postmaster.c:2419 -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Hi again.. There are no kernel messages and I do not seem to find anything related to this error code. The version installed is the last version available in Debian testing branch: postgresql-8.1 8.1.4-6 I have searched and there are not any known bugs about XID or processes exiting unexpectedly Any more ideas, please?. Thanks for your time Alvaro :). --- Mario. Alvaro Herrera escribió: > Hola, > > Mario Lopez wrote: > >> Hola Alvaro, >> >> The process that are being reaped are postgresql child processes, more >> precisely the process that is attending my queryes... >> >> Here I have another log that has the %p %i and %x in that order but I >> see no clear difference. >> > > I see the same as you: the process that dies is the one that was doing > the INSERT. There's no stated reason for the failure however ... the > process just exits with code 255. I don't remember seeing this before. > Is there anything on the kernel messages? I doubt it's the kernel, > because we'd be seeing something about getting a signal, and I don't > think it would be this reproducible. > > Maybe someone else has an idea? The previous-to-last message below is > "server process exited with exit code 255". > > What PostgreSQL version is this exactly? > > Maybe this is the case where proc_exit() is called when it was already > running? i.e. proc_exit(proc_exit_inprogress)? Alas, no, I see that > that would return with exit code 1, not 255. > > > >> PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: StartTransaction >> PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionState, xact.c:3930 >> PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:273990713/1/0, nestlvl: 1, children: <> >> PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionStateRec, xact.c:3955 >> PID:3559 CMD_TAG:INSERT XID:273990713 DEBUG: 00000: ProcessQuery >> PID:3559 CMD_TAG:INSERT XID:273990713 UBICACI?N: ProcessQuery, pquery.c:128 >> PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes >> PID:3524 CMD_TAG: XID: UBICACI?N: reaper, postmaster.c:2021 >> PID:3524 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 3559) termin? con c?digo de salida 255 >> PID:3524 CMD_TAG: XID: UBICACI?N: LogChildExit, postmaster.c:2419 >> > > > >
Alvaro Herrera <alvherre@commandprompt.com> writes: > Maybe someone else has an idea? The previous-to-last message below is > "server process exited with exit code 255". That's very strange if the platform is Linux --- I was guessing it was Windows. Please try to get a core dump from the crash and provide a stack trace. Another thing that would be useful is to turn on log_statement so we can see the exact command causing the crash. regards, tom lane
Hi, The platform as you have seen is Debian testing branch. I have activated log_statement but again nothing clear, the query that makes the system fail has nothing strange on it here is a dump. I do not know how toget a stack trace and the "crash" does not provide a core dump :(. Could you explain how to obtain it?. Thanks, ID:8069 CMD_TAG:idle XID:274157580 DEBUG: 00000: StartTransaction PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: ShowTransactionState, xact.c:3930 PID:8069 CMD_TAG:idle XID:274157580 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 274157580/1/0, nestlvl: 1, children: <> PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: ShowTransactionStateRec, xact.c:3955 PID:8069 CMD_TAG:idle XID:274157580 LOG: 00000: sentencia: INSERT INTO scannmap4 VALUES (1719913, 2, 117, 28, 1155, 17072, 1, 1, '', '', '', '', NULL); PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: log_after_parse, postgres.c:605 PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: ProcessQuery PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: ProcessQuery, pquery.c:128 PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: CommitTransactionCommand PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: finish_xact_command, postgres.c:2006 PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: CommitTransaction PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: ShowTransactionState, xact.c:3930 PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 274157580/1/0, nestlvl: 1, children: <> PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: ShowTransactionStateRec, xact.c:3955 PID:8069 CMD_TAG:INSERT XID:0 LOG: 00000: duración: 0.460 ms PID:8069 CMD_TAG:INSERT XID:0 UBICACIÓN: exec_simple_query, postgres.c:1090 PID:8069 CMD_TAG:idle XID:0 DEBUG: 00000: StartTransactionCommand PID:8069 CMD_TAG:idle XID:0 UBICACIÓN: start_xact_command, postgres.c:1983 PID:8069 CMD_TAG:idle XID:274157581 DEBUG: 00000: StartTransaction PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: ShowTransactionState, xact.c:3930 PID:8069 CMD_TAG:idle XID:274157581 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 274157581/1/0, nestlvl: 1, children: <> PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: ShowTransactionStateRec, xact.c:3955 PID:8069 CMD_TAG:idle XID:274157581 LOG: 00000: sentencia: INSERT INTO scannmap4 VALUES (1719914, 2, 117, 28, 1155, 17073, 1, 1, '', '', '', '', NULL); PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: log_after_parse, postgres.c:605 PID:8025 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2021 PID:8025 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 8069) terminó con código de salida 255 PID:8025 CMD_TAG: XID: UBICACIÓN: LogChildExit, postmaster.c:2419 PID:8025 CMD_TAG: XID: LOG: 00000: proceso de servidor (PID 8069) terminó con código de salida 255 PID:8025 CMD_TAG: XID: UBICACIÓN: LogChildExit, postmaster.c:2419 PID:8025 CMD_TAG: XID: LOG: 00000: terminando todos los otros procesos de servidor activos PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2309 PID:8025 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 8028 PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2362 PID:8025 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 8029 PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2396 PID:8025 CMD_TAG: XID: DEBUG: 00000: reaping dead processes PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2021 PID:8025 CMD_TAG: XID: LOG: 00000: todos los procesos fueron terminados; reinicializando PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2209 PID:8025 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) PID:8025 CMD_TAG: XID: UBICACIÓN: shmem_exit, ipc.c:126 PID:8025 CMD_TAG: XID: DEBUG: 00000: invoking IpcMemoryCreate(size=110387200) PID:8025 CMD_TAG: XID: UBICACIÓN: CreateSharedMemoryAndSemaphores, ipci.c:99 PID:8120 CMD_TAG: XID: LOG: 00000: el sistema de bases de datos fue interrumpido en 2006-09-04 18:56:21 CEST PID:8120 CMD_TAG: XID: UBICACIÓN: StartupXLOG, xlog.c:4373 PID:8120 CMD_TAG: XID: LOG: 00000: el registro de checkpoint está en 1/93231A60 PID:8120 CMD_TAG: XID: UBICACIÓN: StartupXLOG, xlog.c:4441 PID:8120 CMD_TAG: XID: LOG: 00000: registro de redo en 1/93231A60; registro de undo en 0/0; apagado TR Tom Lane escribió: > Alvaro Herrera <alvherre@commandprompt.com> writes: > >> Maybe someone else has an idea? The previous-to-last message below is >> "server process exited with exit code 255". >> > > That's very strange if the platform is Linux --- I was guessing it was > Windows. > > Please try to get a core dump from the crash and provide a stack trace. > > Another thing that would be useful is to turn on log_statement so we can > see the exact command causing the crash. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >
Mario Lopez <mario@lar3d.com> writes: > PID:8069 CMD_TAG:idle XID:274157581 LOG: 00000: sentencia: INSERT INTO > scannmap4 VALUES (1719914, 2, 117, 28, 1155, 17073, 1, 1, '', '', '', > '', NULL); > PID:8069 CMD_TAG:idle XID:274157581 UBICACI�N: log_after_parse, > postgres.c:605 > PID:8025 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 8069) > termin� con c�digo de salida 255 Hm, well that gives us a little bit to go on. Tell us about the schema of table scannmap4 ... what are its column datatypes, indexes, rules, foreign keys, triggers? Can you reproduce the crash just by feeding this one statement into it? regards, tom lane
Hi, I forgot to mention that we are using plphp version 1.1 but I guess that in the process of making a pg_restore this issue does not really matter. Thanks Mario. Mario Lopez escribió: > Hi, > > The platform as you have seen is Debian testing branch. I have > activated log_statement but again nothing clear, the query that makes > the system fail has nothing strange on it here is a dump. > > I do not know how toget a stack trace and the "crash" does not provide > a core dump :(. Could you explain how to obtain it?. > > Thanks, > > ID:8069 CMD_TAG:idle XID:274157580 DEBUG: 00000: StartTransaction > PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: ShowTransactionState, > xact.c:3930 > PID:8069 CMD_TAG:idle XID:274157580 DEBUG: 00000: name: unnamed; > blockState: DEFAULT; state: INPROGR, xid/subid/cid: > 274157580/1/0, nestlvl: 1, children: <> > PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: > ShowTransactionStateRec, xact.c:3955 > PID:8069 CMD_TAG:idle XID:274157580 LOG: 00000: sentencia: INSERT > INTO scannmap4 VALUES (1719913, 2, 117, 28, 1155, 17072, 1, 1, '', '', > '', '', NULL); > PID:8069 CMD_TAG:idle XID:274157580 UBICACIÓN: log_after_parse, > postgres.c:605 > PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: ProcessQuery > PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: ProcessQuery, > pquery.c:128 > PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: > CommitTransactionCommand > PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: finish_xact_command, > postgres.c:2006 > PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: CommitTransaction > PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: > ShowTransactionState, xact.c:3930 > PID:8069 CMD_TAG:INSERT XID:274157580 DEBUG: 00000: name: unnamed; > blockState: STARTED; state: INPROGR, xid/subid/cid: > 274157580/1/0, nestlvl: 1, children: <> > PID:8069 CMD_TAG:INSERT XID:274157580 UBICACIÓN: > ShowTransactionStateRec, xact.c:3955 > PID:8069 CMD_TAG:INSERT XID:0 LOG: 00000: duración: 0.460 ms > PID:8069 CMD_TAG:INSERT XID:0 UBICACIÓN: exec_simple_query, > postgres.c:1090 > PID:8069 CMD_TAG:idle XID:0 DEBUG: 00000: StartTransactionCommand > PID:8069 CMD_TAG:idle XID:0 UBICACIÓN: start_xact_command, > postgres.c:1983 > PID:8069 CMD_TAG:idle XID:274157581 DEBUG: 00000: StartTransaction > PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: ShowTransactionState, > xact.c:3930 > PID:8069 CMD_TAG:idle XID:274157581 DEBUG: 00000: name: unnamed; > blockState: DEFAULT; state: INPROGR, xid/subid/cid: > 274157581/1/0, nestlvl: 1, children: <> > PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: > ShowTransactionStateRec, xact.c:3955 > PID:8069 CMD_TAG:idle XID:274157581 LOG: 00000: sentencia: INSERT > INTO scannmap4 VALUES (1719914, 2, 117, 28, 1155, 17073, 1, 1, '', '', > '', '', NULL); > PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: log_after_parse, > postgres.c:605 > PID:8025 CMD_TAG: XID: DEBUG: 00000: reaping dead processes > PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2021 > PID:8025 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 8069) > terminó con código de salida 255 > PID:8025 CMD_TAG: XID: UBICACIÓN: LogChildExit, postmaster.c:2419 > PID:8025 CMD_TAG: XID: LOG: 00000: proceso de servidor (PID 8069) > terminó con código de salida 255 > PID:8025 CMD_TAG: XID: UBICACIÓN: LogChildExit, postmaster.c:2419 > PID:8025 CMD_TAG: XID: LOG: 00000: terminando todos los otros > procesos de servidor activos > PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2309 > PID:8025 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 8028 > PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2362 > PID:8025 CMD_TAG: XID: DEBUG: 00000: sending SIGQUIT to process 8029 > PID:8025 CMD_TAG: XID: UBICACIÓN: HandleChildCrash, postmaster.c:2396 > PID:8025 CMD_TAG: XID: DEBUG: 00000: reaping dead processes > PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2021 > PID:8025 CMD_TAG: XID: LOG: 00000: todos los procesos fueron > terminados; reinicializando > PID:8025 CMD_TAG: XID: UBICACIÓN: reaper, postmaster.c:2209 > PID:8025 CMD_TAG: XID: DEBUG: 00000: shmem_exit(0) > PID:8025 CMD_TAG: XID: UBICACIÓN: shmem_exit, ipc.c:126 > PID:8025 CMD_TAG: XID: DEBUG: 00000: invoking > IpcMemoryCreate(size=110387200) > PID:8025 CMD_TAG: XID: UBICACIÓN: CreateSharedMemoryAndSemaphores, > ipci.c:99 > PID:8120 CMD_TAG: XID: LOG: 00000: el sistema de bases de datos fue > interrumpido en 2006-09-04 18:56:21 CEST > PID:8120 CMD_TAG: XID: UBICACIÓN: StartupXLOG, xlog.c:4373 > PID:8120 CMD_TAG: XID: LOG: 00000: el registro de checkpoint está en > 1/93231A60 > PID:8120 CMD_TAG: XID: UBICACIÓN: StartupXLOG, xlog.c:4441 > PID:8120 CMD_TAG: XID: LOG: 00000: registro de redo en 1/93231A60; > registro de undo en 0/0; apagado TR > > Tom Lane escribió: >> Alvaro Herrera <alvherre@commandprompt.com> writes: >> >>> Maybe someone else has an idea? The previous-to-last message below is >>> "server process exited with exit code 255". >>> >> >> That's very strange if the platform is Linux --- I was guessing it was >> Windows. >> >> Please try to get a core dump from the crash and provide a stack trace. >> >> Another thing that would be useful is to turn on log_statement so we can >> see the exact command causing the crash. >> >> regards, tom lane >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 1: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly >> >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > >