Bug#926312: MariaDB couldn't start after fresh install

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug#926312: MariaDB couldn't start after fresh install

Joey Schulze
Package: mariadb-server-10.1
Version: 10.1.37-0+deb9u1
Architecture: amd64

After a fresh installation of Debian stretch, a following installation
of said package results in an error:

Here's the transcript:

Setting up mariadb-client-10.1 (10.1.37-0+deb9u1) ...
Setting up mariadb-server-10.1 (10.1.37-0+deb9u1) ...
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
mariadb.service couldn't start.

journalctl -xe says:

Apr 03 11:30:14 Alpha mysqld[6861]: Version: '10.1.37-MariaDB-0+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian
Apr 03 11:30:14 Alpha systemd[6888]: mariadb.service: Failed at step EXEC spawning /etc/mysql/debian-start: No such file or direct
-- Subject: Process /etc/mysql/debian-start could not be executed


Apparently, said script doesn't seem to be part of this package anymore.

Looking at a different host (with architecture i386 though),
/etc/mysql/debian-start was part of this package once:

$ ls -l /etc/mysql/debian-start
-rwxr-xr-x 1 root root 1509 Jun  7  2017 /etc/mysql/debian-start
$ dpkg -S /etc/mysql/debian-start
mariadb-server-10.1: /etc/mysql/debian-start
$ dpkg -l mariadb-server-10.1
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                       Version            Architecture       Description
+++-==========================-==================-==================-==========================================================
ii  mariadb-server-10.1        10.1.26-0+deb9u1   i386               MariaDB database server binaries

I've copied the script from the old packge to the new server and
mariadb was able to start.

Could it be that script got lost somehow?

Regards

        Joey

--
Let's call it an accidental feature.  -- Larry Wall

Please always Cc to me when replying to me on the lists.

Reply | Threaded
Open this post in threaded view
|

Bug#926312: [debian-mysql] Bug#926312: MariaDB couldn't start after fresh install

Otto Kekäläinen-4
Hello!

Thanks for reporting.

The file /etc/mysql/debian-start is shipped as part of the
mariadb-server-10.1 package:
https://packages.debian.org/stretch/amd64/mariadb-server-10.1/filelist

This has been the case for about 4 years and there has not been any
recent changes to this:
https://salsa.debian.org/mariadb-team/mariadb-10.1/blame/stretch/debian/mariadb-server-10.1.install

I would be surprised if a fresh install, the most typical use case,
would be broken.

Are you sure the install is really fresh?

I have no idea how this could have happened. I'd appreciate if you dig
deeper. There is an upcoming stable update to MariaDB so if there is a
problem, it would get fixed and shipped soon.

Reply | Threaded
Open this post in threaded view
|

Bug#926312: [debian-mysql] Bug#926312: Bug#926312: MariaDB couldn't start after fresh install

Otto Kekäläinen-4
Hello!

I've extended our automatic testing system to test for MariaDB 10.1.38
(in Stretch) fresh installs just to be sure, and it passes as
expected:
https://salsa.debian.org/mariadb-team/mariadb-10.1/-/jobs/152301

To debug your case I would need to understand what your "fresh
install" is so I can replicate it.

Reply | Threaded
Open this post in threaded view
|

Bug#926312: MariaDB couldn't start after fresh install

Conrad Sachweh-2
In reply to this post by Joey Schulze
Package: mariadb-server-10.1
Version: 10.1.38-0+deb9u1
Followup-For: Bug #926312

Dear Maintainer,

I purged all mariadb files from my server (also /etc/mysql) and installed mariadb-server.
The installation fails at the configure step of mysql-server and the database is not initialized.

I created the directory /etc/mysql/conf.d (because included in the my.cnf) and reissued the installation and now everything works as expected.
Therefore this bug does only occure on fresh installations, when upgrading from older versions this directory is most likely already existent.

Best regards
Conrad Sachweh


-- System Information:
Debian Release: 9.9
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-9-amd64 (SMP w/1 CPU core)
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE=C.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.1 depends on:
ii  adduser                   3.115
ii  debconf [debconf-2.0]     1.5.61
ii  galera-3                  25.3.19-2
ii  gawk                      1:4.1.4+dfsg-1
ii  init-system-helpers       1.48
ii  iproute2                  4.9.0-1+deb9u1
ii  libaio1                   0.3.110-3
ii  libc6                     2.24-11+deb9u4
ii  libdbi-perl               1.636-1+b1
ii  libpam0g                  1.1.8-3.6
ii  libstdc++6                6.3.0-18+deb9u1
ii  libsystemd0               232-25+deb9u11
ii  lsb-base                  9.20161125
ii  lsof                      4.89+dfsg-0.1
ii  mariadb-client-10.1       10.1.38-0+deb9u1
ii  mariadb-common            10.1.38-0+deb9u1
ii  mariadb-server-core-10.1  10.1.38-0+deb9u1
ii  passwd                    1:4.4-4.1
ii  perl                      5.24.1-3+deb9u5
ii  psmisc                    22.21-2.1+b2
ii  rsync                     3.1.2-1+deb9u2
ii  socat                     1.7.3.1-2+deb9u1
ii  zlib1g                    1:1.2.8.dfsg-5

Versions of packages mariadb-server-10.1 recommends:
ii  libhtml-template-perl  2.95-2

Versions of packages mariadb-server-10.1 suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20160123cvs-4
pn  mariadb-test       <none>
pn  netcat-openbsd     <none>
pn  tinyca             <none>

-- debconf information excluded

Reply | Threaded
Open this post in threaded view
|

Bug#926312: [debian-mysql] Bug#926312: MariaDB couldn't start after fresh install

Faustin Lammler-3
Hi Conrad,
I have just successfully installed mariadb-server (10.1.38-0+deb9u1) on
a fresh Debian Stretch.

There must be something wrong with your setup because fresh installation
of mariadb-server from official Debian repository is widely tested and
we would have a lot more people complaining.

May I ask you to:
- verify that you are using a standard Debian Stretch (not a VPS
  modified one for example) ;
- verify that you are using official Debian repositories ;
- try the installation on a fresh Debian Stretch ;
- provide some more detailed error logs.

Here is how I have just confirmed that mariadb-server can be installed
without problems on a fresh Stretch:
| $ sudo apt update
| $ sudo apt install mariadb-server
| [..]
| $ sudo dpkg -l | grep mariadb-server
| ii  mariadb-server                10.1.38-0+deb9u1             all          MariaDB database server (metapackage depending on the latest version)
| ii  mariadb-server-10.1           10.1.38-0+deb9u1             amd64        MariaDB database server binaries
| ii  mariadb-server-core-10.1      10.1.38-0+deb9u1             amd64        MariaDB database core server files
| $ $ sudo systemctl status mariadb
| ● mariadb.service - MariaDB 10.1.38 database server
|   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
|   Active: active (running) since Thu 2019-06-13 12:34:05 CEST; 7min ago
|     Docs: man:mysqld(8)
|           https://mariadb.com/kb/en/library/systemd/
| Main PID: 1766 (mysqld)
|   Status: "Taking your SQL requests now..."
|   CGroup: /system.slice/mariadb.service
|           └─1766 /usr/sbin/mysqld

Faustin

signature.asc (849 bytes) Download Attachment