search

progressivetech / net.ourpowerbase.sumfields

The Summary Fields extension creates read-only custom data fields that extend Contact and are automatically populated with up-to-date totals such as total lifetime contributions, last contribution amount, last attended event, etc.
Other
8 stars 29 forks source link

500 errors with large database #94

Open discwoods opened 2 years ago

discwoods commented 2 years ago

Using sumfields as CiviCRM extension on Wordpress.

I enabled all checkboxes on settings page and applied the changes. The settings page returned a 500 error because our database is too large and the request timed out. I tried to disable and uninstall the extension, was met both times with a 500 error message. Visually, the extension appeared to successfully disable and uninstall.

After uninstalling, I get a database lock error from several different CiviCRM features. Is there something more I need to do to fully uninstall the plugin? Should I reinstall it, uncheck all of the settings and save, then uninstall?

jmcclelland commented 2 years ago

Sorry for the mess. It's possible that the query is still running on you mysql database and you'll need to kill that query (or let it time out on it's own).

From a mysql prompt, you can run:

   SHOW PROCESSLIST;

To get a list of running queries. And

    KIILL <PID>

To kill a particular query.