This question has been flagged
1 Reply
3663 Views

Error Info

 

Does this need to adjust something of postgresql?

 

Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1427, in load action = req.session.model(action_type).read([action_id], False, ctx) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info) Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 296, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 190, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 132, in wrapper return f(self, dbname, *args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 199, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 187, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3679, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3800, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/usr/lib/pymodules/python2.7/openerp/osv/fields.py", line 1145, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_actions.py", line 211, in _search_view 'search', context=context) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 2278, in fields_view_get xarch, xfields = self.__view_look_dom_arch(cr, user, result['arch'], view_id, context=ctx) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1930, in __view_look_dom_arch fields = self.fields_get(cr, user, None, context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/res/res_users.py", line 849, in fields_get res = super(users_view, self).fields_get(cr, uid, allfields, context, write_access) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3582, in fields_get res.update(self.pool.get(parent).fields_get(cr, user, allfields, context)) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3611, in fields_get val2 = translation_obj._get_source(cr, user, self._name + ',' + f, 'selection', context['lang'], val) File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 18, in lookup r = self.lookup(self2, cr, *args) File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 46, in lookup value = d[key] = self.method(self2, cr, *args) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_translation.py", line 329, in _get_source cr.execute(query, params) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper return f(self, *args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) InternalError: index "ir_translation_src_hash_idx" contains unexpected zero page at block 0 HINT: Please REINDEX it.

Avatar
Discard
Best Answer

If you look at the end of the server traceback, it seems like the error is:

InternalError: index "ir_translation_src_hash_idx" contains unexcpected zero page at block 0

And PostgreSQL gives you a "hint":

Please REINDEX it

So it seems like a database corruption problem, something happened to that index. See this.

To reindex use REINDEX INDEX ir_translation_src_hash_idx from psql.

Avatar
Discard