pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

No such file or directory: "load"

Open kburchfiel opened this issue 4 years ago • 0 comments

Please provide the following information:

  • [ ] pgloader --version

    <3.6.1>
    
  • [ ] did you test a fresh compile from the source tree?

  • I installed it just today so I'm guessing the compile is the most recent one.

  • [ ] did you search for other similar issues?

  • Yes

  • [ ] how can I reproduce the bug?

I entered the following code into an instance of Ubuntu running on Windows:

pgloader load load_kb_database_partial.load

The contents of this file were as follows:

load database
     from sqlite://kb_database.db
     into postgres://[table within Amazon Postgres RDS]

 with include drop, create tables, create indexes, reset sequences
 
 including only table names like '%music%'
 
  set work_mem to '16MB', maintenance_work_mem to '512 MB';
  • [ ] pgloader output you obtain
2021-10-01T23:53:16.005000Z LOG pgloader version "3.6.1"
2021-10-01T23:53:16.006000Z ERROR Can not find file: "load"
2021-10-01T23:53:16.006000Z LOG Parsing commands from file #P"/mnt/c/Users/kburc/D1V1/Documents/load_kb_database_partial.load"
2021-10-01T23:53:16.402000Z LOG Migrating from #<SQLITE-CONNECTION sqlite:///mnt/c/Users/kburc/D1V1/Documents/kb_database.db {1006936623}>
2021-10-01T23:53:16.402000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://[table within Amazon PostgreSQL RDS]>
KABOOM!
2021-10-01T23:53:19.015000Z LOG report summary reset
FATAL error: No such file or directory: "load"
An unhandled error condition has been signalled:
   No such file or directory: "load"
  • [ ] data that is being loaded, if relevant

The data consists of around 120 short .mp3 samples of a public-domain song. The samples were loaded into a SQLite database as .blob files. This database also included images in .blob form, so I don't think the file format is the issue.

The original files can be found here: https://drive.google.com/drive/folders/1BtBkOqwOPBUP1xrnuX2Iq5oo7q_K6GQk?usp=sharing

I originally tried to load my entire SQLite database into Amazon; 3 tables were imported successfully, but pub_domain_music was not.

  • [ ] How the data is different from what you expected, if relevant

I expected that the pub_domain_music table of .blob flies would be loaded successfully, but this was not the case. I was surprised by the 'No such file or directory: 'load'" message.

Thank you in advance for your help!

kburchfiel avatar Oct 02 '21 00:10 kburchfiel