Skip to content

主键采用分布式时间戳⽅式在非分片表上不生效 #1459

@liuxinwang

Description

@liuxinwang
  • dble version: MavenVersion 2.19.07.0
  • preconditions :
    no
  • configs:

schema.xml

<table name="riding_order" primaryKey="id" autoIncrement="true" dataNode="ermdn1"  />

rule.xml

server.xml

<property name="sequnceHandlerType">2</property>

sequence_time_conf.properties

dble为双节点负载
dble1:
WORKID=01
DATAACENTERID=01
dble2:
WORKID=01
DATAACENTERID=02

  • steps:
    step1.
    对 riding_order表 执行插入,主键id生成连续,并没有采用分布式主键方式生成
  • expect result:
    1.id生成非连续
  • real result:
    1.id生成连续
  • supplements:
    1.对riding_order表增加rule规则,也就是采用分片表,分布式主键生成非连续。

Metadata

Metadata

Assignees

Labels

communityissue from communityresolveproblem has been fixed by developer

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions