Good morning,
Yet an another post about Webdav :-) We are trying to find url of files stored
into a webdav server to give the user an human readable file path. We created
that function to do it :
CREATE FUNCTION SEARCHURL(MYCID CHAR(24) BYTE) RETURNS VARCHAR AS
VAR URL VARCHAR(1000);
NOM VARCHAR(500); TRY
URL ='';
DECLARE LSTWEBDAV CURSOR FOR
WITH RECURSIVE PX(P,CA,N) AS
(SELECT PID, CID,NAME FROM DBA.WEBDAV_INODE WHERE CID = :MYCID
UNION ALL
SELECT PID, P,NAME FROM DBA.WEBDAV_INODE, DBA.PX WHERE CID=P)
SELECT N FROM DBA.PX ORDER BY ROWNO DESC;
FETCH LSTWEBDAV INTO :NOM;
URL = NOM;
WHILE $RC = 0 DO
BEGIN
FETCH LSTWEBDAV INTO :NOM;
IF $RC=0 THEN URL = NOM || '\' || URL;
END;
CATCH
RETURN URL ;
When calling 'select searchurl(CID) FROM DBA.WEBDAV_INODE' everything works fine
but when leaving the app MaxDB Server crashes. We are sure it crashes only when
that function is used by the app AND when the app<->maxdb ODBC connection is
closed. It also happens when calling 'select searchurl(CID) FROM
DBA.WEBDAV_INODE' from SQL Studio and then leaving SQL Studio (this proves the
problem does not come from our app).
Here is the report :
Knldiagerr :
2005-05-31 18:44:24 0 ERR 11599 BTRACE ----> Register Dump <----
2005-05-31 18:44:24 0 ERR 11599 BTRACE -------------------------------
2005-05-31 18:44:24 0 ERR 11599 BTRACE ds es 0x0000002b 0x0000002b
2005-05-31 18:44:24 0 ERR 11599 BTRACE fs gs 0x00000000 0x0000009f
2005-05-31 18:44:24 0 ERR 11599 BTRACE trap err 0x0000000e 0x00000004
2005-05-31 18:44:24 0 ERR 11599 BTRACE efl ss 0x00010293 0x0000002b
2005-05-31 18:44:24 0 ERR 11599 BTRACE edi esi 0x00000000 0x00000000
2005-05-31 18:44:24 0 ERR 11599 BTRACE eax ebx 0x460cd5f8
2005-05-31 18:44:24 0 ERR 11599 BTRACE ecx edx 0x00003378
2005-05-31 18:44:24 0 ERR 11599 BTRACE esp uesp 0x460cad78 0x460cad78
2005-05-31 18:44:24 0 ERR 11599 BTRACE ebp eip 0x460cada0 0x0816ad64
2005-05-31 18:44:24 0 ERR 11599 BTRACE cs cr2 0x00000023 0x00000018
2005-05-31 18:44:24 0 ERR 11599 BTRACE -------------------------------
2005-05-31 18:44:24 0 ERR 11599 BTRACE cw - sw - tag 0xffff037f
0xffff0120 0xffffffff
2005-05-31 18:44:24 0 ERR 11599 BTRACE ipoff - cssel 0x00000000
0x00000000
2005-05-31 18:44:24 0 ERR 11599 BTRACE dataoff-datasel 0x00000000
0x00000000
2005-05-31 18:44:24 0 ERR 11599 BTRACE f00 [0x0000 0x0000 0x0000
0x0000 - 0x0000]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f01 [0x0000 0x0000 0x0000
0x0000 - 0x0000]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f02 [0xfe66 0xffff 0xffff
0xe37f - 0x4007]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f03 [0xfe66 0xffff 0xffff
0xe37f - 0x4007]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f04 [0x6800 0x6666 0x6666
0xa666 - 0x3fff]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f05 [0xd712 0x02cd 0x0aba
0xc677 - 0x3ffe]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f06 [0x0000 0x0000 0x8000
0x8642 - 0x400f]
2005-05-31 18:44:24 0 ERR 11599 BTRACE f07 [0x0000 0x0000 0x0000
0x8741 - 0x400e]
2005-05-31 18:44:24 0 ERR 11599 BTRACE -------------------------------
2005-05-31 18:44:24 0 ERR 11599 BTRACE ----> Module List <----
2005-05-31 18:44:24 0 ERR 11599 BTRACE |.text Start |.text End | Module
File Name
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x08048000 | 0x0895b000 |
/u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x40000000 | 0x40013000 |
/lib/ld-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x4001c000 | 0x40029000 |
/lib/i686/libpthread-0.10.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x4006c000 | 0x4006e000 |
/lib/libdl-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x4006f000 | 0x40075000 |
/lib/i686/librt-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x40081000 | 0x400b8000 |
/usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x400cc000 | 0x400ee000 |
/lib/i686/libm-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x400ef000 | 0x40219000 |
/lib/i686/libc-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x40b21000 | 0x40b29000 |
/lib/libnss_files-2.3.2.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE | 0x49596000 | 0x4966d000 |
/u01/lib/liboms.so
2005-05-31 18:44:24 0 ERR 11599 BTRACE 2005-05-31 18:44:24 0 ERR 11599
BTRACE ----> Symbolic Stack Back Trace <----
2005-05-31 18:44:24 0 ERR 11599 BTRACE 0: 0x0816ad64 a10_cache_delete
+0x004c
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cada0]
(0x460cc99c,0x1,0x1,0x0)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 1: 0x08289c1e
a52_ex_commit_rollback +0x0186
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cada0]
(0x460cc99c,0x1,0x1,0x0)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 2: 0x082898ab a52_call_semantik
+0x015f
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cae80]
(0x460cc99c,0x38,0x1,0x1)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 3: 0x081ef757 ak35call_semantik
+0x061b
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cbe40]
(0x460cc99c,0x2,0x460cbe90,0x81ef14a)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 4: 0x081eec67 a35_asql_statement
+0x07d3
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cbec0]
(0x460cc99c,0x181,0x0,0x81ee4a2)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 5: 0x08314aaf
ak92not_only_execute +0x085b
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cbf40]
(0x460cc99c,0x460cd2d4,0x0,0x8314265)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 6: 0x08315906
ak92analyze_messagetype +0x07ce
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cc100]
(0x460cc99c,0x460cc158,0x460cc15c,0x460cc264)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 7: 0x083165dd a92_mode_analyzer
+0x01cd
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cc270]
(0x460cc99c,0x0,0x0,0x0)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 8: 0x0831aec5 ak93one_command
+0x0779
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cc370]
(0x460cc99c,0x0,0x0,0x831aaf4)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 9: 0x08319abd a93_user_commands
+0x047d
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cc4b0]
(0x460cc99c,0x1,0x460cc518,0x1)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 10: 0x0813d0d1
ak91run_user_process +0x0125
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cc550]
(0x460cc99c,0x460cc58a,0x460cc58b,0x813cfbd)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 11: 0x0813d375
a91mainprogam_with_allocator +0x0041
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cde20]
(0x460cdf14,0x3,0x40241b94,0x813d341)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 12: 0x08531a69
gg941CreateAllocatorAndCallMainprog +0x01e5
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cde50]
(0x460cdf14,0x2,0xffffffff,0x26)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 13: 0x0813d318 a91mainprogram
+0x003c
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cdee0]
(0x460cdf14,0x0,0x0,0x813d2ec)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 14: 0x087cd772
en88_CallKernelTaskMain__FP9TASK_TYPE +0x016e
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cdf80]
(0x8af21dc,0x40230110,0x87cdc70,0x87cdc70)
2005-05-31 18:44:24 0 ERR 11599 BTRACE 15: 0x087cdc9e
en88_CallCoroutineKernelTaskMain +0x002e
2005-05-31 18:44:24 0 ERR 11599 BTRACE /u01/pgm/kernel
2005-05-31 18:44:24 0 ERR 11599 BTRACE Frameinfo [0x460cdfb0]
(0x50016f98,0x8ba8520,0x0,0x0)
2005-05-31 18:44:24 0 ERR 11599 BTRACE ----> End of Stack Back Trace <----
2005-05-31 18:44:24 0 ERR 11599 BTRACE analysing LVCMem_Allocator_1
2005-05-31 18:44:24 0 ERR 11599 BTRACE 2005-05-31 18:44:24 0 ERR 11599
BTRACE no problems detected in LVCMem_Allocator_1
2005-05-31 18:44:25 0 ERR 11979 DBCRASH Kernel exited without core and exit
status 0x2f00
2005-05-31 18:44:25 0 ERR 11981 DBCRASH Kernel exited due to reentered
signal handler
2005-05-31 18:44:25 ___ Stopping GMT 2005-05-31
18:44:25 7.5.0 Build 026-121-094-430
2005-05-31 18:44:34 --- Starting GMT 2005-05-31
18:44:34 7.5.0 Build 026-121-094-430
When simplifying the function like this :
DECLARE LSTWEBDAV CURSOR FOR
WITH RECURSIVE PX(P,CA,N) AS
(SELECT PID, CID,NAME FROM DBA.WEBDAV_INODE WHERE CID = :MYCID
UNION ALL
SELECT PID, P,NAME FROM DBA.WEBDAV_INODE, DBA.PX WHERE CID=P)
SELECT N FROM DBA.PX ORDER BY ROWNO DESC;
the server keeps crashing.
The questions are : Is there a problem with the function we are unable to
understand ? Is there a better way to find the webdav file url from its CID ?
Kind regards, Xavier
----
SQL Studio 7.5.00.18
MaxDB 7.5.00.26
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
