Building latest source: database update breaks

[onnozweers]

Dear dCache devs,

I wanted to test something with the latest master snapshot, but I found out that a dcache database update did not seem happy:

[root@badger14 ~/dcache]# dcache database update
PinManager@central1Domain: 
Starting Liquibase at 16:55:41 using Java 21.0.8 (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
Database is up to date, no changesets to execute

UPDATE SUMMARY
Run:                          0
Previously run:               5
Filtered out:                 0
-------------------------------
Total change sets:            5

Liquibase command 'update' was executed successfully.
SpaceManager@central1Domain: 
Starting Liquibase at 16:55:42 using Java 21.0.8 (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
Running Changeset: diskCacheV111/services/space/db/00-liquibase-fixes.xml::0.2::tigran

UPDATE SUMMARY
Run:                          1
Previously run:               0
Filtered out:                 0
-------------------------------
Total change sets:            1

Liquibase: Update has been successful. Rows affected: 1
Liquibase command 'update' was executed successfully.
Starting Liquibase at 16:55:43 using Java 21.0.8 (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
Running Changeset: diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann
[2025-12-17 16:55:44] SEVERE [liquibase.changelog] ChangeSet diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann encountered an exception.
liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:497)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:185)
	at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:776)
	at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:126)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:70)
	at liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:131)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:120)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:257)
	at liquibase.Scope.child(Scope.java:261)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
	at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)
	at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
	at liquibase.command.CommandScope.execute(CommandScope.java:220)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
	at picocli.CommandLine.executeUserObject(CommandLine.java:2045)
	at picocli.CommandLine.access$1500(CommandLine.java:148)
	at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2465)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2457)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2419)
	at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
	at picocli.CommandLine$RunLast.execute(CommandLine.java:2421)
	at picocli.CommandLine.execute(CommandLine.java:2174)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:404)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:379)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:376)
	at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:97)
Caused by: org.postgresql.util.PSQLException: ERROR: column "freespaceinbytes" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:491)
	... 46 more


UPDATE SUMMARY
Run:                          0
Previously run:              38
Filtered out:                 6
-------------------------------
Total change sets:           46


FILTERED CHANGE SETS SUMMARY
DBMS mismatch:                6

ERROR: Exception Details
ERROR: Exception Primary Class:  PSQLException
ERROR: Exception Primary Reason:  ERROR: column "freespaceinbytes" does not exist
ERROR: Exception Primary Source:  PostgreSQL 17.6
[2025-12-17 16:55:44] SEVERE [liquibase.integration] Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.command.CommandScope.execute(CommandScope.java:258)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
	at picocli.CommandLine.executeUserObject(CommandLine.java:2045)
	at picocli.CommandLine.access$1500(CommandLine.java:148)
	at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2465)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2457)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2419)
	at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
	at picocli.CommandLine$RunLast.execute(CommandLine.java:2421)
	at picocli.CommandLine.execute(CommandLine.java:2174)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:404)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:379)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:376)
	at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:97)
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:148)
	at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)
	at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
	at liquibase.command.CommandScope.execute(CommandScope.java:220)
	... 18 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:820)
	at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:126)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:70)
	at liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:131)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:120)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:257)
	at liquibase.Scope.child(Scope.java:261)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
	... 26 more
Caused by: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:497)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:185)
	at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:776)
	... 41 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "freespaceinbytes" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:491)
	... 46 more


Unexpected error running Liquibase: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]

liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.command.CommandScope.execute(CommandScope.java:258)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
	at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
	at picocli.CommandLine.executeUserObject(CommandLine.java:2045)
	at picocli.CommandLine.access$1500(CommandLine.java:148)
	at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2465)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2457)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2419)
	at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
	at picocli.CommandLine$RunLast.execute(CommandLine.java:2421)
	at picocli.CommandLine.execute(CommandLine.java:2174)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:404)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:379)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:176)
	at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:376)
	at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:97)
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:148)
	at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)
	at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
	at liquibase.command.CommandScope.execute(CommandScope.java:220)
	... 18 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset diskCacheV111/services/space/db/spacemanager.changelog-2.9.xml::1.1::behrmann:
     Reason: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:820)
	at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:126)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:70)
	at liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:131)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:120)
	at liquibase.Scope.lambda$child$0(Scope.java:191)
	at liquibase.Scope.child(Scope.java:200)
	at liquibase.Scope.child(Scope.java:190)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:257)
	at liquibase.Scope.child(Scope.java:261)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
	... 26 more
