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

Router hints are ignored when executing a CallableStatement in a Java app using MariaDB Connector/J

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 2.4.3
    • Fix Version/s: N/A
    • Component/s: hintfilter
    • Labels:
      None
    • Environment:
      Ubuntu 18.04, Java 1.8, MariaDB Connector/J 2.5.3

      Description

      In the following slow logs, the Callable Statement is executed before the maxscale end hint comment but after the maxscale begin comment. As is shown, the stored procedure is executed on the "master" node.

      Slow log for Galera "Slave" (as defined by Maxscale):

      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.002670  Lock_time: 0.000111  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 1  Bytes_sent: 13
      SET timestamp=1579156660;
      INSERT INTO diagnostic_log SET message=CONCAT_WS(' - ', @@wsrep_node_name, 1) /* maxscale begin route to slave */;
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.000124  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 0  Bytes_sent: 160
      SET timestamp=1579156660;
      # administrator command: Prepare;
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.002937  Lock_time: 0.000093  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 1  Bytes_sent: 13
      SET timestamp=1579156660;
      INSERT INTO diagnostic_log SET message=CONCAT_WS(' - ', @@wsrep_node_name, 2);
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.002395  Lock_time: 0.000096  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 1  Bytes_sent: 13
      SET timestamp=1579156660;
      INSERT INTO diagnostic_log SET message=CONCAT_WS(' - ', @@wsrep_node_name, 3);
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.003113  Lock_time: 0.000091  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 1  Bytes_sent: 13
      SET timestamp=1579156660;
      INSERT INTO diagnostic_log SET message=CONCAT_WS(' - ', @@wsrep_node_name, 4);
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 329  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 0  Bytes_sent: 0
      SET timestamp=1579156660;
      # administrator command: Close stmt;
      

      Slow log for Galera "Master":

      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 970  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.000167  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 0  Bytes_sent: 187
      SET timestamp=1579156660;
      # administrator command: Prepare;
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 970  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.003640  Lock_time: 0.000000  Rows_sent: 19  Rows_examined: 98
      # Rows_affected: 0  Bytes_sent: 11610
      SET timestamp=1579156660;
      CALL p_store_item_list(10033,'en_GB','ITC',0,NULL,NULL);
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 970  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.003174  Lock_time: 0.000119  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 1  Bytes_sent: 13
      SET timestamp=1579156660;
      INSERT INTO diagnostic_log SET message=CONCAT_WS(' - ', @@wsrep_node_name, 5) /* maxscale end */;
      # User@Host: vt_eucalyptus_local[vt_eucalyptus_local] @  [10.0.2.4]
      # Thread_id: 970  Schema: vt_eucalyptus_local  QC_hit: No
      # Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 0  Bytes_sent: 0
      SET timestamp=1579156660;
      # administrator command: Close stmt;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              Rich Rich Theobald
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.