Sending multiple emails simultaneously to new party does not work properly
--------------------------------------------------------------------------
Key: OFBIZ-3910
URL:
https://issues.apache.org/jira/browse/OFBIZ-3910 Project: OFBiz
Issue Type: Bug
Components: party
Affects Versions: Release Branch 10.04
Reporter: Martin Kreidenweis
Sending more than one email at once to a party that never has received an email using the sendMailFromScreen service fails.
Creating the communication event for the email in this case triggers the createPartyRole service. So two threads apparently try to insert the same party role. This results in the following error:
{code}
java.lang.Exception: Failure in create operation for entity [PartyRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PartyRole][createdStamp,2010-08-30 10:44:41.144(java.sql.Timestamp)][createdTxStamp,2010-08-30 10:44:26.709(java.sql.Timestamp)][lastUpdatedStamp,2010-08-30 10:44:41.144(java.sql.Timestamp)][lastUpdatedTxStamp,2010-08-30 10:44:26.709(java.sql.Timestamp)][partyId,RegisteredMerchantCompany(java.lang.String)][roleTypeId,ADDRESSEE(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ofbiz.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint »pk_party_role«)). Rolling back transaction.
{code}
This happens only after the actual emails are sent. OFBiz now rolls back the transaction, thinks the email sending failed, and tries to send the emails again later.
Workaround:
Create a PartyRole ADDRESSE for the party before trying to send emails.
We did not find a good solution for the actual problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Locked
