Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Description
Test:
CREATE TABLE t1 (id INT PRIMARY KEY);
|
INSERT INTO t1 VALUES (1),(2);
|
|
|
CREATE OR REPLACE VIEW v1 AS SELECT
|
1 IN (
|
SELECT
|
(SELECT COUNT(id)
|
FROM t1
|
WHERE t1_outer.id <> id
|
) AS f
|
FROM
|
t1 AS t1_outer
|
GROUP BY f
|
);
|
|
|
SELECT * FROM v1;
|
DROP VIEW v1;
|
DROP TABLE t1;
|
Errors:
mysqltest: At line 16: query 'SELECT * FROM v1' failed: 2013: Lost connection to MySQL server during query
|
|
|
|
|
Server [mysqld.1 - pid: 59119, winpid: 59119, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
$ /home/elena/work/MariaDB/10.3/bld/sql/mysqld --defaults-group-suffix=.1 --defaults-file=/home/elena/work/MariaDB/10.3/bld/mysql-test/var/my.cnf --log-output=file --core-file --loose-debug-sync-timeout=300
|
2022-02-28 14:31:46 0 [Note] /home/elena/work/MariaDB/10.3/bld/sql/mysqld (mysqld 10.3.35-MariaDB-debug-log) starting as process 59120 ...
|
2022-02-28 14:31:46 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32198)
|
2022-02-28 14:31:46 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2022-02-28 14:31:46 0 [Note] Plugin 'partition' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'InnoDB' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'SEQUENCE' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_LOCKS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMP' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'user_variables' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_TRX' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_METRICS' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2022-02-28 14:31:46 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2022-02-28 14:31:46 0 [Warning] /home/elena/work/MariaDB/10.3/bld/sql/mysqld: unknown option '--loose-pam-debug'
|
2022-02-28 14:31:46 0 [Note] Server socket created on IP: '127.0.0.1'.
|
2022-02-28 14:31:46 0 [Note] Reading of all Master_info entries succeeded
|
2022-02-28 14:31:46 0 [Note] Added new Master_info '' to hash table
|
2022-02-28 14:31:46 0 [Note] /home/elena/work/MariaDB/10.3/bld/sql/mysqld: ready for connections.
|
Version: '10.3.35-MariaDB-debug-log' socket: '/home/elena/work/MariaDB/10.3/bld/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
220228 14:31:46 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
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
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.3.35-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=1
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63289 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7f18cc000d90
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f18dc399db0 thread_stack 0x49000
|
mysys/stacktrace.c:174(my_print_stacktrace)[0x564a238a97e8]
|
sql/signal_handler.cc:221(handle_fatal_signal)[0x564a22fcb40a]
|
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x5b43cc vs 0x429a58)
|
/lib/x86_64-linux-gnu/libc.so.6(+0x46520)[0x7f18e2383520]
|
sql/item_subselect.cc:6878(Item_subselect::init_expr_cache_tracker(THD*))[0x564a230c6ae5]
|
sql/item_subselect.cc:1322(Item_singlerow_subselect::expr_cache_insert_transformer(THD*, unsigned char*))[0x564a230b3b7d]
|
sql/item.cc:727(Item::transform(THD*, Item* (Item::*)(THD*, unsigned char*), unsigned char*))[0x564a22fe9db4]
|
sql/sql_select.cc:3671(JOIN::setup_subquery_caches())[0x564a22ce3062]
|
sql/sql_select.cc:2537(JOIN::optimize_stage2())[0x564a22cdea17]
|
sql/sql_select.cc:2003(JOIN::optimize_inner())[0x564a22cdcaf7]
|
sql/sql_select.cc:1519(JOIN::optimize())[0x564a22cdae7c]
|
sql/sql_lex.cc:4118(st_select_lex::optimize_unflattened_subqueries(bool))[0x564a22c65d3d]
|
sql/opt_subselect.cc:5377(JOIN::optimize_constant_subqueries())[0x564a22e7aedb]
|
sql/sql_select.cc:1718(JOIN::optimize_inner())[0x564a22cdb844]
|
sql/sql_select.cc:1519(JOIN::optimize())[0x564a22cdae7c]
|
sql/sql_derived.cc:962(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x564a22c40580]
|
sql/sql_derived.cc:193(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x564a22c3e620]
|
sql/sql_select.cc:1800(JOIN::optimize_inner())[0x564a22cdbf1f]
|
sql/sql_select.cc:1519(JOIN::optimize())[0x564a22cdae7c]
|
sql/sql_select.cc:4339(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564a22ce5223]
|
sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564a22cd641e]
|
sql/sql_parse.cc:6339(execute_sqlcom_select(THD*, TABLE_LIST*))[0x564a22c9ac83]
|
sql/sql_parse.cc:3870(mysql_execute_command(THD*))[0x564a22c913a0]
|
sql/sql_parse.cc:7870(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564a22c9f205]
|
sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564a22c8b18f]
|
sql/sql_parse.cc:1398(do_command(THD*))[0x564a22c89ab3]
|
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x564a22e11a89]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x564a22e117f8]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x564a238330f4]
|
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x5b43cc vs 0x429a58)
|
/lib/x86_64-linux-gnu/libc.so.6(+0x98927)[0x7f18e23d5927]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7f18e24659e4]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f18cc012ad8): SELECT * FROM v1
|
|
|
Connection ID (thread ID): 4
|
Status: NOT_KILLED
|
|
|
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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
|
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /home/elena/work/MariaDB/10.3/bld/mysql-test/var/mysqld.1/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 255959 255959 processes
|
Max open files 1024 1024 files
|
Max locked memory 8393773056 8393773056 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 255959 255959 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E
|
|
|
----------SERVER LOG END-------------
|
|
Attachments
Issue Links
- is part of
-
MDEV-27691
make working view-protocol
-
- Open
-
- relates to
-
-
- Closed
-
-
-
- Closed
-