On Fri, Aug 02, 2013 at 11:21:24AM -0400, Asif Iqbal wrote: > On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone > <[1][email protected]> wrote: > > You can look at 'show create table sessions' which should be innodb > not myisam and look at your Attributes table, which should have a > LONGBLOB for Content. > > I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / > mysql 5.5.32 > but session table still showing myisam. > $ mysql -e 'use rt4; show create table sessions' > | sessions | CREATE TABLE `sessions` ( > `id` varbinary(32) NOT NULL DEFAULT '', > `a_session` longblob, > `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE > CURRENT_TIMESTAMP, > PRIMARY KEY (`id`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | > I guess I can just ALTER the session table now?
Please show a log of your make upgrade-database step One of the steps explicitly drops and recreates the sessions table. -kevin
pgpKmzGNJ98Sj.pgp
Description: PGP signature
