5
edits
Changes
no edit summary
asdf
Hi Merdad
It's really bad. Can you check it out please?
Thanks,
Andrew
On 12/09/16 12:00, Andrew Smith wrote:
> Hi Mehrdad
>
> I think the DNS might still be trying to load balance, people are
> unable to connect intermittently (I can see it too).
>
> Andrew
>
> On 12/09/16 07:40, Mehrdad Ziaei wrote:
>> Hi,
>>
>>
>>
>> When this wiki was running on Zenit, it was hosted by 4 web servers,
>> so I don’t think that by itself is an issue.
>>
>>
>>
>> However, I stopped one of the webservers just to see if the error
>> happens again or not.
>>
>> Also on the wiki on Zenit we had cache enabled as well, but is not in
>> the new one, could you please look into this as well.
>>
>>
>>
>> I will look into the database server as well.
>>
>>
>>
>> Thanks,
>>
>> Mehrdad
>>
>>
>>
>> *From:*Andrew Smith
>> *Sent:* September 11, 2016 9:11 PM
>> *To:* Mehrdad Ziaei <mehrdad.ziaei@senecacollege.ca>
>> *Subject:* Re: Cdot wiki database errors
>>
>>
>>
>> Hi Mehrdad
>>
>> I am gettng reports from other people who are getting the same error.
>>
>> Andrew
>>
>> On 10/09/16 15:23, Andrew Smith wrote:
>>
>> Hi Mehrdad
>>
>> I just had an idea. Could it be related to the fact that there are
>> two web servers? Maybe some weird race condition happens and they
>> end up blocking each other?
>>
>> Is it difficult to turn off the second one for a few days to see
>> what happens?
>>
>> Cheers,
>>
>> Andrew
>>
>> On 2016-09-10 02:54 PM, Andrew Smith wrote:
>>
>> Hi Mehrdad
>>
>> Well that didn't take long. Here is another, when I try to
>> create a new account:
>>
>> A database query error has occurred. This may indicate a bug in
>> the software.
>>
>> * Query:
>>
>> INSERT IGNORE INTO `mw_user`
>> (user_id,user_name,user_password,user_newpassword,user_email,user_email_authenticated,user_real_name,user_token,user_registration,user_editcount,user_touched)
>> VALUES (NULL,'Asmith15','','','asmith15@myseneca.ca
>> <mailto:asmith15@myseneca.ca>',NULL,'','46e05f814d6feba8f3933b7b2759b
>> 67f','20160910184921','0','20160910184926')
>>
>> * Function: |User::addToDatabase|
>> * Error: 1205 Lock wait timeout exceeded; try restarting
>> transaction (db1.sparc.senecacollege.ca)
>>
>> On 2016-09-10 02:42 PM, Andrew Smith wrote:
>>
>> Hi Mehrdad
>>
>> The test query now succeeds when I run it in a console. It
>> was failing yesterday just before I sent the email.
>>
>> At the same time I was not able to change my password via
>> the wiki interface, because of the same error.
>>
>> Perhaps it had something to do with the semester startup
>> load on the server. Let's leave this issue open for a few
>> days to make sure it doesn't reoccur.
>>
>> If it does - is there some information that I could collect
>> to help debug the problem?
>>
>> Yours,
>>
>> Andrew
>>
>> On 2016-09-10 12:45 PM, Mehrdad Ziaei wrote:
>>
>> Hi,
>>
>>
>>
>> I logged it and edited a page and also change my
>> preferences and didn't
>> get the error.
>>
>>
>>
>> Do you get error on specific action?
>>
>> Does it happen during specific time of day or any random
>> time during the
>> day?
>>
>>
>>
>> Mehrdad
>>
>> ---------------------------------------------------------------------
>> ---
>>
>> *From:* Andrew Smith
>> *Sent:* September 9, 2016 8:22:21 PM
>> *To:* Seneca Service Desk
>> *Cc:* Mehrdad Ziaei
>> *Subject:* Re: Cdot wiki database errors
>>
>> Forgot to CC the service desk.
>>
>> On 09/09/16 20:20, Andrew Smith wrote:
>>
>> Hi Mehrdad
>>
>> I'm getting timeouts on the wiki that all seem to be
>> related to the
>> user table(s). I got one query in debug logs and
>> tried it on the
>> command-line, here's the result:
>>
>> MySQL [cdotwiki_db]> UPDATE `mw_user` SET
>> user_newpassword =
>> ':pbkdf2:sha256:10000:128:xm5XL0Oc/fEdSdXOJg4hjw==:B5bIhG14qHu5lCDQxI
>> l+q8INMY4St5SnW8BjAr8V+Cgz0Wst1vzcu0mYfhXKfuH12oaaRa4FTcHkpN3l/oAsJ1u
>> 1Zx90n9H5JkFHiM1A4bSPmq+io3TWBXEotxTAbz0Lm6XAju/4kfaBJ1JKMzA+2KJNVf37
>> QmOMa8pqtThIcPc=',user_newpass_time
>>
>> = '20160910001118' WHERE user_name = 'Andrew';
>> ERROR 1205 (HY000): Lock wait timeout exceeded; try
>> restarting
>> transaction
>>
>> Which is the same error I'm getting on the wiki.
>>
>> I get the same with a simpler, test query:
>>
>> MySQL [cdotwiki_db]> UPDATE `mw_user` SET
>> user_editcount = '1710'
>> WHERE user_name = 'Andrew';
>> ERROR 1205 (HY000): Lock wait timeout exceeded; try
>> restarting
>> transaction
>>
>> I can only think that maybe SELinux is causing it.
>> Maybe you can see
>> something in other logs (there's nothing in the web
>> server logs) If
>> you can't think of a better reason - can you please
>> disable SELinux?
>>
>> Thanks,
>>
>> Andrew
>>
>>
>>
>>
>>
>>
>>
>>
>>
