From owner-freebsd-ports@FreeBSD.ORG Mon Apr 18 15:08:12 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1188916A4CE; Mon, 18 Apr 2005 15:08:12 +0000 (GMT) Received: from dev.bmby.co.il (l192-114-46-204.broadband.actcom.net.il [192.114.46.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 40A9543D1F; Mon, 18 Apr 2005 15:08:10 +0000 (GMT) (envelope-from uzi@bmby.com) Received: from [10.0.0.3] ([10.0.0.3]) by dev.bmby.co.il (8.12.9/8.12.9) with ESMTP id j3IF82qx025363; Mon, 18 Apr 2005 18:08:02 +0300 Message-ID: <4263DB52.8020408@bmby.com> Date: Mon, 18 Apr 2005 18:07:46 +0200 From: Uzi Klein User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Uzi Klein References: <4263D37E.6070805@bmby.com> <4263D723.6020405@bmby.com> In-Reply-To: <4263D723.6020405@bmby.com> Content-Type: text/plain; charset=windows-1255; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-stable@freebsd.org cc: freebsd-ports@freebsd.org Subject: Re: MySQL signal 11 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 18 Apr 2005 15:08:12 -0000 Uzi Klein wrote: > Uzi Klein wrote: > >> >> Hi >> >> I got this message from mysql-error log. >> Nothing visible on system log, but after it happens, mysql starts >> acting strange (shoes double fields values as 0 while is still >> contains the data - visible after restarting mysql) >> >> Hardware should be OK, nothing wrong in boot message and its a brand >> new HP DL380-G4. >> >> Any leads or ideas? >> > eh.. something causing only 1 attachment to appear... sorry... * mysql-error.log : * mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1044480 max_used_connections=43 max_connections=1000 threads_connected=17 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2306136 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 050415 12:20:07 mysqld restarted 050415 12:20:07 InnoDB: Started; log sequence number 0 43654 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.11-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.11_1 --------------------------------------- * dmesg : * Copyright (c) 1992-2004 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 5.3-RELEASE-p6 #0: Fri Apr 1 22:35:59 UTC 2005 root@devel.bmby.com:/usr/obj/usr/src/sys/BMBY ACPI APIC Table: Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.13-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0xf34 Stepping = 4 Features=0xbfebfbff Hyperthreading: 2 logical CPUs real memory = 2147430400 (2047 MB) avail memory = 2100178944 (2002 MB) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 6 cpu3 (AP): APIC ID: 7 ioapic0 irqs 0-23 on motherboard ioapic1 irqs 24-47 on motherboard ioapic2 irqs 48-71 on motherboard ioapic3 irqs 72-95 on motherboard ioapic4 irqs 96-119 on motherboard npx0: [FAST] npx0: on motherboard npx0: INT 16 interface acpi0: on motherboard acpi0: Power Button (fixed) Timecounter "ACPI-safe" frequency 3579545 Hz quality 1000 acpi_timer0: <24-bit timer at 3.579545MHz> port 0x908-0x90b on acpi0 cpu0: on acpi0 cpu1: on acpi0 cpu2: on acpi0 cpu3: on acpi0 acpi_tz0: on acpi0 pcib0: on acpi0 pci0: on pcib0 pcib1: at device 2.0 on pci0 pci2: on pcib1 pcib2: at device 0.0 on pci2 pci3: on pcib2 bge0: mem 0xfdef0000-0xfdefffff irq 25 at device 1.0 on pci3 miibus0: on bge0 brgphy0: on miibus0 brgphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, 1000baseTX-FDX, auto bge0: Ethernet address: 00:0f:20:f9:d9:a9 bge1: mem 0xfdee0000-0xfdeeffff irq 26 at device 1.1 on pci3 miibus1: on bge1 brgphy1: on miibus1 brgphy1: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, 1000baseTX-FDX, auto bge1: Ethernet address: 00:0f:20:f9:d9:a8 pcib3: at device 0.2 on pci2 pci4: on pcib3 ciss0: port 0x4000-0x40ff mem 0xfdf80000-0xfdfbffff,0xfdff0000-0xfdff1fff irq 51 at device 3.0 on pci4 ciss0: [GIANT-LOCKED] pcib4: at device 6.0 on pci0 pci5: on pcib4 pcib5: at device 0.0 on pci5 pci6: on pcib5 pcib6: at device 0.2 on pci5 pci10: on pcib6 pci0: at device 29.0 (no driver attached) pci0: at device 29.1 (no driver attached) pci0: at device 29.2 (no driver attached) pci0: at device 29.3 (no driver attached) pci0: at device 29.7 (no driver attached) pcib7: at device 30.0 on pci0 pci1: on pcib7 pci1: at device 3.0 (no driver attached) pci1: at device 4.0 (no driver attached) pci1: at device 4.2 (no driver attached) isab0: at device 31.0 on pci0 isa0: on isab0 atapci0: port 0x500-0x50f,0x376,0x170-0x177,0x3f6,0x1f0-0x1f7 at device 31.1 on pci0 ata0: channel #0 on atapci0 ata1: channel #1 on atapci0 atkbdc0: port 0x64,0x60 irq 1 on acpi0 atkbd0: irq 1 on atkbdc0 kbd0 at atkbd0 atkbd0: [GIANT-LOCKED] psm0: irq 12 on atkbdc0 psm0: [GIANT-LOCKED] psm0: model IntelliMouse, device ID 3 sio0: port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0 sio0: type 16550A orm0: at iomem 0xee000-0xeffff,0xcc000-0xcd7ff,0xc8000-0xcbfff,0xc0000-0xc7fff on isa0 pmtimer0 on isa0 sc0: at flags 0x100 on isa0 sc0: VGA <16 virtual consoles, flags=0x300> sio1 at port 0x2f8-0x2ff irq 3 on isa0 sio1: type 16550A vga0: at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 Timecounters tick every 10.000 msec acd0: CDROM at ata0-master PIO4 da0 at ciss0 bus 0 target 0 lun 0 da0: Fixed Direct Access SCSI-0 device da0: 135.168MB/s transfers da0: 34727MB (71122560 512 byte sectors: 255H 32S/T 8716C) da1 at ciss0 bus 0 target 1 lun 0 da1: Fixed Direct Access SCSI-0 device da1: 135.168MB/s transfers da1: 69455MB (142245120 512 byte sectors: 255H 32S/T 17432C) SMP: AP CPU #3 Launched! SMP: AP CPU #1 Launched! SMP: AP CPU #2 Launched! Mounting root from ufs:/dev/da0s1a Pre-seeding PRNG: kickstart . Loading configuration files. Entropy harvesting: interrupts ethernet point_to_point kickstart . swapon: adding /dev/da1s1b as swap device Starting file system checks: /dev/da0s1a: FILE SYSTEM CLEAN; SKIPPING CHECKS /dev/da0s1a: clean, 14532529 free (72385 frags, 1807518 blocks, 0.4% fragmentation) /dev/da1s1d: FILE SYSTEM CLEAN; SKIPPING CHECKS /dev/da1s1d: clean, 30620172 free (2956 frags, 3827152 blocks, 0.0% fragmentation) Setting hostname: devel.bmby.com bge0: flags=8843 mtu 1500 options=1a inet 192.168.0.100 netmask 0xffffff00 broadcast 192.168.0.255 ether 00:0f:20:f9:d9:a9 media: Ethernet autoselect (none) status: no carrier lo0: flags=8049 mtu 16384 inet 127.0.0.1 netmask 0xff000000 add net default: gateway 192.168.0.1 Additional routing options: . Starting devd. Mounting NFS file systems: . Starting syslogd. Apr 1 22:53:41 www syslogd: kernel boot file is /boot/kernel/kernel ELF ldconfig path: /lib /usr/lib /usr/lib/compat /usr/X11R6/lib /usr/local/lib /etc/ld-elf.so.conf a.out ldconfig path: /usr/lib/aout /usr/lib/compat/aout /usr/X11R6/lib/aout /etc/ld.so.conf Starting local daemons: . Updating motd . Configuring syscons: blanktime . Starting sshd. Starting sendmail. Initial i386 initialization: . Additional ABI support: . Starting cron. Local package initialization: Starting apache. Starting mysql. Starting openntpd. Starting proftpd. Starting xinetd. . Additional TCP options: . Starting background file system checks in 60 seconds.