Revision history  [back]

Hi,

As listed here: http://askbot.org/en/question/2673/is-there-a-way-to-purge-unused-tags-from-the-db/ , I tried to run the tag commands. I'm not sure if it works. It seems to error out:

[root@ask01.stg config]# python manage.py delete_unused_tags
/usr/lib/python2.6/site-packages/django/db/__init__.py:19: DeprecationWarning: settings.DATABASE_* is deprecated; use settings.DATABASES instead.
  DeprecationWarning
/usr/lib/python2.6/site-packages/django/db/__init__.py:60: DeprecationWarning: Short names for ENGINE in database configurations are deprecated. Prepend default.ENGINE with 'django.db.backends.'
  DeprecationWarning
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently
see outdated content on your site.

Searching for unused tags:
------------------------------------------------------------ 100.00%
Did not find any.
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_manager(settings)
  File "/usr/lib/python2.6/site-packages/django/core/management/__init__.py", line 438, in execute_manager
    utility.execute()
  File "/usr/lib/python2.6/site-packages/django/core/management/__init__.py", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/python2.6/site-packages/django/core/management/base.py", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/python2.6/site-packages/django/core/management/base.py", line 220, in execute
    output = self.handle(*args, **options)
  File "/usr/lib/python2.6/site-packages/django/core/management/base.py", line 351, in handle
    return self.handle_noargs(**options)
  File "/usr/lib/python2.6/site-packages/django/db/transaction.py", line 222, in inner
    self.__exit__(None, None, None)
  File "/usr/lib/python2.6/site-packages/django/db/transaction.py", line 207, in __exit__
    self.exiting(exc_value, self.using)
  File "/usr/lib/python2.6/site-packages/django/db/transaction.py", line 302, in exiting
    leave_transaction_management(using=using)
  File "/usr/lib/python2.6/site-packages/django/db/transaction.py", line 56, in leave_transaction_management
    connection.leave_transaction_management()
  File "/usr/lib/python2.6/site-packages/django/db/backends/__init__.py", line 115, in leave_transaction_management
    raise TransactionManagementError("Transaction managed block ended with "
django.db.transaction.TransactionManagementError: Transaction managed block ended with pending COMMIT/ROLLBACK

Is this working? It said it didn't find any unused tags but still spews the trace back. A similar error is spewed while using the other tag commands too.

Update:

I've googled and the error seems to be quite common:

http://stackoverflow.com/questions/5647675/transaction-managed-block-ended-with-pending-commit-rollback

http://stackoverflow.com/questions/9955321/django-transaction-managed-block-ended-with-pending-commit-rollback

Does this happen on askbot.org? I'm running this without switching off the website.