headers
Tyler Corbin | 10 Jan 2010 03:52
Picon
Picon

Updating text nodes in Sedna

I’m trying to figure out how to edit text nodes in Sedna (with XQuery Update) and I seem to be having problems. Unlike other databases, Sedna doesn’t come with a update value feature and inserting a string (“text”) into a node doesn’t seem to work... The only way I worked around this is by replacing my node with the same node, with text; which seems pretty hackish.

 

I’ll include examples to help explain.

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

UPDATE

insert "text" into document("*.xml")//*/*    (where * means any arbitrary node.)

I receive the error

Query execution failed (SEDNA Message: ERROR SE2015 Invalid result of the first insert argument: sequence contains atomic values ).

 

UPDATE

insert "text" into document("*.xml")//*/*/text()    (where * means any arbitrary node.)

Just doesn’t work.

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

So to work around, this is what I did...

 

UPDATE

replace $p in document("*.xml")//*/test       (where * means any arbitrary node.)

with <test>text<test>

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

Am I missing something elementary to help me update text nodes? Because I shouldn’t be having problems with something so rudimentary.

 

Thanks in advance; and sorry for such a basic question. While waiting I’m going to re-read the documentation, as I may be missing something.

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Permalink | Reply | 1 comment |
headers
Ivan Shcheklein | 10 Jan 2010 14:58
Picon
Gravatar

Re: Updating text nodes in Sedna

Hi Tyler,

You should insert text *node* instead of atomic value:

update insert text {"something"} into document("doc")/somewhere1/somewhere2

See here for details on text node constructors: http://www.w3.org/TR/xquery/#id-textConstructors .

Ivan Shcheklein
Sedna Team


On Sun, Jan 10, 2010 at 5:52 AM, Tyler Corbin <094568c-XPJyLjwuGo6w5LPnMra/2Q@public.gmane.org> wrote:

I’m trying to figure out how to edit text nodes in Sedna (with XQuery Update) and I seem to be having problems. Unlike other databases, Sedna doesn’t come with a update value feature and inserting a string (“text”) into a node doesn’t seem to work... The only way I worked around this is by replacing my node with the same node, with text; which seems pretty hackish.

 

I’ll include examples to help explain.

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

UPDATE

insert "text" into document("*.xml")//*/*    (where * means any arbitrary node.)

I receive the error

Query execution failed (SEDNA Message: ERROR SE2015 Invalid result of the first insert argument: sequence contains atomic values ).

 

UPDATE

insert "text" into document("*.xml")//*/*/text()    (where * means any arbitrary node.)

Just doesn’t work.

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

So to work around, this is what I did...

 

UPDATE

replace $p in document("*.xml")//*/test       (where * means any arbitrary node.)

with <test>text<test>

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

Am I missing something elementary to help me update text nodes? Because I shouldn’t be having problems with something so rudimentary.

 

Thanks in advance; and sorry for such a basic question. While waiting I’m going to re-read the documentation, as I may be missing something.


------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion


------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Permalink | Reply | 0 comments |
headers
Kabanov, Alexander | 11 Jan 2010 14:32

Memory issues (number of instances of se_sm loaded)

Hi

I have been using Sedna for some time now, but recently began noticing some strange behaviour.
Unfortunately I cannot confirm whether this was actually happening form the start or not. Before I go into
the details of the problem, I would like to clarify something.

I run Sedna on two computers - one runs 64-bit Fedora 7 (8GB RAM) and the other 32-bit Ubuntu 8.04 (2GB RAM).
I began monitoring memory use of various processes recently (via the Linux "top" command) and I noticed a
difference in se_sm behaviour between the two computers: when I run se_sm <db_name> on 64-bit Fedora I get
5 se_sm processes in the memory, each taking up the same amount of memory, whereas on 32-bit Ubuntu I only
get one instance of se_sm in the memory. I tried this with several databases. In both cases all se_sm
instances go away when se_smsd is called on the relevant database. I was wondering if any of this is
expected behaviour?

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 0 comments |
headers
SourceForge.net | 11 Jan 2010 15:10
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 14:10
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 0 comments |
headers
SourceForge.net | 11 Jan 2010 15:17
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 14:10
Message generated for change (Comment added) made by userbob99
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 14:17

Message:
unfortunately i am unable to upload the appropriate data as it contains
customer data.

