No such file or directory: "load"
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!