Hi RT gang, recently we've started experiencing what looks like database errors in our RT 3.4.2 installation. We're using it with PostgreSQL 7.4.17 on RHEL4, and get some errors in the web interface like the following:
error: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block context: ... 63: 64: $self->{update_sth}->bind_param(1, $session->{serialized}); 65: $self->{update_sth}->bind_param(2, $session->{data}->{_session_id}); 66: 67: $self->{update_sth}->execute; 68: 69: $self->{update_sth}->finish; 70: } 71: ... code stack: /usr/lib/perl5/site_perl/5.8.5/Apache/Session/Store/DBI.pm:67 /usr/lib/perl5/site_perl/5.8.5/Apache/Session.pm:523 /usr/lib/perl5/site_perl/5.8.5/Apache/Session.pm:477 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:1078 raw error In the RT log there are a lot of messages (most of which look like diagnostics) but this one caught my eye: [Mon Jul 9 21:17:29 2007] [warning]: DBD::Pg::st execute failed: ERROR: access to noncontiguous page in hash index "transactions_oid" (/opt/rt3/lib/RT.pm:277) The only thing that occurred to me was that the indexes needed rebuilding on that table, which I did, but the problem has come back. I'm not sure if the error messages are related. I also have reports from users that they get errors like "message not recorded" when adding comments occasionally. Any ideas what all this might mean? -- Regards, Oliver _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com