Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
karippery opened this issue Feb 4, 2020 · 1 comment

Comments

@karippery
Copy link

@karippery karippery commented Feb 4, 2020

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
Copy link
Owner

@dimitri dimitri commented Feb 11, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.