maria-developers team mailing list archive

[Otto Kekäläinen <otto@xxxxxxxxxxx>]

Hello!

I reported here about the test failure status in early April and here
is a follow-up.

My old emails can be found here:
https://lists.launchpad.net/maria-developers/msg11171.html
https://lists.launchpad.net/maria-developers/msg11170.html

If one looks at the picture from April and compares to the status
today, the situation is a bit sad as we have even less green than
before:
https://lists.launchpad.net/maria-developers/pngcpxTB4wjTW.png



Current issues we have in addition to the usual mtr test failures are:

- On multiple bionic builds the upgrade fails to run with no apparent
reason. The builder script does not seem to find any previous
installation of anything, so that probably is missing from the images:

+ dpkg -l
+ grep -iE 'maria|mysql|galera'
+ true

Thus the build fails. Example log:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-bionic-amd64/bui
lds/196/steps/upgrade2/logs/stdio


- On bionic and xenial aarch64 mysqld fails to start. In syslog we can
see

May 28 16:11:25 ubuntu-xenial-aarch64 mysqld: 2018-05-28 16:11:25 0
[ERROR] Incorrect definition of table mysql.event: expected column
'sql_mode' at position 14 to have type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGN
ORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','
NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_O
PTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANS
I','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES'
,'STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','
ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_N
OT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPT
Y_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGN
ORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','
NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_O
PTIONS','NO_TABLE_OPTIONS','NO
May 28 16:11:25 ubuntu-xenial-aarch64 mysqld:
_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
May 28 16:11:25 ubuntu-xenial-aarch64 mysqld: 2018-05-28 16:11:25 0
[ERROR] mysqld: Event Scheduler: An error occurred when initializing
system tables. Disabling the Event Scheduler.
May 28 16:11:25 ubuntu-xenial-aarch64 mysqld: 2018-05-28 16:11:25 6
[ERROR] InnoDB: Column last_update in table
`mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be
BINARY(4) NOT NULL (type mismatch).
May 28 16:11:25 ubuntu-xenial-aarch64 mysqld: 2018-05-28 16:11:25 6
[ERROR] InnoDB: 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.

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-aarch64/b
uilds/277/steps/upgrade1/logs/syslog


- stretch amd64 fails to compile due to

librocksdblib.a(compaction_job.cc.o): In function
`rocksdb::ZSTD_TrainDictionary(std::__cxx11::basic_string<char,
std::char_traits<char>, std::allocator<char> > const&,
std::vector<unsigned long, std::allocator<unsigned long> > const&,
unsigned long)':
./builddir/storage/rocksdb/./storage/rocksdb/rocksdb/util/compression.h
:812: undefined reference to `ZDICT_trainFromBuffer'
./builddir/storage/rocksdb/./storage/rocksdb/rocksdb/util/compression.h
:813: undefined reference to `ZDICT_isError'
collect2: error: ld returned 1 exit status

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-amd64/bu
ilds/3986/steps/compile/logs/stdio


- jessie amd64 builds to compile due to

/usr/bin/ld.bfd.real: /tmp/ccOIwjFo.ltrans0.ltrans.o: relocation
R_X86_64_PC32 against symbol `toku_product_name_strings' can not be
used when making a shared object; recompile with -fPIC
/usr/bin/ld.bfd.real: final link failed: Bad value
collect2: error: ld returned 1 exit status

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/bui
lds/4298/steps/compile/logs/stdio


This -fPIC issue might be related to a change in hardening flags I
"forward-ported" from Debian and I will look into it. All the other
issues are things I cannot do anything about.. :(


On the bright side I can report that there are at least no build
regressions on Launchpad with current 10.3:
https://launchpad.net/~mysql-ubuntu/+archive/ubuntu/mariadb-10.3/+build
s?build_text=&build_state=all


- Otto

Attachment: buildbot 10.3 branch 2018-06-01 14-47-40.png
Description: PNG image