Re: strange hung processes
От | Jeremy Ashcraft |
---|---|
Тема | Re: strange hung processes |
Дата | |
Msg-id | 43E26A23.1080208@edgate.com обсуждение исходный текст |
Ответ на | Re: strange hung processes ("Larry Rosenman" <lrosenman@pervasive.com>) |
Ответы |
Re: strange hung processes
|
Список | pgsql-admin |
If it's not sensitive information, what does this show? >> lsof | grep 'pid of hung process' >> From my systems guy: in /proc codd 13262 # cat status {proc "filesystem"} Name: postmaster State: D (disk sleep) Because of the "D" state, it can't be killed as it is not interuptible (waiting on IO ?). codd opt # lsof -p 13263 COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME postmaste 13263 postgres cwd DIR 8,17 464 4030 /app1/user/postgres postmaste 13263 postgres rtd DIR 8,3 488 2 / postmaste 13263 postgres txt REG 8,17 2552859 5012 /app1/pg/7.4.9/bin/postgres postmaste 13263 postgres mem REG 0,0 0 [heap] (stat: No such file or directory) postmaste 13263 postgres DEL REG 0,7 0 /SYSV0052e2c1 postmaste 13263 postgres mem REG 8,3 35428 5729 /lib/libnss_files-2.3.4.so postmaste 13263 postgres mem REG 8,5 18852 6895 /usr/lib/libgpm.so.1.19.0 postmaste 13263 postgres mem REG 8,3 266284 5965 /lib/libncurses.so.5.4 postmaste 13263 postgres mem REG 8,3 1167808 5977 /lib/libc-2.3.4.so postmaste 13263 postgres mem REG 8,3 151896 5755 /lib/libm-2.3.4.so postmaste 13263 postgres mem REG 8,3 10620 5987 /lib/libdl-2.3.4.so postmaste 13263 postgres mem REG 8,3 75848 6003 /lib/libnsl-2.3.4.so postmaste 13263 postgres mem REG 8,3 60884 5998 /lib/libresolv-2.3.4.so postmaste 13263 postgres mem REG 8,3 18424 6006 /lib/libcrypt-2.3.4.so postmaste 13263 postgres mem REG 8,3 173996 6007 /lib/libreadline.so.4.3 postmaste 13263 postgres mem REG 8,3 63204 5976 /lib/libz.so.1.2.2 postmaste 13263 postgres mem REG 8,3 95392 5915 /lib/ld-2.3.4.so postmaste 13263 postgres 0r CHR 1,3 2767 /dev/null postmaste 13263 postgres 1w REG 8,7 7513385 3649 /var/log/pg/ruby.log.bak1 postmaste 13263 postgres 2w REG 8,7 7513385 3649 /var/log/pg/ruby.log.bak1 postmaste 13263 postgres 5u sock 0,4 11790654 can't identify protocol
В списке pgsql-admin по дате отправления: