After upgrading to v1.8.1.365, I am getting this error:
2:46 PM : Starting service Continua version 1.8.1.365.
2:46 PM : Initialising service
2:46 PM : Migrating database
2:46 PM : Could not initialise database: An error occurred executing the following sql: CREATE TABLE public.core_securityentity (id uuid NOT NULL, CONSTRAINT PK_core_securityentity PRIMARY KEY (id)) The error was ERROR: 42P07: relation “core_securityentity” already exists Check the eventlog for more info.
I haven’t been able to find any details on the error. Please advise.
This database table has not been changed since the first build of Continua. It appears that the server is running a full database migration from start. The only way we can see that this would happen is if the versioninfo table in the database has been cleared or deleted.
Can you connect to the database and check the contents of this table? You can access the database using %ProgramFiles%\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin\pgAdmin3.exe. You can find the connection details in %ProgramFiles%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config under configuration -> hibernate-configuration -> session-factory -> property name=“connection.connection_string”.
Which version did you upgrade from and which installation options did you use? There should be as installation log in the %temp% folder e.g. C:\Users\username\AppData\Local\Temp\Setup Log YYYY-MM-DD #XXX.txt, If you send this support@finalbuilder.com then we can investigate what happened.
To get the server back up and running, you’ll need to restore the database from a backup. The installer creates a backup in C:\ProgramData\VSoft\ContinuaCI named something like Continua_PG_0_0_YYYYMMDD-XXXX.sq. See Backing up the Continua database for details on how to restore the database. Once restored, check that there are rows in the versioninfo table. It should contain a row for each database migration. The number will depend on which version was previously installed. There are 160 database migrations altogether in the latest version. If the table is empty, then you will either need to find a backup where this table has rows. If you tell us your previous Continua version number we can send you the data to populate this table.