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

GitHub | lbesnard | 10 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    getglobalattribute psql function not exist

    GitHub | 10 months ago | lbesnard
    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
  2. 0

    wfs:imos:aatams_biologging_shearwater_data is not working

    GitHub | 2 years ago | danfruehauf
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date"
  3. 0

    Argo - locks

    GitHub | 3 weeks ago | lbesnard
    liquibase.exception.DatabaseException: Error executing SQL DROP VIEW IF EXISTS profile_summary CASCADE: ERROR: deadlock detected Detail: Process 23694 waits for AccessExclusiveLock on relation 49097486 of database 16415; blocked by process 23825. Process 23825 waits for AccessShareLock on relation 49097476 of database 16415; blocked by process 23694. Hint: See server log for query details.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Talend: Write data to PostgreSQL database error

    Stack Overflow | 6 years ago | Tjekkles
    org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
  6. 0

    erro: MappedDouble is not mapped to 'double precision' datatype in PostgreSQL?

    Google Groups | 8 years ago | JanWillem Tulp
    org.postgresql.util.PSQLException: ERROR: type "double" does not exist

  1. silex 6 times, last 5 months ago
11 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: function getglobalattribute(bigint, unknown) does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
    6 frames
  3. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    4. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
    5. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
    7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
    8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
    9. liquibase.Liquibase.update(Liquibase.java:114)
    9 frames
  4. anmn_metadata.anmn_metadata_harvester_0_1
    ANMN_metadata_harvester.main
    1. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iPostgresqlDbUpdate_1Process(ANMN_metadata_harvester.java:1393)
    2. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iUpdateIndex_2Process(ANMN_metadata_harvester.java:1091)
    3. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.runJobInTOS(ANMN_metadata_harvester.java:4012)
    4. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.main(ANMN_metadata_harvester.java:3840)
    4 frames