topic Re: Primary Key violation in ACT_HI_ACTINST in Alfresco Archive

Primary Key violation in ACT_HI_ACTINST

distantworker — Mon, 11 Aug 2014 06:43:53 GMT

Hello,We're having a repeatible PK violation on the ACT_HI_ACTINST table running Activiti-5.11, MySQL embedded in a Spring 3.2 application that uses connection pooling. I've searched hi and lo and can't find anyone with a similar problem. If we clean out the entire activiti db and run fresh, it's f

Re: Primary Key violation in ACT_HI_ACTINST

distantworker — Mon, 11 Aug 2014 06:48:55 GMT

Re: Primary Key violation in ACT_HI_ACTINST

frederikherema1 — Mon, 11 Aug 2014 09:26:47 GMT

Do you have multiple engines running against the same database?

Re: Primary Key violation in ACT_HI_ACTINST

distantworker — Mon, 11 Aug 2014 14:55:38 GMT

Thanks for the response. If multiple engines means multiple instances of our application, the answer is no. We do have two dataSources, one for our application and one for activiti. Our configuration seems fairly straight forward (included below).

Could it be a problem that our application database is using

org.apache.commons.dbcp.BasicDataSource

and activiti is using

org.springframework.jdbc.datasource.SimpleDriverDataSource

?

Best, DW

————— This is the activiti conf ————–
<code>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

<bean id="dataSourceActiviti" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
    <property name="driverClass" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/activiti?autoReconnect=true" />
    <property name="username" value="activiti" />
    <property name="password" value="secret" />
</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSourceActiviti" />
</bean>

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
    <property name="dataSource" ref="dataSourceActiviti" />
    <property name="transactionManager" ref="transactionManager" />
    <property name="databaseType" value="mysql" />
    <property name="databaseSchemaUpdate" value="true" />
    <property name="jobExecutorActivate" value="false" />
</bean>

<bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
    <property name="processEngineConfiguration" ref="processEngineConfiguration" />
</bean>

<bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" />
<bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" />
<bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" />
<bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" />
<bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" />

</beans>
</code>

————— This is the regular application db conf ————–
<code>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/pe?autoReconnect=true" />
    <property name="username" value="projectecon" />
    <property name="password" value="secret" />
</bean>
</code>

Re: Primary Key violation in ACT_HI_ACTINST

gideono — Wed, 10 Dec 2014 12:07:25 GMT

Good Morning

Did you ever manage to resolve the above issue?

I seem too be getting the duplicate primary key issue about once a week now and at that point I basically can't add new jobs or complete any tasks on existing jobs.

My first thought was that maybe there are two processes running but I have taken a look at how we launch the process engine in our application and I don't think that is the case. Is there anything else I can look at ?

We call the following method from a servlet on application init and every thing else that wants to access the process engine from then on uses the same method to access it.

<java>
    private static ProcessEngine processEngine = null;

    public static ProcessEngine getProcessEngine() {
       if (processEngine == null) {
            processEngine = ProcessEngineConfiguration.createProcessEngineConfigurationFromResource("activiti.cfg.xml")
                .setProcessEngineName(ProcessEngines.NAME_DEFAULT)
                .buildProcessEngine();
            return processEngine;
       } else {
           return processEngine;
       }
    }
</java>

Re: Primary Key violation in ACT_HI_ACTINST

distantworker — Wed, 10 Dec 2014 12:43:42 GMT

It just kind of resolved itself. When we were getting these errors (and they were repeatable) we were in a heavy development cycle, and things were probably messed up in the activiti database in some form or fashion. That's all I can offer.

Re: Primary Key violation in ACT_HI_ACTINST

nicksmith — Wed, 14 Jan 2015 19:51:37 GMT

@frederikhereman - I have just started seeing this sort of error when we are running multiple engines against the same database in a clustered environment. Could you provide more details in what you were thinking the issue might be in that case?

The weird thing is that we have been running in a clustered environment for almost a year now and this is now happening. We are running Activiti 5.16 and we have been on that version for several months with no issues like this.

Re: Primary Key violation in ACT_HI_ACTINST

sakthi1970 — Tue, 17 Feb 2015 03:13:29 GMT

May I know the primary key is against which table.column(s) ?

Re: Primary Key violation in ACT_HI_ACTINST

jbarrez — Wed, 18 Feb 2015 16:23:27 GMT

Not following the questions here … ?

Re: Primary Key violation in ACT_HI_ACTINST

sakthi1970 — Wed, 18 Feb 2015 22:56:57 GMT

The issue states "Duplicate entry '224' for key 'PRIMARY'" … so the primary key is against which column