Logging: /home/kamil/repo/upstream/8.0/mysql-server/mysql-test/mysql-test-run.pl main.greedy_optimizer MySQL Version 8.0.22 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/home/kamil/repo/upstream/8.0/bld/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 50%] main.greedy_optimizer [ fail ] Test ended at 2020-11-20 16:38:08 CURRENT_TEST: main.greedy_optimizer mysqltest: At line 868: Query 'EXPLAIN $query' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query The result from queries just before the failure was: select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I JOIN t40 ON t40.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I JOIN t40 ON t40.I=x.I JOIN t41 ON t41.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I JOIN t40 ON t40.I=x.I JOIN t41 ON t41.I=x.I JOIN t42 ON t42.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I JOIN t40 ON t40.I=x.I JOIN t41 ON t41.I=x.I JOIN t42 ON t42.I=x.I JOIN t43 ON t43.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; EXPLAIN SELECT COUNT(*) FROM t1 AS x JOIN t1 ON t1.I=x.I JOIN t2 ON t2.I=x.I JOIN t3 ON t3.I=x.I JOIN t4 ON t4.I=x.I JOIN t5 ON t5.I=x.I JOIN t6 ON t6.I=x.I JOIN t7 ON t7.I=x.I JOIN t8 ON t8.I=x.I JOIN t9 ON t9.I=x.I JOIN t10 ON t10.I=x.I JOIN t11 ON t11.I=x.I JOIN t12 ON t12.I=x.I JOIN t13 ON t13.I=x.I JOIN t14 ON t14.I=x.I JOIN t15 ON t15.I=x.I JOIN t16 ON t16.I=x.I JOIN t17 ON t17.I=x.I JOIN t18 ON t18.I=x.I JOIN t19 ON t19.I=x.I JOIN t20 ON t20.I=x.I JOIN t21 ON t21.I=x.I JOIN t22 ON t22.I=x.I JOIN t23 ON t23.I=x.I JOIN t24 ON t24.I=x.I JOIN t25 ON t25.I=x.I JOIN t26 ON t26.I=x.I JOIN t27 ON t27.I=x.I JOIN t28 ON t28.I=x.I JOIN t29 ON t29.I=x.I JOIN t30 ON t30.I=x.I JOIN t31 ON t31.I=x.I JOIN t32 ON t32.I=x.I JOIN t33 ON t33.I=x.I JOIN t34 ON t34.I=x.I JOIN t35 ON t35.I=x.I JOIN t36 ON t36.I=x.I JOIN t37 ON t37.I=x.I JOIN t38 ON t38.I=x.I JOIN t39 ON t39.I=x.I JOIN t40 ON t40.I=x.I JOIN t41 ON t41.I=x.I JOIN t42 ON t42.I=x.I JOIN t43 ON t43.I=x.I JOIN t44 ON t44.I=x.I; select @@optimizer_prune_level; select @@optimizer_search_depth; safe_process[10573]: Child process: 10574, killed by signal: 9 Server [mysqld.1 - pid: 10526, winpid: 10526, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2020-11-20T15:37:50.093528Z 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2020-11-20T15:37:50.093557Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-11-20T15:37:50.093635Z 0 [Note] [MY-010949] [Server] Basedir set to /home/kamil/repo/upstream/8.0/bld/. 2020-11-20T15:37:50.093658Z 0 [System] [MY-010116] [Server] /home/kamil/repo/upstream/8.0/bld/runtime_output_directory/mysqld (mysqld 8.0.22-debug-asan) starting as process 10527 2020-11-20T15:37:50.096490Z 0 [Warning] [MY-010108] [Server] setrlimit could not change the size of core files to 'infinity'; We may not be able to generate a core file on signals 2020-11-20T15:37:50.106403Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2020-11-20T15:37:50.106972Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2020-11-20T15:37:50.112002Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-11-20T15:37:50.112118Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2020-11-20T15:37:50.112229Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2020-11-20T15:37:50.112435Z 1 [Note] [MY-012937] [InnoDB] !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2020-11-20T15:37:50.112545Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins 2020-11-20T15:37:50.112665Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2020-11-20T15:37:50.112795Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2020-11-20T15:37:50.112927Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2020-11-20T15:37:50.115297Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2020-11-20T15:37:50.115612Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions 2020-11-20T15:37:50.116483Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2020-11-20T15:37:50.116693Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2020-11-20T15:37:50.118537Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 6 files. 2020-11-20T15:37:50.119361Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 24.000000M, instances = 1, chunk size =24.000000M 2020-11-20T15:37:50.127077Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2020-11-20T15:37:50.130681Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-11-20T15:37:50.131221Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2020-11-20T15:37:50.131718Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2020-11-20T15:37:50.185664Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2020-11-20T15:37:50.185968Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2020-11-20T15:37:50.186247Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2020-11-20T15:37:50.186539Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2020-11-20T15:37:50.187280Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 17692724, whereas checkpoint_lsn = 17692785 2020-11-20T15:37:50.195397Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2020-11-20T15:37:50.197250Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2020-11-20T15:37:50.197812Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2020-11-20T15:37:50.198980Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2020-11-20T15:37:50.199965Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2020-11-20T15:37:50.201304Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2020-11-20T15:37:50.201967Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1299 2020-11-20T15:37:50.260694Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2020-11-20T15:37:50.261097Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-11-20T15:37:50.276005Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2020-11-20T15:37:50.276679Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2020-11-20T15:37:50.347887Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2020-11-20T15:37:50.348818Z 1 [Note] [MY-012976] [InnoDB] 8.0.22 started; log sequence number 17692785 2020-11-20T15:37:50.349598Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-11-20T15:37:50.371490Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80022'. 2020-11-20T15:37:50.936602Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2020-11-20T15:37:50.941573Z 1 [Note] [MY-012356] [InnoDB] Validated 8/8 tablespaces 2020-11-20T15:37:51.035487Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80022'. 2020-11-20T15:37:51.723426Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2020-11-20T15:37:51.764425Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2020-11-20T15:37:51.765375Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2020-11-20T15:37:51.766422Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /home/kamil/repo/upstream/8.0/bld/mysql-test/var/mysqld.1/data/ib_buffer_pool 2020-11-20T15:37:51.770311Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 201120 18:37:51 2020-11-20T15:37:51.785581Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2020-11-20T15:37:51.840156Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 59c0150f-2b46-11eb-80bc-24ee9af9aa97. 2020-11-20T15:37:51.864337Z 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified. 2020-11-20T15:37:51.867979Z 0 [Warning] [MY-010068] [Server] CA certificate /home/kamil/repo/upstream/8.0/mysql-server/mysql-test/std_data/cacert.pem is self signed. 2020-11-20T15:37:51.869307Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2020-11-20T15:37:51.870509Z 0 [Note] [MY-010310] [Server] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF. 2020-11-20T15:37:51.871702Z 0 [Note] [MY-010310] [Server] Skipping generation of RSA key pair as --caching_sha2_password_auto_generate_rsa_keys is set to OFF. 2020-11-20T15:37:51.873414Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 13000 2020-11-20T15:37:51.874727Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2020-11-20T15:37:51.875968Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2020-11-20T15:37:51.877331Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2020-11-20T15:37:51.902538Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-port=13020'. 2020-11-20T15:37:51.903355Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-socket=/home/kamil/repo/upstream/8.0/bld/mysql-test/var/tmp/mysqlx.1.sock'. 2020-11-20T15:37:51.904134Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-ssl=DISABLED'. 2020-11-20T15:37:51.904905Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-ssl-ca='. 2020-11-20T15:37:51.905598Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-ssl-cert='. 2020-11-20T15:37:51.906295Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-ssl-key='. 2020-11-20T15:37:51.996079Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2020-11-20T15:37:52.006310Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 2020-11-20T15:37:52.006997Z 0 [Note] [MY-013667] [Server] Error-log destination "stderr" is not a file. Can not restore error log messages from previous run. 2020-11-20T15:37:52.007952Z 0 [System] [MY-010931] [Server] /home/kamil/repo/upstream/8.0/bld/runtime_output_directory/mysqld: ready for connections. Version: '8.0.22-debug-asan' socket: '/home/kamil/repo/upstream/8.0/bld/mysql-test/var/tmp/mysqld.1.sock' port: 13000 Source distribution. ASAN:DEADLYSIGNAL ================================================================= ==10527==ERROR: AddressSanitizer: stack-overflow on address 0x7ff7c9b3cef8 (pc 0x7ff7ec81b1e6 bp 0x7ff7c9b3d790 sp 0x7ff7c9b3cf00 T38) #0 0x7ff7ec81b1e5 (/usr/lib/x86_64-linux-gnu/libasan.so.4+0x5b1e5) #1 0x5621b262b68b in strchr /usr/include/string.h:220 #2 0x5621b262b68b in AutoDebugTrace::AutoDebugTrace(char const*, char const*, int) /home/kamil/repo/upstream/8.0/mysql-server/include/my_dbug.h:109 #3 0x5621b4fca9a7 in MEM_ROOT::AllocSlow(unsigned long) /home/kamil/repo/upstream/8.0/mysql-server/mysys/my_alloc.cc:87 #4 0x5621b262bad6 in MEM_ROOT::Alloc(unsigned long) /home/kamil/repo/upstream/8.0/mysql-server/include/my_alloc.h:154 #5 0x5621b2697e88 in operator new(unsigned long, MEM_ROOT*, std::nothrow_t const&) /home/kamil/repo/upstream/8.0/mysql-server/include/my_alloc.h:362 #6 0x5621b31fb59c in std::unique_ptr > NewIterator(THD*, TABLE*&, QEP_TAB*&, unsigned long long*&) /home/kamil/repo/upstream/8.0/mysql-server/sql/timing_iterator.h:168 #7 0x5621b31f0d3e in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:367 #8 0x5621b31f21c4 in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:528 #9 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #10 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #11 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #12 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #13 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #14 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #15 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #16 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #17 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #18 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #19 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #20 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #21 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #22 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #23 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #24 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #25 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #26 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #27 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #28 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #29 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #30 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #31 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #32 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #33 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #34 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #35 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #36 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #37 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #38 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #39 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #40 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #41 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #42 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #43 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #44 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #45 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #46 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #47 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #48 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #49 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #50 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #51 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #52 0x5621b31f223d in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:530 #53 0x5621b31f2eb6 in CreateIteratorFromAccessPath(THD*, AccessPath*, JOIN*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/join_optimizer/access_path.cc:595 #54 0x5621b2ad8bee in SELECT_LEX_UNIT::optimize(THD*, TABLE*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_union.cc:811 #55 0x5621b299a1d2 in Sql_cmd_dml::execute_inner(THD*) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_select.cc:924 #56 0x5621b29b5a6a in Sql_cmd_dml::execute(THD*) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_select.cc:725 #57 0x5621b28c0e9d in mysql_execute_command(THD*, bool) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_parse.cc:4344 #58 0x5621b28c3a6d in mysql_parse(THD*, Parser_state*) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_parse.cc:4965 #59 0x5621b28c6281 in dispatch_command(THD*, COM_DATA const*, enum_server_command) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_parse.cc:1784 #60 0x5621b28c9781 in do_command(THD*) /home/kamil/repo/upstream/8.0/mysql-server/sql/sql_parse.cc:1309 #61 0x5621b2c0a0ca in handle_connection /home/kamil/repo/upstream/8.0/mysql-server/sql/conn_handler/connection_handler_per_thread.cc:301 #62 0x5621b5d9080f in pfs_spawn_thread /home/kamil/repo/upstream/8.0/mysql-server/storage/perfschema/pfs.cc:2880 #63 0x7ff7ec5a86da in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76da) #64 0x7ff7eaa2171e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x12171e) SUMMARY: AddressSanitizer: stack-overflow (/usr/lib/x86_64-linux-gnu/libasan.so.4+0x5b1e5) Thread T38 created by T0 here: #0 0x7ff7ec7f7d2f in __interceptor_pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.4+0x37d2f) #1 0x5621b4fe0dfd in my_thread_create(my_thread_handle*, pthread_attr_t const*, void* (*)(void*), void*) /home/kamil/repo/upstream/8.0/mysql-server/mysys/my_thread.cc:59 #2 0x5621b5d9422f in pfs_spawn_thread_vc(unsigned int, my_thread_handle*, pthread_attr_t const*, void* (*)(void*), void*) /home/kamil/repo/upstream/8.0/mysql-server/storage/perfschema/pfs.cc:2930 #3 0x5621b2c091d9 in inline_mysql_thread_create /home/kamil/repo/upstream/8.0/mysql-server/include/mysql/psi/mysql_thread.h:140 #4 0x5621b2c0a404 in Per_thread_connection_handler::add_connection(Channel_info*) /home/kamil/repo/upstream/8.0/mysql-server/sql/conn_handler/connection_handler_per_thread.cc:409 #5 0x5621b2e1c793 in Connection_handler_manager::process_new_connection(Channel_info*) /home/kamil/repo/upstream/8.0/mysql-server/sql/conn_handler/connection_handler_manager.cc:260 #6 0x5621b26302c6 in Connection_acceptor::connection_event_loop() (/home/kamil/repo/upstream/8.0/bld/runtime_output_directory/mysqld-debug+0x388a2c6) #7 0x5621b262aadf in mysqld_main(int, char**) /home/kamil/repo/upstream/8.0/mysql-server/sql/mysqld.cc:7466 #8 0x5621b2603512 in main /home/kamil/repo/upstream/8.0/mysql-server/sql/main.cc:25 #9 0x7ff7ea921bf6 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x21bf6) ==10527==ABORTING safe_process[10526]: Child process: 10527, exit: 1 ----------SERVER LOG END------------- - the logfile can be found in '/home/kamil/repo/upstream/8.0/bld/mysql-test/var/log/main.greedy_optimizer/greedy_optimizer.log' [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 32 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.greedy_optimizer The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html