Memory crash with:
2015-11-05-15.10.54.622301-300 E1322840E1017 LEVEL:
Severe
PID : 25971 TID : 140644261553920 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-1536 APPID: X.x.x.x.151105194709
AUTHID : DB2INST1 HOSTNAME: test
EDUID : 87 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloLogMemoryCondition,
probe:900
MESSAGE : The memory protect feature relies on resources
governed by /proc/sys/vm/max_map_count. We are getting a
condition which could be caused by max_map_count being set too
low. Try to bump this value up and retry the scenario. Rule of
thumb is: 300,000 should be a good value for testing. For
scenarios that require lots of allocations, such as BLU, you
might need to increase this value further. This instance will
be crashed on purpose because we can no longer continue.
One of the two stacks:
x00007FEA65E236CA
_ZN17Remote_Connection23remove_remote_operationEP16Remote_Operat
ion +
0x00fa
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007FEA65E237B7
_ZN17Remote_Connection28remove_all_remote_operationsEv + 0x0047
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007FEA65E23465 _ZN17Remote_ConnectionD1Ev + 0x0045
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007FE9E0A4B042 _ZN15Odbc_ConnectionD1Ev + 0x00c2
(/home/db2inst1/sqllib/lib64/libdb2rcodbcF.so)
0x00007FE9E0A4AF6A _ZN15Odbc_ConnectionD0Ev + 0x000a
(/home/db2inst1/sqllib/lib64/libdb2rcodbcF.so)
0x00007FEA65E1B93D
_ZN12FencedServer10disconnectEP17Remote_Connection +
0x010d
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007FEA65E1A3B4
_ZN12FencedServer16drop_remote_userEP11Remote_User16Sqlqg_Delete
Type +
0x0124
1 ossDumpStackTraceV98
2 OSSTrapFile::dumpEx
3 sqlo_trce
4 sqloEDUCodeTrapHandler
5 __PRETTY_FUNCTION__.6093
6 sqloCrashOnCriticalMemoryValidationFailure
7 sqloMemProtect
8 SQLO_MEM_POOL::allocateFastMemoryBlock
9 SQLO_MEM_POOL::allocateMemoryBlock
10 sqlogmblkEx
11 sqlnq_cst::populate_from_cd
12 sqlnq_fcs::need_statistics
13 sqlno_col_width
14 sqlno_width_cols_iset
15 sqlno_global_cols_width
16 sqlno_get_buffer_size
17 sqlno_cost_fetch
18 sqlno_prop_fetch
2016-01-11-15.46.32.115776-300 E6820952E971 LEVEL:
Error (Received)
PID : 27974 TID : 140162633819904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
FED_DEV
APPHDL : 0-9483 APPID: *LOCAL.db2inst1.xxxxxx
AUTHID : DB2INST1 HOSTNAME: test
EDUID : 286 EDUNAME: db2agent (FED_DEV) 0
FUNCTION: DB2 UDB, ODBC wrapper, report_error_message,
probe:1131
DATA #1 : String, 16 bytes
Server name:
DATA #2 : String, 8 bytes
CSDWPROD
DATA #3 : String, 16 bytes
Function name:
DATA #4 : String, 15 bytes
num_result_cols
DATA #5 : String, 16 bytes
ODBC native err:
DATA #6 : signed integer, 4 bytes
2706
DATA #7 : String, 16 bytes
ODBC sqlstate:
DATA #8 : String, 5 bytes
42S02
DATA #9 : String, 16 bytes
ODBC error text:
DATA #10: String, 116 bytes
[DataDirect][ODBC Sybase IQ Wire Protocol driver][Sybase IQ]SQL
Anywhere Error -141: Table 'sysstatistics' not found
2016-01-11-15.46.32.116894-300 E6821924E659 LEVEL:
Error (Received)
PID : 27974 TID : 140162633819904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
FED_DEV
APPHDL : 0-9483 APPID: *LOCAL.db2inst1.xxxxxx
AUTHID : DB2INST1 HOSTNAME: test
EDUID : 286 EDUNAME: db2agent (FED_DEV) 0
FUNCTION: DB2 UDB, ODBC wrapper, Odbc_Statement::report_error,
probe:1556
MESSAGE : ZRC=0x80260160=-2144992928=SQLQG_ERROR "Error constant
for gateway."
DATA #1 : String, 16 bytes
SQL statement:
DATA #2 : String, 43 bytes
SELECT max(moddate) FROM dbo.sysstatistics
2016-01-11-15.46.32.117476-300 I6822584E584 LEVEL:
Error
PID : 27974 TID : 140162633819904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
FED_DEV
APPHDL : 0-9483 APPID: *LOCAL.db2inst1.xxxxxx
AUTHID : DB2INST1 HOSTNAME: test
EDUID : 286 EDUNAME: db2agent (FED_DEV) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_passthru_describe,
probe:65
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and
trustable."
2016-01-11-15.46.33.137900-300 I6823169E603 LEVEL:
Error
PID : 27974 TID : 140162633819904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
FED_DEV
APPHDL : 0-9483 APPID: *LOCAL.db2inst1.xxxxxx
AUTHID : DB2INST1 HOSTNAME: test
EDUID : 286 EDUNAME: db2agent (FED_DEV) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1 |
