Console View

Categories: connectors experimental galera main

Legend:

Passed

Failed

Warnings

Failed Again

Running

Exception

Offline

No data

connectors

experimental

galera

main

ffea2a7bc9a0...

ffea2a7bc9a0f4ef41981cc555c832abcf28381b

Alexander Barkov

bar@mariadb.com

MDEV-34981 Functions missing from INFORMATION_SCHEMA.SQL_FUNCTIONS

Plugin functions are now displayed in I_S.SQL_FUNCTIONS

kvm-debug-asan-ubsan: test nm F:alter_copy_race - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.4.err.3 mysqld.3.err.4 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.3 mysqld.4.err.1 mysqld.3.err.3 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
winx64-packages: test nm F:innodb_bug59641 - stdio mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.2.err.3 warnings (1)

fd427cb41651...

fd427cb41651265d58abeba1e3aac09ac93a1bb3

Alexander Barkov

bar@mariadb.com

MDEV-31366 Assertion `thd->start_time' failed in bool LOGGER::slow_log_print(THD*, const char*, size_t, ulonglong)

Fixing a wrong DBUG_ASSERT.

thd->start_time and thd->start_time_sec_part cannot be 0 at the same time.

But thd->start_time can be 0 when thd->start_time_sec_part is not 0,
e.g. after:

SET timestamp=0.99;

kvm-fulltest2: test nm F:sql_sequence.r... W:sql_sequence.r... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.1.err.3 mysqld.3.err.3 warnings (2)

fbfa49ebcfcb...

fbfa49ebcfcbea1b35cf19aaacef7e841f5bd0e3

Vladislav Vaintroub

vvaintroub@gmail.com

wip

kvm-fulltest2-protocols: test ps F:log_file_size_... W:log_file_size_... - stdio kernel mysqld.1.err.4 mysqld.2.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.1.err.3 mysqld.3.err.3 warnings (3)

fb1344c84e80...

fb1344c84e80918f2a167fb37e8a6bacb6e5624c

Daniel Black

daniel@mariadb.org

std::mem_fun and std::bind2nd are deprecated

mem_fun -> mem_fn is a straight replacement.

bind2nd required and additional argument in
the transition to std::bind

kvm-rpm-fedora37-aarch64-gal: test install failed - stdio kernel
kvm-rpm-fedora39-amd64-gal: test install failed - stdio kernel
kvm-tarbake-jaunty-x86: make dist failed - stdio kernel warnings (6)

f2e4e5915ae5...

f2e4e5915ae5d03b449a621245c38643391ee633

Julius Goryavsky

julius.goryavsky@mariadb.com

MDEV-29775 addendum: correct initialization of wsrep for the wsrep_replicate_myisam_basic test

kvm-bintar-centos6-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-centos6-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-debug-arm64: test nm F:sys_vars.wsrep... - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (1)
kvm-debug-asan-ubsan: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.2 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
kvm-fulltest: test view F:user_var - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.1 warnings (1)
kvm-fulltest2: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)
kvm-fulltest2-protocols: test ps F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)

e8dd86834ff2...

e8dd86834ff2bd232fd2d32f8a9efd0a94903f1f

Andrei Elkin

andrei.elkin@pp.inet.fi

rpl_gtid_strict asserted about lack of stmt rollback in errored-out binlog_commit..

.. of the general case N-statement.

The fixes makes sure ha_rollback_trans() is invoked sim to the
T-statement.

kvm-debug-ppc64le: test nm F:rpl_gtid_strict W:rpl_gtid_strict W:rpl_gtid_strict - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (3)

e56a64514920...

e56a645149208d004786e14a5c7ca6a77f16ea87

Vladislav Vaintroub

vvaintroub@gmail.com

WIP

kvm-rpm-centos74-amd64: test nm F:GCF-360 F:galera_3nodes.... W:GCF-360 W:galera_3nodes.... W:galera_3nodes.... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (4)
winx64-debug: test nm F:log_file_size_... W:log_file_size_... - stdio mysqld.1.err.3 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.2 mysqld.2.err.1 mysqld.2.err.4 warnings (2)

dc7ab9426589...

dc7ab942658993f7f1a82f8b97313e0479d034b4

Marko Mäkelä

marko.makela@mariadb.com

fixup! 37b2652a325a1f44195d6a632a83b6cba1ea3e0c

Adjust for 47619ea78fe8482d88ce474aa627a11b9be9d737

d9b5ef3b12f9...

d9b5ef3b12f9ef0cd028acb07ca125c5c77395a8

Vladislav Vaintroub

vvaintroub@gmail.com

wip

kvm-deb-focal-amd64: test nm - stdio kernel syslog mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (1)

d53c46d35fe5...

d53c46d35fe5c8683c30056d262770b990fa6b30

Alexander Barkov

bar@mariadb.com

MDEV-34922 Assertion `value.length() == FbtImpl::binary_length()' failed in Type_handler_fbt<FbtImpl, TypeCollectionImpl>::Field_fbt::store_native, Assertion `item->null_value' failed in Type_handler::Item_send_str

