Hi,I've attached event log file (only part of it). On 21st of October the database worked fine. And the first transaction from the log file was successful (at 21/10/2010 16:22:18). Indeed I don't remember if I stopped the database with se_stop yesterday or it was terminated during the computer shutting down. It might be the cause of problems.
I couldn't find any fault folders. It might be connected with that error message that appeared in the terminal: "Cannot create data directory for soft fault logs". If you can advise how it can be solved too, I'll be grateful.
Best regards, Ivan Lagunov On 10/22/2010 09:03 PM, Ivan Shcheklein wrote:
Hi Ivan, Please send us the following information: 1. Complete event log (all event log files from SEDNA_HOME/data). 2. Fault folders (if any) - SEDNA_HOME/data/fault**** What caused initial database crash? Ivan Shcheklein, Sedna Team
LOG 21/10/2010 16:22:18 (TRN database pid=13369 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:103]: User query: --- collection("data")[Code/@id="TTDG12"] LOG 21/10/2010 16:22:18 (TRN database pid=13369 sid=49 trid=-1) [tr_common_funcs.cpp:on_transaction_end:406]: Transaction has been COMMITED ERROR 21/10/2010 16:26:12 (TRN database pid=13369 sid=49 trid=-1) [socket_client.cpp:read_msg:161]: (SE3007) Failed to receive a message. Details: Success INFO 21/10/2010 16:26:12 (SM database pid=11031) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:164, writes:211 LOG 21/10/2010 16:26:12 (TRN database pid=13369 sid=49 trid=-1) [tr.cpp:TRmain:514]: Session is closed LOG 21/10/2010 19:47:28 (SM database pid=11031) [trmgr.cpp:checkpoint_thread:149]: Starting checkpoint procedure INFO 22/10/2010 19:52:32 (GOV pid=7129) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 19:52:32 (GOV pid=7129) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 19:52:32 (GOV pid=7129) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 19:52:32 (GOV pid=7129) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 19:52:37 (SM database pid=7132) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 19:52:37 (SM database pid=7132) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 19:52:37 (SM database pid=7132) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 19:52:37 (SM database pid=7132) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 19:52:37 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 19:52:37 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... SYS 22/10/2010 19:52:37 (SM database pid=7132) [ummap.c:uMemLock:200]: mlock (code = 12): Cannot allocate memory WARN 22/10/2010 19:52:37 (SM database pid=7132) [bm_functions.cpp:_bm_init_buffer_pool:98]: Can't lock memory. It is not supported without root, RLIMIT_MEMLOCK exceeded or there are not enough system resources. LOG 22/10/2010 19:52:38 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 19:53:13 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 19:53:13 (SM database pid=7132) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 19:53:13 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 19:53:13 (SM database pid=7132) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 19:53:13 (RCV database pid=7152) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 19:53:13 (RCV database pid=7152) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 19:53:13 (SM database pid=7132) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 19:53:13 (RCV database pid=7152) [tr.cpp:TRmain:514]: Session is closed ERROR 22/10/2010 19:53:28 (SM database pid=7132) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log INFO 22/10/2010 19:53:59 (GOV pid=7196) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 19:53:59 (GOV pid=7196) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 19:53:59 (GOV pid=7196) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 19:53:59 (GOV pid=7196) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 19:54:14 (SM database pid=7204) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 19:54:14 (SM database pid=7204) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... SYS 22/10/2010 19:54:14 (SM database pid=7204) [ummap.c:uMemLock:200]: mlock (code = 12): Cannot allocate memory WARN 22/10/2010 19:54:14 (SM database pid=7204) [bm_functions.cpp:_bm_init_buffer_pool:98]: Can't lock memory. It is not supported without root, RLIMIT_MEMLOCK exceeded or there are not enough system resources. LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 19:54:14 (SM database pid=7204) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 19:54:14 (SM database pid=7204) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 19:54:14 (RCV database pid=7208) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 19:54:14 (RCV database pid=7208) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 19:54:14 (SM database pid=7204) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 19:54:14 (RCV database pid=7208) [tr.cpp:TRmain:514]: Session is closed LOG 22/10/2010 19:54:28 (SM database pid=7213) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 19:54:28 (SM database pid=7213) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 19:54:28 (SM database pid=7213) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 19:54:28 (SM database pid=7213) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 19:54:28 (SM database pid=7213) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready SYS 22/10/2010 19:54:28 (SM database pid=7213) [uevent.c:UEventCreate:240]: semget (code = 17): File exists ERROR 22/10/2010 19:54:28 (SM database pid=7213) [trmgr.cpp:init_checkpoint_sems:266]: (SE4010) Can't create semaphore Details: SNAPSHOT_CHECKPOINT_EVENT ERROR 22/10/2010 19:54:28 (SM database pid=7213) [sm.cpp:recover_database_by_physical_and_logical_log:896]: (SE4205) Failed to run SM in the background mode (use '-background-mode off' for detailed diagnostics) ERROR 22/10/2010 19:54:29 (SM database pid=7204) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log INFO 22/10/2010 19:57:49 (GOV pid=7226) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 19:57:49 (GOV pid=7226) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 19:57:49 (GOV pid=7226) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 19:57:49 (GOV pid=7226) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 19:57:53 (STOP pid=7229) [stop_server.cpp:main:92]: Request for GOVERNOR shutdown issued LOG 22/10/2010 19:57:53 (GOV pid=7226) [gov.cpp:main:275]: SEDNA event log is down INFO 22/10/2010 19:57:55 (GOV pid=7232) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 19:57:55 (GOV pid=7232) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 19:57:55 (GOV pid=7232) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 19:57:55 (GOV pid=7232) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 19:58:06 (SM database pid=7236) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 19:58:06 (SM database pid=7236) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... SYS 22/10/2010 19:58:06 (SM database pid=7236) [ummap.c:uMemLock:200]: mlock (code = 12): Cannot allocate memory WARN 22/10/2010 19:58:06 (SM database pid=7236) [bm_functions.cpp:_bm_init_buffer_pool:98]: Can't lock memory. It is not supported without root, RLIMIT_MEMLOCK exceeded or there are not enough system resources. LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 19:58:06 (SM database pid=7236) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 19:58:06 (SM database pid=7236) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 19:58:06 (RCV database pid=7240) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 19:58:06 (RCV database pid=7240) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 19:58:06 (SM database pid=7236) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 19:58:06 (RCV database pid=7240) [tr.cpp:TRmain:514]: Session is closed ERROR 22/10/2010 19:58:21 (SM database pid=7236) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log INFO 22/10/2010 19:58:31 (GOV pid=7245) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 19:58:31 (GOV pid=7245) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 19:58:31 (GOV pid=7245) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 19:58:31 (GOV pid=7245) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 19:59:08 (SM database pid=7248) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 19:59:08 (SM database pid=7248) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... SYS 22/10/2010 19:59:08 (SM database pid=7248) [ummap.c:uMemLock:200]: mlock (code = 12): Cannot allocate memory WARN 22/10/2010 19:59:08 (SM database pid=7248) [bm_functions.cpp:_bm_init_buffer_pool:98]: Can't lock memory. It is not supported without root, RLIMIT_MEMLOCK exceeded or there are not enough system resources. LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 19:59:08 (SM database pid=7248) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 19:59:08 (SM database pid=7248) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 19:59:08 (RCV database pid=7252) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 19:59:08 (RCV database pid=7252) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 19:59:08 (SM database pid=7248) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 19:59:08 (RCV database pid=7252) [tr.cpp:TRmain:514]: Session is closed ERROR 22/10/2010 19:59:23 (SM database pid=7248) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log INFO 22/10/2010 20:00:48 (GOV pid=7286) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 20:00:48 (GOV pid=7286) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 20:00:48 (GOV pid=7286) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 20:00:48 (GOV pid=7286) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 20:00:59 (SM database pid=7297) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 20:00:59 (SM database pid=7297) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 20:00:59 (SM database pid=7297) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 20:00:59 (SM database pid=7297) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 20:00:59 (RCV database pid=7301) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 20:00:59 (RCV database pid=7301) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 20:00:59 (SM database pid=7297) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 20:00:59 (RCV database pid=7301) [tr.cpp:TRmain:514]: Session is closed ERROR 22/10/2010 20:01:14 (SM database pid=7297) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log INFO 22/10/2010 20:49:49 (GOV pid=1980) [gov_functions.cpp:log_out_system_information:87]: SEDNA version is 3.4.66 (64bit Release) INFO 22/10/2010 20:49:49 (GOV pid=1980) [gov_functions.cpp:log_out_system_information:95]: System: Linux 2.6.32-24-generic x86_64 LOG 22/10/2010 20:49:49 (GOV pid=1980) [gov.cpp:main:239]: Process ping server is ready LOG 22/10/2010 20:49:49 (GOV pid=1980) [listener.cpp:client_listener:70]: GOVERNOR is ready LOG 22/10/2010 20:49:55 (SM database pid=1983) [sm.cpp:main:493]: Event log is ready LOG 22/10/2010 20:49:55 (SM database pid=1983) [sm.cpp:main:506]: Ping client has been started SYS 22/10/2010 20:49:55 (SM database pid=1983) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success SYS 22/10/2010 20:49:55 (SM database pid=1983) [uprocess.c:uGetEnvironmentVariable:101]: getenv (code = 0): Success LOG 22/10/2010 20:49:55 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:753]: Event log in recovery procedure is ready LOG 22/10/2010 20:49:55 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:763]: Starting database recovery or hot-backup restoration... SYS 22/10/2010 20:49:55 (SM database pid=1983) [ummap.c:uMemLock:200]: mlock (code = 12): Cannot allocate memory WARN 22/10/2010 20:49:55 (SM database pid=1983) [bm_functions.cpp:_bm_init_buffer_pool:98]: Can't lock memory. It is not supported without root, RLIMIT_MEMLOCK exceeded or there are not enough system resources. LOG 22/10/2010 20:49:55 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:803]: Buffer manager is started LOG 22/10/2010 20:50:16 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:810]: Database has been recovered by physical log successfully LOG 22/10/2010 20:50:16 (SM database pid=1983) [blk_mngmt.cpp:extend_tmp_file:629]: Temp file has been extended, size: 6400000 LOG 22/10/2010 20:50:16 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:822]: Checkpoints are disabled LOG 22/10/2010 20:50:16 (SM database pid=1983) [sm.cpp:recover_database_by_physical_and_logical_log:845]: Wu is initialized LOG 22/10/2010 20:50:16 (RCV database pid=1987) [tr.cpp:TRmain:182]: Session is ready ERROR 22/10/2010 20:50:16 (RCV database pid=1987) [vmm.cpp:vmm_remap:104]: (SE1035) Memory mapping error. INFO 22/10/2010 20:50:16 (SM database pid=1983) [bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:4, writes:0 LOG 22/10/2010 20:50:16 (RCV database pid=1987) [tr.cpp:TRmain:514]: Session is closed ERROR 22/10/2010 20:50:31 (SM database pid=1983) [trmgr.cpp:execute_recovery_by_logical_log_process:365]: (SE4501) Can't recover database by logical log
------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________ Sedna-discussion mailing list Sedna-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sedna-discussion