[MXS-3801] Unexpected internal state with read-only cursor and result with one row Created: 2021-09-30  Updated: 2021-11-22  Resolved: 2021-10-15

Status: Closed
Project: MariaDB MaxScale
Component/s: Protocol
Affects Version/s: 2.5.16, 6.1.3
Fix Version/s: 2.5.17, 6.1.4

Type: Bug Priority: Major
Reporter: Georg Richter Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MXS-3818 Upgrade to Connector-C 3.1.15 Closed
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


Generated at Thu Feb 08 04:24:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.