Date: Fri, 15 Mar 2002 13:15:56 -0600 From: Kevin Haldeman <kevin@micgi.com> To: freebsd-database@FreeBSD.ORG Cc: freebsd-questions@FreeBSD.ORG Subject: Freakish Rebooting with Mysql Message-ID: <5.1.0.14.2.20020315125447.00ad4b88@mail.micgi.com>
next in thread | raw e-mail | index | archive | help
--=======65194F4A=======
Content-Type: text/plain; x-avg-checked=avg-ok-C1911B3; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 8bit
Anybody here experience strange reboots while running mysql?
Our server stays up for about 3 days and then just reboots.
We've got a Dell PowerEdge with SCSI Drives with plenty of room.
1 GB of Memory and a huge swap which never gets touched.
Seems like once we've run through all of the clean memory this happens more
frequently.
And the part that makes it even more frustrating is that it happens
whenever it pleases.
The server has withstood days with over 100 users at a time accessing the
DB, but a 5 a.m. reboot with no clients happens often.
We're currently running Freebsd 4.4, but we've had this same problem on
Linux builds on different machines... So I don't think it would be a
hardware issue. You wouldn't think a that a bad query would be able to
reboot a box... At least I would hope not.
Kernel has been modified from GENERIC with
options NMBCLUSTERS=10240
options MAXDSIZ="(768*1024*1024)"
options MAXSSIZ="(512*1024*1024)"
options DFLDSIZ="(768*1024*1024)"
maxusers 256
We hit the box from PHP using persistent connections from another server so
the only thing we're running on the server is Mysql.
When the server reboots, there is no log of a kernel panic... It just
reboots...
Any Ideas?
Thanks,
Kevin
Copyright (c) 1992-2001 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
The Regents of the University of California. All rights reserved.
FreeBSD 4.4-RELEASE #5: Thu Feb 7 14:49:57 CST 2002
kdh@db1.micgi.com:/usr/src/sys/compile/GENERIC
Calibrating clock(s) ... TSC clock: 930936846 Hz, i8254 clock: 1193156 Hz
CLK_USE_I8254_CALIBRATION not specified - using default frequency
Timecounter "i8254" frequency 1193182 Hz
CLK_USE_TSC_CALIBRATION not specified - using old calibration method
CPU: Pentium III/Pentium III Xeon/Celeron (930.96-MHz 686-class CPU)
Origin = "GenuineIntel" Id = 0x68a Stepping = 10
Features=0x383fbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,MMX,FXSR,SSE>
real memory = 1073733632 (1048568K bytes)
Physical memory chunk(s):
0x00001000 - 0x0009ffff, 651264 bytes (159 pages)
0x004a7000 - 0x3fff5fff, 1068822528 bytes (260943 pages)
avail memory = 1040781312 (1016388K bytes)
bios32: Found BIOS32 Service Directory header at 0xc00ffe80
bios32: Entry = 0xffe90 (c00ffe90) Rev = 0 Len = 1
pcibios: PCI BIOS entry at 0xc7de
pnpbios: Found PnP BIOS data at 0xc00fe2d0
pnpbios: Entry = f0000:e2f4 Rev = 1.0
Other BIOS signatures found:
ACPI: 000fdcd0
Preloaded elf kernel "kernel" at 0xc0481000.
Pentium Pro MTRR support enabled
md0: Malloc disk
Creating DISK md0
Math emulator present
pci_open(1): mode 1 addr port (0x0cf8) is 0x80000070
pci_open(1a): mode1res=0x80000000 (0x80000000)
pci_cfgcheck: device 0 [class=060000] [hdr=80] is there (id=00091166)
Using $PIR table, 9 entries at 0xc00fc380
npx0: <math processor> on motherboard
npx0: INT 16 interface
pcib0: <ServerWorks NB6635 3.0LE host to PCI bridge> on motherboard
found-> vendor=0x1166, dev=0x0009, revid=0x06
class=06-00-00, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
found-> vendor=0x1166, dev=0x0009, revid=0x06
class=06-00-00, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
found-> vendor=0x8086, dev=0x1229, revid=0x08
class=02-00-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
intpin=a, irq=11
map[10]: type 1, range 32, base fe102000, size 12
map[14]: type 1, range 32, base 0000ecc0, size 6
map[18]: type 1, range 32, base fe000000, size 20
found-> vendor=0x1002, dev=0x4752, revid=0x27
class=03-00-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
map[10]: type 1, range 32, base fc000000, size 24
map[14]: type 1, range 32, base 0000e800, size 8
map[18]: type 1, range 32, base fe101000, size 12
found-> vendor=0x1166, dev=0x0200, revid=0x50
class=06-01-00, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
found-> vendor=0x1166, dev=0x0211, revid=0x00
class=01-01-8a, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
map[20]: type 1, range 32, base 000008b0, size 4
found-> vendor=0x1166, dev=0x0220, revid=0x04
class=0c-03-10, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
intpin=a, irq=10
map[10]: type 1, range 32, base fe100000, size 12
pci0: <PCI bus> on pcib0
fxp0: <Intel Pro 10/100B/100+ Ethernet> port 0xecc0-0xecff mem
0xfe000000-0xfe0fffff,0xfe102000-0xfe102fff irq 11 at device 2.0 on p
ci0
fxp0: using memory space register mapping
fxp0: Ethernet address 00:b0:d0:f9:c2:79
fxp0: PCI IDs: 8086 1229 1028 009b 0008
fxp0: Chip Type: 0
inphy0: <i82555 10/100 media interface> on miibus0
inphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
bpf: fxp0 attached
pci0: <ATI Mach64-GR graphics accelerator> (vendor=0x1002, dev=0x4752) at 14.0
isab0: <ServerWorks IB6566 PCI to ISA bridge> at device 15.0 on pci0
isa0: <ISA bus> on isab0
atapci0: <ServerWorks ROSB4 ATA33 controller> port 0x8b0-0x8bf at device
15.1 on pci0
ata0: iobase=0x01f0 altiobase=0x03f6 bmaddr=0x08b0
ata0: mask=03 status0=50 status1=00
ata0: mask=03 ostat0=50 ostat2=00
ata0-master: ATAPI probe a=14 b=eb
ata0-slave: ATAPI probe a=00 b=00
ata0: mask=03 status0=00 status1=00
ata0: devices=04
ata0: at 0x1f0 irq 14 on atapci0
ata1: iobase=0x0170 altiobase=0x0376 bmaddr=0x08b8
ata1: mask=03 status0=20 status1=30
ata1: mask=03 ostat0=20 ostat2=30
ata1-master: ATAPI probe a=20 b=20
ata1-slave: ATAPI probe a=30 b=30
ata1: mask=03 status0=20 status1=30
ata1-master: ATA probe a=25 b=25
ata1-slave: ATA probe a=25 b=25
ata1: devices=00
ata1: at 0x170 irq 15 on atapci0
ohci0: <OHCI (generic) USB controller> mem 0xfe100000-0xfe100fff irq 10 at
device 15.2 on pci0
ohci0: (New OHCI DeviceId=0x02201166)
usb0: OHCI version 1.0, legacy support
usb0: <OHCI (generic) USB controller> on ohci0
usb0: USB revision 1.0
uhub0: (unknown) OHCI root hub, class 9/0, rev 1.00/1.00, addr 1
uhub0: 2 ports with 2 removable, self powered
pcib1: <ServerWorks NB6635 3.0LE host to PCI bridge> on motherboard
found-> vendor=0x9005, dev=0x00cf, revid=0x01
class=01-00-00, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
intpin=a, irq=5
map[10]: type 1, range 32, base 0000cc00, size 8
map[14]: type 1, range 64, base f9001000, size 12
found-> vendor=0x9005, dev=0x00cf, revid=0x01
class=01-00-00, hdrtype=0x00, mfdev=1
subordinatebus=0 secondarybus=0
intpin=b, irq=11
map[10]: type 1, range 32, base 0000c800, size 8
map[14]: type 1, range 64, base f9000000, size 12
found-> vendor=0x10b7, dev=0x9805, revid=0x78
class=02-00-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
intpin=a, irq=5
map[10]: type 1, range 32, base 0000c480, size 7
map[14]: type 1, range 32, base f9002400, size 7
found-> vendor=0x10b7, dev=0x9805, revid=0x78
class=02-00-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
intpin=a, irq=11
map[10]: type 1, range 32, base 0000c400, size 7
map[14]: type 1, range 32, base f9002000, size 7
found-> vendor=0x1011, dev=0x0026, revid=0x05
class=06-04-00, hdrtype=0x01, mfdev=0
subordinatebus=3 secondarybus=2
pci1: <PCI bus> on pcib1
ahc0: <Adaptec aic7899 Ultra160 SCSI adapter> port 0xcc00-0xccff mem
0xf9001000-0xf9001fff irq 5 at device 2.0 on pci1
ahc0: Reading SEEPROM...done.
ahc0: Manual LVD Termination
ahc0: BIOS eeprom is present
ahc0: Secondary High byte termination Enabled
ahc0: Secondary Low byte termination Enabled
ahc0: Primary Low Byte termination Enabled
ahc0: Primary High Byte termination Enabled
ahc0: Downloading Sequencer Program... 419 instructions downloaded
aic7899: Ultra160 Wide Channel A, SCSI Id=7, 32/255 SCBs
ahc1: <Adaptec aic7899 Ultra160 SCSI adapter> port 0xc800-0xc8ff mem
0xf9000000-0xf9000fff irq 11 at device 2.1 on pci1
ahc1: Reading SEEPROM...done.
ahc1: Manual LVD Termination
ahc1: BIOS eeprom is present
ahc1: Secondary High byte termination Enabled
ahc1: Secondary Low byte termination Enabled
ahc1: Primary Low Byte termination Enabled
ahc1: Primary High Byte termination Enabled
ahc1: Downloading Sequencer Program... 419 instructions downloaded
aic7899: Ultra160 Wide Channel B, SCSI Id=7, 32/255 SCBs
using shared irq11.
xl0: <3Com 3c980C Fast Etherlink XL> port 0xc480-0xc4ff mem
0xf9002400-0xf900247f irq 5 at device 6.0 on pci1
using shared irq5.
xl0: Ethernet address: 00:04:75:84:18:81
xl0: media options word: a
xl0: found MII/AUTO
miibus1: <MII bus> on xl0
xlphy0: <3c905C 10/100 internal PHY> on miibus1
xlphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
bpf: xl0 attached
xl1: <3Com 3c980C Fast Etherlink XL> port 0xc400-0xc47f mem
0xf9002000-0xf900207f irq 11 at device 8.0 on pci1
xl1: Ethernet address: 00:04:75:84:18:93
xl1: media options word: a
xl1: found MII/AUTO
miibus2: <MII bus> on xl1
xlphy1: <3c905C 10/100 internal PHY> on miibus2
xlphy1: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
bpf: xl1 attached
pcib2: <DEC 21154 PCI-PCI bridge> at device 10.0 on pci1
found-> vendor=0x1011, dev=0x0026, revid=0x05
class=06-04-00, hdrtype=0x01, mfdev=0
subordinatebus=3 secondarybus=3
found-> vendor=0x1077, dev=0x1216, revid=0x06
class=01-00-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
intpin=a, irq=5
map[10]: type 1, range 32, base 0000dc00, size 8
map[14]: type 1, range 32, base f6fff000, size 12
pci2: <PCI bus> on pcib2
pcib3: <DEC 21154 PCI-PCI bridge> at device 0.0 on pci2
found-> vendor=0x101e, dev=0x1960, revid=0x20
class=01-04-00, hdrtype=0x00, mfdev=0
subordinatebus=0 secondarybus=0
intpin=a, irq=11
map[10]: type 1, range 32, base f0000000, size 26
pci3: <PCI bus> on pcib3
amr0: <AMI MegaRAID> mem 0xf0000000-0xf3ffffff irq 11 at device 0.0 on pci3
amr0: <PERC 3/DC> Firmware 161J, BIOS 3.17, 64MB RAM
pci2: <unknown card> (vendor=0x1077, dev=0x1216) at 1.0 irq 5
ex_isa_identify()
ata-: ata0 exists, using next available unit number
ata-: ata1 exists, using next available unit number
Trying Read_Port at 203
Trying Read_Port at 243
Trying Read_Port at 283
Trying Read_Port at 2c3
Trying Read_Port at 303
Trying Read_Port at 343
Trying Read_Port at 383
Trying Read_Port at 3c3
isa_probe_children: disabling PnP devices
isa_probe_children: probing non-PnP devices
orm0: <Option ROM> at iomem 0xc0000-0xc7fff on isa0
fdc0: <NEC 72065B or clone> at port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on isa0
fdc0: FIFO enabled, 8 bytes threshold
fd0: <1440-KB 3.5" drive> on fdc0 drive 0
ata2 failed to probe at port 0x1f0 irq 14 on isa0
ata3 failed to probe at port 0x170 irq 15 on isa0
adv0 failed to probe on isa0
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x330
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x334
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x230
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x234
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x130
bt0: Failed Status Reg Test - ff
bt_isa_probe: Probe failed at 0x134
bt0 failed to probe at port 0x134-0x137 on isa0
aha0: status reg test failed ff
aha0: status reg test failed ff
aha0: status reg test failed ff
aha0: status reg test failed ff
aha0: status reg test failed ff
aha0: status reg test failed ff
aha0 failed to probe at port 0x134-0x137 on isa0
aic0 failed to probe at port 0x140-0x15f on isa0
atkbdc0: <Keyboard controller (i8042)> at port 0x60,0x64 on isa0
atkbd0: <AT Keyboard> flags 0x1 irq 1 on atkbdc0
atkbd: the current kbd controller command byte 0065
atkbd: keyboard ID 0x41ab (2)
kbd0 at atkbd0
kbd0: atkbd0, AT 101/102 (2), config:0x1, flags:0x3d0000
psm0: current command byte:0065
psm0: failed to reset the aux device.
vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0
fb0: vga0, vga, type:VGA (5), flags:0x7007f
fb0: port:0x3c0-0x3df, crtc:0x3d4, mem:0xa0000 0x20000
fb0: init mode:24, bios mode:3, current mode:24
fb0: window:0xc00b8000 size:32k gran:32k, buf:0 size:32k
VGA parameters upon power-up
50 18 10 00 00 00 03 00 02 67 5f 4f 50 82 55 81
bf 1f 00 4f 0d 0e 00 00 07 80 9c 8e 8f 28 1f 96
b9 a3 ff 00 01 02 03 04 05 14 07 38 39 3a 3b 3c
3d 3e 3f 0c 00 0f 08 00 00 00 00 00 10 0e 00 ff
VGA parameters in BIOS for mode 24
50 18 10 00 10 00 03 00 02 67 5f 4f 50 82 55 81
bf 1f 00 4f 0d 0e 00 00 00 00 9c 8e 8f 28 1f 96
b9 a3 ff 00 01 02 03 04 05 14 07 38 39 3a 3b 3c
3d 3e 3f 0c 00 0f 08 00 00 00 00 00 10 0e 00 ff
EGA/VGA parameters to be used for mode 24
50 18 10 00 10 00 03 00 02 67 5f 4f 50 82 55 81
bf 1f 00 4f 0d 0e 00 00 00 00 9c 8e 8f 28 1f 96
b9 a3 ff 00 01 02 03 04 05 14 07 38 39 3a 3b 3c
3d 3e 3f 0c 00 0f 08 00 00 00 00 00 10 0e 00 ff
sc0: <System console> at flags 0x100 on isa0
sc0: VGA <16 virtual consoles, flags=0x300>
sc0: fb0, kbd0, terminal emulator: sc (syscons terminal)
pcic0 failed to probe at port 0x3e0 iomem 0xd0000 on isa0
pcic1: not probed (disabled)
sio0: irq maps: 0x41 0x51 0x41 0x41
sio0 at port 0x3f8-0x3ff irq 4 flags 0x10 on isa0
sio0: type 16550A
sio1: irq maps: 0x41 0x49 0x41 0x41
sio1 at port 0x2f8-0x2ff irq 3 on isa0
sio1: type 16550A
sio2: not probed (disabled)
sio3: not probed (disabled)
ppc0: parallel port found at 0x378
ppc0: using extended I/O port range
ppc0: ECP SPP SPP
ppc0: <Parallel port> at port 0x378-0x37f irq 7 on isa0
ppc0: Generic chipset (ECP/PS2/NIBBLE) in COMPATIBLE mode
ppc0: FIFO with 16/16/8 bytes threshold
plip0: <PLIP network interface> on ppbus0
bpf: lp0 attached
lpt0: <Printer> on ppbus0
lpt0: Interrupt-driven port
ppi0: <Parallel I/O> on ppbus0
ed0 failed to probe at port 0x280-0x29f iomem 0xd8000 irq 10 on isa0
fe0 failed to probe at port 0x300-0x31f on isa0
ie0 failed to probe at port 0x300 iomem 0xd0000 irq 10 on isa0
lnc0 failed to probe at port 0x280 irq 10 drq 0 on isa0
cs0 failed to probe at port 0x300-0x31f on isa0
sn0 failed to probe at port 0x300-0x30f irq 10 on isa0
isa_probe_children: probing PnP devices
BIOS Geometries:
0:03fefe3f 0..1022=1023 cylinders, 0..254=255 heads, 1..63=63 sectors
0 accounted for
Device configuration finished.
bpf: lo0 attached
bpf: ppp0 attached
new masks: bio 68cc40, tty 63009a, net 6708ba
bpf: sl0 attached
bpf: faith0 attached
ata0-master: piomode=4 dmamode=2 udmamode=2 dmaflag=1
ata0-master: success setting PIO4 on generic chip
acd0: <CRD-8482B/1.05> CDROM drive at ata0 as master
acd0: read 8250KB/s (32KB/s), 128KB buffer, PIO4
acd0: Reads: CD-R, CD-RW, CD-DA stream, packet
acd0: Audio: play, 255 volume levels
acd0: Mechanism: ejectable tray
acd0: Medium: no/blank disc inside, unlocked, lock protected
Waiting 5 seconds for SCSI devices to settle
(noperiph:ahc0:0:-1:-1): SCSI bus reset delivered. 0 SCBs aborted.
(noperiph:ahc1:0:-1:-1): SCSI bus reset delivered. 0 SCBs aborted.
amrd0: <MegaRAID logical drive> on amr0
amrd0: 51834MB (106156032 sectors) RAID 5 (optimal)
Creating DISK amrd0
Mounting root from ufs:/dev/amrd0s1a
amrd0s1: type 0xa5, start 63, end = 106141454, size 106141392 : OK
--=======65194F4A=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-C1911B3
Content-Disposition: inline
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002
--=======65194F4A=======--
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5.1.0.14.2.20020315125447.00ad4b88>