Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • pleroma pleroma
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 669
    • Issues 669
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 101
    • Merge requests 101
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Artifacts
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
    • Model experiments
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • PleromaPleroma
  • pleromapleroma
  • Issues
  • #2553

2.3.0 - Update error when running ./bin/pleroma_ctl migrate

23:32:49.404 [info] == Migrated 20201016205220 in 0.0s

23:32:49.417 [info] == Running 20201217172858 Pleroma.Repo.Migrations.DataMigrationProlongOAuthTokensValidUntil.up/0 forward

23:32:49.427 [info] execute "update oauth_tokens set valid_until = '2121-02-06 23:32:49.424875'"

23:32:49.653 [info] == Migrated 20201217172858 in 0.2s

23:32:49.673 [info] == Running 20201231185546 Pleroma.Repo.Migrations.ConfirmLoggedInUsers.up/0 forward

23:32:49.705 [info] == Migrated 20201231185546 in 0.0s

23:32:49.717 [info] == Running 20210113225652 Pleroma.Repo.Migrations.DeprecatePublicEndpoint.up/0 forward

23:32:49.745 [info] == Migrated 20210113225652 in 0.0s

23:32:49.756 [info] == Running 20210115205649 Pleroma.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward

23:32:49.784 [info] alter table public.oban_jobs

23:32:49.802 [info] execute "DO $$\nDECLARE\n  version int;\n  already bool;\nBEGIN\n  SELECT current_setting('server_version_num')::int INTO version;\n  SELECT '{cancelled}' <@ enum_range(NULL::public.oban_job_state)::text[] INTO already;\n\n  IF already THEN\n    RETURN;\n  ELSIF version >= 120000 THEN\n    ALTER TYPE public.oban_job_state ADD VALUE IF NOT EXISTS 'cancelled';\n  ELSE\n    ALTER TYPE public.oban_job_state RENAME TO _oban_job_state;\n\n    CREATE TYPE public.oban_job_state AS ENUM (\n      'available',\n      'scheduled',\n      'executing',\n      'retryable',\n      'completed',\n      'discarded',\n      'cancelled'\n    );\n\n    ALTER TABLE public.oban_jobs RENAME column state TO _state;\n    ALTER TABLE public.oban_jobs ADD state public.oban_job_state NOT NULL default 'available';\n\n    UPDATE public.oban_jobs SET state = _state::text::public.oban_job_state;\n\n    ALTER TABLE public.oban_jobs DROP column _state;\n    DROP TYPE public._oban_job_state;\n  END IF;\nEND$$;\n"

23:32:49.806 [info] create index if not exists public.oban_jobs_queue_state_priority_scheduled_at_id_index

23:32:49.810 [info] execute "COMMENT ON TABLE public.oban_jobs IS '9'"

23:32:49.820 [info] == Migrated 20210115205649 in 0.0s

23:32:49.835 [info] == Running 20210121080964 Pleroma.Repo.Migrations.AddDefaultTextSearchConfig.change/0 forward

23:32:49.835 [info] execute "DO $$\n    BEGIN\n    execute 'ALTER DATABASE '||current_database()||' SET default_text_search_config = ''english'' ';\n    END\n    $$;"
** (Postgrex.Error) ERROR 42601 (syntax_error) syntax error at or near "-"
    (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:593: Ecto.Adapters.SQL.raise_sql_call_error/1
    (elixir 1.10.3) lib/enum.ex:1396: Enum."-map/2-lists^map/1-0-"/2
    (ecto_sql 3.4.5) lib/ecto/adapters/sql.ex:686: Ecto.Adapters.SQL.execute_ddl/4
    (ecto_sql 3.4.5) lib/ecto/migration/runner.ex:343: Ecto.Migration.Runner.log_and_execute_ddl/3
    (ecto_sql 3.4.5) lib/ecto/migration/runner.ex:117: anonymous fn/6 in Ecto.Migration.Runner.flush/0
    (elixir 1.10.3) lib/enum.ex:2111: Enum."-reduce/3-lists^foldl/2-0-"/3
    (ecto_sql 3.4.5) lib/ecto/migration/runner.ex:116: Ecto.Migration.Runner.flush/0
    (stdlib 3.12.1) timer.erl:166: :timer.tc/1
Assignee
Assign to
Time tracking