Skip to content

Instantly share code, notes, and snippets.

@wesyoung
Created June 10, 2015 15:35
Show Gist options
  • Save wesyoung/db5401217773d4ca6a35 to your computer and use it in GitHub Desktop.
Save wesyoung/db5401217773d4ca6a35 to your computer and use it in GitHub Desktop.
[1983] [Wed Jun 10 15:30:16 2015] [warning]: DBD::Pg::st execute failed: ERROR: syntax error at or near "WHERE"
LINE 1: ...ELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....
^ at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 586, <$handle> line 1. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:586)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: RT::Handle=HASH(0x477ed38) couldn't execute the query 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id AND t.Type = 'ticket' AND t.Queue = ? AND ((txn.Type = 'Set' AND txn.Field = 'Status') OR txn.Type = 'Status'))' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 599, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x477ed38)', 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Tran...', 3) called at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 527
DBIx::SearchBuilder::Handle::DeleteFromSelect('RT::Handle=HASH(0x477ed38)', 'Transactions', 'SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....', 3) called at ./etc/upgrade/2.9.0/content line 256
RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
RT::Handle::InsertData('RT::Handle=HASH(0x477ed38)', './etc/upgrade/2.9.0/content', undef) called at /opt/rt4/sbin/rt-setup-database line 386
main::__ANON__() called at /opt/rt4/sbin/rt-setup-database line 399
main::action_insert('package', 'RT::IR', 'ext-version', 3.2.0, 'dba', 'postgres', 'action', 'upgrade', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 567
main::action_upgrade('package', 'RT::IR', 'prompt-for-dba-password', 1, 'ext-version', 3.2.0, 'dba', 'postgres', 'action', ...) called at /opt/rt4/sbin/rt-setup-database line 210 (/usr/share/perl/5.18/Carp.pm:103)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: Use of uninitialized value $res in concatenation (.) or string at ./etc/upgrade/2.9.0/content line 257, <$handle> line 1. (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [error]: Couldn't delete transactions: (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: DBD::Pg::st execute failed: ERROR: syntax error at or near "WHERE"
LINE 1: ...ELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....
^ at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 586, <$handle> line 1. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:586)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: RT::Handle=HASH(0x477ed38) couldn't execute the query 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id AND t.Type = 'ticket' AND t.Queue = ? AND ((txn.Type = 'Set' AND txn.Field = 'Status') OR txn.Type = 'Status'))' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 599, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x477ed38)', 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Tran...', 4) called at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 527
DBIx::SearchBuilder::Handle::DeleteFromSelect('RT::Handle=HASH(0x477ed38)', 'Transactions', 'SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....', 4) called at ./etc/upgrade/2.9.0/content line 256
RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
RT::Handle::InsertData('RT::Handle=HASH(0x477ed38)', './etc/upgrade/2.9.0/content', undef) called at /opt/rt4/sbin/rt-setup-database line 386
main::__ANON__() called at /opt/rt4/sbin/rt-setup-database line 399
main::action_insert('package', 'RT::IR', 'ext-version', 3.2.0, 'dba', 'postgres', 'action', 'upgrade', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 567
main::action_upgrade('package', 'RT::IR', 'prompt-for-dba-password', 1, 'ext-version', 3.2.0, 'dba', 'postgres', 'action', ...) called at /opt/rt4/sbin/rt-setup-database line 210 (/usr/share/perl/5.18/Carp.pm:103)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: Use of uninitialized value $res in concatenation (.) or string at ./etc/upgrade/2.9.0/content line 257, <$handle> line 1. (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [error]: Couldn't delete transactions: (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: DBD::Pg::st execute failed: ERROR: syntax error at or near "WHERE"
LINE 1: ...ELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....
^ at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 586, <$handle> line 1. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:586)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: RT::Handle=HASH(0x477ed38) couldn't execute the query 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id AND t.Type = 'ticket' AND t.Queue = ? AND ((txn.Type = 'Set' AND txn.Field = 'Status') OR txn.Type = 'Status'))' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 599, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x477ed38)', 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Tran...', 5) called at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 527
DBIx::SearchBuilder::Handle::DeleteFromSelect('RT::Handle=HASH(0x477ed38)', 'Transactions', 'SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....', 5) called at ./etc/upgrade/2.9.0/content line 256
RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
RT::Handle::InsertData('RT::Handle=HASH(0x477ed38)', './etc/upgrade/2.9.0/content', undef) called at /opt/rt4/sbin/rt-setup-database line 386
main::__ANON__() called at /opt/rt4/sbin/rt-setup-database line 399
main::action_insert('package', 'RT::IR', 'ext-version', 3.2.0, 'dba', 'postgres', 'action', 'upgrade', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 567
main::action_upgrade('package', 'RT::IR', 'prompt-for-dba-password', 1, 'ext-version', 3.2.0, 'dba', 'postgres', 'action', ...) called at /opt/rt4/sbin/rt-setup-database line 210 (/usr/share/perl/5.18/Carp.pm:103)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: Use of uninitialized value $res in concatenation (.) or string at ./etc/upgrade/2.9.0/content line 257, <$handle> line 1. (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [error]: Couldn't delete transactions: (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: DBD::Pg::st execute failed: ERROR: syntax error at or near "WHERE"
LINE 1: ...ELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....
^ at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 586, <$handle> line 1. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:586)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: RT::Handle=HASH(0x477ed38) couldn't execute the query 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id AND t.Type = 'ticket' AND t.Queue = ? AND ((txn.Type = 'Set' AND txn.Field = 'Status') OR txn.Type = 'Status'))' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 599, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x477ed38)', 'DELETE FROM Transactions WHERE id IN (SELECT txn.id FROM Tran...', 6) called at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 527
DBIx::SearchBuilder::Handle::DeleteFromSelect('RT::Handle=HASH(0x477ed38)', 'Transactions', 'SELECT txn.id FROM Transactions txn JOIN Tickets t WHERE txn....', 6) called at ./etc/upgrade/2.9.0/content line 256
RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 1272
RT::Handle::InsertData('RT::Handle=HASH(0x477ed38)', './etc/upgrade/2.9.0/content', undef) called at /opt/rt4/sbin/rt-setup-database line 386
main::__ANON__() called at /opt/rt4/sbin/rt-setup-database line 399
main::action_insert('package', 'RT::IR', 'ext-version', 3.2.0, 'dba', 'postgres', 'action', 'upgrade', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 567
main::action_upgrade('package', 'RT::IR', 'prompt-for-dba-password', 1, 'ext-version', 3.2.0, 'dba', 'postgres', 'action', ...) called at /opt/rt4/sbin/rt-setup-database line 210 (/usr/share/perl/5.18/Carp.pm:103)
[1983] [Wed Jun 10 15:30:16 2015] [warning]: Use of uninitialized value $res in concatenation (.) or string at ./etc/upgrade/2.9.0/content line 257, <$handle> line 1. (./etc/upgrade/2.9.0/content:257)
[1983] [Wed Jun 10 15:30:16 2015] [error]: Couldn't delete transactions: (./etc/upgrade/2.9.0/content:257)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment