[rt-users] Re: Postgres "invalid input syntax for integer" errors

[Matt Jennings]

RT 3.2.2 / DBIx::SearchBuilder  1.15 (latest from CPAN) / Postgres 7.4.1

Example message:
Sep  8 12:21:21 RT: DBD::Pg::st execute failed: ERROR:  invalid input
syntax for integer: "" 


Has the invalid value ("") for integer fields on postgres issue been
resolved in 3.2 series (or in a CVS version)?

We still encounter these messages occasionally followed by a failed ACL
query; seemingly less often with the newer SearchBuilder. The messages
do not seem to affect functionality but are concerning nonetheless.

The last time I saw such an error in RT itself was when creating a
queue, it occurred if the priority or other integer fields of the Queue
were left as the defaults.

I've just installed the rt3-statistics package from contrib and have
encountered more such messages, this time they seem to stop the stats
pages from being displayed.

Log below.

Like the previous poster I can find on this topic I've looked through
the mailing list archives and STW but can't seem to find any resolution
for this issue nor am I familiar enough with the RT and related code yet
to look into this.

Regards,
Matt Jennings


Log:

Dec  6 13:57:01 myserver RT: Trying to check RT::Queue rights for an
unspecified RT::Queue at /opt/rt3/lib/RT/Principal_Overlay.pm line 376
^IRT::Principal::HasRight('RT::Principal=HASH
(0x9e9daa8)','Object','RT::Queu
e=HASH(0x9ed8760)','Right','SeeQueue') called at
/opt/rt3/lib/RT/User_Overlay.pm line 1476
^IRT::User::HasRight('RT::User=HASH(0x9f09de0)','Object','RT::Queue=HASH
(0x9
ed8760)','Right','SeeQueue') called at /opt/rt3/lib/RT/CurrentUser.pm
line
338
^IRT::CurrentUser::HasRight('RT::CurrentUser=HASH
(0x9ec5344)','Object','RT::
Queue=HASH(0x9ed8760)','Right','SeeQueue') called at
/opt/rt3/lib/RT/Queue_Overlay.pm line 1066
^IRT::Queue::HasRight('RT::Queue=HASH
(0x9ed8760)','Principal','RT::CurrentUs
er=HASH(0x9ec5344)','Right','SeeQueue') called at
/opt/rt3/lib/RT/Queue_Overlay.pm line 1032
^IRT::Queue::CurrentUserHasRight('RT::Queue=HASH(0x9ed8760)','SeeQueue')
called at /opt/rt3/local/html/Statistics/CallsMultiQueue/index.html line
21
^IHTML::Mason::Commands::__ANON__() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Compon
Dec  6 13:57:01 myserver RT: Trying to check RT::Queue rights for an
unspecified RT::Queue (/opt/rt3/lib/RT/Principal_Overlay.pm:377)
Dec  6 13:57:01 myserver RT: DBD::Pg::st execute failed: ERROR:  invalid
input
syntax for integer: ""
at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 475.
(/opt/rt3/lib/RT.pm:269)
Dec  6 13:57:01 myserver RT: RT::Handle=HASH(0x9909944) couldn't execute
the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers
WHERE
(ACL.RightName = 'SuperUser' OR  ACL.RightName = 'SeeQueue') AND
Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0  AND
Principals.id = Groups.id AND  Principals.id =
CachedGroupMembers.GroupId
AND CachedGroupMembers.MemberId = '24' AND ( ACL.ObjectType =
'RT::System'
OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '')) AND ( (
ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND
(Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR
Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) )
LIMIT 1'
at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 489.
(/opt/rt3/lib/RT.pm:269)
Dec  6 13:57:01 myserver RT: DBD::Pg::st execute failed: ERROR:  invalid
input
syntax for integer: "" at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 475.
(/opt/rt3/lib/RT.pm:269)
Dec  6 13:57:01 myserver RT: RT::Handle=HASH(0x9909944) couldn't execute
the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers
WHERE
(ACL.RightName = 'SuperUser' OR  ACL.RightName = 'SeeQueue') AND
Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0  AND
Principals.id = Groups.id AND  Principals.id =
CachedGroupMembers.GroupId
AND CachedGroupMembers.MemberId = '24' AND ( ACL.ObjectType =
'RT::System'
OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '')) AND  (
((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 0)  )  AND
Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalType = 'Group')  LIMIT 1' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 489.
(/opt/rt3/lib/RT.pm:269)