5.0.15 not starting (Ubuntu 21)

[germain-italic]

Describe the bug
Hello, dbdeployer deploy single 5.0.15 hangs and fails to start.

However I am able to start 5.0.96 and 5.7.25.

I don't know how to find why mysql won't start, any help is appreciated.

To Reproduce
Steps to reproduce the behavior:

# 5.0.96 complained about these
sudo add-apt-repository universe
sudo apt install libncursesw6 libncursesw5

germain@pop-os:~/sandboxes$ dbdeployer deploy single 5.0.15 --log-sb-operations  --enable-general-log  --force
Overwriting directory /home/germain/sandboxes/msb_5_0_15
Database installed in $HOME/sandboxes/msb_5_0_15
run 'dbdeployer usage single' for basic instructions'
cmd:    /home/germain/sandboxes/msb_5_0_15/start
err:    exit status 1
stdout: ................................................................................................................................................................................... sandbox server not started yet

stderr: 
error creating sandbox: 'exit status 1'

germain@pop-os:~/sandboxes$ tail -f msb_5_0_15/start.log 
Starting mysqld daemon with databases from /home/germain/sandboxes/msb_5_0_15/data
STOPPING server from pid file /home/germain/sandboxes/msb_5_0_15/data/mysql_sandbox5015.pid
211015 20:28:16  mysqld ended

germain@pop-os:~/sandboxes$ tail -f logs/single_5_0_15-112557/single.log 
2021/10/15 20:28:14 [0112557-00029 sandbox.writeScript] Creating  script '$HOME/sandboxes/msb_5_0_15/connection.conf' using template 'connection_info_conf'
2021/10/15 20:28:14 [0112557-00030 sandbox.writeScript] Creating  script '$HOME/sandboxes/msb_5_0_15/connection.json' using template 'connection_info_json'
2021/10/15 20:28:14 [0112557-00031 sandbox.writeScript] Creating  executable script '$HOME/sandboxes/msb_5_0_15/replicate_from' using template 'replicate_from'
2021/10/15 20:28:14 [0112557-00032 sandbox.writeScript] Creating  executable script '$HOME/sandboxes/msb_5_0_15/metadata' using template 'metadata'
2021/10/15 20:28:14 [0112557-00033 sandbox.writeScript] Creating  executable script '$HOME/sandboxes/msb_5_0_15/sysbench' using template 'sysbench'
2021/10/15 20:28:14 [0112557-00034 sandbox.writeScript] Creating  executable script '$HOME/sandboxes/msb_5_0_15/sysbench_ready' using template 'sysbench_ready'
2021/10/15 20:28:14 [0112557-00035 sandbox.writeScript] Creating  executable script '$HOME/sandboxes/msb_5_0_15/wipe_and_restart' using template 'wipe_and_restart'
2021/10/15 20:28:14 [0112557-00036 sandbox.writeScript] Creating  script '$HOME/sandboxes/msb_5_0_15/grants.mysql' using template 'grants5x'
2021/10/15 20:28:14 [0112557-00037 sandbox.writeScript] Creating  script '$HOME/sandboxes/msb_5_0_15/sb_include' using template 'sb_include'
2021/10/15 20:28:14 [0112557-00038 sandbox.createSingleSandbox] Running start script

Environment:

• OS: Pop!_OS 21.04 x86_64

• Kernel: 5.13.0-7614-generic

• Shell: bash 5.1.4

• DE: GNOME 3.38.4

• dbdeployer version 1.63.1

• tarball full name mysql-5.0.15.tar.xz

• tarball origin dbdeployer remote download mysql-5.0.11

[datacharmer]

Thanks for reporting this issue.

I have tried to deploy 5.0.15 in Ubuntu 21.04 (docker container, kernel 5.10.25), and the installation worked correctly.
Two things you can try with your current environment:

1. look whether a file /home/germain/sandboxes/msb_5_0_15/data/msandbox.err exists, and if yes look if the logs give some hint about the failure. One possibility is that the database port is already in use.
2. make sure the database server is not running (from a previous attempt) or the port is occupied by any other process (netstat -atn | grep LISTEN), then edit the script /home/germain/sandboxes/msb_5_0_15/start, add set -x in line 17, and run it. It will show all the commands being executed, and hopefully it will be clearer what it is failing.

[germain-italic]

Thanks @datacharmer for your quick reply!

You're indeed correct, a (ghost?) process was listening to port 5015

I wasn't able to stop it normally:

germain@pop-os:~/sandboxes/msb_5_0_15$ ./stop
stop /home/germain/sandboxes/msb_5_0_15
/home/germain/opt/mysql/5.0.15/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'msandbox'@'localhost' (using password: YES)'
Attempting normal termination --- kill -15 130360

So I had to kill it:

lsof -ti tcp:5015 | xargs kill

Then I re-deployed it:

germain@pop-os:~/sandboxes$ dbdeployer deploy single 5.0.15 --force
Overwriting directory /home/germain/sandboxes/msb_5_0_15
Database installed in $HOME/sandboxes/msb_5_0_15
run 'dbdeployer usage single' for basic instructions'
. sandbox server started

And it works fine:

germain@pop-os:~/sandboxes$ lsof -i :5015
COMMAND    PID    USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld  130739 germain    8u  IPv4 403843      0t0  TCP localhost:5015 (LISTEN)
germain@pop-os:~/sandboxes$ cd msb_5_0_15/
germain@pop-os:~/sandboxes/msb_5_0_15$ ./stop 
stop /home/germain/sandboxes/msb_5_0_15
germain@pop-os:~/sandboxes/msb_5_0_15$ ./start
. sandbox server started

Thanks for your help!