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

[Neal Caidin]

HI Francois,

Thank you for the update!

Neal


On Mon, Mar 2, 2015 at 7:02 AM, Francois Campbell <francois at opencollab.co.za
> wrote:

> 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
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20150302/9d75b224/attachment.html