Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
2.4.3
-
None
-
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
- is caused by
-
MXS-2838 Add prepared statement support for hintfilter
- Closed