Skip to content

"Failed to recognize schema" possible during pg_upgrade #352

Closed

Description

@jcflack

pg_upgrade sets check_function_bodies to off, which should prevent function validation from doing anything more than basic checks. But the function validator in PL/Java 1.6 can incorrectly trigger the check for the contents of the sqlj schema, which during pg_upgrade may not be completely populated at the time, leading to a "Failed to recognize schema of PL/Java installation" error and a failed upgrade.

Workaround:

Add --new-options '-c pljava.enable=off' to the pg_upgrade command. The server log will then contain warnings about PL/Java being disabled, but the upgrade will complete.

Fix:

A future release should fix this.

Activity

  1. jcflack commented on Oct 10, 2021

    @jcflack
    ContributorAuthor

    Believed resolved in 1.6.3.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions