← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB-10.2.11 Long Time To Start

 

Michael,

Sorry, I now realize that you must likely have used a stripped executable,
and therefore the symbols for the InnoDB functions are missing (displayed
as ?? in the stack trace output from gdb). As far as I understand, gdb
should be able to resolve the symbols if you install the separate debug
symbol package:

sudo apt install mariadb-server-core-10.2-dbgsym

I tried to find the installation package corresponding to
'10.2.11-MariaDB-10.2.11+maria~xenial-log' so that I would be able to
resolve the stack trace manually. As a developer, normally I work with code
that I build myself from the source code, and therefore I am a bit bad at
giving advice that applies to the packaged code.

I downloaded and extracted the files from the following packages:
mariadb-server-10.2-dbgsym_10.2.11+maria~xenial_amd64.deb
<http://mirror.netinch.com/pub/mariadb//mariadb-10.2.11/repo/ubuntu/pool/main/m/mariadb-10.2/mariadb-server-10.2-dbgsym_10.2.11+maria~xenial_amd64.deb>
mariadb-server-10.2_10.2.11+maria~xenial_amd64.deb
<http://mirror.netinch.com/pub/mariadb//mariadb-10.2.11/repo/ubuntu/pool/main/m/mariadb-10.2/mariadb-server-10.2_10.2.11+maria~xenial_amd64.deb>
mariadb-server-core-10.2-dbgsym_10.2.11+maria~xenial_amd64.deb
<http://mirror.netinch.com/pub/mariadb//mariadb-10.2.11/repo/ubuntu/pool/main/m/mariadb-10.2/mariadb-server-core-10.2-dbgsym_10.2.11+maria~xenial_amd64.deb>
mariadb-server-core-10.2_10.2.11+maria~xenial_amd64.deb
<http://mirror.netinch.com/pub/mariadb//mariadb-10.2.11/repo/ubuntu/pool/main/m/mariadb-10.2/mariadb-server-core-10.2_10.2.11+maria~xenial_amd64.deb>

The server executable /usr/sbin/mysqld is included in the mysql-server-core
package. Unfortunately I was unable to match that executable with the
addresses from your gdb output. I did the following:

file mysqld
mysqld: ELF 64-bit LSB shared object, x86-64, version 1 (GNU/Linux),
dynamically linked, interpreter /lib64/ld-linux-x86-64.so.2, for GNU/Linux
2.6.32, BuildID[sha1]=7649cc717c0ee820185a633fd27692f3b9160bed, stripped

gdb mysqld
symbol-file
../lib/debug/.build-id/76/49cc717c0ee820185a633fd27692f3b9160bed.debug

followed by a number of gdb commands. I expected the least significant 12
bits of the addresses to match in the disassembly of
ha_initialize_handlerton() and plugin_init(), but that was not the case.
Maybe I did something wrong.

So, can you please install the debug symbol package and try again?

Best regards,

Marko

Follow ups

References