当前位置：Gxlcms > mysql > gdb调试之---当update时第一个持有的Latch是什么Latch锁？

gdb调试之---当update时第一个持有的Latch是什么Latch锁？

时间：2021-07-01 10:21:17 帮助过：47人阅读

转载请注明出处 ：http://blog.csdn.net/guoyjoe/article/details/18456937 1、查出当前会话所对应的系统进程号：SPID=7376，如下语句（在第一个窗口执行） gyj@OCM select spid from v$session s,v$process p where s.paddr=p.addr and sid in(select disti

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/18456937

1、查出当前会话所对应的系统进程号：SPID=7376，如下语句（在第一个窗口执行）

  1. gyj@OCM> select spid from v$session s,v$process p where s.paddr=p.addr and sid in(select distinct sid from v$mystat);
  2. SPID
  3. ------------------------
  4. 7376
  1. [oracle@mydb ~]$ gdb $ORACLE_HOME/bin/oracle 7376
  2. GNU gdb Fedora (6.8-27.el5)
  3. Copyright (C) 2008 Free Software Foundation, Inc.
  4. License GPLv3+: GNU GPL version 3 or later <http: gnu.org="" licenses="" gpl.html="">
  5. This is free software: you are free to change and redistribute it.
  6. There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
  7. and "show warranty" for details.
  8. This GDB was configured as "x86_64-redhat-linux-gnu"...
  9. (no debugging symbols found)
  10. Attaching to program: /u01/app/oracle/product/11.2.0/bin/oracle, process 7376
  11. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libodm11.so...(no debugging symbols found)...done.
  12. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libodm11.so
  13. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libcell11.so...done.
  14. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libcell11.so
  15. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxp11.so...done.
  16. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxp11.so
  17. Reading symbols from /lib64/librt.so.1...done.
  18. Loaded symbols for /lib64/librt.so.1
  19. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnnz11.so...done.
  20. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnnz11.so
  21. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libclsra11.so...done.
  22. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libclsra11.so
  23. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so...done.
  24. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so
  25. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libhasgen11.so...done.
  26. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libhasgen11.so
  27. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxn2.so...done.
  28. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxn2.so
  29. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocr11.so...done.
  30. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocr11.so
  31. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrb11.so...done.
  32. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrb11.so
  33. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrutl11.so...done.
  34. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrutl11.so
  35. Reading symbols from /usr/lib64/libaio.so.1...done.
  36. Loaded symbols for /usr/lib64/libaio.so.1
  37. Reading symbols from /lib64/libdl.so.2...done.
  38. Loaded symbols for /lib64/libdl.so.2
  39. Reading symbols from /lib64/libm.so.6...done.
  40. Loaded symbols for /lib64/libm.so.6
  41. Reading symbols from /lib64/libpthread.so.0...done.
  42. [Thread debugging using libthread_db enabled]
  43. [New Thread 0x2b0b8fef0910 (LWP 7376)]
  44. Loaded symbols for /lib64/libpthread.so.0
  45. Reading symbols from /lib64/libnsl.so.1...done.
  46. Loaded symbols for /lib64/libnsl.so.1
  47. Reading symbols from /lib64/libc.so.6...done.
  48. Loaded symbols for /lib64/libc.so.6
  49. Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
  50. Loaded symbols for /lib64/ld-linux-x86-64.so.2
  51. Reading symbols from /usr/lib64/libnuma.so.1...done.
  52. Loaded symbols for /usr/lib64/libnuma.so.1
  53. Reading symbols from /lib64/libnss_files.so.2...done.
  54. Loaded symbols for /lib64/libnss_files.so.2
  55. Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnque11.so...done.
  56. Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnque11.so
  57. 0x0000003f0d40d290 in __read_nocancel () from /lib64/libpthread.so.0
  58. (gdb)  </http:>

3、设一个断点，持有第一个Latch锁(预先知道函数kslgetl就是持有Latch的函数)，并运行（c命令，即continue）（在第二个窗口执行）

  1. (gdb) b kslgetl
  2. Breakpoint 1 at 0x8f96376
  3. (gdb) c
  4. Continuing.

4、执行一个update语句，触发断点的操作，此时update被阻塞了（在第一个窗口执行） 

  1. gyj@OCM> update gyj_test set name='AAAAA' where id=1;

5、一执行updater操作，断点就停在这儿了（在第二个窗口执行）

  1. Breakpoint 1, 0x0000000008f96376 in kslgetl ()
  2. (gdb)

