Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and sessions table dropped and re-created from Schema in rt3.sql dump we
are seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=’%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’’%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802
I have cleared old cookies and caches etc …
Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.
RT version? Show us how your new sessions table looks.
SHOW CREATE TABLE sessions;On Fri, Jan 6, 2012 at 15:56, o.nash@cs.ucc.ie wrote:
Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802
I have cleared old cookies and caches etc …
Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.
Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
| Table | Create Table
|
| sessions | CREATE TABLE sessions ( id char(32) NOT NULL, a_session longtext, LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
1 row in set (0.00 sec)
mysql>
thanks
OliverOn Sun, 8 Jan 2012, Ruslan Zakirov wrote:
Hi,
RT version? Show us how your new sessions table looks.
Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802
I have cleared old cookies and caches etc …
Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.
a_session column should be blob not text.On Mon, Jan 9, 2012 at 01:59, o.nash@cs.ucc.ie wrote:
Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE sessions ( id char(32) NOT NULL, a_session longtext, LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
thanks
Oliver
On Sun, 8 Jan 2012, Ruslan Zakirov wrote:
Hi,
RT version? Show us how your new sessions table looks.
Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] "GET
Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE sessions ( id char(32) NOT NULL, a_session longtext, LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
thanks
Oliver
On Sun, 8 Jan 2012, Ruslan Zakirov wrote:
Hi,
RT version? Show us how your new sessions table looks.
Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] "GET