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,
Carlos Andrés Muñoz Bolaños
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
