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

radarr pgloader docs arent' complete, throws errors #183

Closed
evanrich opened this issue Oct 12, 2022 · 1 comment
Closed

radarr pgloader docs arent' complete, throws errors #183

evanrich opened this issue Oct 12, 2022 · 1 comment

Comments

@evanrich
Copy link

evanrich commented Oct 12, 2022

trying to load the radarr.db file in using

load database
   from sqlite:///tmp/radarr.db
   into pgsql://radarr:radarr@localhost/radarr-main
   with quote identifiers, data only
  alter schema 'radarr' rename to 'public';

This throws a TON of errors:

2022-10-12T22:55:56.016000Z LOG pgloader version "3.6.7~devel"
2022-10-12T22:55:56.152002Z LOG Migrating from #<SQLITE-CONNECTION sqlite:///tmp/radarr.db {1007F76D23}>
2022-10-12T22:55:56.152002Z LOG Migrating into #<PGSQL-CONNECTION pgsql://radarr@192.168.1.128:5432/radarr-main {1007F779A3}>
2022-10-12T22:55:56.684003Z WARNING Source column "public"."Config"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Config"."Id".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."RootFolders"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."RootFolders"."Id".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."Metadata"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Metadata"."Id".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."Metadata"."\"Enable\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Metadata"."Enable".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."DownloadClients"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."DownloadClients"."Id".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."DownloadClients"."\"Enable\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DownloadClients"."Enable".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."DownloadClients"."\"Priority\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadClients"."Priority".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."DownloadClients"."\"RemoveCompletedDownloads\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DownloadClients"."RemoveCompletedDownloads".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."DownloadClients"."\"RemoveFailedDownloads\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DownloadClients"."RemoveFailedDownloads".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."RemotePathMappings"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."RemotePathMappings"."Id".
2022-10-12T22:55:56.684003Z WARNING Source column "public"."Restrictions"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Restrictions"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."DelayProfiles"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"EnableUsenet\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DelayProfiles"."EnableUsenet".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"EnableTorrent\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DelayProfiles"."EnableTorrent".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"PreferredProtocol\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DelayProfiles"."PreferredProtocol".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"UsenetDelay\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DelayProfiles"."UsenetDelay".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"TorrentDelay\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DelayProfiles"."TorrentDelay".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"Order\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DelayProfiles"."Order".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."DelayProfiles"."\"BypassIfHighestQuality\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."DelayProfiles"."BypassIfHighestQuality".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Users"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Users"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Tags"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Tags"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."QualityDefinitions"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."QualityDefinitions"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."QualityDefinitions"."\"Quality\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."QualityDefinitions"."Quality".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."QualityDefinitions"."\"MinSize\"" is casted to type "numeric" which is not the same as "double precision", the type of current target database column "public"."QualityDefinitions"."MinSize".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."QualityDefinitions"."\"MaxSize\"" is casted to type "numeric" which is not the same as "double precision", the type of current target database column "public"."QualityDefinitions"."MaxSize".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."QualityDefinitions"."\"PreferredSize\"" is casted to type "numeric" which is not the same as "double precision", the type of current target database column "public"."QualityDefinitions"."PreferredSize".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."ImportExclusions"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ImportExclusions"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."CustomFilters"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."CustomFilters"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Indexers"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"EnableRss\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Indexers"."EnableRss".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"EnableAutomaticSearch\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Indexers"."EnableAutomaticSearch".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"EnableInteractiveSearch\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Indexers"."EnableInteractiveSearch".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"Priority\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Indexers"."Priority".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Indexers"."\"DownloadClientId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Indexers"."DownloadClientId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Notifications"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnGrab\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnGrab".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnDownload\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnDownload".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnUpgrade\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnUpgrade".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnRename\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnRename".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnHealthIssue\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnHealthIssue".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"IncludeHealthWarnings\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."IncludeHealthWarnings".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnMovieDelete\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnMovieDelete".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnMovieFileDelete\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnMovieFileDelete".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnMovieFileDeleteForUpgrade\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnMovieFileDeleteForUpgrade".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnApplicationUpdate\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnApplicationUpdate".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Notifications"."\"OnMovieAdded\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Notifications"."OnMovieAdded".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Profiles"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"Cutoff\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Profiles"."Cutoff".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"Language\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Profiles"."Language".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"UpgradeAllowed\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Profiles"."UpgradeAllowed".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"MinFormatScore\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Profiles"."MinFormatScore".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Profiles"."\"CutoffFormatScore\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Profiles"."CutoffFormatScore".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."NamingConfig"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."NamingConfig"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."NamingConfig"."\"MultiEpisodeStyle\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."NamingConfig"."MultiEpisodeStyle".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."NamingConfig"."\"ReplaceIllegalCharacters\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."NamingConfig"."ReplaceIllegalCharacters".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."NamingConfig"."\"ColonReplacementFormat\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."NamingConfig"."ColonReplacementFormat".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."NamingConfig"."\"RenameMovies\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."NamingConfig"."RenameMovies".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."CustomFormats"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."CustomFormats"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."CustomFormats"."\"IncludeCustomFormatWhenRenaming\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."CustomFormats"."IncludeCustomFormatWhenRenaming".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."AlternativeTitles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."AlternativeTitles"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."AlternativeTitles"."\"MovieMetadataId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."AlternativeTitles"."MovieMetadataId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Credits"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Credits"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Credits"."\"PersonTmdbId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Credits"."PersonTmdbId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Credits"."\"Order\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Credits"."Order".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Credits"."\"Type\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Credits"."Type".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."Credits"."\"MovieMetadataId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Credits"."MovieMetadataId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."MovieTranslations"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."MovieTranslations"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."MovieTranslations"."\"Language\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieTranslations"."Language".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."MovieTranslations"."\"MovieMetadataId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieTranslations"."MovieMetadataId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."ImportListMovies"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ImportListMovies"."Id".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."ImportListMovies"."\"ListId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportListMovies"."ListId".
2022-10-12T22:55:56.688003Z WARNING Source column "public"."ImportListMovies"."\"MovieMetadataId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportListMovies"."MovieMetadataId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ImportLists"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"Enabled\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."ImportLists"."Enabled".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"EnableAuto\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."ImportLists"."EnableAuto".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"ProfileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportLists"."ProfileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"MinimumAvailability\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportLists"."MinimumAvailability".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"SearchOnAdd\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."ImportLists"."SearchOnAdd".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportLists"."\"Monitor\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportLists"."Monitor".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Blocklist"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Blocklist"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Blocklist"."\"Protocol\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Blocklist"."Protocol".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Blocklist"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Blocklist"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Blocklist"."\"IndexerFlags\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Blocklist"."IndexerFlags".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Collections"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"TmdbId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Collections"."TmdbId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"QualityProfileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Collections"."QualityProfileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"MinimumAvailability\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Collections"."MinimumAvailability".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"SearchOnAdd\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Collections"."SearchOnAdd".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Collections"."\"Monitored\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Collections"."Monitored".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Commands"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Commands"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Commands"."\"Priority\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Commands"."Priority".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Commands"."\"Status\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Commands"."Status".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Commands"."\"Trigger\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Commands"."Trigger".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadClientStatus"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."DownloadClientStatus"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadClientStatus"."\"ProviderId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadClientStatus"."ProviderId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadClientStatus"."\"EscalationLevel\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadClientStatus"."EscalationLevel".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"EventType\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."EventType".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"Protocol\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."Protocol".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"IndexerId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."IndexerId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."DownloadHistory"."\"DownloadClientId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."DownloadHistory"."DownloadClientId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ExtraFiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ExtraFiles"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ExtraFiles"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ExtraFiles"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ExtraFiles"."\"MovieFileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ExtraFiles"."MovieFileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."History"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."History"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."History"."\"EventType\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."History"."EventType".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."History"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."History"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportListStatus"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ImportListStatus"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportListStatus"."\"ProviderId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportListStatus"."ProviderId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ImportListStatus"."\"EscalationLevel\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ImportListStatus"."EscalationLevel".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."IndexerStatus"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."IndexerStatus"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."IndexerStatus"."\"ProviderId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."IndexerStatus"."ProviderId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."IndexerStatus"."\"EscalationLevel\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."IndexerStatus"."EscalationLevel".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MetadataFiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."MetadataFiles"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MetadataFiles"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MetadataFiles"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MetadataFiles"."\"Type\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MetadataFiles"."Type".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MetadataFiles"."\"MovieFileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MetadataFiles"."MovieFileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieFiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."MovieFiles"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieFiles"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieFiles"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieFiles"."\"IndexerFlags\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieFiles"."IndexerFlags".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"TmdbId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."TmdbId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"OriginalLanguage\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."OriginalLanguage".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"Status\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."Status".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"Runtime\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."Runtime".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"Year\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."Year".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"SecondaryYear\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."SecondaryYear".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"Popularity\"" is casted to type "numeric" which is not the same as "real", the type of current target database column "public"."MovieMetadata"."Popularity".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."MovieMetadata"."\"CollectionTmdbId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."MovieMetadata"."CollectionTmdbId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."Movies"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"Monitored\"" is casted to type "bigint" which is not the same as "boolean", the type of current target database column "public"."Movies"."Monitored".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"ProfileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Movies"."ProfileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"MovieFileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Movies"."MovieFileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"MinimumAvailability\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Movies"."MinimumAvailability".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."Movies"."\"MovieMetadataId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."Movies"."MovieMetadataId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."PendingReleases"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."PendingReleases"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."PendingReleases"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."PendingReleases"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."PendingReleases"."\"Reason\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."PendingReleases"."Reason".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ScheduledTasks"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."ScheduledTasks"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."ScheduledTasks"."\"Interval\"" is casted to type "numeric" which is not the same as "double precision", the type of current target database column "public"."ScheduledTasks"."Interval".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."SubtitleFiles"."\"Id\"" is casted to type "bigserial" which is not the same as "integer", the type of current target database column "public"."SubtitleFiles"."Id".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."SubtitleFiles"."\"MovieId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."SubtitleFiles"."MovieId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."SubtitleFiles"."\"MovieFileId\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."SubtitleFiles"."MovieFileId".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."SubtitleFiles"."\"Language\"" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."SubtitleFiles"."Language".
2022-10-12T22:55:56.692003Z WARNING Source column "public"."VersionInfo"."\"Description\"" is casted to type "text" which is not the same as "character varying", the type of current target database column "public"."VersionInfo"."Description".
2022-10-12T22:55:58.808011Z ERROR Database error 23505: duplicate key value violates unique constraint "PK_ScheduledTasks"
DETAIL: Key ("Id")=(3) already exists.
CONTEXT: COPY ScheduledTasks, line 1
2022-10-12T22:55:58.880011Z ERROR Database error 23505: duplicate key value violates unique constraint "UC_Version"
DETAIL: Key ("Version")=(1) already exists.
CONTEXT: COPY VersionInfo, line 1
KABOOM!
UNDEFINED-COLUMN: Database error 42703: column ""Id"" of relation "ImportLists" does not exist
CONTEXT: PL/pgSQL function inline_code_block line 6 at FOR over SELECT rows
QUERY:
DO $$
DECLARE
  n integer := 0;
  r record;
