1. Holger Schimanski Avatar Holger Schimanski
  2. Untitled project
  3. syntaxplugin-public
  4. Issues

SQL - Error formatting macro: code: java.lang.StackOverflowError

Issue #78 new
Gilles Beraudo created an issue

Hi, We just migrated from JIRA 6.2.7 to JIRA 6.4.12 . We also migrate your plugin from version 1.9.1 to version 2.2.0.

We faced a new error since we migrated, on a existing jira comment (in 'view' or 'preview').

Gilles Here is the stack trace: {code} java.lang.StackOverflowError at java.util.regex.Pattern$CharProperty$1.isSatisfiedBy(Pattern.java:3771) at java.util.regex.Pattern$7.isSatisfiedBy(Pattern.java:5271) at java.util.regex.Pattern$CharProperty.match(Pattern.java:3776) at java.util.regex.Pattern$Branch.match(Pattern.java:4604) at java.util.regex.Pattern$GroupHead.match(Pattern.java:4658) at java.util.regex.Pattern$Loop.match(Pattern.java:4785) at java.util.regex.Pattern$GroupTail.match(Pattern.java:4717) at java.util.regex.Pattern$BranchConn.match(Pattern.java:4568) at java.util.regex.Pattern$CharProperty.match(Pattern.java:3777) at java.util.regex.Pattern$Branch.match(Pattern.java:4604) at java.util.regex.Pattern$GroupHead.match(Pattern.java:4658) at java.util.regex.Pattern$Loop.match(Pattern.java:4785) at java.util.regex.Pattern$GroupTail.match(Pattern.java:4717) at java.util.regex.Pattern$BranchConn.match(Pattern.java:4568) at java.util.regex.Pattern$CharProperty.match(Pattern.java:3777) at java.util.regex.Pattern$Branch.match(Pattern.java:4604) at java.util.regex.Pattern$GroupHead.match(Pattern.java:4658)

{code}

I will attach exemples of working / non working in comments

