OBLOADER & OBDUMPER V4.3.3

OBLOADER & OBDUMPER V4.3.3 released in March 2025 aims to improve export speed and stability.

New features

• Improved export performance

  • The technical solution for querying the macroblock range during snapshot export is optimized, achieving a performance improvement of approximately three to four times in large table export scenarios.

  • The multi-thread management efficiency is optimized during export, achieving a performance improvement of about 5% in multi-table export scenarios.

• Accelerated metadata query

  For OceanBase Database V2.2.27 and earlier, operations related to querying table metadata are accelerated, with some scenarios achieving an improvement of up to 20 times.

• Optimized task startup

  Result paging for export queries and data export are optimized to run in parallel, resolving the issue of prolonged paging stage during large table export.

• Comments are added to all SQL statements executed during import and export, allowing you to identify the SQL source by using the SQL audit feature.

• A check item is added to prevent using the --block-size option together with the -f option when -f specifies a specific file for export.

Compatibility changes

• A confirmation prompt will appear when the --truncate-table or --delete-from-table option is executed, reminding you of potential risks. The --yes option is added for you to skip the confirmation, which facilitates integration with other O&M systems.

Bug fixes

1. Fixed the issue where a NullPointerException (NPE) is thrown when an existing object is imported.

2. Fixed the issue where exported stored procedures do not contain the SQL SECURITY characteristic.

3. Fixed the issue where a negative size error is reported when the size of an imported CSV file is an integral multiple of the --block-size value.

4. Fixed the issue where a schema export task fails due to exhaustion of connections in the database connection pool when too many tables are involved in the task.

5. Fixed the issue where the counting of the ignore and execute operations of the --truncate-table option is not continuous in logs.

6. Fixed the issue where parallel write fails to be enabled when the -f option specifies a specific file.

7. Fixed the issue where the performance of result paging for snapshot export queries significantly regresses compared to V3.x.

8. Fixed the issue where the --replace-data option is invalid when the --auto-column-mapping option is specified.

9. Fixed the issue where a file specified by the -f option is exported with two file name extensions.

10. Fixed the issue where no empty file is generated in the export directory when an empty table is exported in the ORC format with the --retain-empty-files option specified.