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
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.