Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Odoo V8 : Server Error - OperationalError: could not read block 4 in file "base/449508/455055": Input/output error

By
Frank Carll
on 8/14/15, 3:11 PM 466 views

When trying to create a new product, I get the following traceback message.  I can pull up existing products but cannot edit them without getting a similar error message.


Traceback (most recent call last):

File "/opt/odoo/openerp/http.py", line 530, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/opt/odoo/openerp/http.py", line 567, in dispatch

result = self._call_function(**self.params)

File "/opt/odoo/openerp/http.py", line 303, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/opt/odoo/openerp/service/model.py", line 113, in wrapper

return f(dbname, *args, **kwargs)

File "/opt/odoo/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/opt/odoo/openerp/http.py", line 796, in __call__

return self.method(*args, **kw)

File "/opt/odoo/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/opt/odoo/addons/web/controllers/main.py", line 935, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/opt/odoo/addons/web/controllers/main.py", line 927, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/product/product.py", line 715, in create

self.create_variant_ids(cr, uid, [product_template_id], context=context)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/product/product.py", line 698, in create_variant_ids

id = product_obj.create(cr, uid, values, context=ctx)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/product/product.py", line 1155, in create

return super(product_product, self).create(cr, uid, vals, context=ctx)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/mail/mail_thread.py", line 377, in create

thread_id = super(mail_thread, self).create(cr, uid, values, context=context)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 336, in old_api

result = method(recs, *args, **kwargs)

File "/opt/odoo/openerp/models.py", line 4055, in create

record = self.browse(self._create(old_vals))

File "/opt/odoo/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 462, in new_api

result = method(self._model, cr, uid, *args, **kwargs)

File "/opt/odoo/openerp/models.py", line 4193, in _create

tuple([u[2] for u in updates if len(u) > 2])

File "/opt/odoo/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/opt/odoo/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

OperationalError: could not read block 4 in file "base/449508/455055": Input/output error


Thanks for any and all help.


Frank

0
Frank Carll
On 8/17/15, 2:49 PM

I was able to determine that the problem was caused by a corrupt Postgresql data file.


Fortunately, I was able to restore the data file from backups.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/14/15, 3:11 PM
Seen: 466 times
Last updated: 8/18/15, 10:09 AM