[Bug 270807] databases/mysql80-server: mysqld got signal 4
Date: Mon, 22 Apr 2024 15:14:18 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270807 --- Comment #6 from Federico GDB <federicogalvezdurand@yahoo.com> --- Updating on this persistent issue. This hardware is a raspberrypi 3B+ and runs well any MySQL version prior to 8.0.26 (included). The present one is 8.0.35_1 I do not have a raspberrypi 4 anymore, but the behaviour was just the same. #uname -a FreeBSD *****.local 14.0-RELEASE-p6 FreeBSD 14.0-RELEASE-p6 #0: Tue Mar 26 20:37:02 UTC 2024 root@arm64-builder.daemonology.net:/usr/obj/usr/src/arm64.aarch64/sys/GENERIC arm64 #pkg check -dna Checking all packages: 100% #tail -100 /var/log/mysqld.log 2024-04-22T14:48:27.6NZ mysqld_safe Logging to '/var/log/mysqld.log'. 2024-04-22T14:48:27.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2024-04-22T14:48:27.640519Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.35) starting as process 3772 2024-04-22T14:48:27.662506Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-04-22T14:48:27Z UTC - mysqld got signal 4 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x73b397a9d000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... [0x22eb2d4] +0x0 [0x22eb438] +0x0 [0x8573e034] +0x0 [0x8573d774] +0x0 [0x849da1a4] +0x0 [0x3091da4] +0x0 [0x3089a18] +0x0 [0x2e1f6a8] +0x0 [0x2e1bce8] +0x0 [0x2e1cd04] +0x0 [0x3044f20] +0x0 [0x2d9b7c4] +0x0 [0x2b9fd10] +0x0 [0x2d25bd0] +0x0 [0x1fb867c] +0x0 [0x30f2d3c] +0x0 [0x8573334c] +0x0 stack_bottom = 98859e90 thread_stack 0x21000 0x2d50460 <_Z19my_print_stacktracePKhm+0x13c> at /usr/local/libexec/mysqld 0x22eb2d4 <_Z18print_fatal_signali+0x25c> at /usr/local/libexec/mysqld 0x22eb438 <handle_fatal_signal+0x40> at /usr/local/libexec/mysqld 0x8573e034 <pthread_sigmask+0x540> at /lib/libthr.so.3 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 1 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. # dmesg -a Copyright (c) 1992-2023 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 is a registered trademark of The FreeBSD Foundation. FreeBSD 14.0-RELEASE-p6 #0: Tue Mar 26 20:37:02 UTC 2024 root@arm64-builder.daemonology.net:/usr/obj/usr/src/arm64.aarch64/sys/GENERIC arm64 FreeBSD clang version 16.0.6 (https://github.com/llvm/llvm-project.git llvmorg-16.0.6-0-g7cbf1a259152) VT(efifb): resolution 656x416 module scmi already present! real memory = 993988608 (947 MB) avail memory = 945319936 (901 MB) Starting CPU 1 (1) Starting CPU 2 (2) Starting CPU 3 (3) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs random: unblocking device. random: entropy device external interface kbd0 at kbdmux0 ofwbus0: <Open Firmware Device Tree> simplebus0: <Flattened device tree simple bus> on ofwbus0 ofw_clkbus0: <OFW clocks bus> on ofwbus0 clk_fixed0: <Fixed clock> on ofw_clkbus0 clk_fixed1: <Fixed clock> on ofw_clkbus0 regfix0: <Fixed Regulator> on ofwbus0 regfix1: <Fixed Regulator> on ofwbus0 bcm2835_firmware0: <BCM2835 Firmware> on simplebus0 ofw_clkbus1: <OFW clocks bus> on bcm2835_firmware0 psci0: <ARM Power State Co-ordination Interface Driver> on ofwbus0 lintc0: <BCM2836 Interrupt Controller> mem 0x40000000-0x400000ff on simplebus0 intc0: <BCM2835 Interrupt Controller> mem 0x7e00b200-0x7e00b3ff irq 39 on simplebus0 gpio0: <BCM2708/2835 GPIO controller> mem 0x7e200000-0x7e2000b3 irq 7,8 on simplebus0 gpiobus0: <OFW GPIO bus> on gpio0 gpio1: <Raspberry Pi Firmware GPIO controller> on bcm2835_firmware0 gpiobus1: <GPIO bus> on gpio1 mbox0: <BCM2835 VideoCore Mailbox> mem 0x7e00b880-0x7e00b8bf irq 6 on simplebus0 generic_timer0: <ARMv7 Generic Timer> irq 1,2,3,4 on ofwbus0 Timecounter "ARM MPCore Timecounter" frequency 19200000 Hz quality 1000 Event timer "ARM MPCore Eventtimer" frequency 19200000 Hz quality 1000 bcm_dma0: <BCM2835 DMA Controller> mem 0x7e007000-0x7e007eff irq 23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38 on simplebus0 usb_nop_xceiv0: <USB NOP PHY> on ofwbus0 bcm2835_clkman0: <BCM283x Clock Manager> mem 0x7e101000-0x7e102fff on simplebus0 gpioc0: <GPIO controller> on gpio0 uart0: <PrimeCell UART (PL011)> mem 0x7e201000-0x7e2011ff irq 9 on simplebus0 uart0: console (115200,n,8,1) spi0: <BCM2708/2835 SPI controller> mem 0x7e204000-0x7e2041ff irq 11 on simplebus0 spibus0: <OFW SPI bus> on spi0 spibus0: <unknown card> at cs 0 mode 0 spibus0: <unknown card> at cs 1 mode 0 iichb0: <BCM2708/2835 BSC controller> mem 0x7e804000-0x7e804fff irq 19 on simplebus0 bcm283x_dwcotg0: <DWC OTG 2.0 integrated USB controller (bcm283x)> mem 0x7e980000-0x7e98ffff,0x7e006000-0x7e006fff irq 21,22 on simplebus0 usbus1 on bcm283x_dwcotg0 bcmwd0: <BCM2708/2835 Watchdog> mem 0x7e100000-0x7e100113,0x7e00a000-0x7e00a023 on simplebus0 bcmrng0: <Broadcom BCM2835/BCM2838 RNG> mem 0x7e104000-0x7e10400f irq 40 on simplebus0 sdhci_bcm0: <Broadcom 2708 SDHCI controller> mem 0x7e300000-0x7e3000ff irq 48 on simplebus0 mmc0: <MMC/SD bus> on sdhci_bcm0 gpioc1: <GPIO controller> on gpio1 fb0: <BCM2835 VT framebuffer driver> on simplebus0 fb0: keeping existing fb bpp of 32 fbd0 on fb0 WARNING: Device "fb" is Giant locked and may be deleted before FreeBSD 15.0. VT: Replacing driver "efifb" with new "fb". fb0: 656x416(656x416@0,0) 32bpp fb0: fbswap: 1, pitch 2624, base 0x3eaf0000, screen_size 1091584 pmu0: <Performance Monitoring Unit> irq 0 on ofwbus0 cpulist0: <Open Firmware CPU Group> on ofwbus0 cpu0: <Open Firmware CPU> on cpulist0 bcm2835_cpufreq0: <CPU Frequency Control> on cpu0 gpioled0: <GPIO LEDs> on ofwbus0 gpioled0: <led0> failed to map pin armv8crypto0: CPU lacks AES instructions Timecounters tick every 1.000 msec iicbus0: <OFW I2C bus> on iichb0 iic0: <I2C generic I/O> on iicbus0 usbus1: 480Mbps High Speed USB v2.0 ugen1.1: <DWCOTG OTG Root HUB> at usbus1 uhub0 on usbus1 uhub0: <DWCOTG OTG Root HUB, class 9/0, rev 2.00/1.00, addr 1> on usbus1 mmcsd0: 16GB <SDHC SC16G 8.0 SN C5E049F0 MFG 11/2017 by 3 SD> at mmc0 50.0MHz/4bit/65535-block bcm2835_cpufreq0: ARM 600MHz, Core 250MHz, SDRAM 400MHz, Turbo OFF CPU 0: ARM Cortex-A53 r0p4 affinity: 0 Cache Type = <64 byte D-cacheline,64 byte I-cacheline,VIPT ICache,64 byte ERG,64 byte CWG> Instruction Set Attributes 0 = <CRC32> Instruction Set Attributes 1 = <> Instruction Set Attributes 2 = <> Processor Features 0 = <AdvSIMD,FP,EL3 32,EL2 32,EL1 32,EL0 32> Processor Features 1 = <> Memory Model Features 0 = <TGran4,TGran64,SNSMem,BigEnd,16bit ASID,1TB PA> Trying to mount root from ufs:/dev/ufs/rootfs [rw]... Memory Model Features 1 = <8bit VMID> Memory Model Features 2 = <32bit CCIDX,48bit VA> Debug Features 0 = <DoubleLock,2 CTX BKPTs,4 Watchpoints,6 Breakpoints,PMUv3,Debugv8> Debug Features 1 = <> Auxiliary Features 0 = <> Auxiliary Features 1 = <> AArch32 Instruction Set Attributes 5 = <CRC32,SEVL> AArch32 Media and VFP Features 0 = <FPRound,FPSqrt,FPDivide,DP VFPv3+v4,SP VFPv3+v4,AdvSIMD> AArch32 Media and VFP Features 1 = <SIMDFMAC,FPHP DP Conv,SIMDHP SP Conv,SIMDSP,SIMDInt,SIMDLS,FPDNaN,FPFtZ> CPU 1: ARM Cortex-A53 r0p4 affinity: 1 CPU 2: ARM Cortex-A53 r0p4 affinity: 2 CPU 3: ARM Cortex-A53 r0p4 affinity: 3 Release APs...done TCP_ratelimit: Is now initialized uhub0: 1 port with 1 removable, self powered ugen1.2: <vendor 0x0424 product 0x9514> at usbus1 uhub1 on uhub0 uhub1: <vendor 0x0424 product 0x9514, class 9/0, rev 2.00/2.00, addr 2> on usbus1 uhub1: MTT enabled Root mount waiting for: usbus1 uhub1: 5 ports with 4 removable, self powered ugen1.3: <vendor 0x0424 product 0xec00> at usbus1 smsc0 on uhub1 smsc0: <vendor 0x0424 product 0xec00, rev 2.00/2.00, addr 3> on usbus1 smsc0: chip 0xec00, rev. 0002 miibus0: <MII bus> on smsc0 smscphy0: <SMC LAN8700 10/100 interface> PHY 1 on miibus0 smscphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto ue0: <USB Ethernet> on smsc0 ue0: Ethernet address: b8:27:eb:36:17:96 Root mount waiting for: usbus1 Root mount waiting for: usbus1 usb_msc_auto_quirk: UQ_MSC_NO_GETMAXLUN set for USB mass storage device vendor 0x13fe USB DISK 2.0 (0x13fe:0x3600) usb_msc_auto_quirk: UQ_MSC_NO_TEST_UNIT_READY set for USB mass storage device vendor 0x13fe USB DISK 2.0 (0x13fe:0x3600) usb_msc_auto_quirk: UQ_MSC_NO_PREVENT_ALLOW set for USB mass storage device vendor 0x13fe USB DISK 2.0 (0x13fe:0x3600) usb_msc_auto_quirk: UQ_MSC_NO_SYNC_CACHE set for USB mass storage device vendor 0x13fe USB DISK 2.0 (0x13fe:0x3600) Root mount waiting for: usbus1 ugen1.4: <vendor 0x13fe USB DISK 2.0> at usbus1 umass0 on uhub1 umass0: <vendor 0x13fe USB DISK 2.0, class 0/0, rev 2.00/1.10, addr 4> on usbus1 umass0: SCSI over Bulk-Only; quirks = 0xc101 umass0:0:0: Attached to scbus0 (probe0:umass-sim0:0:0:0): REPORT LUNS. CDB: a0 00 00 00 00 00 00 00 00 10 00 00 (probe0:umass-sim0:0:0:0): CAM status: SCSI Status Error (probe0:umass-sim0:0:0:0): SCSI status: Check Condition (probe0:umass-sim0:0:0:0): SCSI sense: ILLEGAL REQUEST asc:20,0 (Invalid command operation code) (probe0:umass-sim0:0:0:0): Error 22, Unretryable error da0 at umass-sim0 bus 0 scbus0 target 0 lun 0 da0: < USB DISK 2.0 PMAP> Removable Direct Access SPC-4 SCSI device da0: Serial Number 079A0A009E087E2B da0: 40.000MB/s transfers da0: 7640MB (15646720 512 byte sectors) da0: quirks=0x3<NO_SYNC_CACHE,NO_6_BYTE> Warning: no time-of-day clock registered, system time will not be set accurately Dual Console: Serial Primary, Video Secondary Setting hostuuid: 30303030-3030-3030-6238-333631373936. Setting hostid: 0x4476d08b. Starting file system checks: /dev/ufs/rootfs: FILE SYSTEM CLEAN; SKIPPING CHECKS /dev/ufs/rootfs: clean, 1687780 free (6340 frags, 210180 blocks, 0.2% fragmentation) Mounting local filesystems:. Setting up harvesting: [CALLOUT],[UMA],[FS_ATIME],SWI,INTERRUPT,NET_NG,[NET_ETHER],NET_TUN,MOUSE,KEYBOARD,ATTACH,CACHED Feeding entropy: . Setting hostname: *********.local. ELF ldconfig path: /lib /usr/lib /usr/lib/compat /usr/local/lib /usr/local/lib/compat/pkg /usr/local/lib/compat/pkg /usr/local/lib/mysql /usr/local/lib/mysql/plugin /usr/local/lib/perl5/5.36/mach/CORE 32-bit compatibility ldconfig path: /usr/lib32 ue0: link state changed to UP lo0: link state changed to UP smsc0: chip 0xec00, rev. 0002 ue0: link state changed to DOWN ue0: link state changed to UP Starting Network: lo0 ue0. lo0: flags=1008049<UP,LOOPBACK,RUNNING,MULTICAST,LOWER_UP> metric 0 mtu 16384 options=680003<RXCSUM,TXCSUM,LINKSTATE,RXCSUM_IPV6,TXCSUM_IPV6> inet 127.0.0.1 netmask 0xff000000 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 groups: lo nd6 options=21<PERFORMNUD,AUTO_LINKLOCAL> ue0: flags=1008843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST,LOWER_UP> metric 0 mtu 1500 options=80009<RXCSUM,VLAN_MTU,LINKSTATE> ether b8:27:eb:36:17:96 media: Ethernet autoselect (100baseTX <full-duplex>) status: active nd6 options=29<PERFORMNUD,IFDISABLED,AUTO_LINKLOCAL> Starting devd. Starting dhclient. -- You are receiving this mail because: You are the assignee for the bug.