Database pg_depend update failes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • scs_it_team
    Junior Member
    • Nov 2026
    • 1

    #1

    Database pg_depend update failes

    Upgrading from 10.0.12 to 10.1.1 fails due less permissions.

    espocrm.log:
    ERROR: (0) Failed to rebuild database schema. Rebuild database early-rebuild error.
    [object] (RuntimeException(code: 0): Rebuild database early-rebuild error. at /var/www/espocrm/application/Espo/Core/Utils/Database/Schema/SchemaManager.php:163)
    [previous exception] [object] (RuntimeException(code: 0): An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for table pg_depend
    ...
    ...

    postgresql.log:
    espocrmdbuser@espocrmdb ERROR: permission denied for table pg_depend
    espocrmdbuser@espocrmdb CONTEXT: SQL statement "UPDATE pg_depend

    What I tried to check the permissions on Postgresql:
    postgres=# \c espocrmdb espocrmdbuser
    You are now connected to database "espocrmdb" as user "espocrmdbuser".
    espocrmdb=> SELECT has_table_privilege('espocrmdbuser', 'pg_catalog.pg_depend', 'SELECT');
    has_table_privilege
    ---------------------
    t​

    espocrmdb=> SELECT * FROM pg_catalog.pg_depend LIMIT 1;
    classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
    ---------+-------+----------+------------+----------+-------------+---------
    1247 | 12002 | 0 | 1259 | 12000 | 0 | i​


    Any hints?
Working...