[MXS-2250] DESCRIBE on temporary table is routed to slave Created: 2019-01-09  Updated: 2020-08-25  Resolved: 2019-06-05

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 2.2.18, 2.3.2
Fix Version/s: 2.3.8

Type: Bug Priority: Major
Reporter: Adam Bambuch Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None


 Description    

[Read-Write-Service]
 
type=service
 
router=readwritesplit
 
servers=db1,db2,db3
 
user=maxscale
 
passwd=


mysql> CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_category_product_index_store1_tmp` LIKE `catalog_category_product_index_store1`;
 
Query OK, 0 rows affected (0.01 sec)
 
mysql> DESCRIBE `catalog_category_product_index_store1_tmp`;
 
ERROR 1146 (42S02): Table 'testovaci.catalog_category_product_index_store1_tmp' doesn't exist



 Comments   
Comment by Johan Wikman [ 2019-01-09 ]

Statements involving temporary tables are always sent to master, but DESCRIBE table is classified as a READ, so it will be sent to some slave. Hence the error.

Comment by markus makela [ 2019-04-15 ]

johan.wikman is the table name exposed by the query classifier?

Comment by Johan Wikman [ 2019-06-04 ]

Currently not, but work in progress to change that.

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