@@ Line 4: / Line 4: @@
 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
->>
->>
->>
->>
->>
->>
->>
->>
->>

Difference between revisions of "User:Mziaei"

Revision as of 13:05, 12 September 2016

Navigation menu

Search