[Monotone-devel] fatal: std::runtime_error: sqlite exec error column id is not unique

[R.J.J.H. van Son]

L.S.,

I was setting up a monotone repository (first time) and encoutered the 
following error messages (see below) which told me to email this address.

It seems that I can sync computer 'wesseling' with computer 'fonpc18'. 
However, I get this error when I try to sync 'fonpc18' (or 'wesseling' 
itself) with 'wesseling'.

The repositories are rather small. I am sorry, but I have not been able 
to find any reference to this kind of problems.

Sincerely,

Rob

--
           Rob van Son
     address@hidden
 Institute of Phonetic Sciences/ACLC
       University of Amsterdam
          Herengracht 338
1016 CG Amsterdam, The Netherlands
      tel: +31 (0)205252183
      fax: +31 (0)205252197

########################################################################
address@hidden:SIGdial2005> monotone --db=~/monotone/rob.db sync wesseling 
nl.uva
monotone: connecting to wesseling
monotone: rebuilding merkle trees for collection nl.uva
monotone: including branch nl.uva.hum.dialog.SIGdial2005
monotone: including branch nl.uva.hum.dialog.Interspeech2005
monotone: [certs: 20] [keys: 2]
monotone: warning: first time connecting to server wesseling; 
authenticity can't be established
monotone: warning: their key is 0f0be105cd6ebe365bea8a369cd034926b5affb7
monotone: warning: saving public key for address@hidden to database
monotone: [bytes in: 209] [bytes out: 0] [revs in: 0] [revs out: 0]
monotone: fatal: std::runtime_error: sqlite exec error column id is not 
unique
monotone: this is almost certainly a bug in monotone.
monotone: please send this error message, the output of 'monotone 
--full-version',
monotone: and a description of what you were doing to 
address@hidden
monotone: wrote debugging log to MT/debug

address@hidden:SIGdial2005> monotone --full-version
monotone 0.18 (base revision: e8c9e4eb0534a4c6e538935576330de34ec42052)
Running on: Linux 2.4.22-openmosix-2 #4 SMP Tue Nov 25 09:28:04 CET 2003 
i686
Changes since base revision:

new_manifest [cbc23fa42b07e4f6f7d3a327c5eb1d4f4a782a75]

old_revision [e8c9e4eb0534a4c6e538935576330de34ec42052]
old_manifest [cbc23fa42b07e4f6f7d3a327c5eb1d4f4a782a75]


  Generated from data cached in the distribution;
  further changes may have been made.

  Generated from data cached in the distribution;
  further changes may have been made.

  Generated from data cached in the distribution;
  further changes may have been made.

MT/debug contents:
command line: 'monotone', '--db=~/monotone/rob.db', 'sync', 'wesseling', 
'nl.uva'
set locale: LC_CTYPE=C, LC_MESSAGES=C
initial path is /home/rob/Publications/SIGdial2005
converting 8 bytes from ANSI_X3.4-1968 to UTF-8
converting 22 bytes from ANSI_X3.4-1968 to UTF-8
converting 4 bytes from ANSI_X3.4-1968 to UTF-8
converting 9 bytes from ANSI_X3.4-1968 to UTF-8
converting 6 bytes from ANSI_X3.4-1968 to UTF-8
searching for 'MT' directory with root '/'
search for 'MT' ended at '/home/rob/Publications/SIGdial2005' with '' 
removed
initializing from directory /home/rob/Publications/SIGdial2005
found working copy directory /home/rob/Publications/SIGdial2005
options path is MT/options
converting 2 bytes from UTF-8 to ANSI_X3.4-1968
converting 7 bytes from UTF-8 to ANSI_X3.4-1968
converting 2 bytes from UTF-8 to ANSI_X3.4-1968
converting 7 bytes from UTF-8 to ANSI_X3.4-1968
local dump path is MT/debug
setting dump path to MT/debug
opening rcfile '/home/rob/.monotonerc' ...
'/home/rob/.monotonerc' is ok
skipping nonexistent rcfile 'MT/monotonerc'
executing sync command
db.fetch("SELECT domain, name, value FROM db_vars")
db.fetch("SELECT domain, name, value FROM db_vars")
lua isfunction() failed in get_fn
db.fetch("SELECT id from 'private_keys'")
db.fetch("SELECT id, name, value, keypair, signature FROM 
'revision_certs' WHERE name = 'branch'")
db.execute("BEGIN")
connecting to wesseling
rebuilding merkle trees for collection nl.uva
db.fetch("SELECT id, name, value, keypair, signature FROM 
'revision_certs' WHERE name = 'branch'")
including branch nl.uva.hum.dialog.SIGdial2005
including branch nl.uva.hum.dialog.Interspeech2005
db.fetch("SELECT branch, epoch FROM branch_epochs")
db.fetch("SELECT hash, id, keypair FROM 'revision_certs'")
db.fetch("SELECT id FROM public_keys WHERE id = 'address@hidden'")
db.fetch("SELECT keydata FROM public_keys where id = 
'address@hidden'")
db.fetch("SELECT id FROM public_keys WHERE id = 'address@hidden'")
db.fetch("SELECT keydata FROM public_keys where id = 'address@hidden'")
read 209 bytes from fd 4 (peer wesseling)
processing 0 byte input buffer from peer wesseling
server key has name address@hidden, hash 
0f0be105cd6ebe365bea8a369cd034926b5affb7
db.fetch("SELECT domain, name, value FROM db_vars")
warning: first time connecting to server wesseling; authenticity can't 
be established
warning: their key is 0f0be105cd6ebe365bea8a369cd034926b5affb7
db.execute("INSERT OR REPLACE INTO db_vars VALUES('known-servers', 
'd2Vzc2VsaW5n
' ...")
db.fetch("SELECT id FROM public_keys WHERE hash = 
'0f0be105cd6ebe365bea8a369cd034926b5affb7'")
warning: saving public key for address@hidden to database
db.execute("INSERT INTO public_keys 
VALUES('0f0be105cd6ebe365bea8a369cd034926b5aff ...")
db.execute("ROLLBACK")