This patch is a workaround to avoid crashes on DBUG_ASSERT.
The core problem is reported in:

MDEV-35238 Wrong results from a MyISAM/HEAP/ARIA tables with a single record and an aggregate

which is not trivial to fix.

The code relevant to MDEV-35238 erroneously reads a value of Item_copy_xxx when
there is no a value.
This patch initializes Item_copy_fbt to keep a zero value by default
instead of "no value".

This makes the reported statemenents return a zero UUID instead of the crash.
When MDEV-35238 is fixed, they should return a non-zero generated UUID.

kvm-fulltest2-protocols: test ps F:insert_select-... W:compat/oracle.... W:compat/oracle.... W:compat/oracle.... W:insert_select W:insert_select-... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.1.err.3 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (3)
openssl3-fips-debug: test nm F:debug_key_mana... W:debug_key_mana... - stdio kernel syslog mysqld.3.err.5 mysqld.2.err.5 mysqld.2.err.2 mysqld.3.err.2 mysqld.4.err.2 mysqld.2.err.4 mysqld.1.err.2 mysqld.1.err.4 mysqld.1.err.5 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.6 mysqld.2.err.1 mysqld.3.err.6 mysqld.1.err.6 warnings (2)
winx64-debug: test nm F:log_file_size_... W:log_file_size_... - stdio mysqld.1.err.2 mysqld.1.err.3 mysqld.1.err.1 mysqld.1.err.4 mysqld.2.err.3 mysqld.2.err.2 mysqld.2.err.4 warnings (2)

c336904c0205...

c336904c02054e1377b0d9b690902d7702e964a1

Marko Mäkelä

marko.makela@mariadb.com

squash! 427df2a0c8cf2e66c0d900414cee52e602b9b8ca

Do not enable page_cur_search_with_match_bytes() for the change buffer.
Let us see if this avoids some corruption.

c30ca9e7f77f...

c30ca9e7f77fd9a733c844e997201fc010fcf2e4

Alexander Barkov

bar@mariadb.com

MDEV-34981 Functions missing from INFORMATION_SCHEMA.SQL_FUNCTIONS

Plugin functions are now displayed in I_S.SQL_FUNCTIONS

fulltest-debug-big-only: update failed - stdio
kvm-rpm-centos74-amd64: test nm F:galera_3nodes.... - stdio kernel mysqld.3.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 warnings (1)

c065bdda338a...

c065bdda338a5695f206f333f5299f38ba4a349f

Jan Lindström

jan.lindstrom@galeracluster.com

