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. ...

Acest articol se aplică pentru Acest articol nu se aplică pentru Acest articol nu este legat de un produs specific. Acest articol nu acoperă toate versiunile de produs existente.
Consultați alte resurse

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.

Produse

AppSync
Proprietăți articol
Article Number: 000194478
Article Type: Solution
Ultima modificare: 28 oct. 2025
Version:  3
Găsiți răspunsuri la întrebările dvs. de la alți utilizatori Dell
Servicii de asistență
Verificați dacă dispozitivul dvs. este acoperit de serviciile de asistență.