[server-admins] Firebird Server pegging

[Chris Little]

The forums appear to work again. I'm fairly confident that the spammers 
are wreaking havoc with the forums and are the ultimate cause of the db 
pegging.

I deleted all the accounts that hadn't yet confirmed their email 
addresses. It amounted to ~3600 accounts. That's more than the ~3300 
accounts created by actual people and/or spammers who bothered to 
confirm their email addresses. And those 3600 accounts were created 
within just the 7 days prior to the forums going down.

--Chris

On 11/20/2013 11:01 AM, DM Smith wrote:
> OK. I found the startup script. As you figured out, the fb server was down. It is now up. You may need to bounce the forums for it to see it. They still give a connection pool complaint.
>
> On Nov 20, 2013, at 1:54 PM, 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
>
>
>
> _______________________________________________
> server-admins mailing list
> server-admins at crosswire.org
> http://www.crosswire.org/mailman/listinfo/server-admins
>