TransactionManagementError attempting to create product variation from configurable product

[m1chael]

I am getting an error on /admin/product/productvariation/add/

TransactionManagementError attempting to create product variation from
configurable product...

I see this ticket, but don't see much more information or fixes...
http://www.satchmoproject.com/trac/ticket/643

I am At satchmo revision 2055 and Django version 1.1 beta 1 SVN-11082.

Does anyone know what this might mean???

Environment:

Request Method: POST
Request URL: http://www.voodookey.com:8000/admin/product/productvariation/add/
Django Version: 1.1 beta 1 SVN-11082
Python Version: 2.4.3
Installed Applications:
['django.contrib.flatpages',
'django.contrib.admindocs',
'django.contrib.sites',
'satchmo_store.shop',
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.comments',
'django.contrib.sessions',
'django.contrib.sitemaps',
'registration',
'keyedcache',
'livesettings',
'l10n',
'sorl.thumbnail',
'satchmo_store.contact',
'tax',
'tax.modules.no',
'tax.modules.area',
'tax.modules.percent',
'shipping',
'product',
'payment',
'payment.modules.giftcertificate',
'satchmo_utils',
'app_plugins',
'survey',
'voodookey.accounting',
'voodookey.expense',
'voodookey.newsletter',
'voodookey.password',
'voodookey.todo']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.middleware.doc.XViewMiddleware',
'threaded_multihost.middleware.ThreadLocalMiddleware',
'satchmo_store.shop.SSLMiddleware.SSLRedirect',
'django.contrib.flatpages.middleware.FlatpageFallbackMiddleware')

Traceback:
File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py"
in get_response
92. response = callback(request, *callback_args,
**callback_kwargs)
File "/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py" in root
480. return self.model_page(request, *url.split('/', 2))
File "/usr/lib/python2.4/site-packages/django/views/decorators/cache.py"
in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py"
in model_page
499. return admin_obj(request, rest_of_url)
File "/usr/lib/python2.4/site-packages/django/contrib/admin/options.py"
in __call__
1088. return self.add_view(request)
File "/usr/lib/python2.4/site-packages/django/db/transaction.py" in
_commit_on_success
251. leave_transaction_management()
File "/usr/lib/python2.4/site-packages/django/db/transaction.py" in
leave_transaction_management
77. raise TransactionManagementError("Transaction managed
block ended with pending COMMIT/ROLLBACK")

Exception Type: TransactionManagementError at
/admin/product/productvariation/add/
Exception Value: Transaction managed block ended with pending COMMIT/ROLLBACK

[m1chael]

Still having the problem.. but I have checked the postgresql log file..

I see the error as being:

ERROR: insert or update on table "product_productvariation_options"
violates foreign key constraint "product_productvariation_opti$
DETAIL: Key (productvariation_id)=(20) is not present in table
"product_productvariation".
STATEMENT: COMMIT

Hope gives more insight on what is going on here...

Any ideas???

~Mike

[m1chael]

ERROR: insert or update on table "product_productvariation_options"
violates foreign key constraint

"product_productvariation_options_productvariation_id_fkey"

DETAIL: Key (productvariation_id)=(20) is not present in table
"product_productvariation".
STATEMENT: COMMIT