[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