InterfaceError: Error binding parameter 0 - probably unsupported type.
This happened to me 3 or 4 times in a couple of days, I was testing mail appending (copying mails from an existing account into a bitmask account).
2014-02-13 12:58:27,806 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:27-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 2014-02-13 12:58:28,463 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:28,494 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:28-0300 [-] Adding new doc to memstore 'INBOX' (145) 2014-02-13 12:58:28,501 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:28-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 13 append "INBOX" (\Seen) "13-Jan-2014 11:54:31 -0300" {4375} 2014-02-13 12:58:28,502 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:28-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 2014-02-13 12:58:29,232 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:29,262 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:29-0300 [-] Adding new doc to memstore 'INBOX' (146) 2014-02-13 12:58:29,269 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:29-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 14 append "INBOX" (\Seen) "13-Jan-2014 12:35:16 -0300" {7958} 2014-02-13 12:58:29,270 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:29-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 2014-02-13 12:58:30,069 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:30,088 - INFO - L#514 : leap.mail.imap.memorystore:write_messages() - Writing messages to Soledad... 2014-02-13 12:58:30,093 - DEBUG - L#441 : leap.mail.imap.soledadstore:_get_calls_for_rflags_doc() - Saving RFLAGS to Soledad... 2014-02-13 12:58:30,760 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:30-0300 [-] Adding new doc to memstore 'INBOX' (147) 2014-02-13 12:58:31,514 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:31-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 15 append "INBOX" (\Seen) "13-Jan-2014 12:04:35 -0300" {8328} 2014-02-13 12:58:31,515 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:31-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 2014-02-13 12:58:34,638 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:37,110 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:39,537 - ERROR - L#376 : leap.mail.imap.soledadstore:_try_call() - Error: InterfaceError('Error binding parameter 0 - probably unsupported type.',) Traceback (most recent call last): File "/mnt/datos/Unixono/proyectos/LEAP/leap_mail/src/leap/mail/imap/soledadstore.py", line 371, in _try_call call(item) File "/mnt/datos/Unixono/proyectos/LEAP/soledad/client/src/leap/soledad/client/__init__.py", line 899, in create_doc self._convert_to_unicode(content), doc_id=doc_id) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/u1db-13.09-py2.7.egg/u1db/backends/__init__.py", line 94, in create_doc return self.create_doc_from_json(json_string, doc_id) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/u1db-13.09-py2.7.egg/u1db/backends/__init__.py", line 100, in create_doc_from_json self.put_doc(doc) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/u1db-13.09-py2.7.egg/u1db/backends/sqlite_backend.py", line 377, in put_doc self._put_and_update_indexes(old_doc, doc) File "/mnt/datos/Unixono/proyectos/LEAP/soledad/client/src/leap/soledad/client/sqlcipher.py", line 413, in _put_and_update_indexes self, old_doc, doc) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/u1db-13.09-py2.7.egg/u1db/backends/sqlite_backend.py", line 878, in _put_and_update_indexes self._update_indexes(doc.doc_id, raw_doc, getters, c) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/u1db-13.09-py2.7.egg/u1db/backends/sqlite_backend.py", line 235, in _update_indexes "INSERT INTO document_fields VALUES (?, ?, ?)", values) InterfaceError: Error binding parameter 0 - probably unsupported type. 2014-02-13 12:58:40,298 - DEBUG - L#309 : leap.mail.imap.soledadstore:_soledad_write_document_parts() - ITEM WAS: {'part_map': {'1': {'multi': False, 'ctype': u'text/plain', 'headers': [('Content-Type', 'text/plain; charset=utf-8'), ('Content-Transfer-Encoding', 'Quoted-printable'), ('Content-Disposition', 'inline')], 'parts': 1, 'phash': u'50d319e633d61f51f253fd251f93226de44c14e224b419585e3b33ba23a60f04', 'size': 6303}, '2': {'part_map': {}, 'multi': False, 'ctype': u'text/html', 'headers': [('Content-Type', 'text/html; charset=utf-8'), ('Content-Transfer-Encoding', 'Quoted-printable'), ('Content-Disposition', 'inline')], 'parts': 1, 'phash': u'78a3958f195fddbf84b54d3a66552046beba79e11effc50e27e093c5acdea3be', 'size': 7254}}, 'body': u'50d319e633d61f51f253fd251f93226de44c14e224b419585e3b33ba23a60f04', 'multi': True, 'msgid': None, 'headers': defaultdict(, {'Delivered-To': u'ivan.bienco@unixono.com.ar', 'From': u'chili@leap.se', 'Return-Path': u'', 'X-Chiliproject-Project': u'eip-client', 'X-Chiliproject-Type': u'Issue', 'X-Virus-Scanned': u'Debian amavisd-new at paladio.gnucleo.net', 'X-Chiliproject-Issue-Assignee': u'micah', 'To': u'ivan.bienco@unixono.com.ar', 'X-Chiliproject-Host': u'leap.se/code', 'X-Chiliproject-Issue-Id': u'4845', 'Date': u'Wed, 8 Jan 2014 22:30:09 +0000', 'Message-Id': u'', 'X-Mailer': u'ChiliProject', 'Mime-Version': u'1.0', 'Received': u'from localhost (localhost [127.0.0.1])\r\n\tby paladio.gnucleo.net (Postfix) with ESMTP id D1BE268A67\r\n\tfor ; Wed, 8 Jan 2014 19:30:17 -0300 (ART)\nReceived: from paladio.gnucleo.net ([127.0.0.1])\r\n\tby localhost (paladio.gnucleo.net [127.0.0.1]) (amavisd-new, port 10024)\r\n\twith ESMTP id NLO831Ina3TG for ;\r\n\tWed, 8 Jan 2014 19:30:13 -0300 (ART)\nReceived: from cobalto.gnucleo.net (cobalto.gnucleo.net [10.23.0.27])\r\n\tby paladio.gnucleo.net (Postfix) with ESMTP id 0FD7968A3A\r\n\tfor ; Wed, 8 Jan 2014 19:30:13 -0300 (ART)\nReceived: from flea.leap.se (flea.leap.se [204.13.164.43])\r\n\tby cobalto.gnucleo.net (Postfix) with ESMTP id 9CC2920F65\r\n\tfor ; Wed, 8 Jan 2014 19:30:11 -0300 (ART)\nReceived: from hare.leap.se (hare.leap.se [204.13.164.51])\r\n\tby flea.leap.se (Postfix) with ESMTPA id C793912038E1\r\n\tfor ; Wed, 8 Jan 2014 22:30:09 +0000 (UTC)', 'Auto-Submitted': u'auto-generated', 'Precedence': u'bulk', 'Content-Type': u'multipart/alternative; boundary=mimepart_52cdd171c359c_54b23fe13e2057b0104f', 'References': u'', 'X-Chiliproject-Site': u'LEAP', 'X-Chiliproject-Issue-Author': u'varac', 'Subject': u'[Client - Bug #4845] (Resolved) thunderbird extension package should allow thunderbird as dependency'}), 'chash': u'c3ad82a906e3e2266a18ee67636b3915136a41f035c6055d344c29968b222de2', 'date': u'08-Jan-2014 19:30:09 -0300', 'type': u'head', 'subject': u'[Client - Bug #4845] (Resolved) thunderbird extension package should allow thunderbird as dependency'} 2014-02-13 12:58:40,390 - WARNING - L#86 : leap.mail.decorators:_errback() - Error in method: _consume_doc 2014-02-13 12:58:40,474 - ERROR - L#87 : leap.mail.decorators:_errback() - Traceback (most recent call last): File "/usr/lib/python2.7/threading.py", line 781, in __bootstrap self.__bootstrap_inner() File "/usr/lib/python2.7/threading.py", line 808, in __bootstrap_inner self.run() File "/usr/lib/python2.7/threading.py", line 761, in run self.__target(*self.__args, **self.__kwargs) --- --- File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/Twisted-13.2.0-py2.7-linux-i686.egg/twisted/python/threadpool.py", line 191, in _worker result = context.call(ctx, function, *args, **kwargs) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/Twisted-13.2.0-py2.7-linux-i686.egg/twisted/python/context.py", line 118, in callWithContext return self.currentContext().callWithContext(ctx, func, *args, **kw) File "/home/ivan/.virtualenvs/bitmask/local/lib/python2.7/site-packages/Twisted-13.2.0-py2.7-linux-i686.egg/twisted/python/context.py", line 81, in callWithContext return func(*args,**kw) File "/mnt/datos/Unixono/proyectos/LEAP/leap_mail/src/leap/mail/imap/soledadstore.py", line 289, in _consume_doc doSoledadCalls(self._iter_wrapper_subparts(doc_wrapper)) File "/mnt/datos/Unixono/proyectos/LEAP/leap_mail/src/leap/mail/imap/soledadstore.py", line 286, in doSoledadCalls failed = self._soledad_write_document_parts(items) File "/mnt/datos/Unixono/proyectos/LEAP/leap_mail/src/leap/mail/imap/soledadstore.py", line 310, in _soledad_write_document_parts logger.debug("ITEM CONTENT WAS: %s" % str(item.content)) exceptions.AttributeError: 'dict' object has no attribute 'content' None 2014-02-13 12:58:40,510 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:40-0300 [-] Adding new doc to memstore 'INBOX' (148) 2014-02-13 12:58:42,491 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:42-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 16 append "INBOX" (\Seen) "13-Jan-2014 11:58:16 -0300" {23750} 2014-02-13 12:58:43,839 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:43-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 2014-02-13 12:58:46,420 - DEBUG - L#82 : leap.mail.imap.messages:try_unique_query() - More than one rdoc found for this mbox, we got a duplicate!! 2014-02-13 12:58:46,445 - INFO - L#514 : leap.mail.imap.memorystore:write_messages() - Writing messages to Soledad... 2014-02-13 12:58:46,450 - DEBUG - L#441 : leap.mail.imap.soledadstore:_get_calls_for_rflags_doc() - Saving RFLAGS to Soledad... 2014-02-13 12:58:46,746 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:46-0300 [-] Adding new doc to memstore 'INBOX' (149) 2014-02-13 12:58:46,754 - DEBUG - L#53 : leap:write() - 2014-02-13 12:58:46-0300 [LeapIMAPServer,1,127.0.0.1] rcv (select): 17 append "INBOX" (\Seen) "13-Jan-2014 11:28:59 -0300" {8393}
(from redmine: created on 2014-02-13, closed on 2014-02-21, relates #4972 (closed), relates #4462 (closed), relates #4463 (closed))