Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-6768

Casing breaks CDC | ignore and continue

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 25.10.3
    • 26.10.0
    • exasol-cdc
    • None
    • MXS-SPRINT-276, MXS-SPRINT-277

    Description

      Reproduced error

      2026-07-28 15:27:16   error  : ODBC: Failed to handle event TABLE_MAP_EVENT. STOPPING replication: --- ODBC Error Could not create table address ---\nSQL State: 42500\nNative Error: -6818256\nMessage: [Exasol][Exasol Driver]object "mariadb_exa_demo"."address" already exists (Session: 1871972799586828288)\nDo 
      

      this and it breaks CDC

      CREATE TABLE address (     id   INT PRIMARY KEY, city VARCHAR(50) );
      INSERT INTO address VALUES (1, 'Atlanta');
      CREATE TABLE ADDRESS (     id   INT PRIMARY KEY, city VARCHAR(50) );
      INSERT INTO ADDRESS VALUES (1, 'Southeast');
      

      Workaround:
      my.cnf
      lower_case_table_names=1

      Attachments

        Activity

          People

            nantti Niclas Antti
            allen.herrera Allen Herrera
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 1d
                1d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.5h Time Not Required
                0.5h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.