BUG #1451: FATAL: could not reattach to shared memory

From: "Kim Hansen" <k(at)oek(dot)dk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1451: FATAL: could not reattach to shared memory
Date: 2005-01-31 01:14:45
Message-ID: 20050131011445.079749A580C@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1451
Logged by: Kim Hansen
Email address: k(at)oek(dot)dk
PostgreSQL version: 8.0.0 (MSI)
Operating system: MS Windows XP Pro
Description: FATAL: could not reattach to shared memory
Details:

postmaster.exe did something wrong when it started and because of that it
didn't accept any logins, it used more than 100MB RAM (of 512MB) and it use
100% cpu.

The logfiles were filled very fast, 10 MB where genereated every 22 minutes.
I have attached the first 150 lines of the first logfile created when the
server started to the end of this bug report.

The server stopped without problems when I used the 'Stop Service' program.
I tried to reproduce the problem by stopping and starting the server 5
times, but it didn't reappear.

I hope you can use this bug report.
Regards,
Kim Hansen

===== The first lines of the logfile:
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:21 LOG: background writer process (PID 2544) exited with
exit code 0
2005-01-30 12:46:21 LOG: terminating any other active server processes
2005-01-30 12:46:21 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2752) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2860) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2884) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2908) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2932) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 2988) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 3012) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 3084) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:22 LOG: background writer process (PID 3140) exited with
exit code 0
2005-01-30 12:46:22 LOG: terminating any other active server processes
2005-01-30 12:46:22 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3164) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3188) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3212) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3236) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3260) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3284) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3308) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3332) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3356) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3380) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3404) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3428) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3452) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3476) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3500) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3524) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3548) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3572) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:23 LOG: background writer process (PID 3612) exited with
exit code 0
2005-01-30 12:46:23 LOG: terminating any other active server processes
2005-01-30 12:46:23 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:24 LOG: background writer process (PID 3668) exited with
exit code 0
2005-01-30 12:46:24 LOG: terminating any other active server processes
2005-01-30 12:46:24 LOG: all server processes terminated; reinitializing
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
FATAL: could not reattach to shared memory (key=5432001, addr=012F0000):
Invalid argument
2005-01-30 12:46:24 LOG: background writer process (PID 3692) exited with
exit code 0
2005-01-30 12:46:24 LOG: terminating any other active server processes
2005-01-30 12:46:24 LOG: all server processes terminated; reinitializing

Browse pgsql-bugs by date

  From Date Subject
Next Message Jonathan Chen 2005-01-31 03:27:17 BUG #1452: psql and other programs don't offer a password prompt, so I can't login to databases
Previous Message Bruce Momjian 2005-01-30 14:19:03 Re: BUG #1434: ERROR: type "bigserial" does not exist