Skip to Content
Menu
This question has been flagged
2475 Views

Can anyone help me with this issue? When I try to create a warehouse I get a block error which looks to be related to "stock_rule". This happened after restoring my database on docker. 



2021-08-10 23:13:43.914 UTC [49] STATEMENT: INSERT INTO "stock_rule" ("id", "create_uid", "create_date", "write_uid", "write_date", "action", "active", "auto", "company_id", "delay", "group_propagation_option", "location_id", "location_src_id", "name", "picking_type_id", "procure_method", "propagate", "route_id", "sequence", "warehouse_id") VALUES (nextval('stock_rule_id_seq'), 2, (now() at time zone 'UTC'), 2, (now() at time zone 'UTC'), 'pull', true, 'manual', 1, 0, 'propagate', 9, 258, 'keg: Stock → Customers', 242, 'make_to_stock', true, 88, 20, 31) RETURNING id,

2021-08-10 23:13:43.914 UTC [49] ERROR: could not read block 1 in file "base/16384/21370": read only 0 of 8192 bytes

Avatar
Discard
Author

Error:
Odoo Server Error

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 654, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 312, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/usr/lib/python3/dist-packages/odoo/http.py", line 696, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 344, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 337, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 939, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 517, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 962, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 954, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 747, in call_kw
return _call_kw_model_create(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 727, in _call_kw_model_create
result = method(recs, *args, **kwargs)
File "<decorator-gen-234>", line 2, in create
File "/usr/lib/python3/dist-packages/odoo/api.py", line 430, in _model_create_single
return create(self, arg)
File "/usr/lib/python3/dist-packages/odoo/addons/stock/models/stock_warehouse.py", line 108, in create
route_vals = warehouse._create_or_update_route()
File "/usr/lib/python3/dist-packages/odoo/addons/stock/models/stock_warehouse.py", line 342, in _create_or_update_route
self._find_existing_rule_or_create(rules_list)
File "/usr/lib/python3/dist-packages/odoo/addons/stock/models/stock_warehouse.py", line 433, in _find_existing_rule_or_create
self.env['stock.rule'].create(rule_vals)
File "<decorator-gen-3>", line 2, in create
File "/usr/lib/python3/dist-packages/odoo/api.py", line 451, in _model_create_multi
return create(self, [arg])
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3543, in create
records = self._create(data_list)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3643, in _create
cr.execute(query, params)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.InternalError: could not read block 1 in file "base/16384/21370": read only 0 of 8192 bytes

Damm even I am having a similar kind of issue, I have searched all over the internet and even have posted on number of threads on different forum, no solution seems to work. I am really frustrated, can anyone of you here help me resolve this issue, I am very much tired now.


Related Posts Replies Views Activity
2
Nov 24
1855
2
Oct 24
343
2
Aug 24
362
3
Jul 24
6442
1
May 24
564