[debian-mysql] Bug#924498: mariadb-server-10.3: Indexes problem with replicatetd Data

[nte]

Subject: mariadb-server-10.3: Indexes problem with replicatetd Data
Package: mariadb-server-10.3
Version: 1:10.3.13-1
Severity: important

Dear Maintainer,

I tested importing dump on MariaDB + Galera (2 nodes Master-Master) as 
follow :

  * Create a db
  * import dump sql (table in INNODB) on Node 1

When I check some index cardinalities, I have on node 1 the right value 
and on node 2 null value (0) e.g :

Node 1 : index on column username (varchar 255 utf-8) : cardinality =38250
Node 2 : index username : cardinality = 0

Indexes are not updated on node 2 and SQL queries on MariaDB Node 2 are 
too slow !

I tested different versions :

MariaDB 10.1.37 (Debian Stretch version) : cardinality is OK : no 
problem (but not same cardinality ...) !
MariaDB 10.2.22 (Debian MariaDB repository) : cardinality is NOT ok : 
problem
MariaDB 10.3.12 (Debian MariaDB repository) : cardinality is NOT ok : 
problem

I run OPTIMIZE Table on Node 2 for build indexes and then indexes are 
managed on Node 2. Strange things too : the cardinalities are always 
differentes on the 2 nodes ...

Hope, you will be able to take a look ...




-- System Information:
Debian Release: buster/sid
   APT prefers testing
   APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.15.18-11-pve (SMP w/24 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), 
LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.3 depends on:
ii  adduser                   3.118
ii  debconf [debconf-2.0]     1.5.71
ii  galera-3                  25.3.25-1
ii  gawk                      1:4.2.1+dfsg-1
ii  iproute2                  4.20.0-2
ii  libc6                     2.28-8
ii  libdbi-perl               1.642-1+b1
ii  libgnutls30               3.6.6-2
ii  libpam0g                  1.3.1-5
ii  libstdc++6                8.3.0-2
ii  lsb-base                  10.2018112800
ii  lsof                      4.91+dfsg-1
ii  mariadb-client-10.3       1:10.3.13-1
ii  mariadb-common            1:10.3.13-1
ii  mariadb-server-core-10.3  1:10.3.13-1
ii  passwd                    1:4.5-1.1
ii  perl                      5.28.1-4
ii  psmisc                    23.2-1
ii  rsync                     3.1.3-5
ii  socat                     1.7.3.2-2
ii  zlib1g                    1:1.2.11.dfsg-1

Versions of packages mariadb-server-10.3 recommends:
ii  libhtml-template-perl  2.97-1

Versions of packages mariadb-server-10.3 suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20180807cvs-1
pn  mariadb-test       <none>
pn  netcat-openbsd     <none>
pn  tinyca             <none>

-- Configuration Files:
/etc/mysql/debian-start changed:
source /usr/share/mysql/debian-start.inc.sh
if [ -f /etc/default/mysql ]; then
   . /etc/default/mysql
fi
MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mysql_upgrade 
--defaults-extra-file=/etc/mysql/debian.cnf --version-check"
MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="${MYCHECK_RCPT:-root}"
trap "" SIGHUP
(
   upgrade_system_tables_if_necessary;
   check_root_accounts;
   check_for_crashed_tables;
) >&2 &
exit 0

/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf [Errno 2] Datei oder 
Verzeichnis nicht gefunden: '/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf'
/etc/mysql/mariadb.conf.d/50-server.cnf [Errno 2] Datei oder Verzeichnis 
nicht gefunden: '/etc/mysql/mariadb.conf.d/50-server.cnf'

-- debconf information:
   mariadb-server-10.3/postrm_remove_databases: false
   mariadb-server-10.3/nis_warning:
   mariadb-server-10.3/old_data_directory_saved:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20190313/d2f6a2bd/attachment.html>