Spencer Cheng | 1 Jun 2010 02:40

Re: Build errors on Mac OS X

Hi Ivan,

You did say it was alpha code so I have no problems with some glitches. What I would like to have is a stable
Sedna/Ruby development platform on Mac OS X so I can do my initial development without having to try to
develop in a Linux VM. I'll even accept something that is not always stable. :) 

Rolf has been very good and updated the Ruby driver for Sedna to include libsedna. It works fine on Linux
(Ubuntu Server 10.04 - thanks Rolf) but something is not quite right on 10.6.

Regards,
Spencer

On May 31, 2010, at 15:30, Ivan Shcheklein wrote:

> Hi Spencer,
> 
> Sorry for the delay. We experimented with SL 10.6.3.
> 
> I still don't understand completely what do you actually want - just to try
> Sedna x64 or to install Ruby driver? Or both? )).
> 
> To install Ruby driver you don't need the latest Sedna. Just take Sedna
> 3.3.55 and build x64 C driver with commands (only comment or change
> ucontext.h stuff):
> 
> cd driver/c
> make
> 
> Then you should be able to install Ruby driver.
> 
(Continue reading)

SourceForge.net | 1 Jun 2010 05:30
Picon
Favicon

[ sedna-Bugs-3009467 ] se_exp import failed

Bugs item #3009467, was opened at 2010-05-31 17:21
Message generated for change (Comment added) made by allexk
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3009467&group_id=129076

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Export/Import
Group: Sedna (development)
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: infodynedev (infodynedev)
Assigned to: Alexander Kalinin (allexk)
Summary: se_exp import failed

Initial Comment:
Sedna: 3.3. Build 138 (night build)
OS: Vista64

Dear Sedna Team support,

With the nighty build of sedna (3.3 build 138) we were unable to proceed to an import or restore with se_exp.
The testdb database can be an existing db  or an empty one created with se_cdb ,with or without authorization.
The hot backup features is still working.

1) Issuing a backup command work as expected:
se_exp export testdb c:\back_testdb
(Continue reading)

Ivan Shcheklein | 1 Jun 2010 23:26
Picon
Gravatar

Re: Build errors on Mac OS X

I have the same Ruby. I've tried to install driver and it works fine for me. Here what I've done:

1. Download sedna-3.3.55 sources for Darwin and upack them somewhere in temporary dir.

2. Build x64 C driver:

     <ucontext.h -> sys/ucontext.h in u.h>

     cd <path-to-sedna-3.3.55>/driver/c
     make

3. Install Ruby driver with gem:

     gem install sedna -- --with-sedna-dir=<path-to-sedna-3.3.55>


If you still have problems, please, send us output of the commands above and example of Ruby code which doesn't work for you.

On Wed, Jun 2, 2010 at 12:43 AM, Spencer Cheng <scheng-oy5H8LD8oqiakBO8gow8eQ@public.gmane.org> wrote:
Hi Ivan,

I don't use Rail so the S/W lineup is pretty simple. Ruby is Apple supplied version I believe. Thanks.

Regards,
Spencer

------------
spencer <at> tsangpo:sedna$ type ruby
ruby is hashed (/usr/bin/ruby)
spencer <at> tsangpo:sedna$ ruby -v
ruby 1.8.7 (2009-06-08 patchlevel 173) [universal-darwin10.0]
spencer <at> tsangpo:sedna$ gem list

*** LOCAL GEMS ***

columnize (0.3.1)
linecache (0.43)
macaddr (1.0.0)
rake (0.8.7)
rdoc (2.5.8)
ruby-debug (0.10.3)
ruby-debug-base (0.10.3)
rubygems-update (1.3.7)
sedna (0.6.0)
uuid (2.3.1)
xmpp4r (0.5)
---------------

On Jun 1, 2010, at 16:18, Ivan Shcheklein wrote:

> Ok. What versions of Ruby, Rubygems, Rails do you use on Mac? Did you build
> them from sources?
>
> I'll to install them on my Mac OS.


