[MDEV-21597] MariaDB standalone server replication to MariaDB Galera Cluster crashing Created: 2020-01-30 Updated: 2022-10-27 Resolved: 2022-10-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Replication, Tests |
| Affects Version/s: | 10.4.12 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Eric Ang | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Galera, crash, replication | ||
| Environment: |
CentOS 7 (64bit), CentOS 8 (64bit) |
||
| Issue Links: |
|
||||||||
| Description |
|
Have setup the following 3 servers Server A is replicating to Server C Data updates done to Server A and Server B are fine but when updates are done to Server C, Server B will crash with the following information: 2020-01-30 11:23:04 24 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000019' at position 259047, relay log './unicorn-relay-bin.000001' position: 4; GTID position '0-115-13488787,1-8-1419' mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.12/wsrep-lib/src/transaction.cpp:123: int wsrep::transaction::start_transaction(const wsrep::transaction_id&): Assertion `active() == false' failed. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.4.12-MariaDB-log Thread pointer: 0x7faa30001378 Trying to get some variables. Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 2020-01-30 11:24:03 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: e171100d-322d-11e8-9957-624639ca8561:21127560 |
| Comments |
| Comment by Eric Ang [ 2020-01-31 ] | ||||||||||||||||||
|
Hi! After more testing, I've found the steps to reproduce this issue. In Server B, set the following In Server C, run the following query Server B will then crash. To summarize, Server A and Server B are setup as Galera Cluster while Server C is a standalone MariaDB server. | ||||||||||||||||||
| Comment by Eric Ang [ 2020-02-07 ] | ||||||||||||||||||
|
Hi! Any updates regarding this issue? | ||||||||||||||||||
| Comment by Marko Mäkelä [ 2021-03-19 ] | ||||||||||||||||||
|
I got a test failure locally on 10.4, with the same assertion expression:
I will disable that test with a reference to this ticket. As part of the fix, the test must be re-enabled. |