[Mono-list] multi-threading operation on Oracle database led to program crash !!!
Miguel de Icaza
miguel at novell.com
Tue Nov 3 14:55:57 EST 2009
Hello,
> I used Mono+System.Data.OracleClient+instantclient to access Oracle database
> in multi-threading way on x64bit SUSE Linux.
It would be useful to have a test case to reproduce this issue.
>
> Your reply will be highly appreciated!
>
> My program run several minutes and crashed and exited with following
> message:
>
> Stacktrace:
>
>
> Native stacktrace:
>
> mono(mono_handle_native_sigsegv+0xb0) [0x48c230]
> mono(mono_arch_handle_altstack_exception+0xf5) [0x4bbf55]
> /lib64/libpthread.so.0 [0x2aed9a374c10]
> /opt/oracle/oradb/home/lib/libclntsh.so(kpcsncharset2ucs2+0x2b)
> [0x2aaaac9788e3]
> /opt/oracle/oradb/home/lib/libclntsh.so(OCICharSetToUnicode+0x9)
> [0x2aaaac8a6a93]
> [0x40adf508]
>
> Debug info from gdb:
>
> Using host libthread_db library "/lib64/libthread_db.so.1".
> [Thread debugging using libthread_db enabled]
> [New Thread 47199987718976 (LWP 18957)]
> [New Thread 1102186816 (LWP 18971)]
> [New Thread 1100085568 (LWP 18970)]
> [New Thread 1097984320 (LWP 18969)]
> [New Thread 1091615040 (LWP 18966)]
> [New Thread 1089448256 (LWP 18965)]
> [New Thread 1084852544 (LWP 18963)]
> [New Thread 1082751296 (LWP 18962)]
> [New Thread 1080584512 (LWP 18961)]
> [New Thread 1078483264 (LWP 18960)]
> [New Thread 1075988800 (LWP 18959)]
> [New Thread 1073887552 (LWP 18958)]
> 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> 12 Thread 1073887552 (LWP 18958) 0x00002aed9a374231 in fmod () from
> /lib64/libpthread.so.0
> 11 Thread 1075988800 (LWP 18959) 0x00002aed9a372dfd in sem_wait () from
> /lib64/libpthread.so.0
> 10 Thread 1078483264 (LWP 18960) 0x00002aed9a685fcb in fmod () from
> /lib64/libc.so.6
> 9 Thread 1080584512 (LWP 18961) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
> 8 Thread 1082751296 (LWP 18962) 0x00002aed9a373b8b in fmod () from
> /lib64/libpthread.so.0
> 7 Thread 1084852544 (LWP 18963) 0x00002aed9a37394b in fmod () from
> /lib64/libpthread.so.0
> 6 Thread 1089448256 (LWP 18965) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
> 5 Thread 1091615040 (LWP 18966) 0x00002aed9a693b68 in fmod () from
> /lib64/libc.so.6
> 4 Thread 1097984320 (LWP 18969) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
> 3 Thread 1100085568 (LWP 18970) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
> 2 Thread 1102186816 (LWP 18971) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
> 1 Thread 47199987718976 (LWP 18957) 0x00002aed9a3711c6 in
> pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
>
> Thread 12 (Thread 1073887552 (LWP 18958)):
> #0 0x00002aed9a374231 in fmod () from /lib64/libpthread.so.0
> #1 0x000000000055dcaf in collection_thread (unused=<value optimized out>)
> at collection.c:34
> #2 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #3 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #4 0x0000000000000000 in ?? ()
>
> Thread 11 (Thread 1075988800 (LWP 18959)):
> #0 0x00002aed9a372dfd in sem_wait () from /lib64/libpthread.so.0
> #1 0x00000000004ef998 in finalizer_thread (unused=<value optimized out>) at
> gc.c:1058
> #2 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #3 0x00000000005773b3 in thread_start_routine (args=0x7dc560) at
> threads.c:286
> #4 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #5 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #6 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #7 0x0000000000000000 in ?? ()
>
> Thread 10 (Thread 1078483264 (LWP 18960)):
> #0 0x00002aed9a685fcb in fmod () from /lib64/libc.so.6
> #1 0x000000004027f625 in ?? ()
> #2 0x00000000009820d0 in ?? ()
> #3 0x00002aaaaaadb4c8 in ?? ()
> #4 0x00002aaaab5f9000 in ?? ()
> #5 0x0000000000000020 in ?? ()
> #6 0x0000000040485068 in ?? ()
> #7 0x0000000040484fc0 in ?? ()
> #8 0x0000000040484f00 in ?? ()
> #9 0x00002aaaaaadb4c8 in ?? ()
> #10 0x00002aaaab5f9000 in ?? ()
> #11 0x0000000000000020 in ?? ()
> #12 0x00002aaaab1e8ca0 in ?? ()
> #13 0x000000004027f4d0 in ?? ()
> #14 0x0000000000000004 in ?? ()
> #15 0x00002aaaab1e8ca0 in ?? ()
> #16 0x0000000000000000 in ?? ()
>
> Thread 9 (Thread 1080584512 (LWP 18961)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x40d, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x0000000000579fc0 in WaitForSingleObjectEx (handle=0x40d,
> timeout=4294967295, alertable=1) at wait.c:205
> #3 0x000000000050c6b3 in
> ves_icall_System_Threading_WaitHandle_WaitOne_internal (this=<value
> optimized out>, handle=0x40d,
> ms=-1, exitContext=<value optimized out>) at threads.c:1446
> #4 0x000000004028353e in ?? ()
> #5 0x0000000000a1ccc0 in ?? ()
> #6 0x000018aeea14452c in ?? ()
> #7 0x0000000000000000 in ?? ()
>
> Thread 8 (Thread 1082751296 (LWP 18962)):
> #0 0x00002aed9a373b8b in fmod () from /lib64/libpthread.so.0
> #1 0x0000000000574034 in _wapi_accept (fd=6, addr=0x0, addrlen=0x0) at
> sockets.c:209
> #2 0x0000000000516b33 in
> ves_icall_System_Net_Sockets_Socket_Accept_internal (sock=6,
> error=0x40896e7c,
> blocking=<value optimized out>) at socket-io.c:892
> #3 0x0000000040a9904e in ?? ()
> #4 0x000000000087ec90 in ?? ()
> #5 0x00002aaaaaadb198 in ?? ()
> #6 0x0000000000000000 in ?? ()
>
> Thread 7 (Thread 1084852544 (LWP 18963)):
> #0 0x00002aed9a37394b in fmod () from /lib64/libpthread.so.0
> #1 0x000000000048c3a3 in mono_handle_native_sigsegv (signal=<value
> optimized out>, ctx=<value optimized out>)
> at /usr/include/bits/unistd.h:35
> #2 0x00000000004bbf55 in mono_arch_handle_altstack_exception
> (sigctx=0x2aaaab649c40, fault_addr=<value optimized out>,
> stack_ovf=0) at exceptions-amd64.c:910
> #3 <signal handler called>
> #4 0x00002aaaac9788e3 in kpcsncharset2ucs2 () from
> /opt/oracle/oradb/home/lib/libclntsh.so
> #5 0x00002aaaac8a6a93 in OCICharSetToUnicode () from
> /opt/oracle/oradb/home/lib/libclntsh.so
> #6 0x0000000040adf508 in ?? ()
> #7 0x0000000000874de0 in ?? ()
> #8 0x00002aaaae9969f0 in ?? ()
> #9 0x0000000040a97bfc in ?? ()
> #10 0x00002aaaaed27000 in ?? ()
> #11 0x00002aaaabcc4260 in ?? ()
> #12 0x0000000000000000 in ?? ()
>
> Thread 6 (Thread 1089448256 (LWP 18965)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x401, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x0000000000579fc0 in WaitForSingleObjectEx (handle=0x401,
> timeout=4294967295, alertable=1) at wait.c:205
> #3 0x0000000000513121 in async_invoke_thread (data=0x0) at
> threadpool.c:1424
> #4 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #5 0x00000000005773b3 in thread_start_routine (args=0x7dcf88) at
> threads.c:286
> #6 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #7 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #8 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #9 0x0000000000000000 in ?? ()
>
> Thread 5 (Thread 1091615040 (LWP 18966)):
> #0 0x00002aed9a693b68 in fmod () from /lib64/libc.so.6
> #1 0x0000000000511d34 in socket_io_epoll_main (p=<value optimized out>) at
> threadpool.c:600
> #2 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #3 0x00000000005773b3 in thread_start_routine (args=0x7dd1e0) at
> threads.c:286
> #4 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #5 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #6 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #7 0x0000000000000000 in ?? ()
>
> Thread 4 (Thread 1097984320 (LWP 18969)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x401, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x0000000000579fc0 in WaitForSingleObjectEx (handle=0x401,
> timeout=4294967295, alertable=1) at wait.c:205
> #3 0x0000000000513121 in async_invoke_thread (data=0x0) at
> threadpool.c:1424
> #4 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #5 0x00000000005773b3 in thread_start_routine (args=0x7dd5c8) at
> threads.c:286
> #6 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #7 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #8 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #9 0x0000000000000000 in ?? ()
>
> Thread 3 (Thread 1100085568 (LWP 18970)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x401, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x0000000000579fc0 in WaitForSingleObjectEx (handle=0x401,
> timeout=4294967295, alertable=1) at wait.c:205
> #3 0x0000000000513121 in async_invoke_thread (data=0x0) at
> threadpool.c:1424
> #4 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #5 0x00000000005773b3 in thread_start_routine (args=0x7dd8e8) at
> threads.c:286
> #6 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #7 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #8 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #9 0x0000000000000000 in ?? ()
>
> Thread 2 (Thread 1102186816 (LWP 18971)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x401, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x0000000000579fc0 in WaitForSingleObjectEx (handle=0x401,
> timeout=4294967295, alertable=1) at wait.c:205
> #3 0x0000000000513121 in async_invoke_thread (data=0x0) at
> threadpool.c:1424
> #4 0x000000000050ec6c in start_wrapper (data=<value optimized out>) at
> threads.c:623
> #5 0x00000000005773b3 in thread_start_routine (args=0x7dd9b0) at
> threads.c:286
> #6 0x0000000000593192 in GC_start_routine (arg=<value optimized out>) at
> pthread_support.c:1382
> #7 0x00002aed9a36d143 in start_thread () from /lib64/libpthread.so.0
> #8 0x00002aed9a69374d in clone () from /lib64/libc.so.6
> #9 0x0000000000000000 in ?? ()
>
> Thread 1 (Thread 47199987718976 (LWP 18957)):
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
> #1 0x0000000000562b0a in _wapi_handle_timedwait_signal_handle
> (handle=0x400, timeout=0x0, alertable=1, poll=0)
> at handles.c:1605
> #2 0x000000000057aa1d in WaitForMultipleObjectsEx (numobjects=3,
> handles=0x2aaaab710ed0, waitall=0, timeout=4294967295,
> alertable=0) at wait.c:723
> #3 0x000000000050ff01 in mono_thread_manage () at threads.c:2497
> #4 0x0000000000473153 in mono_main (argc=2, argv=<value optimized out>) at
> driver.c:1648
> #5 0x00002aed9a5f1154 in __libc_start_main () from /lib64/libc.so.6
> #6 0x0000000000422139 in _start ()
> #0 0x00002aed9a3711c6 in pthread_cond_wait@@GLIBC_2.3.2 () from
> /lib64/libpthread.so.0
>
> =================================================================
> Got a SIGSEGV while executing native code. This usually indicates
> a fatal error in the mono runtime or one of the native libraries
> used by your application.
> =================================================================
>
> Aborted
>
>
>
>
>
> I wrote following code:
>
> using System;
> using System.Net.Sockets;
> using System.Threading;
>
> //using some my namespace
>
> namespace CommandAgent
> {
> class MainClass
> {
> public static void Main(string[] args)
> {
>
> SchemaServer schemaServer=new SchemaServer();
> Thread threadServer=new Thread(new ThreadStart(schemaServer.Procedure));
> threadServer.Start();
>
> Thread threadPoll=new Thread(new ThreadStart(SchemaPoll.Procedure));
> threadPoll.Start();
>
>
> }
> }
>
> public class SchemaServer
> {
> public SchemaServer()
> {
> }
> public void Procedure()
> {
> while(true)
> {
> //do something
> }
> }
> }
>
> public class SchemaPoll
> {
> public static void Procedure()
> {
> while(true)
> {
> try
> {
> //CommandInvoker.Invoke() method is used to scan oracle database table
> to retrieve some data
> CommandInvoker.Invoke();
> Thread.Sleep(5000);
> //CommandFeeder.Feed() method is used to scan oracle database table to
> retrieve some data
> CommandFeeder.Feed();
> }
> catch(Exception ex)
> {
> Console.WriteLine("Exception in SchemaPoll.Procedure:{0}",ex.Message);
> }
> }
> }
> }
>
> }
More information about the Mono-list
mailing list