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

Memory usage growing until server crash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.12
    • N/A
    • MariaDB server v10.3.12 - 32 bits for Windows

      Installed on : Windows Server 2016 64 bit, Intel Xeon CPU e5-2620

    Description

      I am using MariaDB as a bridge for old databases that has only 32 bit ODBC drivers.

      So, I have create many tables in MariaDB using the CONNECT engine to point to thoses old databases.

      For example:
      CREATE TABLE customer ENGINE=CONNECT CONNECTION='DSN=AcombaStructure' TABLE_TYPE='ODBC' TABNAME='Customer' OPTION_LIST='readonly=yes'

      I have also created a "send command to ODBC data source" table as per documentation of the CONNECT engine.

      Through a .NET program, I open the connection, send SELECT requests or Update / Insert requests to the special "send command to ODBC data source" table. Then close the connection. Memory usage by the "mysqld" process on the Windows server just keep on growing. Even simple SELECT request through MySQL Workbench does the same thing on memory.

      I have tried with MySQL ODBC driver and MariaDB ODBC driver.... same situation of memory not released.

      That leads to the MariaDB server crashing.

      I haven't changed anything in the MariaDB config file, default values from the installation are used.

      I am joining a partial error log file.

      Attachments

        1. Call 2 - MySQL.txt
          12 kB
          Pat Sav
        2. create local CONNECT table MariaDB.txt
          0.2 kB
          Pat Sav
        3. create remote InnoDB table MySQL.txt
          0.1 kB
          Pat Sav
        4. In Mariadb 1 of 2.jpg
          93 kB
          Pat Sav
        5. In Mariadb 2 of 2.jpg
          76 kB
          Pat Sav
        6. local MariaDB my.ini
          0.2 kB
          Pat Sav
        7. Local MariaDB schema.jpg
          35 kB
          Pat Sav
        8. Local MariaDB table.jpg
          78 kB
          Pat Sav
        9. Log MariaDB.txt
          4 kB
          Pat Sav
        10. ODBC MySQL DSN setup.jpg
          176 kB
          Pat Sav
        11. remote MySQL my.ini
          0.6 kB
          Pat Sav
        12. Remote MySQL schema.jpg
          35 kB
          Pat Sav
        13. Remote MySQL table.jpg
          89 kB
          Pat Sav
        14. setup for testing.jpg
          77 kB
          Pat Sav
        15. tblfourn on MySQL server.jpg
          269 kB
          Pat Sav

        Activity

          People

            bertrandop Olivier Bertrand
            PatSav Pat Sav
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.