greg_repolitic

Ok, a quick update on what's happened between when I posted above and now...

I've looked at the database, and now all the tables are correctly showing as Innodb (not MyISAM), which is good!

However, I'm still seeing VERY high load and memory usage.

So should I wait, or reboot. 

Is there anything else anyone would recommend I do at this point?

Thanks~!

I recently tried to do a Innodb conversion on a rather large table. I didn't' realize it was as large as it was - 1.5M rows.

I used phpmyadmin to execute the query... which I now realize was a mistake.

I got a timeout error after a min or so.

Now I'm seeing extremely high CPU, and mysql is consuming 50%+ CPU and 35% + memory.

What should I do? Just let this run out, or reboot and try again via the command line?

I've placed the community into maintenance mode for now.

Thanks!

If I go Nathan's solution, it looks like it removes clubs from the search results, etc.

That kind of is a disappointment. I wish there was a middle ground - were you can remove the clubs listing from the front page, but not remove them completely from the community...

I think I remember a way to do this, but I can't find it in the settings.

I no longer want the clubs to be shown on the forum index page.

How do I remove it?

OK, I doubled the memory to 512, and the tasks are now running properly. Thanks!

Here is a few entries of the apache error log:

[Thu Aug 11 15:06:32.633471 2022] [proxy_fcgi:error] [pid 1233:tid 140343752189696] [client 161.35.111.81:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function ignore_user_abort() in /home/server_stuf/webapps/repolitics/wp-cron.php:19\nStack trace:\n#0 {main}\n  thrown in /home/server_stuf/webapps/repolitics/wp-cron.php on line 19', referer: https://repolitics.com/wp-cron.php?doing_wp_cron=1660230392.5572190284729003906250
[Thu Aug 11 15:05:38.725002 2022] [proxy_fcgi:error] [pid 1838:tid 140343886472960] [client 64.98.124.17:0] AH01071: Got error 'PHP message: PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 1171456 bytes) in /home/server_stuf/webapps/repolitics/forums/system/Db/Select.php on line 549', referer: https://repolitics.com/forums/admin/?app=core&module=system&controller=background&do=process&csrfKey=877d06f4b917bb00dc970025d67a0c86&mr=8
[Thu Aug 11 15:05:35.490440 2022] [proxy_fcgi:error] [pid 1233:tid 140343802545920] [client 64.98.124.17:0] AH01071: Got error 'PHP message: PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 1171456 bytes) in /home/server_stuf/webapps/repolitics/forums/system/Db/Select.php on line 549', referer: https://repolitics.com/forums/admin/?app=core&module=system&controller=background&do=process&csrfKey=877d06f4b917bb00dc970025d67a0c86
[Thu Aug 11 15:05:26.139145 2022] [proxy_fcgi:error] [pid 1233:tid 140343743796992] [client 161.35.111.81:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function ignore_user_abort() in /home/server_stuf/webapps/repolitics/wp-cron.php:19\nStack trace:\n#0 {main}\n  thrown in /home/server_stuf/webapps/repolitics/wp-cron.php on line 19', referer: https://repolitics.com/wp-cron.php?doing_wp_cron=1660230326.0768899917602539062500
[Thu Aug 11 15:04:11.794651 2022] [proxy_fcgi:error] [pid 1232:tid 140343994025728] [client 161.35.111.81:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function ignore_user_abort() in /home/server_stuf/webapps/repolitics/wp-cron.php:19\nStack trace:\n#0 {main}\n  thrown in /home/server_stuf/webapps/repolitics/wp-cron.php on line 19', referer: https://repolitics.com/wp-cron.php?doing_wp_cron=1660230251.7440550327301025390625

I can't seem to get this background process to run.

It always get stuck, and even on the tasks page, it says it's never run.

The community is fully upgraded, I've rebooted the droplet, and when I manually try to start the Rebuilding Topics sitemap task, I get a blank screen.

Also, no error logs are present relating to sitemapgenerator

Any ideas?