MDEV-29775 : Assertion `0' failed in void Protocol::end_statement() when adding data to the MyISAM table after setting wsrep_mode=replicate_myisam

Firstly, variables wsrep_forced_binlog_format, wsrep_replicate_myisam
should not be able to set if wsrep_on=OFF.

Secondly, if wsrep_replicate_myisam=ON we allow wsrep_forced_binlog_format
to be [DEFAULT|ROW].

Signed-off-by: Julius Goryavsky <[email protected]>

kvm-bintar-centos6-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-centos6-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-debug-arm64: test nm F:sys_vars.wsrep... - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (1)
kvm-debug-asan-ubsan: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.2 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
kvm-fulltest: test view F:user_var - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.1 warnings (1)
kvm-fulltest2: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)
kvm-fulltest2-protocols: test ps F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)

bcbeef677227...

bcbeef677227995f329b251dbaf8d0cc40e07e79

Vlad Lesin

vlad_lesin@mail.ru

MDEV-35457 Remove btr_cur_t::path_arr

After MDEV-21136 fix, the btr_cur_t::path_arr field stayed declared, but
not used, wasting space in each btr_cur_t and btr_pcur_t. Remove it.

kvm-deb-focal-amd64: test nm F:MDEV-33997 - stdio kernel syslog mysqld.3.err.1 mysqld.4.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 warnings (1)
kvm-rpm-centos74-amd64: test nm F:MDEV-33997 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (1)
kvm-rpm-rocky8-aarch64: test nm - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (1)
kvm-zyp-opensuse155-amd64: test nm F:MDEV-33997 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 warnings (1)

ae11b0ce869c...

ae11b0ce869c7fc35bac808b5fcc8e04821c2d43

Vladislav Vaintroub

vvaintroub@gmail.com

WIP

kvm-deb-focal-amd64: test nm F:mariadb_port_f... - stdio kernel syslog mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.1 mysqld.1.err.1 warnings (1)
kvm-debug-asan-ubsan: test nm F:rpl_xa_empty_t... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.3.err.4 mysqld.2.err.3 mysqld.4.err.3 mysqld.1.err.3 mysqld.3.err.3 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
openssl3-fips-debug: test nm F:innodb-encrypt... W:innodb-encrypt... - stdio kernel syslog mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.5 mysqld.4.err.5 mysqld.2.err.5 mysqld.2.err.4 mysqld.1.err.4 mysqld.1.err.5 mysqld.1.err.1 mysqld.3.err.1 mysqld.2.err.1 mysqld.2.err.3 mysqld.1.err.3 mysqld.2.err.6 mysqld.3.err.6 mysqld.1.err.6 warnings (2)

a9492f6f857c...

a9492f6f857cd48c19c4c729b83771998663c2e1

Alexander Barkov

bar@mariadb.com

MDEV-33472 Assertion `0' failed in Item_row::illegal_method_call on CREATE EVENT

Do not accept rows as event parameters.

a45c2e289d7b...

a45c2e289d7b40bcfbf92444b8402d2742b3cd03

Alexander Barkov

bar@mariadb.com

kvm-debug-arm64: test nm F:sql_sequence.r... W:sql_sequence.r... - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (2)

a3df51503861...

a3df51503861dd0fcfd0cb06a6f549dcc6ef9df5

Alexander Barkov

bar@mariadb.com

MDEV-31881 ASAN: unknown-crash in check_ulonglong (sql/sql_analyse.cc) on SELECT ... FROM ... PROCEDURE ANALYSE()

Fixing a wrong condition which made the code read 1 byte behind the buffer.

winx64-debug: test nm F:ctype_upgrade W:bootstrap_innodb W:cache_innodb W:check_constrai... W:column_compres... W:commit - stdio mysqld.1.err.3 mysqld.1.err.4 mysqld.1.err.2 mysqld.1.err.1 mysqld.2.err.1 mysqld.2.err.2 warnings (2)

93fb364cd926...

93fb364cd92679e5e7016e642e1afefbf3038d1b

Monty

monty@mariadb.org

Removed not used ha_drop_table()

This was done after changing call in sql_select.cc from
ha_drop_table() to drop_table(), like in 11.5

kvm-fulltest2-protocols: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.2.err.1 mysqld.2.err.3 mysqld.1.err.3 warnings (1)
kvm-zyp-sles15-amd64: test nm W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... - stdio kernel mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)

866b76d54f3b...

866b76d54f3b07a4e02464019b11f9a18e7faa03

Vladislav Vaintroub

vvaintroub@gmail.com

WIP

