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[[File: 1205 Lock wait timeout exceeded; try restarting>> transaction (db1.sparc.senecacollege.ca)>>>> On 2016mziaei-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_dbjpg]> 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>>>>>>>>>>>>>>>>>>
