[osdldbt-general] Re: [Osdl_performance] libsqlod.so waiting in __libc_recv ()

[Stephen H. <she...@os...>]

Are you sure you are not allowing multiple threads can not share the
same database connection? Unless there is explicit locking maybe one
request is getting mixed with another.

On Tue, 2002-09-17 at 11:26, Mark Wong wrote:
> I have a situation where I see some number of threads in a
> multi-threaded ODBC program waiting in libc_recv.  I have used gdb to
> attach to my program and produce a back trace, which is copied at the
> end of the message.
> 
> The issue is fairly easy to reproduce by having only a 4 or 5 threads
> repeatedly call a stored procedure in a tight loop.  I can provide more
> information if it will help.
> 
> Back trace:
> 
> #0  0x40301722 in __libc_recv () at __libc_recv:-1
> #1  0x401ed9d6 in recv (fd=7, buf=0x403ab1a8, n=130576, flags=0)
>     at wrapsyscall.c:198
> #2  0x401098cd in sql42_rcvpkt ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #3  0x4010b433 in sql42_recv_packet ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #4  0x401056af in sql23_receive ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #5  0x400fb4ed in sql03_receive ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #6  0x400fc001 in sqlareceive ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #7  0x400e18f4 in p03creceive ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #8  0x400e2b1e in p03creqrecpacket ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #9  0x400d1b60 in pr03PacketReqRec ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #10 0x400df29b in p03reqrecpacket ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #11 0x400f1a07 in p11execute () from
> /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #12 0x400efb39 in p10allexecute ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #13 0x400ef9f9 in p10forexecute ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #14 0x400f06ea in p10execute () from
> /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #15 0x4009adc1 in apeexec () from
> /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #16 0x4008be26 in pa10execute ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #17 0x4008bb96 in paSQLExecute ()
>    from /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> #18 0x4008c600 in SQLExecute () from
> /opt/sapdb/interfaces/odbc/lib/libsqlod.so
> -- 
> Mark Wong - - ma...@os...
> Open Source Development Lab Inc - A non-profit corporation
> 15275 SW Koll Parkway - Suite H - Beaverton OR, 97006
> (503)-626-2455 x 32 (office)
> (503)-626-2436      (fax)
> http://www.osdl.org/archive/markw/
> 
> _______________________________________________
> osdl_performance mailing list
> osd...@li...
> http://lists.osdl.org/mailman/listinfo/osdl_performance