kvm-rpm-centos74-amd64: test nm F:GCF-360 F:galera_3nodes.... W:GCF-360 W:galera_3nodes.... W:galera_3nodes.... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (4)
winx64-debug: test nm F:log_file_size_... W:log_file_size_... - stdio mysqld.1.err.3 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.2 mysqld.2.err.1 mysqld.2.err.4 warnings (2)

8352c1d9e95c...

8352c1d9e95c203c319272acf1956a5782b35966

Julius Goryavsky

julius.goryavsky@mariadb.com

MDEV-29755 correction: running wsrep_replicate_myisam_basic test with wsrep enabled

kvm-deb-focal-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel syslog mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-centos74-amd64: test nm F:galera_bf_abor... F:galera_wsrep_m... F:mdev-29775 W:galera_bf_abor... W:galera_bf_abor... W:galera_bf_abor... W:galera_binlog_... W:galera_binlog_... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-rocky9-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (3)

76b5c6a7a7e9...

76b5c6a7a7e9fb6507f18534c374fb738ea25343

Marko Mäkelä

marko.makela@mariadb.com

fixup! dc7ab942658993f7f1a82f8b97313e0479d034b4

6f921c9e3b14...

6f921c9e3b14c0b9b2d239e3e684edafca5d1ead

Oleg Smirnov

olernov@gmail.com

MDEV-34888 Implement SEMIJOIN() and SUBQUERY() hints

kvm-bintar-centos74-amd64: test F:optimize_table F:table_stats F:table_stats - stdio kernel warnings (1)
kvm-debug-arm64: test nm F:mysqld--help F:mysqltest_trac... F:opt_hints_subq... F:opt_trace F:optimizer_switch - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.3.err.1 mysqld.2.err.1 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.2.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (1)
kvm-fulltest2: test emb F:opt_hints_subq... F:optimizer_switch F:sys_vars.optim... F:sys_vars.sysva... - stdio kernel mysqld.1.err.4 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.3 warnings (1)
kvm-fulltest2-protocols: test ps-embedded F:opt_hints_subq... F:optimizer_switch F:sys_vars.optim... F:sys_vars.sysva... - stdio kernel mysqld.1.err.4 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.3 warnings (1)
kvm-rpm-centos74-amd64: test nm F:table_stats F:table_stats - stdio kernel mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.4 mysqld.2.err.1 mysqld.1.err.2 mysqld.1.err.1 warnings (1)
kvm-rpm-rocky9-amd64: test nm F:table_stats F:table_stats - stdio kernel mysqld.2.err.1 mysqld.1.err.2 mysqld.1.err.1 mysqld.2.err.4 mysqld.1.err.4 mysqld.1.err.3 warnings (1)
winx64-debug: test nm F:mysqld--help F:mysqltest_trac... F:opt_hints_subq... F:opt_trace F:optimizer_switch - stdio mysqld.1.err.2 mysqld.1.err.4 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.3 mysqld.2.err.2 mysqld.2.err.4
winx64-packages: test nm F:mysqld--help F:mysqltest_trac... F:opt_hints_subq... F:opt_trace F:optimizer_switch - stdio mysqld.1.err.1 mysqld.1.err.2 mysqld.2.err.4 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.2

69be363daa87...

69be363daa8777071fa6a360af517ee8f2a7d26d

Monty

monty@mariadb.org

Fixed that internal temporary Aria tables are not flushed to disk

