[rt-users] SQL error from Pg on 4.0.21

[Bill McGonigle]

On 07/22/2014 01:10 PM, Bill McGonigle wrote:
> I did see this backtrace, but I'm not sure at which point the query is built (looks like DBIx::SearchBuilder::_DoSearch gets a perl object and builds the SQL?)

Maybe I see what's going on - I've got some mysql code paths being called.  I wonder if I messed up the config.

I have:

  Set($DatabaseType , 'Pg');

And it _is_ mostly working, so I gotta figure it's finding the right database (using the right DBD, etc.).  So ... odd.

-Bill

[26226] [Tue Jul 22 16:52:53 2014] [warning]: DBD::Pg::st execute failed: ERROR:  function last_insert_id() does not exist
LINE 1: SELECT LAST_INSERT_ID()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 589. (/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm:589)
[26226] [Tue Jul 22 16:52:53 2014] [warning]: RT::Handle=HASH(0x7f238c35c538) couldn't execute the query 'SELECT LAST_INSERT_ID()' at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 602.
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7f238c35c538)', 'SELECT LAST_INSERT_ID()') called at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 634
        DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0x7f238c35c538)', 'SELECT LAST_INSERT_ID()') called at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle/mysql.pm line 44
        DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7f238c35c538)', 'Tickets', 'Subject', 'openstack for Boston', 'Status', 'new', 'Queue', 5, 'Creator', ...) called at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record.pm line 1320
        DBIx::SearchBuilder::Record::Create('RT::Ticket=HASH(0x7f238cb99360)', 'Subject', 'openstack for Boston', 'Status', 'new', 'Queue', 5, 'Creator', 22, ...) called at /usr/share/perl5/vendor_perl/RT/Record.pm line 316


-- 
Bill McGonigle, Owner   
BFC Computing, LLC       
http://bfccomputing.com/ 
Telephone: +1.855.SW.LIBRE
Email, IM, VOIP: bill at bfccomputing.com           
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle