RE: Locking issue

From: Noveljic Nenad <nenad.noveljic_at_vontobel.com>
Date: Thu, 27 May 2021 11:27:29 +0000
Message-ID: <17cf29bec6f04994b93486b6f1da772a_at_vontobel.com>

Hi Lok

Could you please include the lines immediately before “----- End of Abridged Call Stack Trace -----“ It should be something like

kqrpre: … cid=62 stack: ----- Abridged Call Stack Trace ----- and then the short call stack.

Best regards,
Nenad

From: Lok P <loknath.73_at_gmail.com>
Sent: Donnerstag, 27. Mai 2021 13:21
To: Noveljic Nenad <nenad.noveljic_at_vontobel.com> Subject: Re: Locking issue

Below is the one as requested.

End of Abridged Call Stack Trace -----

Partial short call stack signature: 0x9e2e116b542b9042

kqrpre: returnVal: TRUE

kqrpre: start hash=dc7ac22a mode=S keyIndex=0 dur=CALL opt=FALSE

kqrSetIncarnation: po=0x69ee83058 idn set to 1 1

kqrHashTableInsert: inserting po = 0x69ee83058

time=3801653824

kqrpad: new po 0x69ee83058 hash dc7ac22a key_index 0 from kqrpre1

row cache parent object: addr=0x69ee83058 cid=62(dc_realtime_colst) conid=0 conuid=0

hash=dc7ac22a typ=61 transaction=(nil) flags=00000000 inc=1, pdbinc=1

version=1 mtx version=3

own=0x69ee83128[0x69ee83128,0x69ee83128] wat=0x69ee83138[0x69ee83138,0x69ee83138] mode=N req=N

status=-/-/-/-/-/-/-/-/- KGH pinned

instance lock=QK dc7ac22a 7943c8a6

data=

0001119b 00000001 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000100 dc7ac22a 00010003 00000000

9ee83058 00000006 609c6f18 00000007 609c6f18 00000007 00000000 00000000

kqrAllocateEnqueue: bis: po=0x69ee83058 flag=00010000 before=00000000 after=00010000

kqrGetClusterLock bic: po=0x69ee83058 flag=00010000 before=00010000 after=00000000

kqrInstanceLock: op = KQRILGET po = 0x69ee83058 lk = 0x66efd4778 mode = 3 ilh = 0x66efd47d0

kqrInstanceLock: po = 0x69ee83058 status = 0 error = 0 ilh = 0x66efd47d0

kqrClusterLock po=0x69ee83058 mode=3 timeout=ffff opt=NWT flg=82 err=0

kqrGetClusterLock bis: po=0x69ee83058 flag=00008000 before=00000000 after=00008000

kqrReadFromDB : kqrpre1.1 po=0x69ee83058 flg=8000 cid=62 eq=0x66efd4700 idx=0 dsflg=0

kqdOpenBundled : rp8=0x7fb23fbca5d8 cu=0x7fb23fbca5b0 cnum=4 cur=0x7fb242b14858 xsc=(nil) hsh=0 val=65559 curid=1

kqrpre: start hash=19430df7 mode=S keyIndex=0 dur=CALL opt=TRUE

kqrpre: optimistic lookup: hash=19430df7

kqrpre: optimistic lookup: searching cache 0 po 0x73bee3908 hash 5b2ad36f ver 1

kqrpre: optimistic lookup: searching cache 1 po 0x74bfb16b0 hash b6d844b9 ver 1

kqrpre: optimistic lookup: searching cache 2 po 0x6b5ec9988 hash 1eb76ed1 ver 1

kqrpre: optimistic lookup: searching cache 3 po 0x719c6f5a0 hash f07219c5 ver 1

kqrpre: optimistic lookup: searching cache 4 po 0x71994bff8 hash 35e74caf ver 1

kqrpre: optimistic lookup: searching cache 5 po 0x6af4e7bf8 hash 46229d00 ver 1

kqrpre: optimistic lookup: searching cache 6 po 0x75176b5f0 hash 3d353950 ver 1

kqrpre: optimistic lookup: searching cache 7 po 0x6f367ad38 hash 999653d4 ver 1

kqrpre: optimistic lookup: searching cache 8 po 0x700842d98 hash 2cad6213 ver 1

kqrpre: optimistic lookup: searching cache 9 po 0x671f25258 hash 760e449 ver 1

kqrpre: optimistic lookup: reading hash mtx addr=0x7675cea8e version=86

kqrpre: optimistic lookup: processing po 0x70b8d0ef8 mtx addr=0x70b8d12b8 version=28

kqrpre: optimistic lookup: lock mode 0 flag 00000002

kqrpre: optimistic lookup: copied po 0x70b8d0ef8 to cache 4

kqrpre: optimistic lookup: success

kqrpre: done po=0x7fb23fb715f0 cid=8 flg=2 eq=0x6f330fb20 pso=0x6966657b8 dur=CALL

kqrpre: keyIndex=0 hash=19430df7 b24a568a 0

kqrpre: obobn=14862 obname=WRI$_OPTSTAT_HISTHEAD_HISTORY obtyp=2 obsta=1 obflg=4194304

kqrpre: SQL=select timestamp#, sample_size, minimum, maximum, lowval, hival, null_cnt, avgcln, spare1, spare2 from wri$_optstat_histhead_history where obj#=:1 and intcol#=:2 and savtime = timestamp '4000-12-01 01:00:00 -0:0' kqrpre: time=3801654172

kqrpre: po=0x7fb23fb715f0 cid=8 stack: ----- Abridged Call Stack Trace -----

