Hello,
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?
But you can debug this (I ate my dogfood and tested not just write from
the memory sorry for that)
shutdown mariadbd (which is not probably not running)
remove /var/lib/mysql which again will destroy your database (Please note)
use to install your database:
/usr/bin/mariadb-install-db --rpm --cross-bootstrap --user=mysql
Does it print some errors? Is there any errors in syslog? Does MariaDB
start after this?
Sincerely,
Tuukka
k-...@web.de kirjoitti 19.12.2023 klo 16.33:
Removing mariadb-server via apt purge also removes the user mysql.
--> chown mysql:mylsql doesn't work.
Reinstalling mariadb-server doesn't solve the issue.
*Gesendet:* Dienstag, 19. Dezember 2023 um 13:01 Uhr
*Von:* "Tuukka Pasanen" <tuukka.pasa...@ilmi.fi>
*An:* k-...@web.de
*Cc:* "Scott Barker" <sc...@mostlylinux.ca>, 1058...@bugs.debian.org,
"Otto Kekäläinen" <o...@debian.org>, "Faustin Lammler"
<faus...@mariadb.org>
*Betreff:* Re: Aw: Re: Bug#1058706: mariadb-server-core: mariadbd
fails to start on fresh install on armel
Hello,
I've investigate this yesterday and I could reproduce this one:
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
k-...@web.de kirjoitti 19.12.2023 klo 12.18:
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"<tuukka.pasa...@ilmi.fi>
An: "Scott Barker"<sc...@mostlylinux.ca>,1058...@bugs.debian.org, "Otto
Kekäläinen"<o...@debian.org>,k-...@web.de
Cc: "Faustin Lammler"<faus...@mariadb.org>
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:
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:
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:
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.https://launchpad.net/~mysql-ubuntu/
+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.
--
Scott Barker
--
To unsubscribe, send mail to1058706-unsubscr...@bugs.debian.org.