------------------------------------------------------------------------------

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Spencer Cheng | 2 Jun 2010 02:58

Re: Build errors on Mac OS X

Hi Ivan,

I started from scratch on my Mac by deleting my existing Sedna installation and all the Ruby gems. 

1/ I installed sedna-3.3.55-bin-darwin-i386.sh. Started se_gov, created test DB using se_cdb, start
the test DB using se_sm. I can connect to the test DB using se_term.

2/ I installed Rolf's Ruby gem for sedna ($sudo gem install sedna). The install went without error.

3/ I run some ruby scripts using irb (interactive ruby). 

---------
>> require 'sedna'
=> true
>> c={ :database => 'test', :host => 'localhost'}
=> {:database=>"test", :host=>"localhost"}
>> s=Sedna.connect c
=> #<Sedna:0x10157b898>
>> s.connected?
NoMethodError: undefined method `connected?' for #<Sedna:0x10157b898>
	from (irb):5
--------------
So this is strange because the Sedna class is missing a method. Is it a problem with the local DB? Try
different server.

--------------------
>> c={ :database => 'test', :host => '192.168.1.192'}
=> {:database=>"test", :host=>"192.168.1.192"}
>> s=Sedna.connect c
=> #<Sedna:0x10157b898>
>> s.connected?
NoMethodError: undefined method `connected?' for #<Sedna:0x10157b898>
	from (irb):8
>> ^D
-------------------
That doesn't seem to be the problem.

So this where Rolf and I are at. It works on his Mac and not on mine. Very annoying.

Regards,
Spencer

On Jun 1, 2010, at 17:26, Ivan Shcheklein wrote:

> I have the same Ruby. I've tried to install driver and it works fine for me.
> Here what I've done:
> 
> 1. Download sedna-3.3.55 sources for Darwin and upack them somewhere in
> temporary dir.
> 
> 2. Build x64 C driver:
> 
>     <ucontext.h -> sys/ucontext.h in u.h>
>     cd <path-to-sedna-3.3.55>/driver/c
>     make
> 
> 3. Install Ruby driver with gem:
> 
>     gem install sedna -- --with-sedna-dir=<path-to-sedna-3.3.55>
> 
> If you still have problems, please, send us output of the commands above and
> example of Ruby code which doesn't work for you.
> 
> On Wed, Jun 2, 2010 at 12:43 AM, Spencer Cheng <scheng@...> wrote:
> 
>> Hi Ivan,
>> 
>> I don't use Rail so the S/W lineup is pretty simple. Ruby is Apple supplied
>> version I believe. Thanks.
>> 
>> Regards,
>> Spencer
>> 
>> ------------
>> spencer <at> tsangpo:sedna$ type ruby
>> ruby is hashed (/usr/bin/ruby)
>> spencer <at> tsangpo:sedna$ ruby -v
>> ruby 1.8.7 (2009-06-08 patchlevel 173) [universal-darwin10.0]
>> spencer <at> tsangpo:sedna$ gem list
>> 
>> *** LOCAL GEMS ***
>> 
>> columnize (0.3.1)
>> linecache (0.43)
>> macaddr (1.0.0)
>> rake (0.8.7)
>> rdoc (2.5.8)
>> ruby-debug (0.10.3)
>> ruby-debug-base (0.10.3)
>> rubygems-update (1.3.7)
>> sedna (0.6.0)
>> uuid (2.3.1)
>> xmpp4r (0.5)
>> ---------------
>> 
>> On Jun 1, 2010, at 16:18, Ivan Shcheklein wrote:
>> 
>>> Ok. What versions of Ruby, Rubygems, Rails do you use on Mac? Did you
>> build
>>> them from sources?
>>> 
>>> I'll to install them on my Mac OS.
>> 
>> 

------------------------------------------------------------------------------
Spencer Cheng | 2 Jun 2010 03:09

Re: Linux port problems?

