【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
CREATE TABLE IF NOT EXISTS opt_log (
id
BIGINT(20) UNSIGNED NOT NULL AUTO_RANDOM,
mod_id
BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
act_id
BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
apkid
TINYINT(1) UNSIGNED NOT NULL DEFAULT ‘0’,
deviceid
TINYINT(1) UNSIGNED NOT NULL DEFAULT ‘0’,
content
TEXT COMMENT ‘日志内容’,
user_id
BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
create_time
INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id
,create_time
)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT ‘操作行为日志分区表’
PARTITION BY RANGE (create_time
)
(PARTITION p202307
VALUES LESS THAN (UNIX_TIMESTAMP(‘2023-08-01 00:00:00’)),
PARTITION p202308
VALUES LESS THAN (UNIX_TIMESTAMP(‘2023-09-01 00:00:00’)),
PARTITION p202309
VALUES LESS THAN (UNIX_TIMESTAMP(‘2023-10-01 00:00:00’)),
PARTITION p202310
VALUES LESS THAN (UNIX_TIMESTAMP(‘2023-11-01 00:00:00’)),
PARTITION p202311
VALUES LESS THAN (UNIX_TIMESTAMP(‘2023-12-01 00:00:00’)),
PARTITION p202312
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-01-01 00:00:00’)),
PARTITION p202401
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-02-01 00:00:00’)),
PARTITION p202402
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-03-01 00:00:00’)),
PARTITION p202403
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-04-01 00:00:00’)),
PARTITION p202404
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-05-01 00:00:00’)),
PARTITION p202405
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-06-01 00:00:00’)),
PARTITION p202406
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-07-01 00:00:00’)),
PARTITION p202407
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-08-01 00:00:00’)),
PARTITION p202408
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-09-01 00:00:00’)),
PARTITION p202409
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-10-01 00:00:00’)),
PARTITION p202410
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-11-01 00:00:00’)),
PARTITION p202411
VALUES LESS THAN (UNIX_TIMESTAMP(‘2024-12-01 00:00:00’)),
PARTITION pmax
VALUES LESS THAN (MAXVALUE));
创建分区表报错8216 - Invalid auto random: column id is not the integer primary key, or the primary key is nonclustered
请问各位有使用分区表吗?创建分区表的时候报这个错误,应该如何 调整?
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】