From owner-freebsd-bugs Tue Nov 25 04:43:18 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id EAA09718 for bugs-outgoing; Tue, 25 Nov 1997 04:43:18 -0800 (PST) (envelope-from owner-freebsd-bugs) Received: from fiscodata-pr.netpar.com.br (tty816.netpar.com.br [200.255.244.88] (may be forged)) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id EAA09711 for ; Tue, 25 Nov 1997 04:43:10 -0800 (PST) (envelope-from paulo@fiscodata-pr.netpar.com.br) Received: from fiscodata-pr.netpar.com.br (fiscodata-pr.netpar.com.br [200.255.244.88]) by fiscodata-pr.netpar.com.br (8.8.7/8.8.5) with SMTP id KAA06384 for ; Tue, 25 Nov 1997 10:46:13 GMT Date: Tue, 25 Nov 1997 10:46:13 +0000 (GMT) From: Paulo Cesar Pereira de Andrade Reply-To: Paulo Cesar Pereira de Andrade To: bugs@freebsd.org Subject: sbwait ? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-bugs@freebsd.org X-Loop: FreeBSD.org Precedence: bulk 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 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 real memory = 67108864 (65536K bytes) avail memory = 62738432 (61268K bytes) eisa0: Probing for devices on the EISA bus ahc0: 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.