Difference between revisions of "User:Mziaei"
Line 4: | Line 4: | ||
asdf | 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 | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> | ||
+ | >> |
Revision as of 14:05, 12 September 2016
Testing!!!!!
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 >> >> >> >> >> >> >> >> >>