[rt-devel] Re: incompatibility with Postgres 7.3

[Louis-David Mitterrand]

On Thu, Feb 20, 2003 at 12:34:02PM -0500, Jesse Vincent wrote:
> Can you send a _specific_ bug report in, then? I was fairly sure that
> all of the atoi stuff had been dealt with in the 2.1.x series.

OK, here is how to reproduce the bug:

- select new ticket from drop-down list,
- enter ONLY suject and description,
- press Create,
- boom!

The mason error in itself is not really interesting:

	error:   DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/share/perl5/Apache/Session/Store/DBI.pm line 65.
	context: 
	... 
	277:  }
	278: 
	279:  # All errors returned from this routine will be in exception form.
	280:  local $SIG{'__DIE__'} = sub {
	281:  rethrow_exception( $_[0] );
	282:  };
	283: 
	284:  #
	285:  # $m is a dynamically scoped global containing this

The Apache error log tells more:

[Fri Feb 21 10:07:53 2003] [warning]: DBD::Pg::st execute failed: ERROR:  pg_ato
i: zero-length string at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.
 (/usr/local/rt3/lib/RT.pm:220)
[Fri Feb 21 10:07:53 2003] [warning]: RT::Handle=HASH(0x9f8c1b0) couldn't execut
e the query 'INSERT INTO Tickets (TimeEstimated, Status, Queue, Type, InitialPri
ority, Starts, TimeWorked, LastUpdated, Subject, FinalPriority, TimeLeft, Creato
r, Owner, LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder
/Handle.pm line 383.
 (/usr/local/rt3/lib/RT.pm:220)

On another queue I had a different error (GESCI is the queue name):

[Fri Feb 21 09:53:30 2003] [warning]: DBD::Pg::st execute failed: ERROR:  pg_ato
i: error in "GESCI": can't parse "GESCI" at /usr/share/perl5/DBIx/SearchBuilder.
pm line 134.
 (/usr/local/rt3/lib/RT.pm:220)
[Fri Feb 21 09:53:30 2003] [warning]: DBIx::SearchBuilder error:ERROR:  pg_atoi:
 error in "GESCI": can't parse "GESCI"
    Query String is SELECT DISTINCT main.* FROM CustomFields main   WHERE ((main
.Disabled = '0')) AND ((main.Queue = 'GESCI')OR(main.Queue = '0'))  ORDER BY mai
n.SortOrder ASC
 (/usr/local/rt3/lib/RT.pm:220)

-- 
ldm at apartia.org