Console View

Categories: connectors experimental galera main

Legend:

Passed

Failed

Warnings

Failed Again

Running

Exception

Offline

No data

connectors

experimental

galera

main

e2bba8e49853...

e2bba8e498533f9d7041fa1a9ad3b39819a418be

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915 Review Increment

* Code cleanup
* Reverted rpl_parallel_optimistic_error_stop test to old
changes as the non-determinism was fixed by a later commit
* Moved previously general test case from
rpl_stm_par_stop_slave_quick to the _common test file so
the behavior is validated in row format as well
* Added T,N,T,N,T test case to ensure transactions are
executed up to the last N, and not after
* Misc test case improvements

Note the rpl_parallel.test wait_for_done() debug_sync comment
has not yet been addessed

dfe6881498b3...

dfe6881498b3c8a75895c15b1485ab44b3ed004f

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915: STOP SLAVE takes very long time on a busy system

The problem is that a parallel replica would not immediately stop
running/queued transactions when issued STOP SLAVE. That is, it
allowed the current group of transactions to run, and sometimes the
transactions which belong to the next group could be started and run
through commit after STOP SLAVE was issued too, if the last group
had started committing. This would lead to long periods to wait for
all waiting transactions to finish.

This patch updates a parallel replica to try and abort immediately
and roll-back any ongoing transactions. The exception to this is any
transactions which are non-transactional (e.g. those modifying
sequences or non-transactional tables), and any prior transactions,
will be run to completion.

Reviewed By:
============
Andrei Elkin <[email protected]>

dd5d641c9ed1...

dd5d641c9ed182e9090374d8aa0119d539c762df

Sergei Golubchik

serg@mariadb.org

enable ColumnStore only on selected DEB distributions

kvm-asan: test nm F:long_host - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 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-rpm-fedora36-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 warnings (1)
kvm-rpm-rhel9-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.3 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 warnings (1)
winx64-packages: test nm F:innodb-64k-crash F:log_file_size_... - stdio mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.4 mysqld.2.err.1 mysqld.2.err.2 mysqld.2.err.3 warnings (1)

d5e3d37ec29f...

d5e3d37ec29f1fb4eae579972f2ac1641b9b372e

Sergei Golubchik

serg@mariadb.org

more C API methods in the service_sql

for columnstore

kvm-asan: test nm F:long_host - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 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-rpm-fedora36-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 warnings (1)
kvm-rpm-rhel9-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.3 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 warnings (1)
winx64-packages: test nm F:innodb-64k-crash F:log_file_size_... - stdio mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.4 mysqld.2.err.1 mysqld.2.err.2 mysqld.2.err.3 warnings (1)

d18800bf83a3...

d18800bf83a3243961567bfbecebcac7afae2cb1

Sergei Golubchik

serg@mariadb.org

Merge branch 'bb-10.6-release' into bb-10.6-release

kvm-ports-freebsd130-amd64: test nm F:rpl_row_img_se... W:rpl_row_img_se... - stdio kernel syslog mysqld.2.err.1 mysqld.3.err.1 mysqld.4.err.1 mysqld.1.err.1 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 warnings (2)
fulltest-debug-big-only: update failed - stdio
kvm-deb-bullseye-aarch64: test nm F:innodb-checksu... F:innodb-checksu... W:innodb-checksu... W:innodb-checksu... - stdio kernel warnings (2)
kvm-deb-buster-amd64: minor upgrade for columnstore failed - stdio kernel step-script.sh ldd.old ldd.new syslog plugins.old plugins.new columnstore_logs
kvm-rpm-alma84-amd64: test nm F:galera_3nodes.... 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 (3)
kvm-rpm-rhel9-amd64: test nm F:spider/bugfix.... - 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 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (1)
kvm-rpm-rocky9-aarch64: test nm F:spider/bugfix.... - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (1)
kvm-rpm-rocky84-amd64: test nm F:GCF-939 - stdio kernel mysqld.3.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 (1)
winx64-debug: 'dojob git clone --branch bb-10.6-release --depth=100 https://github.com/MariaDB/server src && cd src && git reset --hard d18800bf83a3243961567bfbecebcac7afae2cb1' failed - stdio

cbabb95915d5...

cbabb95915d55ce7004f4b7e103aa1143549d384

Sergei Golubchik

serg@mariadb.org

Merge branch '11.0' into 11.1

kvm-asan: test nm F:long_host - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 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-rpm-fedora36-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 warnings (1)
kvm-rpm-rhel9-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.3 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 warnings (1)
winx64-packages: test nm F:innodb-64k-crash F:log_file_size_... - stdio mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.4 mysqld.2.err.1 mysqld.2.err.2 mysqld.2.err.3 warnings (1)

