AppSync：\appsync\jboss\logs位置下的datastore.log文件意外增长

摘要: datastore.log和server.log填充了“update or delete on table 'archwayevententity'viomulbutes foreign key constraint”，这会导致datastore.log文件意外增长。

本文适用于 本文不适用于 本文并非针对某种特定的产品。 本文并非包含所有产品版本。
查看其他资源

症状

datastore.log文件的大小比平时大。

对于 AppSync 4.3 版本，在 AppSync 数据存储区和服务器日志中发现了以下数千项： 
  
<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

 
对于 AppSync 4.4 版本，消息非常相似：
  
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

原因

AppSync 软件 4.3.0.0、4.3.0.1、4.4.0 和 4.4.1 中的软件问题。

解决方案

此问题已在 AppSync 4.5 中得到解决。

产品

AppSync
文章属性
文章编号: 000194478
文章类型: Solution
上次修改时间: 28 10月 2025
版本:  3
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。