the error you've seen has nothing to do with either $@ or "$@". it just
signalled that you had a migration error. once you deleted both metadata
and the underlying tables, everything was fixed.
On Monday, November 7, 2016 at 6:28:22 PM UTC+1, Mirek Zvolský wrote:
>
> I use Debian (testing), Postgres 9.4,
> and Web2py 2.14.6 (with current trunk is problem the same)
>
> I use such command (assigned to an alias) for long time to start my
> application
> python web2py.py -K codex2020 -X $@
>
> Today I received strange behaviour, errors like
> web2py.scheduler TICKER: error assigning tasks
> or such something (with no effect if I have deleted scheduler_* tables and
> their databases/ metadata earlier)
> starting scheduler for "codex2020"...
> Currently running 1 scheduler processes
> Traceback (most recent call last):
> File "/home/mirek/mz/web2py/gluon/restricted.py", line 227, in restricted
> exec ccode in environment
> File "applications/codex2020/models/scheduler.py", line 80, in <module>
> scheduler = Scheduler(db)
> File "/home/mirek/mz/web2py/gluon/scheduler.py", line 567, in __init__
> self.define_tables(db, migrate=migrate)
> File "/home/mirek/mz/web2py/gluon/scheduler.py", line 659, in
> define_tables
> migrate=self.__get_migrate('scheduler_worker', migrate)
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/base.py", line 834,
> in define_table
> table = self.lazy_define_table(tablename,*fields,**args)
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/base.py", line 873,
> in lazy_define_table
> polymodel=polymodel)
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 510, in create_table
> fake_migrate=fake_migrate
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 623, in migrate_table
> self.execute(sub_query)
> File
> "/home/mirek/mz/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line
> 362, in execute
> return BaseAdapter.execute(self, *a, **b)
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 1388, in execute
> return self.log_execute(*a, **b)
> File "/home/mirek/mz/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 1382, in log_execute
> ret = self.get_cursor().execute(command, *a[1:], **b)
> ProgrammingError: column "worker_stats__tmp" is of type json but
> expression is of type text
> LINE 1: UPDATE scheduler_worker SET worker_stats__tmp=worker_stats;
> ^
> HINT: You will need to rewrite or cast the expression.
>
> Then I decided then if I run without $@, all will start well:
> python web2py.py -K codex2020 -X
>
> After testing of everything I went back to:
> python web2py.py -K codex2020 -X $@
> or
> python web2py.py -K codex2020 -X "$@"
>
> and I have now no more the previous problem. All works well.
>
> Has somebody any idea about the reason of problems
> and can you explain me the difference between $@ and "$@". Which one is
> more safe to use? Is there a difference?
>
> Thanks...
>
--
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.
