[horde] nag is using duplicate task ids
Dr. Michael J. Chudobiak
mjc at avtechpulse.com
Wed Nov 26 06:19:20 PST 2003
Hello,
I'm having a problem with nag. About half the time when I try to add a
new task, the addition fails with the error "There was a problem saving
the task: DB Error: already exists".
The pgsql.log agrees:
Nov 26 09:05:45 server2 postgres[14680]: [2] LOG: connection
authorized: user=horde database=horde
Nov 26 09:05:45 server2 postgres[14680]: [3] ERROR: Cannot insert a
duplicate key into unique index nag_tasks_pkey
Nov 26 09:05:45 server2 postgres[14680]: [4-1] LOG: statement:
INSERT INTO nag_tasks (task_owner, task_id, task_name, task_desc,
task_due, task_priority, task_ completed,
Nov 26 09:05:45 server2 postgres[14680]: [4-2] task_category,
task_modified, ta sk_alarm) VALUES ('mjc', 35, 'test task',
'', 0, 1, 0, 4, 1069855545, 0)
Browsing the nag table shows that a different task with that owner and
id does indeed exist already.
The nag_tasks table seems to be set up OK:
horde=# \d nag_tasks
Table "public.nag_tasks"
Column | Type | Modifiers
----------------+------------------------+--------------------
task_owner | character varying(255) | not null
task_id | integer | not null
task_name | character varying(64) | not null
task_desc | text |
task_modified | integer | not null
task_due | integer |
task_priority | integer | not null default 0
task_category | integer | not null default 0
task_completed | smallint | not null default 0
task_private | smallint | not null default 1
task_alarm | integer | not null default 0
Indexes: nag_tasks_pkey primary key btree (task_owner, task_id)
So, for some reason, nag is using already-assigned id numbers. Any ideas
on what's wrong?
I am using Fedora Core 1, psql 7.3.4-RH, horde-2003-11-24.tar.gz,
framework-2003-11-24.tar.gz, nag-2003-11-24.tar.gz,
kronolith-2003-11-13.tar.gz.
- Mike
More information about the horde
mailing list