stop spam and sc editor plugin not working and down the whole website.

Question

this 2 plugin by q2apro. hello q2apro please solve this problem

when you will click on the plugin options of this 2 plugin the whole website stop working for 1 to 2 minitues.

Comments

Noticed this happening with more plugins - can see a lot of waiting sleep queries in MySQL.

---

I gradually removed the plugins, the site hangs when you click on the settings of any plug-in, even if they are very few.

---

Happening - but this wasnt the case even a couple of months back. I dont know what exactly is causing this. Actually I had more plugins previously than now.

---

i only found problem in this 2 plugin.all other third party plugin working well.if you have this 2 plugin all other plugin also stop working.even the whole plugin section of admin panel stop working.i findout this problem,basically this 2 plugin eating your all entry process of your server.

---

I'm not using these 2 particular plugins but still have the issue - clicking on option causes it - so problem should be with option_default of some plugin I feel.

---

no default plugin causes this.are you using any plugin of q2apro?

---

yes. Currently seeing this with q2apro-on-site-notification plugin.

---

is this plugin causes of your problem?

---

I have now deleted all the plugins, except for recapcha only then the site began to work normally.
This started the day before yesterday, something is not clear

---

I think so. It happens on Q2A 1.8.3. Are you using the same? (Not seeing on 1.8.0)

---

@niko  you dont need to delet all plugin.

---

I upgraded to 1.8.3 from 1.8.0 but there were problems on 1.8.0

---

Okay. Something is not clear. It is really hard to debug as site goes down.

---

What is this error?
PHP Question2Answer MySQL query error 2006: MySQL server has gone away - Query: SELECT qa_users.userid, passsalt, HEX(passcheck) AS passcheck, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS created, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS loggedin, loginip, UNIX_TIMESTAMP(written) AS written, writeip, BINARY avatarblobid AS avatarblobid, avatarwidth, avatarheight, points, wallposts FROM qa_users LEFT JOIN qa_userpoints ON qa_userpoints.userid=qa_users.userid WHERE qa_users.userid='1', referer https://          /admin/plugins

---

I think the problem is the plugins are raising a large number of MySQL requests so that the MySQL server goes down. In my MySQL process list I can see about 50 sleep queries and they keep on running till MySQL timeout setting. But the hard thing is this is not directly caused by any plugin code -- might be some bug from some setting.

Answer 1

I have noticed the same once in a while. Reported as bug: https://github.com/q2a/question2answer/issues/742

Not easy to fix since the error logs are empty :(

Comments

Most likely this will become a problem for sites that actively use AJAX and make several simultaneous requests. The easiest way to solve this problem is to call the session_write_close () function as soon as all the required changes to the session have been made, preferably closer to the beginning of the script. You can also use another session mechanism that supports concurrent access.

It follows: situations in which simultaneous access to a session is blocked always occurred with any hoster.

---

I connected an additional service  Redis on the hosting and it completely solved the problem

---

hello, q2a pro how to solve this problem?

---

Please see the GitHub thread. It is answered there.