[Building Sakai] Job Scheduler table data lost when upgrading from Sakai 2.9.3 upgrade to Sakai 10.1 - MySQL

[Francois Campbell]

Good day.

When upgrading from Sakai 2.9.3 upgrade to Sakai 10.1 using the database
conversion scripts we lose the existing qrtz _* table data.

We checked the upgrade scripts and there are only 3 statements which affect
the QRTZ tables.
Went through the mysql upgrade scripts, there was only 3 statements that
affected any of the QRTZ tables, they are listed below:

-- Drop column
ALTER TABLE QRTZ_SCHEDULER_STATE DROP COLUMN RECOVERER;

-- Increase size
ALTER TABLE QRTZ_SIMPLE_TRIGGERS MODIFY TIMES_TRIGGERED BIGINT(10) NOT NULL;

-- Increase size
ALTER TABLE QRTZ_CRON_TRIGGERS MODIFY CRON_EXPRESSION VARCHAR(120) NOT NULL;

When I restored the backup database and ran only these 3 statements the
tables were altered but no data was removed. Any ideas what could be
destroying the data from these tables when upgrading?

--
Regards
*Francois Campbell*
 Java Developer

-- 

------------------------------
See OpenCollab email disclaimer at 
http://www.opencollab.co.za/email-disclaimer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20150302/ca8fc2c3/attachment.html