From: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
Sent: Tuesday, August 29, 2017 4:52 AM
To: K S, Sandhya (Nokia - IN/Bangalore) <sandhya.k_s@nokia.com>
Cc: pgsql-odbc@postgresql.org; T, Rasna (Nokia - IN/Bangalore) <rasna.t@nokia.com>; Itnal, Prakash (Nokia - IN/Bangalore) <prakash.itnal@nokia.com>
Subject: Re: [ODBC] ODBC crash after DB cleanup
Below the bt of the core file.
#0 0x000000555a0323c0 in strcpy () from /srv/Log/bak/mnt/backup/iso/lib64/libc.so.6
#1 0x00000055c53ddfa4 in SC_create_errorinfo (self=Cannot access memory at address 0x55bbfe80e0
Cannot access memory at address 0x55bbfe8108
(gdb) disassemble SC_create_errorinfo
Dump of assembler code for function SC_create_errorinfo:
0x00000055c53dd910 <+0>: daddiu sp,sp,-4272
0x00000055c53dd914 <+4>: sd ra,4264(sp)
0x00000055c53dd918 <+8>: sd s8,4256(sp)
0x00000055c53dd91c <+12>: sd gp,4248(sp)
0x00000055c53dd920 <+16>: move s8,sp
0x00000055c53dd924 <+20>: lui gp,0x6
0x00000055c53dd928 <+24>: daddu gp,gp,t9
0x00000055c53dd92c <+28>: daddiu gp,gp,-26368
0x00000055c53ddf98 <+1672>: move t9,v0
0x00000055c53ddf9c <+1676>: jalr t9
0x00000055c53ddfa0 <+1680>: nop
0x00000055c53ddfa4 <+1684>: ld v0,40(s8)
0x00000055c53ddfa8 <+1688>: move sp,s8
0x00000055c53ddfac <+1692>: ld ra,4264(sp)
0x00000055c53ddfb0 <+1696>: ld s8,4256(sp)
0x00000055c53ddfb4 <+1700>: ld gp,4248(sp)
0x00000055c53ddfb8 <+1704>: daddiu sp,sp,4272
0x00000055c53ddfbc <+1708>: jr ra
---Type <return> to continue, or q <return> to quit---
0x00000055c53ddfc0 <+1712>: nop
We are trying to reproduce the issue in local environment, no success yet. Enabling ODBC debug logs on production is not an option as we see 50% decrease in performance when we enable ODBC logs.
Please help us in resolving this issue.