<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1" /><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1" /></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">They should certainly be in separate instances, even running as different users. This is why I have a hard time guessing how this is happening. Let's leave stuff running. I will bring firebird down just before my presentations.<br><br><div class="gmail_quote">DM Smith <dmsmith@crosswire.org> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
The bug tracker uses mysql. Has for quite a while.<div>Is swordweb in the same tomcat server instance? Can we (you) put the forums in it's own instance?<br /><div><br /><div><div>On Nov 20, 2013, at 3:19 PM, Troy A. Griffitts <<a href="mailto:scribe@crosswire.org">scribe@crosswire.org</a>> wrote:</div><br class="Apple-interchange-newline" /><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">I have no idea what still uses firebird. I thought the bug tracker also used it. I still don't understand how turning on firebird causes swordweb to freeze.<br /><br /><div class="gmail_quote">DM Smith <<a href="mailto:dmsmith@crosswire.org">dmsmith@crosswire.org</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Do you want me to stop the fb server?<div><br /></div><div>What are the web apps that use it? (besides news and forums)</div><div><br /></div><div>News can't possibly be creating the problem. For all practical purposes, it is read-only.</div><div><br /></div><div>Can we make the forums read-only and put up a banner that it is locked down?</div><div><br /></div><div>-- DM</div><div><br /><div><br /><div><div>On Nov 20, 2013, at 2:01 PM, Troy A. Griffitts <<a href="mailto:scribe@crosswire.org">scribe@crosswire.org</a>> wrote:</div><br class="Apple-interchange-newline" /><blockquote type="cite">So does anyone have any idea which webapp is causing all other tomcat processes to cease to function via firebird. How can this happen? I suspected thread limits but have hiked those up and still have seen issues. I have a presentation tomorrow and don't want to put everything in jeopardy by starting the firebird server again. If we could bring up down one webapp at a time, maybe one every 2 days in an effort to try to find the culprit, maybe that would be a good path forward. We can start with leaving the forum software offline and see if we can stay up for 2 days with everything else. I can do this after tomorrow's presentation, but have another on Saturday and another on Sunday.<br /><br /><div class="gmail_quote">DM Smith <<a href="mailto:dmsmith@crosswire.org">dmsmith@crosswire.org</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">Chris,<br /><br />Though I have privs to do it, I'm not sure I can do it. I'll look and see if I can find the startup scripts. I maintain the mysql db on the box. Troy, who is traveling, does the firebird. If Troy would like to move the databases that are in firebird into mysql, I'd be happy to maintain them too.<br /><br />DM<br /><br />On Nov 19, 2013, at 6:31 AM, Chris Little <<a href="mailto:chrislit@crosswire.org">chrislit@crosswire.org</a>> wrote:<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">Any chance we could get the database back online?<br />It's giving the not unreasonable impression that the project is dead.<br /><br />--Chris<br /><br /><br />On 11/14/2013 1:26 AM, Chris Little wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;">On 11/12/2013 11:22 AM, Troy A. Griffitts wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">Dear Server Admins :)<br /><br />There is something happening on the server which pegs fbserver and<br />freezes our main website (and other sites oddly).<br /><br />I see this when our system on the NTVMR here in Münster stops pulling a<br />gadget from the swordweb web application which is on a totally unrelated<br />tomcat instance from anything to do with firebird.</blockquote><br />I've been watching this for a few months. Restarting Tomcat tends to fix<br />it rapidly, without disabling the news or forums.<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">When this happens, I can't even hit <a href="http://crosswire.org/">http://crosswire.org</a>. As soon as I<br />/etc/rc.d/init.d/firebird-superserver stop then everything comes back.</blockquote><br />Could you restart the database because the news, forums, and anything<br />else using the database is currently dead.<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">I have no idea how this can happen. I guess I've copied the webapp<br />information between all the instances and so they may each have a<br />firebird jdbc driver setup, but the swordweb server certainly isn't<br />using it for anything. Nor is the main site, to my knowledge-- Well,<br />unless we are displaying news on the main site now.</blockquote><br />My theory has been that it's caused by spammers on the forums and bad<br />forum software in general. I typically mass delete spammer accounts a<br />couple times a week, which seems to cure the issue temporarily. And if I<br />notice that the site is unresponsive, I restart Tomcat & follow up with<br />deleting spammer accounts.<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">Anyway, if you have any ideas, I'm open. I'm also open to switching<br />database servers to mysql if anyone wants to do the work.</blockquote><br />I still advocate what was discussed briefly on sword-devel:<br />switching to modern and maintained forum software, then making the<br />current mvnForums forums static by disabling posting & new logins.<br /><br />--Chris<br /><br /><br /><hr /><br />server-admins mailing list<br /><a href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br /><a href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a></blockquote><br /><br /><hr /><br />server-admins mailing list<br /><a href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br /><a href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a></blockquote><br /></pre><div style="margin-top: 2.5em; margin-bottom: 1em; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(0, 0, 0);"><br class="webkit-block-placeholder" /></div><pre class="k9mail"><hr /><br />server-admins mailing list<br /><a href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br /><a href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a><br /></pre></blockquote></div><br />
-- <br />
Sent from my Android device with K-9 Mail. Please excuse my brevity.</blockquote></div><br /></div></div></blockquote></div><br />
-- <br />
Sent from my Android device with K-9 Mail. Please excuse my brevity.</div></blockquote></div><br /></div></div></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>