View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006343 | SymmetricDS | Bug | public | 2024-04-12 16:45 | 2024-04-19 15:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.5 | Fixed in Version | 3.15.5 | ||
| Summary | 0006343: DbCompare on Postgres not using cursor with fetch size | ||||
| Description | When running dbcompare on PostgreSQL database, it is using the default behavior of querying all rows into the result set instead of using a more memory efficient backend cursor. Comparison of a large table can cause an OutOfMemoryError. Postgres requires autocommt to be off and the fetch size to be set before it will use a backend cursor. The code is using the dirty SQL template that was initialized with the default SQL template instead of the Postgres SQL template that has the setting requiresAutoCommitFalseToSetFetchSize set to true. | ||||
| Tags | dbcompare, dialect: postgresql | ||||
|
SymmetricDS: 3.15 518ef2db 2024-04-12 16:46:14 Details Diff |
0006343: DbCompare on Postgres not using cursor with fetch size |
Affected Issues 0006343 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/redshift/RedshiftDatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-04-12 16:45 | elong | New Issue | |
| 2024-04-12 16:45 | elong | Status | new => assigned |
| 2024-04-12 16:45 | elong | Assigned To | => elong |
| 2024-04-12 16:45 | elong | Tag Attached: dbcompare | |
| 2024-04-12 16:45 | elong | Tag Attached: dialect: postgresql | |
| 2024-04-12 16:46 | elong | Status | assigned => resolved |
| 2024-04-12 16:46 | elong | Resolution | open => fixed |
| 2024-04-12 16:46 | elong | Fixed in Version | => 3.15.5 |
| 2024-04-19 15:46 | admin | Changeset attached | => SymmetricDS 3.15 518ef2db |
| 2024-04-23 16:58 | admin | Status | resolved => closed |