Prank

We're 7 full days down the track now and I can happily report that I've not had the same problem since switching to MySQL 8. Thanks all 🙌

Just throwing some potentially helpful info in here from my investigations and the posts from the Invision guys. The process list posted by @Idea-ahead looks identical to mine. They all relate to a single topic. The query individually is perfectly fine, runs fast. I think its just a snowball of queries (Similar to the affect of a DDoS but see below). But, its definitely not a DDoS attack. I don't see an increase in PHP processes and I'm behind Cloudflare with fairly strong security like browser check etc. After the Invision responses and some of my own research I decided to follow the recommendations and switch to MySQL 8 from Maria 10.5 yesterday. I'm at 20h uptime now which is promising but early days. I'll report back after another day or two to see how it's looking.

I'd appreciate you posting what you do here as we were on Maria 10.3 and now 10.5. I'm weighing up options.

Hi Matt, thanks for the reply. I appreciate the info you've added. I think Marc telling me straight up that I was being unrealistic and that my 1100 page topic was "very very much outside the normal use of the software" was a clear fob attempt and was totally incorrect, as you stated you have clients with 25k pages. It wasn't helpful at all. On the flip side I think that you adding this extra info has been very helpful. If you say that there was no change between the two releases that could cause this problem then I'll have to accept that and look into other options. Thanks again.

I always keep it updated, within days of an update being released so it would have been the previous point release. As I said above, this is the only change I've made. The server is hefty, Maria is very well configured and invision has never had a problem with these topics until the update. I run nothing else on the server. I'd just appreciate not being fobbed off here. To be clear - I don't know if these queries come from viewing the topic or something else. Maybe you guys could shed soe light on this? I'm happy to dig into code, I just haven't had a chance.

Hi Matt, I don't think this is a good enough response when it was fine with the previous version. If you do refuse to accept that something has changed maybe you can advise if its possible to roll back to the previous version? Also, note that the explain is clean, but its running *so* many queries that it bogs down. Individually the queries are fine, but not at the numbers they come in at.

Thanks, very much appreciated.

Seriously? Thats your response? As with @Idea-ahead the only change on my server is that I'm now running 4.7.19. Invision on my server has not had *any* problems with these topics for many years. Again, let me reiterate - the ONLY change is that I updated Invision. Nothing else runs on this server, it is entirely dedicated to Invision.

The explain; > EXPLAIN SELECT forums_posts.*, author.*, author_pfields.* FROM `ibf_forums_posts` AS `forums_posts` LEFT JOIN `ibf_core_members` AS `author` ON author.member_id = forums_posts.author_id LEFT JOIN `ibf_core_pfields_content` AS `author_pfields` ON author_pfields.member_id=author.member_id WHERE forums_posts.topic_id=310874 AND (forums_posts.queued IN(0,2)) ORDER BY post_date asc LIMIT 0,20; +------+-------------+----------------+--------+----------------------------+-----------+---------+-----------------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+----------------+--------+----------------------------+-----------+---------+-----------------------------------+------+-------------+ | 1 | SIMPLE | forums_posts | index | queued,topic_id,first_post | post_date | 5 | NULL | 3048 | Using where | | 1 | SIMPLE | author | eq_ref | PRIMARY,mgroup | PRIMARY | 3 | skycom_sau.forums_posts.author_id | 1 | | | 1 | SIMPLE | author_pfields | eq_ref | PRIMARY | PRIMARY | 3 | skycom_sau.author.member_id | 1 | Using where | +------+-------------+----------------+--------+----------------------------+-----------+---------+-----------------------------------+------+-------------+ 3 rows in set (0.001 sec)

I'm down again with a different topic ID. Another big topic with 1100+ pages. I'll log a support ticket. Oh, looks like creating tickets through the admincp is no longer a thing? Either way, I restarted mysql, again, to bring things back up.

I am also getting issues with these queries. SELECT forums_posts.*, author.*, author_pfields.* FROM `ibf_forums_posts` AS `forums_posts` LEFT JOIN `ibf_core_members` AS `author` ON author.member_id = forums_posts.author_id LEFT JOIN `ibf_core_pfields_content` AS `author_pfields` ON author_pfields.member_id=author.member_id WHERE forums_posts.topic_id=379859 AND (forums_posts.queued IN(0,2)) ORDER BY post_date asc LIMIT 0,20 I just searched here to see if others are having it. I get thousands of them running over and over. It eventually will bring the site down at random times through the day. MariaDB [(none)]> show processlist; +--------+--------+-----------+------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+--------+-----------+------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+ | 639673 | skycom | localhost | NULL | Query | 0 | Init | show processlist | 0.000 | | 639899 | skycom | localhost |[obfiscated] | Sleep | 0 | | NULL | 0.000 | | 639903 | skycom | localhost | [obfiscated] | Execute | 111 | Sending data | /*[obfiscated]::IPS\Content\_Item::_comments:31*/ SELECT forums_posts.*, author.*, author_pfie | 0.000 | | 639911 | skycom | localhost | [obfiscated] | Execute | 65 | Sending data | /*[obfiscated]::IPS\Content\_Item::_comments:31*/ SELECT forums_posts.*, author.*, author_pfie | 0.000 | | 639915 | skycom | localhost | [obfiscated] | Execute | 65 | Sending data | /*[obfiscated]::IPS\Content\_Item::_comments:31*/ SELECT forums_posts.*, author.*, author_pfie | 0.000 | | 639917 | skycom | localhost | [obfiscated] | Execute | 61 | Sending data | /*[obfiscated]::IPS\Content\_Item::_comments:31*/ SELECT forums_posts.*, author.*, author_pfie | 0.000 | | 639918 | skycom | localhost | [obfiscated] | Execute | 61 | Sending data | /*[obfiscated]::IPS\Content\_Item::_comments:31*/ SELECT forums_posts.*, author.*, author_pfie | 0.000 | <snip> The site will stay down for 30 - 40 mins unless I restart php and mysql. It's down right now as I speak with load at 40. I see anywhere between 40 and 100 of those queries running. The topic from the query above is closed, since 2015 and has 4200 pages.

Patch worked perfectly for me. Thanks.

Thanks guys.

Hi Guys, We're getting lots of spammers registering and some of them are taking to PM's to spam discreetly. What I'd like to do is restrict new users for 15 posts or so. Starting with just not being able to PM during this period. This used to be a setting but now it seems that I need to make possibly a 'New Member' group to put new registrations in, which is restricted, and then auto promote them to the Members group after 15 posts. Is this correct? Is there anything I should know before I do this? Thanks, Christian

Thanks Marc