Too many SQL variables on sync from scratch
I just did a fresh sync on my old wazokazi account, after migrating to the new soledad schema. At some time i got this error:
2016-08-24T14:43:34.723533+02:00 pixelated pixelated-user-agent[3342]: 2016-08-24 14:43:34 [leap.soledad.client.encdecpool] DEBUG Sync decrypter pool: inserting doc in local db: M-c6c3c875_4497_4cf7_86e6_044ba4a75718-BA96A3E77B141B588BE 6913D258C2FF3D7EA02E5CC188D5F204A658614635EF8:feb844bc1dd14cfa8e0f3ae2e85ae48a:1 2361 2016-08-24T14:43:35.961444+02:00 pixelated pixelated-user-agent[3342]: Unhandled error in Deferred: 2016-08-24T14:43:35.961899+02:00 pixelated pixelated-user-agent[3342]: 2016-08-24 14:43:35 [twisted] CRITICAL Unhandled error in Deferred: 2016-08-24T14:43:35.964116+02:00 pixelated pixelated-user-agent[3342]: Traceback (most recent call last): 2016-08-24T14:43:35.964156+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 434, in errback 2016-08-24T14:43:35.964177+02:00 pixelated pixelated-user-agent[3342]: self._startRunCallbacks(fail) 2016-08-24T14:43:35.964194+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 501, in _startRunCallbacks 2016-08-24T14:43:35.964211+02:00 pixelated pixelated-user-agent[3342]: self._runCallbacks() 2016-08-24T14:43:35.964226+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 588, in _runCallbacks 2016-08-24T14:43:35.964242+02:00 pixelated pixelated-user-agent[3342]: current.result = callback(current.result, *args, **kw) 2016-08-24T14:43:35.964257+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 1184, in gotResult 2016-08-24T14:43:35.964273+02:00 pixelated pixelated-user-agent[3342]: _inlineCallbacks(r, g, deferred) 2016-08-24T14:43:35.964287+02:00 pixelated pixelated-user-agent[3342]: --- --- 2016-08-24T14:43:35.964308+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks 2016-08-24T14:43:35.964324+02:00 pixelated pixelated-user-agent[3342]: result = result.throwExceptionIntoGenerator(g) 2016-08-24T14:43:35.964340+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator 2016-08-24T14:43:35.964356+02:00 pixelated pixelated-user-agent[3342]: return g.throw(self.type, self.value, self.tb) 2016-08-24T14:43:35.964372+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/src/leap.soledad.client/client/src/leap/soledad/client/encdecpool.py", line 643, in _decrypt_and_recurse 2016-08-24T14:43:35.964389+02:00 pixelated pixelated-user-agent[3342]: yield self._process_decrypted_docs() 2016-08-24T14:43:35.964405+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks 2016-08-24T14:43:35.964420+02:00 pixelated pixelated-user-agent[3342]: result = result.throwExceptionIntoGenerator(g) 2016-08-24T14:43:35.964463+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator 2016-08-24T14:43:35.964479+02:00 pixelated pixelated-user-agent[3342]: return g.throw(self.type, self.value, self.tb) 2016-08-24T14:43:35.964495+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/src/leap.soledad.client/client/src/leap/soledad/client/encdecpool.py", line 575, in _process_decrypted_docs 2016-08-24T14:43:35.964511+02:00 pixelated pixelated-user-agent[3342]: insertable = yield self._get_insertable_docs() 2016-08-24T14:43:35.964546+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks 2016-08-24T14:43:35.964563+02:00 pixelated pixelated-user-agent[3342]: result = result.throwExceptionIntoGenerator(g) 2016-08-24T14:43:35.964589+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator 2016-08-24T14:43:35.964611+02:00 pixelated pixelated-user-agent[3342]: return g.throw(self.type, self.value, self.tb) 2016-08-24T14:43:35.964633+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/src/leap.soledad.client/client/src/leap/soledad/client/encdecpool.py", line 562, in _get_insertable_docs 2016-08-24T14:43:35.964649+02:00 pixelated pixelated-user-agent[3342]: sequence=sequence) 2016-08-24T14:43:35.964663+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/threadpool.py", line 246, in inContext 2016-08-24T14:43:35.964679+02:00 pixelated pixelated-user-agent[3342]: result = inContext.theWork() 2016-08-24T14:43:35.964694+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/threadpool.py", line 262, in 2016-08-24T14:43:35.964709+02:00 pixelated pixelated-user-agent[3342]: inContext.theWork = lambda: context.call(ctx, func, *args, **kw) 2016-08-24T14:43:35.964724+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/context.py", line 118, in callWithContext 2016-08-24T14:43:35.964740+02:00 pixelated pixelated-user-agent[3342]: return self.currentContext().callWithContext(ctx, func, *args, **kw) 2016-08-24T14:43:35.964756+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/python/context.py", line 81, in callWithContext 2016-08-24T14:43:35.964771+02:00 pixelated pixelated-user-agent[3342]: return func(*args,**kw) 2016-08-24T14:43:35.964787+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/enterprise/adbapi.py", line 445, in _runInteraction 2016-08-24T14:43:35.964802+02:00 pixelated pixelated-user-agent[3342]: result = interaction(trans, *args, **kw) 2016-08-24T14:43:35.964817+02:00 pixelated pixelated-user-agent[3342]: File "/usr/share/python/pixelated-user-agent/local/lib/python2.7/site-packages/twisted/enterprise/adbapi.py", line 459, in _runQuery 2016-08-24T14:43:35.964838+02:00 pixelated pixelated-user-agent[3342]: trans.execute(*args, **kw) 2016-08-24T14:43:35.964852+02:00 pixelated pixelated-user-agent[3342]: pysqlcipher.dbapi2.OperationalError: too many SQL variables 2016-08-24T14:43:35.964867+02:00 pixelated pixelated-user-agent[3342]: 2016-08-24 14:43:35 [twisted] CRITICAL
shyba, ayoyo asked me to hand this to you, pls have a look.
(from redmine: created on 2016-08-24, closed on 2017-01-02)