【 使用环境 】测试环境
【 OB or 其他组件 】obdumper
【 使用版本 】 4.2.0-RELEASE
【问题描述】在执行db2数据库导出时,发现会将db1数据库的tablegroup也导出。这样是否合理?
【复现路径】
-- 在数据库里面,可以看到tg_test12属于db1数据库
obclient [db2]> show tablegroups like 'tg_test12';
+-----------------+------------+---------------+
| Tablegroup_name | Table_name | Database_name |
+-----------------+------------+---------------+
| tg_test12 | test01 | db1 |
| tg_test12 | test02 | db1 |
+-----------------+------------+---------------+
2 rows in set (0.007 sec)
-- 执行db2数据库的导出,发现将db1下面的tg_test12也导出了
[root@ob-single bin]# ./obdumper --host=192.168.10.91 --port=2883 --cluster=oceanbasetest --tenant=tenant_test01 --database=d b2 --user=lijiaman --password=lijiaman --all --ddl --sql --retain-empty-files --weak-read --thread 4 --block-size 1024MB --fi le-path='/root/backup'
2023-05-18 16:11:46 [INFO] Parsed args:
[--ddl] true
[--sql] true
[--file-path] /root/backup
[--host] 192.168.10.91
[--port] 2883
[--user] lijiaman
[--tenant] tenant_test01
[--cluster] oceanbasetest
[--password] ******
[--database] db2
[--sys-user] root
[--all] true
[--weak-read] true
[--retain-empty-files] true
[--block-size] 1024MB
2023-05-18 16:11:47 [INFO] Load jdbc driver class: "org.mariadb.jdbc.Driver" finished
2023-05-18 16:11:47 [WARN] No VIEW are exist in the schema: "db2"
2023-05-18 16:11:47 [WARN] No SEQUENCE are exist in the schema: "db2"
2023-05-18 16:11:47 [WARN] No FUNCTION are exist in the schema: "db2"
2023-05-18 16:11:47 [WARN] No PROCEDURE are exist in the schema: "db2"
2023-05-18 16:11:47 [INFO] Generate 2 dump tasks finished. Total Elapsed: 4.852 ms
2023-05-18 16:11:47 [INFO] Start 3 schema dump threads for 2 dump tasks finished.
2023-05-18 16:11:47 [INFO] Return the latest compatible version: 4.1.0.0 -> 4.0.0.0
2023-05-18 16:11:47 [INFO] Return the latest compatible version: 4.1.0.0 -> 4.0.0.0
2023-05-18 16:11:47 [INFO] Dump create objects success. DbType: OBMYSQL Version: 4.1.0.0
2023-05-18 16:11:47 [INFO] Dump create objects success. DbType: OBMYSQL Version: 4.1.0.0
2023-05-18 16:11:47 [INFO] ObMySql(4.1.0.0) is older than 4.0 ? false
2023-05-18 16:11:47 [INFO] ObMySql(4.1.0.0) is older than 4.0 ? false
2023-05-18 16:11:47 [INFO] Load meta/obmysql/obmysql14x.xml, meta/obmysql/obmysql22x.xml, meta/obmysql/obmysql2271.xml, meta/ obmysql/obmysql3230.xml, meta/obmysql/obmysql40x.xml successed
2023-05-18 16:11:47 [INFO] Load meta/obmysql/obmysql14x.xml, meta/obmysql/obmysql22x.xml, meta/obmysql/obmysql2271.xml, meta/ obmysql/obmysql3230.xml, meta/obmysql/obmysql40x.xml successed
2023-05-18 16:11:47 [INFO] Query 0 dependencies elapsed 44.96 ms
2023-05-18 16:11:47 [INFO] Query 0 dependencies elapsed 6.806 ms
2023-05-18 16:11:47 [INFO] Query 1 tablegroups elapsed 17.55 ms
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTablespaceMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireSynonymMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTypeMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTypeBodyMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquirePackageMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquirePackageBodyMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTriggerMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireDatabaseLinkMapping()
2023-05-18 16:11:47 [INFO] Dump [TABLEGROUP] tg_test12 to "/root/backup/data/db2/TABLEGROUP/tg_test12-schema.sql " finished
2023-05-18 16:11:47 [INFO] No.1 It has dumped 1 TABLE_GROUPs finished. Remain: 0
2023-05-18 16:11:47 [INFO] Total dumped 1 TABLE_GROUPs finished. Elapsed: 171.2 ms
2023-05-18 16:11:47 [INFO] Dump the ddl of schema: "db2" finished
2023-05-18 16:11:47 [INFO] Query table: "db2_t1" attr finished. Remain: 0
2023-05-18 16:11:47 [INFO] Query 1 tables elapsed 262.3 ms
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTablespaceMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireSynonymMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTypeMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTypeBodyMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquirePackageMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquirePackageBodyMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireTriggerMapping()
2023-05-18 16:11:47 [WARN] c.o.t.l.s.o.ObMySqlDatabase does't implement acquireDatabaseLinkMapping()
2023-05-18 16:11:47 [INFO] Dump [TABLE] db2_t1 to "/root/backup/data/db2/TABLE/db2_t1-schema.sql " finished
2023-05-18 16:11:47 [INFO] No.1 It has dumped 1 TABLEs finished. Remain: 0
2023-05-18 16:11:47 [INFO] Total dumped 1 TABLEs finished. Elapsed: 393.8 ms
2023-05-18 16:11:47 [INFO] Dump the ddl of schema: "db2" finished
2023-05-18 16:11:48 [INFO] Close connection count: 24 of the DataSource. Key: BIZ
2023-05-18 16:11:48 [INFO] Shutdown task context finished
2023-05-18 16:11:48 [INFO] ---------- Finished Tasks: 2 Running Tasks: 0 Progress: 100.00% ----------
2023-05-18 16:11:48 [INFO]
All Dump Tasks Finished:
----------------------------------------------------------------------------------------------------------------------------
No.# | Type | Name | Count | Status
----------------------------------------------------------------------------------------------------------------------------
1 | TABLE | db2_t1 | 1 -> 1 | SUCCESS
2 | TABLEGROUP | tg_test12 | 1 -> 1 | SUCCESS
----------------------------------------------------------------------------------------------------------------------------
Total Count: 2 End Time: 2023-05-18 16:11:48
2023-05-18 16:11:48 [INFO] Dump schema finished. Total Elapsed: 1.064 s
2023-05-18 16:11:48 [INFO] Query partition names for table: "db2_t1" success. (Non-partitioned)
2023-05-18 16:11:48 [INFO] Try to query unique keys for table: "db2_t1".... (But no-primary constraints).
2023-05-18 16:11:48 [INFO] Query unique keys for table: "db2_t1" success. (No-unique constraints). Elapsed: 6.936 ms
2023-05-18 16:11:48 [INFO] Query table entry for table: "db2_t1" success. Remain: 0. Elapsed: 1.666 ms
2023-05-18 16:11:48 [INFO] Query all table entries success. Total: 1. Elapsed: 48.35 ms
2023-05-18 16:11:48 [INFO] Split rows for non-partitioned table(without primary key): "db2_t1" success. Ranges: 1
2023-05-18 16:11:48 [INFO] Generate 1 dump tasks finished. Total Elapsed: 21.32 ms
2023-05-18 16:11:48 [INFO] Start 4 record dump threads for 1 dump tasks finished
2023-05-18 16:11:48 [INFO] Dump 1 rows db2.db2_t1 to "/root/backup/data/db2/TABLE/db2_t1.1.*.sql" finished
2023-05-18 16:11:49 [INFO] Close connection count: 5 of the DataSource. Key: BIZ
2023-05-18 16:11:49 [INFO] Shutdown task context finished
2023-05-18 16:11:49 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ----------
2023-05-18 16:11:49 [INFO]
All Dump Tasks Finished:
----------------------------------------------------------------------------------------------------------------------------
No.# | Type | Name | Count | Status
----------------------------------------------------------------------------------------------------------------------------
1 | TABLE | db2_t1 | 1 | SUCCESS
----------------------------------------------------------------------------------------------------------------------------
Total Count: 1 End Time: 2023-05-18 16:11:49
2023-05-18 16:11:49 [INFO] Dump record finished. Total Elapsed: 1.129 s
2023-05-18 16:11:49 [INFO] System exit 0
-- 操作系统文件
[root@ob-single backup]# ls
data logs
[root@ob-single backup]# cd data/
[root@ob-single data]# ls
db2 dump.ckpt
[root@ob-single data]# tree
.
├── db2
│ ├── TABLE
│ │ ├── db2_t1.1.0.sql
│ │ └── db2_t1-schema.sql
│ └── TABLEGROUP
│ └── tg_test12-schema.sql
└── dump.ckpt
3 directories, 4 files
【附件】