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

[Francois Campbell]

Please ignore.

After further troubleshooting, we found it to have been an update that
slipped into one of our in-house tools via human error.

Apologies for any wasted time and effort.


Regards
*Francois Campbell*
 Java Developer





On 2 March 2015 at 11:54, Francois Campbell <francois at opencollab.co.za>
wrote:

> 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/991298a3/attachment.html