Subject: [iola-conversion-tool] Approval Announcement Bug

From: Cindy Morgan <[email-masked]>
Date: Tue, 21 Feb 2012 14:41:46 -0800

Logged in as a Secretariat user, I tried to send an approval announcement for draft-ietf-payload-rtp-klv, and got this error:

https://trackerbeta.ietf.org/doc/draft-ietf-payload-rtp-klv/edit/approveballot/

Environment:

Request Method: POST
Request URL: https://trackerbeta.ietf.org/doc/draft-ietf-payload-rtp-klv/edit/approveballot/
Django Version: 1.2.7 SVN-3938
Python Version: 2.6.0
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.sitemaps',
 'django.contrib.admin',
 'django.contrib.admindocs',
 'django.contrib.humanize',
 'south',
 'workflows',
 'permissions',
 'ietf.person',
 'ietf.name',
 'ietf.group',
 'ietf.doc',
 'ietf.message',
 'ietf.announcements',
 'ietf.idindex',
 'ietf.idtracker',
 'ietf.ietfauth',
 'ietf.iesg',
 'ietf.ipr',
 'ietf.liaisons',
 'ietf.mailinglists',
 'ietf.meeting',
 'ietf.proceedings',
 'ietf.redirects',
 'ietf.idrfc',
 'ietf.wginfo',
 'ietf.submit',
 'ietf.ietfworkflows',
 'ietf.wgchairs',
 'ietf.wgcharter']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.auth.middleware.RemoteUserMiddleware',
 'django.middleware.doc.XViewMiddleware',
 'ietf.middleware.SQLLogMiddleware',
 'ietf.middleware.SMTPExceptionMiddleware',
 'ietf.middleware.RedirectTrailingPeriod',
 'django.middleware.transaction.TransactionMiddleware',
 'ietf.middleware.UnicodeNfkcNormalization')

Traceback:
File "/a/www/ietf-trackerbeta/web/django/core/handlers/base.py" in get_response
  100.                     response = callback(request, *callback_args, **callback_kwargs)
File "/a/home/henrik/tracker/4.00rc1/ietf/ietfauth/decorators.py" in inner
  51.                 return view_func(request, *args, **kwargs)
File "/a/www/ietf-trackerbeta/web/ietf/idrfc/views_ballot.py" in approve_ballotREDESIGN
  1261.         msg.related_docs.add(doc)
File "/a/home/henrik/tracker/4.00rc1/django/db/models/fields/related.py" in add
  501.                 self._add_items(self.source_field_name, self.target_field_name, *objs)
File "/a/home/henrik/tracker/4.00rc1/django/db/models/fields/related.py" in _add_items
  573.                 new_ids = new_ids - set(vals)
File "/a/home/henrik/tracker/4.00rc1/django/db/models/query.py" in _result_iter
  105.                 self._fill_cache()
File "/a/home/henrik/tracker/4.00rc1/django/db/models/query.py" in _fill_cache
  783.                     self._result_cache.append(self._iter.next())
File "/a/home/henrik/tracker/4.00rc1/django/db/models/query.py" in iterator
  967.             for row in self.query.get_compiler(self.db).results_iter():
File "/a/home/henrik/tracker/4.00rc1/django/db/models/sql/compiler.py" in results_iter
  677.         for rows in self.execute_sql(MULTI):
File "/a/home/henrik/tracker/4.00rc1/django/db/models/sql/compiler.py" in execute_sql
  732.         cursor.execute(sql, params)
File "/a/home/henrik/tracker/4.00rc1/django/db/backends/util.py" in execute
  15.             return self.cursor.execute(sql, params)
File "/a/home/henrik/tracker/4.00rc1/django/db/backends/mysql/base.py" in execute
  86.             return self.cursor.execute(query, args)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py" in execute
  166.             self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py" in defaulterrorhandler
  35.     raise errorclass, errorvalue

Exception Type: DatabaseError at /doc/draft-ietf-payload-rtp-klv/edit/approveballot/
Exception Value: (1146, "Table 'ietf_new.message_message_related_docs' doesn't exist")

---

From: Ole Laursen <[email-masked]>
Date: Wed, 22 Feb 2012 18:32:28 +0100

> https://trackerbeta.ietf.org/doc/draft-ietf-payload-rtp-klv/edit/approveballot/

This is the same table missing from the database.

Ole

---

From: Henrik Levkowetz <[email-masked]>
Date: Wed, 22 Feb 2012 20:34:47 +0100

> This is the same table missing from the database.

This seems to work now.  I still have to figure out why that table goes missing
at times.  Ole, could a single-document conversion trigger this somehow??

Best regards,

	Henrik

---

From: Ole Laursen <[email-masked]>
Date: Wed, 22 Feb 2012 21:55:45 +0100

> at times.  Ole, could a single-document conversion trigger this somehow??

I don't see how? I don't think I've written any code anywhere inside
Python that can drop a table.

Ole

---

From: Henrik Levkowetz <[email-masked]>
Date: Wed, 22 Feb 2012 22:00:39 +0100

> Python that can drop a table.

Ack.  Reasonable.  Just checking.

Thanks,

	Henrik