This bug was caused by
MDEV-17070 Table corruption or Assertion `table->file->stats.records > 0

kvm-fulltest2-protocols: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.2.err.1 mysqld.2.err.3 mysqld.1.err.3 warnings (1)
kvm-zyp-sles15-amd64: test nm W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... - stdio kernel mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)

69424c6be590...

69424c6be59085d65c55f84f62a5545c5e53e7b2

Jan Lindström

jan.lindstrom@galeracluster.com

MDEV-27861: Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict_ddl=ON

Problem was incorrect handling of partitioned tables,
because db_type == DB_TYPE_PARTITION_DB
wsrep_should_replicate_ddl incorrectly marked
DDL as not replicatable. However, in partitioned
tables we should check implementing storage engine
from table->file->partition_ht() if available because
if partition handler is InnoDB all DDL should be allowed
even with wsrep_strict_ddl. For other storage engines
DDL should not be allowed and error should be issued.

This is 10.5 version of the fix.

Signed-off-by: Julius Goryavsky <[email protected]>

kvm-bintar-centos6-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-centos6-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-amd64: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-bintar-trusty-x86: test F:sys_vars.wsrep... - stdio kernel warnings (1)
kvm-debug-arm64: test nm F:sys_vars.wsrep... - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 warnings (1)
kvm-debug-asan-ubsan: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.2 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
kvm-fulltest: test view F:user_var - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.1 warnings (1)
kvm-fulltest2: test nm F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)
kvm-fulltest2-protocols: test ps F:sys_vars.wsrep... - stdio kernel mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 mysqld.1.err.3 warnings (1)

663d185a9bae...

663d185a9bae35590d999f3ec3e4e6587546c9d3

Alexander Barkov

bar@mariadb.com

MDEV-34090 Client allows to set character set to utf32 and crashes on the next command

Disallowing character sets with mbminlen>1 in the client.

kvm-fulltest2-protocols: test ps F:sql_sequence.r... W:sql_sequence.r... - stdio kernel mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.1.err.2 mysqld.2.err.4 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.3 mysqld.3.err.1 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (2)

611db0cbb8ba...

611db0cbb8ba966203a9baddb7fa7ccaf0086973

Marko Mäkelä

marko.makela@mariadb.com

fixup! 37b2652a325a1f44195d6a632a83b6cba1ea3e0c

5f24a3f76ac1...

5f24a3f76ac11be8278bfa863e4ebafb86581888

Julius Goryavsky

julius.goryavsky@mariadb.com

MDEV-26516: WSREP: Record locking is disabled in this thread, but the table being modified

We periodically observe assertion failures in the mtr tests,
specifically in the /storage/innobase/row/row0ins.cc file,
following a WSREP error. The error message is: 'WSREP: record
locking is disabled in this thread, but the table being modified
is not mysql/wsrep_streaming_log: mysql/innodb_table_stats.'"
This issue seems to occur because, upon opening the table,
innodb_stats_auto_recalc may trigger, which Galera does not
anticipate. This commit should fix this bug.

fulltest-debug-big-only: build failed - stdio warnings (13)
kvm-bintar-centos6-amd64: make bintar failed - stdio kernel warnings (67)
kvm-bintar-centos6-x86: make bintar failed - stdio kernel warnings (9)
kvm-bintar-trusty-amd64: make bintar failed - stdio kernel warnings (60)
kvm-bintar-trusty-x86: make bintar failed - stdio kernel warnings (2)
kvm-deb-focal-amd64: make debs failed - stdio kernel warnings (49505)
kvm-debug-arm64: build failed - stdio kernel
kvm-debug-asan-ubsan: build failed - stdio kernel
kvm-fulltest: build failed - stdio kernel
kvm-fulltest2: build failed - stdio kernel warnings (2)
kvm-rpm-centos74-amd64: make rpms failed - stdio kernel
kvm-rpm-rocky9-amd64: make rpms failed - stdio kernel

5855554eb45b...

5855554eb45b32d0e2d8d2f30967ec4d469bdd5b

Alexander Barkov

bar@mariadb.com

MDEV-21029 Incorrect result for expression with the <=> operator and IS NULL

Item_func_equal erroneously derived is_null() from the parent class.
Overriding it to return false because <=> can never return NULL.

kvm-deb-focal-amd64: upgrade from MariaDB failed - stdio kernel syslog
kvm-debug-asan-ubsan: test nm F:sys_vars.innod... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.4 mysqld.2.err.4 mysqld.1.err.3 mysqld.1.err.1 mysqld.4.err.1 mysqld.3.err.3 mysqld.2.err.1 mysqld.3.err.1 warnings (1)
kvm-fulltest: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.1.err.2 mysqld.2.err.3 mysqld.2.err.4 mysqld.1.err.3 mysqld.1.err.1 mysqld.2.err.1 warnings (1)
kvm-fulltest2-protocols: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.1.err.1 mysqld.1.err.2 mysqld.2.err.1 mysqld.2.err.2 mysqld.2.err.3 mysqld.1.err.3 warnings (1)
kvm-rpm-centos74-amd64: test nm F:MDEV-29142 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 warnings (1)

49b5c2f1a631...

49b5c2f1a631bb8a30f7b632c781fdc4e55b967a

Daniel Black

daniel@mariadb.org

Merge pull request #30 from grooverdan/deprecated_gcc

std::mem_fun and std::bind2nd are deprecated

kvm-rpm-fedora37-aarch64-gal: test install failed - stdio kernel
kvm-rpm-fedora39-amd64-gal: test install failed - stdio kernel
kvm-tarbake-jaunty-x86: make dist failed - stdio kernel warnings (6)

3fde097950f8...

3fde097950f85b0488b032c3c35539088a641fdb

Marko Mäkelä

marko.makela@mariadb.com

MDEV-35049: Avoid building AHI on non-unique columns

During a workload, an adaptive hash index had been built on
UNIQUE INDEX(ID) on SYS_TABLES, and during a DROP TABLE
operation the adaptive hash index would be widened to cover
2 fields (ID,NAME). Such an adaptive hash index is unlikely
to satisfy (m)any queries. Let us limit the AHI to the unique
fields also in secondary indexes.

3daa257494cd...

3daa257494cd186791b3ba3599966bffc77606d8

Jan Lindström

jan.lindstrom@galeracluster.com

MDEV-27861: Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict_ddl=ON

Problem was incorrect handling of partitioned tables,
because db_type == DB_TYPE_PARTITION_DB
wsrep_should_replicate_ddl incorrectly marked
DDL as not replicatable. However, in partitioned
tables we should check implementing storage engine
from table->file->partition_ht() if available because
if partition handler is InnoDB all DDL should be allowed
even with wsrep_strict_ddl. For other storage engines
DDL should not be allowed and error should be issued.

This is 10.6 version of the fix.

Signed-off-by: Julius Goryavsky <[email protected]>

kvm-deb-focal-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel syslog mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-centos74-amd64: test nm F:galera_bf_abor... F:galera_wsrep_m... F:mdev-29775 W:galera_bf_abor... W:galera_bf_abor... W:galera_bf_abor... W:galera_binlog_... W:galera_binlog_... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-rocky9-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (3)

34b79adfc57c...

34b79adfc57c181ee9699a39ae7ba11c32f93cf0

Vladislav Vaintroub

vvaintroub@gmail.com

wip

kvm-rpm-centos74-amd64: test nm F:GCF-360 F:galera_3nodes.... W:GCF-360 W:galera_3nodes.... W:galera_3nodes.... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (4)
winx64-debug: test nm F:log_file_size_... W:log_file_size_... - stdio mysqld.1.err.3 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.2 mysqld.2.err.1 mysqld.2.err.4 warnings (2)

32962ea2532e...

32962ea2532ee78bc99d8da950348ba01d38a23b

Monty

monty@mariadb.org

Do not read aria bitmap page for internal temporary tables

Instead create the bitmap page from scratch

kvm-fulltest2-protocols: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.2.err.1 mysqld.2.err.3 mysqld.1.err.3 warnings (1)
kvm-zyp-sles15-amd64: test nm W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... - stdio kernel mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)

31c53596ccbd...

31c53596ccbd04d15889fe3839bdbd42aadf942f

Yuchen Pei

ycp@mariadb.com

MDEV-35452 Disable view protocol for four spider tests

About half (i.e. ~110) spider tests fail mtr --view-protocol. The plan
is to disable view protocol for these tests, fix them, then enable
them.

Adding the disable/enable lines to all these tests requires a bit of
scripting. Therefore, we first fix 4 tests known to the mandatory
builder amd64-last-N-failed to unblock pushes.

27555ed21b46...

27555ed21b46bf6c1a596d7e9db7e17f17162d46

Jan Lindström

jan.lindstrom@galeracluster.com

MDEV-29775 : Assertion `0' failed in void Protocol::end_statement() when adding data to the MyISAM table after setting wsrep_mode=replicate_myisam

