Hi Andreas,
Let me ask you a few questions.
1) Do you use auto-commit while loading documents, load them in one
transaction or use explicit commits?
2) Could you send us the database (archived cfg, data folders) or put it on
some ftp?
Best regards,
Alexander Kalinin
Sedna Team
On Thu, Feb 5, 2009 at 3:08 PM, Andreas Meinl <[email protected]> wrote:
> 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
>
------------------------------------------------------------------------------
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
