Re: Found this in the server log on MAC OSX
От | Sean Shanny |
---|---|
Тема | Re: Found this in the server log on MAC OSX |
Дата | |
Msg-id | 403B83FA.10300@earthlink.net обсуждение исходный текст |
Ответ на | Re: Found this in the server log on MAC OSX (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
To all, It looks like it is the fault of the shutdown script <said Sean with sheepish look on my face> We have to take a look a the scripts, found them on the web, to figure out what they are doing to cause this. Sorry for the clutter in your mailboxes. --sean waiting for postmaster to shut down................................................................ failed pg_ctl: postmaster does not shut down /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: ??: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: S: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 3:35.75: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: postgres:: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: tripmaster: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: tripmaster: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 192.168.34.19: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: idle: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: ??: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: S: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 0:03.56: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: postgres:: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: tripmaster: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: tripmaster: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 192.168.35.16: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: idle: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: in: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: transaction: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: std-: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: S: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 0:00.71: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: postgres:: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: stats: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: buffer: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: process: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: std-: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: S: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: 0:03.78: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: postgres:: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: stats: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: collector: no such pid /Library/StartupItems/PostgreSQL/PostgreSQL: line 61: kill: process: no such pid Tom Lane wrote: >"Ed L." <pgsql@bluepolka.net> writes: > > >>On Monday February 23 2004 8:43, Sean Shanny wrote: >> >> >>>*LOG: received smart shutdown request * >>>*FATAL: the database system is shutting down >>>FATAL: the database system is shutting down >>>LOG: server process (PID 4691) was terminated by signal 9 >>>LOG: terminating any other active server processes >>>LOG: statistics collector process (PID 361) was terminated by signal 9 >>> >>> > > > >>Looks like it got a SIGTERM, which is what you might get if someone shutdown >>OSX (osx pls gurus correct me). >> >> > >Uh, no, signal 9 is SIGKILL not SIGTERM. I'm not aware of any automatic >mechanism in OS X that would issue SIGKILL against a Postgres backend. >Certainly Postgres itself would not. Some Linux kernels issue SIGKILL >to get out of out-of-memory situations, but I believe OS X to be better >behaved than that. > >My private opinion is that Sean is mistaken and that the above trace >shows someone manually (and not very competently) shutting down the >database. First they tried a SIGTERM against the postmaster (or >equivalently "pg_ctl stop") and after getting tired of waiting for >the clients to shut down, they did SIGKILL against the backends. >It's too bad we have no timestamps in this log, as the intervals >between the above-recorded entries would be very revealing. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 3: 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 > > >
В списке pgsql-general по дате отправления:
Следующее
От: "Gellert, Andre"Дата:
Сообщение: Re: PHP + Postgres: More than 1000 postmasters produce