Firstly, variables wsrep_mode, wsrep_forced_binlog_format, wsrep_replicate_myisam
should not be able to set if wsrep_on=OFF.

Secondly, if wsrep_mode=BINLOG_ROW_FORMAT_ONLY wsrep_forced_binlog_format
can be DEFAULT (UNSPECIFIED) or ROW.

Finally, if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] or
wsrep_replicate_myisam=ON we allow wsrep_forced_binlog_format
to be [DEFAULT|ROW].

Signed-off-by: Julius Goryavsky <[email protected]>

kvm-deb-focal-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel syslog mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-centos74-amd64: test nm F:galera_bf_abor... F:galera_wsrep_m... F:mdev-29775 W:galera_bf_abor... W:galera_bf_abor... W:galera_bf_abor... W:galera_binlog_... W:galera_binlog_... - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)
kvm-rpm-rocky9-amd64: test nm F:galera_wsrep_m... F:mdev-29775 W:GAL-382 W:GAL-401 W:MDEV-21479 W:MDEV-22051 W:MDEV-22421 - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (3)

14dc813f7ce1...

14dc813f7ce172b271b14ac11bf73194b3b4dce7

Rex

rex.johnston@mariadb.com

MDEV-32294 2nd execution problem with inconsistent outer context paths

WORK IN PROGRESS

