Created
October 27, 2022 02:21
-
-
Save xtender/a48edf801516a3a1c9e328edaedffe2c to your computer and use it in GitHub Desktop.
Trace PX to find DOP downgrade reasons
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SQL> col QKSXAREASONS for a80 | |
| SQL> select indx,qksxareasons from x$qksxa_reason where lower(qksxareasons) like '%dop%'; | |
| INDX QKSXAREASONS | |
| ---------- -------------------------------------------------------------------------------- | |
| 192 query coordinator did not used automatic DOP | |
| 205 default DOP mismatch | |
| 209 parallel execution mode DOP mismatch | |
| 221 number of partitions much greater than DoP | |
| 223 min number of hash partitions or sub-partitions greater than DoP | |
| 352 DOP downgrade due to adaptive DOP | |
| 353 DOP downgrade due to resource manager max DOP | |
| 354 DOP downgrade due to insufficient number of processes <--- | |
| 355 DOP downgrade because slaves failed to join | |
| 516 high NDV estimation of GROUP BY keys compared to DOP | |
| 10 rows selected. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SQL> alter system set events 'trace[Parallel_Execution.*]{process: ospid = 19942} disk=lowest'; | |
| System altered. | |
| -- limiting PDB to parallel_max_servers=4 just for this test case: | |
| SQL> alter system set parallel_max_servers=4 scope=memory; | |
| System altered. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Trace file /opt/oracle/diag/rdbms/ora19/ORA19/trace/ORA19_ora_19942_px1.trc | |
| Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production | |
| Version 19.11.0.0.0 | |
| Build label: RDBMS_19.11.0.0.0DBRU_LINUX.X64_210412 | |
| ORACLE_HOME: /opt/oracle/product/19c/dbhome_1 | |
| System name: Linux | |
| Node name: 4ce98707bd2b | |
| Release: 3.10.0-1160.25.1.el7.x86_64 | |
| Version: #1 SMP Wed Apr 28 21:49:45 UTC 2021 | |
| Machine: x86_64 | |
| Instance name: ORA19 | |
| Redo thread mounted by this instance: 1 | |
| Oracle process number: 38 | |
| Unix process pid: 19942, image: oracle@4ce98707bd2b | |
| *** 2022-10-27T02:05:55.305480+00:00 (PDB1(3)) | |
| *** SESSION ID:(743.9480) 2022-10-27T02:05:55.305572+00:00 | |
| *** CLIENT ID:() 2022-10-27T02:05:55.305592+00:00 | |
| *** SERVICE NAME:(pdb1) 2022-10-27T02:05:55.305605+00:00 | |
| *** MODULE NAME:(SQL*Plus) 2022-10-27T02:05:55.305620+00:00 | |
| *** ACTION NAME:() 2022-10-27T02:05:55.305634+00:00 | |
| *** CLIENT DRIVER:(SQL*PLUS) 2022-10-27T02:05:55.305646+00:00 | |
| *** CONTAINER ID:(3) 2022-10-27T02:05:55.305660+00:00 | |
| 2022-10-27 02:05:55.242*:PX_Granule:kxfr.c@9322:kxfrDefaultDOP(): | |
| deg:8 tpc:1 #cpus:8 cap:-1 service:pdb1 pig: ser:0 locl:0 | |
| Starting parallelizer rwsid:2 pxid:1 | |
| Starting SQL statement dump | |
| SQL Information | |
| user_id=107 user_name=XTENDER module=SQL*Plus action= | |
| sql_id=5xugyr6f5vtgn plan_hash_value=-973802575 problem_type=3 command_type=3 | |
| ----- Current SQL Statement for this session (sql_id=5xugyr6f5vtgn) ----- | |
| select/*+ parallel(23) */ count(*) from sys.obj$ | |
| sql_text_length=49 | |
| sql=select/*+ parallel(23) */ count(*) from sys.obj$ | |
| ----- Explain Plan Dump ----- | |
| ----- Plan Table ----- | |
| ============ | |
| Plan Table | |
| ============ | |
| ---------------------------------------------+-----------------------------------+-------------------------+ | |
| | Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib | | |
| ---------------------------------------------+-----------------------------------+-------------------------+ | |
| | 0 | SELECT STATEMENT | | | | 3 | | | | | | |
| | 1 | SORT AGGREGATE | | 1 | | | | | | | | |
| | 2 | PX COORDINATOR | | | | | | | | | | |
| | 3 | PX SEND QC (RANDOM) | :TQ10000| 1 | | | |:Q1000| P->S |QC (RANDOM)| | |
| | 4 | SORT AGGREGATE | | 1 | | | |:Q1000| PCWP | | | |
| | 5 | PX BLOCK ITERATOR | | 71K | | 3 | 00:00:01 |:Q1000| PCWC | | | |
| | 6 | INDEX FAST FULL SCAN | I_OBJ1 | 71K | | 3 | 00:00:01 |:Q1000| PCWP | | | |
| ---------------------------------------------+-----------------------------------+-------------------------+ | |
| Query Block Name / Object Alias (identified by operation id): | |
| ------------------------------------------------------------ | |
| 1 - SEL$1 | |
| 6 - SEL$1 / "OBJ$"@"SEL$1" | |
| ------------------------------------------------------------ | |
| Predicate Information: | |
| ---------------------- | |
| 6 - access(:Z>=:Z AND :Z<=:Z) | |
| Content of other_xml column | |
| =========================== | |
| derived_cpu_dop: 0 | |
| derived_io_dop : 0 | |
| dop_reason : hint | |
| dop : 23 | |
| px_in_memory_imc: no | |
| px_in_memory : no | |
| db_version : 19.0.0.0 | |
| parse_schema : XTENDER | |
| plan_hash_full : 238785628 | |
| plan_hash : 3321164721 | |
| plan_hash_2 : 238785628 | |
| ----------------- | |
| Optimizer Metrics | |
| ----------------- | |
| <stats type="compilation"><stat name="bg">0</stat></stats> | |
| Outline Data: | |
| /*+ | |
| BEGIN_OUTLINE_DATA | |
| IGNORE_OPTIM_EMBEDDED_HINTS | |
| OPTIMIZER_FEATURES_ENABLE('19.1.0') | |
| DB_VERSION('19.1.0') | |
| ALL_ROWS | |
| OUTLINE_LEAF(@"SEL$1") | |
| INDEX_FFS(@"SEL$1" "OBJ$"@"SEL$1" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#")) | |
| END_OUTLINE_DATA | |
| */ | |
| Hint Report: | |
| Statement: | |
| parallel(23) | |
| End Hint Report | |
| ====================== END SQL Statement Dump ====================== | |
| 2022-10-27 02:05:55.305*:PX_Granule:kxfr.c@2707:kxfrialo(begin): | |
| id:1 #sets:1 #objs:1 #gdef:1 #sm:0 sflg:0 | |
| 2022-10-27 02:05:55.305*:PX_Granule:kxfr.c@9322:kxfrDefaultDOP(): | |
| deg:8 tpc:1 #cpus:8 cap:-1 service:pdb1 pig: ser:0 locl:0 | |
| 2022-10-27 02:05:55.305*:PX_Granule:kxfr.c@2847:kxfrialo(): | |
| Start: building object table (1) | |
| 2022-10-27 02:05:55.305*:PX_Granule:kxfr.c@6586:kxfrFlushObjs(begin): | |
| Flushing 1 objects | |
| 2022-10-27 02:05:55.305*:PX_Granule:kxfr.c@6873:kxfrFlushObjs(end): | |
| flushed 0 objects and 0 temp objects | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@11136:kxfpgsg(begin): | |
| reqthreads=23 height=0 lsize=0 alloc_flg=0x230 | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@11211:kxfpgsg(): | |
| reqthreads=23 alloc_flg=0x230 load balancing=on adaptive=off | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@21521:kxfpiinfo(): | |
| inst pdb [cpus:mxslv:tgsl:bc(MB) :pga_target(MB):type] | |
| 1 3 [8 :4 :4 :336 :512 :HUB] | |
| new q=0x8a82e240 dp=(nil) pnum=65535 numa#=0 qser=0 done. | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@12612:kxfpg1sg(): | |
| q=0x8a82e240 req_threads=23 nthreads=23 unit=1 #inst=1 alloc_flg=0x230 normal | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@15403:kxfpcre1(): | |
| Allocated slave=P00L dp=0x8c9f7550 flg=4 | |
| 2022-10-27 02:05:55.305*:PX_Messaging:kxfp.c@15403:kxfpcre1(): | |
| Allocated slave=P00M dp=0x8c9f7610 flg=4 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 1 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 2 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 3 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 4 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 5 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 6 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 7 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 8 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 9 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 10 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 11 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 12 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 13 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 14 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 15 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 16 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 17 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 18 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 19 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 20 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 21 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 22 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@12812:kxfpg1sg(): Got It. 23 so far. | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbaa408 server=1.0 qser=15361 qdp.sid=0 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7fb468 server=1.1 qser=15361 qdp.sid=1 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.1 qref=0x8a7fb468 msg=0x9c853fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbab398 server=1.2 qser=15361 qdp.sid=2 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.2 qref=0x7bbab398 msg=0x9dfebfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbab100 server=1.3 qser=15361 qdp.sid=3 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.3 qref=0x7bbab100 msg=0x9c877fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7f9fa8 server=1.4 qser=15361 qdp.sid=4 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.4 qref=0x8a7f9fa8 msg=0x9cfbbfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7faa08 server=1.5 qser=15361 qdp.sid=5 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7f9d10 server=1.6 qser=15361 qdp.sid=6 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.6 qref=0x8a7f9d10 msg=0x9d853fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a82f488 server=1.7 qser=15361 qdp.sid=7 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7f9a78 server=1.8 qser=15361 qdp.sid=8 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7fa770 server=1.9 qser=15361 qdp.sid=9 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.9 qref=0x8a7fa770 msg=0x9dfdbfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81d760 server=1.10 qser=15361 qdp.sid=10 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.10 qref=0x8a81d760 msg=0x9dfe7fd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81d230 server=1.11 qser=15361 qdp.sid=11 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.11 qref=0x8a81d230 msg=0x9bfe7fd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81d4c8 server=1.12 qser=15361 qdp.sid=12 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.12 qref=0x8a81d4c8 msg=0x9c843fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbaa938 server=1.13 qser=15361 qdp.sid=13 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.13 qref=0x7bbaa938 msg=0x9c873fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbaa6a0 server=1.14 qser=15361 qdp.sid=14 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.14 qref=0x7bbaa6a0 msg=0x9c86ffc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a82f1f0 server=1.15 qser=15361 qdp.sid=15 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.15 qref=0x8a82f1f0 msg=0x9d843fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7f97e0 server=1.16 qser=15361 qdp.sid=16 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.16 qref=0x8a7f97e0 msg=0x9c863fc0 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x7bbab630 server=1.17 qser=15361 qdp.sid=17 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.17 qref=0x7bbab630 msg=0x9bfebfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81cf98 server=1.18 qser=15361 qdp.sid=18 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.18 qref=0x8a81cf98 msg=0x9bfbffd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7fa4d8 server=1.19 qser=15361 qdp.sid=19 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.19 qref=0x8a7fa4d8 msg=0x9dfd7fd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81d9f8 server=1.20 qser=15361 qdp.sid=20 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.20 qref=0x8a81d9f8 msg=0x9dfcffd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a7fa240 server=1.21 qser=15361 qdp.sid=21 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.21 qref=0x8a7fa240 msg=0x9dfcbfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13129:kxfpg1sg(): | |
| need to allocate qref to slaves | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13143:kxfpg1sg(): | |
| qref=0x8a81cd00 server=1.22 qser=15361 qdp.sid=22 qdp.iid=1 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.22 qref=0x8a81cd00 msg=0x9cffbfd8 len=6562 st=2 | |
| mty=2 (JOI) enq#=9(KXFP JOIN GROUP MESSAGE) flg=0x8 state=10011 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@25273:kxfpSendJoin(): msg sent(frag size: 16064, data size: 6250, force frags: FALSE | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x7bbaa938 server=1.13 pid=19803 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81d4c8 server=1.12 pid=19801 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x7bbaa6a0 server=1.14 pid=19805 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81d9f8 server=1.20 pid=20008 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7fa240 server=1.21 pid=20038 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7f97e0 server=1.16 pid=20000 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.335*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81cd00 server=1.22 pid=20040 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x7bbab398 server=1.2 pid=16765 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x7bbab100 server=1.3 pid=16767 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7f9fa8 server=1.4 pid=19699 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7f9d10 server=1.6 pid=19703 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81d760 server=1.10 pid=19797 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81d230 server=1.11 pid=19799 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a82f1f0 server=1.15 pid=19807 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7fa4d8 server=1.19 pid=20006 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7fb468 server=1.1 pid=16763 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a7fa770 server=1.9 pid=19795 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x8a81cf98 server=1.18 pid=20004 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13265:kxfpg1sg(): | |
| join failed qref=0x7bbab630 server=1.17 pid=20002 reason=pdb max servers limit(13) err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fb468 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.1 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fb468 action=1 server=1.1 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09d70 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbab398 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.2 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbab398 action=1 server=1.2 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a8e8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbab100 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.3 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbab100 action=1 server=1.3 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0ae98 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f9fa8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.4 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f9fa8 action=1 server=1.4 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a092c8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f9d10 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.6 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f9d10 action=1 server=1.6 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a080d0 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fa770 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.9 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fa770 action=1 server=1.9 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0b108 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d760 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.10 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d760 action=1 server=1.10 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09468 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d230 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.11 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d230 action=1 server=1.11 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0af68 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d4c8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.12 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d4c8 action=1 server=1.12 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a07d90 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa938 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.13 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa938 action=1 server=1.13 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0aa88 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa6a0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.14 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa6a0 action=1 server=1.14 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a320 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a82f1f0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.15 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a82f1f0 action=1 server=1.15 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0b6d0 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f97e0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.16 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f97e0 action=1 server=1.16 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09128 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbab630 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.17 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbab630 action=1 server=1.17 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0acf8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81cf98 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.18 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81cf98 action=1 server=1.18 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a9b8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fa4d8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.19 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fa4d8 action=1 server=1.19 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a818 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d9f8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.20 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d9f8 action=1 server=1.20 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0adc8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fa240 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.21 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fa240 action=1 server=1.21 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09bd0 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81cd00 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.22 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81cd00 action=1 server=1.22 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a748 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13324:kxfpg1sg(): | |
| got 4 servers (sync), errors=0x0 returning | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@11930:kxfpgsg(): threads reduced from 23 to 4 due to not enough slaves | |
| Acquired 4 slaves on 1 instances avg height=4 #set=1 qser=15361 | |
| P000 set 1 inst 1 spid 16761 | |
| P008 set 1 inst 1 spid 19793 | |
| P007 set 1 inst 1 spid 19705 | |
| P005 set 1 inst 1 spid 19701 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@12157:kxfpgsg(): | |
| Instance(servers): | |
| inst=1 #slvs=4 | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9048:kxfxcp(begin): | |
| Sending parse to nprocs:4 #slave_set:1 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=5048 st=2 | |
| mty=6 (DTA) enq#=20(KXFX PARSE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=5048 st=2 | |
| mty=6 (DTA) enq#=20(KXFX PARSE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=5048 st=2 | |
| mty=6 (DTA) enq#=20(KXFX PARSE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=5048 st=2 | |
| mty=6 (DTA) enq#=20(KXFX PARSE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9083:kxfxcp(): | |
| Wait for all parse replies | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9230:kxfxcp(end): | |
| parse finished, all parse reply received #failures:0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@11051:kxfpValidateSlaveGroup(): | |
| Query start, buffer cache support for numa enabled: YES | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@12443:kxfpgsg(end): | |
| slave group q=0x8a82e240 | |
| 2022-10-27 02:05:55.342*:PX_Granule:kxfr.c@3324:kxfrialo(): | |
| Start: generating granules (1) imc_px-0 | |
| 2022-10-27 02:05:55.342*:PX_Granule:kxfr.c@3430:kxfrialo(end): | |
| Finished granules allocation and slave acquisition (qcq:0x8a82e240) | |
| kxfqopn [ 66/ 66] | |
| TQ header info | |
| kxfqh : 0x7fdf2b60ed40 | |
| kxfqhflg : 0x1 TQ handle open | |
| kxfqhmkr : 0x4 QC | |
| kxfqhpc : 2 1:producer 2:consumer 3:ranger | |
| kxfqepty : 4 | |
| kxfqhnsam : 4 | |
| kxfqhnth : 4 | |
| kxfqhDbaHashMask: -1 | |
| kxfqhrrThreshold: 1 | |
| kxfqhnky: 0 | |
| kxfqhdsc : TQ descriptor | |
| kxfqd : 0x7aaca800 | |
| kxfqdtqi : 0 | |
| kxfqdcc : 0x14 TQ: from slave set 1 to QC | |
| kxfqdpty : 4 | |
| kxfqdsmp : 90 number of samples | |
| kxfqdflg : 0x800080 | |
| /KXFQDFPAGG/KXFQDF_FASTENQ | |
| kxfqdFlags: | |
| kxfqdstart: 0 partitioning column offset | |
| kxfqdfmt : TQ format | |
| kxfqfnco : 1 number of TQ columns | |
| kxfqfnky : 0 number of key columns | |
| kxfqfnpcol: 0 number of partitioning columns | |
| TQ column kxfqcbfl kxfqcdty kxfqcflg kxfqcplen | |
| kxfqfcol[ 0]: 10 209 0x0 10 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=640 st=2 | |
| mty=6 (DTA) enq#=21(KXFX EXECUTE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=640 st=2 | |
| mty=6 (DTA) enq#=21(KXFX EXECUTE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=640 st=2 | |
| mty=6 (DTA) enq#=21(KXFX EXECUTE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=640 st=2 | |
| mty=6 (DTA) enq#=21(KXFX EXECUTE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=448 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d86bfc0 len=336 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bfd3fd8 len=336 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9bfdbfd8 len=336 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9c84bfc0 len=336 st=2 | |
| mty=6 (DTA) enq#=29(KXFX GRANULE) flg=0x1 state=10011 | |
| kxfqcls [ 68/ 2] | |
| kxfqh : 0x7fdf2b60ed40 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4019:kxfpqsod(begin): | |
| q=0x8a82e240 qser=15361 qinc=0 action=0x1 flg=0x424 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@14134:kxfpssg(): | |
| Signaling OER(10387) in q=0x8a82e240 qser=15361 qinc=1 nqr=4 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@16272:kxfplsig(): signaling err=10387 in q=(nil) qser=15361 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@16296:kxfplsig(): target slave is 0.0, current slave is 1.0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@25455:kxfpSignalSlave(): signal: dp=0x8c9f6580 dpflg=8 q=0x8a83d6a8 qser=15361 pr=0x99599ec0 cqr=0x8a8393f8 err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@16296:kxfplsig(): target slave is 0.0, current slave is 1.5 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@25455:kxfpSignalSlave(): signal: dp=0x8c9f6940 dpflg=8 q=0x8a82df98 qser=15361 pr=0x995bb6b0 cqr=0x8a7faca0 err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@16296:kxfplsig(): target slave is 0.0, current slave is 1.7 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@25455:kxfpSignalSlave(): signal: dp=0x8c9f6ac0 dpflg=8 q=0x8a821ca8 qser=15361 pr=0x995be190 cqr=0x8a82fc50 err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@16296:kxfplsig(): target slave is 0.0, current slave is 1.8 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@25455:kxfpSignalSlave(): signal: dp=0x8c9f6b80 dpflg=8 q=0x8a81ca58 qser=15361 pr=0x995bf700 cqr=0x8a82ef58 err=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.0 qref=0x7bbaa408 msg=0x9d85ffc0 len=304 st=2 | |
| mty=10 (SST) enq#=18(KXFP SESSION STATS) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.8 qref=0x8a7f9a78 msg=0x9bffbfd8 len=304 st=2 | |
| mty=10 (SST) enq#=18(KXFP SESSION STATS) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.7 qref=0x8a82f488 msg=0x9d84bfc0 len=304 st=2 | |
| mty=10 (SST) enq#=18(KXFP SESSION STATS) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@5202:kxfprienq(): | |
| Sending to server=1.5 qref=0x8a7faa08 msg=0x9d873fc0 len=304 st=2 | |
| mty=10 (SST) enq#=18(KXFP SESSION STATS) flg=0x1 state=10011 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f9a78 q=0x8a82e240 qflg=404 qrser=15361 qrseq=3 server=1.8 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f9a78 action=1 server=1.8 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a678 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a82f488 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.7 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a82f488 action=1 server=1.7 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a08d18 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7faa08 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.5 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7faa08 action=1 server=1.5 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a250 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa408 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.0 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa408 action=1 server=1.0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0ac28 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@3768:kxfpqsod_qc_sod(): all slaves released qser=15361 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4076:kxfpqsod(): | |
| Query end, buffer cache support for numa enabled: YES | |
| ------------------------------------------------------------------------------- | |
| Trace Bucket Dump Begin: PX Blackbox | |
| CDB_NAME(CON_ID):TIME(*=approx):COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: DATA | |
| ------------------------------------------------------------------------------- | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d760 action=1 server=1.10 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09468 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d230 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.11 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d230 action=1 server=1.11 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0af68 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d4c8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.12 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d4c8 action=1 server=1.12 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a07d90 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa938 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.13 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa938 action=1 server=1.13 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0aa88 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa6a0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.14 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa6a0 action=1 server=1.14 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a320 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a82f1f0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.15 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a82f1f0 action=1 server=1.15 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0b6d0 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f97e0 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.16 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f97e0 action=1 server=1.16 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09128 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbab630 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.17 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbab630 action=1 server=1.17 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0acf8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81cf98 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.18 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81cf98 action=1 server=1.18 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a9b8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fa4d8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.19 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fa4d8 action=1 server=1.19 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a818 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81d9f8 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.20 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81d9f8 action=1 server=1.20 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0adc8 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7fa240 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.21 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7fa240 action=1 server=1.21 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a09bd0 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a81cd00 q=0x8a82e240 qflg=400 qrser=15361 qrseq=2 server=1.22 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a81cd00 action=1 server=1.22 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a748 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@13324:kxfpg1sg(): | |
| got 4 servers (sync), errors=0x0 returning | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@11930:kxfpgsg(): threads reduced from 23 to 4 due to not enough slaves | |
| Acquired 4 slaves on 1 instances avg height=4 #set=1 qser=15361 | |
| P000 set 1 inst 1 spid 16761 | |
| P008 set 1 inst 1 spid 19793 | |
| P007 set 1 inst 1 spid 19705 | |
| P005 set 1 inst 1 spid 19701 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@12157:kxfpgsg(): | |
| Instance(servers): | |
| inst=1 #slvs=4 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@7248:qerpxSendParse(): --> parse qser:15361 pxid:1 mflg:0x0 #slaves:4 | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9048:kxfxcp(begin): | |
| Sending parse to nprocs:4 #slave_set:1 | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9083:kxfxcp(): | |
| Wait for all parse replies | |
| 2022-10-27 02:05:55.342*:PX_Control:kxfx.c@9230:kxfxcp(end): | |
| parse finished, all parse reply received #failures:0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@11051:kxfpValidateSlaveGroup(): | |
| Query start, buffer cache support for numa enabled: YES | |
| 2022-10-27 02:05:55.342*:PX_Granule:kxfr.c@3324:kxfrialo(): | |
| Start: generating granules (1) imc_px-0 | |
| 2022-10-27 02:05:55.342*:PX_Granule:kxfr.c@3430:kxfrialo(end): | |
| Finished granules allocation and slave acquisition (qcq:0x8a82e240) | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@12767:qerpxSetupAndAllocSlaves(): DOP downgraded to 4(reason_code = 354) | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:0 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:1 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:2 | |
| 2022-10-27 02:05:55.342*:PX_Scheduler:qerpx.c@10441:qerpxFetch(): <-- granule pxid:1 rwsrid:2 dfo:0 slv:3 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4019:kxfpqsod(begin): | |
| q=0x8a82e240 qser=15361 qinc=0 action=0x1 flg=0x424 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7f9a78 q=0x8a82e240 qflg=404 qrser=15361 qrseq=3 server=1.8 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7f9a78 action=1 server=1.8 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a678 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a82f488 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.7 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a82f488 action=1 server=1.7 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a08d18 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x8a7faa08 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.5 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x8a7faa08 action=1 server=1.5 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0a250 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4397:kxfpqrsod(): | |
| del qref=0x7bbaa408 q=0x8a82e240 qflg=504 qrser=15361 qrseq=3 server=1.0 action=1 sopr=0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4570:kxfpqsrls(): | |
| Release Slave q=0x8a82e240 qr=0x7bbaa408 action=1 server=1.0 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4655:kxfpqsrls(): | |
| got enq=0x96a0ac28 in exclusive mode | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4736:kxfpqsrls(): | |
| cleaning up enqueue lock value | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@3768:kxfpqsod_qc_sod(): all slaves released qser=15361 | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4076:kxfpqsod(): | |
| Query end, buffer cache support for numa enabled: YES | |
| ------------------------------------------------------------------------------- | |
| Trace Bucket Dump End: PX Blackbox | |
| 2022-10-27 02:05:55.342*:PX_Messaging:kxfp.c@4083:kxfpqsod(end): Teardown ret: Succeed |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment