[server-admins] Firebird Server pegging

[DM Smith]

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20131120/8bae22a2/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4145 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20131120/8bae22a2/attachment-0001.p7s>