CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • How to get a list of old civicrm_task_action_temp tables?
Pages: [1]

Author Topic: How to get a list of old civicrm_task_action_temp tables?  (Read 1084 times)

torenware

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 4
How to get a list of old civicrm_task_action_temp tables?
May 18, 2013, 07:40:13 pm
Looking through a recent back up of a large CiviCRM 4.1 site I work on, I see about 124 tables with names like civicrm_task_action_temp_BIGFRIGGINGHASHSTRING.

The docs say it's safe to delete these things once they're used.  But is there a list of theme hanging out anywhere, so I know if a table is in use or is old?

Writing a script to delete _all_ of them is easy.  Making sure I don't clobber anybody doing really work looks a little harder.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: How to get a list of old civicrm_task_action_temp tables?
May 19, 2013, 12:57:00 am
torenware - the risk of at use is 'is someone right in the middle of doing a merge or a search + take action on results or import / export or whatever"

We normally kill these pretty happily but to be safe you could do it at a low-use time.

Note that in 4.2 + there is a scheduled job to ditch them. It might be backportable.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to get a list of old civicrm_task_action_temp tables?
May 20, 2013, 06:53:28 am

Note that those tables are also deleted during upgrades and we clean up older tables on a random basis when folks visit the admin sections

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

torenware

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 4
Re: How to get a list of old civicrm_task_action_temp tables?
May 21, 2013, 08:34:04 pm
Lobo --

How do you know which ones are "old"?  Is there some place to do a look-up?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to get a list of old civicrm_task_action_temp tables?
May 21, 2013, 08:59:20 pm

INFORMATION_SCHEMA.TABLES

has the create time information

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

torenware

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 4
Re: How to get a list of old civicrm_task_action_temp tables?
May 21, 2013, 10:22:36 pm
Hadn't thought of that.  Should work, though.

Thanks.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • How to get a list of old civicrm_task_action_temp tables?

This forum was archived on 2017-11-26.