[rt-users] RTFM and Postgres 7.3.

[Patrick Hurley]

> > Jan 13 09:39:36 rt RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
> > zero-length string at
> > /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line
410.
> > (/opt/rt3/lib/RT.pm:247)
> 
> The postgres error log should contain a record of what statement it
> failed on. That's necessary for debugging this.

My apologies -- I had the postgres logging level set to panic.  Here's
more postgres info from the log (with the log level now set to error)
which is probably what you're asking for:


Jan 13 17:11:21 rt RT: Trying to check RT::FM::Article rights for an
unspecified RT::FM::Article (/opt/rt3/lib/RT/Principal_Overlay.pm:355
)

Jan 13 23:11:21 rt postgres[9386]: [1] ERROR:  pg_atoi: zero-length
string

Jan 13 23:11:21 rt postgres[9386]: [2-1] LOG:  statement:

Jan 13 23:11:21 rt postgres[9386]: [2-2]
SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers

Jan 13 23:11:21 rt postgres[9386]: [2-3]  WHERE (ACL.RightName =
'SuperUser' OR ACL.RightName = 'ShowArticle') AND Principals.Disabled =
0 AND

Jan 13 23:11:21 rt postgres[9386]: [2-4]  CachedGroupMembers.Disabled =
0 AND Principals.id = Groups.id AND Principals.id =
CachedGroupMembers.GroupId AND

Jan 13 23:11:21 rt postgres[9386]: [2-5]  CachedGroupMembers.MemberId =
'12' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType =
'RT::FM::System' AND ACL.ObjectId =

Jan 13 23:11:21 rt postgres[9386]: [2-6]  '1') OR (ACL.ObjectType =
'RT::FM::Class' AND ACL.ObjectId = '') OR (ACL.ObjectType =
'RT::FM::Article' AND ACL.ObjectId = ''))

Jan 13 23:11:21 rt postgres[9386]: [2-7]  AND ( ( ACL.PrincipalId =
Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain =
'SystemInternal' OR Groups.Domain

Jan 13 23:11:21 rt postgres[9386]: [2-8]  = 'UserDefined' OR
Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT
1

Jan 13 17:11:22 rt RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
zero-length string at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:247)

Jan 13 17:11:22 rt RT: RT::Handle=HASH(0x93c37bc) couldn't execute the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers
WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName = 'ShowArticle')
AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0  AND
Principals.id = Groups.id AND  Principals.id =
CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '12' AND (
ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::FM::System' AND
ACL.ObjectId = '1') OR (ACL.ObjectType = 'RT::FM::Class' AND
ACL.ObjectId = '') OR (ACL.ObjectType = 'RT::FM::Article' 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.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:247)

Jan 13 23:11:21 rt postgres[9386]: [3] ERROR:  pg_atoi: zero-length
string

Jan 13 23:11:21 rt postgres[9386]: [4-1] LOG:  statement:

Jan 13 23:11:21 rt postgres[9386]: [4-2]

Jan 13 23:11:21 rt postgres[9386]: [4-3]
SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE
(ACL.Ri
ghtName = 

Jan 13 23:11:21 rt postgres[9386]: [4-4]  'SuperUser' OR ACL.RightName =
'ShowArticle') AND Principals.Disabled = 0 AND
CachedGroupMembers.Disabled = 0 AND Principals.id

Jan 13 23:11:21 rt postgres[9386]: [4-5]  = Groups.id AND Principals.id
= CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '12' AND
( ACL.ObjectType =

Jan 13 23:11:22 rt postgres[9386]: [4-6]  'RT::System' OR
(ACL.ObjectType = 'RT::FM::System' AND ACL.ObjectId = '1') OR
(ACL.ObjectType = 'RT::FM::Class' AND

Jan 13 23:11:22 rt postgres[9386]: [4-7]  ACL.ObjectId = '') OR
(ACL.ObjectType = 'RT::FM::Article' AND ACL.ObjectId = '')) AND (
((Groups.Domain = 'RT::FM::System-Role'

Jan 13 23:11:22 rt postgres[9386]: [4-8]  AND Groups.Instance = 1) OR
(Groups.Domain = 'RT::FM::Class-Role' AND Groups.Instance = 0) OR
(Groups.Domain = Jan 13 23:11:22 rt postgres[9386]: [4-9]
'RT::FM::Article-Role' AND Groups.Instance = 0) ) AND Groups.Type =
ACL.PrincipalType AND Groups.Id = Principals.id AND

Jan 13 23:11:22 rt postgres[9386]: [4-10]  Principals.PrincipalType =
'Group') LIMIT 1 Jan 13 17:11:22 rt RT: DBD::Pg::st execute failed:
ERROR:  pg_atoi: zero-length string at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410
.  (/opt/rt3/lib/RT.pm:247)


--

Thanks again,

ph.