Caused by: liquibase.exception.DatabaseException: ERROR: column "freespaceinbytes" does not exist [Failed SQL: (0) ALTER TABLE public.srmlinkgroup RENAME COLUMN freespaceinbytes TO availablespaceinbytes]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:497)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:185)
	at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:776)
	... 41 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "freespaceinbytes" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:491)
	... 46 more

I upgraded from snapshot 868690a (built on 2025-10-17) to snapshot 646f462.

I thought you might want to know.

Let me know if you want additional information.

Cheers,
Onno

[onnozweers]

Oh it seems the field is already called availablespaceinbytes:

[root@badger14 ~]# psql -U postgres spacemanager -c '\d srmlinkgroup'
                                            Table "public.srmlinkgroup"
        Column         |           Type           | Collation | Nullable |                 Default                  
-----------------------+--------------------------+-----------+----------+------------------------------------------
 id                    | bigint                   |           | not null | nextval('srmlinkgroup_id_seq'::regclass)
 name                  | character varying(32672) |           | not null | 
 availablespaceinbytes | bigint                   |           | not null | 
 lastupdatetime        | bigint                   |           |          | 
 onlineallowed         | integer                  |           |          | 
 nearlineallowed       | integer                  |           |          | 
 replicaallowed        | integer                  |           |          | 
 outputallowed         | integer                  |           |          | 
 custodialallowed      | integer                  |           |          | 
 reservedspaceinbytes  | bigint                   |           | not null | 
Indexes:
    "srmlinkgroup_pkey" PRIMARY KEY, btree (id)
    "srmlinkgroup_name_unique" UNIQUE CONSTRAINT, btree (name)
Referenced by:
    TABLE "srmlinkgroupvos" CONSTRAINT "fk_srmlinkgroupvos_l" FOREIGN KEY (linkgroupid) REFERENCES srmlinkgroup(id) ON DELETE RESTRICT
    TABLE "srmspace" CONSTRAINT "fk_srmspace_l" FOREIGN KEY (linkgroupid) REFERENCES srmlinkgroup(id)

Does that mean I can ignore the error and just continue?

[DmitryLitvintsev]

Onno,

I am afraid you can't ignore this. You can try renaming availablespaceinbytes -> freespaceinbytes and restart (to let it successfully rename it back)

Dmitry

[DmitryLitvintsev]

to follow up:

is this fresh install from scratch or an upgrade of an existing install?

[onnozweers]

Hi Dmitry,

It is an upgrade. We regularly build the latest master snapshot on this test server and upgrade it. We always do a dcache database update after upgrading the RPM. So I have no idea where this database schema mismatch comes from.

Thanks for your suggestion to try renaming availablespaceinbytes to freespaceinbytes. Will do that soon.

Kind regards,
Onno

[vokac]

I "fixed" my testbed by replacing spacemanager databasechangelog table with dump from clean dCache 11.1.5 installation

# dump spacemanager public.databasechangelog from clean dCache 11.1.5 installation
[root@dcache-clean-11.1.5 ~]# su - postgres -c "pg_dump -d spacemanager -t public.databasechangelog --data-only -f /tmp/dump.spacemanager.sql"
# replace spacemanager public.databasechangelog after 11.1.4 -> 11.1.5 upgrade
[root@dcache-upgraded ~]# su - postgres -c "psql -d spacemanager -c 'TRUNCATE TABLE public.databasechangelog RESTART IDENTITY CASCADE;'"
[root@dcache-upgraded ~]# su - postgres -c "psql -d spacemanager < /tmp/dump.spacemanager.sql"