[Monotone-devel] SQL logic error or missing database

[Lapo Luchini]

Update, merge, add... they work.
Sync somewhat works too, but only send ONE revision at a time and then
dies with:
mtn: error: sqlite error: SQL logic error or missing database

I've got a full "mtn sy --debug 2>debug.log" that is around 250KiB, and
in attach the last 100 lines of it.

Any idea?

PS: file permissions are ok

-- 
Lapo Luchini
address@hidden (OpenPGP & X.509)
www.lapo.it (Jabber, ICQ, MSN)

mtn: ” ¦…þ ꒞ú `ë:ÃB¨ü¢nµ™‹ ´ ±R1ˆ¥óÊô ¸é Ÿ™çK¤ §¥Ub  ~ ÈOÍ拢ê CìÏAµ+* 
¡öï8Óî™HÓc  <M‚'
mtn: binding 1 parameters for SELECT id FROM revisions WHERE id = ?
mtn: binding 1 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 6 parameters for INSERT INTO revision_certs VALUES(?, ?, ?, ?, ?, 
?)
mtn: binding 1 with value 'd6856b6a6e0bbbf822457492890991702224c6e4'
mtn: binding 2 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 3 with value 'date'
mtn: binding 4 with value '2007-07-06T07:07:47'
mtn: binding 5 with value 'address@hidden'
mtn: binding 6 with value ' í d¤4²I¶ 3R9….WHÇ均Ͼ:!ʧÉ×+ó¬·d † 
mtn: N W,4ñ
mtn: ” ¦…þ ꒞ú `ë:ÃB¨ü¢nµ™‹ ´ ±R1ˆ¥óÊô ¸é Ÿ™çK¤ §¥Ub  ~ ÈOÍ拢ê CìÏAµ+* 
¡öï8Óî™HÓc  <M‚'
mtn: processing 0 byte input buffer from peer monotone.ca
mtn: count of cert items to receive has reached zero
mtn: binding 1 parameters for SELECT id FROM revision_certs WHERE hash = ?
mtn: binding 1 with value 'ba6232139620d93b087188e5d084b4fce395633a'
mtn: binding 5 parameters for SELECT id FROM revision_certs WHERE id = ? AND 
name = ? AND value = ? AND keypair = ? AND signature = ?
mtn: binding 1 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 2 with value 'author'
mtn: binding 3 with value 'address@hidden'
mtn: binding 4 with value 'address@hidden'
mtn: binding 5 with value ' Yg ;ǵƒ0èÞ¥!ㄠ  †¯Œî/ÇII
mtn: wàë dŠÖ)ÖOb+L« /Â]I1©bRb ß´» TØ4 ¡òÈHà\ZõÄð¦UfËk AŽ ͘FEýà Ì1Èm ^ ÎSÛ[,  
˜ï“ éÓ©Hރ8ø®å©Ë= 
mtn: \ 'æ?^Öp'
mtn: binding 1 parameters for SELECT id FROM revisions WHERE id = ?
mtn: binding 1 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 6 parameters for INSERT INTO revision_certs VALUES(?, ?, ?, ?, ?, 
?)
mtn: binding 1 with value 'ba6232139620d93b087188e5d084b4fce395633a'
mtn: binding 2 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 3 with value 'author'
mtn: binding 4 with value 'address@hidden'
mtn: binding 5 with value 'address@hidden'
mtn: binding 6 with value ' Yg ;ǵƒ0èÞ¥!ㄠ  †¯Œî/ÇII
mtn: wàë dŠÖ)ÖOb+L« /Â]I1©bRb ß´» TØ4 ¡òÈHà\ZõÄð¦UfËk AŽ ͘FEýà Ì1Èm ^ ÎSÛ[,  
˜ï“ éÓ©Hރ8ø®å©Ë= 
mtn: \ 'æ?^Öp'
mtn: prepared statement INSERT INTO files (id, data) VALUES (?, ?)
mtn: binding 2 parameters for INSERT INTO files (id, data) VALUES (?, ?)
mtn: binding 1 with value '98de63131b4cf45184f1ab75d7d2efa6fdc0d124'
mtn: binding 2 with value ' ‹       ÿì½Ír I’çyŸ§ð͑\0g & Ÿ$³ªºQ * Ò$Á ‘ÙÛÍ*á   
M address@hidden:Ìid¯»{Ù¹íieç:·9כô“ìï¯j_în ‚¬¬‘Y‘miÉ"<ÜÍÔÔÔÔô[/ 
gӓ櫯þÍåâlq3׿¾z9Ÿýóäøfuÿdõ§É|1]=i.gW³›ÙÕä÷W¼p8¹žÍoVŸëÛÕß.Ï «G³'ýôòàhuw> 
ßðÕêÓñÍäI³öðáöêÃÑêÚzóðѓ‡W >zø0¼¼z8y?Õ ­w7W×6›Ñã'£ ÿp Þ}6^ܬ 
ÍÇW‹‹ñÍlþ¤y6¾ž5ϖÇçÓ«ió« þú[ýçÁôæ76ø³ñÕÙr|6Y=šŒ/?ýúóýç{y¹£  áîìêfrÅÄ 
¯YÉÍä7ß^_Œ§Wß5ÇçãùbróëåÍéê#›0½+ O'óÕ½«ãÙÉôêìIóèíôÆW|±œ/V 
7›_.ž4W×öçâ×kß5þÏ__ýfô½ù¿¬¾œMN¦7«»³åÕÍüã“fÿhçÙ?¶ ûíx1¹ ߜ?i <øýïõÛ¿ù·Ošñõõ›Å
mtn: ¸ p|üd´¾õoþíýæxõ”9Ç7Úgmø‡ÙüÝâz|<iæ“ YN瓓æíò¦a“›S&<ùzñõ"  
oþ<5'Óæbü~6Ÿ5ó)xŸ,nfÍ嘏®š›ùì=ûâŸõØب 1½z?¾ š æ?fS?6++yÒüT 
؛ãæ_ÿãÿù¯ÿñ?×Ö¹¹^›"Òmóv6{÷n2¹f?Êù¾^¬4ã  öäc3ùãtq³h¦WÍ
mtn: 3  ãâ p°˜ÌßO >Òø öõ КɂQ&ÍÙôÏÿ—†ŠÏ rstðôàI3 ŸLA<#ÆÉüxü7=„­m<¬­f1 
ϏϛùŒm ŒÍÉl²°M3Ø[ ÷fI ؆9˜Ÿ ÕèNPM ¦ mŸ ٟÿŸfyÕú
mtn: prepared statement INSERT INTO rosters (id, checksum, data) VALUES (?, ?, 
?)
mtn: binding 3 parameters for INSERT INTO rosters (id, checksum, data) VALUES 
(?, ?, ?)
mtn: binding 1 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: binding 2 with value 'f4472ce711e51caef82f72968049242d144a3a73'
mtn: binding 3 with value ' ‹       ÿÜÝ[s$Wr%êwý
mtn: Z¿“ ÷˼É$™±£‘d’ÆƎµÉÊâʂX Ô ¨n¶~ýù H ‘¹ d4 ª$TÓj É  
Ó÷o¿,_k½¹ý8Ü¿ûãr{wusýÍïòßýÕ_}óðg¾ºýæw¿{ø›«y¹¾ øwñoÆ«Ûû÷ßü¡h›¢©Æl,×|i³uÊ»² 
Ú,[š¥ÉÇy\ª©\‹õßþêÓpÿþÝÇáö‡¿ä¡Ã§øæ›õêÃòÍï¾ûx ýíÕ÷×7·Ëãgúfº¹¾õ‡º 
‡l(‹¡›Ë¹¨Û¶kç¼X‹¥lÇnÊË¢Ÿ  ´ú·§ ùôuª²:ü¬/_ªŸ–~mêj ê1ë›uœóv­ÊºÌ»¶ªó© 
ŠimÛùág=û^ÕÒTÅXÎKݖsŸµÕ:ŽS9û ]±öS6g%ë4ù¿ýÕác 쑯EßÍí²”EYù2vu> õ° 
YW7]9VMÖ2ô¿=½•'{üõÿþ×ÿñÿü/§¶˜šuí²i¬üÖj­úÖw©»fÊü“je¥rl«©è [´§–Øÿz¹Ä3Kì îØ 
å:ùÒë:µÝ4ÌÅÐgy¹fk‘­mY–]V-k^MSŸXâoþñŸþ¿ÿù ÿýÔ -«–ã\U•ŸÇ 
ÙÄ°yÞ´ÞPµÌÍP/ÒwCb‰îҖ˜Ç&ÏÆa\ò©(󢯖¬Ëó¬ï  {ªûºXÛlîùà“C ÎÈß¼ ®¿_þþæûS[ = ìû, 
ûz]Xš…¹q15~P=²+Ï`›S[ }ݜZcÈòl ¸zÝOí< M»pô"+Ãq}°Î±¯«n<=!ûŸ;ö‹ýϝXã üõßü¿ ~1 c;: 
address@hidden>­ŽÐ쨜Ú"/ÚäŒ4YYµC›ç‚ßTTmÙ7MØe]ûN¼ðÿá¶Yéô Ÿ‘ýÏ Ûb «2«§aéÇÆ 
kêržÚ¥¨ë¦/¦¡ÊÊÑéëÚ%ñŒÿù ÿò¯ ý÷  ê Õ84
mtn: sqlite error: 1: SQL logic error or missing database
mtn: schema_migration.cc:100: detected error 'E(false)' violated
mtn: binding 1 parameters for SELECT data FROM revisions WHERE id = ?
mtn: binding 1 with value 'dffcbb7724735c3a91d142f12f85395c9e880ff1'
mtn: loading lua hook note_netsync_revision_received
mtn: lua failure: isfunction() in get_fn; stack = nil  
mtn: Lua::ok(): failed
mtn: loading lua hook note_netsync_end
mtn: lua failure: isfunction() in get_fn; stack = nil  
mtn: Lua::ok(): failed
mtn: prepared statement ROLLBACK
mtn: binding 0 parameters for ROLLBACK
mtn: statement cache statistics
mtn: prepared 38 statements
mtn: 1 executions of BEGIN EXCLUSIVE
mtn: 1 executions of DELETE FROM file_deltas WHERE id = ?
mtn: 2 executions of DELETE FROM files WHERE id = ?
mtn: 1 executions of INSERT INTO file_deltas VALUES (?, ?, ?)
mtn: 1 executions of INSERT INTO files (id, data) VALUES (?, ?)
mtn: 1 executions of INSERT INTO heights VALUES(?, ?)
mtn: 2 executions of INSERT INTO revision_ancestry VALUES(?, ?)
mtn: 4 executions of INSERT INTO revision_certs VALUES(?, ?, ?, ?, ?, ?)
mtn: 1 executions of INSERT INTO revisions VALUES(?, ?)
mtn: 0 executions of INSERT INTO rosters (id, checksum, data) VALUES (?, ?, ?)
mtn: 1 executions of ROLLBACK
mtn: 418 executions of SELECT 1 FROM file_deltas WHERE id = ? LIMIT 1
mtn: 417 executions of SELECT 1 FROM files WHERE id = ? LIMIT 1
mtn: 1 executions of SELECT 1 FROM heights LIMIT 1
mtn: 1 executions of SELECT 1 FROM manifests LIMIT 1
mtn: 1 executions of SELECT 1 FROM revisions LIMIT 1
mtn: 1 executions of SELECT 1 FROM rosters LIMIT 1
mtn: 6 executions of SELECT 1 FROM rosters WHERE id = ? LIMIT 1
mtn: 1 executions of SELECT DISTINCT value FROM revision_certs WHERE name = ?
mtn: 2 executions of SELECT base FROM roster_deltas WHERE id = ?
mtn: 1 executions of SELECT branch, epoch FROM branch_epochs
mtn: 2 executions of SELECT checksum, data FROM rosters WHERE id = ?
mtn: 2 executions of SELECT checksum, delta FROM roster_deltas WHERE id = ? AND 
base = ?
mtn: 2 executions of SELECT data FROM files WHERE id = ?
mtn: 4 executions of SELECT data FROM revisions WHERE id = ?
mtn: 8 executions of SELECT domain, name, value FROM db_vars
mtn: 1 executions of SELECT hash, id, keypair FROM 'revision_certs' WHERE name 
!= 'branch'
mtn: 3 executions of SELECT height FROM heights WHERE height = ?
mtn: 163 executions of SELECT height FROM heights WHERE revision = ?
mtn: 1 executions of SELECT id FROM public_keys WHERE hash = ?
mtn: 42 executions of SELECT id FROM public_keys WHERE id = ?
mtn: 4 executions of SELECT id FROM revision_certs WHERE hash = ?
mtn: 4 executions of SELECT id FROM revision_certs WHERE id = ? AND name = ? 
AND value = ? AND keypair = ? AND signature = ?
mtn: 9 executions of SELECT id FROM revisions WHERE id = ?
mtn: 4 executions of SELECT id, name, value, keypair, signature FROM 
revision_certs WHERE name = ? AND value = ?
mtn: 42 executions of SELECT keydata FROM public_keys WHERE id = ?
mtn: 160 executions of SELECT parent FROM revision_ancestry WHERE child = ?
mtn: 1 executions of SELECT parent,child FROM revision_ancestry
mtn: error: sqlite error: SQL logic error or missing database