Skip to content

"Could not move file: The process cannot access the file because it is being used by another process." (works on retry) #55

@fdcastel

Description

@fdcastel

The Excel extension successfully converts .parquet files to .xlsx only about 50% of the time, alternating between successful and failed attempts:

PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
IO Error:
Could not move file: The process cannot access the file because it is being used by another process.

PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
IO Error:
Could not move file: The process cannot access the file because it is being used by another process.

PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
IO Error:
Could not move file: The process cannot access the file because it is being used by another process.

PS C:\> duckdb -box -c "INSTALL EXCEL; LOAD EXCEL; COPY (FROM read_parquet('/temp/input.parquet') LIMIT 50001) TO '/temp/output.xlsx' WITH (FORMAT xlsx, HEADER true);"
                       


PS C:\>duckdb --version
v1.3.1 (Ossivalis) 2063dda3e6

PS C:\>cmd /c ver
Microsoft Windows [Version 10.0.26100.4061]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions