[Devel] [Kaboom at OH] Error (EXTERNAL IP): /search/

[Asheesh Laroia]

Excerpts from mr_website's message of Mon Dec 14 16:44:39 UTC 2009:
> Traceback (most recent call last):
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/core/handlers/base.py
> ", line 92, in get_response
>     response = callback(request, *callback_args, **callback_kwargs)
> 
>   File "/home/deploy/milestone-a.buildout/mysite/search/views.py", line 44, in
> fetch_bugs
>     suggestion_keys = person.get_recommended_search_terms()
> 
>   File "/home/deploy/milestone-a.buildout/mysite/profile/models.py", line 152,
> in get_recommended_search_terms
>     return Person.only_terms_with_results(terms)
> 
>   File "/home/deploy/milestone-a.buildout/mysite/profile/models.py", line 127,
> in only_terms_with_results
>     hit_count = query.get_or_create_cached_hit_count()
> 
>   File "/home/deploy/milestone-a.buildout/mysite/search/controllers.py", line
> 243, in get_or_create_cached_hit_count
>     hit_count=count)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/manager.py"
> , line 126, in create
>     return self.get_query_set().create(**kwargs)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 315, in create
>     obj.save(force_insert=True)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/base.py",
> line 410, in save
>     self.save_base(force_insert=force_insert, force_update=force_update)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/base.py",
> line 495, in save_base
>     result = manager._insert(values, return_id=update_pk)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/manager.py"
> , line 177, in _insert
>     return insert_query(self.model, values, **kwargs)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 1087, in insert_query
>     return query.execute_sql(return_id)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/sql/subquer
> ies.py", line 320, in execute_sql
>     cursor = super(InsertQuery, self).execute_sql(None)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/sql/query.p
> y", line 2369, in execute_sql
>     cursor.execute(sql, params)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/backends/mysql/bas
> e.py", line 84, in execute
>     return self.cursor.execute(query, args)
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/MySQL_python-1.2.3c1-py2.5-linux-i686.eg
> g/MySQLdb/cursors.py", line 173, in execute
>     self.errorhandler(self, exc, value)
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/MySQL_python-1.2.3c1-py2.5-linux-i686.eg
> g/MySQLdb/connections.py", line 36, in defaulterrorhandler
>     raise errorclass, errorvalue
> 
> IntegrityError: (1062, "Duplicate entry
> '281f0ad7b329e5f7dfa420700e81555915062c9f' for key 1")
> 
> 
> <WSGIRequest
> GET:<QueryDict: {}>,
> POST:<QueryDict: {}>,
> COOKIES:{'sessionid': '866d7d29cecbaf385f4541ae85eacfdb'},
> META:{'DOCUMENT_ROOT': '/var/www/',
>  'GATEWAY_INTERFACE': 'CGI/1.1',
>  'HTTPS': '1',
>  'HTTP_ACCEPT':
> 'application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/pn
> g,*/*;q=0.5',
>  'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
>  'HTTP_ACCEPT_ENCODING': 'gzip,deflate',
>  'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',
>  'HTTP_CONNECTION': 'keep-alive',
>  'HTTP_COOKIE': 'sessionid=866d7d29cecbaf385f4541ae85eacfdb',
>  'HTTP_HOST': 'openhatch.org',
>  'HTTP_REFERER': 'https://openhatch.org/',
>  'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/532.6
> (KHTML, like Gecko) Chrome/4.0.267.0 Safari/532.6',
>  'PATH': '/usr/local/bin:/usr/bin:/bin',
>  'PATH_INFO': u'/search/',
>  'PATH_TRANSLATED':
> '/home/deploy/milestone-a.buildout/bin/production.wsgi/search/',
>  'QUERY_STRING': '',
>  'REMOTE_ADDR': '71.134.237.175',
>  'REMOTE_PORT': '58807',
>  'REQUEST_METHOD': 'GET',
>  'REQUEST_URI': '/search/',
>  'SCRIPT_FILENAME': '/home/deploy/milestone-a.buildout/bin/production.wsgi',
>  'SCRIPT_NAME': u'',
>  'SERVER_ADDR': '74.207.229.254',
>  'SERVER_ADMIN': 'webmaster at localhost',
>  'SERVER_NAME': 'openhatch.org',
>  'SERVER_PORT': '443',
>  'SERVER_PROTOCOL': 'HTTP/1.1',
>  'SERVER_SIGNATURE': '<address>Apache/2.2.9 (Debian) PHP/5.2.11-1 with
> Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g mod_wsgi/2.5 Python/2.5.4 Server at
> openhatch.org Port 443</address>\n',
>  'SERVER_SOFTWARE': 'Apache/2.2.9 (Debian) PHP/5.2.11-1 with Suhosin-Patch
> mod_ssl/2.2.9 OpenSSL/0.9.8g mod_wsgi/2.5 Python/2.5.4',
>  'mod_wsgi.application_group': 'openhatch.org|',
>  'mod_wsgi.callable_object': 'application',
>  'mod_wsgi.listener_host': '',
>  'mod_wsgi.listener_port': '443',
>  'mod_wsgi.process_group': 'live',
>  'mod_wsgi.reload_mechanism': '1',
>  'mod_wsgi.script_reloading': '1',
>  'mod_wsgi.version': (2, 5),
>  'wsgi.errors': <mod_wsgi.Log object at 0x9f76698>,
>  'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object
> at 0x9f20f98>,
>  'wsgi.input': <mod_wsgi.Input object at 0x9e0ea98>,
>  'wsgi.multiprocess': True,
>  'wsgi.multithread': False,
>  'wsgi.run_once': False,
>  'wsgi.url_scheme': 'https',
>  'wsgi.version': (1, 0)}>

I've talked with the user this affected, and committed 84ff8f932dff9c82717bdf3f06d856c81014fa31
to fix it.

Deployed!

-- Asheesh.

-- 
An exotic journey in downtown Newark is in your future.