Opened 6 years ago

Closed 3 years ago

#4352 closed defect (duplicate)

Weather blows up with a stacktrace on locked database

Reported by: kaner Owned by: kaner
Priority: Medium Milestone:
Component: Metrics/Tor Weather Version:
Severity: Keywords:
Cc: Actual Points:
Parent ID: Points:
Reviewer: Sponsor:

Description (last modified by arma)

This has been seen a few times recently:

WARN [ Thu Oct 27 19:19:06 2011 ]: No event for: 650 NEWCONSENSUS
Traceback (most recent call last):
  File "/srv/weather.torproject.org/opt/weather/weather/TorCtl/TorCtl.py", line 535, in _eventLoop
    self._handleFn(timestamp, reply)
  File "/srv/weather.torproject.org/opt/weather/weather/TorCtl/TorCtl.py", line 1061, in _handle1
    self._map1.get(event.event_name, self.unknown_event)(event)
  File "/srv/weather.torproject.org/opt/weather/weather/weatherapp/listener.py", line 30, in new_consensus_event
    updaters.run_all()
  File "/srv/weather.torproject.org/opt/weather/weather/weatherapp/updaters.py", line 335, in run_all
    email_list = update_all_routers(ctl_util, email_list)
  File "/srv/weather.torproject.org/opt/weather/weather/weatherapp/updaters.py", line 263, in update_all_routers
    if len(deployed_query) == 0:
  File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line 81, in __len__
    self._result_cache = list(self.iterator())
  File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line 269, in iterator
    for row in compiler.results_iter():
  File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py", line 672, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py", line 727, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py", line 200, in execute
    return Database.Cursor.execute(self, query, params)
DatabaseError: database is locked
Terminated

Child Tickets

Change History (4)

comment:1 Changed 6 years ago by kaner

Seems like a second Weather process was running that kept the database locked. I wonder where that came from. Keeping this ticket open for now.

comment:2 Changed 6 years ago by arma

Description: modified (diff)

comment:3 Changed 3 years ago by kaner

This is fixed together with #5521. Closing.

comment:4 Changed 3 years ago by kaner

Resolution: duplicate
Status: newclosed
Note: See TracTickets for help on using tickets.