Date: Tue, 25 Nov 1997 10:46:13 +0000 (GMT) From: Paulo Cesar Pereira de Andrade <paulo@fiscodata-pr.netpar.com.br> To: bugs@freebsd.org Subject: sbwait ? Message-ID: <Pine.BSF.3.96.971125100012.5262A-100000@fiscodata-pr.netpar.com.br>
next in thread | raw e-mail | index | archive | help
Hi,
After a heavy load, doing several tests, to choose a *sql server,
to use in a project in my work, the jobs stopped working.
Here the messages from this night:
-----------
>From daemon Tue Nov 25 02:06:21 1997
Received: (from root@localhost)
by fiscodata-pr.netpar.com.br (8.8.7/8.8.5) id CAA02891
for root; Tue, 25 Nov 1997 02:00:10 GMT
Date: Tue, 25 Nov 1997 02:00:10 GMT
From: Charlie Root <root>
Message-Id: <199711250200.CAA02891@fiscodata-pr.netpar.com.br>
Subject: fiscodata-pr security check output
Status: RO
X-Status:
checking setuid files and devices:
checking for uids of 0:
root 0
toor 0
no /var/log/ipfw.today
fiscodata-pr kernel log messages:
> e is full
> file: table is full
> file: table is full
> file: table is full (*** THIS LINE REPEATS MORE 222 TIMES ***)
> file: table is full
> sio1: 352 more tty-level buffer overflows (total 64465)
> sio1: 884 more tty-level buffer overflows (total 65349)
> sio1: 310 more tty-level buffer overflows (total 65659)
> sio1: 1542 more tty-level buffer overflows (total 67201)
> sio1: 226 more tty-level buffer overflows (total 67427)
> sio1: 2184 more tty-level buffer overflows (total 69611)
> sio1: 126 more tty-level buffer overflows (total 69737)
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> file: table is full
> sio1: 268 more tty-level buffer overflows (total 70005)
> sio1: 1264 more tty-level buffer overflows (total 71269)
> sio1: 3850 more tty-level buffer overflows (total 75119)
> sio1: 308 more tty-level buffer overflows (total 75427)
> sio1: 1689 more tty-level buffer overflows (total 77116)
> sio1: 1652 more tty-level buffer overflows (total 78768)
> sio1: 1261 more tty-level buffer overflows (total 80029)
> sio1: 2270 more tty-level buffer overflows (total 82299)
> sio1: 378 more tty-level buffer overflows (total 82677)
> sio1: 1502 more tty-level buffer overflows (total 84179)
> sio1: 2653 more tty-level buffer overflows (total 86832)
> sio1: 840 more tty-level buffer overflows (total 87672)
> sio1: 912 more tty-level buffer overflows (total 88584)
> sio1: 856 more tty-level buffer overflows (total 89440)
> sio1: 182 more tty-level buffer overflows (total 89622)
> sio1: 1696 more tty-level buffer overflows (total 91318)
> sio1: 1260 more tty-level buffer overflows (total 92578)
> sio1: 240 more tty-level buffer overflows (total 92818)
> sio1: 3836 more tty-level buffer overflows (total 96654)
> sio1: 70 more tty-level buffer overflows (total 96724)
> sio1: 198 more tty-level buffer overflows (total 96922)
> sio1: 1428 more tty-level buffer overflows (total 98350)
> sio1: 352 more tty-level buffer overflows (total 98702)
> sio1: 686 more tty-level buffer overflows (total 99388)
> sio1: 1038 more tty-level buffer overflows (total 100426)
> sio1: 618 more tty-level buffer overflows (total 101044)
> sio1: 1036 more tty-level buffer overflows (total 102080)
> sio1: 198 more tty-level buffer overflows (total 102278)
> sio1: 99 more tty-level buffer overflows (total 102377)
> sio1: 1150 more tty-level buffer overflows (total 103527)
> sio1: 2424 more tty-level buffer overflows (total 105951)
> sio1: 112 more tty-level buffer overflows (total 106063)
> sio1: 660 more tty-level buffer overflows (total 106723)
> sio1: 2 more tty-level buffer overflows (total 106725)
> sio1: 2241 more tty-level buffer overflows (total 108966)
> sio1: 1346 more tty-level buffer overflows (total 110312)
> sio1: 1584 more tty-level buffer overflows (total 111896)
> sio1: 1150 more tty-level buffer overflows (total 113046)
> sio1: 1990 more tty-level buffer overflows (total 115036)
> sio1: 114 more tty-level buffer overflows (total 115150)
> sio1: 2 more tty-level buffer overflows (total 115152)
> sio1: 546 more tty-level buffer overflows (total 115698)
-----------
Sio1 is our dedicated 38400 modem, connected to the Internet.
The related processes:
-----------
# ps -lp 435
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
101 435 227 1 2 0 468 8660 select S v0 78:29.65 /usr/local/H
# ps -jp 435
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
msql 435 227 435 6583e0 1 S v0 78:29.73 /usr/local/Hughes/bi
# ps -lp 443
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
0 443 227 0 10 0 476 104 wait I v0 0:00.02 /bin/sh ./in
# ps -jp 443
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
root 443 227 443 6583e0 1 I v0 0:00.02 /bin/sh ./indexa.sh
# ps -lp 446
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
0 446 443 0 2 0 4704 3684 sbwait I v0 10:05.61 /usr/local/b
# ps -jp 446
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
root 446 443 443 6583e0 1 I v0 10:05.61 /usr/local/bin/perl
# ps -lp 202
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
100 202 1 0 2 0 1220 436 select Is ?? 0:00.03 /usr/local/p
# ps -jp 202
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
postgres 202 1 202 658980 0 Is ?? 0:00.03 /usr/local/pgsql/bin
# ps -lp 496
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
1000 496 456 0 10 0 484 100 wait I v1 0:00.03 /bin/sh ./in
# ps -jp 496
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
paulo 496 456 496 6584e0 1 I v1 0:00.03 /bin/sh ./indexa.sh
# ps -lp 499
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
1000 499 496 3 2 0 4700 3852 sbwait I v1 15:33.84 /usr/local/b
# ps -jp 499
USER PID PPID PGID SESS JOBC STAT TT TIME COMMAND
paulo 499 496 496 6584e0 1 I v1 15:33.84 /usr/local/bin/perl
-----------
System:
-----------
# uname -a
FreeBSD fiscodata-pr.netpar.com.br 2.2.5-STABLE FreeBSD 2.2.5-STABLE #0: Mon Nov 24 12:38:52 GMT 1997 paulo@fiscodata-pr.netpar.com.br:/usr/src/sys/compile/OTIMIZADO i386
# cat /sys/i386/conf/OTIMIZADO
machine "i386"
cpu "I586_CPU"
ident OTIMIZADO
maxusers 10
options INET #InterNETworking
options FFS #Berkeley Fast Filesystem
options NFS #Network Filesystem
options MSDOSFS #MSDOS Filesystem
options PROCFS #Process filesystem
options "COMPAT_43" #Compatible with BSD 4.3 [KEEP THIS!]
options SCSI_DELAY=15 #Be pessimistic about Joe SCSI device
options BOUNCE_BUFFERS #include support for DMA bounce buffers
options UCONSOLE #Allow users to grab the console
options FAILSAFE #Be conservative
options USERCONFIG #boot -c editor
options VISUAL_USERCONFIG #visual boot -c editor
options IPFIREWALL
options IPFIREWALL_VERBOSE
options SYSVSHM
options SYSVSEM
options MAXCONS=12
config kernel root on sd0
controller isa0
controller eisa0
controller fdc0 at isa? port "IO_FD1" bio irq 6 drq 2 vector fdintr
disk fd0 at fdc0 drive 0
options "CMD640"
#controller wdc0 at isa? port "IO_WD1" bio irq14 vector wdintr
#options ATAPI
#options ATAPI_STATIC
#device wcd0
# A single entry for any of these controllers (ncr, ahb, ahc, amd) is
# sufficient for any number of installed devices.
controller ahb0
controller ahc0
controller scbus0
device sd0
device cd0
# syscons is the default console driver, resembling an SCO console
device sc0 at isa? port "IO_KBD" tty irq 1 vector scintr
# Enable this and PCVT_FREEBSD for pcvt vt220 compatible console driver
#device vt0 at isa? port "IO_KBD" tty irq 1 vector pcrint
#options PCVT_FREEBSD=210 # pcvt running on FreeBSD >= 2.0.5
#options XSERVER # include code for XFree86
#options FAT_CURSOR # start with block cursor
# If you have a ThinkPAD, uncomment this along with the rest of the PCVT lines
#options PCVT_SCANSET=2 # IBM keyboards are non-std
# Mandatory, don't remove
device npx0 at isa? port "IO_NPX" flags 0x1 irq 13 vector npxintr
device sio0 at isa? port "IO_COM1" tty irq 4 vector siointr
device sio1 at isa? port "IO_COM2" tty irq 3 vector siointr
device sio2 at isa? disable port "IO_COM3" tty irq 5 vector siointr
device lpt0 at isa? port? tty irq 7 vector lptintr
device lpt1 at isa? port? tty
device psm0 at isa? port "IO_KBD" conflicts tty irq 12 vector psmintr
#device ed0 at isa? port 0x320 net irq 5 iomem 0xd8000 vector edintr
device lnc0 at isa? port 0x300 net irq 15 drq 5 vector lncintr
pseudo-device loop
pseudo-device ether
pseudo-device log
pseudo-device sl 1
# ijppp uses tun instead of ppp device
pseudo-device ppp 1
pseudo-device vn 1
pseudo-device tun 1
pseudo-device pty 16
pseudo-device gzip # Exec gzipped a.out's
-----------
Dmesg, restored from /var/log/messages:
-----------
Copyright (c) 1992-1997 FreeBSD Inc.
Copyright (c) 1982, 1986, 1989, 1991, 1993
The Regents of the University of California. All rights reserved.
FreeBSD 2.2.5-STABLE #0: Mon Nov 24 12:38:52 GMT 1997
paulo@fiscodata-pr.netpar.com.br:/usr/src/sys/compile/OTIMIZADO
CPU: Pentium (90.00-MHz 586-class CPU)
Origin = "GenuineIntel" Id = 0x524 Stepping=4
Features=0x1bf<FPU,VME,DE,PSE,TSC,MSR,MCE,CX8>
real memory = 67108864 (65536K bytes)
avail memory = 62738432 (61268K bytes)
eisa0: <INT30f1 (System Board)>
Probing for devices on the EISA bus
ahc0: <Adaptec aic7770 SCSI host adapter> at 0x9c00-0x9cff irq 11
ahc0: on eisa0 slot 9
ahc0: aic7770 >= Rev E, Twin Channel, A SCSI Id=7, B SCSI Id=7, 4 SCBs
ahc0 waiting for scsi devices to settle
(ahc0:0:0): "HP C3724S 5153" type 0 fixed SCSI 2
sd0(ahc0:0:0): Direct-Access 1149MB (2354660 512 byte sectors)
(ahc0:5:0): "TOSHIBA CD-ROM XM-4101TA 1084" type 5 removable SCSI 2
cd0(ahc0:5:0): CD-ROM can't get the size
(ahc0:6:0): "QUANTUM MAVERICK 540S 0901" type 0 fixed SCSI 2
sd1(ahc0:6:0): Direct-Access 516MB (1057758 512 byte sectors)
ahc0 waiting for scsi devices to settle
Probing for devices on the ISA bus:
sc0 at 0x60-0x6f irq 1 on motherboard
sc0: VGA color <12 virtual consoles, flags=0x0>
sio0 at 0x3f8-0x3ff irq 4 on isa
sio0: type 16550A
sio1 at 0x2f8-0x2ff irq 3 on isa
sio1: type 16550A
lpt0 at 0x378-0x37f irq 7 on isa
lpt0: Interrupt-driven port
lp0: TCP/IP capable interface
lpt1 not found at 0xffffffff
psm0 at 0x60-0x64 irq 12 on motherboard
psm0: device ID 0
fdc0 at 0x3f0-0x3f7 irq 6 drq 2 on isa
fdc0: FIFO enabled, 8 bytes threshold
fd0: 1.44MB 3.5in
lnc0 at 0x300-0x317 irq 15 drq 5 on isa
lnc0: PCnet-ISA address 08:00:09:1f:68:74
npx0 flags 0x1 on motherboard
npx0: INT 16 interface
IP packet filtering initialized, divert disabled, unlimited logging
-----------
It have happened, when I have reset the ipfw rules, with:
# ipfw -f flush
# ipfw /etc/ipfw.cfg
Now, the system is completely idle, but I know, that the processes did
only about 70% of the work.
How can I make the processes restart? This would be a useful
information, if it happens again.
Sorry for the long mail, but I think this can be useful. OK, I am
being bad to FreeBSD :), too much work, but it's intended to survive,
isn't it ? :)
PS: I have been running and cvsupping since 2.2.2-RELEASE in our
last server, a 486. The disk died completely, so I restarted over,
using a backup machine (a 386 running 2.2.2-RELEASE), downloading 2.2.5.
Thanks,
Paulo.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.971125100012.5262A-100000>