INFINITE LOOP IN DB2 SERVER WHEN THE CONNECTION USER STRING
CONTAINS "|" IN JAVA APPLICATION.
When using 'db2conn.setDB2ClientWorkstation("USER_ID");' for
identify client user which JAVA application connected, if there
is special character in USER_ID(eg. "|" ), application is hang,
and cannot be forced on db2 server.
In db2diag.log, The related statement is like this:
2012-02-13-11.28.34.401977+540 I110784A1048 LEVEL: Severe
PID : 733340 TID : 6186 PROC : db2sysc
0
INSTANCE: testinst NODE : 000 DB : TEST
APPHDL : 0-236 APPID:
10.255.112.66.40934.12020802283
AUTHID : TESTINST
EDUID : 6186 EDUNAME: db2agent (TEST) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : RDS UCINTFC: pStatementText =
DATA #1 : Hexdump, 99 bytes
0x00000001106A2640 : 5345 5420 434C 4945 4E54 2041 4343 544E
SET CLIENT ACCTN
0x00000001106A2650 : 4727 4A43 4330 3335 3330 4842 3120 2020
G'JCC03530HB1
0x00000001106A2660 : 2020 2020 2020 2020 2020 2020 4150 505F
APP_
0x00000001106A2670 : 4547 5F56 6973 6974 5043 5F61 6464 5669
EG_VisitPC_addVi
0x00000001106A2680 : 2720 7C20 2776 6F6C 272C 5827 3131 272C
' | 'vol',X'11',
0x00000001106A2690 : 272D 3566 3363 6530 3439 3366 3737 6461
'-5f3ce0493f77da
0x00000001106A26A0 : 3438 27
48'
From the stacktrace, there is the loop in func sqlrrGetLiteral:
-------Frame------ ------Function + Offset------
0x090000000DFD0EF0 sqlrrGetLiteral
0x090000000E3A4DA8 sqlrr_shortcut_excsqlset
0x090000000E54A2CC sqlrr_excsqlset
0x090000000E54BB04 sqljs_ddm_excsqlset
0x090000000E54B334 sqljsParseRdbAccessed
0x090000000E64CB7C .sqljsParse
0x090000000E64BADC @63@sqljsSqlam
0x090000000E7DE928 @63@sqljsDriveRequests
0x090000000E7DE790 @63@sqljsDrdaAsInnerDriver
0x090000000E7DE154 sqljsDrdaAsDriver
0x090000000E7A2BB8 RunEDU__8sqeAgentFv
0x090000000E80F858 EDUDriver__9sqzEDUObjFv
0x090000000E79B1F4 sqloEDUEntry
In the db2trc, sqljsSqlam func never return back.
853 | | | sqljsSqlam entry [eduid 2829 eduname db2agent]
854 | | | | sqloAddEDUExitList entry [eduid 2829 eduname
db2agent]
855 | | | | sqloAddEDUExitList exit
856 | | | | sqljsParse entry [eduid 2829 eduname
db2agent]
857 | | | | | sqljsParseRequest entry [eduid 2829
eduname db2agent]
858 | | | | | | sqljcReadHdrAs entry [eduid 2829 eduname
db2agent]
859 | | | | | | sqljcReadHdrAs exit
860 | | | | | sqljsParseRequest exit
861 | | | | sqljsParse correl[Corr: Local: -
PD_CORRID_ACT_SET]
862 | | | | | sqljsParsedExpExcsat entry [eduid 2829
eduname db2agent]
863 | | | | | | sqljs_ddm_excsat entry [eduid 2829
eduname db2agent]
864 | | | | | | | sqljsParseExcsat entry [eduid 2829
eduname db2agent]
865 | | | | | | | | sqljsParseMgrLvls entry [eduid 2829
eduname db2agent]
866 | | | | | | | | sqljsParseMgrLvls exit
867 | | | | | | | sqljsParseExcsat exit
868 | | | | | | | sqljsValidateMangerLevels entry [eduid
2829 eduname db2agent]
869 | | | | | | | sqljsValidateMangerLevels exit
870 | | | | | | | sqljsPeekNextObj entry [eduid 2829
eduname db2agent]
871 | | | | | | | | sqljsParseRequest entry [eduid 2829
eduname db2agent]
872 | | | | | | | | | sqljcReadHdrAs entry [eduid 2829
eduname db2agent]
873 | | | | | | | | | sqljcReadHdrAs exit
874 | | | | | | | | sqljsParseRequest exit
875 | | | | | | | sqljsPeekNextObj exit
876 | | | | | | sqljs_ddm_excsat exit
877 | | | | | sqljsParsedExpExcsat exit
878 | | | | sqljsParse correl[Corr: Local: -
PD_CORRID_ACT_END]
879 | | | | | sqljsParseRequest entry [eduid 2829
eduname db2agent]
880 | | | | | sqljsParseRequest exit
881 | | | | sqljsParse correl[Corr: Local: -
PD_CORRID_ACT_SET]
882 | | | | | sqljsParseConnect entry [eduid 2829
eduname db2agent]
...... |
