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:

  1. Caused by: org.h2.jdbc.JdbcSQLNonTransientException: The database is read only; SQL statement:
  2. 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]
  3.     at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
  4.     at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
  5.     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.