attached is 1 log 

the other from SM5020.log is 

SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: C:\Development\Tools\sedna\bin\se_sm.exe
vision_xchange

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 0 comments |
headers
SourceForge.net | 11 Jan 2010 15:18
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 14:10
Message generated for change (Comment added) made by userbob99
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 14:18

Message:
se_gov starts correctly and when running se_sm against the db either se_sm
or se_rcv crashes.

i am unable to access the db therefore to export the data

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 14:17

Message:
unfortunately i am unable to upload the appropriate data as it contains
customer data.

attached is 1 log 

the other from SM5020.log is 

SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: C:\Development\Tools\sedna\bin\se_sm.exe
vision_xchange

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 1 comment |
headers
SourceForge.net | 11 Jan 2010 16:08
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 17:10
Message generated for change (Comment added) made by shcheklein
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
Status: Open
>Resolution: Accepted
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Ivan Shcheklein (shcheklein)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

>Comment By: Ivan Shcheklein (shcheklein)
Date: 2010-01-11 18:08

Message:
Hi Richard,

Unfortunatelly, I don't know what we can do in this situation. Can you
send us event log files at least? Do you have backups of your data? Is this
issue reproducible?

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 17:18

Message:
se_gov starts correctly and when running se_sm against the db either se_sm
or se_rcv crashes.

i am unable to access the db therefore to export the data

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 17:17

Message:
unfortunately i am unable to upload the appropriate data as it contains
customer data.

attached is 1 log 

the other from SM5020.log is 

SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: C:\Development\Tools\sedna\bin\se_sm.exe
vision_xchange

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 0 comments |
headers
SourceForge.net | 11 Jan 2010 16:26
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 14:10
Message generated for change (Comment added) made by userbob99
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
Status: Open
Resolution: Accepted
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Ivan Shcheklein (shcheklein)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 15:26

Message:
the last event log file is below. i cannot seem to attach more artifacts to
this call

INFO  11/01/2010 14:01:10 (GOV pid=4764) [gov.cpp:main:231]: SEDNA version
is 3.1.175
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gov_functions.cpp:log_out_system_information:79]: System: Windows 6.0.6002
(SP2.0) x86
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:129]: Layer address space start addr
= 0x22380000
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:130]: Layer address space boundary  
= 0x62380000
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:131]: Persistent heap start addr    
= 0x1bf80000
LOG   11/01/2010 14:01:10 (GOV pid=4764) [gov.cpp:main:240]: Process ping
server is ready
LOG   11/01/2010 14:01:10 (GOV pid=4764)
[listener.cpp:client_listener:67]: GOVERNOR is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:547]:
Event log is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:560]:
Ping client has been started
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:566]:
VMM region values determined
SYS   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
SYS   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:830]: Event log in
recovery procedure is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:834]:
init_transaction_ids_table done
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:838]:
init_checkpoint_sems done
LOG   11/01/2010 14:01:15 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:844]: Logical log is
started
LOG   11/01/2010 14:01:16 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:859]: Persistent heap
has been recovered
LOG   11/01/2010 14:01:16 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:864]:
start_chekpoint_thread done
LOG   11/01/2010 14:01:22 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:886]: Buffer manager
is started
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[blk_mngmt.cpp:extend_tmp_file:619]: Temp file has been extended, size:
6400000
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:893]: Database has
been recovered by physical log successfully
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:898]: Checkpoints are
disabled
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:902]:
lm_table.init_lock_table done
LOG   11/01/2010 14:03:10 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:925]: Wu is
initialized
LOG   11/01/2010 14:03:10 (UNK vision_xchange pid=5640)
[rcv_db.cpp:TRmain:81]: recovery process by logical log started

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

Comment By: Ivan Shcheklein (shcheklein)
Date: 2010-01-11 15:08

Message:
Hi Richard,

Unfortunatelly, I don't know what we can do in this situation. Can you
send us event log files at least? Do you have backups of your data? Is this
issue reproducible?

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 14:18

Message:
se_gov starts correctly and when running se_sm against the db either se_sm
or se_rcv crashes.

i am unable to access the db therefore to export the data

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 14:17

Message:
unfortunately i am unable to upload the appropriate data as it contains
customer data.

attached is 1 log 

the other from SM5020.log is 

SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: C:\Development\Tools\sedna\bin\se_sm.exe
vision_xchange

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 1 comment |
headers
SourceForge.net | 11 Jan 2010 21:05
Picon
Favicon

[ sedna-Bugs-2929830 ] Sedna Database Unable to start 3.1

Bugs item #2929830, was opened at 2010-01-11 17:10
Message generated for change (Settings changed) made by shcheklein
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&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: General
Group: Sedna (current)
>Status: Closed
>Resolution: Out of Date
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Ivan Shcheklein (shcheklein)
Summary: Sedna Database Unable to start 3.1

Initial Comment:
Hi, the attached DB is unable to start i have attached the logs entries and the exception is a standard
windows exception which initially crashed on se_sm and now crashes se_rcv.

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

>Comment By: Ivan Shcheklein (shcheklein)
Date: 2010-01-11 23:05

Message:
Richard, the one thing we can try in this situation is to restore your
data. However, in this case you have to share your database with us (we can
give you private access to the modis team's ftp and gurantee that database
will be used strictly for restoring). 

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 18:26

Message:
the last event log file is below. i cannot seem to attach more artifacts to
this call

INFO  11/01/2010 14:01:10 (GOV pid=4764) [gov.cpp:main:231]: SEDNA version
is 3.1.175
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gov_functions.cpp:log_out_system_information:79]: System: Windows 6.0.6002
(SP2.0) x86
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:129]: Layer address space start addr
= 0x22380000
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:130]: Layer address space boundary  
= 0x62380000
INFO  11/01/2010 14:01:10 (GOV pid=4764)
[gmm.cpp:create_global_memory_mapping:131]: Persistent heap start addr    
= 0x1bf80000
LOG   11/01/2010 14:01:10 (GOV pid=4764) [gov.cpp:main:240]: Process ping
server is ready
LOG   11/01/2010 14:01:10 (GOV pid=4764)
[listener.cpp:client_listener:67]: GOVERNOR is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:547]:
Event log is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:560]:
Ping client has been started
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020) [sm.cpp:main:566]:
VMM region values determined
SYS   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
SYS   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:830]: Event log in
recovery procedure is ready
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:834]:
init_transaction_ids_table done
LOG   11/01/2010 14:01:14 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:838]:
init_checkpoint_sems done
LOG   11/01/2010 14:01:15 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:844]: Logical log is
started
LOG   11/01/2010 14:01:16 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:859]: Persistent heap
has been recovered
LOG   11/01/2010 14:01:16 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:864]:
start_chekpoint_thread done
LOG   11/01/2010 14:01:22 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:886]: Buffer manager
is started
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[blk_mngmt.cpp:extend_tmp_file:619]: Temp file has been extended, size:
6400000
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:893]: Database has
been recovered by physical log successfully
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:898]: Checkpoints are
disabled
LOG   11/01/2010 14:03:09 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:902]:
lm_table.init_lock_table done
LOG   11/01/2010 14:03:10 (SM vision_xchange pid=5020)
[sm.cpp:recover_database_by_physical_and_logical_log:925]: Wu is
initialized
LOG   11/01/2010 14:03:10 (UNK vision_xchange pid=5640)
[rcv_db.cpp:TRmain:81]: recovery process by logical log started

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

Comment By: Ivan Shcheklein (shcheklein)
Date: 2010-01-11 18:08

Message:
Hi Richard,

Unfortunatelly, I don't know what we can do in this situation. Can you
send us event log files at least? Do you have backups of your data? Is this
issue reproducible?

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 17:18

Message:
se_gov starts correctly and when running se_sm against the db either se_sm
or se_rcv crashes.

i am unable to access the db therefore to export the data

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

Comment By: Richard Holt (userbob99)
Date: 2010-01-11 17:17

Message:
unfortunately i am unable to upload the appropriate data as it contains
customer data.

attached is 1 log 

the other from SM5020.log is 

SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: C:\Development\Tools\sedna\bin\se_sm.exe
vision_xchange

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2929830&group_id=129076

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 0 comments |
headers
Antoni Mylka | 12 Jan 2010 15:50
Picon

Temp file size problem

Hello,

I use the static linux build of sedna 3.2.91 on linux AMD64.

I have a 600MB XML file (dblp.xml taken from:
http://dblp.uni-trier.de/xml/). I create a 'dblp' database with all
default settings. Then I load the dblp.xml file to a 'dblp' collection.

It loads OK the sedata file is about 3G large.

Then I use the Java XQJ driver to execute a query. I use the
writeSequenceToSAX method on the result sequence. It is then processed
by my SAX handler. The query itself is attached below.

The query is executed correctly and returns a couple of hundred thousand
results (<resource> tags). The problem is that the temp file rises to
18GB until it fills the whole disk. Sedna writes some error in the log
about not being able to extend the temp file "cannot write the block" or
something similar. Then it breaks, all processes are killed (both the
trn and the sm ones). XQJ throws an exception.

Therefore some questions.

1. Is the 18GB temp file to be expected on such a query for such a
dataset? Maybe I should live with it and get a bigger disk.
2. If I limit the temp file size with the -tmp-file-max-size option will
sedna deal with a limited temp file and bring the query to an end or
will it simply break earlier when the temp file hits the limit?
3. What is the correct way to specify the -tmp-file-max-size option. I
tried it a couple of time and always get

se_cdb -tmp-file-init-size 100 -tmp-file-ext-portion 100
-tmp-file-max-size 200 dblp

Creating a data base (it can take a few minutes)...
SEDNA Message: ERROR SE1012
Temporary file has reached its maximum size.

The same with following settings (init-size,ext-portion,max-size)
(100,1000,1000)
(100,1500,100)
(100,100,1000)

Basically anything apart from 0 in the -tmp-file-max-size throws the
SE1012 error.

All kinds of comments welcome. I can provide any additional information
if needed.

Antoni Mylka
antoni.mylka@...

The quuery is meant to extract information from a given file in a given
collection.

for $x at $pos in
    collection('dblp')[compare(document-uri(.),'dblp.xml') = 0]/./dblp/*
return
<resource>
  <d1>{for $d1 in $x/data( <at> key) return <s>{$d1}</s>}</d1>
  <d2>{for $d2 in $x/title/text() return <s>{$d2}</s>}</d2>
  <d3>{for $d3 in $x/source/text() return <s>{$d3}</s>}</d3>
  <d4>{for $d4 in $x/year/text() return <s>{$d4}</s>}</d4>
  <d5>{for $d5 in $x/series/text() return <s>{$d5}</s>}</d5>
  <d6>{for $d6 in $x/volume/text() return <s>{$d6}</s>}</d6>
  <d7>{for $d7 in $x/number/text() return <s>{$d7}</s>}</d7>
  <d8>{for $d8 in $x/month/text() return <s>{$d8}</s>}</d8>
  <d9>{for $d9 in $x/pages/text() return <s>{$d9}</s>}</d9>
  <d10>{for $d10 in $x/url[starts-with(text(),'http://')]/text()
        return <s>{$d10}</s>}
  </d10>
  <d11>{for $d11 in $x/url[not(starts-with(text(),'http://'))]/text()
        return <s>{$d11}</s>}
  </d11>
  <d12>{for $d12 in $x/ee[starts-with(text(),'http://')]/text()
        return <s>{$d12}</s>}
  </d12>
  <d13>{for $d13 in $x/ee[not(starts-with(text(),'http://'))]/text()
        return <s>{$d13}</s>}
  </d13>
  <d14>{for $d14 in $x/publisher/text() return <s>{$d14}</s>}</d14>
  <d15>{for $d15 in $x/isbn/text() return <s>{$d15}</s>}</d15>
  <d16>{for $d16 in $x/crossref/text() return <s>{$d16}</s>}</d16>
  <d17>{for $d17 in $x/cite[not(starts-with(text(),'.'))]/text()
        return <s>{$d17}</s>}
  </d17>
  <d18>{for $d18 in $x/booktitle/text() return <s>{$d18}</s>}</d18>
  <d19>{for $d19 in $x/author/text() return <s>{$d19}</s>}</d19>
  <d20>{for $d20 in $x/editor/text() return <s>{$d20}</s>}</d20>
  <d21>{for $d21 in $x/titleSignature/text() return <s>{$d21}</s>}</d21>
  <d22>{for $d22 in $x/mdate/text() return <s>{$d22}</s>}</d22>
  <p>{$pos}</p>
</resource>

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
Permalink | Reply | 3 comments |

Gmane