Comments (7)

  1. Gilles Beraudo reporter

    This is not working! {code:sql} set search_path = 'hp_mitsohio_all_local'

    --> 6411654;"McMassMailLtrsPanel.ascx";30002;1536376932 SELECT * FROM DSS_KeysExtra WHERE Object_ID = 6411654

    -- REGULAR CALL GRAPH (all FROM-clause's tables below are the _RCG ones) --> Return 0 rows Select A.* From Acc A , DSS_Transaction_RCG TR , DSS_TransactionDetails_RCG TD2 , DSS_TransactionDetails_RCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- FULL CALL GRAPH (all FROM-clause's tables below are the _FCG ones) --> Return 1 row -- IdAcc=252325; IdClr=101077; IdCle=101626; -- AccTypLo=2097152; AccTypHi=1; AccTypLo2=0; AccTypHi2=0; -- AccKnd=0; IdPro=148572; Prop=0 -- ChildType = 0 Select A.*, TD.ChildType From Acc A , DSS_Transaction_FCG TR , DSS_TransactionDetails_FCG TD2 , DSS_TransactionDetails_FCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- What objects correspond to the Acc's IdClr, IdCle returned above ? --> 101077;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36122;0;138220;"???";"1970-01-01 00:00:00";"";0;"" => TRIGGER -- 101626;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36100;0;138017;"???";"1970-01-01 00:00:00";"";0;"" => TABLE select * from Keys where IdKey in ( 101077, 101626 )

    -- Starting from the Acc's IdClr, IdCle returned above, we now -- climb up the FCG until we reach the transaction's Entry Point --> 101077 (TRIGGER) call level = 5 --> 101626 (TABLE) call level = 6 select * from DSSAPP_TRAN_CALLS where object_id in ( 101077, 101626 )

    --> only 1 caller = 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101626 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> only 1 caller = 144492;4;"CAST_Oracle_RelationalTable";"T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101077 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    / --> 4 callers, but we ignore the 2 at levels 5 and 14 585505;3;"CAST_DotNet_MethodCSharp";"RetrieveLetterBySak";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLetterBySak" 585501;3;"CAST_DotNet_MethodCSharp";"RetrieveLettersByType";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLettersByType" 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" 551714;14;"CAST_DotNet_MethodCSharp";"IsInValidLetterId";"iC.MMIS.TPL.Factory.TplLetterCodeFactory.IsInValidLetterId" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 144492 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    / --> 2 callers 691846;2;"CAST_DotNet_MethodCSharp";"Datapanel_PanelDataBound";"iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_PanelDataBound" 691847;2;"CAST_DotNet_MethodCSharp";"Datapanel_Update"; "iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_Update" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 585505, 585501 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> twice the same only 1 caller = 759659;1;"CAST_DotNet_CSharpFile";"McMassMailLtrsPanel.ascx.cs";"C:\CASTMS_8\Deploy\MITS_Ohio\DotNet\MC\DotNet\iC.MMIS.MC.WebUI\McMassMailLtrsPanel.ascx.cs" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 691846, 691847 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> only 1 caller = 759550;0;"CAST_DotNet_AscxFile";"McMassMailLtrsPanel.ascx";"C:\CASTMS_8\Deploy\MITS_Ohio\DotNet\MC\DotNet\iC.MMIS.MC.WebUI\McMassMailLtrsPanel.ascx" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 759659 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> STOP here since here we're at call level = 0

    / --> 2 callers 691846;2;"CAST_DotNet_MethodCSharp";"Datapanel_PanelDataBound";"iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_PanelDataBound" 691847;2;"CAST_DotNet_MethodCSharp";"Datapanel_Update"; "iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_Update" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 585505, 585501 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    {code}

  5. Gilles Beraudo reporter

    This is working fine! {code:sql} set search_path = 'hp_mitsohio_all_local'

    --> 6411654;"McMassMailLtrsPanel.ascx";30002;1536376932 SELECT * FROM DSS_KeysExtra WHERE Object_ID = 6411654

    -- REGULAR CALL GRAPH (all FROM-clause's tables below are the _RCG ones) --> Return 0 rows Select A.* From Acc A , DSS_Transaction_RCG TR , DSS_TransactionDetails_RCG TD2 , DSS_TransactionDetails_RCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- FULL CALL GRAPH (all FROM-clause's tables below are the _FCG ones) --> Return 1 row -- IdAcc=252325; IdClr=101077; IdCle=101626; -- AccTypLo=2097152; AccTypHi=1; AccTypLo2=0; AccTypHi2=0; -- AccKnd=0; IdPro=148572; Prop=0 -- ChildType = 0 Select A.*, TD.ChildType From Acc A , DSS_Transaction_FCG TR , DSS_TransactionDetails_FCG TD2 , DSS_TransactionDetails_FCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- What objects correspond to the Acc's IdClr, IdCle returned above ? --> 101077;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36122;0;138220;"???";"1970-01-01 00:00:00";"";0;"" => TRIGGER -- 101626;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36100;0;138017;"???";"1970-01-01 00:00:00";"";0;"" => TABLE select * from Keys where IdKey in ( 101077, 101626 )

    -- Starting from the Acc's IdClr, IdCle returned above, we now -- climb up the FCG until we reach the transaction's Entry Point --> 101077 (TRIGGER) call level = 5 --> 101626 (TABLE) call level = 6 select * from DSSAPP_TRAN_CALLS where object_id in ( 101077, 101626 )

    --> only 1 caller = 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101626 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> only 1 caller = 144492;4;"CAST_Oracle_RelationalTable";"T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101077 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    / --> 4 callers, but we ignore the 2 at levels 5 and 14 585505;3;"CAST_DotNet_MethodCSharp";"RetrieveLetterBySak";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLetterBySak" 585501;3;"CAST_DotNet_MethodCSharp";"RetrieveLettersByType";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLettersByType" 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" 551714;14;"CAST_DotNet_MethodCSharp";"IsInValidLetterId";"iC.MMIS.TPL.Factory.TplLetterCodeFactory.IsInValidLetterId" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 144492 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    {code}

  6. Gilles Beraudo reporter

    This is working fine too (this is the difference between the working & not working comments)!

    / --> 2 callers 691846;2;"CAST_DotNet_MethodCSharp";"Datapanel_PanelDataBound";"iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_PanelDataBound" 691847;2;"CAST_DotNet_MethodCSharp";"Datapanel_Update"; "iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_Update" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 585505, 585501 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    {code}

  7. Gilles Beraudo reporter

    This is not working! {code:sql} set search_path = 'hp_mitsohio_all_local'

    --> 6411654;"McMassMailLtrsPanel.ascx";30002;1536376932 SELECT * FROM DSS_KeysExtra WHERE Object_ID = 6411654

    -- REGULAR CALL GRAPH (all FROM-clause's tables below are the _RCG ones) --> Return 0 rows Select A.* From Acc A , DSS_Transaction_RCG TR , DSS_TransactionDetails_RCG TD2 , DSS_TransactionDetails_RCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- FULL CALL GRAPH (all FROM-clause's tables below are the _FCG ones) --> Return 1 row -- IdAcc=252325; IdClr=101077; IdCle=101626; -- AccTypLo=2097152; AccTypHi=1; AccTypLo2=0; AccTypHi2=0; -- AccKnd=0; IdPro=148572; Prop=0 -- ChildType = 0 Select A.*, TD.ChildType From Acc A , DSS_Transaction_FCG TR , DSS_TransactionDetails_FCG TD2 , DSS_TransactionDetails_FCG TD Where TR.Object_ID = 6411654 --> The transaction of interest And TD.Object_ID = TR.Object_ID And TD2.Object_ID = TR.Object_ID And TD2.Object_ID = TD.Object_ID And A.IdClr = TD2.Child_ID And A.IdCle = TD.Child_ID And ( A.Prop & 65536 ) = 0 -- The link hasn't been ignored And ( A.AccTypHi & 7 ) != 0 -- INSERT/UPDATE/DELETE (rINSERT+rUPDATE+rDELETE) And ( A.AccTypLo & 2097152 ) = 2097152 -- "use link" (rUSE)

    -- What objects correspond to the Acc's IdClr, IdCle returned above ? --> 101077;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36122;0;138220;"???";"1970-01-01 00:00:00";"";0;"" => TRIGGER -- 101626;"A_T_LG_LETTER_TEMPLATE";"";"XXXXXX";-1;36100;0;138017;"???";"1970-01-01 00:00:00";"";0;"" => TABLE select * from Keys where IdKey in ( 101077, 101626 )

    -- Starting from the Acc's IdClr, IdCle returned above, we now -- climb up the FCG until we reach the transaction's Entry Point --> 101077 (TRIGGER) call level = 5 --> 101626 (TABLE) call level = 6 select * from DSSAPP_TRAN_CALLS where object_id in ( 101077, 101626 )

    --> only 1 caller = 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101626 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    --> only 1 caller = 144492;4;"CAST_Oracle_RelationalTable";"T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.T_LG_LETTER_TEMPLATE" select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 101077 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    / --> 4 callers, but we ignore the 2 at levels 5 and 14 585505;3;"CAST_DotNet_MethodCSharp";"RetrieveLetterBySak";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLetterBySak" 585501;3;"CAST_DotNet_MethodCSharp";"RetrieveLettersByType";"iC.MMIS.SW.Factory.LetterFactory.RetrieveLettersByType" 101077;5;"CAST_Oracle_DML_Trigger";"A_T_LG_LETTER_TEMPLATE";"OHMISPA.AIM.A_T_LG_LETTER_TEMPLATE" 551714;14;"CAST_DotNet_MethodCSharp";"IsInValidLetterId";"iC.MMIS.TPL.Factory.TplLetterCodeFactory.IsInValidLetterId" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 144492 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    / --> 2 callers 691846;2;"CAST_DotNet_MethodCSharp";"Datapanel_PanelDataBound";"iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_PanelDataBound" 691847;2;"CAST_DotNet_MethodCSharp";"Datapanel_Update"; "iC.MMIS.MC.WebUI.McMassMailLtrsPanel.Datapanel_Update" / select C.*, T.TypNam, K.KeyNam, OFN.FullName from DSSAPP_TRAN_CALLS C, CTV_LINKS L, Keys K, Typ T, ObjFulNam OFN where L.Called_ID in ( 585505, 585501 ) and L.Caller_ID = C.Object_ID and K.IdKey = L.Caller_ID and K.ObjTyp = T.IdTyp and K.IdKey = OFN.IdObj

    {code}

  8. Log in to comment
Assignee
–
Type
bug
Priority
minor
Status
new
Milestone
–
Version
–
Votes
1
Watchers
2
Jira Software: the preferred issue tracker for Bitbucket. Join the team!