472,368 Members | 2,611 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,368 software developers and data experts.

SQL1131N after installing a new shared library.

Hello,

DB2 V7 FP 13 running on Linux.

We have developed a C++ shared library that will be called by a db2
stored procedure. Every time my developers generate a new .so shared
library, I copy it to /home/db2inst1/sqllib/functions/ and then run a
test applications that calls the stored proc. I also run a "bind
file.bnd blocking all grant public". The first execution of the
procedure (after the .so has been replaced) always fails with SQL1131N
(DARI (Stored Procedure) process has been terminated abnormally.)

However, if I invoke the same procedure again (using my test app or
CLP), it works like a charm. In fact, it will never fail again. The
error happens only during the first execution.

This leads me to think that there is no application / C code error. Do
I need to run any command after copying the new .so file, so DB2 can
"reload" the lib ? I am not sure what I am missing here.

Here are the diag and stack trace files:

2005-11-21-10.15.46.091845 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:15

DiagData
4120 6e6f 6e2d 4544 5520 6368 696c 6420 A non-EDU child

6372 6173 6865 642e crashed.
2005-11-21-10.15.46.141778 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:16

DiagData
f527 0000 '..
2005-11-21-10.15.46.169819 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:17

DiagData
0101 0000 ....
2005-11-21-10.15.46.177624 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:18

DiagData
ffff ffff
2005-11-21-10.15.56.190141 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:15

DiagData
4120 6e6f 6e2d 4544 5520 6368 696c 6420 A non-EDU child

6372 6173 6865 642e crashed.
2005-11-21-10.15.56.202971 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:16

DiagData
c627 0000 '..
2005-11-21-10.15.56.250408 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:17

DiagData
0101 0000 ....
2005-11-21-10.15.56.254621 Instance:db2inst1 Node:000
PID:18999(db2sysc) Appid:none
base_sys_utilities sqleChildCrashHandler Probe:18

DiagData
ffff ffff

Trace

*****************************************
* *
* DB2 USERS : *
* ----------- *
* A DARI process terminated abnormally. *
* This may have been caused by a prog- *
* ramming error in the DARI procedure. *
* A stack trace-back follows. *
* *
*****************************************
2005-11-21-10.15.44.179467 : DB2 v7.1.0.103 s040930 SQL07029
S:Linux R:2.4.9-e.57 V:#1 Thu Dec 2 20:56:19 EST 2004 M:i686
N:batata.automatos.com
db2inst1.000 : db2dari (10386) (0x2000)
Signal #11

Data seg top [sbrk(0)] = 0x0806D000
Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x800000
Cur core size (bytes) = 0x0

Context Information:
sigcontext_struct (88 bytes):
00000007 00000000 0000002b c010002b
0805fc40 0805fc40 bffeb190 bffeb188
41107850 4102e000 00000000 000d9844
0000000e 00000004 41084098 00000023
00010246 bffeb188 0000002b bffeaf08
80000000 000d9844

Register Information:
eax = 000d9844; ebx = 41107850; ecx = 00000000; edx =
4102e000;
ebp = bffeb190; esp = bffeb188; edi = 0805fc40; esi =
0805fc40;
ds = 0000002b; es = 0000002b; fs = 00000000; gs =
00000007;
eip = 41084098; cs = 00000023; ss = 0000002b; eflags =
00010246;

Stack Trace:
DB2 (db2inst1.000) : 2005-11-21-10.15.44.273050 stack corrupted.
Signal 11 caught in traceback attempt.
Thanks in advance for any suggestions.

Nov 21 '05 #1
0 1111

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000...
0
by: Darren L. Weber | last post by:
The following is a first attempt to almost create a shell script for installation of ATLAS and LAPACK. It does not work right now and it is specific to a particular platform. It is posted here to...
8
by: N.V.Dev | last post by:
Hi, I am trying to use the db2load API using C. During run-time below is the error message thrown call utils.load_table('util.temp') SQL1131N DARI (Stored Procedure) process has been...
6
by: gaetan | last post by:
Hi everybody, I have several stored procedure developped in Java that ran fine when I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11, I'm not able to call any of my stored...
4
by: dromuss via DBMonster.com | last post by:
I have a problem registering Stored Procedures. I tried diferent stored procedure and non of them work. Not even an empty stored procedure like the following: CREATE PROCEDURE DB2INST1.PRUEBA...
1
by: zpinhead | last post by:
I am unable to get my downloaded extension from pecl to link up with php properly. seems like the php.so I could not use pear install http. pear claimed the extension was already installed....
0
by: ravindrag | last post by:
Hi, I am getting error SQL1131N during sqlj.install_jar(...). There is no useful message in the diag.log (even with diag level 4). I am giving the diag.log entries at the end of this posting...
3
by: menzies | last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
5
by: jgelfand | last post by:
I'm installing Python 2.4.4 on a CentOS release 4.6 (Final) 64-bit machine. Running "./configure --prefix="/ usr/local/yosi/ciao-4.0/ots" --enable-shared" appears to be fine, but I get the...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
1
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.