search

dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.32k stars 539 forks source link

pgloader failed sqlite to postgresql migration (pgloader failed to find column) #1077

Open karippery opened 4 years ago

karippery commented 4 years ago

hello, i want to migrate sqlite database to postgresql. unfortunately i got strange error. i am using ubuntu 18.04

steps i follows:

1.cp /var/lib/dbconfig-common/sqlite3/redmine/instances/default/redmine_default /tmp/redmine_backupdb.sqlite3

2 gem install rack -v 1.4.5 sqlite3 pg taps

3 update Gemfile

  1. bundle install

  2. create a new postgresql database CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;

6 edit /etc/postgresql/10/main/pg_hba.conf

  # "local" is for Unix domain socket connections only
       local   all             all                                     trust
       local   all             all                                     peer
  1. edit database.yml
  development:
  adapter: postgresql
  encoding: unicode
  database: redmine
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  username: redmine
  password: Qwe12345!

test:
  adapter: postgresql
  database: redmine_test
  username: redmine
  password: Qwe12345!
  host: localhost

production:
  adapter: postgresql
  encoding: unicode
  database: redmine
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  username: redmine
  password: Qwe12345!
  host: localhost

8 migrate cd /usr/share/redmine rake db:migrate rake db:setup

  1. run pgloader

pgloader --with "data only" /tmp/redmine_backupdb.sqlite3 postgresql://redmine:"Qwe12345!"@localhost/redmine

Error i got 

2020-02-04T10:27:17.278000Z WARNING Failed to transform default value "NULL": junk in string "NULL"
2020-02-04T10:27:17.291000Z WARNING Failed to transform default value "NULL": junk in string "NULL"
KABOOM!
FATAL error: pgloader failed to find column "public"."issues"."sprint_id" in target table "\"public\".\"issues\""
An unhandled error condition has been signalled:
   pgloader failed to find column "public"."issues"."sprint_id" in target table "\"public\".\"issues\""

2020-02-04T10:27:17.892000Z WARNING Source column "public"."schema_migrations"."version" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"schema_migrations\""."version".
2020-02-04T10:27:17.892000Z WARNING Source column "public"."custom_fields_projects"."custom_field_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_fields_projects\""."custom_field_id".
2020-02-04T10:27:17.892000Z WARNING Source column "public"."custom_fields_projects"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_fields_projects\""."project_id".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_fields_trackers"."custom_field_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_fields_trackers\""."custom_field_id".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_fields_trackers"."tracker_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_fields_trackers\""."tracker_id".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_values"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_values\""."id".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_values"."customized_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"custom_values\""."customized_type".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_values"."customized_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_values\""."customized_id".
2020-02-04T10:27:17.893000Z WARNING Source column "public"."custom_values"."custom_field_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"custom_values\""."custom_field_id".
2020-02-04T10:27:17.894000Z WARNING Source column "public"."news"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"news\""."id".
2020-02-04T10:27:17.894000Z WARNING Source column "public"."news"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"news\""."project_id".
2020-02-04T10:27:17.894000Z WARNING Source column "public"."news"."title" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"news\""."title".
2020-02-04T10:27:17.894000Z WARNING Source column "public"."news"."summary" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"news\""."summary".
2020-02-04T10:27:17.895000Z WARNING Source column "public"."news"."author_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"news\""."author_id".
2020-02-04T10:27:17.895000Z WARNING Source column "public"."news"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"news\""."created_on".
2020-02-04T10:27:17.895000Z WARNING Source column "public"."news"."comments_count" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"news\""."comments_count".
2020-02-04T10:27:17.895000Z WARNING Source column "public"."tokens"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"tokens\""."id".
2020-02-04T10:27:17.896000Z WARNING Source column "public"."tokens"."user_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"tokens\""."user_id".
2020-02-04T10:27:17.896000Z WARNING Source column "public"."tokens"."action" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"tokens\""."action".
2020-02-04T10:27:17.896000Z WARNING Source column "public"."tokens"."value" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"tokens\""."value".
2020-02-04T10:27:17.896000Z WARNING Source column "public"."tokens"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"tokens\""."created_on".
2020-02-04T10:27:17.896000Z WARNING Source column "public"."tokens"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"tokens\""."updated_on".
2020-02-04T10:27:17.897000Z WARNING Source column "public"."workflows"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"workflows\""."id".
2020-02-04T10:27:17.897000Z WARNING Source column "public"."workflows"."tracker_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"workflows\""."tracker_id".
2020-02-04T10:27:17.897000Z WARNING Source column "public"."workflows"."old_status_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"workflows\""."old_status_id".
2020-02-04T10:27:17.897000Z WARNING Source column "public"."workflows"."new_status_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"workflows\""."new_status_id".
2020-02-04T10:27:17.897000Z WARNING Source column "public"."workflows"."role_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"workflows\""."role_id".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."workflows"."type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"workflows\""."type".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."workflows"."field_name" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"workflows\""."field_name".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."workflows"."rule" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"workflows\""."rule".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."journals"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"journals\""."id".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."journals"."journalized_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"journals\""."journalized_id".
2020-02-04T10:27:17.898000Z WARNING Source column "public"."journals"."journalized_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"journals\""."journalized_type".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."journals"."user_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"journals\""."user_id".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."journals"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"journals\""."created_on".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."comments"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"comments\""."id".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."comments"."commented_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"comments\""."commented_type".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."comments"."commented_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"comments\""."commented_id".
2020-02-04T10:27:17.899000Z WARNING Source column "public"."comments"."author_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"comments\""."author_id".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."comments"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"comments\""."created_on".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."comments"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"comments\""."updated_on".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."wikis"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wikis\""."id".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."wikis"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wikis\""."project_id".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."wikis"."start_page" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"wikis\""."start_page".
2020-02-04T10:27:17.900000Z WARNING Source column "public"."wikis"."status" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wikis\""."status".
2020-02-04T10:27:17.901000Z WARNING Source column "public"."wiki_pages"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wiki_pages\""."id".
2020-02-04T10:27:17.901000Z WARNING Source column "public"."wiki_pages"."wiki_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wiki_pages\""."wiki_id".
2020-02-04T10:27:17.901000Z WARNING Source column "public"."wiki_pages"."title" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"wiki_pages\""."title".
2020-02-04T10:27:17.901000Z WARNING Source column "public"."wiki_pages"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"wiki_pages\""."created_on".
2020-02-04T10:27:17.901000Z WARNING Source column "public"."wiki_pages"."parent_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"wiki_pages\""."parent_id".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."watchers"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"watchers\""."id".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."watchers"."watchable_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"watchers\""."watchable_type".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."watchers"."watchable_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"watchers\""."watchable_id".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."watchers"."user_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"watchers\""."user_id".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."changesets_issues"."changeset_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changesets_issues\""."changeset_id".
2020-02-04T10:27:17.902000Z WARNING Source column "public"."changesets_issues"."issue_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changesets_issues\""."issue_id".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."issue_relations"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issue_relations\""."id".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."issue_relations"."issue_from_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issue_relations\""."issue_from_id".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."issue_relations"."issue_to_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issue_relations\""."issue_to_id".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."issue_relations"."relation_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"issue_relations\""."relation_type".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."issue_relations"."delay" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issue_relations\""."delay".
2020-02-04T10:27:17.903000Z WARNING Source column "public"."messages"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."id".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."board_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."board_id".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."parent_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."parent_id".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."subject" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"messages\""."subject".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."author_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."author_id".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."replies_count" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."replies_count".
2020-02-04T10:27:17.904000Z WARNING Source column "public"."messages"."last_reply_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."last_reply_id".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."messages"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"messages\""."created_on".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."messages"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"messages\""."updated_on".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."messages"."sticky" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"messages\""."sticky".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."enabled_modules"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"enabled_modules\""."id".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."enabled_modules"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"enabled_modules\""."project_id".
2020-02-04T10:27:17.905000Z WARNING Source column "public"."enabled_modules"."name" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"enabled_modules\""."name".
2020-02-04T10:27:17.906000Z WARNING Source column "public"."projects_trackers"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"projects_trackers\""."project_id".
2020-02-04T10:27:17.906000Z WARNING Source column "public"."projects_trackers"."tracker_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"projects_trackers\""."tracker_id".
2020-02-04T10:27:17.906000Z WARNING Source column "public"."versions"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"versions\""."id".
2020-02-04T10:27:17.906000Z WARNING Source column "public"."versions"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"versions\""."project_id".
2020-02-04T10:27:17.906000Z WARNING Source column "public"."versions"."name" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"versions\""."name".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."description" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"versions\""."description".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"versions\""."created_on".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"versions\""."updated_on".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."wiki_page_title" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"versions\""."wiki_page_title".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."status" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"versions\""."status".
2020-02-04T10:27:17.907000Z WARNING Source column "public"."versions"."sharing" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"versions\""."sharing".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changesets\""."id".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."repository_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changesets\""."repository_id".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."revision" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changesets\""."revision".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."committer" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changesets\""."committer".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."committed_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"changesets\""."committed_on".
2020-02-04T10:27:17.908000Z WARNING Source column "public"."changesets"."scmid" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changesets\""."scmid".
2020-02-04T10:27:17.909000Z WARNING Source column "public"."changesets"."user_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changesets\""."user_id".
2020-02-04T10:27:17.909000Z WARNING Source column "public"."open_id_authentication_associations"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"open_id_authentication_associations\""."id".
2020-02-04T10:27:17.909000Z WARNING Source column "public"."open_id_authentication_associations"."issued" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"open_id_authentication_associations\""."issued".
2020-02-04T10:27:17.909000Z WARNING Source column "public"."open_id_authentication_associations"."lifetime" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"open_id_authentication_associations\""."lifetime".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_associations"."handle" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"open_id_authentication_associations\""."handle".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_associations"."assoc_type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"open_id_authentication_associations\""."assoc_type".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_nonces"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"open_id_authentication_nonces\""."id".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_nonces"."timestamp" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"open_id_authentication_nonces\""."timestamp".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_nonces"."server_url" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"open_id_authentication_nonces\""."server_url".
2020-02-04T10:27:17.910000Z WARNING Source column "public"."open_id_authentication_nonces"."salt" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"open_id_authentication_nonces\""."salt".
2020-02-04T10:27:17.911000Z WARNING Source column "public"."settings"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"settings\""."id".
2020-02-04T10:27:17.911000Z WARNING Source column "public"."settings"."name" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"settings\""."name".
2020-02-04T10:27:17.911000Z WARNING Source column "public"."settings"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"settings\""."updated_on".
2020-02-04T10:27:17.911000Z WARNING Source column "public"."member_roles"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"member_roles\""."id".
2020-02-04T10:27:17.911000Z WARNING Source column "public"."member_roles"."member_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"member_roles\""."member_id".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."member_roles"."role_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"member_roles\""."role_id".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."member_roles"."inherited_from" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"member_roles\""."inherited_from".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."groups_users"."group_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"groups_users\""."group_id".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."groups_users"."user_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"groups_users\""."user_id".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."changes"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changes\""."id".
2020-02-04T10:27:17.912000Z WARNING Source column "public"."changes"."changeset_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changes\""."changeset_id".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."action" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changes\""."action".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."path" is casted to type "text(255)" which is not the same as "text", the type of current target database column "\"public\""."\"changes\""."path".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."from_path" is casted to type "text(255)" which is not the same as "text", the type of current target database column "\"public\""."\"changes\""."from_path".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."from_revision" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changes\""."from_revision".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."revision" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changes\""."revision".
2020-02-04T10:27:17.913000Z WARNING Source column "public"."changes"."branch" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"changes\""."branch".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"repositories\""."id".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"repositories\""."project_id".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."url" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."url".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."login" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."login".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."password" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."password".
2020-02-04T10:27:17.914000Z WARNING Source column "public"."repositories"."root_url" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."root_url".
2020-02-04T10:27:17.915000Z WARNING Source column "public"."repositories"."type" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."type".
2020-02-04T10:27:17.915000Z WARNING Source column "public"."repositories"."path_encoding" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."path_encoding".
2020-02-04T10:27:17.915000Z WARNING Source column "public"."repositories"."log_encoding" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."log_encoding".
2020-02-04T10:27:17.915000Z WARNING Source column "public"."repositories"."identifier" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"repositories\""."identifier".
2020-02-04T10:27:17.915000Z WARNING Source column "public"."repositories"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"repositories\""."created_on".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"journal_details\""."id".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."journal_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"journal_details\""."journal_id".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."property" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"journal_details\""."property".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."prop_key" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"journal_details\""."prop_key".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."old_value" is casted to type "text(255)" which is not the same as "text", the type of current target database column "\"public\""."\"journal_details\""."old_value".
2020-02-04T10:27:17.916000Z WARNING Source column "public"."journal_details"."value" is casted to type "text(255)" which is not the same as "text", the type of current target database column "\"public\""."\"journal_details\""."value".
2020-02-04T10:27:17.917000Z WARNING Source column "public"."changeset_parents"."changeset_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changeset_parents\""."changeset_id".
2020-02-04T10:27:17.917000Z WARNING Source column "public"."changeset_parents"."parent_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"changeset_parents\""."parent_id".
2020-02-04T10:27:17.917000Z WARNING Source column "public"."issues"."id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."id".
2020-02-04T10:27:17.917000Z WARNING Source column "public"."issues"."tracker_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."tracker_id".
2020-02-04T10:27:17.917000Z WARNING Source column "public"."issues"."project_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."project_id".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."subject" is casted to type "text" which is not the same as "character varying", the type of current target database column "\"public\""."\"issues\""."subject".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."category_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."category_id".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."status_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."status_id".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."assigned_to_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."assigned_to_id".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."priority_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."priority_id".
2020-02-04T10:27:17.918000Z WARNING Source column "public"."issues"."fixed_version_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."fixed_version_id".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."author_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."author_id".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."lock_version" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."lock_version".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."created_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"issues\""."created_on".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."updated_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"issues\""."updated_on".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."done_ratio" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."done_ratio".
2020-02-04T10:27:17.919000Z WARNING Source column "public"."issues"."estimated_hours" is casted to type "float" which is not the same as "double precision", the type of current target database column "\"public\""."\"issues\""."estimated_hours".
2020-02-04T10:27:17.920000Z WARNING Source column "public"."issues"."parent_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."parent_id".
2020-02-04T10:27:17.920000Z WARNING Source column "public"."issues"."root_id" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."root_id".
2020-02-04T10:27:17.920000Z WARNING Source column "public"."issues"."lft" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."lft".
2020-02-04T10:27:17.920000Z WARNING Source column "public"."issues"."rgt" is casted to type "bigint" which is not the same as "integer", the type of current target database column "\"public\""."\"issues\""."rgt".
2020-02-04T10:27:17.920000Z WARNING Source column "public"."issues"."closed_on" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "\"public\""."\"issues\""."closed_on".

What I am doing here?

pgloader failed to find column "public"."issues"."sprint_id" in target table "\"public\".\"issues\""

Waiting for the monitor thread to complete.
dimitri commented 4 years ago

Can you share your redline SQLite database for me to reproduce the error locally and maybe fix it then? Thanks