Date: Sun, 30 May 2004 15:52:04 -0400 From: Don Bowman <don@sandvine.com> To: "'current@freebsd.org'" <current@freebsd.org> Subject: hang with raid, postgresql Message-ID: <FE045D4D9F7AED4CBFF1B3B813C85337051D8DE4@mail.sandvine.com>
next in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] I have a system with 2x 2.8GHz XEON (P4), intel e7501 chipset, 4GB of ram, aac [adaptec 2200s] raid with 4 scsi disks. I have also tried asr (adaptec 2015). I have tried two different motherboards. The only application the machine runs is postgresql, with about ~30 databases, about ~250GB of data. I'm finding the machine locks up solid once a day or so (sometimes more, sometimes less, no pattern of time of day). I know its not a hardware issue, it is reliable with FreeBSD 4.7. I've run through memory test, disk test, etc. There appears to be a correlation between disk activity (postgresql vacuum) and the lockup, but i can't be sure. I've just reproduced it with a cvsup from head today [2004-05-30 12:00 EDT], so its still present. I've got a serial console, and the break to debugger (which works under normal circumstances). In the lockup case, i cannot drop into db, and no output appears anywhere. I have enabled the following options, but still no affect, no messages come out (other than erroneous LOR issues). options ALT_BREAK_TO_DEBUGGER options DDB options INVARIANTS options INVARIANT_SUPPORT options WITNESS options WITNESS_SKIPSPIN options MUTEX_DEBUG options DIAGNOSTIC i've tried both with and without ACPI. It does not have PAE configured in. The fact that i can't drop into the debugger using the CR ~ ^B sequence when its locked up implies that its no longer servicing the serial interrupt. Does anyone have any suggestions? postgresql makes use of disk, sysv semaphores, shared memory, etc. I don't have sound, vga, X, ... any of the 'complicated' things, its just a server. There is no ATA. I tried setting kern.smp.active to 0, but it still locked up. I'm looking for any suggestions. I have attached the config file from it if anyone has any comments on that. --don [-- Attachment #2 --] machine i386 cpu I686_CPU ident CDATA makeoptions DEBUG=-g #Build kernel with gdb(1) debug symbols options SCHED_4BSD #4BSD scheduler options INET #InterNETworking options INET6 #IPv6 communications protocols options FFS #Berkeley Fast Filesystem options SOFTUPDATES #Enable FFS soft updates support options UFS_ACL #Support for access control lists options UFS_DIRHASH #Improve performance on big directories options MD_ROOT #MD is a potential root device options NFSCLIENT #Network Filesystem Client options NFSSERVER #Network Filesystem Server options NFS_ROOT #NFS usable as /, requires NFSCLIENT options MSDOSFS #MSDOS Filesystem options CD9660 #ISO 9660 Filesystem options PROCFS #Process filesystem (requires PSEUDOFS) options PSEUDOFS #Pseudo-filesystem framework options COMPAT_43 #Compatible with BSD 4.3 [KEEP THIS!] options COMPAT_FREEBSD4 #Compatible with FreeBSD4 options SCSI_DELAY=1000 #Delay (in ms) before probing SCSI options KTRACE #ktrace(1) support options SYSVSHM #SYSV-style shared memory options SYSVMSG #SYSV-style message queues options SYSVSEM #SYSV-style semaphores options _KPOSIX_PRIORITY_SCHEDULING #Posix P1003_1B real-time extensions options KBD_INSTALL_CDEV # install a CDEV entry in /dev options AHC_REG_PRETTY_PRINT # Print register bitfields in debug # output. Adds ~128k to driver. options AHD_REG_PRETTY_PRINT # Print register bitfields in debug # output. Adds ~215k to driver. options PFIL_HOOKS # pfil(9) framework # Debugging for use in -current options DDB #Enable the kernel debugger options INVARIANTS #Enable calls of extra sanity checking options INVARIANT_SUPPORT #Extra sanity checks of internal structures, required by INVARIANTS options WITNESS #Enable checks to detect deadlocks and cycles options WITNESS_SKIPSPIN #Don't run witness on spinlocks for speed options MUTEX_DEBUG options DIAGNOSTIC # To make an SMP kernel, the next two are needed options SMP # Symmetric MultiProcessor Kernel device apic # I/O APIC device isa device eisa device pci # Floppy drives device fdc # ATA and ATAPI devices device ata device atadisk # ATA disk drives device ataraid # ATA RAID drives device atapicd # ATAPI CDROM drives device atapifd # ATAPI floppy drives device atapist # ATAPI tape drives options ATA_STATIC_ID #Static device numbering # SCSI Controllers device ahd # AHA39320/29320 and onboard AIC79xx devices # SCSI peripherals device scbus # SCSI bus (required for SCSI) device ch # SCSI media changers device da # Direct Access (disks) device sa # Sequential Access (tape etc) device cd # CD device pass # Passthrough device (direct SCSI access) device ses # SCSI Environmental Services (and SAF-TE) # RAID controllers interfaced to the SCSI subsystem device asr # DPT SmartRAID V, VI and Adaptec SCSI RAID device ciss # Compaq Smart RAID 5* device dpt # DPT Smartcache III, IV - See NOTES for options device iir # Intel Integrated RAID device ips # IBM (Adaptec) ServeRAID device mly # Mylex AcceleRAID/eXtremeRAID device aac # Adaptec FSA RAID device amr # Adaptec FSA RAID device aacp # SCSI passthrough for aac (requires CAM) device ida # Compaq Smart RAID device mlx # Mylex DAC960 family device pst # Promise Supertrak SX6000 device twe # 3ware ATA RAID # atkbdc0 controls both the keyboard and the PS/2 mouse device atkbdc # AT keyboard controller device atkbd # AT keyboard device psm # PS/2 mouse device vga # VGA video card driver device splash # Splash screen and screen saver support # syscons is the default console driver, resembling an SCO console device sc # Enable this for the pcvt (VT220 compatible) console driver #device vt #options XSERVER # support for X server on a vt console #options FAT_CURSOR # start with block cursor device agp # support several AGP chipsets # Floating point support - do not disable. device npx # Power management support (see NOTES for more options) #device apm # Add suspend/resume support for the i8254. device pmtimer # PCCARD (PCMCIA) support # Pcmcia and cardbus bridge support device cbb # cardbus (yenta) bridge #device pcic # ExCA ISA and PCI bridges device pccard # PC Card (16-bit) bus device cardbus # CardBus (32-bit) bus # Serial (COM) ports device sio # 8250, 16[45]50 based serial ports # PCI Ethernet NICs. device em # Intel PRO/1000 adapter Gigabit Ethernet Card # PCI Ethernet NICs that use the common MII bus controller code. # NOTE: Be sure to keep the 'device miibus' line in order to use these NICs! device miibus # MII bus support device bfe # Broadcom BCM440x 10/100 ethernet device bge # Broadcom BCM570xx Gigabit Ethernet device fxp # Intel EtherExpress PRO/100B (82557, 82558) device xl # 3Com 3c90x (``Boomerang'', ``Cyclone'') # Pseudo devices - the number indicates how many units to allocate. device random # Entropy device device loop # Network loopback device ether # Ethernet support device tun # Packet tunnel. device pty # Pseudo-ttys (telnet etc) device md # Memory "disks" device gif # IPv6 and IPv4 tunneling device faith # IPv6-to-IPv4 relaying (translation) # The `bpf' device enables the Berkeley Packet Filter. # Be aware of the administrative consequences of enabling this! device bpf # Berkeley packet filter # USB support device uhci # UHCI PCI->USB interface device ohci # OHCI PCI->USB interface device usb # USB Bus (required) #device udbp # USB Double Bulk Pipe devices device ugen # Generic device uhid # "Human Interface Devices" device ukbd # Keyboard device ulpt # Printer device umass # Disks/Mass storage - Requires scbus and da device ums # Mouse device urio # Diamond Rio 500 MP3 player device uscanner # Scanners # USB Ethernet, requires mii device aue # ADMtek USB ethernet device axe # ASIX Electronics USB ethernet device cue # CATC USB ethernet device kue # Kawasaki LSI USB ethernet options ALT_BREAK_TO_DEBUGGER options DDB_UNATTENDED options MAXDSIZ=(1536UL*1024*1024) options MAXSSIZ=(128UL*1024*1024) options DFLDSIZ=(1024UL*1024*1024) options INCLUDE_CONFIG_FILE # Include this file in kernel device gre #IP over IP tunneling options IPFIREWALL #firewall options IPFIREWALL_DEFAULT_TO_ACCEPT #allow everything by default options HZ=1000 options SES_ENABLE_PASSTHROUGH device smbus # Bus support, required for smb below. device smb device ichsmb options SEMMNS=256 options SEMMNI=128 options SEMMSL=128 options CONSPEED=115200 #option VM_KMEM_SIZE_SCALE=2 options VM_KMEM_SIZE_MAX=419430400 options CPU_ENABLE_SSE options CPU_ENABLE_TCC
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?FE045D4D9F7AED4CBFF1B3B813C85337051D8DE4>