I'm moving our Activiti applicaation to a lcoal Postgres instance. With a clean database I can connect and ACtiviti generates the appropriate tables but after the first run I get the following error attached.
INFO 7/28/15 12:06 PM:liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml::1::tijsrademakers: Successfully released change log lock 12:06:07,016 [localhost-startStop-1] WARN org.springframework.web.context.support.AnnotationConfigWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/activiti/conf/DatabaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:META-INF/liquibase/db-changelog-onpremise.xml::1::tijsrademakers: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE public.hibernate_sequences (sequence_name VARCHAR(255), sequence_next_hi_value INT): ERROR: relation "hibernate_sequences" already exists
Here's a list of the tables generated in the Postgres instance:
List of relations Schema | Name | Type | Owner ——–+————————-+———-+———- public | act_evt_log | table | activiti public | act_evt_log_log_nr__seq | sequence | activiti public | act_ge_bytearray | table | activiti public | act_ge_property | table | activiti public | act_hi_actinst | table | activiti public | act_hi_attachment | table | activiti public | act_hi_comment | table | activiti public | act_hi_detail | table | activiti public | act_hi_identitylink | table | activiti public | act_hi_procinst | table | activiti public | act_hi_taskinst | table | activiti public | act_hi_varinst | table | activiti public | act_id_group | table | activiti public | act_id_info | table | activiti public | act_id_membership | table | activiti public | act_id_user | table | activiti public | act_re_deployment | table | activiti public | act_re_model | table | activiti public | act_re_procdef | table | activiti public | act_ru_event_subscr | table | activiti public | act_ru_execution | table | activiti public | act_ru_identitylink | table | activiti public | act_ru_job | table | activiti public | act_ru_task | table | activiti public | act_ru_variable | table | activiti public | authority | table | activiti public | cluster_config | table | activiti public | databasechangelog | table | activiti public | databasechangeloglock | table | activiti public | hibernate_sequences | table | activiti public | master_config | table | activiti public | server_config | table | activiti public | user_authority | table | activiti public | user_info | table | activiti
It looks like Activiti already generated the correct tables. Do I have something mis-configured? From the docs I've configured the activti-app.properties and activiti-admin.properties like this in the tomcat/lib dir: