Re: [Monotone-devel] sqlite exec error column id is not unique

[Hendrik Boom]

On Mon, Jul 04, 2005 at 12:36:43AM -0700, Nathaniel Smith wrote:
> On Sun, Jul 03, 2005 at 09:28:53PM -0400, Hendrik Boom wrote:
> > It told me to send this to you.  The monotone I am using is the one
> > distributed with sarge.
> 
> Can you send the file 'MT/debug' along too?
> 
> My first guess is that you have some keys on the server and in your
> local db with the same name but generated at different times, and
> we're giving a really horrid error message; but the debug log should
> clarify things.

The new server does have a different key from the old one, although
it has the same name.  The client did detect the change, and asked 
me to run the command to purge keys, which I did.  Of course I didn't think
anything was amiss at that point.  The problem I am reporting happened
after that, so I no longer have the older messages.

I hope I haven't messed up the MT/debig file by subsequent actions.
I'm puzzled by the date on eht first line on MT/debug -- both computers
have fairly well-synchonized, correct, clock.  Both of them know
it is 2005 now, and that July 8 hasn't happened yet.

-- hendrik

> 
> -- Nathaniel
> 
> -- 
> "If you can explain how you do something, then you're very very bad at it."
>   -- John Hopfield

There doesn't seem to be one for the server.
But here's MT/debug from the client:

started up on Linux 2.6.7-1-386 #1 Thu Jul 8 05:08:04 EDT 2004 i686
command line: 'monotone', '--db=/home/hendrik/monotone/database.db', 'sync', 
'topoi.pooq.com', 'com.pooq'
set locale: LC_CTYPE=en_CA.UTF-8, LC_MESSAGES=en_CA.UTF-8
initial path is /home2/hendrik/dv/sandbox
searching for 'MT' directory with root '/'
search for 'MT' ended at '/home2/hendrik/dv/sandbox' with '' removed
initializing from directory /home2/hendrik/dv/sandbox
found working copy directory /home2/hendrik/dv/sandbox
options path is MT/options
local dump path is MT/debug
setting dump path to MT/debug
skipping nonexistent rcfile '/home/hendrik/.monotonerc'
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 topoi.pooq.com
rebuilding merkle trees for collection com.pooq
db.fetch("SELECT id, name, value, keypair, signature FROM 'revision_certs' 
WHERE name = 'branch'")
including branch com.pooq.topoi.sandbox
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'")
read 214 bytes from fd 4 (peer topoi.pooq.com)
processing 0 byte input buffer from peer topoi.pooq.com
server key has name address@hidden, hash 
427ccc83f801158da61ac7a9cccda470f8a0b840
db.fetch("SELECT domain, name, value FROM db_vars")
warning: first time connecting to server topoi.pooq.com; authenticity can't be 
established
warning: their key is 427ccc83f801158da61ac7a9cccda470f8a0b840
db.execute("INSERT OR REPLACE INTO db_vars VALUES('known-servers', 
'dG9wb2kucG9vcS ...")
db.fetch("SELECT id FROM public_keys WHERE hash = 
'427ccc83f801158da61ac7a9cccda470f8a0b840'")
warning: saving public key for address@hidden to database
db.execute("INSERT INTO public_keys 
VALUES('427ccc83f801158da61ac7a9cccda470f8a0b8 ...")
db.execute("ROLLBACK")