[server-admins] Firebird Server pegging

[Troy A. Griffitts]

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.

DM Smith <dmsmith at crosswire.org> wrote:
>Do you want me to stop the fb server?
>
>What are the web apps that use it? (besides news and forums)
>
>News can't possibly be creating the problem. For all practical
>purposes, it is read-only.
>
>Can we make the forums read-only and put up a banner that it is locked
>down?
>
>-- DM
>
>
>On Nov 20, 2013, at 2:01 PM, Troy A. Griffitts <scribe at crosswire.org>
>wrote:
>
>> 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.
>> 
>> DM Smith <dmsmith at crosswire.org> wrote:
>> Chris,
>> 
>> 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.
>> 
>> DM
>> 
>> On Nov 19, 2013, at 6:31 AM, Chris Little <chrislit at crosswire.org>
>wrote:
>> 
>> Any chance we could get the database back online?
>> It's giving the not unreasonable impression that the project is dead.
>> 
>> --Chris
>> 
>> 
>> On 11/14/2013 1:26 AM, Chris Little wrote:
>> On 11/12/2013 11:22 AM, Troy A. Griffitts wrote:
>> Dear Server Admins :)
>> 
>> There is something happening on the server which pegs fbserver and
>> freezes our main website (and other sites oddly).
>> 
>> I see this when our system on the NTVMR here in Münster stops pulling
>a
>> gadget from the swordweb web application which is on a totally
>unrelated
>> tomcat instance from anything to do with firebird.
>> 
>> I've been watching this for a few months. Restarting Tomcat tends to
>fix
>> it rapidly, without disabling the news or forums.
>> 
>> When this happens, I can't even hit http://crosswire.org.  As soon as
>I
>> /etc/rc.d/init.d/firebird-superserver stop then everything comes
>back.
>> 
>> Could you restart the database because the news, forums, and anything
>> else using the database is currently dead.
>> 
>> I have no idea how this can happen.  I guess I've copied the webapp
>> information between all the instances and so they may each have a
>> firebird jdbc driver setup, but the swordweb server certainly isn't
>> using it for anything.  Nor is the main site, to my knowledge-- Well,
>> unless we are displaying news on the main site now.
>> 
>> My theory has been that it's caused by spammers on the forums and bad
>> forum software in general. I typically mass delete spammer accounts a
>> couple times a week, which seems to cure the issue temporarily. And
>if I
>> notice that the site is unresponsive, I restart Tomcat & follow up
>with
>> deleting spammer accounts.
>> 
>> Anyway, if you have any ideas, I'm open.  I'm also open to switching
>> database servers to mysql if anyone wants to do the work.
>> 
>> I still advocate what was discussed briefly on sword-devel:
>> switching to modern and maintained forum software, then making the
>> current mvnForums forums static by disabling posting & new logins.
>> 
>> --Chris
>> 
>> 
>> 
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>> 
>> 
>> 
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>> 
>> 
>> 
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>> 
>> -- 
>> Sent from my Android device with K-9 Mail. Please excuse my brevity.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20131120/d184bee7/attachment.html>