Thanks, that would have been easier.
What I ended up doing was dropping the tables and removing the table
files.
then a restart got everything back in sync again. That only worked because
I didn't need to keep any of the data in the scheduler tables.
Brad
On Tuesday, May 23, 2017 at 1:03:13 PM UTC-5, Dave S wrote:
>
>
>
> On Tuesday, May 23, 2017 at 5:30:08 AM UTC-7, Brad Miller wrote:
>>
>> Due to a forced migration to new hardware/os on webfaction, I just
>> recently had to upgrade from 2.5.1 to 2.14.6.
>>
>> In the process I have managed to get myself into a state where the
>> scheduler schema is wrong. (I'm using postgresql)
>>
>> I get the following error:
>>
>> ProgrammingError: ('ERROR', '42703', 'column "prevent_drift" of relation
>> "scheduler_task" does not exist')
>>
>>
>> This is probably my fault as in my haste to get everything up and live
>> again I did a fake_migrate_all=True (the app was crashing because it said
>> the session table already existed.)
>>
>>
>> I have all my application tables prefixed with my app name for migration
>> purposes:
>>
>> runestone_my_table.table. for example. however the scheduler and the
>> session tables are still getting the default:
>>
>> 033e652b5c024094757cfc1050e7ecda_scheduler_run.table
>> 033e652b5c024094757cfc1050e7ecda_scheduler_task.table
>> 033e652b5c024094757cfc1050e7ecda_scheduler_worker.table
>> 409096731cda32e62dcf6bbed574f3d5_web2py_session_runestone.table
>>
>> Everything except my scheduler processes is back on line. Is there any
>> way to make the scheduler update its schema given the state I am in??
>>
>> Thanks
>>
>> Brad
>>
>
>
> I think you want to set "migrate" (not "fake_migrate" this time) to true,
> do one access to any function in your app, and then turn "migrate" off
> again.
>
> Setting the "fake_migrate" updated your table files (the web2py side of
> the pipe), but now you need to update the actual DB tables.
>
> If you've got the appconfig.ini set up (as part of your upgrade), then
> that's easy to do, but it's not much harder if you have to set it in your
> model.
>
>
> /dps
>
>
> /dps
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
