Once in a blue moon I get this assertion failure on server start: 2019-06-15 12:00:29.650 -04 [30080] LOG: iniciando PostgreSQL 12beta1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04) 7.4.0, 64-bit 2019-06-15 12:00:29.650 -04 [30080] LOG: escuchando en la dirección IPv4 «127.0.0.1», port 55432 2019-06-15 12:00:29.650 -04 [30080] LOG: escuchando en el socket Unix «/tmp/.s.PGSQL.55432» 2019-06-15 12:00:29.658 -04 [30956] LOG: el sistema de bases de datos fue apagado en 2019-06-15 12:00:24 -04 2019-06-15 12:00:29.659 -04 [30080] LOG: proceso de servidor (PID 30107) terminó con código de salida 15 2019-06-15 12:00:29.659 -04 [30080] LOG: terminando todos los otros procesos de servidor activos TRAP: FailedAssertion(«!(AbortStartTime == 0)», Archivo: «/pgsql/source/master/src/backend/postmaster/postmaster.c», Línea: 2957) Aborted (core dumped)
Apologies for the Spanish -- I cannot readily reproduce this. In essence, this shows a normal startup, until suddenly process 30107 terminates with exit code 15, and then while shutting everything down, postmaster hits the aforementioned assertion and terminates. One problem with debugging this is that I don't know what process 30107 is, since the logs don't mention it. No idea what is going on. But I'm going to set my script to start the server with log_min_messages=debug1, in case I hit it again ... Has anybody else seen this? -- Álvaro Herrera