dbTalk Databases Forums  

[BUGS] BUG #1451: FATAL: could not reattach to shared memory

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1451: FATAL: could not reattach to shared memory in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kim Hansen
 
Posts: n/a

Default [BUGS] BUG #1451: FATAL: could not reattach to shared memory - 01-31-2005 , 08:56 PM







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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.