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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2475
Views
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Nov 24
|
1855 | ||
|
2
Oct 24
|
343 | ||
|
2
Aug 24
|
362 | ||
|
3
Jul 24
|
6442 | ||
|
1
May 24
|
564 |
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.