Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40843

DuckDB: Appender init error/corruption on INSERT IGNORE into partition

    XMLWordPrintable

Details

    • Can result in data loss

    Description

      Testcase is MTR/CLI compatible.

      --source include/have_partition.inc
      INSTALL SONAME 'ha_duckdb';
      CREATE TABLE t (c INT KEY) ENGINE=DuckDB PARTITION BY HASH(c) (PARTITION p1,PARTITION p2);
      INSERT IGNORE INTO t SET c=1;
      

      Leads to:

      CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Debug, Clang 22.1.8-20260622) Build 18/08/2026

      13.1.0-dbg>INSERT IGNORE INTO t SET c=1;
      ERROR 1296 (HY000): Got error 168 'Catalog Error: Table with name t does not exist!
      Did you mean "information_schema.tables"?' from DuckDB
      

      And

      CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Debug, Clang 22.1.8-20260622) Build 18/08/2026

      2026-08-19 20:51:35 4 [ERROR] Invalid (old?) table or database name 't#P#p1'
      2026-08-19 20:51:35 4 [ERROR] Invalid (old?) table or database name 't#P#p2'
      2026-08-19 20:51:35 4 [ERROR] DuckDB: Appender init error: {"exception_type":"Catalog","exception_message":"Table \".test.t\" could not be found"}
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  180826  8f00e6caca633c783140db86d3a48a96de67cf38  No bug found                  
      CS  10.11  opt  180826  8f00e6caca633c783140db86d3a48a96de67cf38  No bug found                  
      CS  11.4   dbg  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  No bug found                  
      CS  11.4   opt  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  No bug found                  
      CS  11.8   dbg  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  11.8   opt  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  12.3   dbg  180826  add63991988734383c5e942de2a19c6c45f511f7  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  12.3   opt  180826  add63991988734383c5e942de2a19c6c45f511f7  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  13.0   dbg  180826  a848493c6fe031f23606144420c1ca1e467cbd81  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  13.0   opt  180826  a848493c6fe031f23606144420c1ca1e467cbd81  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  13.1   dbg  180826  da18481158c81ca94689702073c3e04aad85a6a3  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      CS  13.1   opt  180826  da18481158c81ca94689702073c3e04aad85a6a3  DUCKDB_ERROR|Appender init error: {"exception_type":"Catalog","exception_message":"Table X could not be found"}
      ES  10.6   dbg  180826  fcecb2620f25965723d640decede7c018bcb1dcc  No bug found                  
      ES  10.6   opt  180826  fcecb2620f25965723d640decede7c018bcb1dcc  No bug found                  
      ES  11.4   dbg  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  No bug found                  
      ES  11.4   opt  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  No bug found                  
      ES  11.8   dbg  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  No bug found                  
      ES  11.8   opt  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  No bug found                  
      ES  12.3   dbg  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  No bug found                  
      ES  12.3   opt  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  No bug found                   
      

      Attachments

        Activity

          People

            drrtuy Roman
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 40m
                40m

                Git Integration

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