Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18051

Connect engine crashes mariadb server

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2.8
    • N/A
    • Windows Server 2016 Standard 64bit
      Processor: Intel(R) Xeon(R) CPU E5640 @2.67GHz 2.66GHz
      RAM: 24GB

    Description

      When I run flush tables the server crashes. We use the connect engine quite intensively and the mysqld memory keeps growing, so I run flush tables to free up some memory, but the DB server crashes.

      I will attach the error log for that query.

      Attachments

        1. flush.err
          5 kB
        2. my.ini
          0.3 kB

        Issue Links

          Activity

            Stack trace from the attached log:

            10.2.8

            ha_connect.dll!CntCloseTable()[connect.cc:546]
            ha_connect.dll!ha_connect::CloseTable()[ha_connect.cc:2014]
            mysqld.exe!closefrm()[table.cc:3412]
            mysqld.exe!intern_close_table()[table_cache.cc:223]
            mysqld.exe!tc_purge()[table_cache.cc:335]
            mysqld.exe!close_cached_tables()[sql_base.cc:376]
            mysqld.exe!reload_acl_and_cache()[sql_reload.cc:331]
            mysqld.exe!mysql_execute_command()[sql_parse.cc:5387]
            mysqld.exe!mysql_parse()[sql_parse.cc:7891]
            mysqld.exe!dispatch_command()[sql_parse.cc:1814]
            mysqld.exe!do_command()[sql_parse.cc:1359]
            mysqld.exe!threadpool_process_request()[threadpool_common.cc:346]
            mysqld.exe!tp_callback()[threadpool_common.cc:192]
            ntdll.dll!RtlReleaseSRWLockExclusive()
            ntdll.dll!RtlReleaseSRWLockExclusive()
            KERNEL32.DLL!BaseThreadInitThunk()
            ntdll.dll!RtlUserThreadStart()
             
            Trying to get some variables.
            Some pointers may be invalid and cause the dump to abort.
            Query (0x2c0b3bcbbc0): flush tABLES
            Connection ID (thread ID): 24138
            Status: NOT_KILLED
            

            elenst Elena Stepanova added a comment - Stack trace from the attached log: 10.2.8 ha_connect.dll!CntCloseTable()[connect.cc:546] ha_connect.dll!ha_connect::CloseTable()[ha_connect.cc:2014] mysqld.exe!closefrm()[table.cc:3412] mysqld.exe!intern_close_table()[table_cache.cc:223] mysqld.exe!tc_purge()[table_cache.cc:335] mysqld.exe!close_cached_tables()[sql_base.cc:376] mysqld.exe!reload_acl_and_cache()[sql_reload.cc:331] mysqld.exe!mysql_execute_command()[sql_parse.cc:5387] mysqld.exe!mysql_parse()[sql_parse.cc:7891] mysqld.exe!dispatch_command()[sql_parse.cc:1814] mysqld.exe!do_command()[sql_parse.cc:1359] mysqld.exe!threadpool_process_request()[threadpool_common.cc:346] mysqld.exe!tp_callback()[threadpool_common.cc:192] ntdll.dll!RtlReleaseSRWLockExclusive() ntdll.dll!RtlReleaseSRWLockExclusive() KERNEL32.DLL!BaseThreadInitThunk() ntdll.dll!RtlUserThreadStart()   Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2c0b3bcbbc0): flush tABLES Connection ID (thread ID): 24138 Status: NOT_KILLED
            bertrandop Olivier Bertrand added a comment - - edited

            I cannot reproduce this. When I execute FLUSH TABLES the connect engine is not called. Could you publish the scenario causing the crash?

            And what is this mysqld memory that keeps growing? Is it related to CONNECT?

            bertrandop Olivier Bertrand added a comment - - edited I cannot reproduce this. When I execute FLUSH TABLES the connect engine is not called. Could you publish the scenario causing the crash? And what is this mysqld memory that keeps growing? Is it related to CONNECT?
            lanklaas Pierre added a comment -

            I was also not able to reproduce this. You can close the issue. I will reopen when I found the table causing the issue

            lanklaas Pierre added a comment - I was also not able to reproduce this. You can close the issue. I will reopen when I found the table causing the issue

            People

              bertrandop Olivier Bertrand
              lanklaas Pierre
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.