Forgot to mention this SUSE 9 with the default 2.6.5 kernel. Logs does not show anything strange and post refuses to shutdown gracefully or receive connections.Processes just hangs out there ... . Evgeny. On Wed, 4 Jan 2006, Tsirkin Evgeny wrote: > Today i was trying to run an old ver. of an application on test server . > After a while i have got the pg hangs : > 9899 ? S 0:00 postgres: [local] SELECT > 9932 ? S 0:00 postgres: [local] SELECT > 9933 ? S 0:00 postgres: [local] startup > 9936 ? S 0:00 postgres: [local] startup > 9941 ? S 0:00 postgres: > 9974 ? S 0:00 postgres: [local] startup > 9976 ? S 0:00 postgres: [local] startup > 9978 ? S 0:00 postgres: [local] startup > 9983 ? S 0:00 postgres: [local] startup > 9989 ? S 0:00 postgres: template1 [local] startup > This a web application with apache connecting to post and doing things. > I have tryed to connect to the db with psql - nosuccess. > This the backtrace of 9989. > (gdb) > backtrace > #00xffffe410 in ?? () > #10xbfffcc28 in ?? () > #20x00000001 in ?? () > #30x01488005 in ?? () > #40x402ffffb in semop () from /lib/tls/libc.so.6 > #50x08154d07 in PGSemaphoreLock () > #6 0x08177ade in LWLockAcquire () > #70x0816c7f2 in ReadBufferInternal () > #80x08086eb0 in _bt_getbuf () > #90x080882b6 in _bt_getroot () > #10 0x0808ab62 in _bt_search () > #11 0x0808aeca in _bt_first () > #12 0x080894e0 in btgettuple () > #13 0x081eba7b in FunctionCall2 () > #14 0x08083f86 in index_getnext () > #15 0x080836e4 in systable_getnext () > #16 0x080f87ed in RelationBuildTriggers () > #17 0x081e44ab in RelationCacheInitializePhase2 () > #18 0x081f0ce5 in InitPostgres () > #19 0x0817db30 in PostgresMain () > #20 0x08157754 in ServerLoop () > #21 0x08158d1e in PostmasterMain () > #22 0x08128c21 in main () > > Version 7.4 something (does not remember and can't get it because can't > connect to the db).Trying to connect to the template also hangs up. > Please help. > Evgeny. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly >
