Greetings,

I have an interesting access issue with my Reviewboard instance.
I have a dedicated VM running reviewboard 1.5.4.

The Problem:
Every now and again users have issues using the system and I get Admin
alert emails with the details below. The load on the machine goes up
to approximate 4 (single processor).. more observations below.

-------- (Email Message to Root) --------
Traceback (most recent call last):

  File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.5-py2.6.egg/django/core/handlers/base.py",
line 100, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File 
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.5.4-py2.6.egg/reviewboard/accounts/decorators.py",
line 27, in _check
    return view_func(*args, **kwargs)

  File 
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.5.4-py2.6.egg/reviewboard/accounts/decorators.py",
line 46, in _check_valid_prefs
    return view_func(request, *args, **kwargs)

  File 
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.5.4-py2.6.egg/reviewboard/reviews/views.py",
line 141, in review_detail
    visited.save()

  File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.5-py2.6.egg/django/db/models/base.py",
line 458, in save
    self.save_base(using=using, force_insert=force_insert,
force_update=force_update)

  File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.5-py2.6.egg/django/db/models/base.py",
line 558, in save_base
    transaction.commit_unless_managed(using=using)

  File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.5-py2.6.egg/django/db/transaction.py",
line 175, in commit_unless_managed
    connection._commit()

  File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.5-py2.6.egg/django/db/backends/__init__.py",
line 32, in _commit
    return self.connection.commit()

OperationalError: database is locked


<ModPythonRequest
path:/r/1371/,
GET:<QueryDict: {}>,
POST:<QueryDict: {}>,
COOKIES:{'rbsessionid': '803f0ef200329d8921c1b70a9b7eb8ff'},
META:{'AUTH_TYPE': None,
 'CONTENT_LENGTH': 0,
 'CONTENT_TYPE': None,
 'GATEWAY_INTERFACE': 'CGI/1.1',
 'HTTP_ACCEPT':
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
 'HTTP_ACCEPT_ENCODING': 'gzip, deflate',
 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5',
 'HTTP_CONNECTION': 'keep-alive',
 'HTTP_COOKIE': 'rbsessionid=803f0ef200329d8921c1b70a9b7eb8ff',
 'HTTP_HOST': 'review.****.***',
 'HTTP_IF_NONE_MATCH': '****:2012-01-16 10:46:18.283850::2012-02-16
14:12:08.745932:0:1299464299',
 'HTTP_REFERER': 'http://review.rocksoft.com/dashboard/',
 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
rv:10.0.1) Gecko/20100101 Firefox/10.0.1',
 'PATH_INFO': u'/r/1371/',
 'PATH_TRANSLATED': None,
 'QUERY_STRING': None,
 'REMOTE_ADDR': '****.***.***.***',
 'REMOTE_HOST': None,
 'REMOTE_IDENT': None,
 'REMOTE_USER': None,
 'REQUEST_METHOD': 'GET',
 'SCRIPT_NAME': '',
 'SERVER_NAME': 'review.***.***.***',
 'SERVER_PORT': 80,
 'SERVER_PROTOCOL': 'HTTP/1.1',
 'SERVER_SOFTWARE': 'mod_python'}>
--------

While trying to restart apache (and this is the wierd bit), patch
appears to get started and open 'port 80' (yeah, I don't understand
this either).

# netstat -ntlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address
State       PID/Program name
...
tcp        0      0 0.0.0.0:80              0.0.0.0:*
LISTEN      23275/patch
...

# ps aux | grep patch
www-data 23275  0.0  0.0   4036   492 ?        S    Jan12   0:00 patch
-o /tmp/reviewboard.VDhhfR/tmp0HLn60-new
/tmp/reviewboard.VDhhfR/tmp0HLn60
www-data 23276  0.0  0.0   4036   484 ?        S    Jan12   0:00 patch
-o /tmp/reviewboard.xTIxjP/tmpN7YjTq-new
/tmp/reviewboard.xTIxjP/tmpN7YjTq
www-data 32634  0.0  0.0   4036   528 ?        S    Jan17   0:00 patch
-o /tmp/reviewboard.Mhy4yq/tmpqytjmk-new
/tmp/reviewboard.Mhy4yq/tmpqytjmk
www-data 32635  0.0  0.0   4036   532 ?        S    Jan17   0:00 patch
-o /tmp/reviewboard.NrBcSF/tmpq5ehYD-new
/tmp/reviewboard.NrBcSF/tmpq5ehYD

Question 1: Why does 'patch' have port 80 open? ( I have some
thoughts, but it requires more knowledge on how
  reviewboard calls patch ).

Question 2: Is this what would cause issues accessing the apache
server? (It certainly doesn't allow the apache server to restart.)

Cheers,
Paul

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~----------~----~----~----~------~----~------~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Reply via email to