[Mono-list] multi-threading operation on Oracle database led to program crash !!!
ibrahim steed
ibrahim.steed at gmail.com
Wed Oct 28 02:26:53 EDT 2009
I used Mono+System.Data.OracleClient+instantclient to access Oracle database
in multi-threading way on x64bit SUSE Linux.
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);
}
}
}
}
}
--
View this message in context: http://www.nabble.com/multi-threading-operation-on-Oracle-database-led-to-program-crash-%21%21%21-tp26089486p26089486.html
Sent from the Mono - General mailing list archive at Nabble.com.
More information about the Mono-list
mailing list