|
|
proc: table is full
Hi all,
Why the proc table is full ? Any idea to resolv ? Any experience about
this Pb ?
# uname -a
HP-UX adler B.11.23 U ia64 4175670235 unlimited-user license
# grep full /var/adm/messages
proc: table is full
....
# /usr/sbin/sysdef | grep nproc
nproc 4200 - 10-
-
# /usr/sbin/sysdef | grep ninode
ninode 35648 - 14-
-
# /usr/sbin/sysdef | grep nfile
nfile 65536 - 14-
-
# uptime
10:46am up 28 days, 21:17, 90 users, load average: 0.10, 0.11, 0.13
# w | wc -l
92
# top
System: adler Mon Dec 18
10:47:21 2006
Load averages: 0.08, 0.10, 0.12
541 processes: 514 sleeping, 24 running, 3 zombies
Cpu states:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 0.08 0.0% 0.0% 3.0% 97.0% 0.0% 0.0% 0.0% 0.0%
1 0.08 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
2 0.08 0.0% 0.0% 2.0% 98.0% 0.0% 0.0% 0.0% 0.0%
3 0.08 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
--- ---- ----- ----- ----- ----- ----- ----- ----- -----
avg 0.08 0.0% 0.0% 1.0% 99.0% 0.0% 0.0% 0.0% 0.0%
Memory: 5625340K (1761248K) real, 6735408K (2157012K) virtual, 2926960K
free Page# 1/42
|
|
0
|
|
|
|
Reply
|
 p002842 (1)
|
12/18/2006 10:50:06 AM |
|
p002842@yahoo.fr said:
>Why the proc table is full ? Any idea to resolv ? Any experience about
>this Pb ?
>
># uname -a
>HP-UX adler B.11.23 U ia64 4175670235 unlimited-user license
>
># grep full /var/adm/messages
>proc: table is full
>...
>
># /usr/sbin/sysdef | grep nproc
>nproc 4200 - 10-
Well, at some point in the history your machine had 4200 processes running.
You might be able to find at least some idea of when this happened by
looking at timestamps of other messages around that one in the messages
file.
># top
>System: adler Mon Dec 18
>10:47:21 2006
>Load averages: 0.08, 0.10, 0.12
>541 processes: 514 sleeping, 24 running, 3 zombies
.... but by now it looks like there are only 541.
There's nothing connecting the information frmo 'top' to something that
happened at some earlier point in time.
--
Wolf a.k.a. Juha Laiho Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)
|
|
|
0
|
|
|
|
Reply
|
 Juha
|
12/20/2006 5:12:03 PM
|
|
Juha Laiho wrote:
> p002842@yahoo.fr said:
>
> >Why the proc table is full ? Any idea to resolv ? Any experience about
> >this Pb ?
>
> ># uname -a
> >HP-UX adler B.11.23 U ia64 4175670235 unlimited-user license
> >
> ># grep full /var/adm/messages
> >proc: table is full
> >...
>
> Well, at some point in the history your machine had 4200 processes running.
I remember encountering this problem several years ago on HPUX
when few processes were running. There are other tables involved
and this message confused me for a while.
Also look into the shared memory table and the semaphore table.
I think one of those filled not the process table. One way to get
this problem is to run a database without doing the required kernel
tuning settings.
|
|
|
0
|
|
|
|
Reply
|
Doug
|
12/20/2006 5:59:27 PM
|
|
|
2 Replies
350 Views
(page loaded in 0.064 seconds)
Similiar Articles: Unable to sort dataset with 6.7 Million records. ERROR: Utility ...Probable disk full condition. > I tried few options like changing the ... BY by-variable; PROC APPEND BASE = SORTED DATA = TEMP; PROC SQL; DROP TABLE TEMP; PROC ... Determine number of open files and/or open file locks - comp.sys ...... skwar.name> wrote: > >>Rick Jones wrote: >> >>>i believe there was disucssion some time back about a bug that left >>>zombie zombies around keepin gthe proc table full ... Date/time to date format in PROC SQL - comp.soft-sys.sas ...PROC SQL; CREATE TABLE TEST AS SELECT A.ID AS ID1, A.DOB AS DOB1, B.ID AS ID2, scan('B.DOB', -3, ':') Format=3Dmmddyy8. AS DOB2 FROM MDSVERI.Assessment1 AS A FULL ... Re: does sas support varchar data type? - comp.soft-sys.sas ...> see the following code. is there a generic way to read the full string > into table without specify the length? > > proc sql; > CREATE TABLE test(TEXT varchar ... PROC REPORT or PROC PRINT with variables > 256 characters - comp ...Hello, In the process of generating a series of tables with PROC REPORT and ODS RTF, I ... PROC REPORT has no problem displaying the full text of long character ... How to merge with duplicate observation on both sides - comp.soft ...Use SQL to get a FULL JOIN. proc sql; create table new as select a.*,b.* from left a full join right b on a.id =3D b.id ; quit; On Mar 21, 6:51 ... kill all the child processes - comp.unix.programmer... proc->fields; return undef unless exists $fields{'ppid'}; foreach (@{$proc->table ... how to kill all the children of a process - comp.unix.programmer ... full list of ... proc report - calculating %'s across - comp.soft-sys.sas ...I have this: proc report data=full nowindows headskip; column schoolid a1 i15 ... Calculate Percent using proc report - comp.soft-sys.sas proc sql; create table new ... SQL and first. or last. - comp.soft-sys.sasSQL ALTER TABLE Statement - W3Schools Online Web ... am try to merge two data sets. =A0I have used Proc SQL ... ... Split full name in to first, middle, and last name - comp ... SAS Enterprise Guide Users Asking for functionality available ...INSERTING PROC SYNTAX IN YOUR EDITOR If I ... we are required to have the full program path ... Cycle or Other Cycle'; run; proc sql; create table frq ... Proc: Table Is Full... - AppleThis is a follow up to my problem last week where the server goes catatonic. It happened again this morning, and I was once again unable to ssh into the HP Communities - Proc table is full - Enterprise Business CommunityI am having this message "PROC table in full" in HPUX server. Is there any way to solve this problem without rebooting the server. 7/11/2012 1:16:09 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
4 followers. 