Hi,
We have been using Sedna for quite some time now (since version 0.6 :-).
We are currently using Sedna 3.4.66 in our production server. So far,
we have three databases in production. Today, I got an error which put
Sedna down for a while before I noticed something was wrong. The
event.log shows the following (see red lines in particular):
LOG 15/12/2011 07:10:53 (TRN campus-visit pid=25739 sid=49 trid=47)
[tr_functions.cpp:on_user_statement_begin:103]: User query:
--- let $registrationRefs :=
index-scan('registration','1323709597187','EQ')
--- let $participant := for $pid in
$registrationRefs/participant-ref/@id return
index-scan('participant',$pid,'EQ')
--- let $interest := for $iid in
$registrationRefs/interest-ref/@id return index-scan('interest', $iid,
'EQ')
--- let $events := for $eid in
$registrationRefs/registered-event/@id return index-scan('event', $eid,
'EQ')
--- return ($registrationRefs, $participant, $interest, $events)
LOG 15/12/2011 07:10:53 (TRN campus-visit pid=25739 sid=49 trid=-1)
[tr_common_funcs.cpp:on_transaction_end:406]: Transaction has been
COMMITED
INFO 15/12/2011 07:10:53 (SM campus-visit pid=24210)
[bm_core.cpp:bm_log_out_io_statistics:521]: IO block reads:0, writes:0
LOG 15/12/2011 07:10:53 (TRN campus-visit pid=25739 sid=49 trid=-1)
[tr.cpp:TRmain:454]: Session is closed
SYS 15/12/2011 09:10:01 (GOV pid=24200) [ushm.c:uOpenShMem:71]:
shm_open (code = 24): Too many open files
FATAL 15/12/2011 09:10:01 (GOV pid=24200)
[hb_funcs.cpp:hbSendMsgToSm:64]: Failed to initialize SSMMsg service
(message service)
INFO 15/12/2011 10:33:48 (GOV pid=25909)
[gov_functions.cpp:log_out_system_information:87]: SEDNA version is
3.4.66 (32bit Release)
INFO 15/12/2011 10:33:48 (GOV pid=25909)
[gov_functions.cpp:log_out_system_information:95]: System: Linux
2.6.9-101.ELsmp x86_64
LOG 15/12/2011 10:33:48 (GOV pid=25909) [gov.cpp:main:239]: Process
ping server is ready
LOG 15/12/2011 10:33:48 (GOV pid=25909)
[listener.cpp:client_listener:70]: GOVERNOR is ready
Would you have an explanation as to why "Too many open files" would
occured?
Note that we just deployed (well since Oct 2011) a new application which
requires more xml document inserts (i.e. Load document). Not sure if
that could be relevant. This is the first time I see this error since
our deployment in October.
I noticed that you have version 3.5 released. I will probably upgrade
our devl and prod early in 2012 unless you believe that this problem
could go away if I upgrade right now.
Thank you,
Jocelyn Raymond
University of Alberta, Canada
PS:
[root@sedna data]# uname -a
Linux sedna.registrar.ualberta.ca 2.6.9-101.ELsmp #1 SMP Fri May 27
18:56:38 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
------------------------------------------------------------------------------
10 Tips for Better Server Consolidation
Server virtualization is being driven by many needs.
But none more important than the need to reduce IT complexity
while improving strategic productivity. Learn More!
http://www.accelacomm.com/jaw/sdnl/114/51507609/
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
