View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004849 | SymmetricDS | Bug | public | 2021-02-24 14:02 | 2021-03-30 19:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.8 | Fixed in Version | 3.12.8 | ||
| Summary | 0004849: Firebird result set is closed after routing | ||||
| Description | When channel is set as "nontransactional" the router service gets a "result set is closed" at the end of routing. It tries to advance the cursor to the next row after it is already at the last row, and the Jaybird driver will throw an exception for that. Router service only logs the error, so data is still routed properly. ERROR [] [DataGapRouteReader] [server-router-reader-730] StackTraceKey.init [SqlException:1816645792] org.jumpmind.db.sql.SqlException: The result set is closed at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:313) at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:63) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:146) at org.jumpmind.symmetric.route.DataGapRouteReader.fillPeekAheadQueue(DataGapRouteReader.java:478) at org.jumpmind.symmetric.route.DataGapRouteReader.executeNonTransactional(DataGapRouteReader.java:250) at org.jumpmind.symmetric.route.DataGapRouteReader.execute(DataGapRouteReader.java:155) at org.jumpmind.symmetric.route.DataGapRouteReader.run(DataGapRouteReader.java:130) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: The result set is closed at org.firebirdsql.jdbc.AbstractResultSet.checkOpen(AbstractResultSet.java:297) at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:285) at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:360) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207) at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:132) ... 7 more | ||||
| Steps To Reproduce | - Setup replication on default channel - Change default channel to "nontransactional" - Make a change to replicate | ||||
| Tags | dialect: firebird | ||||
|
SymmetricDS: 3.12 08fa1bb3 2021-03-01 14:52:38 Details Diff |
0004849: Firebird result set is closed after routing |
Affected Issues 0004849 |
|
| mod - symmetric-client/src/main/resources/symmetric-modules.properties | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/sql/JdbcSqlReadCursor.java | Diff File | ||
|
SymmetricDS: 3.12 4ba04490 2021-03-01 14:53:08 Details Diff |
0004849: Firebird result set is closed after routing |
Affected Issues 0004849 |
|
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/SqlRunner.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/TabularResultLayout.java | Diff File | ||
|
SymmetricDS: 3.12 51a4aae1 2021-03-01 18:00:28 Details Diff |
0004849: Firebird result set is closed after routing |
Affected Issues 0004849 |
|
| mod - symmetric-jdbc/build.gradle | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-02-24 14:02 | elong | New Issue | |
| 2021-02-24 14:02 | elong | Status | new => assigned |
| 2021-02-24 14:02 | elong | Assigned To | => elong |
| 2021-02-24 14:02 | elong | Tag Attached: dialect: firebird | |
| 2021-03-01 14:53 | elong | Status | assigned => resolved |
| 2021-03-01 14:53 | elong | Resolution | open => fixed |
| 2021-03-01 14:53 | elong | Fixed in Version | => 3.12.8 |
| 2021-03-01 15:00 | admin | Changeset attached | => SymmetricDS 3.12 4ba04490 |
| 2021-03-01 15:00 | admin | Changeset attached | => SymmetricDS 3.12 08fa1bb3 |
| 2021-03-01 19:00 | admin | Changeset attached | => SymmetricDS 3.12 51a4aae1 |
| 2021-03-30 19:46 | admin | Status | resolved => closed |