Mi sa che ho fatto qualche casino aggiornando postgis alla 2.1.8, dopo aver installato i moduli GEOBi...adesso non riesco più a far partire il server di produzione ed ho questo errore:
2015-07-07 15:35:52,821 17899 ERROR emervol openerp.netsvc: geometry_columns table seems to be corrupted. SRID check is not possible
Traceback (most recent call last):
File "/opt/openerp/lp/openerp/openerp/netsvc.py", line 296, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/lp/openerp/openerp/service/web_services.py", line 433, in dispatch
return fn(*params)
File "/opt/openerp/lp/openerp/openerp/service/web_services.py", line 444, in exp_authenticate
res_users = pooler.get_pool(db).get('res.users')
File "/opt/openerp/lp/openerp/openerp/pooler.py", line 49, in get_pool
return get_db_and_pool(db_name, force_demo, status, update_module)[1]
File "/opt/openerp/lp/openerp/openerp/pooler.py", line 33, in get_db_and_pool
registry = RegistryManager.get(db_name, force_demo, status, update_module)
File "/opt/openerp/lp/openerp/openerp/modules/registry.py", line 203, in get
update_module)
File "/opt/openerp/lp/openerp/openerp/modules/registry.py", line 233, in new
openerp.modules.load_modules(registry.db, force_demo, status, update_module)
File "/opt/openerp/lp/openerp/openerp/modules/loading.py", line 350, in load_modules
force, status, report, loaded_modules, update_module)
File "/opt/openerp/lp/openerp/openerp/modules/loading.py", line 256, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/opt/openerp/lp/openerp/openerp/modules/loading.py", line 165, in load_module_graph
init_module_models(cr, package.name, models)
File "/opt/openerp/lp/openerp/openerp/modules/module.py", line 374, in init_module_models
result = obj._auto_init(cr, {'module': module_name})
File "/opt/openerp/lp/openerp/openerp/addons/base_geoengine/geo_model.py", line 63, in _auto_init
cursor, kol, geo_columns[kol], self._table, self._name)
File "/opt/openerp/lp/openerp/openerp/addons/base_geoengine/geo_field.py", line 121, in manage_db_column
self.update_geo_column(cursor, col_name, geo_columns, table, model)
File "/opt/openerp/lp/openerp/openerp/addons/base_geoengine/geo_field.py", line 156, in update_geo_column
"geometry_columns table seems to be corrupted. "
Exception: geometry_columns table seems to be corrupted. SRID check is not possible
la geometry_columuns e' una vista pero'...non ho idea di come uscirne...posso provare a cancellare il modulo base_geospatial e vedere se accedo al sistema e poi rimuovo tutto quanto riguarda i moduli GEOBi?
Grazie a tutti...sono in mezzo ad una strada!