[server-admins] Firebird Server pegging

[Troy A. Griffitts]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20131120/d48846ab/attachment.html>