ksedsts()+426<-kqrpreDoneTrace()+607<-kqrpre1()+3854<-kkdlSetTableVersion()+387<-kkdlgstd()+275<-kkmfcbloCbk()+172<-kkmpfcbk()+235<-qcsprfro()+648<-qcsprfro_tree()+372<-qcsprfro_tree()+138<-qcspafq()+240<-qcspqbDescendents()+264<-qcspqb()+255<-kkmdrv()+180

<-opiSem()+2191<-opiprs()+321<-kksParseChildCursor()+527<-rpiswu2()+2004<-kksLoadChild()+5283<-kxsGetRuntimeLock()+1983<-kksfbc()+18656<-kkspsc0()+1566<-kksParseCursor()+114<-opiosq0()+2310<-opiall0()+4805<-opikpr()+595<-opiodr()+1202<-rpidrus()+198<-skgmstack()+65

<-rpidru()+132<-rpiswu2()+543<-kprball()+1046<-kqdGetBundledCursor()+462<-qosliveColStLoad()+314<-kqrReadFromDB()+338<-kqrpre()+1360<-kkestRCSBase()+5869<-kkercs()+211<-kkehrd_prealo()+1059<-kkoarl()+405<-kkoiqb()+9406<-kkooqb()+587<-kkoqbc()+2707<-apakkoqb()+159

<-apaqbdDescendents()+480<-apaqbd()+140<-apadrv()+1254<-opitca()+2226<-kksLoadChild()+7535<-kxsGetRuntimeLock()+1983<-kksfbc()+18656<-kkspsc0()+1566<-kksParseCursor()+114<-opiosq0()+2310<-kpooprx()+387<-kpoal8()+830<-opiodr()+1202<-ttcpip()+1222<-opitsk()+1900

<-opiino()+936<-opiodr()+1202<-opidrv()+1094<-sou2o()+165<-opimai_real()+422<-ssthrdmain()+417<-main()+256<-__libc_start_main()+245

End of Abridged Call Stack Trace -----

Partial short call stack signature: 0xabdd9645439f74f2

kqrpre: returnVal: TRUE

kqrprl: eq=0x6f330fb20 fpInUse=TRUE

Abridged Call Stack Trace -----

ksedsts()+426<-kqrprl()+1271<-kkdlSetTableVersion()+578<-kkdlgstd()+275<-kkmfcbloCbk()+172<-kkmpfcbk()+235<-qcsprfro()+648<-qcsprfro_tree()+372<-qcsprfro_tree()+138<-qcspafq()+240<-qcspqbDescendents()+264<-qcspqb()+255<-kkmdrv()+180<-opiSem()+2191<-opiprs()+321

<-kksParseChildCursor()+527<-rpiswu2()+2004<-kksLoadChild()+5283<-kxsGetRuntimeLock()+1983<-kksfbc()+18656<-kkspsc0()+1566<-kksParseCursor()+114<-opiosq0()+2310<-opiall0()+4805<-opikpr()+595<-opiodr()+1202<-rpidrus()+198<-skgmstack()+65<-rpidru()+132<-rpiswu2()+543

<-kprball()+1046<-kqdGetBundledCursor()+462<-qosliveColStLoad()+314<-kqrReadFromDB()+338<-kqrpre()+1360<-kkestRCSBase()+5869<-kkercs()+211<-kkehrd_prealo()+1059<-kkoarl()+405<-kkoiqb()+9406<-kkooqb()+587<-kkoqbc()+2707<-apakkoqb()+159<-apaqbdDescendents()+480

<-apaqbd()+140<-apadrv()+1254<-opitca()+2226<-kksLoadChild()+7535<-kxsGetRuntimeLock()+1983<-kksfbc()+18656<-kkspsc0()+1566<-kksParseCursor()+114<-opiosq0()+2310<-kpooprx()+387<-kpoal8()+830<-opiodr()+1202<-ttcpip()+1222<-opitsk()+1900<-opiino()+936<-opiodr()+1202

<-opidrv()+1094<-sou2o()+165<-opimai_real()+422<-ssthrdmain()+417<-main()+256<-__libc_start_main()+245

End of Abridged Call Stack Trace -----

Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.

Important Notice

This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system. Without prejudice to any contractual agreements between you and us which shall prevail in any case, we take it as your authorization to correspond with you by e-mail if you send us messages by e-mail. However, we reserve the right not to execute orders and instructions transmitted by e-mail at any time and without further explanation. E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively referred to as "Vontobel Group") for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version. Please note that all e-mail communications to and from the Vontobel Group are subject to electronic storage and review by Vontobel Group. Unless stated to the contrary and without prejudice to any contractual agreements between you and Vontobel Group which shall prevail in any case, e-mail-communication is for informational purposes only and is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. The legal basis for the processing of your personal data is the legitimate interest to develop a commercial relationship with you, as well as your consent to forward you commercial communications. You can exercise, at any time and under the terms established under current regulation, your rights. If you prefer not to receive any further communications, please contact your client relationship manager if you are a client of Vontobel Group or notify the sender. Please note for an exact reference to the affected group entity the corporate e-mail signature. For further information about data privacy at Vontobel Group please consult www.vontobel.com <https://www.vontobel.com>.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 27 2021 - 13:27:29 CEST

This message: [ Message body ]
Next message: Noveljic Nenad: "RE: Locking issue"
Previous message: Noveljic Nenad: "RE: Locking issue"
Maybe in reply to: Lok P: "Locking issue"
Next in thread: Noveljic Nenad: "RE: Locking issue"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message