[server-admins] Firebird Server pegging

[Troy A. Griffitts]

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.

DM Smith <dmsmith at crosswire.org> wrote:
>The bug tracker uses mysql. Has for quite a while.
>Is swordweb in the same tomcat server instance? Can we (you) put the
>forums in it's own instance?
>
>On Nov 20, 2013, at 3:19 PM, Troy A. Griffitts <scribe at crosswire.org>
>wrote:
>
>> 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.

-- 
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/6ab65053/attachment.html>