[rt-users] users and group sequence resetting
Donal O'C
lists at schools.edu.ie
Wed Aug 1 06:48:10 EDT 2007
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
We noticed a problem recently with our RT install. Some incoming mails
didn't get created as tickets. Checking the logs we get the errors
below. I've copied 2 instances. This led us to check users_id_seq and
groups_id_seq, both of whose "last value" had reset to 1.
I tried to update this manually but the last value in the sequence isn't
incremented by new tickets being created. Has anyone come across any
sequences resetting? We upgraded postgres some time ago but RT has
mostly been working without any problems.
With the sequence not incrementing, RT tries to insert new users with
the same id as existing ones.
We have also noticed some transactions being confused, i.e. the wrong
email being sent by RT when a ticket is updated but I'm not sure these
are linked.
RT v3.4 PostgreSQL 8.2.4
Thanks,
Donal
[Wed Jul 25 11:24:11 2007] [warning]: DBD::Pg::st execute failed: ERROR:
duplicate key violates unique constraint "groups_pkey"
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'INSERT INTO Groups (Domain, Type, Instance,
id, Name, Description) VALUES (?, ?, ?, ?,
?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'SELECT * FROM Principals WHERE
LOWER(PrincipalType) = ? AND (ObjectId IS NULL OR Objec
tId = '')' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'INSERT INTO GroupMembers (GroupId, MemberId)
VALUES (?, ?)' at /usr/share/perl5/DBIx/Se
archBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [crit]: Couldn't add the user to his own acl
equivalence group:
(/usr/share/request-tracker3.4/lib/RT/Group_Overlay.pm:591)
[Wed Jul 25 11:24:11 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'DELETE FROM Groups WHERE id=? ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 4
94.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:11 2007] [crit]: Couldn't stash the user in
groupmembers (/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:277)
[Wed Jul 25 11:24:16 2007] [crit]: Failed to create user user at email.com:
Could not create user
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:612)
[Wed Jul 25 11:24:16 2007] [warning]: DBD::Pg::st execute failed: ERROR:
duplicate key violates unique constraint "groups_pkey"
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'INSERT INTO Groups (Domain, Type, Instance,
id, Name, Description) VALUES (?, ?, ?, ?,
?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'SELECT * FROM Principals WHERE
LOWER(PrincipalType) = ? AND (ObjectId IS NULL OR Objec
tId = '')' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'INSERT INTO GroupMembers (GroupId, MemberId)
VALUES (?, ?)' at /usr/share/perl5/DBIx/Se
archBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [crit]: Couldn't add the user to his own acl
equivalence group:
(/usr/share/request-tracker3.4/lib/RT/Group_Overlay.pm:591)
[Wed Jul 25 11:24:16 2007] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [warning]: RT::Handle=HASH(0x9b386b8)
couldn't execute the query 'DELETE FROM Groups WHERE id=? ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 4
94.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Jul 25 11:24:16 2007] [crit]: Couldn't stash the user in
groupmembers (/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:277)
[Wed Jul 25 11:24:21 2007] [crit]: Failed to create user user at email.com:
Could not create user
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:612)
[Wed Jul 25 11:24:22 2007] [error]: error: unexpected end of header
[Wed Aug 1 08:18:25 2007] [debug]: Converting 'us-ascii' to 'utf-8' for
text/plain - Please review ticket 01AC038956 assigned to
(/usr/share/request-tracker3.4/lib/RT/I18N.pm:225)
[Wed Aug 1 08:18:25 2007] [debug]: About to think about scrips for
transaction #21871
(/usr/share/request-tracker3.4/lib/RT/Transaction_Overlay.pm:154)
[Wed Aug 1 08:18:25 2007] [debug]: About to think about scrips for
transaction #21872
(/usr/share/request-tracker3.4/lib/RT/Transaction_Overlay.pm:154)
[Wed Aug 1 08:18:25 2007] [warning]: DBD::Pg::st execute failed: ERROR:
duplicate key violates unique constraint "groups_pkey"
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Aug 1 08:18:25 2007] [warning]: RT::Handle=HASH(0x9a86340)
couldn't execute the query 'INSERT INTO Groups (Domain, Type, Instance,
id, Name, Description) VALUES (?, ?, ?, ?,
?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
[Wed Aug 1 08:18:25 2007] [error]: Couldn't create a ticket group of
type 'Cc' for ticket 2320: Could not create group
(/usr/share/request-tracker3.4/lib/RT/Ticket_Overlay.pm:1255
)
[Wed Aug 1 08:18:25 2007] [crit]: Couldn't create ticket groups for
ticket 2320. aborting Ticket creation.
(/usr/share/request-tracker3.4/lib/RT/Ticket_Overlay.pm:613)
[Wed Aug 1 08:18:25 2007] [crit]: Ticket could not be created due to an
internal error (/usr/share/request-tracker3.4/lib/RT/Interface/Email.pm:753)
[Wed Aug 1 08:18:25 2007] [error]: Create failed: 0 / 0 / Ticket could
not be created due to an internal error
(/usr/share/request-tracker3.4/lib/RT/Interface/Email.pm:759)
error: couldn't parse head; error near:
A new ticket has being created
(/usr/share/request-tracker3.4/lib/RT/Template_Overlay.pm:366)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGsGTp0B9Uyyi7ssARAvTiAKCTZwD51kKrn2Ik+Rt1glPLzWYZmwCgkV3/
z0rMlQ/hFMVEgva9hRWXof4=
=n3na
-----END PGP SIGNATURE-----
More information about the rt-users
mailing list