c93754d45e5d...

c93754d45e5d9379e3e23d7ada1d5f21d2711f66

Marko Mäkelä

marko.makela@mariadb.com

MDEV-31234 related cleanup

trx_purge_free_segment(), trx_purge_truncate_rseg_history():
Replace some unreachable code with debug assertions.
A buffer-fix does prevent pages from being evicted
from the buffer pool; see buf_page_t::can_relocate().

Tested by: Matthias Leich

kvm-ports-freebsd130-amd64: test nm F:rpl_row_img_se... W:rpl_row_img_se... - stdio kernel syslog mysqld.2.err.1 mysqld.3.err.1 mysqld.4.err.1 mysqld.1.err.1 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 warnings (2)
kvm-bld-minimal: build failed - stdio kernel
kvm-bld-nopart-debug: build failed - stdio kernel
kvm-deb-bullseye-aarch64: test nm F:innodb-checksu... F:innodb-checksu... W:innodb-checksu... W:innodb-checksu... - stdio kernel warnings (2)
kvm-deb-buster-amd64: minor upgrade for columnstore failed - stdio kernel step-script.sh ldd.old ldd.new syslog plugins.old plugins.new columnstore_logs
kvm-deb-kinetic-amd64: test nm - stdio kernel syslog 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-rpm-alma84-amd64: test nm F:galera_3nodes.... 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 (3)
kvm-rpm-rhel9-amd64: test nm F:spider/bugfix.... - 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 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (1)
kvm-rpm-rocky9-aarch64: test nm F:spider/bugfix.... - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (1)
kvm-rpm-rocky84-amd64: test nm F:GCF-939 - stdio kernel mysqld.3.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 (1)
openssl3-fips-debug: test nm F:innodb-redo-no... W:innodb-redo-no... - stdio kernel syslog mysqld.2.err.2 mysqld.3.err.2 mysqld.4.err.2 mysqld.1.err.2 mysqld.2.err.5 mysqld.1.err.5 mysqld.2.err.4 mysqld.1.err.4 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.3.err.1 mysqld.2.err.1 mysqld.2.err.6 mysqld.1.err.6 warnings (2)

c761f5025eb1...

c761f5025eb154f0a960a98deb639c0a1830bb2a

Lena Startseva

lena.startseva@mariadb.com

MDEV-31407: Add aliases in opt_trace.test for long column name for removing "--disable-view-protocol"

Change tests:
opt_trace.test
opt_trace_index_merge.test
opt_trace_ucs2.test

bed70468ea08...

bed70468ea08c2820647f5e3ac006a9ff88144ac

Sergei Golubchik

serg@mariadb.org

Merge branch 'bb-10.4-release' into bb-10.5-release

kvm-bintar-trusty-amd64: test F:show_aggregate - stdio kernel warnings (2)
kvm-fulltest: test view F:derived_cond_p... F:func_str F:opt_trace - stdio kernel mysqld.1.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.3.err.1 mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.3 mysqld.2.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (1)
kvm-fulltest2: test view F:derived_cond_p... F:func_str F:opt_trace - stdio kernel mysqld.4.err.1 mysqld.3.err.1 mysqld.2.err.1 mysqld.1.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.2.err.2 mysqld.1.err.2 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.4 warnings (1)
kvm-rpm-rocky8-aarch64: test nm F:show_aggregate - stdio kernel mysqld.3.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.4 mysqld.2.err.2 mysqld.1.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 warnings (1)

b5507c738f83...

b5507c738f83f3c896fe81dd38f695c91b2ad46c

Oleg Smirnov

olernov@gmail.com

MDEV-25080 Fix crash for CREATE TABLE from pushed union

During st_select_lex_unit::prepare() the member select_unit*
st_select_lex_unit::union_result is being assigned to an instance
of one of the following classes:
- select_unit
- select_unit_ext
- select_unit_recursive
- select_union_direct
Select_union_direct used to pass the result of the query directly to
the receiving select_result without filling a temporary table. This class
wraps a select_result object and is currently used to process UNION ALL
queries. Other select_unit_* classes involve some additional result processing.
Pushed down units are processed on the engine side so the results must be
also passed directly to a select_result object. So in the case when
the unit pushdown is employed st_select_lex_unit::union_result must be
assigned to an instance of select_union_direct.

