<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hello,<br>
Thank you for testing. I assume these are different issues. Other
happens in low end ARMv5 machine with 512 MB (memory which is kind
of low now a days) and other is in normal server/laptop inside XEN
machine (although i686? 32-bit still as armel). As I understand your
problem is in initializing mysql-dir (which is mandatory) but
MYISAM/Aria and InnoDB works ok?<br>
<br>
But you can debug this (I ate my dogfood and tested not just write
from the memory sorry for that)<br>
shutdown mariadbd (which is not probably not running)<br>
remove /var/lib/mysql which again will destroy your database (Please
note)<br>
use to install your database:<br>
<br>
<span style="color:#000000;background-color:#ffffff;">/usr/bin/mariadb-install-db
--rpm --cross-bootstrap --user=mysql</span><br>
<br>
Does it print some errors? Is there any errors in syslog? Does
MariaDB start after this?<br>
Sincerely,<br>
Tuukka
<p><br>
</p>
<div class="moz-cite-prefix"><a class="moz-txt-link-abbreviated" href="mailto:k-i-r@web.de">k-i-r@web.de</a> kirjoitti 19.12.2023 klo
16.33:<br>
</div>
<blockquote type="cite"
cite="mid:trinity-f1727777-6ec2-40a9-82e5-0af2d2bb7931-1702996419186@3c-app-webde-bap07">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Removing mariadb-server via apt purge also removes the user
mysql.</div>
<div>--> chown mysql:mylsql doesn't work.</div>
<div>Reinstalling mariadb-server doesn't solve the issue.</div>
<div>
<div>
<div> </div>
<div> </div>
<div><b>Gesendet:</b> Dienstag, 19. Dezember 2023 um 13:01
Uhr</div>
<div name="quote"
style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Von:</b> "Tuukka
Pasanen" <a class="moz-txt-link-rfc2396E" href="mailto:tuukka.pasanen@ilmi.fi"><tuukka.pasanen@ilmi.fi></a><br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:k-i-r@web.de">k-i-r@web.de</a><br>
<b>Cc:</b> "Scott Barker" <a class="moz-txt-link-rfc2396E" href="mailto:scott@mostlylinux.ca"><scott@mostlylinux.ca></a>,
<a class="moz-txt-link-abbreviated" href="mailto:1058706@bugs.debian.org">1058706@bugs.debian.org</a>, "Otto Kekäläinen"
<a class="moz-txt-link-rfc2396E" href="mailto:otto@debian.org"><otto@debian.org></a>, "Faustin Lammler"
<a class="moz-txt-link-rfc2396E" href="mailto:faustin@mariadb.org"><faustin@mariadb.org></a><br>
<b>Betreff:</b> Re: Aw: Re: Bug#1058706:
mariadb-server-core: mariadbd fails to start on fresh
install on armel</div>
<div name="quoted-content">
<p>Hello,</p>
<p>I've investigate this yesterday and I could reproduce
this one:</p>
<pre class="message">Dec 17 11:17:55 gast1 mariadbd[1291]: 2023-12-17 11:17:55 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Dec 17 11:17:55 gast1 mariadbd[1291]: 2023-12-17 11:17:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Dec 17 11:17:55 gast1 mariadbd[1291]: 2023-12-17 11:17:55 0 [ERROR] Aborting
Can you do (Please on testing machine not production will destroy your database!!!)
apt purge mariadb-server
# check is your database is not available /var/lib/mysql if it is remote it
mkdir -p /var/lib/mysql
chown mysql:mysql /var/lib/mysql
and then re-install mariad-server again. Does it work then? Just trying to see if my findings are correct. What comes to this InnoDB corruption I can't reproduce that.
Sincerely,
Tuukka
</pre>
<p> </p>
<div class="moz-cite-prefix"><a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:k-i-r@web.de" onclick=""
target="_blank" moz-do-not-send="true">k-i-r@web.de</a>
kirjoitti 19.12.2023 klo 12.18:</div>
<blockquote>
<pre class="moz-quote-pre">Hi Tuukka,
I don't think the issue is related to the armel hardware.
I see the same error on my XEN-VM (1 VCPU) based on a Intel(R) Celeron(R) CPU G3900 @ 2.80GHz processor with 2 cores.
No lack of memory could be seen during installation of mariadb-server package. I tested it with 2 or 8 GB of assigned RAM.
Regards,
Konstantin
Gesendet: Montag, 18. Dezember 2023 um 08:23 Uhr
Von: "Tuukka Pasanen" <a class="moz-txt-link-rfc2396E"
href="mailto:tuukka.pasanen@ilmi.fi" onclick=""
target="_blank" moz-do-not-send="true"><tuukka.pasanen@ilmi.fi></a>
An: "Scott Barker" <a class="moz-txt-link-rfc2396E"
href="mailto:scott@mostlylinux.ca" onclick=""
target="_blank" moz-do-not-send="true"><scott@mostlylinux.ca></a>, <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:1058706@bugs.debian.org" onclick=""
target="_blank" moz-do-not-send="true">1058706@bugs.debian.org</a>, "Otto Kekäläinen" <a
class="moz-txt-link-rfc2396E"
href="mailto:otto@debian.org" onclick=""
target="_blank" moz-do-not-send="true"><otto@debian.org></a>, <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:k-i-r@web.de" onclick="" target="_blank"
moz-do-not-send="true">k-i-r@web.de</a>
Cc: "Faustin Lammler" <a class="moz-txt-link-rfc2396E"
href="mailto:faustin@mariadb.org" onclick=""
target="_blank" moz-do-not-send="true"><faustin@mariadb.org></a>
Betreff: Re: Bug#1058706: mariadb-server-core: mariadbd fails to start on fresh install on armel
Hello,
Have you monitored that is memory exhausted at the installation? This
could lead error like that.
I assume your XEN/KVM/Docker base machine is some older system with not
so fancy CPU or is there any particular reason to use armel build?
Sincerly,
Tuukka
Scott Barker kirjoitti 17.12.2023 klo 19.15:
</pre>
<blockquote>
<pre class="moz-quote-pre">Same result with the latest kernel:
Linux nas-1 6.1.0-16-marvell #1 Debian 6.1.67-1 (2023-12-12) armv5tel
GNU/Linux
On Sun, Dec 17, 2023 at 09:59:23AM -0700, Scott Barker wrote:
</pre>
<blockquote>
<pre class="moz-quote-pre">Prior to the installation, /var/lib/mysql did not exist. After
installation:
61559 4 drwxr-xr-x 2 mysql mysql 4096 Dec 17 09:56
/var/lib/mysql
61975 4 -rw-rw---- 1 mysql mysql 52 Dec 17 09:56
/var/lib/mysql/aria_log_control
61983 12304 -rw-rw---- 1 mysql mysql 12582912 Dec 17 09:56
/var/lib/mysql/ibdata1
61963 0 -rw-r--r-- 1 root root 0 Dec 17 09:56
/var/lib/mysql/debian-10.11.flag
61990 98404 -rw-rw---- 1 mysql mysql 100663296 Dec 17 09:56
/var/lib/mysql/ib_logfile101
61982 16 -rw-rw---- 1 mysql mysql 16384 Dec 17 09:56
/var/lib/mysql/aria_log.00000001
uname -a reports:
Linux nas-1 5.10.0-26-marvell #1 Debian 5.10.197-1 (2023-09-29)
armv5tel GNU/Linux
On Sun, Dec 17, 2023 at 11:48:16PM +0800, Otto Kekäläinen wrote:
</pre>
<blockquote>
<pre class="moz-quote-pre">Hi Scott and Kr!
Did you note this line?
2023-12-14 14:51:33 0 [Note] InnoDB: Header page consists of zero
bytes in
datafile: ./ibdata1, Space ID:0, Flags: 0
Can you include the output of `find /var/lib/mysql -ls` so we can
see what
files your system has?
What is the hardware you have? The report shows 'Linux
5.10.0-26-marvell '.
What does `uname -a` yield?
The test suite passes on armhf at
e.g. <a class="moz-txt-link-freetext"
href="https://launchpad.net/~mysql-ubuntu/"
target="_blank" moz-do-not-send="true">https://launchpad.net/~mysql-ubuntu/</a>
+archive/ubuntu/mariadb-10.11/+builds?build_text=&build_state=all.
At https://
ci.debian.net/packages/m/mariadb/unstable/armel/ it fails due to
regression in
subselect which is unrelated to what you reported.
</pre>
</blockquote>
<pre class="moz-quote-pre">--
Scott Barker
--
To unsubscribe, send mail to <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:1058706-unsubscribe@bugs.debian.org"
onclick="" target="_blank" moz-do-not-send="true">1058706-unsubscribe@bugs.debian.org</a>.
</pre>
</blockquote>
<pre class="moz-quote-pre"> </pre>
</blockquote>
<pre class="moz-quote-pre"> </pre>
</blockquote>
<pre class="moz-signature"> </pre>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>