6、我们先来看update时持有第一个Latch锁所对应函数kslgetl ()的第一个参数是什么？用命令info all-register显示寄存器（在第二个窗口执行）

  1. (gdb) info all-register
  2. rax            0x0      0
  3. rbx            0x2000   8192
  4. rcx            0xf27    3879
  5. rdx            0x0      0
  6. rsi            0x1      1
  7. rdi            0x601082f0       1611694832
  8. rbp            0x7fff1c5754d0   0x7fff1c5754d0
  9. rsp            0x7fff1c5754d0   0x7fff1c5754d0
  10. r8             0xf27    3879
  11. r9             0xbaf3fa0        196034464
  12. r10            0x0      0
  13. r11            0xf27    3879
  14. r12            0x927db800       2457712640
  15. r13            0x601082f0       1611694832
  16. r14            0x1      1
  17. r15            0x1      1
  18. rip            0x8f96376        0x8f96376 <kslgetl+4>
  19. eflags         0x246    [ PF ZF IF ]
  20. cs             0x33     51
  21. ss             0x2b     43
  22. ds             0x0      0
  23. es             0x0      0
  24. fs             0x0      0
  25. gs             0x0      0
  26. st0            0        (raw 0x00000000000000000000)
  27. ---Type <return> to continue, or q <return> to quit---
  28. st1            0        (raw 0x00000000000000000000)
  29. st2            0        (raw 0x00000000000000000000)
  30. st3            0        (raw 0x00000000000000000000)
  31. st4            0        (raw 0x00000000000000000000)
  32. st5            0        (raw 0x00000000000000000000)
  33. st6            333296   (raw 0x4011a2be000000000000)
  34. st7            300384   (raw 0x401192ac000000000000)
  35. fctrl          0x27f    639
  36. fstat          0x0      0
  37. ftag           0xffff   65535
  38. fiseg          0x0      0
  39. fioff          0x9394e95        154750613
  40. foseg          0x7fff   32767
  41. fooff          0x1c573f50       475479888
  42. fop            0x0      0
  43. xmm0           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  44.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  45. xmm1           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  46.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  47. xmm2           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  48.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  49. xmm3           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x8000000000000000, 0x8000000000000000}, v16_int8 = {0xfe, 0xff, 0xff, 0xff, 
  50.     0xff, 0xff, 0xff, 0xff, 0xfe, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff}, v8_int16 = {0xfffe, 0xffff, 0xffff, 0xffff, 0xfffe, 0xffff, 
  51.     0xffff, 0xffff}, v4_int32 = {0xfffffffe, 0xffffffff, 0xfffffffe, 0xffffffff}, v2_int64 = {0xfffffffffffffffe, 0xfffffffffffffffe}, 
  52.   uint128 = 0xfffffffffffffffefffffffffffffffe}
  53. ---Type <return> to continue, or q <return> to quit---
  54. xmm4           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  55.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  56. xmm5           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x32, 0xa3, 0xd7, 0x2, 0x0 <repeats 12="" times="">}, 
  57.   v8_int16 = {0xa332, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d7a332, 0x0, 0x0, 0x0}, v2_int64 = {0x2d7a332, 0x0}, 
  58.   uint128 = 0x00000000000000000000000002d7a332}
  59. xmm6           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  60.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  61. xmm7           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0xda, 0x87, 0xd7, 0x2, 0x0 <repeats 12="" times="">}, 
  62.   v8_int16 = {0x87da, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d787da, 0x0, 0x0, 0x0}, v2_int64 = {0x2d787da, 0x0}, 
  63.   uint128 = 0x00000000000000000000000002d787da}
  64. xmm8           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  65.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  66. xmm9           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  67.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  68. xmm10          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  69.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  70. xmm11          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  71.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  72. xmm12          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x18, 0xe, 0x73, 0x90, 0xb, 0x2b, 0x0, 0x0, 0x0, 0x0, 
  73.     0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v8_int16 = {0xe18, 0x9073, 0x2b0b, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x90730e18, 0x2b0b, 0x0, 0x0}, 
  74.   v2_int64 = {0x2b0b90730e18, 0x0}, uint128 = 0x000000000000000000002b0b90730e18}
  75. xmm13          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  76.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  77. xmm14          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  78.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  79. ---Type <return> to continue, or q <return> to quit---
  80. xmm15          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16="" times="">}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
  81.     0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
  82. mxcsr          0x1fa1   [ IE PE IM DM ZM OM UM PM ]
  83. (gdb) 
  84. </repeats></return></return></repeats></repeats></repeats></repeats></repeats></repeats></repeats></repeats></repeats></repeats></return></return></repeats></repeats></repeats></return></return></kslgetl+4>

7、rdi/edi是第一个参数， rsi/esi是第二个参数，贴出info all-register命令所显示函数kslgetl ()的两个参数，如下

8、找到第一个参数0x601082f0,注意因我的OS是64位，前面要补8个0，在v$latch_children视图中地址的字母要大写,

  1. sys@OCM>  select  name from v$latch_children where addr='00000000601082F0';
  2. NAME
  3. ----------------------------------------------------------------
  4. shared pool

10、发现Latch锁就是shared pool Latch。

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！