Jacobson, Miranda | 16 Oct 00:26 2014

Read only access

I have a question concerning the C API. There is a SEsetConnectionAttr that can be called with an attribute, SEDNA_READONLY_TRANSACTION or SEDNA_UPDATE_TRANSACTION.

My question is does this have to be called before  SEconnect for it to take affect or can I keep changing this attribute during the entire connection?

 

Thanks,

 

Miranda Jacobson


----------------------------------------------------------------------------------
NOTICE: The information contained in this electronic message and any attachments to this message may contain information that is privileged, confidential, or is otherwise protected by work product immunity. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, use, copying, and/or disclosure of its contents is strictly prohibited. If you have received this message in error, please notify us immediately by either replying to this message or calling Volcano Corporation at +1 (800) 228-4728 and, deleting this message from your computer.   ­­  
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Sojma, Zdenek | 15 Oct 17:58 2014
Picon

Re: Long term stability

Hi Ivan,

 

The database stopped again so I am sending you the event.log file together with our simple log from running service (I did not find any fault* file). The se_term.exe returns following error when I try to connect:

 

failed to open session

SEDNA Message: ERROR SE3003

Failed to connect to the specified host.

Details: localhost:5050

 

I did not try the lates build yet, but I am going to in near future. We are currently using Windows 7 x86 and we install binary version of latest 3.5.161 sedna from your websites.

 

Thank you,

Zdenek

 

 

From: Ivan Shcheklein [mailto:shcheklein <at> gmail.com]
Sent: Monday, October 06, 2014 14:44
To: Sojma, Zdenek
Cc: sedna-discussion <at> lists.sourceforge.net
Subject: Re: [Sedna-discussion] Long term stability

 

Hi Zdenek,

 

2. What OS do you use? 

3. Do you build Sedna from sources?

4. Next time, please, save and send us event.log* and fault* files from the SEDNA_HOME/data folder.

 

Regards,

Ivan Shcheklein

Sedna Team

 

On Mon, Oct 6, 2014 at 2:38 PM, Sojma, Zdenek <Zdenek.Sojma <at> honeywell.com> wrote:

Hello,

 

We are using the Sedna which we run as a service for a long time. We regularly log into the database, store one document and log out. Everything works well for a while (month or more) and then the Sedna randomly stops working and we cannot even connect to it. Only thing that works for us is to delete the database and create it again. I know that this is a long shot, but do you have some known issue that can cause this? We have also troubles to replicate the error state, so we cannot debug it deeper? Can you please tell us where we can look for some troubleshooting information? (some log, etc.)

 

I also want to ask you how does it look like with development? Latest version released is 3.5.161 from Jan. 2012. Do you plan further development/support of the Sedna?

 

Thank you for your answer.

 

Best regards

Zdenek Sojma

 


------------------------------------------------------------------------------
Slashdot TV.  Videos for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

 

Attachment (Database Service.log): application/octet-stream, 1759 bytes
Attachment (event.log): application/octet-stream, 2991 bytes
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Ilya Taranov | 9 Oct 01:50 2014
Picon

Re: Sedna 3.5.615 repeated hanging

I can easily see the scenario, where one of the clients doesn't terminate the transaction properly. Unfortunately, current application timeout doesn't apply for client hangs. The issue can be easily fixed, however.

Unfortunately, even fix still would not solve your problem, you would still have application timeout wait on locks. Probably the most straightforward way to find the cause for you would be to log connection checkins/checkouts at the client driver level.

Could you please give me a link to the connection pool + driver you currently use (including all your changes if possible) so I could help you with that?

On Tue, Oct 7, 2014 at 4:37 AM, Ivan Lagunov <lagivan-Re5JQEeQqe8@public.gmane.orgm> wrote:
Hi Ilya,

Your suggestion seems to be correct. After I've restarted three Java applications that had connections to Sedna, the database has resumed processing operations. Here is the event.log where Sedna has hanged between 12:35:03 and 13:06:05:


I'm not sure which of the applications caused it though. It still worries me as the queries before hanging look quite simple and I cannot understand which client operation could have hanged the whole database.

Best regards,
Ivan Lagunov

On Mon, Oct 6, 2014 at 12:29 PM, Ivan Lagunov <lagivan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
Hi Ilya,

Yes, I use a connection pool via Sedna XML:DB API implementation. It's documented here:


