Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3801

Unexpected internal state with read-only cursor and result with one row

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.16, 6.1.3
    • Fix Version/s: 2.5.17, 6.1.4
    • Component/s: Protocol
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-142

      Description

      When running Connector/C test suites on Travis against MaxScale, all C/C branches get timeout when running ps_bugs after CONC-566 test was running:

      Start 12: ps_bugs
       
      12: # port: 4006
      12: # ssl_port: 4006
      12: # Testing against MySQL Server 10.5.12-MariaDB-1:10.5.12+maria~focal
      12: # Host: mariadb.example.com via TCP/IP
      12: # Client library: 10.5.5
      12: ok 1 - test_conc566
      12/21 Test #12: ps_bugs ..........................***Timeout 180.09 sec
      

      test_conc566 (from unittest/libmariadb/ps_bugs.c):

      static int test_conc566(MYSQL *mysql)
      {
        int rc;
        MYSQL_STMT *stmt = mysql_stmt_init(mysql);
        unsigned long cursor = CURSOR_TYPE_READ_ONLY;
        const char* query= "call sp()";
       
        rc= mysql_query(mysql,"drop procedure if exists sp");
        check_mysql_rc(rc, mysql);
       
        rc= mysql_query(mysql,"create procedure sp() select 1");
        check_mysql_rc(rc, mysql);
       
        rc= mysql_stmt_prepare(stmt,query,-1);
        check_stmt_rc(rc, stmt);
       
        rc= mysql_stmt_attr_set(stmt, STMT_ATTR_CURSOR_TYPE, &cursor);
        check_stmt_rc(rc, stmt);
       
        rc= mysql_stmt_execute(stmt);
        check_stmt_rc(rc, stmt);
       
        mysql_stmt_close(stmt);
        return OK;
      }
      

      P.S: I don't know which MaxScale version it is, server is running on db.skysql.net

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              georg Georg Richter
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.