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

Query timeout expired' from CONNECT

    XMLWordPrintable

    Details

      Description

      My connect table is not working due to timeout reasons.
      Is there a way I can configure to change the query timeout.

      /etc/odbc.ini

      [test]
      DSN = test
      Driver = ODBC Driver 11 for SQL Server
      Trace = Yes
      Server = 10.0.1.102
      Port = 1433
      Database = testdb
      Language = us_english

      /etc/odbcinst.ini

      [ODBC Driver 11 for SQL Server]
      Description=Microsoft ODBC Driver 11 for SQL Server
      Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
      Threading=1
      UsageCount=1

      test on isql

      isql test uid PASSWORD
      select TOP(1) * FROM dmi_vCustomer2;
       
      (Returns 1 row 66 seconds later.)

      error on MariaDB

      CREATE OR REPLACE TABLE ms_dmi_vCustomer2
      (
      customer_no int DEFAULT NULL
      ,post_code varchar(7) DEFAULT NULL
      ,customer_category smallint DEFAULT NULL
      ,mail_address varchar(100) DEFAULT NULL
      ,sex int DEFAULT NULL
      ,birthday char(23) DEFAULT NULL
      ,update_date char(23) DEFAULT NULL
      )
      ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=test;UID=uid;pwd=PASSWORD' `table_type`=ODBC `block_size`=500
      `tabname`='dmi_vCustomer2';
       
      select * from ms_dmi_vCustomer2 limit 10;
       
      (Returns the following error 27 seconds later.)
       
      ERROR 1296 (HY000): Got error 122 '[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired' from CONNECT

      *.err file

      S1T00: [unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired, Native=0
      [unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expiredrnd_next CONNECT: [unixODBC][Microsoft][ODBC Driver 11 for
      SQL Server]Query timeout expired
      GEM(73): [unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired
      external_lock: this=0x7fe8e6894a20 thd=0x7fe8f96fc008 xp=0x7fe8e69141a0 g=0x7fe8e68e7000 lock_type=2
      ODBC CloseDB: closing ms_dmi_vCustomer2

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            takuya Takuya Aoki
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Git Integration