[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Monotone-devel] SQL logic error or missing database
From: |
Lapo Luchini |
Subject: |
[Monotone-devel] SQL logic error or missing database |
Date: |
Fri, 06 Jul 2007 10:01:41 +0200 |
User-agent: |
Thunderbird 2.0.0.4 (X11/20070615) |
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 ¬¬YmiÉ"<ÜÍÔÔÔÔô[/
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çæíò¦aS&<ùzñõ"
oþ<5'Óæbü~65ó)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¹fkmY]V-k^MSXâ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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Monotone-devel] SQL logic error or missing database,
Lapo Luchini <=