Hi Ivan,

On May 28, 2010, at 17:14, Ivan Shcheklein wrote:

> 
> Did you run it on static binaries? You should run ldd with se_trn from the
> ordinary Sedna binaries package.
> 
> 

root <at> dev:~# sh sedna-3.3.55-bin-linux-i686.sh
This program will extract and install Sedna XML DBMS.

Where do you want to install the "sedna" directory tree?
 1 - /usr/local
 2 - /opt
 3 - $HOME (/home/spencer) [default]
 4 - . (here)
 Or enter a different directory (prefix) to install in.
> /usr/local/sedna.shared
Checking the integrity of the binary archive... ok
Unpacking into "/usr/local/sedna.shared/sedna"... done
[...]
root <at> dev:~# ldd /usr/local/sedna.shared/bin/se_trn
ldd: /usr/local/sedna.shared/bin/se_trn: No such file or directory

Regards,
Spencer

------------------------------------------------------------------------------
Ivan Shcheklein | 2 Jun 2010 07:52
Picon
Gravatar

Re: Build errors on Mac OS X

Spencer, besides sedna binaries you MUST download sedna sources, MUST build C driver and install Sedna Ruby driver with --with-sedna-dir option.


On Wed, Jun 2, 2010 at 4:58 AM, Spencer Cheng <scheng-oy5H8LD8oqiakBO8gow8eQ@public.gmane.org> wrote:
Hi Ivan,

I started from scratch on my Mac by deleting my existing Sedna installation and all the Ruby gems.

1/ I installed sedna-3.3.55-bin-darwin-i386.sh. Started se_gov, created test DB using se_cdb, start the test DB using se_sm. I can connect to the test DB using se_term.

2/ I installed Rolf's Ruby gem for sedna ($sudo gem install sedna). The install went without error.

3/ I run some ruby scripts using irb (interactive ruby).

---------
>> require 'sedna'
=> true
>> c={ :database => 'test', :host => 'localhost'}
=> {:database=>"test", :host=>"localhost"}
>> s=Sedna.connect c
=> #<Sedna:0x10157b898>
>> s.connected?
NoMethodError: undefined method `connected?' for #<Sedna:0x10157b898>
       from (irb):5
--------------
So this is strange because the Sedna class is missing a method. Is it a problem with the local DB? Try different server.

--------------------
>> c={ :database => 'test', :host => '192.168.1.192'}
=> {:database=>"test", :host=>"192.168.1.192"}
>> s=Sedna.connect c
=> #<Sedna:0x10157b898>
>> s.connected?
NoMethodError: undefined method `connected?' for #<Sedna:0x10157b898>
       from (irb):8
>> ^D
-------------------
That doesn't seem to be the problem.

So this where Rolf and I are at. It works on his Mac and not on mine. Very annoying.

Regards,
Spencer

On Jun 1, 2010, at 17:26, Ivan Shcheklein wrote:

