Гость
Форумы
[новые:0]
/ IBM DB2, WebSphere, IMS, U2
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
10.5.0.4 The statement was not processed because a limit such as a memory limit
[новые:0]
1 сообщений из 1, страница 1 из 1
|
|
|
10.5.0.4 The statement was not processed because a limit such as a memory limit
|
|||
|---|---|---|---|
|
#18+
После апгрейда с 10.5 на 10.5.0.4 (Red Hat Enterprise Linux Server 5.11 / x86_64) стали получать ошибку: The statement was not processed because a limit such as a memory limit, an SQL limit, or a database limit was reached.. SQLCODE=-101, SQLSTATE=54001, DRIVER=4.13.111 На том же самом приложении, которое работало до апгрейда без подобной ошибки. Ошибка можеть быть как на селекте умеренной сложности (джоин 5-6 таблиц), так и на довольно простом блоке операторов, типа: begin atomic insert ... 10-12 инсертов end@ в diag.log: 2015-04-08-14.28.14.896774+120 E1243822349E791 LEVEL: Warning PID : 7261 TID : 46957816965440 PROC : db2sysc 0 INSTANCE: mledevl9 NODE : 000 DB : QQQ_01 APPHDL : 0-8802 APPID: 198.18.127.20.52221.150418032439 AUTHID : MLEDEVL9 HOSTNAME: host1.com EDUID : 164 EDUNAME: db2agent (QQQ_01) 0 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30 DATA #1 : <preformatted> Out of memory failure for Statement Heap on node 0. Requested block size : 10271 bytes. Physical heap size : 113704960 bytes. Configured heap size : 8388608 bytes. Unreserved memory used by heap : 0 bytes. Unreserved memory left in set : 0 bytes. 2015-04-08-14.28.14.907492+120 E1243823141E3391 LEVEL: Info (Origin) PID : 7261 TID : 46957816965440 PROC : db2sysc 0 INSTANCE: mledevl9 NODE : 000 DB : QQQ_01 APPHDL : 0-8802 APPID: 198.18.127.20.52221.150418032439 AUTHID : MLEDEVL9 HOSTNAME: host1.com EDUID : 164 EDUNAME: db2agent (QQQ_01) 0 FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 MESSAGE : ZRC=0x8B0F000C=-1961951220=SQLO_NOMEM_STMTH "No memory available in 'Statement Heap'" DIA8319C No memory available in the statement heap. DATA #1 : String, 62 bytes An unexpected error was detected during statement compilation. DATA #2 : Boolean, 1 bytes true DATA #3 : Boolean, 1 bytes false DATA #4 : Boolean, 1 bytes true DATA #5 : Boolean, 1 bytes false DATA #6 : Hex integer, 4 bytes 0x00000000 DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -101 sqlerrml: 1 sqlerrmc: 1 sqlerrp : SQLNG130 sqlerrd : (1) 0x8B0F000C (2) 0x0000000C (3) 0x00000000 (4) 0x00000491 (5) 0xFFFFFF66 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: DATA #8 : Hex integer, 4 bytes 0x00000040 DATA #9 : String with size, 1000 bytes begin atomic INSERT INTO ... DATA #10: String, 954 bytes Compiler error stack for rc = -1961951220: sqlnn_cmpl[415] sqlng_main[2984] sqlng_main[1690] sqlng_build_thread[854] sqlngProcessLolepop[547] sqlng_process_return_op[1656] sqlngProcessLolepop[547] sqlng_process_pipe_op[883] sqlngProcessLolepop[547] sqlng_process_mate_op[1496] sqlngProcessLolepop[547] sqlng_process_filter_op[9618] sqlng_build_FLTR_op[5003] sqlng_build_thread[1035] sqlng_walk_BF_chain[881] sqlng_process_BF_node[1064] sqlng_process_parse_tree_n[1524] sqlng_build_CASE_op[13916] sqlng_build_thread[1035] sqlng_walk_BF_chain[881] sqlng_process_BF_node[1064] sqlng_process_parse_tree_n[1514] sqlng_build_SBQR_op[12392] sqlng_prepare_SUBQ_operati[2833] sqlng_build_thread[854] sqlngProcessLolepop[547] sqlng_process_pipe_op[883] sqlngProcessLolepop[547] sqlng_process_mate_op[1496] sqlngProcessLolepop[547] sqlng_process_filter_op[9618] sqlng_build_FLTR_op[5003] sqlng_build_thread[1035] sqlng_walk_BF_chain[881] sqlng_process_BF_node[1064] При этом в момент выполнения запроса (или блока) получаю странную картину с mempools: Address MemSet PoolName Id SecondId Overhead LogSz LogHWM PhySz PhyHWM CfgSize Bnd BlkCnt CfgParm 0x00002AAFA009EF18 Appl stmth 12 34241 13120 164522825 164652361 168034304 168034304 8388608 No 74961 n/a Т.е. LogSz для statementheap=164522825, при том что CfgSize=8388608 SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(2048) Это нормально, что statementheap=164522825? здесь: IT04326: PACKAGE CACHE MEMORY USE CAN EXCEED CONFIGURED SIZE RESULTING IN MEMORY EXHAUSTION ON DB2 Cancun Release 10.5.0.4. http://www-01.ibm.com/support/docview.wss?uid=swg1IT04326 пишут про нечто похожее для кэша пакетов. Кто-нибудь сталкивался с таким подвохом со стороны канкуна? все mempools: Memory Pools: Address MemSet PoolName Id SecondId Overhead LogSz LogHWM PhySz PhyHWM CfgSize Bnd BlkCnt CfgParm 0x00002AAFC815EF18 DVL_03 utilh 5 0 0 8568 1002908 65536 1114112 131203072 No 34 UTIL_HEAP_SZ 0x00002AAFA9423FF8 DVL_03 pckcacheh 7 0 76864 2096183 192665382 5308416 217579520 53542912 No 397 PCKCACHESZ 0x00002AAFA9421110 DVL_03 xmlcacheh 93 0 50880 145552 145552 196608 196608 2097152 No 1 n/a 0x00002AAFA941E228 DVL_03 catcacheh 8 0 52736 2917804 3318452 4063232 4128768 3276800 No 934 CATALOGCACHE_SZ 0x00002AAFA9415570 DVL_03 bph 16 2 0 16768384 16768384 17694720 17694720 17694720 No 126 n/a 0x00002AAFA940F7A0 DVL_03 bph 16 1 261504 58235264 420043136 59441152 420937728 59441152 No 409 n/a 0x00002AAFA94099D0 DVL_03 bph 16 4099 0 784768 784768 1835008 1835008 1835008 No 5 n/a 0x00002AAFA9403C00 DVL_03 bph 16 4098 0 522624 522624 1572864 1572864 1572864 No 3 n/a 0x00002AAFA93FDE30 DVL_03 bph 16 4097 0 391552 391552 1441792 1441792 1441792 No 2 n/a 0x00002AAFA93F8060 DVL_03 bph 16 4096 0 326016 326016 1376256 1376256 1376256 No 2 n/a 0x00002AAFA93F2290 DVL_03 shsorth 18 0 0 12104 751304 2359296 4980736 20578304 No 18 SHEAPTHRES_SHR 0x00002AAFA93EF3A8 DVL_03 lockh 4 0 0 55056512 67115136 55115776 67174400 57081856 No 1 LOCKLIST 0x00002AAFA93EC4C0 DVL_03 dbh 2 0 967904 104164395 104848275 107347968 107347968 137363456 No 7449 DBHEAP 0x00002AAFA009EF18 Appl stmth 12 34241 13120 164522825 164652361 168034304 168034304 8388608 No 74961 n/a 0x00002AAFA0817BD0 Appl apph 1 34249 0 18675 127833 196608 196608 33554432 No 33 APPLHEAPSZ 0x00002AAFA06DEF18 Appl apph 1 34241 0 41187 127833 196608 196608 33554432 No 46 APPLHEAPSZ 0x00002AAFA0527BD0 Appl apph 1 32807 0 24698 127816 196608 196608 33554432 No 41 APPLHEAPSZ 0x00002AAF9FB2EF18 Appl apph 1 19111 0 18658 127816 196608 196608 33554432 No 32 APPLHEAPSZ 0x00002AAFA051C030 Appl apph 1 8563 0 18675 127833 196608 196608 33554432 No 33 APPLHEAPSZ 0x00002AAFA0B2EF18 Appl apph 1 8569 0 18675 127833 196608 196608 33554432 No 33 APPLHEAPSZ 0x00002AAF9F897BD0 Appl apph 1 4442 0 27997 56403 65536 65536 33554432 No 48 APPLHEAPSZ 0x00002AAF9FB34CE8 Appl apph 1 4443 0 27381 56403 65536 65536 33554432 No 48 APPLHEAPSZ 0x00002AAF9F775178 Appl apph 1 36686 0 70263 421925 196608 458752 33554432 No 137 APPLHEAPSZ 0x00002AAF9F7A1110 Appl apph 1 33 0 17320 17320 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F79B340 Appl apph 1 32 0 17320 17320 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F795570 Appl apph 1 31 0 17320 17320 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F78F7A0 Appl apph 1 30 0 17320 17320 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F7899D0 Appl apph 1 29 0 99240 99744 196608 196608 33554432 No 1045 APPLHEAPSZ 0x00002AAF9F783C00 Appl apph 1 28 0 17320 17320 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F77DE30 Appl apph 1 27 0 17320 19304 65536 65536 33554432 No 21 APPLHEAPSZ 0x00002AAF9F778060 Appl apph 1 26 0 18008 127904 196608 196608 33554432 No 27 APPLHEAPSZ 0x00002AAF9F76C4C0 Appl appshrh 20 0 261408 9201768 17470380 12582912 20381696 81920000 No 3000 application shared ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.04.2015, 19:26 |
|
||
1 сообщений из 1, страница 1 из 1
|
|
Форумы
[новые:0]
/ IBM DB2, WebSphere, IMS, U2
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
10.5.0.4 The statement was not processed because a limit such as a memory limit
[новые:0]
