[ https://jira.jboss.org/jira/browse/JBPM-2294?page=com.atlassian.jira.plug... ] Work on JBPM-2294 started by Alejandro Guizar. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-2294?page=com.atlassian.jira.plug... ] Alejandro Guizar updated JBPM-2294: ----------------------------------- PostgreSQL did not like the format of a native SQL query, the one that counts the records left in a table. Changed the query to a more portable form. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-2294?page=com.atlassian.jira.plug... ] Alejandro Guizar reopened JBPM-2294: ------------------------------------ Most failures are gone but one still remains: IdentityTest.testFindGroupsByUser http://hudson.qa.jboss.com/hudson/view/JBPM4/job/jbpm4-jboss/31/ Configurations are run in the following order 1) JBOSS_VERSION=5.0.0.GA,jdk=java16_default 2) JBOSS_VERSION=5.0.0.GA,jdk=java15_default 3) JBOSS_VERSION=5.0.1.GA,jdk=java16_default 4) JBOSS_VERSION=5.0.1.GA,jdk=java15_default Exception messages are: 1) no exception 2) org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.jbpm.pvm.internal.identity.impl.IdentitySessionImpl.findUserById(IdentitySessionImpl.java:52) at org.jbpm.pvm.internal.identity.impl.IdentitySessionImpl.createMembership(IdentitySessionImpl.java:161) 3) org.hibernate.NonUniqueResultException: query did not return a unique result: 3 4) org.hibernate.NonUniqueResultException: query did not return a unique result: 4 One user is left behind at each run. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-2294?page=com.atlassian.jira.plug... ] Tom Baeyens commented on JBPM-2294: ----------------------------------- seems to be a problem with DB cleaning: drop.jbpm.schema: [sql] Executing file: /mnt/hudson_workspace/workspace/jbpm4-jboss/DATABASE/postgresql/JBOSS_VERSION/5.0.0.GA/jdk/java16_default/label/dev45/jbpm-4.0-SNAPSHOT/db/schema.scripts/jbpm.postgresql.drop.sql [sql] Failed to execute: alter table JBPM4_COMMENT drop constraint FKFD23139F86A745AD [sql] org.postgresql.util.PSQLException: ERROR: constraint "fkfd23139f86a745ad" does not exist [sql] Failed to execute: alter table JBPM4_DEPLOYPROP drop constraint FK_DEPLPROP_DEPL [sql] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block [sql] Failed to execute: alter table JBPM4_EXECUTION drop constraint FK_EXEC_SUBPI i have tried to more the sql execution from a transaction: <sql driver="${jdbc.driver}" url="${jdbc.url}" userid="${jdbc.username}" password="${jdbc.password}" onerror="continue"> <transaction src="${jbpm.home}/db/schema.scripts/jbpm.${database}.create.sql"/> <classpath> <fileset dir="${jbpm.home}/lib"> <include name="*.jar"/> </fileset> </classpath> </sql> to just a src attribute <sql driver="${jdbc.driver}" url="${jdbc.url}" userid="${jdbc.username}" password="${jdbc.password}" onerror="continue" src="${jbpm.home}/db/schema.scripts/jbpm.${database}.create.sql"> <classpath> <fileset dir="${jbpm.home}/lib"> <include name="*.jar"/> </fileset> </classpath> </sql> let's see if that helps... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira