Menu
▾
▴
Re: [ebxmlms-general] Database reconnect problem
|
From: David RR W. \(XML\) <da...@dr...> - 2006-09-22 13:53:09
|
<div>Ashique,</div>
<div> </div>
<div>OK - that's what I thought too.</div>
<div> </div>
<div>Clearly that failed send is still in the local db - and they need to
flush that first.</div>
<div> </div>
<div>Would be nice to have a restart function built-in to Hermes - we
should suggest that to Patrick as an upgrade feature...</div>
<div> </div>
<div>DW<BR></div>
<DIV id=wmMessageComp name="wmMessageComp"><BR><BR>
<BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT:
blue 2px solid">-------- Original Message --------<BR>Subject: Re:
[ebxmlms-general] Database reconnect problem<BR>From: "Tanveer, Ashique
(NIH/OD) [C]" <tan...@od...><BR>Date: Fri, September 22,
2006 9:31 am<BR>To: "General discussions"
<ebx...@li...><BR>Cc: "Webber, David
(NIH/OD) [C]" <we...@od...><BR><BR>
<STYLE>
#wmMessageComp v\:* {behavior:url(#default#VML);}
#wmMessageComp o\:* {behavior:url(#default#VML);}
#wmMessageComp w\:* {behavior:url(#default#VML);}
#wmMessageComp .shape {behavior:url(#default#VML);}
</STYLE>
<o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType>
<STYLE>
#wmMessageComp st1\:* {behavior:url(#default#ieooui) }
</STYLE>
<STYLE>
#wmMessageComp /* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
#wmMessageComp /* Style Definitions */
p.MsoNormal, #wmMessageComp li.MsoNormal, #wmMessageComp div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
#wmMessageComp a:link, #wmMessageComp span.MsoHyperlink
{color:blue;
text-decoration:underline;}
#wmMessageComp a:visited, #wmMessageComp span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
#wmMessageComp span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
#wmMessageComp @page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
#wmMessageComp div.Section1
{page:Section1;}
</STYLE>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Try cleaning
out DerbyDB database, ebxmlms repository and restarting Hermes.
We have been also restarting hermes after cleaning up those
transient folders.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">That
worked.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY:
Arial">--------------------------------------------------------------------------</SPAN></FONT><FONT
color=blue><SPAN style="COLOR: blue"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Ashique
Tanveer<BR>Contractor, eRA, National Institute of Health<BR>Booz |
Allen | <st1:City
w:st="on">Hamilton</st1:City>
<BR>--------------------------------------------------------------------------</SPAN></FONT><FONT
color=blue><SPAN style="COLOR: blue"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">(301) 451-1772
(Office)<BR>(240) 354-8072 (<st1:City w:st="on"><st1:place
w:st="on">Mobile</st1:place></st1:City>)<BR>(925) 889-3635 (Fax)<BR><A
href="mailto:tan...@ba...">tan...@ba...</A>, <A
href="mailto:tan...@od...">tan...@od...</A><BR>--------------------------------------------------------------------------</SPAN></FONT><o:p></o:p></P></DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP:
medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: blue
1.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: medium none">
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT:
bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
David RR Webber (XML) [mailto:da...@dr...] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, September 22, 2006
8:36 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> General
discussions<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
Re: [ebxmlms-general] Database reconnect
problem</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Andreas,<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Our stock "workaround" for any startup problems
with Hermes is to flush the local database tables that Hermes uses for
its internal tracking and then restart. We're using DerbyDB for
those tables - and then Oracle for our main processing - so it makes it
easy to flush those DerbyDB tables by just deleting the local
directory.<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">DW<o:p></o:p></SPAN></FONT></P></DIV>
<DIV id=wmMessageComp name="wmMessageComp">
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in;
BORDER-TOP: medium none; MARGIN-TOP: 5pt; PADDING-LEFT: 5pt;
MARGIN-BOTTOM: 5pt; PADDING-BOTTOM: 0in; MARGIN-LEFT: 5.45pt;
BORDER-LEFT: blue 1.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: medium
none">
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New
Roman" size=3><SPAN style="FONT-SIZE:
12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">-------- Original Message --------<BR>Subject:
[ebxmlms-general] Database reconnect problem<BR>From: Andreas
Hausleitner <and...@en...><BR>Date: Fri,
September 22, 2006 4:29 am<BR>To: General discussions
<ebx...@li...><BR><BR>Hello,<BR>we
encountered a problem with hermes when database connection is
lost, <BR>e.g. database shutdown or network problems.<BR>Hermes
reconnects fine if the database is available only if no clients <BR>try
to send a message in between to the msh.<BR><BR>If the database is not
available and a client tries to send a message it <BR>will fail with
the
error:<BR>hk.hku.cecid.phoenix.message.handler.RequestException:<BR>Fail
to send EbxmlMessage to MessageServiceHandler:<BR> HTTP response
code = 409<BR> HTTP response message = [10008] HTTP POST request
failed - [10306] <BR>Cannot create DB connection<BR><BR>If the database
is available again later on hermes cannot reconnect to <BR>the database.
We got this error messages periodically:<BR>2006-09-22 10:22:30,181
ERROR [thread-pool-47]: [10303] Cannot get DB <BR>connection - give up
after 20000 milliseconds<BR><BR>Has anyone found a workaround for this
problem?<BR><BR>Thanks,<BR>Andreas<BR><BR>--
<BR>------------------------------------------<BR>Andreas Hausleitner,
DI<BR>Software Developement<BR><BR>enerbility software
gmbh<BR>Mariahilferstrasse 113/43<BR>A-1070 Wien<BR><BR>email:
and...@en...<BR>http:
www.enerbility.com<BR>------------------------------------------<BR><BR><BR>-------------------------------------------------------------------------<BR>Take
Surveys. Earn Cash. Influence the Future of IT<BR>Join SourceForge.net's
Techsay panel and you'll get the chance to share your<BR>opinions on IT
& business topics through brief surveys -- and earn
cash<BR>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV<BR>_______________________________________________<BR>ebxmlms-general
mailing
list<BR>ebx...@li...<BR>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
<o:p></o:p></SPAN></FONT></P></BLOCKQUOTE></DIV></DIV></DIV>
<HR>
-------------------------------------------------------------------------<BR>Take
Surveys. Earn Cash. Influence the Future of IT<BR>Join SourceForge.net's
Techsay panel and you'll get the chance to share your<BR>opinions on IT
& business topics through brief surveys -- and earn
cash<BR>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
<HR>
_______________________________________________<BR>ebxmlms-general
mailing
list<BR>ebx...@li...<BR>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
</BLOCKQUOTE></DIV>
|
