Enabling GoCD to use H2 Database

    Your query search resulted in no results.

    Enabling GoCD to use H2 Database


    GoCD installers ship with H2 database and no external configuration is required to use GoCD with H2 database.

    Troubleshooting

    Database is read-only

    You might see a message such as this, after upgrade, in the GoCD server logs:

    Caused by: org.h2.jdbc.JdbcSQLNonTransientException: The database is read only; SQL statement:
    UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '10.16.0.5 (10.16.0.5)', LOCKGRANTED = '2020-06-17 15:07:20.707' WHERE ID = 1 AND LOCKED = FALSE [90097-200]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
    	at org.h2.message.DbException.get(DbException.java:205)
    

    This can happen due to the H2 DB file (usually at /var/lib/go-server/db/h2db/cruise.mv.db on Linux) having the wrong permissions or ownership.