-
Technical Work
-
Resolution: Won't Do
-
Minor
-
1.1.0
-
None
When a new Gateway is being installed the ./configure_database.sh install command generate the following error
liquibase-tasks.ant.xml:123: liquibase.exception.LockException: liquibase.exception.JDBCException: Error executing SQL CREATE TABLE public.databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
[.....]
Caused by: org.postgresql.util.PSQLException: ERROR: schema "public" does not exist
To fix this error the liquibase-task.ant.xml line
<target name="install" depends="echo, compile" description="New database installation" >
should be changed to
<target name="install" depends="echo, clean, compile" description="New database installation" >.
A temporary workaround is to call
./configure_database.sh clean
./configure_database.sh install
liquibase-tasks.ant.xml:123: liquibase.exception.LockException: liquibase.exception.JDBCException: Error executing SQL CREATE TABLE public.databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
[.....]
Caused by: org.postgresql.util.PSQLException: ERROR: schema "public" does not exist
To fix this error the liquibase-task.ant.xml line
<target name="install" depends="echo, compile" description="New database installation" >
should be changed to
<target name="install" depends="echo, clean, compile" description="New database installation" >.
A temporary workaround is to call
./configure_database.sh clean
./configure_database.sh install