Oracle takes too long to process a simple .csv file

[tati-qalified]

Search first

• I searched and no similar issues were found

Description

Discovered because of #5599
When trying to use loadData with Oracle, a .csv file with 4 lines takes around 3 minutes to run.
It might have something to do with the fact that it's trying to insert values to a column with autoIncrement, but in that case I would expect a validation failure or some other warning.

Steps To Reproduce

changelog.xml:

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:pro="http://www.liquibase.org/xml/ns/pro"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
    http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd ">

<changeSet author="your.name" id="1::emptyTable">
    <createTable tableName="populated">
        <column name="id" type="int" autoIncrement="true">
            <constraints primaryKey="true" nullable="false"/>
        </column>
        <column name="first" type="varchar(50)"/>
        <column name="last" type="varchar(50)"/>
    </createTable>
</changeSet>

<changeSet author="your.name" id="2::dataForTable" labels="data">
    <loadData file="names.csv" tableName="populated"/>
</changeSet>

</databaseChangeLog>

names.csv:

id,first,last
0,john,doe
1,eric,smith
2,cat,jones

.jfr file:
liquibase-2024_03_21T12_28_58_522.zip

Expected/Desired Behavior

Either a warning/error if there's something wrong, or a faster runtime.

Liquibase Version

4.26.0

Database Vendor & Version

Oracle Free 23.2 slim

Liquibase Integration

CLI

Liquibase Extensions

OS and/or Infrastructure Type/Provider

Windows

Additional Context

No response

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[kevin-atx]

Hi @tati-qalified - could you re-run the job with the java profiler enabled and attache the resulting profile? It will make it easier for development to quickly see the issue.

[tati-qalified]

@kevin-atx the file is attached before the "Expected/Desired Behavior" section