表结构未变动闪回失败报表结构改变

dfant · 2025 年6 月 25 日 16:31

【使用环境】测试环境
【 OB or 其他组件】
【使用版本】4.2.1.10
obclient(root@ldf)[test]> select version();
±------------------------------+
| version() |
±------------------------------+
| 5.7.25-OceanBase_CE-v4.2.1.10 |
±------------------------------+
1 row in set (0.001 sec)

obclient(root@ldf)[test]> select * from untab;
±-----±-----+
| c1 | c2 |
±-----±-----+
| 100 | a |
| 200 | b |
| 300 | c |
±-----±-----+
3 rows in set (0.001 sec)

obclient(root@ldf)[test]> select time_to_usec(CURRENT_TIMESTAMP()),CURRENT_TIMESTAMP();
±----------------------------------±--------------------+
| time_to_usec(CURRENT_TIMESTAMP()) | CURRENT_TIMESTAMP() |
±----------------------------------±--------------------+
| 1750840043000000 | 2025-06-25 16:27:23 |
±----------------------------------±--------------------+
1 row in set (0.000 sec)

obclient(root@ldf)[test]> delete from untab;
Query OK, 3 rows affected (0.003 sec)

obclient(root@ldf)[test]> select time_to_usec(CURRENT_TIMESTAMP()),CURRENT_TIMESTAMP();
±----------------------------------±--------------------+
| time_to_usec(CURRENT_TIMESTAMP()) | CURRENT_TIMESTAMP() |
±----------------------------------±--------------------+
| 1750840052000000 | 2025-06-25 16:27:32 |
±----------------------------------±--------------------+
1 row in set (0.000 sec)

obclient(root@ldf)[test]> select * from untab as of snapshot 1750840043000000;
ERROR 1412 (HY000): Unable to read data – Table definition has changed

这个闪回失败，说是表结构改变，表结构没动过。这个是社区版这个版本的bug吗

淇铭 · 2025 年6 月 25 日 18:30

提供一下操作的这个时间的observer.log的日志信息
查一下这个看看是否有ddl的变更操作
select o.tenant_id, o.gmt_create, o.database_id, d.database_name, o.table_id, t.table_name, o.operation_type, o.ddl_stmt_str
from oceanbase.__all_ddl_operation o left join oceanbase.__all_database d on (o.database_id=d.database_id)
left join oceanbase.__all_table t on (o.table_id=t.table_id)
where o.ddl_stmt_str != ‘’ and t.table_name = ‘t1’
order by o.gmt_create ;

dddddba · 2025 年6 月 25 日 19:38

插眼

shigp · 2025 年6 月 26 日 08:27

问题有解决吗？

dfant · 2025 年6 月 26 日 09:50

老师我又复现了一把，日志在附件。
ob.tar.gz (18.7 MB)

obclient(root@ldf)[test]> select * from untab;
Empty set (0.000 sec)

obclient(root@ldf)[test]> select time_to_usec(CURRENT_TIMESTAMP()),CURRENT_TIMESTAMP();
±----------------------------------±--------------------+
| time_to_usec(CURRENT_TIMESTAMP()) | CURRENT_TIMESTAMP() |
±----------------------------------±--------------------+
| 1750902283000000 | 2025-06-26 09:44:43 |
±----------------------------------±--------------------+
1 row in set (0.001 sec)

obclient(root@ldf)[test]> insert into untab values(100,‘aa’);
Query OK, 1 row affected (0.005 sec)

obclient(root@ldf)[test]> insert into untab values(200,‘bb’);
Query OK, 1 row affected (0.001 sec)

obclient(root@ldf)[test]> select time_to_usec(CURRENT_TIMESTAMP()),CURRENT_TIMESTAMP();
±----------------------------------±--------------------+
| time_to_usec(CURRENT_TIMESTAMP()) | CURRENT_TIMESTAMP() |
±----------------------------------±--------------------+
| 1750902304000000 | 2025-06-26 09:45:04 |
±----------------------------------±--------------------+
1 row in set (0.000 sec)

obclient(root@ldf)[test]> select * from untab as of snapshot 1750902283000000;
ERROR 1412 (HY000): Unable to read data – Table definition has changed

#####DDL查询
obclient(root@ldf)[oceanbase]> select o.tenant_id, o.gmt_create, o.database_id, d.database_name, o.table_id, t.table_name, o.operation_type, o.ddl_stmt_str
→ from oceanbase.__all_ddl_operation o left join oceanbase.__all_database d on (o.database_id=d.database_id)
→ left join oceanbase.__all_table t on (o.table_id=t.table_id)
→ where o.ddl_stmt_str != ‘’ and t.table_name = ‘untab’
→ order by o.gmt_create ;
±----------±---------------------------±------------±--------------±---------±-----------±---------------±------------------------------------------+
| tenant_id | gmt_create | database_id | database_name | table_id | table_name | operation_type | ddl_stmt_str |
±----------±---------------------------±------------±--------------±---------±-----------±---------------±------------------------------------------+
| 0 | 2025-06-25 15:15:00.536201 | 500001 | test | 500056 | untab | 4 | create table untab(c1 int,c2 varchar(10)) |
±----------±---------------------------±------------±--------------±---------±-----------±---------------±------------------------------------------+
1 row in set (0.002 sec)

淇铭 · 2025 年6 月 26 日 16:25

show parameters like ‘%undo_retention%’ 查一下配置项

SHOW VARIABLES LIKE ‘%recyclebin%’; 这个变量查一下

dfant · 2025 年6 月 26 日 16:32

obclient(root@ldf)[test]> show parameters like ‘%undo%’;
±------±---------±--------------±---------±---------------±----------±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±--------±-------±--------±------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
±------±---------±--------------±---------±---------------±----------±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±--------±-------±--------±------------------+
| zone1 | observer | 192.168.96.12 | 2882 | undo_retention | NULL | 600 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE |
±------±---------±--------------±---------±---------------±----------±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±--------±-------±--------±------------------+
1 row in set (0.004 sec)