I have a strange situation that is not allowing me to upgrade the DB from version 6.0 to 6.8. I have followed all the migration steps according the to existing documentation. However, on a particular DB, when I issue the following command:
trytond-admin -c <config> --all -d company
I get the following error:
Traceback (most recent call last):
File "/home/richi/work/pyenv/tryton68/bin/trytond-admin", line 7, in <module>
exec(compile(f.read(), __file__, 'exec'))
File "/home/richi/work/tryton60/tryton_src/trytond/bin/trytond-admin", line 31, in <module>
admin.run(options)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/admin.py", line 57, in run
pool.init(update=options.update, lang=list(lang),
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/pool.py", line 167, in init
restart = not load_modules(
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 453, in load_modules
_load_modules(update)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 415, in _load_modules
graph = create_graph(module_list)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 157, in create_graph
raise MissingDependenciesException(list(missing))
trytond.exceptions.MissingDependenciesException: Missing dependencies: stock_shipment_cost
I checked that stock_shipment_cost is present in the modules folder as well as ensure that .hook/link_modules created the links.
Also when I try to upgrade this particular stock_shipment_cost module i.e.:
trytond-admin -c <config> -u stock_shipment_cost -d company
I get this following error:
Traceback (most recent call last):
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 464, in parse_xmlstream
self.sax_parser.parse(source)
File "/usr/lib/python3.8/xml/sax/expatreader.py", line 111, in parse
xmlreader.IncrementalParser.parse(self, source)
File "/usr/lib/python3.8/xml/sax/xmlreader.py", line 125, in parse
self.feed(buffer)
File "/usr/lib/python3.8/xml/sax/expatreader.py", line 217, in feed
self._parser.Parse(data, isFinal)
File "../Modules/pyexpat.c", line 407, in StartElement
File "/usr/lib/python3.8/xml/sax/expatreader.py", line 333, in start_element
self._cont_handler.startElement(name, AttributesImpl(attrs))
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 496, in startElement
self.taghandler.startElement(name, attributes)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 258, in startElement
model, id_ = self.mh.get_id(ref_attr)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 536, in get_id
if self.fs2db.get(module, xml_id) is None:
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 340, in get
self.fetch_new_module(module)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 408, in fetch_new_module
records = Model.search([
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/model/modelsql.py", line 1749, in search
cursor.execute(*select)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/backend/postgresql/database.py", line 68, in execute
cursor.execute(self, sql, args)
psycopg2.errors.UndefinedColumn: column a.allow_pickup does not exist
LINE 1: ..."active" AS "active", "a"."address" AS "address", "a"."allow...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/richi/work/pyenv/tryton68/bin/trytond-admin", line 7, in <module>
exec(compile(f.read(), __file__, 'exec'))
File "/home/richi/work/tryton60/tryton_src/trytond/bin/trytond-admin", line 31, in <module>
admin.run(options)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/admin.py", line 57, in run
pool.init(update=options.update, lang=list(lang),
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/pool.py", line 167, in init
restart = not load_modules(
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 453, in load_modules
_load_modules(update)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 421, in _load_modules
load_module_graph(graph, pool, update, lang)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/modules/__init__.py", line 255, in load_module_graph
tryton_parser.parse_xmlstream(fp)
File "/home/richi/work/tryton60/tryton_src/trytond/trytond/convert.py", line 466, in parse_xmlstream
raise ParsingError("in %s" % self.current_state()) from e
trytond.convert.ParsingError: in record 'stock_shipment_cost.stock_move_view_form'
I checked the views in the stock_shipment_cost module but nothing seem to be wrong. What is really strange is that stock_shipment_cost module is currently inactive on this particular DB, hence there are no dependencies.
Anyone has any idea what I may have done wrong?