MyCATApache/Mycat-Server

Mycat 1.6-RELEASE 水平分表，插入子表时报错找不到父表分片节点

Open

#2947 opened on Jan 19, 2024

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Java (9,451 stars) (3,886 forks)batch import
help wanted

Description

schema.xml配置 微信图片_20240119154023

rule.xml配置 rule配置

数据表结构 数据表结构

SQL语句 INSERT INTO order_detail (id, order_id) values (1, 1);

报错：1064 - can't find (root) parent sharding node for sql

请问哪位大神能帮忙看一下，感谢

Contributor guide

Tech stack
javasql
Domain
databasebackend
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Mycat shardingJava
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
25
Research direction
Investigate the sharding rule configuration for the parent child table relationship in Mycat. The error 'can't find (root) parent sharding node for sql' suggests that when inserting into a child table, Mycat cannot locate the parent sharding node. Examine rule.xml to ensure the child table's sharding rule correctly references the parent table's algorithm. Also verify schema.xml for proper table linkage. Review Mycat's source code for error handling in parent node resolution.