[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Monotone-devel] sqlite exec error column id is not unique
From: |
Hendrik Boom |
Subject: |
Re: [Monotone-devel] sqlite exec error column id is not unique |
Date: |
Mon, 4 Jul 2005 17:54:21 -0400 |
User-agent: |
Mutt/1.5.9i |
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")