SymmetricDS

Initial load gets arithmetic exception, numeric overflow, or string truncation

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.3.0
  • Fix Version/s: 2.4.0
  • Component/s: DB Dialect Interbase
  • Labels:
    None
  • Number of attachments :
    0

Description

During initial load, the following error occurs:

java.sql.SQLException: [interclient][interbase]arithmetic exception, numeric overflow, or string truncation

The problem happens when an Interbase table has multiple varchar/char columns that need wrapped with sym_escape() function. The amount of data in the columns seems to make a difference also. For example, more than 500 characters.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Eric Long added a comment -

It appears to be an issue with the sym_escape() function. It's defined as an external function that returns a cstring(32660). If it is defined as cstring(4096), the initial load works. The data capture is currently limited to 4096 characters per row on this platform already, so that seems fine for now.

Show
Eric Long added a comment - It appears to be an issue with the sym_escape() function. It's defined as an external function that returns a cstring(32660). If it is defined as cstring(4096), the initial load works. The data capture is currently limited to 4096 characters per row on this platform already, so that seems fine for now.
Hide
Permalink
Eric Long added a comment -

The issue ended up being that Interbase has a 64 KB limit on the size of a row in the result set. Each call to a user defined function uses up a portion of that buffer.

Show
Eric Long added a comment - The issue ended up being that Interbase has a 64 KB limit on the size of a row in the result set. Each call to a user defined function uses up a portion of that buffer.

People

  • Assignee:
    Unassigned
    Reporter:
    Eric Long
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: