Issue1

Title Creating new groups in a new SGDI instance gives error
Priority BUG Status testing
Superseder Nosy List jgentry, sfalcon
Assigned To jgentry Topics

Created on 2006-03-25.11:06:49 by sfalcon, last changed 2006-05-18.13:20:54 by jgentry.

Messages
msg69 (view) Author: jgentry Date: 2006-05-18.13:20:54
Switching back to testing.  I misunderstood the original comments.  It is (I
think) the same basic problem though (the double queries) as the error message
I'm getting is the same.  

I'm going to create a separate issue for this.
msg68 (view) Author: sfalcon Date: 2006-05-18.13:14:04
ERROR reading file: msg68
Possibly a access right configuration problem.
[Errno 13] Permission denied: '/extra/trackers/sgdi/db/files/msg/0/msg68'
msg67 (view) Author: jgentry Date: 2006-05-18.12:50:32
I just got this error this evening, so it hasn't gone away completely.  In this
case - adding group w/o members worked, but adding group w/ members did not work.
msg45 (view) Author: jgentry Date: 2006-04-04.11:37:23
Let's call this 'testing' for now until we can be more sure this is the same
error as in Issue11
msg38 (view) Author: jgentry Date: 2006-03-30.12:22:56
If this is indeed the same as Issue11, it is resolved.  If not, I'm going to
need more info (tracebacks & such)
msg36 (view) Author: jgentry Date: 2006-03-30.11:30:46
The double query comes when you add a group w/ users in it.  It looks like if
you add a group w/o initial users it only calls it 1x.  Disregard my earlier
statement about a lot of things coming 2x, that was a little too bold.
msg35 (view) Author: jgentry Date: 2006-03-30.11:18:24
It looks like the query is being fired over to Postgres multiple times.  Since
it must be unique the second one must be triggering that constraint.  Actually
it looks like a lot of these things are getting doubled up - I'm not really sure
why that would be.  Also, it is unclear why other INSERTs (w/o unique
contraints) actually don't insert 2x if they're being issued 2x.
msg32 (view) Author: jgentry Date: 2006-03-29.16:04:52
What is the actual error you get here? (provided you can replicate it)

Also, it might also be similar to the VIEW problem where certain environmental
conditions need to be met before it works (as currently implemented).
msg31 (view) Author: sfalcon Date: 2006-03-29.14:57:23
ERROR reading file: msg31
Possibly a access right configuration problem.
[Errno 13] Permission denied: '/extra/trackers/sgdi/db/files/msg/0/msg31'
msg30 (view) Author: jgentry Date: 2006-03-29.14:46:13
Is this the unique constraint issue?
msg1 (view) Author: sfalcon Date: 2006-03-25.11:06:49
After installing a new SGDI instance into Zope via the ZMI.  One gets an error
when trying to add a new group.  But by repeating the attempt, it eventually
works and groups are able to be added.
History
Date User Action Args
2006-05-18 13:20:54jgentrysetstatus: in-progress -> testing
messages: + msg69
2006-05-18 13:14:04sfalconsetmessages: + msg68
2006-05-18 12:50:32jgentrysetstatus: testing -> in-progress
messages: + msg67
2006-04-04 11:37:23jgentrysetstatus: in-progress -> testing
messages: + msg45
2006-03-30 12:22:56jgentrysetmessages: + msg38
2006-03-30 11:30:46jgentrysetmessages: + msg36
2006-03-30 11:18:24jgentrysetmessages: + msg35
2006-03-29 16:04:52jgentrysetmessages: + msg32
2006-03-29 14:57:23sfalconsetmessages: + msg31
2006-03-29 14:46:13jgentrysetstatus: unread -> in-progress
assignedto: jgentry
messages: + msg30
nosy: + jgentry
2006-03-25 11:06:49sfalconcreate