BEGIN
  FOR r in
       SELECT 'select '
               || trim(trailing ')'
                  from replace(pg_get_expr(d.adbin, d.adrelid),
                               'nextval', 'setval'))
               || ', (select greatest(max(' || quote_ident(a.attname) || '), (select seqmin from pg_sequence where seqrelid = ('''
               || pg_get_serial_sequence(quote_ident(nspname) || '.' || quote_ident(relname), quote_ident(a.attname)) || ''')::regclass limit 1), 1) from only '
               || quote_ident(nspname) || '.' || quote_ident(relname) || '));' as sql
         FROM pg_class c
              JOIN pg_namespace n on n.oid = c.relnamespace
              JOIN pg_attribute a on a.attrelid = c.oid
              JOIN pg_attrdef d on d.adrelid = a.attrelid
                                 and d.adnum = a.attnum
                                 and a.atthasdef
        WHERE relkind = 'r' and a.attnum > 0
              and pg_get_expr(d.adbin, d.adrelid) ~ '^nextval'
              and c.oid in (select oid from reloids)
  LOOP
    n := n + 1;
    EXECUTE r.sql;
  END LOOP;

  PERFORM pg_notify('seqs', n::text);
END;
$$;
An unhandled error condition has been signalled:
   Database error 42703: column ""Id"" of relation "ImportLists" does not exist
CONTEXT: PL/pgSQL function inline_code_block line 6 at FOR over SELECT rows
QUERY:
DO $$
DECLARE
  n integer := 0;
  r record;
BEGIN
  FOR r in
       SELECT 'select '
               || trim(trailing ')'
                  from replace(pg_get_expr(d.adbin, d.adrelid),
                               'nextval', 'setval'))
               || ', (select greatest(max(' || quote_ident(a.attname) || '), (select seqmin from pg_sequence where seqrelid = ('''
               || pg_get_serial_sequence(quote_ident(nspname) || '.' || quote_ident(relname), quote_ident(a.attname)) || ''')::regclass limit 1), 1) from only '
               || quote_ident(nspname) || '.' || quote_ident(relname) || '));' as sql
         FROM pg_class c
              JOIN pg_namespace n on n.oid = c.relnamespace
              JOIN pg_attribute a on a.attrelid = c.oid
              JOIN pg_attrdef d on d.adrelid = a.attrelid
                                 and d.adnum = a.attnum
                                 and a.atthasdef
        WHERE relkind = 'r' and a.attnum > 0
              and pg_get_expr(d.adbin, d.adrelid) ~ '^nextval'
              and c.oid in (select oid from reloids)
  LOOP
    n := n + 1;
    EXECUTE r.sql;
  END LOOP;

  PERFORM pg_notify('seqs', n::text);
END;
$$;



2022-10-12T22:55:59.964015Z ERROR Database error 42703: column ""Id"" of relation "ImportLists" does not exist
CONTEXT: PL/pgSQL function inline_code_block line 6 at FOR over SELECT rows
QUERY:
DO $$
DECLARE
  n integer := 0;
  r record;
BEGIN
  FOR r in
       SELECT 'select '
               || trim(trailing ')'
                  from replace(pg_get_expr(d.adbin, d.adrelid),
                               'nextval', 'setval'))
               || ', (select greatest(max(' || quote_ident(a.attname) || '), (select seqmin from pg_sequence where seqrelid = ('''
               || pg_get_serial_sequence(quote_ident(nspname) || '.' || quote_ident(relname), quote_ident(a.attname)) || ''')::regclass limit 1), 1) from only '
               || quote_ident(nspname) || '.' || quote_ident(relname) || '));' as sql
         FROM pg_class c
              JOIN pg_namespace n on n.oid = c.relnamespace
              JOIN pg_attribute a on a.attrelid = c.oid
              JOIN pg_attrdef d on d.adrelid = a.attrelid
                                 and d.adnum = a.attnum
                                 and a.atthasdef
        WHERE relkind = 'r' and a.attnum > 0
              and pg_get_expr(d.adbin, d.adrelid) ~ '^nextval'
              and c.oid in (select oid from reloids)
  LOOP
    n := n + 1;
    EXECUTE r.sql;
  END LOOP;

  PERFORM pg_notify('seqs', n::text);
END;
$$;

What I am doing here?

Database error 42703: column ""Id"" of relation "ImportLists" does not exist
CONTEXT: PL/pgSQL function inline_code_block line 6 at FOR over SELECT rows
QUERY:
DO $$
DECLARE
  n integer := 0;
  r record;
BEGIN
  FOR r in
       SELECT 'select '
               || trim(trailing ')'
                  from replace(pg_get_expr(d.adbin, d.adrelid),
                               'nextval', 'setval'))
               || ', (select greatest(max(' || quote_ident(a.attname) || '), (select seqmin from pg_sequence where seqrelid = ('''
               || pg_get_serial_sequence(quote_ident(nspname) || '.' || quote_ident(relname), quote_ident(a.attname)) || ''')::regclass limit 1), 1) from only '
               || quote_ident(nspname) || '.' || quote_ident(relname) || '));' as sql
         FROM pg_class c
              JOIN pg_namespace n on n.oid = c.relnamespace
              JOIN pg_attribute a on a.attrelid = c.oid
              JOIN pg_attrdef d on d.adrelid = a.attrelid
                                 and d.adnum = a.attnum
                                 and a.atthasdef
        WHERE relkind = 'r' and a.attnum > 0
              and pg_get_expr(d.adbin, d.adrelid) ~ '^nextval'
              and c.oid in (select oid from reloids)
  LOOP
    n := n + 1;
    EXECUTE r.sql;
  END LOOP;

  PERFORM pg_notify('seqs', n::text);
END;
$$;

I'm using pgloader 3.6.7 to do this. I've tried every permutation of data only, etc, can't get it to work

AB#3897

@bakerboy448
Copy link
Collaborator

Wiki GitHub issues are not for support

Please use the discord or Reddit for support for the *arr app

@bakerboy448 bakerboy448 closed this as not planned Won't fix, can't repro, duplicate, stale Oct 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants