pgloader failed sqlite to postgresql FATAL error: pgloader failed to find column "public"
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 4. `bundle install` 5. `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 ``` 7. 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 9. 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. ```
issue