> I have the same Ruby. I've tried to install driver and it works fine for me.
> Here what I've done:
>
> 1. Download sedna-3.3.55 sources for Darwin and upack them somewhere in
> temporary dir.
>
> 2. Build x64 C driver:
>
>     <ucontext.h -> sys/ucontext.h in u.h>
>     cd <path-to-sedna-3.3.55>/driver/c
>     make
>
> 3. Install Ruby driver with gem:
>
>     gem install sedna -- --with-sedna-dir=<path-to-sedna-3.3.55>
>
> If you still have problems, please, send us output of the commands above and
> example of Ruby code which doesn't work for you.
>
> On Wed, Jun 2, 2010 at 12:43 AM, Spencer Cheng <scheng-oy5H8LD8oqiakBO8gow8eQ@public.gmane.org> wrote:
>
>> Hi Ivan,
>>
>> I don't use Rail so the S/W lineup is pretty simple. Ruby is Apple supplied
>> version I believe. Thanks.
>>
>> Regards,
>> Spencer
>>
>> ------------
>> spencer <at> tsangpo:sedna$ type ruby
>> ruby is hashed (/usr/bin/ruby)
>> spencer <at> tsangpo:sedna$ ruby -v
>> ruby 1.8.7 (2009-06-08 patchlevel 173) [universal-darwin10.0]
>> spencer <at> tsangpo:sedna$ gem list
>>
>> *** LOCAL GEMS ***
>>
>> columnize (0.3.1)
>> linecache (0.43)
>> macaddr (1.0.0)
>> rake (0.8.7)
>> rdoc (2.5.8)
>> ruby-debug (0.10.3)
>> ruby-debug-base (0.10.3)
>> rubygems-update (1.3.7)
>> sedna (0.6.0)
>> uuid (2.3.1)
>> xmpp4r (0.5)
>> ---------------
>>
>> On Jun 1, 2010, at 16:18, Ivan Shcheklein wrote:
>>
>>> Ok. What versions of Ruby, Rubygems, Rails do you use on Mac? Did you
>> build
>>> them from sources?
>>>
>>> I'll to install them on my Mac OS.
>>
>>


------------------------------------------------------------------------------

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

------------------------------------------------------------------------------

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Ivan Shcheklein | 2 Jun 2010 07:54
Picon
Gravatar

Re: Linux port problems?

Spencer,

root <at> dev:~# ldd /usr/local/sedna.shared/bin/se_trn
ldd: /usr/local/sedna.shared/bin/se_trn: No such file or directory


Probably, because you should run ldd /usr/local/sedna.shared/sedna/bin/se_trn .

Ivan
------------------------------------------------------------------------------

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Michele Bassanelli | 2 Jun 2010 17:15
Picon

Performance degrades

I use sedna 3.3.55 on windows 7 64 bit.
I must insert a lot of xml nodes (1000) of about 600kb, all in the same resource.
The performance degrades costantly, the first insertion take about 5s but after two hundred insertion the time is about 30s.
Is normal this behavior?

If at this point I  recreate the db and load  the entire xml (with bulk load) and I try to add more nodes to the resource, the performances improves and returns as the start (5s. even if the resource already contains 1000 nodes)

The xml node:
  <value>
     <row>test1</row>
     <row>test2</row>
     <row>test3</row>
      ...
  </value>

The initial resource is simply
<values>
</values>

------------------------------------------------------------------------------

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Ivan Shcheklein | 2 Jun 2010 20:23
Picon
Gravatar

Re: Performance degrades

Hi Michele,


I use sedna 3.3.55 on windows 7 64 bit.
I must insert a lot of xml nodes (1000) of about 600kb, all in the same resource.
The performance degrades costantly, the first insertion take about 5s but after two hundred insertion the time is about 30s.
Is normal this behavior?

I hope it's not. Could you give me a couple hundred files to try to reproduce this? It's quite hard to determine remotely what's going on.

Anyway, at least send us complete event logs - from the database creation up to 30s performance.

Ivan Shcheklein,
Sedna Team
 


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Michele Bassanelli | 3 Jun 2010 10:19
Picon

Re: Performance degrades

Hi Ivan,

By further analysis I realized that the problem was in the layer that managed the recover  of the xml and not in the insertion on Sedna.

Creating a mini-application to test the problem that  I explained I found that the performance are constant


Bassanelli Michele

2010/6/2 Ivan Shcheklein <shcheklein-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Hi Michele,

I use sedna 3.3.55 on windows 7 64 bit.
I must insert a lot of xml nodes (1000) of about 600kb, all in the same resource.
The performance degrades costantly, the first insertion take about 5s but after two hundred insertion the time is about 30s.
Is normal this behavior?

I hope it's not. Could you give me a couple hundred files to try to reproduce this? It's quite hard to determine remotely what's going on.

Anyway, at least send us complete event logs - from the database creation up to 30s performance.

Ivan Shcheklein,
Sedna Team
 



------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Gmane