context {select_lex, outer_context} elements made private, accessor
function will now skip merged selects.

When calculating the Item_subselect::used_tables_cache the current code
relies on upper_refs, this is populated by Item_subselect::mark_as_dependent()
which gets called during fix_fields on a Field/Reference that is an
outer reference.
This list contains an item contained within the Item_subselect somewhere
and a select_lex where that item is resolved.
For each item in this list, Item_subselect::update_used_tables() searches
outwards until it encounters 'new_parent'. If it does encounter this
select_lex, then the tables used in this item are records as being used
in this Item_subselect. If it doesn't encounter this select_lex, then
it sets OUTER_BIT_TABLE_REF indicating that the somewhere within lies
and item resolved above our new parent.

This new code code turns this upside down by directly referencing items
resolved in a SELECT_LEX, in that SELECT_LEX. Later, when recalculating
Item_subselect::used_tables_cache, rather than looking though all items
below that might be resolved within the SELECT_LEX of interest
(new_parent), we can iterate through the items resolved in 'new_parent'
and decide if they are relevant to our Item_subquery. We do this by
starting in the select_lex where the item is defined, walking outwards
on outer_select() and seeing if the master_unit() is the same as
Item_subselect::unit. If it is, this item 'belongs' to our
Item_subselect.

Changes:

We add SELECT_LEX::resolved_here List<Item>
Item because we can gather Item_field or Item_direct_view_ref
We add to this list on statement memory only during prepare or first execution.

When looking at items in 'new_parent' we can determine where this item is
used in this Item_subselect by walking outwards from where the item is
defined up to 'new_parent' looking to see if the enclosing unit is the
unit attached to out Item_subselect.
If we have a match then we know that we add the bit
field_item->field->table->map into our bitmap (used_tables_cache).

Test to see if this Item belongs to our unit implemented in
Item_belongs_to()

When we merge 2 queries together (either a derived table merge or a
subquery to semijoin merge), we need to manage the resolved_here list
for both SELECT_LEXs.
The SELECT_LEX that is uppermost must have it's resolved_here list
pruned of items that are belong to the SELECT_LEX to be merged. These
pruned items will no longer be outer references.

0ff88f046f19...

0ff88f046f199ed0eb90148b390ecf76696f27f0

Alexander Barkov

bar@mariadb.com

0de9e40f4b16...

0de9e40f4b167dfb1d600b362f8cf469e992cec7

Monty

monty@mariadb.org

Added status variable "stack_usable" to be able to check stack usage

kvm-fulltest2-protocols: test view F:stack - stdio kernel mysqld.1.err.4 mysqld.2.err.4 mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.1 mysqld.2.err.1 mysqld.2.err.3 mysqld.1.err.3 warnings (1)
kvm-zyp-sles15-amd64: test nm W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... W:galera_sr.GCF-... - stdio kernel mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 warnings (3)