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

mixo mixo at coza.net.za
Fri Dec 19 04:38:35 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:
++++++++++++++++++++++++++++++++++++++
[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 follwed by the attachment.

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.




More information about the rt-users mailing list