liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Argo - locks
    via GitHub by lbesnard
    ,
  • GitHub comment 497#284943865
    via GitHub by jonescc
    ,
  • Problem with PostgreSQL driver
    via by Jacobus,
    • liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:114) at anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iPostgresqlDbUpdate_1Process(ANMN_metadata_harvester.java:1393) at anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iUpdateIndex_2Process(ANMN_metadata_harvester.java:1091) at anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.runJobInTOS(ANMN_metadata_harvester.java:4012) at anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.main(ANMN_metadata_harvester.java:3840) Caused by: org.postgresql.util.PSQLException: ERROR: function getglobalattribute(bigint, unknown) does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 11 more

    Users with the same issue

    Unknown User
    Unknown User9 times, last one,
    Unknown visitor1 times, last one,
    silex
    silex6 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    90 more bugmates