Toni Font Posted November 6 Posted November 6 Hi, We are paying for a support plan and we don't understand how we can't send a ticket by email. We have a problem with the forum since yesterday. It is running very slow. A user tells us that when accessing shows the following error: 2S119/1 The server managers pass us the following data. Seguimos viendo que las siguientes queries están generando toda esta carga de cpu: | 10751 | nikonistasforo | 10.210.148.2:8822 | foro_ipboard | Execute | 0 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? | 544 | 0 | 0 | | 10752 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0 | 0 | 0 | | 10753 | nikonistasforo | 10.210.148.2:8826 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1435 | 0 | 0 | | 10754 | nikonistasforo | 10.210.148.2:8832 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1198 | 0 | 0 | | 10755 | nikonistasforo | 10.210.148.2:8834 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1198 | 0 | 0 | | 10756 | nikonistasforo | 10.210.148.2:8838 | foro_ipboard | Execute | 1 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? | 563 | 0 | 0 | | 10757 | nikonistasforo | 10.210.148.2:8840 | foro_ipboard | Execute | 1 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? Can you help us? Toni
Marc Posted November 6 Posted November 6 54 minutes ago, Toni Font said: We are paying for a support plan and we don't understand how we can't send a ticket by email. Im not sure what leads you to believe you arent getting support here? We are issuing support from the support forums, and if these need to be escalated, a ticket would be created for escalation In terms of performance, you would need your host to look into that. Some of the items being shown there are very simple queries. If its having issues with those, then its configuration on the sql side that needs to be addressed. In terms of the error mentioned, could you please let us know where this is being seen?
Toni Font Posted November 6 Author Posted November 6 Hi Marc, thank you very much for your quick response. It's not that I don't think I can get support. It's just that I can't request it privately by email, as I used to be able to. The error is shown to the user when logging in. The problem is not the origin of the queries. The problem, as you can see in the graph, is that they have increased by 600% without any action on our part. Before writing we have restarted the services, we have enough CPU and memory that have managed the load perfectly until yesterday. I don't think the solution is to increase CPU or memory. The forum tool is causing this increase in queries for some reason.
Marc Posted November 6 Posted November 6 13 minutes ago, Toni Font said: Hi Marc, thank you very much for your quick response. It's not that I don't think I can get support. It's just that I can't request it privately by email, as I used to be able to. We simply changed where we issue it, thats all. Nothing really changes in terms of the support you get 🙂 13 minutes ago, Toni Font said: The error is shown to the user when logging in. Please provide me with the name of the user in question 13 minutes ago, Toni Font said: The problem is not the origin of the queries. The problem, as you can see in the graph, is that they have increased by 600% without any action on our part. Before writing we have restarted the services, we have enough CPU and memory that have managed the load perfectly until yesterday. I don't think the solution is to increase CPU or memory. The forum tool is causing this increase in queries for some reason. Have you changed something on your forum since yesterday?
Toni Font Posted November 6 Author Posted November 6 1) OK, Well. 2) Rafillapm https://www.nikonistas.com/digital/foro/topic/506739-código-de-error-2s1191 3) No, nothing. On Monday we did a mass mailing. We usually do 1 or 2 a month.
Marc Posted November 6 Posted November 6 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
Marc Posted November 6 Posted November 6 The issues you are having there are certainly hosting, unfortunately. Even loading the initial login page for the admin CP (there is very little even being loaded at that point), it timed out a few times, and logging in is taking a very very long time. Again, there is very little actually even running in that location other than the menus Eventually got this, and this is certainly an issue with the mysql setup
Solution Toni Font Posted November 7 Author Solution Posted November 7 Thank you very much Marc. We have detected and blocked a malicious IP belonging to a Bot that was posing as a Chrome user and was saturating our database. We can close the thread. Thank you very much for your time and help. Stuart Silvester and Marc 2
Marc Posted November 7 Posted November 7 Thank you for letting us know, and glad to hear you found a resolution to the issue Toni Font 1
Recommended Posts