kvm-asan: test nm F:long_host - stdio kernel mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.2.err.2 mysqld.3.err.4 mysqld.1.err.4 mysqld.4.err.4 mysqld.2.err.4 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-rpm-fedora36-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.2 mysqld.2.err.2 mysqld.1.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 warnings (1)
kvm-rpm-rhel9-amd64: test nm F:mariadb_port_f... - stdio kernel mysqld.1.err.3 mysqld.2.err.1 mysqld.2.err.2 mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 warnings (1)
winx64-packages: test nm F:innodb-64k-crash F:log_file_size_... - stdio mysqld.1.err.2 mysqld.1.err.1 mysqld.1.err.4 mysqld.1.err.3 mysqld.2.err.4 mysqld.2.err.1 mysqld.2.err.2 mysqld.2.err.3 warnings (1)

b2e60680093f...

b2e60680093f13ff495b835e1cfe1a2494e7a6eb

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915: Fix binlog_encrypion.rpl_parallel

ababe22ca343...

ababe22ca343ce5d93888c58939110661d7036ce

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915: Compilation fix

Removed inline (to re-add later)

a42a6fa99bce...

a42a6fa99bce9ce0def87f532348f765caa00ae5

Sergei Golubchik

serg@mariadb.org

Merge branch 'bb-10.5-release' into bb-10.6-release

kvm-ports-freebsd130-amd64: test nm F:rpl_row_img_se... W:rpl_row_img_se... - stdio kernel syslog mysqld.2.err.1 mysqld.3.err.1 mysqld.4.err.1 mysqld.1.err.1 mysqld.2.err.2 mysqld.4.err.2 mysqld.3.err.2 mysqld.1.err.2 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 warnings (2)
kvm-bld-minimal: build failed - stdio kernel
kvm-bld-nopart-debug: build failed - stdio kernel
kvm-deb-bullseye-aarch64: test nm F:innodb-checksu... F:innodb-checksu... W:innodb-checksu... W:innodb-checksu... - stdio kernel warnings (2)
kvm-deb-buster-amd64: minor upgrade for columnstore failed - stdio kernel step-script.sh ldd.old ldd.new syslog plugins.old plugins.new columnstore_logs
kvm-deb-kinetic-amd64: test nm - stdio kernel syslog 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-rpm-alma84-amd64: test nm F:galera_3nodes.... 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 (3)
kvm-rpm-rhel9-amd64: test nm F:spider/bugfix.... - 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 mysqld.1.err.4 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.3 mysqld.3.err.3 warnings (1)
kvm-rpm-rocky9-aarch64: test nm F:spider/bugfix.... - stdio kernel mysqld.3.err.1 mysqld.4.err.1 mysqld.2.err.1 mysqld.1.err.1 mysqld.3.err.4 mysqld.4.err.4 mysqld.2.err.4 mysqld.1.err.4 mysqld.4.err.3 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 mysqld.4.err.2 mysqld.3.err.2 mysqld.2.err.2 mysqld.1.err.2 warnings (1)
kvm-rpm-rocky84-amd64: test nm F:GCF-939 - stdio kernel mysqld.3.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 (1)
openssl3-fips-debug: test nm F:innodb-redo-no... W:innodb-redo-no... - stdio kernel syslog mysqld.2.err.2 mysqld.3.err.2 mysqld.4.err.2 mysqld.1.err.2 mysqld.2.err.5 mysqld.1.err.5 mysqld.2.err.4 mysqld.1.err.4 mysqld.3.err.3 mysqld.2.err.3 mysqld.1.err.3 mysqld.1.err.1 mysqld.3.err.1 mysqld.2.err.1 mysqld.2.err.6 mysqld.1.err.6 warnings (2)

a0f379a4c356...

a0f379a4c3560c1daec7798fd41df6af82d8130c

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915 Address buildbot failures

Note the update to binlog_mysqlbinlog_row_trans shows
that thd_arg->transaction.all.modified_non_trans_table is
preserved for mixed multi-engine N/T transactions where
the N statements are logged directly as separate
transactions, resulting in the final T transaction
not having FL_TRANSACTIONAL

8aa2165de9bf...

8aa2165de9bf4448023751b811722dc73f1d99cc

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915: Added wait_for_done PSI stage

Extended other tests to wait for the slave sql thread
to notify worker threads to abort before allowing paused
transactions to continue. Otherwise there would be a
potential race condition where a thread could continue
to the commit stage before noticing the abort.

84d34842a741...

84d34842a7414c641996ecb0d5eb0ee0606b1fd3

Brandon Nesterenko

brandon.nesterenko@mariadb.com

MDEV-13915 Mixed-multi engine case

7d7b1bee2bfc...

7d7b1bee2bfc0a36cec68766f9f566b2f9fd5b0e

Brandon Nesterenko

brandon.nesterenko@mariadb.com