View Single Post
  #6  
Old 18th June 2013, 12:33
Kwambus Kwambus is offline
Junior Member
 
Join Date: Jun 2013
Posts: 2
Thanks: 1
Thanked 2 Times in 1 Post
Default

FIXED:

Strange one this-

OK so I could train HAM/SPAM/Release/Delete from anywhere except the message details screen which would cause a hang and timeout. Most times I would have to restart uwsgi.

I poured over this for hours and implemented everything jrossi90 appeared to find out about this problem, I also conversed with jrossi90 yesterday but we hit a dead end. Thanks for the help by the way.

There was little in the logs to help, but seeing the release mechanism work everywhere but this screen I knew it could not be permissions of interactions with MailScanner/SpamAssassin/Baruwa.

As other have I saw this in the uwsgi log files:

/usr/lib/python2.7/dist-packages/djcelery/managers.py:173: TxIsolationWarning: Polling results with transaction isolation level repeatable

After some research I found this:

https://code.djangoproject.com/ticket/13906

And after inserting the following into /etc/baruwa/settings.py:

# Recommended for MySQL. See http://code.djangoproject.com/ticket/13906
'OPTIONS': {'init_command': 'SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED'},

In the section starting:

DATABASES = {
'default': {

I rebooted and everything is working! No idea why other than the 'not returning error code' is a possible reason as to why the session was hanging.

I really hope this helps others, this problem was a nightmare. I have rebooted several times and thus far it appears fixed.
Reply With Quote