Hi Ivan,
thanks for your quick reply. There is enough free disk space. The import
is implemented in Java using Sedna's XML:DB API, the relevant lines look
like:
xmlResource = (XMLResource) collection.createResource("test.xml",
XMLResource.RESOURCE_TYPE);
xmlResource.setContent(content);
collection.storeResource(xmlResource);
There are some fault-* directories, the content of the latest one,
fault-last, consists of three text files.
GOV644.log:
SEDNA soft fault message:
One of SEDNA processes is down
GOV command line arguments: se_gov.exe -background-mode off -port-number
5050 -ping-port-number 5151 -el-level 3 -alive-timeout 0
SM1364.log:
SEDNA soft fault message:
SEDNA GOVERNOR is down
SM command line arguments: se_sm.exe test
UNK1404.log:
SEDNA soft fault message:
lfs error: error in reading file
UNK command line arguments: "C:\...\bin/se_rcv" test 35546835700
There are also a lot of event-*.log files; I think the most meaningful
part of the latest one, event.log, is:
LOG 30/01/2009 22:08:46 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
--- LOAD STDIN "272056.xml" "all"
LOG 30/01/2009 22:08:46 (TRN test pid=1276 sid=48 trid=48)
[socket_client.cpp:socket_client::close_file_from_client:339]: Temporary
file has been deleted C:\...\bin\../data/test_files/tmp.148
LOG 30/01/2009 22:08:46 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
---
document("$documents")/documents/collecti...@name="all"]/docume...@name="272057.xml"]
LOG 30/01/2009 22:08:48 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
--- LOAD STDIN "272057.xml" "all"
LOG 30/01/2009 22:08:50 (TRN test pid=1276 sid=48 trid=48)
[socket_client.cpp:socket_client::close_file_from_client:339]: Temporary
file has been deleted C:\...\bin\../data/test_files/tmp.148
LOG 30/01/2009 22:08:50 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
---
document("$documents")/documents/collecti...@name="all"]/docume...@name="272058.xml"]
LOG 30/01/2009 22:08:53 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
--- LOAD STDIN "272058.xml" "all"
LOG 30/01/2009 22:08:54 (TRN test pid=1276 sid=48 trid=48)
[socket_client.cpp:socket_client::close_file_from_client:339]: Temporary
file has been deleted C:\...\bin\../data/test_files/tmp.148
LOG 30/01/2009 22:08:54 (TRN test pid=1276 sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:80]: User query:
---
document("$documents")/documents/collecti...@name="all"]/docume...@name="272059.xml"]
INFO 30/01/2009 23:24:44 (GOV pid=2180) [gov.cpp:main:239]: SEDNA
version is 3.1.126
INFO 30/01/2009 23:24:44 (GOV pid=2180)
[gov_functions.cpp:log_out_system_information:79]: System: Windows
5.2.3790 (SP2.0) x64
INFO 30/01/2009 23:24:44 (GOV pid=2180)
[gmm.cpp:create_global_memory_mapping:130]: Layer address space start
addr = 0x1c200000
INFO 30/01/2009 23:24:44 (GOV pid=2180)
[gmm.cpp:create_global_memory_mapping:131]: Layer address space
boundary = 0x5c200000
INFO 30/01/2009 23:24:44 (GOV pid=2180)
[gmm.cpp:create_global_memory_mapping:132]: Persistent heap start
addr = 0x15e00000
LOG 30/01/2009 23:24:44 (GOV pid=2180) [gov.cpp:main:248]: Process
ping server is ready
LOG 30/01/2009 23:24:44 (GOV pid=2180)
[listener.cpp:client_listener:67]: GOVERNOR is ready
LOG 30/01/2009 23:25:02 (SM test pid=340) [sm.cpp:main:538]: SM event
log is ready
LOG 30/01/2009 23:25:02 (SM test pid=340) [sm.cpp:main:540]: SM set
global names done
LOG 30/01/2009 23:25:02 (SM test pid=340) [sm.cpp:main:554]: SM ping
started
LOG 30/01/2009 23:25:02 (SM test pid=340) [sm.cpp:main:560]: SM vmm
region values determined
SYS 30/01/2009 23:25:02 (SM test pid=340)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
SYS 30/01/2009 23:25:02 (SM test pid=340)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:836]: SM event log
in recovery procedure is ready
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:840]: SM :
init_transaction_ids_table done
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:844]: SM :
init_checkpoint_sems done
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:850]: SM : logical
log is started
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:865]: SM :
persistent heap is recovered
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:870]: SM :
start_chekpoint_thread done
LOG 30/01/2009 23:25:02 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:892]: SM :
bm_startup done
LOG 30/01/2009 23:26:06 (SM test pid=340)
[blk_mngmt.cpp:extend_tmp_file:619]: Temp file has been extended, size:
6400000
LOG 30/01/2009 23:26:06 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:901]: SM : db
recovered by phys records successfully
LOG 30/01/2009 23:26:06 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:906]: SM :
checkpoints are disabled
LOG 30/01/2009 23:26:06 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:910]: SM :
lm_table.init_lock_table done
LOG 30/01/2009 23:26:06 (SM test pid=340)
[sm.cpp:recover_database_by_physical_and_logical_log:934]: SM : Wu is
initialized
LOG 30/01/2009 23:26:06 (UNK test pid=1552) [rcv_db.cpp:TRmain:88]:
recovery process by logical log started
LOG 30/01/2009 23:28:10 (SM test pid=340)
[blk_mngmt.cpp:extend_data_file:593]: Data file has been extended, size:
ab7c10000
SYS 30/01/2009 23:28:14 (UNK test pid=1552) [uhdd.c:uReadFile:184]:
ReadFile (code = 998): Invalid access to memory location.
FATAL 30/01/2009 23:28:14 (UNK test pid=1552)
[lfsStorage.cpp:_lfsProcessError:112]: lfs error: error in reading file
INFO 30/01/2009 23:29:14 (GOV pid=2112) [gov.cpp:main:239]: SEDNA
version is 3.1.126
INFO 30/01/2009 23:29:14 (GOV pid=2112)
[gov_functions.cpp:log_out_system_information:79]: System: Windows
5.2.3790 (SP2.0) x64
INFO 30/01/2009 23:29:14 (GOV pid=2112)
[gmm.cpp:create_global_memory_mapping:130]: Layer address space start
addr = 0x1c200000
INFO 30/01/2009 23:29:14 (GOV pid=2112)
[gmm.cpp:create_global_memory_mapping:131]: Layer address space
boundary = 0x5c200000
INFO 30/01/2009 23:29:14 (GOV pid=2112)
[gmm.cpp:create_global_memory_mapping:132]: Persistent heap start
addr = 0x15e00000
LOG 30/01/2009 23:29:14 (GOV pid=2112) [gov.cpp:main:248]: Process
ping server is ready
LOG 30/01/2009 23:29:14 (GOV pid=2112)
[listener.cpp:client_listener:67]: GOVERNOR is ready
LOG 30/01/2009 23:29:19 (SM test pid=2728) [sm.cpp:main:538]: SM event
log is ready
LOG 30/01/2009 23:29:19 (SM test pid=2728) [sm.cpp:main:540]: SM set
global names done
LOG 30/01/2009 23:29:19 (SM test pid=2728) [sm.cpp:main:554]: SM ping
started
LOG 30/01/2009 23:29:19 (SM test pid=2728) [sm.cpp:main:560]: SM vmm
region values determined
SYS 30/01/2009 23:29:19 (SM test pid=2728)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
SYS 30/01/2009 23:29:19 (SM test pid=2728)
[uprocess.c:uGetEnvironmentVariable:67]: GetEnvironmentVariable (code =
203): The system could not find the environment option that was entered.
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:836]: SM event log
in recovery procedure is ready
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:840]: SM :
init_transaction_ids_table done
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:844]: SM :
init_checkpoint_sems done
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:850]: SM : logical
log is started
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:865]: SM :
persistent heap is recovered
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:870]: SM :
start_chekpoint_thread done
LOG 30/01/2009 23:29:19 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:892]: SM :
bm_startup done
LOG 30/01/2009 23:30:28 (SM test pid=2728)
[blk_mngmt.cpp:extend_tmp_file:619]: Temp file has been extended, size:
6400000
LOG 30/01/2009 23:30:28 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:901]: SM : db
recovered by phys records successfully
LOG 30/01/2009 23:30:28 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:906]: SM :
checkpoints are disabled
LOG 30/01/2009 23:30:28 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:910]: SM :
lm_table.init_lock_table done
LOG 30/01/2009 23:30:28 (SM test pid=2728)
[sm.cpp:recover_database_by_physical_and_logical_log:934]: SM : Wu is
initialized
LOG 30/01/2009 23:30:28 (UNK test pid=440) [rcv_db.cpp:TRmain:88]:
recovery process by logical log started
SYS 30/01/2009 23:30:36 (UNK test pid=440) [uhdd.c:uReadFile:184]:
ReadFile (code = 998): Invalid access to memory location.
FATAL 30/01/2009 23:30:36 (UNK test pid=440)
[lfsStorage.cpp:_lfsProcessError:112]: lfs error: error in reading file
And sorry, I forgot: I'm using Sedna version 3.1.126 Windows binaries on
Windows Server 2003 R2 x64.
Regards,
Andreas
Ivan Shcheklein schrieb:
> Hi Andreas,
>
> First of all, please send us event log files (event****.log) and fault
> foldres (sedna/data).
>
> Did you use se_exp to import? If not, how do you import your files?
>
> Check also that you have enough space on your disk.
>
> Ivan Shcheklein,
> Sedna Team
>
> On Thu, Feb 5, 2009 at 2:23 PM, Andreas Meinl <[email protected]
> <mailto:[email protected]>> wrote:
>
> Hi all,
>
> during the import of some xml files there was a power blackout and
> since
> then I can't start my database any more:
>
> "se_gov.exe" started as expected...
>
> GOVERNOR has been started in the background mode
>
> ...but then "se_sm.exe test" failed with following messages:
>
> Starting database recovery or hot-backup restoration...
> Database recovery in progress...
> SEDNA Message: ERROR SE4501
> Can't recover database by logical log
>
> SEDNA Message: FATAL ERROR
> in process [1364] se_sm.exe test
> System error. This error means system malfunction.
> Details: SEDNA GOVERNOR is down
>
> It's a little bit annoying, as the import already took several days,
> which I don't want to lose; I have to import nearly half a million of
> xml files.
>
> Does anybody know how I could recover and start up my database? Any
> recommendations, approaches, ...?
>
> Thanks a lot!
>
> Andreas Meinl
>
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
