Hi, I am curious regarding the document-uri used to find the document name. Can it be used in a xquery statement in order to drop a document? Something along the line: se_term -query "DROP DOCUMENT document-uri(...) IN COLLECTION 'col-name'" dbname
Tks, Jocelyn Raymond University of Alberta -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: October 29, 2010 10:50 AM To: [email protected] Subject: Sedna-discussion Digest, Vol 51, Issue 10 Send Sedna-discussion mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/sedna-discussion or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Sedna-discussion digest..." Today's Topics: 1. Re: How to find out the document name (Ivan Lagunov) 2. Re: Memory mapping error and database recovery failure (Ivan Shcheklein) 3. Re: php-api-2.0 (Tak-po Li) ---------------------------------------------------------------------- Message: 1 Date: Mon, 25 Oct 2010 17:16:49 +0400 From: Ivan Lagunov <[email protected]> Subject: Re: [Sedna-discussion] How to find out the document name To: Ivan Shcheklein <[email protected]> Cc: sedna-discussion <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Hi, Thanks! It works. Best regards, Ivan On 10/21/2010 05:36 PM, Ivan Shcheklein wrote: > Hi Ivan, > > I have the following xquery: > collection("col_name")[Main/UniqueCode="s145"] > It returns full contents of the document. > Please advise how I can get this document's name ("something.xml")? > > > Use document-uri function: > > document-uri(collection("col_name")[Main/UniqueCode="s145"]) > > It will return name of the document in the database. > > > Ivan Shcheklein, > Sedna Team -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Mon, 25 Oct 2010 18:04:28 +0400 From: Ivan Shcheklein <[email protected]> Subject: Re: [Sedna-discussion] Memory mapping error and database recovery failure To: [email protected] Cc: sedna-discussion <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Ok. At least is it possible for you to send us full even logs? You can remove any confidential information from it. It'll probaly help us to fix this issue and make Sedna better. Ivan Hi, > > Unfortunately, I cannot share the database files as it contains > confidential information from our customer. At least I'll need to get > an approval. > > Best regards, > Ivan Lagunov > > > On 10/23/2010 08:17 PM, Ivan Shcheklein wrote: > > Hi Ivan, > > Seems to be a bug in Sedna. > > Is it possible for you to share this corrupted database with Sedna > Team to try to understand exact reasons of this failure? Please, > contact us directly at [email protected] to get access to the private > ftp. Of course we guarantee that data will be used only for testing and fixing bugs. > > Ivan Shcheklein, > Sedna Team > > > Hi, >> >> Please find all requested information in the attached files: >> sedna_home.txt - results of ls -lh SEDNA_HOME/* sedna_home_data.txt - >> results of ls -lh SEDNA_HOME/data/* dev_shm.txt - results of ls -lh >> /dev/shm df.txt - results of df -h event.log - new event.log with >> -el-level 4 >> >> I work with Sedna from the standard account system/manager. >> >> Best regards, >> Ivan Lagunov >> >> >> On 10/22/2010 09:56 PM, Ivan Shcheklein wrote: >> >> Ok, please send us also: >> >> 1. result of the: >> >> ls -lh SEDNA_HOME/* >> ls -lh SEDNA_HOME/data/* >> >> ls -lh /dev/shm >> >> df -h >> >> 2. Name of the account you working with Sedna from. >> 3. Restart se_gov with "-el-level 4" option, try to run se_sm >> database and send us new event logs. >> >> >> Hi, >>> >>> I've attached event log file (only part of it). On 21st of October >>> the database worked fine. And the first transaction from the log >>> file was successful (at 21/10/2010 16:22:18). Indeed I don't >>> remember if I stopped the database with se_stop yesterday or it was >>> terminated during the computer shutting down. It might be the cause of problems. >>> >>> I couldn't find any fault folders. It might be connected with that >>> error message that appeared in the terminal: >>> "Cannot create data directory for soft fault logs". If you can >>> advise how it can be solved too, I'll be grateful. >>> >>> Best regards, >>> Ivan Lagunov >>> >>> >>> On 10/22/2010 09:03 PM, Ivan Shcheklein wrote: >>> >>>> Hi Ivan, >>>> >>>> Please send us the following information: >>>> >>>> 1. Complete event log (all event log files from SEDNA_HOME/data). >>>> 2. Fault folders (if any) - SEDNA_HOME/data/fault**** >>>> >>>> What caused initial database crash? >>>> >>>> Ivan Shcheklein, >>>> Sedna Team >>>> >>> >>> >> >> > > -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 3 Date: Fri, 29 Oct 2010 12:49:16 -0400 From: Tak-po Li <[email protected]> Subject: Re: [Sedna-discussion] php-api-2.0 To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Hi Ivan, I just download and unzip php-api-2.0 9/23/2010 5:00PM in XP by WinZip 8.1. I got a single file size 681,230. It seems some where the zip is wrong. Could you please take a look? Thanks, Tak On Mon, Oct 25, 2010 at 5:34 AM, < [email protected]> wrote: > Send Sedna-discussion mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/sedna-discussion > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Sedna-discussion digest..." > > > Today's Topics: > > 1. Re: Memory mapping error and database recovery failure > (Ivan Lagunov) > 2. Re: Memory mapping error and database recovery failure > (Ivan Shcheklein) > 3. Re: Memory mapping error and database recovery failure > (Ivan Lagunov) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 23 Oct 2010 18:20:36 +0400 > From: Ivan Lagunov <[email protected]> > Subject: Re: [Sedna-discussion] Memory mapping error and database > recovery failure > To: Ivan Shcheklein <[email protected]> > Cc: sedna-discussion <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi, > > Please find all requested information in the attached files: > sedna_home.txt - results of ls -lh SEDNA_HOME/* sedna_home_data.txt - > results of ls -lh SEDNA_HOME/data/* dev_shm.txt - results of ls -lh > /dev/shm df.txt - results of df -h event.log - new event.log with > -el-level 4 > > I work with Sedna from the standard account system/manager. > > Best regards, > Ivan Lagunov > > On 10/22/2010 09:56 PM, Ivan Shcheklein wrote: > > Ok, please send us also: > > > > 1. result of the: > > > > ls -lh SEDNA_HOME/* > > ls -lh SEDNA_HOME/data/* > > > > ls -lh /dev/shm > > > > df -h > > > > 2. Name of the account you working with Sedna from. > > 3. Restart se_gov with "-el-level 4" option, try to run se_sm > > database and send us new event logs. > > > > > > Hi, > > > > I've attached event log file (only part of it). On 21st of October > > the database worked fine. And the first transaction from the log > > file was successful (at 21/10/2010 16:22:18). Indeed I don't > > remember if I stopped the database with se_stop yesterday or it > > was terminated during the computer shutting down. It might be the > > cause of problems. > > > > I couldn't find any fault folders. It might be connected with that > > error message that appeared in the terminal: > > "Cannot create data directory for soft fault logs". If you can > > advise how it can be solved too, I'll be grateful. > > > > Best regards, > > Ivan Lagunov > > > > > > On 10/22/2010 09:03 PM, Ivan Shcheklein wrote: > > > > Hi Ivan, > > > > Please send us the following information: > > > > 1. Complete event log (all event log files from SEDNA_HOME/data). > > 2. Fault folders (if any) - SEDNA_HOME/data/fault**** > > > > What caused initial database crash? > > > > Ivan Shcheklein, > > Sedna Team > > > > > > > > -------------- next part -------------- An HTML attachment was > scrubbed... > -------------- next part -------------- An embedded and > charset-unspecified text was scrubbed... > Name: dev_shm.txt > -------------- next part -------------- An embedded and > charset-unspecified text was scrubbed... > Name: df.txt > -------------- next part -------------- An embedded and > charset-unspecified text was scrubbed... > Name: event.log > -------------- next part -------------- An embedded and > charset-unspecified text was scrubbed... > Name: sedna_home.txt > -------------- next part -------------- An embedded and > charset-unspecified text was scrubbed... > Name: sedna_home_data.txt > > ------------------------------ > > Message: 2 > Date: Sat, 23 Oct 2010 20:17:11 +0400 > From: Ivan Shcheklein <[email protected]> > Subject: Re: [Sedna-discussion] Memory mapping error and database > recovery failure > To: [email protected] > Cc: sedna-discussion <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi Ivan, > > Seems to be a bug in Sedna. > > Is it possible for you to share this corrupted database with Sedna > Team to try to understand exact reasons of this failure? Please, > contact us directly at [email protected] to get access to the private > ftp. Of course we guarantee that data will be used only for testing > and fixing bugs. > > Ivan Shcheklein, > Sedna Team > > > Hi, > > > > Please find all requested information in the attached files: > > sedna_home.txt - results of ls -lh SEDNA_HOME/* sedna_home_data.txt > > - results of ls -lh SEDNA_HOME/data/* dev_shm.txt - results of ls > > -lh /dev/shm df.txt - results of df -h event.log - new event.log > > with -el-level 4 > > > > I work with Sedna from the standard account system/manager. > > > > Best regards, > > Ivan Lagunov > > > > > > On 10/22/2010 09:56 PM, Ivan Shcheklein wrote: > > > > Ok, please send us also: > > > > 1. result of the: > > > > ls -lh SEDNA_HOME/* > > ls -lh SEDNA_HOME/data/* > > > > ls -lh /dev/shm > > > > df -h > > > > 2. Name of the account you working with Sedna from. > > 3. Restart se_gov with "-el-level 4" option, try to run se_sm > > database > and > > send us new event logs. > > > > > > Hi, > >> > >> I've attached event log file (only part of it). On 21st of October > >> the database worked fine. And the first transaction from the log > >> file was successful (at 21/10/2010 16:22:18). Indeed I don't > >> remember if I > stopped > >> the database with se_stop yesterday or it was terminated during the > computer > >> shutting down. It might be the cause of problems. > >> > >> I couldn't find any fault folders. It might be connected with that > >> error message that appeared in the terminal: > >> "Cannot create data directory for soft fault logs". If you can > >> advise > how > >> it can be solved too, I'll be grateful. > >> > >> Best regards, > >> Ivan Lagunov > >> > >> > >> On 10/22/2010 09:03 PM, Ivan Shcheklein wrote: > >> > >>> Hi Ivan, > >>> > >>> Please send us the following information: > >>> > >>> 1. Complete event log (all event log files from SEDNA_HOME/data). > >>> 2. Fault folders (if any) - SEDNA_HOME/data/fault**** > >>> > >>> What caused initial database crash? > >>> > >>> Ivan Shcheklein, > >>> Sedna Team > >>> > >> > >> > > > > > -------------- next part -------------- An HTML attachment was > scrubbed... > > ------------------------------ > > Message: 3 > Date: Mon, 25 Oct 2010 13:31:59 +0400 > From: Ivan Lagunov <[email protected]> > Subject: Re: [Sedna-discussion] Memory mapping error and database > recovery failure > To: Ivan Shcheklein <[email protected]> > Cc: sedna-discussion <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi, > > Unfortunately, I cannot share the database files as it contains > confidential information from our customer. At least I'll need to get > an approval. > > Best regards, > Ivan Lagunov > > On 10/23/2010 08:17 PM, Ivan Shcheklein wrote: > > Hi Ivan, > > > > Seems to be a bug in Sedna. > > > > Is it possible for you to share this corrupted database with Sedna > > Team to try to understand exact reasons of this failure? Please, > > contact us directly at [email protected] <mailto:[email protected]> to > > get access to the private ftp. Of course we guarantee that data will > > be used only for testing and fixing bugs. > > > > Ivan Shcheklein, > > Sedna Team > > > > > > Hi, > > > > Please find all requested information in the attached files: > > sedna_home.txt - results of ls -lh SEDNA_HOME/* > > sedna_home_data.txt - results of ls -lh SEDNA_HOME/data/* > > dev_shm.txt - results of ls -lh /dev/shm > > df.txt - results of df -h > > event.log - new event.log with -el-level 4 > > > > I work with Sedna from the standard account system/manager. > > > > Best regards, > > Ivan Lagunov > > > > > > On 10/22/2010 09:56 PM, Ivan Shcheklein wrote: > >> Ok, please send us also: > >> > >> 1. result of the: > >> > >> ls -lh SEDNA_HOME/* > >> ls -lh SEDNA_HOME/data/* > >> > >> ls -lh /dev/shm > >> > >> df -h > >> > >> 2. Name of the account you working with Sedna from. > >> 3. Restart se_gov with "-el-level 4" option, try to run se_sm > >> database and send us new event logs. > >> > >> > >> Hi, > >> > >> I've attached event log file (only part of it). On 21st of > >> October the database worked fine. And the first transaction > >> from the log file was successful (at 21/10/2010 16:22:18). > >> Indeed I don't remember if I stopped the database with > >> se_stop yesterday or it was terminated during the computer > >> shutting down. It might be the cause of problems. > >> > >> I couldn't find any fault folders. It might be connected with > >> that error message that appeared in the terminal: > >> "Cannot create data directory for soft fault logs". If you > >> can advise how it can be solved too, I'll be grateful. > >> > >> Best regards, > >> Ivan Lagunov > >> > >> > >> On 10/22/2010 09:03 PM, Ivan Shcheklein wrote: > >> > >> Hi Ivan, > >> > >> Please send us the following information: > >> > >> 1. Complete event log (all event log files from > >> SEDNA_HOME/data). > >> 2. Fault folders (if any) - SEDNA_HOME/data/fault**** > >> > >> What caused initial database crash? > >> > >> Ivan Shcheklein, > >> Sedna Team > >> > >> > >> > > > > > > -------------- next part -------------- An HTML attachment was > scrubbed... > > ------------------------------ > > > ---------------------------------------------------------------------- > -------- Nokia and AT&T present the 2010 Calling All Innovators-North > America contest Create new apps & games for the Nokia N8 for consumers > in U.S. and Canada $10 million total in prizes - $4M cash, 500 > devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web > Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > > ------------------------------ > > _______________________________________________ > Sedna-discussion mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/sedna-discussion > > > End of Sedna-discussion Digest, Vol 51, Issue 9 > *********************************************** > -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ ------------------------------------------------------------------------ ------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ------------------------------ _______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion End of Sedna-discussion Digest, Vol 51, Issue 10 ************************************************ ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
