suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT30790 Status: Closed

DB2LOGGP CAN TRAP WITH SIGNAL #11 IN A FEDERATED ENVIRONMENT

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
DB2 instance trapped in sqleuApplicationInit

The following db2diag.log probe can occur for db2loggp:

2019-06-13-09.06.44.247708+120 I537852E449           LEVEL:
Warning
PID     : 10217                TID : 47051769374464  PROC :
db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : TEST
HOSTNAME: test
EDUID   : 38                   EDUNAME: db2loggp (TEST) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 28 bytes
_Z23sqlpForceConflictingApp
DATA #2 : String, 4 bytes
sqlp

...

2019-06-13-09.06.50.279399+120 E550835E1478          LEVEL:
Severe
PID     : 10217                TID : 47051769374464  PROC :
db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : TEST
HOSTNAME: test
EDUID   : 38                   EDUNAME: db2loggp (TEST) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
probe:90
MESSAGE : ADM14011C  A critical failure has caused the following
type of error:
          "Trap". The database manager cannot recover from the
failure. First
          Occurrence Data Capture (FODC) was invoked in the
following mode:
          "Automatic". FODC diagnostic information is located in
the following
          directory:
"/db2/db2dump/FODC_Trap_2019-06-13-09.06.44.030401_0000/".
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 128 bytes
...


And the following stack can occur:



DB2 build information: DB2 v11.1.3.3 s1807091300 SQL11013
timestamp: 2019-06-13-09.06.44.040532
instance name: db2inst.000
EDU name     : db2loggp (TEST) 0
EDU ID       : 38
Signal #11
uname: S:Linux R:3.10.0-862.9.1.el7.x86_64 V:#1 SMP Wed Jun 27
04:30:39 EDT 2018 M:x86_64 N:test
process id: 10217
parent process id: 10215
thread id : 47051769374464 (0x2ACB17FFE700)
kthread id : 10419

...



 sqleuApplicationInit + 0x00e3
(/db2/db2inst/sqllib/lib64/libdb2.so.1)

        0x00002ACDD4E3C2A3 : 4C8B3A4D85FF7424


-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002ACAD9E4E4A6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
                (/db2/db2inst/sqllib/lib64/libdb2osse.so.1)
0x00002ACAD9E4E0EB ossDumpStackTraceV98 + 0x002b
                (/db2/db2inst/sqllib/lib64/libdb2osse.so.1)
0x00002ACAD9E4A297 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
                (/db2/db2inst/sqllib/lib64/libdb2osse.so.1)
0x00002ACAD234A967 sqlo_trce + 0x03c7
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD24B4851 sqloEDUCodeTrapHandler + 0x03b1
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACACAC52680 address: 0x00002ACACAC52680 ; dladdress:
0x00002ACACAC43000 ; offset in lib: 0x000000000000F680 ;
                (/lib64/libpthread.so.0)
0x00002ACDD4E3C2A3 sqleuApplicationInit + 0x00e3
                (/db2/db2inst/sqllib/lib64/libdb2.so.1)
0x00002ACDD46AAD21 SQLCancel + 0x0091
                (/db2/db2inst/sqllib/lib64/libdb2.so.1)
0x00002ACD74F6BD21 _ZN14DRDA_Statement19interrupt_executionEv +
0x0031
                (/db2/db2inst/sqllib/lib64/libdb2drdaF.so)
0x00002ACAD069CC82 _ZN8sqeAgent21InterruptFedStatementEv +
0x0022
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD0762B0E
_ZN14sqeAppServices17ForceApplicationsEP14sqeApplicationiP12SQLZ
_APP_HDLiiii + 0x030e
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD062B6F9
_Z15sqleForceAgentsiiP12SQLZ_APP_HDLP5sqlcaiii + 0x0159
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD28DFAF1
_Z23sqlpForceConflictingAppP12SQLZ_APP_HDLmjP14SQLP_LOCK_INFO +
0x0391
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD282957B
_Z27sqlpScanTranTableForLowTranP14sqlpMasterDbcbP9SQLP_LSN8PP11S
QLP_TENTRY + 0x05ab
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD282A613
_ZN11sqpLoggpEdu33sqlpLoggpScanToUpdateRecoveryLsnsEv + 0x01d3
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD286F90D _ZN11sqpLoggpEdu6RunEDUEv + 0x028d
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD3F5026E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACAD24B1798 sqloEDUEntry + 0x0578
                (/db2/db2inst/sqllib/lib64/libdb2e.so.1)
0x00002ACACAC4ADD5 address: 0x00002ACACAC4ADD5 ; dladdress:
0x00002ACACAC43000 ; offset in lib: 0x0000000000007DD5 ;
                (/lib64/libpthread.so.0)
0x00002ACADAF59B3D clone + 0x006d
                (/lib64/libc.so.6)
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* All DB2 for LUW users                                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 Db2 11.1 M4FP5 or later.                      *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT29468 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.10.2019
31.10.2019
31.10.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)