Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 16Feb 16 I updated my live site this morning and it all went very smoothly ... except ...I now have my CPU's maxing out at "200%" and they have been like that for over two hours now.Are there some processes that are likely running on the backend that will finish up at some point or is this indicative of an error and I should roll back?There is nothing listed in the background processes, but looking at cPanel shows something is very busy.Running php 8.1.31These are the only upgrade_error entries in the system logs:16/02/25 11:14 AM upgrade_error Error (1060) Duplicate column name 'page_views': addColumnsAndIndexes ["cms_pages",[{"name":"page_me... 16/02/25 11:14 AM upgrade_error Error (1061) Duplicate key name 'transaction-lookup': addColumnsAndIndexes ["nexus_transactions",[],... 16/02/25 11:13 AM upgrade_error Error (1061) Duplicate key name 'widget_performance': addColumnsAndIndexes ["forums_forums",[{"name"... 16/02/25 11:13 AM upgrade_error Error (1091) Can't DROP COLUMN `mt_is_draft`; check that it exists: dropColumn ["core_message_topics... 16/02/25 11:13 AM upgrade_error Error (1050) Table 'core_rc_author_notification_text' already exists: createTable [{"name":"core_rc_... 16/02/25 11:13 AM upgrade_error Error (1060) Duplicate column name 'guest_name': addColumnsAndIndexes ["core_rc_reports",[{"name":"g... 16/02/25 11:12 AM upgrade_error Error (1050) Table 'core_contact_verify' already exists: createTable [{"name":"core_contact_verify",... 16/02/25 11:12 AM upgrade_error Error (1050) Table 'core_member_privacy_actions' already exists: createTable [{"name":"core_member_p... 16/02/25 11:09 AM upgrade_error Error (1091) Can't DROP COLUMN `set_marketplace_id`; check that it exists: dropColumn ["core_themes"... 16/02/25 11:09 AM upgrade_error Error (1091) Can't DROP COLUMN `app_marketplace_id`; check that it exists: dropColumn ["core_applica... 16/02/25 11:09 AM upgrade_error Error (1061) Duplicate key name 'type': addColumnsAndIndexes ["core_clubs",[],[{"type":"key","name":...
February 16Feb 16 Author The CPU only seems to max out when the forums application is accessed - using pages etc. doesn't cause a spike.Looking at MySQL also shows that it is coping OK: Edited February 16Feb 16 by Mick23
February 16Feb 16 Author Disabling advertisements seems to have fixed the issue - now I'll try to figure out why the ads would be slowing it down...
February 16Feb 16 Author I re-enabled all the advertisements I have (around 180 banners) and the problem returned immediately, so I've left them disabled for now.Is anyone else having this issue?
February 16Feb 16 8 hours ago, Mick23 said:Running php 8.1.31Now that you are using Ipb 5 I think it would be better to use php 8.2.8 hours ago, Mick23 said:I updated my live site this morning and it all went very smoothly ... except ...I now have my CPU's maxing out at "200%" and they have been like that for over two hours now.Are there some processes that are likely running on the backend that will finish up at some point or is this indicative of an error and I should roll back?There is nothing listed in the background processes, but looking at cPanel shows something is very busy.Running php 8.1.31These are the only upgrade_error entries in the system logs:16/02/25 11:14 AM upgrade_error Error (1060) Duplicate column name 'page_views': addColumnsAndIndexes ["cms_pages",[{"name":"page_me... 16/02/25 11:14 AM upgrade_error Error (1061) Duplicate key name 'transaction-lookup': addColumnsAndIndexes ["nexus_transactions",[],... 16/02/25 11:13 AM upgrade_error Error (1061) Duplicate key name 'widget_performance': addColumnsAndIndexes ["forums_forums",[{"name"... 16/02/25 11:13 AM upgrade_error Error (1091) Can't DROP COLUMN `mt_is_draft`; check that it exists: dropColumn ["core_message_topics... 16/02/25 11:13 AM upgrade_error Error (1050) Table 'core_rc_author_notification_text' already exists: createTable [{"name":"core_rc_... 16/02/25 11:13 AM upgrade_error Error (1060) Duplicate column name 'guest_name': addColumnsAndIndexes ["core_rc_reports",[{"name":"g... 16/02/25 11:12 AM upgrade_error Error (1050) Table 'core_contact_verify' already exists: createTable [{"name":"core_contact_verify",... 16/02/25 11:12 AM upgrade_error Error (1050) Table 'core_member_privacy_actions' already exists: createTable [{"name":"core_member_p... 16/02/25 11:09 AM upgrade_error Error (1091) Can't DROP COLUMN `set_marketplace_id`; check that it exists: dropColumn ["core_themes"... 16/02/25 11:09 AM upgrade_error Error (1091) Can't DROP COLUMN `app_marketplace_id`; check that it exists: dropColumn ["core_applica... 16/02/25 11:09 AM upgrade_error Error (1061) Duplicate key name 'type': addColumnsAndIndexes ["core_clubs",[],[{"type":"key","name":...Error (1060) Duplicate column name errors means that the query being run on upgrade return columns that have the same name. I haven't checked the actual code, but a fix or workaround if you will, is to use an alias for those columns so that no two columns in the query have the same name, but the assigned aliasesError (1091) Can't drop columns error usually happens when the MySQL searches for a foreign key constraint, but there is no constraint with such name. To troubleshoot this you can run the SHOW CREATE TABLE table_name; to make sure that the field/name mentioned in the error message is the name of foreign key constraint. And the table_name in the query must be replaced with the actual table that it's being mentioned in the error.Error (1050) Table already exists error is obvious imo. Edited February 16Feb 16 by Miss_B
February 16Feb 16 I've moved this to its own topic as it is something we want to assist you with.1 hour ago, Mick23 said:I re-enabled all the advertisements I have (around 180 banners) and the problem returned immediately, so I've left them disabled for now.Is anyone else having this issue?Do you have any Slow query logging running or any other logging to provide us the query being ran that is causing the issue here? While 180 advertisements is a lot at one time, that isn't a lot for MySQL query so we would need to perform further analysis here.
February 16Feb 16 Author 6 hours ago, Jim M said:I've moved this to its own topic as it is something we want to assist you with.Do you have any Slow query logging running or any other logging to provide us the query being ran that is causing the issue here? While 180 advertisements is a lot at one time, that isn't a lot for MySQL query so we would need to perform further analysis here.Thanks Jim. Just to be clear - it's only about 180 advertisements in the rotation - but only two of them show on a page at any one time.I'll see if I can generate a log this afternoon.
February 17Feb 17 Author Since I'm on shared hosting I don't have the super privileges to enabled slow query logging - I've logged a support ticket to see if they'll enable it for me.If I enable all the advertisements by way of a SQL query (ad_active=1) it takes about 3 hits on the homepage to shoot the CPU up to 100% - then eventually I get a 500 error due to too many connections.I was watching the MySQL monitor page and it didn't max anything out there even with the connection failures, yet my cPanel was showing the same maxed out CPU as before.ETA: They cannot enable slow query logging on a shared server. Can you share the query that v5 uses to get the banner advertisements? These are my settings:Then I'll run the query through the MySQL interface to see if the same problem occurs. Edited February 17Feb 17 by Mick23
February 17Feb 17 Author I can supply the a SQL dump to recreate the advertisements table if that would help in your testing.
February 17Feb 17 14 hours ago, Mick23 said:I can supply the a SQL dump to recreate the advertisements table if that would help in your testing.Can you send me a DM with that attached?Thanks!
February 17Feb 17 Author 4 hours ago, Stuart Silvester said:Can you send me a DM with that attached?Thanks!Have done so, thank you!11 hours ago, Marc said:Its the slow query log we would need to be able to adviseThey flat our refuse to turn it on because it's a shared server, unfortunately.
