Database crashed if I try recreate the dbproc

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	mysql openssl Question
•	mysql:it 's a db not a dbms how it 's possible?!
•	Does the binary log enabling affect the MySQL performances?
•	Strange behavior, Table Level Permission
•	FULLTEXT query format question
•	Preventing Duplicate Entries
•	Comparing and writing out BLOBS
•	Executing MySQL Commands From Within C Program
•	Can 't access mysql after kernel upgrade
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Downgrade Mysql from 4 to 3 23
•	MySQL Cluster Software
•	mysql test 4 1 fails with the gis test
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	Getting Identity after INSERT
•	Update one field with more fields from another table
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	mysql have same function mthod as Oracle decode()

Database crashed if I try recreate the dbproc

Database crashed if I try recreate the dbproc

2007-04-27 - By <8B@(protected) CA0=>2

Back

Reply: 1 2

I'm using MAXDB version 7.6.00.16 build 016-121-109-428

Database crashed if I try recreate the dbproc

DROP DBPROC PACS.getProtocolFieldData
//
CREATE DBPROC PACS.getProtocolFieldData
( IN TableName VARCHAR(32)
, IN ProtocolId INT
, IN objId INT
, IN xpath VARCHAR(200)
, IN p_version INT
)
RETURNS CURSOR
AS
BEGIN
TRY
SET $CURSOR='MYCUR';
EXECUTE('DECLARE ' || $CURSOR || ' CURSOR FOR SELECT * FROM PACS.'
|| TableName ||
' WHERE ProtocolId=' || ProtocolId ||
' AND objId=' || objId || ' AND xpath=''' || xpath || '''' ||
' AND VALUE(fromRevision, 1) <= ' || p_version ||
' AND ' || p_version || ' < VALUE(toRevision, ' ||
p_version + 1 || ')'
);
CATCH
IF $rc != 100 THEN
STOP($rc,$errmsg);
END;
//
GRANT EXECUTE ON PACS.getProtocolFieldData TO PacsDoctorRole
//

log:

2007-04-28 11:49:15 10 11561 COMMUNIC Connecting T95 it9.dc-local
1784
2007-04-28 11:49:15 24 11561 COMMUNIC Connected T95 it9.dc-local
1784
2007-04-28 11:49:15 0 12853 DBSTATE Caught signal 11(SIGSEGV)
2007-04-28 11:49:15 0 ERR 11330 COREHAND ABORTING due to signal 11
2007-04-28 11:49:15 0 ERR 11599 BTRACE ----> Emergency Stack Back
Trace <----
2007-04-28 11:49:15 0 ERR 11599 BTRACE (0):0x82bd190
[0x845894e4](0x8458b9ec,0x1e,0x6,0x845898ac)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (1):0x82c09d6
[0x845894e4](0x8458b9ec,0x1e,0x6,0x845898ac)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (3):0x82c1563
[0x84589534](0x8458b9ec,0x1a,0x6,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (5):0x82c0b3e
[0x84589574](0x8458b9ec,0x19,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (7):0x82c1aaa
[0x845895c4](0x8458b9ec,0x18,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (9):0x82cc582
[0x84589724](0x8458b9ec,0x845898ac,0x18,0x2d5)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (11):0x82cca74
[0x8458ac14](0x8458b9ec,0x1,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (13):0x82b899c
[0x8458ac34](0x8458b9ec,0x0,0x8458ac54,0x86dc88f)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (15):0x82e741d
[0x8458ac64](0x8458b9ec,0x1e70fbc,0x101,0x8e70fbc)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (17):0x82e8307
[0x8458ad04](0x8458b9ec,0x0,0x0,0x8458ad94)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (19):0x844b4bf
[0x8458ada4](0x8458b9ec,0x0,0x40,0x73)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (21):0x844d058
[0x8458afb4](0x8458b9ec,0x8458b010,0x8458b15a,0x8458b13c)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (23):0x844da2d
[0x8458b194](0x8458b9ec,0x0,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (25):0x844ed3e
[0x8458b2b4](0x8458b9ec,0x0,0x0,0x8458b348)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (27):0x84522a6
[0x8458b464](0x8458b9ec,0x1,0x8458b4ec,0x1)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (29):0x8a02e46
[0x8458b544](0x8458b9ec,0x8458b9e2,0x8458b563,0x8a8f300)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (31):0x8a031b8
[0x8458b994](0x500524a4,0x2,0x8458b9ec,0xb7d7a130)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (33):0x8a99416
[0x8458cfa4](0x500524a4,0x50002f14,0xb7e63b68,0x8e70fbc)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (35):0x8b67009
[0x8458cfc4](0x3281,0x3,0x8cd3b42,0x8cdf528)
2007-04-28 11:49:15 0 ERR 11599 BTRACE (37):0x681dc4
[0x8458cff4](0x0,0x0,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE ----> Register Dump <----
2007-04-28 11:49:15 0 ERR 11599 BTRACE -- ---- ---- ---- ---- ---- ---
2007-04-28 11:49:15 0 ERR 11599 BTRACE ds es 0x0000007b 0x0000007b
2007-04-28 11:49:15 0 ERR 11599 BTRACE fs gs 0x00000000 0x00000033
2007-04-28 11:49:15 0 ERR 11599 BTRACE trap err 0x0000000e 0x00000004
2007-04-28 11:49:15 0 ERR 11599 BTRACE efl ss 0x00010246 0x0000007b
2007-04-28 11:49:15 0 ERR 11599 BTRACE edi esi 0x8458b9ec 0x82f79490
2007-04-28 11:49:15 0 ERR 11599 BTRACE eax ebx 0x00000531
2007-04-28 11:49:15 0 ERR 11599 BTRACE ecx edx 0x82f7d4a0
2007-04-28 11:49:15 0 ERR 11599 BTRACE esp uesp 0x8458940c 0x8458940c
2007-04-28 11:49:15 0 ERR 11599 BTRACE ebp eip 0x845894e4 0x082bd190
2007-04-28 11:49:15 0 ERR 11599 BTRACE cs cr2 0x00000073 0x00000531
2007-04-28 11:49:15 0 ERR 11599 BTRACE -- ---- ---- ---- ---- ---- ---
2007-04-28 11:49:15 0 ERR 11599 BTRACE cw - sw - tag 0xffff037f
0xffff0020 0xffffffff
2007-04-28 11:49:15 0 ERR 11599 BTRACE ipoff - cssel 0x00000000
0x00000000
2007-04-28 11:49:15 0 ERR 11599 BTRACE dataoff-datasel 0x00000000
0x00000000
2007-04-28 11:49:15 0 ERR 11599 BTRACE f00 [0x0000 0x0000
0x0000 0x0000 - 0x0000]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f01 [0x0000 0x0000
0x0000 0x0000 - 0x0000]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f02 [0x0000 0x0000
0x0000 0x0000 - 0x0000]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f03 [0x0000 0x0000
0x0000 0x0000 - 0x0000]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f04 [0x0000 0x0000
0x0000 0x0000 - 0x0000]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f05 [0x0000 0x0000
0x0000 0xa000 - 0x4002]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f06 [0x0000 0x0000
0x0000 0xe540 - 0x4008]
2007-04-28 11:49:15 0 ERR 11599 BTRACE f07 [0x0000 0x0000
0x0000 0x8000 - 0x4002]
2007-04-28 11:49:15 0 ERR 11599 BTRACE -- ---- ---- ---- ---- ---- ---
2007-04-28 11:49:15 0 ERR 11599 BTRACE ----> Module List <----
2007-04-28 11:49:15 0 ERR 11599 BTRACE |.text Start |.text End |
Module File Name
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x0062d000 | 0x00642000 |
/lib/ld-2.3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x00642000 | 0x00643000 |
/lib/ld-2.3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x0064b000 | 0x00770000 |
/lib/tls/libc-2 (See http://ibc-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x00770000 | 0x00772000 |
/lib/tls/libc-2 (See http://ibc-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x00778000 | 0x0077f000 |
/lib/libgcc_s-3.4.6-20060404.so.1
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x00788000 | 0x0078a000 |
/lib/libdl-2 (See http://bdl-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x0078a000 | 0x0078b000 |
/lib/libdl-2 (See http://bdl-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x0078e000 | 0x007af000 |
/lib/tls/libm-2 (See http://ibm-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x007af000 | 0x007b0000 |
/lib/tls/libm-2 (See http://ibm-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x007b3000 | 0x007bb000 |
/lib/tls/librt-2 (See http://brt-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x007bb000 | 0x007bc000 |
/lib/tls/librt-2 (See http://brt-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x007ff000 | 0x0080d000 |
/lib/tls/libpthread-2 (See http://ead-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x0080d000 | 0x0080e000 |
/lib/tls/libpthread-2 (See http://ead-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x08048000 | 0x08d03000 |
/opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0x81172000 | 0x8139c000 |
/opt/sdb/7600/lib/liboms.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0xb7e2b000 | 0xb7e34000 |
/lib/libnss_files-2 (See http://les-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0xb7e34000 | 0xb7e35000 |
/lib/libnss_files-2 (See http://les-2.ora-code.com).3.4.so
2007-04-28 11:49:15 0 ERR 11599 BTRACE | 0xb7f40000 | 0xb7fef000 |
/usr/lib/libstdc++.so.5.0.7
2007-04-28 11:49:15 0 ERR 11599 BTRACE
2007-04-28 11:49:15 0 ERR 11599 BTRACE ----> Symbolic Stack Back
Trace <----
2007-04-28 11:49:15 0 ERR 11599 BTRACE 0: 0x082bd190
ak262DynamicSqlStatement +0x0340
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x845894e4] (0x8458b9ec,0x1e,0x6,0x845898ac)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 1: 0x082c09d6
ak262compile +0x0406
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x845894e4] (0x8458b9ec,0x1e,0x6,0x845898ac)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 2: 0x082c1563
ak262TryCatchBlock +0x0113
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x84589534] (0x8458b9ec,0x1a,0x6,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 3: 0x082c0b3e
ak262compile +0x056e
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x84589574] (0x8458b9ec,0x19,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 4: 0x082c1aaa
ak262StoreStmtAndComplile +0x052a
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x845895c4] (0x8458b9ec,0x18,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 5: 0x082cc582
ak262Create +0x04e2
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x84589724] (0x8458b9ec,0x845898ac,0x18,0x2d5)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 6: 0x082cca74
a262CreateDBProc +0x0034
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458ac14] (0x8458b9ec,0x1,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 7: 0x082b899c
a261proc_handling +0x013c
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458ac34] (0x8458b9ec,0x0,0x8458ac54,0x86dc88f)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 8: 0x082e741d
ak35call_semantik +0x03ed
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458ac64] (0x8458b9ec,0x1e70fbc,0x101,0x8e70fbc)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 9: 0x082e8307
a35_asql_statement2 +0x0867
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458ad04] (0x8458b9ec,0x0,0x0,0x8458ad94)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 10: 0x0844b4bf
ak92not_only_execute +0x04af
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458ada4] (0x8458b9ec,0x0,0x40,0x73)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 11: 0x0844d058
ak92analyze_messagetype +0x0ab8
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458afb4] (0x8458b9ec,0x8458b010,0x8458b15a,0x8458b13c)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 12: 0x0844da2d
a92_mode_analyzer +0x032d
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458b194] (0x8458b9ec,0x0,0x0,0x0)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 13: 0x0844ed3e
ak93one_command +0x057e
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458b2b4] (0x8458b9ec,0x0,0x0,0x8458b348)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 14: 0x084522a6
a93_user_commands +0x0566
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458b464] (0x8458b9ec,0x1,0x8458b4ec,0x1)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 15: 0x08a02e46
_Z7SQLTaskR20tak_all_command_globRhb +0x0086
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458b544] (0x8458b9ec,0x8458b9e2,0x8458b563,0x8a8f300)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 16: 0x08a031b8
_Z11Kernel_MainR13RTETask_ITask +0x02c8
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458b994] (0x500524a4,0x2,0x8458b9ec,0xb7d7a130)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 17: 0x08a99416
RTETask_TaskMain +0x0056
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458cfa4] (0x500524a4,0x50002f14,0xb7e63b68,0x8e70fbc)
2007-04-28 11:49:15 0 ERR 11599 BTRACE 18: 0x08b67009
en88_CallCoroutineKernelTaskMain +0x0099
2007-04-28 11:49:15 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2007-04-28 11:49:15 0 ERR 11599 BTRACE Frameinfo
[0x8458cfc4] (0x3281,0x3,0x8cd3b42,0x8cdf528)
2007-04-28 11:49:15 0 ERR 11599 BTRACE ----> End of Stack Back
Trace <----
2007-04-28 11:49:15 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001
2007-04-28 11:49:15 0 ERR 11599 BTRACE
2007-04-28 11:49:15 0 ERR 11599 BTRACE no problems detected in
LVCMem_Allocator_001
2007-04-28 11:49:15 0 ERR 11599 BTRACE analysing LVCMem_Allocator_002
2007-04-28 11:49:15 0 ERR 11599 BTRACE
2007-04-28 11:49:15 0 ERR 11599 BTRACE no problems detected in
LVCMem_Allocator_002
+++++++++++++++++++++++++++++++++++++++ Kernel Exit
++++++++++++++++++++++++++++
2007-04-28 11:49:16 0 11987 dump_rte rtedump written to file
'rtedump'
2007-04-28 11:49:16 0 ERR 12006 DBCRASH Kernel exited without core
and exit status 0x2f00
2007-04-28 11:49:16 0 ERR 12008 DBCRASH Kernel exited due to
reentered signal handler
2007-04-28 11:49:16 0 12890 DIAGHIST Backup of diagnostic files
will be forced at next restart
2007-04-28 11:49:16 0 12808 DBSTATE Flushing knltrace pages
2007-04-28 11:49:16 0 WNG 11824 COMMUNIC Releasing T95 kernel abort
2007-04-28 11:49:16 0 12696 DBSTATE Change DbState to 'OFFLINE
'(29)
-- ---- ---- ---- ---- ---- ---- ------ current write position
-- ---- ---- ----

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)