[ 
https://issues.apache.org/jira/browse/IGNITE-5239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16038096#comment-16038096
 ] 

Vasiliy Sisko commented on IGNITE-5239:
---------------------------------------

{code}
e = {CacheException@4878} "javax.cache.CacheException: class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to 
execute DML statement [stmt=delete from "WithdataCache".Withdata where _KEY = 
1, params=null]"
 detailMessage = "class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to 
execute DML statement [stmt=delete from "WithdataCache".Withdata where _KEY = 
1, params=null]"
 cause = {IgniteSQLException@4898} "class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to 
execute DML statement [stmt=delete from "WithdataCache".Withdata where _KEY = 
1, params=null]"
  sqlState = null
  statusCode = 0
  detailMessage = "Failed to execute DML statement [stmt=delete from 
"WithdataCache".Withdata where _KEY = 1, params=null]"
  cause = {CachePartialUpdateCheckedException@4902} "class 
org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedException: 
Failed to update keys (retry update if possible).: [1]"
   failedKeys = {ArrayList@4904}  size = 1
   topVer = {AffinityTopologyVersion@4905} "AffinityTopologyVersion [topVer=1, 
minorTopVer=0]"
   detailMessage = "Failed to update keys (retry update if possible)."
   cause = {CachePartialUpdateCheckedException@4902} "class 
org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedException: 
Failed to update keys (retry update if possible).: [1]"
   stackTrace = {StackTraceElement[0]@4899} 
   suppressedExceptions = {ArrayList@4907}  size = 1
    0 = {IgniteCheckedException@4911} "class 
org.apache.ignite.IgniteCheckedException: Failed to update keys."
     detailMessage = "Failed to update keys."
     cause = {IgniteCheckedException@4911} "class 
org.apache.ignite.IgniteCheckedException: Failed to update keys."
     stackTrace = {StackTraceElement[0]@4899} 
     suppressedExceptions = {ArrayList@4914}  size = 1
      0 = {IgniteCheckedException@4918} "class 
org.apache.ignite.IgniteCheckedException: Runtime failure on search row: 
org.apache.ignite.internal.processors.cache.IgniteCacheOffheapManagerImpl$SearchRow@4944f938"
       detailMessage = "Runtime failure on search row: 
org.apache.ignite.internal.processors.cache.IgniteCacheOffheapManagerImpl$SearchRow@4944f938"
       cause = {IgniteCheckedException@4921} "class 
org.apache.ignite.IgniteCheckedException: Failed to remove value from database 
[table=public.withdata, key=1]"
        detailMessage = "Failed to remove value from database 
[table=public.withdata, key=1]"
        cause = {CacheWriterException@4925} 
"javax.cache.integration.CacheWriterException: Failed to remove value from 
database [table=public.withdata, key=1]"
         detailMessage = "Failed to remove value from database 
[table=public.withdata, key=1]"
         cause = {PSQLException@4927} "org.postgresql.util.PSQLException: 
ERROR: update or delete on table "withdata" violates foreign key constraint 
"withfk_fk_fkey" on table "withfk"\n  Detail: Key (key)=(1) is still referenced 
from table "withfk"."
          _serverError = {ServerErrorMessage@4930} "ERROR: update or delete on 
table "withdata" violates foreign key constraint "withfk_fk_fkey" on table 
"withfk"\n  Detail: Key (key)=(1) is still referenced from table "withfk"."
          SQLState = "23503"
          vendorCode = 0
          next = null
          detailMessage = "ERROR: update or delete on table "withdata" violates 
foreign key constraint "withfk_fk_fkey" on table "withfk"\n  Detail: Key 
(key)=(1) is still referenced from table "withfk"."
          cause = null
          stackTrace = {StackTraceElement[0]@4899} 
          suppressedExceptions = 
{Collections$UnmodifiableRandomAccessList@4758}  size = 0
         stackTrace = {StackTraceElement[0]@4899} 
         suppressedExceptions = {Collections$UnmodifiableRandomAccessList@4758} 
 size = 0
        stackTrace = {StackTraceElement[0]@4899} 
        suppressedExceptions = {Collections$UnmodifiableRandomAccessList@4758}  
size = 0
       stackTrace = {StackTraceElement[0]@4899} 
       suppressedExceptions = {Collections$UnmodifiableRandomAccessList@4758}  
size = 0
  stackTrace = {StackTraceElement[0]@4899} 
  suppressedExceptions = {Collections$UnmodifiableRandomAccessList@4758}  size 
= 0
 stackTrace = {StackTraceElement[0]@4899} 
 suppressedExceptions = {Collections$UnmodifiableRandomAccessList@4758}  size = 0
{code}

> Web Console: Add an option to show full stack trace on Queries screen
> ---------------------------------------------------------------------
>
>                 Key: IGNITE-5239
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5239
>             Project: Ignite
>          Issue Type: Task
>          Components: UI, wizards
>    Affects Versions: 2.0
>            Reporter: Alexey Kuznetsov
>            Assignee: Vasiliy Sisko
>             Fix For: 2.1
>
>
> In some situations we need full stack trace to show real error like: 
> {code}
> Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on 
> table "city" violates foreign key constraint "country_capital_fkey" on table 
> "country"
>   Detail: Key (id)=(3503) is still referenced from table "country".
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to