[MDEV-20744] SET GLOBAL `replicate_do_db` = DEFAULT causes crash Created: 2019-10-04 Updated: 2024-02-02 Resolved: 2020-10-23 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Variables |
| Affects Version/s: | 5.5, 10.0, 10.1, 10.4.8, 10.2, 10.3, 10.4 |
| Fix Version/s: | 10.1.48, 10.2.35, 10.3.26, 10.4.16, 10.5.7 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Brad Chin (Inactive) | Assignee: | Alexey Botchkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS 7 |
||
| Issue Links: |
|
||||||||
| Description |
|
I started my MariaDB 10.4.8 server as so /qa/sw/mariadb/10.4/bin/mysqld --basedir=/opt/krobix/qa/bchin_oakey/mysql/goldDB-10-1570164683 --sql-mode= --sync-binlog=0 --slave-net-timeout=3600 --secure-file-priv= --datadir /opt/krobix/qa/bchin_oakey/mysql/goldDB-10-1570164683/data --port=60477 --max_connect_errors=999999 --server-id=60477 --user=mysql --skip-grant-tables --default-storage-engine=innodb --character-set-server=utf8 --socket /opt/krobix/qa/bchin_oakey/mysql/goldDB-10-1570164683/mysql.sock --innodb_lock_wait_timeout=300 --verbose I connected to the server with the following command: [root@oak013blue ~]# which mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SET GLOBAL `replicate_do_db` = DEFAULT; here is the trace + other info: Server version: 10.4.8-MariaDB Thread pointer: 0x7f0e080009a8 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 We think the query pointer is invalid, but we will try to print it anyway. Writing a core file... And I didn't see a core dump under "data" |
| Comments |
| Comment by Alice Sherepa [ 2019-10-04 ] | ||||||||||||||||||||||
|
Thank you very much for the report!
| ||||||||||||||||||||||
| Comment by Alexey Botchkov [ 2020-10-23 ] | ||||||||||||||||||||||
|
https://github.com/MariaDB/server/commit/94b493571a8ba8f30c97a5c30fc641171ca48e8a |