Closed
Description
Thanks for all the work for this migration tool, we are really hoping to add to our tools chest. I am trying to us migrate with redshift database and getting a strange error "pq: unexpected transaction status idle" when trying to run the simplest migration. I have tried running the SQL in my migrations file directly on redshift and that works fine. I have also tried pointing go-migrate to postgres database and that works well too. any pointers to make progress on this issue are greatly appreciated.
- migrate version - 3.4.0
- contents of migrations folder
- 00001_CREATE_FIRST_TABLE.down.sql (
DROP TABLE cities) - 00001_CREATE_FIRST_TABLE.up.sql (
CREATE TABLE cities( cityid integer not null, city varchar(100) not null, state char(2) not null))
- 00001_CREATE_FIRST_TABLE.down.sql (
- command - ./migrate -database redshift://user:pass@redshift.vpc.clypd.com:5439/go_migrate_test -path ./migrations -verbose up 1
- output error
2018/08/06 17:02:38 Start buffering 1/u CREATE_FIRST_TABLE
2018/08/06 17:02:39 error: transaction commit failed in line 0: (details: pq: unexpected transaction status idle)
please let me know if any more info is needed
Metadata
Metadata
Assignees
Labels
No labels