Hi Xavier, First of all: There is no other way to retrieve a documents URL than by using a recursive select. That approach was perfectly right.
As for the means you used I have to disappoint you in a way: functions are not released in 7.5. They are present in a more work-in-progress like way. Anyway in 7.5 you have to use a db procedure instead. Unfortunately you will loose the possibility to use the procedure inside a select statement. But it would work w/o crashing your server. Cheers, Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 1. Juni 2005 10:02 To: [email protected] Subject: Webdav, Server Crash 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
