[rt-devel] [rt-users] RT dump import errors on postgresql 7.4

mixo mixo at coza.net.za
Fri Dec 19 07:45:57 EST 2003


For every user created I get the following messages in the logs
++++++++++++++++++++++++++++++++++++++
Wed Dec 17 11:19:15 2003] [warning]: Creating user xxxxxxxxx at
./dumpfile-to-rt-3.0-reverse-2 line 743.
(/opt/rt3/lib/RT.pm:247)
[Wed Dec 17 11:19:15 2003] [warning]: DBD::Pg::st execute failed:
ERROR:  invalid input syntax for integer: "xxxxxxxxxxxx" at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:247)
[Wed Dec 17 11:19:15 2003] [warning]: RT::Handle=HASH(0x8b71290)
couldn't execute the query 'SELECT  * FROM Users WHERE id = ?' at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:247)
++++++++++++++++++++++++++++++++++++++

And for every ticket I get the following with a JPEG attachment:
++++++++++++++++++++++++++++++++++++++
[Thu Dec 18 05:54:29 2003] [warning]: DBD::Pg::st execute failed:
ERROR:  unterminated quoted string at or near "'ÿØÿà" at character 368
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:247)
[Thu Dec 18 05:54:29 2003] [warning]: RT::Handle=HASH(0x8b71290)
couldn't execute the query 'INSERT INTO Attachments
(ContentType, Parent, id, Subject, Filename, Headers, Creator, Created,
Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 417.
(/opt/rt3/lib/RT.pm:247)
[Thu Dec 18 05:54:29 2003] [warning]: Couldn't create attachment
HASH(0x8c17f3c) $VAR1 = {
++++++++++++++++++++++++++++++++++++++
Which is followed by the attachment. For other binary attachments I get
a similar problem.

Should I be concened about these messages or can I ignore them? In are
the users, along with tickets
and the attachments being created?

By the way, the log is at about 845M.

_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm




More information about the Rt-devel mailing list