Re: [Health] Exception during installation of module icd10

[Leandro Poli]

Well, i figured it out.

TL;DR

PostgreSQL has no enought RAM, with 128MB (for small purposes on a LXC 
should go fine, no?), it blocked and started to swap when it tried to 
load the datasets.

Give more ram to your databases (at least 256MB), folks.

Regards.

El 28/5/19 a las 20:55, Leandro Poli escribió:
> I forgot a line, but it's about the diseases.xml file
>
> El 28/5/19 a las 20:43, Leandro Poli escribió:
> > Hi
> >
> > I've an issue when trying to install the icd10 module (part of health 
> > profile):
> >
> > 748 140205260875520 [2019-05-28 23:36:37,057] ERROR trytond.convert 
> > Error while parsing xml file:
> > In tag record: model gnuhealth.pathology with id T567.
> > Traceback (most recent call last):
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 448, in parse_xmlstream
> >     self.sax_parser.parse(source)
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 111, in parse
> >     xmlreader.IncrementalParser.parse(self, source)
> >   File "/usr/lib/python3.6/xml/sax/xmlreader.py", line 125, in parse
> >     self.feed(buffer)
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 217, in feed
> >     self._parser.Parse(data, isFinal)
> >   File "../Modules/pyexpat.c", line 468, in EndElement
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 336, in 
> > end_element
> >     self._cont_handler.endElement(name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 508, in endElement
> >     self.taghandler = self.taghandler.endElement(name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 290, in endElement
> >     self.model.__name__, self.values, self.xml_id)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 694, in import_record
> >     self.create_records(model, [values], [fs_id])
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 700, in create_records
> >     records = Model.create(vlist)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelsql.py", 
> > line 605, in create
> >     cls._validate(sub_records)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 37, in wrapper
> >     return func(*args, **kwargs)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 1091, in _validate
> >     getattr(record, field_name), field_name, field)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/fields/field.py", 
> > line 283, in __get__
> >     return inst.__getattr__(self.name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 1436, in __getattr__
> >     read_data = self.read(list(ids), list(ffields.keys()))
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelsql.py", 
> > line 724, in read
> >     Transaction().language, ids)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/ir/translation.py", 
> > line 469, in get_ids
> >     where=where))
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/backend/postgresql/database.py", 
> > line 60, in execute
> >     cursor.execute(self, sql, args)
> > psycopg2.OperationalError: SSL SYSCALL error: EOF detected
> >
> > 748 140205260875520 [2019-05-28 23:36:37,110] ERROR 
> > trytond.protocols.dispatcher <class 
> > 'trytond.ir.module.ModuleActivateUpgrade'>.execute(*(6, {'start': 
> > {'module_info': 'company: to activate\ncountry: to 
> > activate\ncurrency: to activate\nhealth: to 
> > activate\nhealth_genetics: to activate\nhealth_gyneco: to 
> > activate\nhealth_icd10: to activate\nhealth_inpatient: to 
> > activate\nhealth_lab: to activate\nhealth_lifestyle: to 
> > activate\nhealth_pediatrics: to activate\nhealth_profile: to 
> > activate\nhealth_socioeconomics: to activate\nhealth_surgery: to 
> > activate\nparty: to activate\nproduct: to activate', 'id': -4}}, 
> > 'upgrade', {'language': 'en', 'groups': [1], 'active_model': 
> > 'ir.module', 'language_direction': 'ltr', 'active_ids': [18], 
> > 'active_id': 18, 'action_id': 45}), **{}) from 
> > address@hidden//gnuhealth/
> > Traceback (most recent call last):
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/modules/__init__.py", 
> > line 467, in load_modules
> >     _load_modules(update)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/modules/__init__.py", 
> > line 432, in _load_modules
> >     load_module_graph(graph, pool, update, lang)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/modules/__init__.py", 
> > line 258, in load_module_graph
> >     tryton_parser.parse_xmlstream(fp)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 448, in parse_xmlstream
> >     self.sax_parser.parse(source)
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 111, in parse
> >     xmlreader.IncrementalParser.parse(self, source)
> >   File "/usr/lib/python3.6/xml/sax/xmlreader.py", line 125, in parse
> >     self.feed(buffer)
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 217, in feed
> >     self._parser.Parse(data, isFinal)
> >   File "../Modules/pyexpat.c", line 468, in EndElement
> >   File "/usr/lib/python3.6/xml/sax/expatreader.py", line 336, in 
> > end_element
> >     self._cont_handler.endElement(name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 508, in endElement
> >     self.taghandler = self.taghandler.endElement(name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 290, in endElement
> >     self.model.__name__, self.values, self.xml_id)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 694, in import_record
> >     self.create_records(model, [values], [fs_id])
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/convert.py", 
> > line 700, in create_records
> >     records = Model.create(vlist)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelsql.py", 
> > line 605, in create
> >     cls._validate(sub_records)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 37, in wrapper
> >     return func(*args, **kwargs)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 1091, in _validate
> >     getattr(record, field_name), field_name, field)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/fields/field.py", 
> > line 283, in __get__
> >     return inst.__getattr__(self.name)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelstorage.py", 
> > line 1436, in __getattr__
> >     read_data = self.read(list(ids), list(ffields.keys()))
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/model/modelsql.py", 
> > line 724, in read
> >     Transaction().language, ids)
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/ir/translation.py", 
> > line 469, in get_ids
> >     where=where))
> >   File 
> > "/home/gnuhealth/gnuhealth/tryton/server/trytond-4.6.15/trytond/backend/postgresql/database.py", 
> > line 60, in execute
> >     cursor.execute(self, sql, args)
> > psycopg2.OperationalError: SSL SYSCALL error: EOF detected
> >
> > Maybe the data related to the xml is corrupted?
> >
> > Regards