Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#48098 - [mariadb] 10.1.11-1-i686 package is incorrectly configured

Attached to Project: Arch Linux
Opened by Pavel (psp) - Monday, 08 February 2016, 17:01 GMT
Last edited by Doug Newgard (Scimmia) - Tuesday, 09 February 2016, 13:42 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To No-one
Architecture i686
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
mariadb-10.1.11-1-i686 package is incorrectly configured and/or packaged.

Immediately after install, it is supposed to create tables, mariadb schemes and root user using mysql_install_db script.

mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Described in wiki as well: https://wiki.archlinux.org/index.php/MySQL

The script fails with error.
Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
2016-02-08 17:44:11 b6f4df40 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
ERROR: 1136 Column count doesn't match value count at row 1
2016-02-08 17:44:11 3069691712 [ERROR] Aborting

Additional info:

* package version(s) mariadb-10.1.11-1 i686


Steps to reproduce:

On i686 AMD architecture

pacman -S mariadb
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

I put severity critical because it totally prevents any use of mariadb even if the package is installed.
This task depends upon

Closed by  Doug Newgard (Scimmia)
Tuesday, 09 February 2016, 13:42 GMT
Reason for closing:  Not a bug
Comment by Doug Newgard (Scimmia) - Tuesday, 09 February 2016, 03:40 GMT
Do you have an existing database at /var/lib/mysql?

"I put severity critical because it totally prevents any use of mariadb even if the package is installed."

That does not make it critical.
Comment by Pavel (psp) - Tuesday, 09 February 2016, 07:13 GMT
You are right, this was supposedly a fresh install on this server, but I found some remnants in /var/lib/mysql. Last April I already installed mariadb, did what was needed and finished. When the package is not needed I remove it so I ran pacman -Rns and mariadb was cleanly unistalled. But I forgot about MY user files. I was so dumbfounded by this error (installed mysql/maria without any problems several times) that it never occurred to me to look into data directory. Removed all of it. Script finished okay. Requesting closure.

Loading...