[MDEV-19872] Adding 'port' and 'socket' to primary key in spider tables (install_spider.sql) Created: 2019-06-26  Updated: 2023-09-20

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Leandro Pacheco (Inactive) Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Tables in spider with backend server information (e.g. spider_xa_member) only have host in the primary key.
That causes problems when a table has two backends with the same host value (but different ports, for example), and the errors it causes can be quite confusing.
For example, you may get "this xid already exists" due to conflicting entries for two participants of the same XA.
Adding port/socket to the primary key of these spider tables (in install_spider.sql) should resolve this issue.


Generated at Thu Feb 08 08:55:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.