MogDB 3.0.5

1. Version Description

MogDB 3.0.5 is a patch version of MogDB 3.0.0, which is released on July 20 of 2023. It mainly involves bug fixes based on MogDB 3.0.4, and incorporate fixed defects in openGauss 3.0.3.

2. Fixed Defects

1. Fixed the occasional memory leak issue when calling autonomous transactions in a stored procedure.
2. Fixed the probabilistic hashtable overflow issue in the plglsql package.
3. Fixed the coredump issue that may occur during database startup under low memory conditions.
4. Fixed the problem in rewind where using the old values when aligning source and target data file sizes.
5. Disabled the invocation of SSE4 instructions during COPY operation.
6. Added feedback response to the main database when performing gs_probackup backups to prevent potential hangs.
7. Fixed the coredump issue when the elastic_search_ip_addr parameter corresponds to a service that is not started.
8. Fixed the possible query abnormality when using national cryptographic algorithms in full encryption mode.
9. Fixed the issue in NasWrite where memory was still accessed after being freed.
10. Enabled support for using "tid" as a column name for data tables in non-cstore storage engines.
11. Fixed a misjudgment of instance node names in job scheduling that could lead to instance coredumps.
12. Fixed the issue where the execution time was always greater than 10 seconds during switchover due to percentile influence.
13. Fixed the coredump issue that may occur when executing scheduled tasks with plugins.
14. Fixed the problem in logical replication where incremental data was not returned for tables without a primary key.
15. Fixed the statement_history table inflation caused by the "close" statement.
16. Fixed the memory leak issue in xgboost.
17. Fixed the issue where "alter system set" may not take effect.
18. Fixed the memory leak issue when using cursors and fetching under codegen.
19. Fixed the failure when initializing the database with gbk character set.
20. Fixed the coredump issue that may occur when querying a view that references another view that has been deleted.
21. Fixed the failure in logical import/export for gbk/gb18030 character sets under specific character situations.
22. Fixed the issue in gs_package where duplicate package names may occur when repeatedly replacing the package body.
23. Fixed the operation and judgment issues of the pg_repack plugin under different table storage methods.
24. Fixed the potential coredump issue when running orafce and whale plugins together.
25. Fixed the problem where the whale plugin could not be installed in a gbk character set database.
26. Fixed the database coredump issue that may occur due to incorrect usage of the merge syntax.
27. Fixed the uninitialized grpc lock issue.
28. Fixed the risky pointer access issue in session_options.

3. Incorporate Fixed Defects in openGauss 3.0.3

1. Synchronized LsnMarker is no longer required during parallel playback, reducing synchronization overhead.
2. During gs_probackup backup, the wal_sender_timeout is now extended to 30 minutes by default.
3. Fixed the issue where the main database gs_ctl stop fails when full checkpoint is enabled and there are non-asynchronous standby databases.
4. Fixed the issue in gs_ctl restore where missing "break" caused problems in executing the copy operation.
5. Modified the role of basebackup to SNDROLE_PRIMARY_BUILDSTANDBY.
6. Fixed the issue with gs_probackup, where it always failed after 10 minutes in specific situations.
7. Fixed the problem in standby build, where incremental build was always performed as a full build.
8. Fixed the issue where gs_dump and gs_restore fail after upgrading from a lower version.
9. Fixed the coredump issue in streaming disaster recovery scenarios.
10. Fixed the execution failure when SQL statements contain both window functions and subqueries.
11. Fixed the issue where group by cube with duplicate fields results in incorrect output.
12. Fixed the coredump issue caused by querying system domain types using the vec mode preference.
13. Fixed the bug in list partition display.
14. Fixed the issue where the first parameter is used for configuration in the conf file with multiple parameters.
15. Optimized the process of parsing and obtaining bool type values.
16. Optimized the method for obtaining current_time.
17. Fixed the problem where inappropriate debug logs are reported at the warning level.
18. Fixed the error that occurs when referencing other packages within a package.
19. Optimized the handling process of const values in postgres_fdw.
20. Optimized the response mechanism of walsender.
21. Fixed the slot name length check issue in the pg_recvlogical program.
22. Fixed the potential parallel modification issue when modifying the configuration file through database commands.
23. Fixed the issue where the pcd file reopening process could fail during free.