AppSync: The datastore.log files under \appsync\jboss\logs location grows unexpectedly

Summary: The datastore.log and server.log are filled with "update or delete on table "archwayevententity" violates foreign key constraint," which causes the datastore.log file to grow unexpectedly. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

The datastore.log files are of a larger size than usual. 

For the AppSync 4.3 versions, thousands of the following are found in AppSync Datastore and Server logs: 
  
<DATE  & TIME> EDT 1720 617e113c.6b8 112796 apollo:ERROR: update or delete on table "archwayevententity" violates foreign key constraint "fke9556998f3ed668b" on table "archwayevententity_args"
<DATE  & TIME> EDT 1720 617e113c.6b8 112797 apollo:DETAIL: Key (f_id)=(df477d61-8afd-4c9b-af67-a51e646bf01a) is still referenced from table "archwayevententity_args".
<DATE  & TIME> EDT 1720 617e113c.6b8 112798 apollo:STATEMENT: delete from archway.ArchwayEventEntity where (f_id) IN (select f_id from HT_ArchwayEventEntity)
<DATE  & TIME> EDT 1720 617e113c.6b8 112799 apollo:ERROR: current transaction is aborted, commands ignored until end of transaction block
<DATE  & TIME> EDT 1720 617e113c.6b8 112800 apollo:STATEMENT: drop table HT_ArchwayEventEntity

 
For the AppSync 4.4 versions, the messages are highly similar:
  
07-05-2022 09:01:40.915 INFO [EJB default - 2] [com.emc.archway.services.event.ArchwayEventEntityServiceBean] [] [] 53e3596c-3619-4f27-b2ff-bd0c48395654->>> Query string is:DELETE FROM ArchwayEventEntity n where n.id IN (:list)
07-05-2022 09:01:40.931 WARN [EJB default - 2] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [] [] SQL Error: 0, SQLState: 23503
07-05-2022 09:01:40.931 ERROR [EJB default - 2] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [] [] ERROR: update or delete on table "archwayevententity" violates foreign key constraint "fk6fwt1ukc99ilmil3l4frmqk4m" on table "archwayevententity_args"
  Detail: Key (f_id)=(142293c9-6374-4199-be18-628e2c45b9d2) is still referenced from table "archwayevententity_args".
07-05-2022 09:01:40.931 WARN [EJB default - 2] [org.hibernate.hql.spi.id.local.Helper] [] [] unable to drop temporary id table after use [ERROR: current transaction is aborted, commands ignored until end of transaction block]
07-05-2022 09:01:40.947 INFO [EJB default - 2] [com.emc.archway.services.event.ArchwayEventEntityServiceBean] [] [] 53e3596c-3619-4f27-b2ff-bd0c48395654->>> Exception : javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

Cause

Software issue in AppSync software 4.3.0.0, 4.3.0.1, 4.4.0 and 4.4.1.

Resolution

The issue is resolved in AppSync 4.5.

Products

AppSync
Article Properties
Article Number: 000194478
Article Type: Solution
Last Modified: 28 Oct 2025
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.