Skip to content

Flaky test_materialized_database_mysql_date_type_to_date32 #66047

@pamarcos

Description

@pamarcos

test_materialized_database_mysql_date_type_to_date32 failed due to an issue found by the Thread Sanitizer.

Report: https://s3.amazonaws.com/clickhouse-test-reports/65838/389a86ec059461f20521e4dd2c7888e2b3b37623/integration_tests__tsan__[4_6]//home/ubuntu/actions-runner/_work/_temp/test/output_dir/integration_run_parallel1_0.log

__ ERROR at teardown of test_materialized_database_mysql_date_type_to_date32 ___
[gw1] linux -- Python 3.10.12 /usr/bin/python3

    @pytest.fixture(scope="module")
    def started_cluster():
        try:
            cluster.start()
            yield cluster
        finally:
            node_db.stop_clickhouse()  # ensures that coverage report is written to disk, even if cluster.shutdown() times out.
>           cluster.shutdown()

test_materialized_mysql_database/test.py:58: 
...
WARNING: ThreadSanitizer: data race (pid=3978)
  Read of size 8 at 0x7220001667a0 by thread T639 (mutexes: write M0):
    #0 sa_doall build_docker/./contrib/openssl/crypto/sparse_array.c:86:30 (clickhouse+0x205ac15b) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #1 ossl_sa_doall_arg build_docker/./contrib/openssl/crypto/sparse_array.c:148:9 (clickhouse+0x205ac15b)
    #2 ossl_sa_ALGORITHM_doall_arg build_docker/./contrib/openssl/crypto/property/property.c:97:1 (clickhouse+0x20577c51) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #3 ossl_method_store_do_all build_docker/./contrib/openssl/crypto/property/property.c:490:9 (clickhouse+0x20577c51)
    #4 evp_generic_do_all build_docker/./contrib/openssl/crypto/evp/evp_fetch.c:621:5 (clickhouse+0x2050083c) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #5 EVP_KEYMGMT_do_all_provided build_docker/./contrib/openssl/crypto/evp/keymgmt_meth.c:298:5 (clickhouse+0x2050c967) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #6 ossl_decoder_ctx_setup_for_pkey build_docker/./contrib/openssl/crypto/encode_decode/decoder_pkey.c:441:5 (clickhouse+0x204d93e5) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #7 OSSL_DECODER_CTX_new_for_pkey build_docker/./contrib/openssl/crypto/encode_decode/decoder_pkey.c:803:16 (clickhouse+0x204d93e5)
    #8 x509_pubkey_ex_d2i_ex build_docker/./contrib/openssl/crypto/x509/x_pubkey.c:208:14 (clickhouse+0x205ef014) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #9 asn1_item_embed_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:262:20 (clickhouse+0x2044a86d) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #10 asn1_template_noexp_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:682:15 (clickhouse+0x2044c451) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #11 asn1_template_ex_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:558:16 (clickhouse+0x2044b31d) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #12 asn1_item_embed_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:422:19 (clickhouse+0x2044ace9) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #13 asn1_template_noexp_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:682:15 (clickhouse+0x2044c451) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #14 asn1_template_ex_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:558:16 (clickhouse+0x2044b31d) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #15 asn1_item_embed_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:422:19 (clickhouse+0x2044ace9) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #16 asn1_item_ex_d2i_intern build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:118:10 (clickhouse+0x2044a48b) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #17 ASN1_item_d2i_ex build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:144:9 (clickhouse+0x2044a48b)
    #18 ASN1_item_d2i build_docker/./contrib/openssl/crypto/asn1/tasn_dec.c:154:12 (clickhouse+0x2044a48b)
    #19 d2i_X509 build_docker/./contrib/openssl/crypto/x509/x_x509.c:138:1 (clickhouse+0x205ef150) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #20 tls_process_server_certificate build_docker/./contrib/openssl/ssl/statem/statem_clnt.c:2006:13 (clickhouse+0x20425199) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #21 ossl_statem_client_process_message build_docker/./contrib/openssl/ssl/statem/statem_clnt.c:1100:16 (clickhouse+0x20423bff) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #22 read_state_machine build_docker/./contrib/openssl/ssl/statem/statem.c:684:19 (clickhouse+0x2041f9e7) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #23 state_machine build_docker/./contrib/openssl/ssl/statem/statem.c:478:21 (clickhouse+0x2041f9e7)
    #24 ossl_statem_connect build_docker/./contrib/openssl/ssl/statem/statem.c:297:12 (clickhouse+0x2041ebce) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #25 SSL_do_handshake build_docker/./contrib/openssl/ssl/ssl_lib.c:4746:19 (clickhouse+0x203a5f41) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #26 SSL_connect build_docker/./contrib/openssl/ssl/ssl_lib.c:2208:12 (clickhouse+0x203a6053) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #27 ma_tls_connect build_docker/./contrib/mariadb-connector-c/libmariadb/secure/openssl.c:627:30 (clickhouse+0x1dc9065d) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #28 ma_pvio_tls_connect build_docker/./contrib/mariadb-connector-c/libmariadb/ma_tls.c:83:12 (clickhouse+0x1dc7a0ba) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #29 ma_pvio_start_ssl build_docker/./contrib/mariadb-connector-c/libmariadb/ma_pvio.c:531:7 (clickhouse+0x1dc79e73) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #30 send_client_reply_packet build_docker/./contrib/mariadb-connector-c/plugins/auth/my_auth.c:302:9 (clickhouse+0x1dc789e4) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #31 client_mpvio_write_packet build_docker/./contrib/mariadb-connector-c/plugins/auth/my_auth.c:444:12 (clickhouse+0x1dc789e4)
    #32 native_password_auth_client build_docker/./contrib/mariadb-connector-c/plugins/auth/my_auth.c:88:9 (clickhouse+0x1dc774d8) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #33 run_plugin_auth build_docker/./contrib/mariadb-connector-c/plugins/auth/my_auth.c:594:8 (clickhouse+0x1dc77a0a) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #34 mthd_my_real_connect build_docker/./contrib/mariadb-connector-c/libmariadb/mariadb_lib.c:1518:7 (clickhouse+0x1dc6adb7) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #35 mysql_real_connect build_docker/./contrib/mariadb-connector-c/libmariadb/mariadb_lib.c:1203:10 (clickhouse+0x1dc69e04) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #36 mysqlxx::Connection::connect(char const*, char const*, char const*, char const*, unsigned int, char const*, char const*, char const*, char const*, unsigned int, unsigned int, bool, bool) build_docker/./src/Common/mysqlxx/Connection.cpp:117:10 (clickhouse+0x1d371cd2) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #37 mysqlxx::Pool::allocConnection(bool) build_docker/./src/Common/mysqlxx/Pool.cpp:366:24 (clickhouse+0x1d382012) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #38 mysqlxx::Pool::initialize() build_docker/./src/Common/mysqlxx/Pool.cpp:347:13 (clickhouse+0x1d381339) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #39 mysqlxx::Pool::tryGet() build_docker/./src/Common/mysqlxx/Pool.cpp:225:5 (clickhouse+0x1d382b1d) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #40 DB::MaterializedMySQLSyncThread::prepareSynchronized(DB::MaterializeMetadata&) build_docker/./src/Databases/MySQL/MaterializedMySQLSyncThread.cpp:541:31 (clickhouse+0x16b99f10) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #41 DB::MaterializedMySQLSyncThread::synchronization() build_docker/./src/Databases/MySQL/MaterializedMySQLSyncThread.cpp:296:22 (clickhouse+0x16b990a8) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #42 DB::MaterializedMySQLSyncThread::startSynchronization()::$_0::operator()() const build_docker/./src/Databases/MySQL/MaterializedMySQLSyncThread.cpp:368:80 (clickhouse+0x16babfd2) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #43 decltype(std::declval<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&>()()) std::__1::__invoke[abi:v15000]<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&) build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:394:23 (clickhouse+0x16babfd2)
    #44 decltype(auto) std::__1::__apply_tuple_impl[abi:v15000]<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&, std::__1::tuple<>&>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&, std::__1::tuple<>&, std::__1::__tuple_indices<...>) build_docker/./contrib/llvm-project/libcxx/include/tuple:1789:1 (clickhouse+0x16babfd2)
    #45 decltype(auto) std::__1::apply[abi:v15000]<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&, std::__1::tuple<>&>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&, std::__1::tuple<>&) build_docker/./contrib/llvm-project/libcxx/include/tuple:1798:1 (clickhouse+0x16babfd2)
    #46 ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'()::operator()() build_docker/./src/Common/ThreadPool.h:251:13 (clickhouse+0x16babfd2)
    #47 decltype(std::declval<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>()()) std::__1::__invoke[abi:v15000]<ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'()&>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&) build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:394:23 (clickhouse+0x16babfd2)
    #48 void std::__1::__invoke_void_return_wrapper<void, true>::__call<ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'()&>(ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'()&) build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:479:9 (clickhouse+0x16babfd2)
    #49 std::__1::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'(), void ()>::operator()[abi:v15000]() build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:235:12 (clickhouse+0x16babfd2)
    #50 void std::__1::__function::__policy_invoker<void ()>::__call_impl<std::__1::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::MaterializedMySQLSyncThread::startSynchronization()::$_0>(DB::MaterializedMySQLSyncThread::startSynchronization()::$_0&&)::'lambda'(), void ()>>(std::__1::__function::__policy_storage const*) build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:716:16 (clickhouse+0x16babfd2)
    #51 std::__1::__function::__policy_func<void ()>::operator()[abi:v15000]() const build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:848:16 (clickhouse+0xf77f303) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #52 std::__1::function<void ()>::operator()() const build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:1187:12 (clickhouse+0xf77f303)
    #53 ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) build_docker/./src/Common/ThreadPool.cpp:462:13 (clickhouse+0xf77f303)
    #54 void ThreadPoolImpl<std::__1::thread>::scheduleImpl<void>(std::__1::function<void ()>, Priority, std::__1::optional<unsigned long>, bool)::'lambda0'()::operator()() const build_docker/./src/Common/ThreadPool.cpp:219:73 (clickhouse+0xf7859d1) (BuildId: ca1a7a65d43730ba23d847e8ba1837f4dd08786e)
    #55 decltype(std::declval<void>()()) std::__1::__invoke[abi:v15000]<void ThreadPoolImpl<std::__1::thread>::scheduleImpl<void>(std::__1::function<void ()>, Priority, std::__1::optional<unsigned long>, bool)::'lambda0'()>(void&&) build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:394:23 (clickhouse+0xf7859d1)
    #56 void std::__1::__thread_execute[abi:v15000]<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct>>, void ThreadPoolImpl<std::__1::thread>::scheduleImpl<void>(std::__1::function<void ()>, Priority, std::__1::optional<unsigned long>, bool)::'lambda0'()>(std::__1::tuple<void, void ThreadPoolImpl<std::__1::thread>::scheduleImpl<void>(std::__1::function<void ()>, Priority, std::__1::optional<unsigned long>, bool)::'lambda0'()>&, std::__1::__tuple_indices<...>) build_docker/./contrib/llvm-project/libcxx/include/thread:284:5 (clickhouse+0xf7859d1)
    #57 void* std::__1::__thread_proxy[abi:v15000]<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct>>, void ThreadPoolImpl<std::__1::thread>::scheduleImpl<void>(std::__1::function<void ()>, Priority, std::__1::optional<unsigned long>, bool)::'lambda0'()>>(void*) build_docker/./contrib/llvm-project/libcxx/include/thread:295:5 (clickhouse+0xf7859d1)

Metadata

Metadata

Assignees

No one assigned

    Labels

    testingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions