9 Jul 2010 22:40
Corrupted database
Hi all,
I'm trying to recover a database in Sedna 3.1.175 in a CentOS 4.3 system (Linux 2.6.18) .
A days ago, there was a power loss and when the server rebooted the Sedna service didn't started.
We start the service manually:
se_gov
se_sm sampelims
The first command executed correctly, but the second one, fails with a message:
Starting database recovery or hot-backup restoration...
Database recovery in progress...
SEDNA Message: FATAL ERROR
in process [11883] se_sm samplelims
System error. This error means system malfunction.
Details: Offset is out of range
The messages reported in the log files are these:
LOG 09/07/2010 15:01:45 (SM samplelims pid=11860) [sm.cpp:main:547]: Event log is ready
SYS 09/07/2010 15:01:45 (SM samplelims pid=11860) [usocket.c:uconnect_tcp:192]: connect (code = 111): Failed to obtain error message
SYS 09/07/2010 15:02:00 (GOV pid=4035) [usocket.c:uconnect_tcp:192]: connect (code = 111): Failed to obtain error message
INFO 09/07/2010 15:02:05 (GOV pid=11867) [gov.cpp:main:231]: SEDNA version is 3.1.175
INFO 09/07/2010 15:02:05 (GOV pid=11867) [gov_functions.cpp:log_out_system_information:81]: System: Linux 2.6.18-92.1.1.el5.028stab057.2 i686
INFO 09/07/2010 15:02:05 (GOV pid=11867) [gmm.cpp:create_global_memory_mapping:129]: Layer address space start addr = 0x60010000
INFO 09/07/2010 15:02:05 (GOV pid=11867) [gmm.cpp:create_global_memory_mapping:130]: Layer address space boundary = 0xa0010000
INFO 09/07/2010 15:02:05 (GOV pid=11867) [gmm.cpp:create_global_memory_mapping:131]: Persistent heap start addr = 0x59c10000
LOG 09/07/2010 15:02:05 (GOV pid=11867) [gov.cpp:main:240]: Process ping server is ready
LOG 09/07/2010 15:02:05 (GOV pid=11867) [listener.cpp:client_listener:67]: GOVERNOR is ready
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:main:547]: Event log is ready
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:main:560]: Ping client has been started
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:main:566]: VMM region values determined
SYS 09/07/2010 15:02:55 (SM samplelims pid=11878) [uprocess.c:uGetEnvironmentVariable:76]: getenv (code = 4): Failed to obtain error message
SYS 09/07/2010 15:02:55 (SM samplelims pid=11878) [uprocess.c:uGetEnvironmentVariable:76]: getenv (code = 4): Failed to obtain error message
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:830]: Event log in recovery procedure is ready
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:834]: init_transaction_ids_table done
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:838]: init_checkpoint_sems done
LOG 09/07/2010 15:02:55 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:844]: Logical log is started
LOG 09/07/2010 15:02:57 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:859]: Persistent heap has been recovered
LOG 09/07/2010 15:02:57 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:864]: start_chekpoint_thread done
LOG 09/07/2010 15:02:57 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:886]: Buffer manager is started
LOG 09/07/2010 15:03:05 (SM samplelims pid=11878) [blk_mngmt.cpp:extend_tmp_file:619]: Temp file has been extended, size: 6400000
LOG 09/07/2010 15:03:05 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:893]: Database has been recovered by physical log successfully
LOG 09/07/2010 15:03:05 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:898]: Checkpoints are disabled
LOG 09/07/2010 15:03:05 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:902]: lm_table.init_lock_table done
LOG 09/07/2010 15:03:05 (SM samplelims pid=11878) [sm.cpp:recover_database_by_physical_and_logical_log:925]: Wu is initialized
LOG 09/07/2010 15:03:05 (UNK samplelims pid=11884) [rcv_db.cpp:TRmain:81]: recovery process by logical log started
LOG 09/07/2010 15:03:15 (SM samplelims pid=11878) [blk_mngmt.cpp:extend_data_file:593]: Data file has been extended, size: 12c10000
LOG 09/07/2010 15:03:24 (SM samplelims pid=11878) [blk_mngmt.cpp:extend_data_file:593]: Data file has been extended, size: 19010000
FATAL 09/07/2010 15:03:28 (SM samplelims pid=11878) [bm_core.cpp:calculate_offset_and_file_handler:162]: Offset is out of range
There are messages before these, but are related to xquery execution before the crash, nothing anormal here.
Thanks for any help you can give me with this problem,
Regards,
------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________ Sedna-discussion mailing list Sedna-discussion@... https://lists.sourceforge.net/lists/listinfo/sedna-discussion
RSS Feed