Ticket create error DBD::Pg::st execute failed: ERROR: invalid input

RT Users
1

Get this error on some incoming e-mails:

[230110] [Mon Nov 14 00:36:43 2022] [warning]: DBD::Pg::st execute failed: ERROR:  invalid input syntax for type bytea
CONTEXT:  unnamed portal parameter $2 = '...' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 622. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:622)

And in PostgreSQL log have this:

2022-11-14 00:36:43.284 EET [230120] xxx@rt5 ERROR:  invalid input syntax for type bytea
2022-11-14 00:36:43.284 EET [230120] xxx@rt5 CONTEXT:  unnamed portal parameter $2 = '...'
2022-11-14 00:36:43.284 EET [230120] xxx@rt5 STATEMENT:  INSERT INTO Attachments (Creator, Content, Parent, TransactionId, ContentEncoding, ContentType, Headers, MessageId, Created, Subject, Filename) VALUES ($1, $2, $3, ...
2022-11-14 00:36:43.289 EET [230120] xxx@rt5 ERROR:  current transaction is aborted, commands ignored until end of transaction block

Problems is causing Content column. Column number $2 is changing because column order is changing on insert.
In PostgreSQL log have lot of error rows on attachment insert followed by dropping legal queries after error:

2022-11-14 00:36:43.845 EEST [61903] xxx@rt5 STATEMENT:  SELECT  * FROM Tickets WHERE id = $1
2022-11-14 00:36:43.849 EEST [61903] xxx@rt5 ERROR:  current transaction is aborted, commands ignored until end of transaction block
2022-11-14 00:36:43.849 EEST [61903] xxx@rt5 STATEMENT:  SELECT * FROM Tickets WHERE id = $1 FOR UPDATE
2022-11-14 00:36:43.854 EEST [61903] xxx@rt5 ERROR:  current transaction is aborted, commands ignored until end of transaction block
2022-11-14 00:36:43.854 EEST [61903] xxx@rt5 STATEMENT:  UPDATE Tickets SET LastUpdated=$1 WHERE id=$2
2022-11-14 00:36:43.858 EEST [61903] xxx@rt5 ERROR:  current transaction is aborted, commands ignored until end of transaction block
2022-11-14 00:36:43.858 EEST [61903] xxx@rt5 STATEMENT:  UPDATE Tickets SET LastUpdatedBy=$1 WHERE id=$2
2022-11-14 00:36:43.864 EEST [61903] xxx@rt5 ERROR:  current transaction is aborted, commands ignored until end of transaction block
2022-11-14 00:36:43.864 EEST [61903] xxx@rt5 STATEMENT:  SELECT  * FROM Tickets WHERE id = $1

Using latest RT (5.0.3) with latest RTIR (5.0.3)

2

Was there ever an issue / bug track opened on this? it’s definitely still an issue in RT 5.0.6, wonder if anyone knows if it’s been resolved in future iterations?

3

Never seen that error on 5.0.8.

I don’t know if it was happening in 5.0.5 (previous version installed).

4

After moving to RT6 this is not relevant anymore

5

Greetings Girts,

Can you plz clarify what you mean? Were you having this error previously, but are no longer having it after upgrading to RT6 ?