Unfortunately, there is no support for active connection timeout. This could be the cause if there was a query hanging for some reason. Still if some query hangs forever (that should not as it's in my case) it looks more like a database bug/deadlock situation.

I'll try as you suggest next time.

P.S. Sorry for the second email as I've forgotten to add CC first.

Best regards,
Ivan Lagunov

On Fri, Oct 3, 2014 at 10:23 PM, Ilya Taranov <epsilon-wUdYQqulHFfT9K10yU4tPQ@public.gmane.org> wrote:
Ivan, do you have a connection pool? I see one of the se_trn processes waiting for socket read. 

If you don't have a connection pool, it just might be a client problem. I'll take a deeper look anyway, just next time it happens, could you please try to shutdown the client thread, if it's even possible.

On Thu, Oct 2, 2014 at 5:30 AM, Ivan Lagunov <lagivan <at> gmail.com> wrote:
Hi all,

I've been facing major issues with Sedna hanging regularly for the last two weeks (after several months of stable work). I tried to do the complete export-import of data using se_exp but Sedna still hangs regularly. Looking into event.log does not help as queries differ every time. Sometimes it looks like Sedna hangs after some heavy query (with huge response) while in other cases there are no heavy queries to suspect. I've written a script to collect the following logs/dumps you will find in the archives:

event.log - the last Sedna event log till the moment DB hangs and is stopped;
sedna_procs.txt - list of all Sedna processes (ps -ef);
netstat.txt - list of all ESTABLISHED connections;
ipcs.txt - results of ipcs -s;
<pid>.txt - results of gdb with bt for all threads of a Sedna process (available for all processes at the moment of hanging). This is collected automatically for threads 1-4 of each process.

I'm providing two sets of logs/dumps for two separate hanging events:

25th September - seemed to hang without any heavy queries:

2nd October - hanged after a heavy query:
The heavy query occurs at LOG   02/10/2014 11:10:20

If you can find out the cause of the hangings, it'd be the best. Otherwise it'd be nice to hear some recommendations at least on how to avoid these issues/minimize an impact. May be I need to upgrade to some later version but I'm currently using 3.5.615 that is already a night build that we had to upgrade to after some older issue (reported back in March-April of 2013). I'd try some 3.5 or 3.6 version but without knowing the reason there is no guarantee the potential bug is fixed in the later night build.

Also it'd be really nice if there was an official release for 3.5 with all the latest bug fixes (I see the last night build is 3.5.627 of 8th May 2013).

Best regards,
Ivan Lagunov

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/sedna-discussion





------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Bill | 8 Oct 05:17 2014

events posted by sedna if records change

Hello

Is there some mechanism in SEDNA, or perhaps in some other tool that can be 
used together with SEDNA, that can 'post' events to my application when a 
record has changed?

I have seen a reply to an earlier post where someone asked if SEDNA 
supported application callbacks in triggers. That reply was negative, in 
other words, I can not create a trigger in the database that will notify my 
application if a specific record (or record type) is added, updated or 
deleted.

I would think this to be a desirable feature that is often asked for by 
developers working with SEDNA as their DBMS.

Thanks
Bill

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Ivan Lagunov | 2 Oct 14:30 2014
Picon

Sedna 3.5.615 repeated hanging

Hi all,

I've been facing major issues with Sedna hanging regularly for the last two weeks (after several months of stable work). I tried to do the complete export-import of data using se_exp but Sedna still hangs regularly. Looking into event.log does not help as queries differ every time. Sometimes it looks like Sedna hangs after some heavy query (with huge response) while in other cases there are no heavy queries to suspect. I've written a script to collect the following logs/dumps you will find in the archives:

event.log - the last Sedna event log till the moment DB hangs and is stopped;
sedna_procs.txt - list of all Sedna processes (ps -ef);
netstat.txt - list of all ESTABLISHED connections;
ipcs.txt - results of ipcs -s;
<pid>.txt - results of gdb with bt for all threads of a Sedna process (available for all processes at the moment of hanging). This is collected automatically for threads 1-4 of each process.

I'm providing two sets of logs/dumps for two separate hanging events:

25th September - seemed to hang without any heavy queries:

2nd October - hanged after a heavy query:
The heavy query occurs at LOG   02/10/2014 11:10:20

If you can find out the cause of the hangings, it'd be the best. Otherwise it'd be nice to hear some recommendations at least on how to avoid these issues/minimize an impact. May be I need to upgrade to some later version but I'm currently using 3.5.615 that is already a night build that we had to upgrade to after some older issue (reported back in March-April of 2013). I'd try some 3.5 or 3.6 version but without knowing the reason there is no guarantee the potential bug is fixed in the later night build.

Also it'd be really nice if there was an official release for 3.5 with all the latest bug fixes (I see the last night build is 3.5.627 of 8th May 2013).

Best regards,
Ivan Lagunov
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Milan Vidaković | 1 Sep 15:37 2014

update from xquery functions

Hi all,

in exist db I am able to make and invoke function which contains update:

declare function local:doInsertDokument($tip as xs:string, $sbroj as xs:positiveInteger, $datizd as xs:date, $jmbg as xs:string)

    as xs:boolean{

        let $i := update insert <Dokument tip="{$tip}" sbroj="{$sbroj}" datizd="{$datizd}" jmbg="{$jmbg}"/> preceding doc("sup.xml")//sup/Dokument[1]

        return true()       

};


<!-- /* Font Definitions */ <at> font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-536870145 1073786111 1 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} <at> page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> I wasn't able to do so in Sedna, and as far as I understand, it is not possible (yet). Is it really not possible to make function which contains update, and if it is not possible, are there any plans to enable this?
-- Best regards, Milan
------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Milind Gupta | 15 Aug 23:39 2014
Picon

Full text search support

Hi,
     I was trying a query on my collection:

{
for $x in collection("circuitIdeas")/Circuit_Ideas/Record_Info
    let $y := ftscan($x/Title,"Current and Mirror~","string-value")/parent::*/parent::*
    order by $y/Record_Info/DesignID
    return <tr><td>{data($y/Record_Info/DesignID)}</td><td>{data($y/Record_Info/Title)}</td><td>{data($y/Design_Details/Abstract)}</td></tr>
}

I get the following error:
SEDNA Message: ERROR SE1002
Feature is not implemented.
Details: full-text search support is disabled


Please excuse me if there is some dumb mistake. I am a total newbie for xquery and sedna as well. Any help would be appreciated.

Thanks!

Milind


------------------------------------------------------------------------------
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Malcolm G. Davis | 17 May 20:47 2014

Comparison between Sedna, eXist and BaseX?

While interesting, I am always skeptical of these types of analysis.

1. Tuning: 
a. Sedna is written in C/C++, the other 2 systems are Java based. Java based
systems always require some type of Java VM option tuning based on the
problem space.  
b. Sedna in a production environment also requires some tuning.  I have
spent effort in turning Sedna and eXistDb.  
c. Including tuning options (outside of indexing) is important.

2. Alternatives.
There are also other free options, such as DB2 express.  I've talked to
several people that prefer DB2 express for XQuery.

3. Test scenarios
a. Are the XQuery drivers equivalent?  Did you use REST for eXistDB & xBase
and not Sedna?  Sedna driver is lean and mean, REST has some inherit
overhead.

b.  All the documents are stored as separate documents?
What about the scenario of a single <Outletinfos> parent document with
Outletinfo documents as children?
I've pushed a single 2 GB XML document, with Outletinfo type documents as
children.

c.  What about batch updating?

d.  Is the full test suite available for review?

4. The project activity test
There has not been an official release of Sedan since Nov 2011.  The lack of
a iterative release model/plan has me concerned.

5. Stack memory space. 
Large queries will cause stack depth problems in Senda.  If you end up
writing XQuery with deep recursion, things will fail.
We overcame the problem by splinting up the problem and putting recursion in
the code calling Senda.

6. Understanding the model
I suggest reading link that is a technical discussion Zorba.
http://www.vldb.org/pvldb/2/vldb09-1078.pdf

Page 7 compares some of the XQuery offerings and talks in detail about the
different models.

For instances, SEDNA offers an iterator processing model while DB2
XML-Extended Relational engine.

The doc discusses the advantages & disadvantages of the different models.

Thanks,
malcolm

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Marco van der Putten | 14 May 11:25 2014
Picon

Comparison between Sedna, eXist and BaseX

About a month ago, I’ve done some tests with Sedna, eXist and BaseX XML databases.

My employer has decided to share this with the community as a token of appreciation for the good work on these free products.

For those of you who are interested in the results, see: http://svds.aweta.local:8080/share/s/U3Rt4TQ1R-uR4ut8DVZRqg

 

Regards,

    Marco van der Putten

 

+-----------------------------------------------+

| Marco van der Putten                          |

| Aweta G&P BV              http://www.aweta.nl |

|                                               |

| P.O. box 17               Burg. Winkellaan 8  |

| 2630 AA Nootdorp          2631 HG Nootdorp    |

| Netherlands                                   |

| ++31-(0)886688000 (telephone)                 |

| ++31-(0)153107321 (fax)                       |

+-----------------------------------------------+

 

 

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Kanchan Dokania | 5 May 11:59 2014
Picon

Which version of PHP is compatible with Sedna database? - Error in sedna.dll loading

Hi ,

I am getting the below error:

PHP Warning:  PHP Startup: sedna: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP    compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0

Can you please tell me which version of PHP is compatible with Sedna database?

Thanks Kanchan
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Kanchan Dokania | 4 May 18:46 2014
Picon

PHI API for Sedna

Hi,

Please tell me how to build sedna.dll library for php 5.5 and 5.1 in windows.

Thanks Kanchan
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Gmane