[已解决]restore odoo12数据库报错
-
报错信息如下,不知道是否跟log里面列的其他模块有关?
2020-05-09 06:43:55,164 5636 INFO ? odoo.http: HTTP Configuring static files 2020-05-09 06:43:55,166 5636 DEBUG ? odoo.http: HTTP sessions stored in: /home/hui/data_file/odoo12/sessions 2020-05-09 06:43:55,176 5636 DEBUG 89_v12 odoo.modules.registry: Multiprocess load registry signaling: [Registry: 20] [Cache: 52] 2020-05-09 06:43:55,180 5636 INFO 89_v12 odoo.modules.loading: loading 1 modules... 2020-05-09 06:43:55,181 5636 DEBUG 89_v12 odoo.modules.loading: loading module base (1/1) 2020-05-09 06:43:55,197 5636 INFO 89_v12 odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries 2020-05-09 06:43:55,203 5636 DEBUG 89_v12 odoo.modules.module: module muk_utils: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,203 5636 WARNING 89_v12 odoo.modules.graph: module muk_utils: not installable, skipped 2020-05-09 06:43:55,205 5636 DEBUG 89_v12 odoo.modules.module: module sms: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,205 5636 WARNING 89_v12 odoo.modules.graph: module sms: not installable, skipped 2020-05-09 06:43:55,207 5636 DEBUG 89_v12 odoo.modules.module: module muk_autovacuum: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,207 5636 WARNING 89_v12 odoo.modules.graph: module muk_autovacuum: not installable, skipped 2020-05-09 06:43:55,208 5636 DEBUG 89_v12 odoo.modules.module: module sale_order_aprobar: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,208 5636 WARNING 89_v12 odoo.modules.graph: module sale_order_aprobar: not installable, skipped 2020-05-09 06:43:55,211 5636 DEBUG 89_v12 odoo.modules.module: module auto_backup: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,211 5636 WARNING 89_v12 odoo.modules.graph: module auto_backup: not installable, skipped 2020-05-09 06:43:55,215 5636 DEBUG 89_v12 odoo.modules.module: module xx_muk_be_theme_collapse: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,215 5636 WARNING 89_v12 odoo.modules.graph: module xx_muk_be_theme_collapse: not installable, skipped 2020-05-09 06:43:55,220 5636 DEBUG 89_v12 odoo.modules.module: module muk_web_theme: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,220 5636 WARNING 89_v12 odoo.modules.graph: module muk_web_theme: not installable, skipped 2020-05-09 06:43:55,221 5636 DEBUG 89_v12 odoo.modules.module: module muk_web_utils: no manifest file found ('__manifest__.py', '__openerp__.py') 2020-05-09 06:43:55,221 5636 WARNING 89_v12 odoo.modules.graph: module muk_web_utils: not installable, skipped 2020-05-09 06:43:55,224 5636 DEBUG 89_v12 odoo.modules.loading: Updating graph with 47 more modules 2020-05-09 06:43:55,224 5636 INFO 89_v12 odoo.modules.loading: loading 40 modules... 2020-05-09 06:43:55,224 5636 DEBUG 89_v12 odoo.modules.loading: loading module decimal_precision (2/40) 2020-05-09 06:43:55,227 5636 DEBUG 89_v12 odoo.modules.loading: loading module uom (3/40) 2020-05-09 06:43:55,230 5636 DEBUG 89_v12 odoo.modules.loading: loading module web (4/40) 2020-05-09 06:43:55,238 5636 DEBUG 89_v12 odoo.modules.loading: loading module base_import (5/40) 2020-05-09 06:43:55,262 5636 DEBUG 89_v12 odoo.modules.loading: loading module base_setup (6/40) 2020-05-09 06:43:55,265 5636 DEBUG 89_v12 odoo.modules.loading: loading module bus (7/40) 2020-05-09 06:43:55,269 5636 DEBUG 89_v12 odoo.modules.loading: loading module http_routing (8/40) 2020-05-09 06:43:55,274 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_diagram (9/40) 2020-05-09 06:43:55,275 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_editor (10/40) 2020-05-09 06:43:55,288 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_kanban_gauge (11/40) 2020-05-09 06:43:55,289 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_settings_dashboard (12/40) 2020-05-09 06:43:55,292 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_tour (13/40) 2020-05-09 06:43:55,295 5636 DEBUG 89_v12 odoo.modules.loading: loading module iap (14/40) 2020-05-09 06:43:55,299 5636 DEBUG 89_v12 odoo.modules.loading: loading module mail (15/40) 2020-05-09 06:43:55,352 5636 DEBUG 89_v12 odoo.modules.loading: loading module web_unsplash (16/40) 2020-05-09 06:43:55,360 5636 DEBUG 89_v12 odoo.modules.loading: loading module analytic (17/40) 2020-05-09 06:43:55,364 5636 DEBUG 89_v12 odoo.modules.loading: loading module auth_signup (18/40) 2020-05-09 06:43:55,377 5636 DEBUG 89_v12 odoo.modules.loading: loading module fetchmail (19/40) 2020-05-09 06:43:55,386 5636 DEBUG 89_v12 odoo.modules.loading: loading module mail_bot (20/40) 2020-05-09 06:43:55,395 5636 DEBUG 89_v12 odoo.modules.loading: loading module partner_autocomplete (21/40) 2020-05-09 06:43:55,401 5636 DEBUG 89_v12 odoo.modules.loading: loading module portal (22/40) 2020-05-09 06:43:55,417 5636 DEBUG 89_v12 odoo.modules.loading: loading module product (23/40) 2020-05-09 06:43:55,438 5636 DEBUG 89_v12 odoo.modules.loading: loading module sales_team (24/40) 2020-05-09 06:43:55,443 5636 DEBUG 89_v12 odoo.modules.loading: loading module snailmail (25/40) 2020-05-09 06:43:55,449 5636 DEBUG 89_v12 odoo.modules.loading: loading module digest (26/40) 2020-05-09 06:43:55,456 5636 DEBUG 89_v12 odoo.modules.loading: loading module account (27/40) 2020-05-09 06:43:55,605 5636 DEBUG 89_v12 odoo.modules.loading: loading module account_bank_statement_import (28/40) 2020-05-09 06:43:55,610 5636 DEBUG 89_v12 odoo.modules.loading: loading module account_cancel (29/40) 2020-05-09 06:43:55,612 5636 DEBUG 89_v12 odoo.modules.loading: loading module account_facturx (30/40) 2020-05-09 06:43:55,614 5636 DEBUG 89_v12 odoo.modules.loading: loading module l10n_multilang (31/40) 2020-05-09 06:43:55,618 5636 DEBUG 89_v12 odoo.modules.loading: loading module membership (32/40) 2020-05-09 06:43:55,629 5636 DEBUG 89_v12 odoo.modules.loading: loading module payment (33/40) 2020-05-09 06:43:55,631 5636 DEBUG 89_v12 odoo.modules.loading: loading module snailmail_account (34/40) 2020-05-09 06:43:55,644 5636 DEBUG 89_v12 odoo.modules.loading: loading module l10n_cn (35/40) 2020-05-09 06:43:55,646 5636 DEBUG 89_v12 odoo.modules.loading: loading module member_lee (36/40) 2020-05-09 06:43:55,648 5636 DEBUG 89_v12 odoo.modules.loading: loading module payment_transfer (37/40) 2020-05-09 06:43:55,651 5636 DEBUG 89_v12 odoo.modules.loading: loading module sale (38/40) 2020-05-09 06:43:55,676 5636 DEBUG 89_v12 odoo.modules.loading: loading module l10n_cn_small_business (39/40) 2020-05-09 06:43:55,679 5636 DEBUG 89_v12 odoo.modules.loading: loading module sale_management (40/40) 2020-05-09 06:43:55,686 5636 INFO 89_v12 odoo.modules.loading: 40 modules loaded in 0.46s, 0 queries 2020-05-09 06:43:56,245 5636 INFO 89_v12 odoo.modules.loading: Modules loaded. 2020-05-09 06:43:56,250 5636 DEBUG 89_v12 odoo.modules.registry: Multiprocess signaling check: [Registry - 20 -> 20] [Cache - 52 -> 52] 2020-05-09 06:43:56,250 5636 INFO 89_v12 odoo.addons.base.models.ir_http: Generating routing map 2020-05-09 06:43:56,298 5636 INFO 89_v12 werkzeug: 127.0.0.1 - - [09/May/2020 06:43:56] "GET / HTTP/1.1" 200 - 24 0.020 1.113 2020-05-09 06:43:56,333 5636 DEBUG 89_v12 odoo.modules.registry: Multiprocess signaling check: [Registry - 20 -> 20] [Cache - 52 -> 52] 2020-05-09 06:43:56,336 5636 INFO 89_v12 werkzeug: 127.0.0.1 - - [09/May/2020 06:43:56] "GET /web HTTP/1.1" 303 - 1 0.000 0.004 2020-05-09 06:43:56,345 5636 DEBUG 89_v12 odoo.modules.registry: Multiprocess signaling check: [Registry - 20 -> 20] [Cache - 52 -> 52] 2020-05-09 06:43:56,621 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,622 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,627 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,644 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,650 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,652 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,654 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,663 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,666 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,670 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,861 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,862 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,872 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,874 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:56,881 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,293 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,295 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,296 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,298 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,673 5636 WARNING 89_v12 odoo.modules.module: module muk_web_theme: module not found 2020-05-09 06:43:57,700 5636 ERROR 89_v12 odoo.sql_db: bad query: b'INSERT INTO "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "company_id", "datas_fname", "mimetype", "name", "public", "res_id", "res_model", "type") VALUES (nextval(\'ir_attachment_id_seq\'), 1, (now() at time zone \'UTC\'), 1, (now() at time zone \'UTC\'), true, 1, \'web.assets_common.js\', \'application/javascript\', \'/web/content/js\', true, 0, \'ir.ui.view\', \'binary\') RETURNING id' ERROR: relation "ir_attachment_id_seq" does not exist LINE 1: ...", "res_id", "res_model", "type") VALUES (nextval('ir_attach... ^ 2020-05-09 06:43:57,700 5636 ERROR 89_v12 odoo.sql_db: bad query: b'SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (("ir_ui_view"."active" = true) AND ("ir_ui_view"."key" = \'web.login_layout\')) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" ,"ir_ui_view"."id" limit 1' ERROR: current transaction is aborted, commands ignored until end of transaction block 2020-05-09 06:43:57,782 5636 INFO 89_v12 werkzeug: 127.0.0.1 - - [09/May/2020 06:43:57] "GET /web/login HTTP/1.1" 500 - 202 0.132 1.307 2020-05-09 06:43:57,796 5636 ERROR 89_v12 werkzeug: Error on request: Traceback (most recent call last): File "/home/hui/.local/lib/python3.5/site-packages/werkzeug/serving.py", line 193, in run_wsgi execute(self.server.app) File "/home/hui/.local/lib/python3.5/site-packages/werkzeug/serving.py", line 181, in execute application_iter = app(environ, start_response) File "/home/hui/odoo-dev/odoo12/odoo/odoo/service/server.py", line 350, in app return self.app(e, s) File "/home/hui/odoo-dev/odoo12/odoo/odoo/service/wsgi_server.py", line 128, in application return application_unproxied(environ, start_response) File "/home/hui/odoo-dev/odoo12/odoo/odoo/service/wsgi_server.py", line 117, in application_unproxied result = odoo.http.root(environ, start_response) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 1318, in __call__ return self.dispatch(environ, start_response) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 1291, in __call__ return self.app(environ, start_wrapped) File "/home/hui/.local/lib/python3.5/site-packages/werkzeug/wsgi.py", line 599, in __call__ return self.app(environ, start_response) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 1486, in dispatch result = ir_http._dispatch() File "/home/hui/odoo-dev/odoo12/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch return super(Http, cls)._dispatch() File "/home/hui/odoo-dev/odoo12/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch return super(IrHttp, cls)._dispatch() File "/home/hui/odoo-dev/odoo12/odoo/addons/http_routing/models/ir_http.py", line 394, in _dispatch result = super(IrHttp, cls)._dispatch() File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_http.py", line 207, in _dispatch return cls._handle_exception(e) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_http.py", line 177, in _handle_exception return request._handle_exception(exception) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 774, in _handle_exception return super(HttpRequest, self)._handle_exception(exception) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 312, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/home/hui/odoo-dev/odoo12/odoo/odoo/tools/pycompat.py", line 87, in reraise raise value File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_http.py", line 203, in _dispatch result = request.dispatch() File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 833, in dispatch r = self._call_function(**self.params) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 344, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 340, in checked_call result.flatten() File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 1268, in flatten self.response.append(self.render()) File "/home/hui/odoo-dev/odoo12/odoo/odoo/http.py", line 1261, in render return env["ir.ui.view"].render_template(self.template, self.qcontext) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_ui_view.py", line 1279, in render_template return self.browse(self.get_view_id(template)).render(values, engine) File "/home/hui/odoo-dev/odoo12/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_ui_view.py", line 1288, in render return self.env[engine].render(self.id, qcontext) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_qweb.py", line 59, in render result = super(IrQWeb, self).render(id_or_xml_id, values=values, **context) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 272, in render self.compile(template, options)(self, body.append, values or {}) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 346, in _compiled_fn raise e File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 344, in _compiled_fn return compiled(self, append, new, options, log) File "<template>", line 1, in template_173_5 File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 349, in _compiled_fn element, document = self.get_template(template, options) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 374, in get_template raise QWebException("load could not load template", name=template) odoo.addons.base.models.qweb.QWebException: None Traceback (most recent call last): File "/home/hui/odoo-dev/odoo12/odoo/odoo/tools/cache.py", line 88, in lookup r = d[key] File "/home/hui/odoo-dev/odoo12/odoo/odoo/tools/func.py", line 69, in wrapper return func(self, *args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/tools/lru.py", line 44, in __getitem__ a = self.d[obj].me KeyError: ('ir.qweb', <function IrQWeb._get_asset_nodes at 0x7f7eb3ddc048>, 'web.assets_common', 'en_US', False, True, False, False, (None,)) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 344, in _compiled_fn return compiled(self, append, new, options, log) File "<template>", line 1, in template_web_login_layout_11 File "<template>", line 2, in body_call_content_10 File "<template>", line 4, in set_8 File "<decorator-gen-56>", line 2, in _get_asset_nodes File "/home/hui/odoo-dev/odoo12/odoo/odoo/tools/cache.py", line 93, in lookup value = d[key] = self.method(*args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_qweb.py", line 308, in _get_asset_nodes return remains + asset.to_node(css=css, js=js, debug=debug, async_load=async_load) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/assetsbundle.py", line 174, in to_node ["src", self.js().url], File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/assetsbundle.py", line 327, in js return self.save_attachment('js', content) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/assetsbundle.py", line 300, in save_attachment attachment = ira.sudo().create(values) File "<decorator-gen-41>", line 2, in create File "/home/hui/odoo-dev/odoo12/odoo/odoo/api.py", line 451, in _model_create_multi return create(self, [arg]) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_attachment.py", line 507, in create return super(IrAttachment, self).create(vals_list) File "<decorator-gen-3>", line 2, in create File "/home/hui/odoo-dev/odoo12/odoo/odoo/api.py", line 452, in _model_create_multi return create(self, arg) File "/home/hui/odoo-dev/odoo12/odoo/odoo/models.py", line 3514, in create records = self._create(data_list) File "/home/hui/odoo-dev/odoo12/odoo/odoo/models.py", line 3614, in _create cr.execute(query, params) File "/home/hui/odoo-dev/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: relation "ir_attachment_id_seq" does not exist LINE 1: ...", "res_id", "res_model", "type") VALUES (nextval('ir_attach... ^ During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/qweb.py", line 370, in get_template document = options.get('load', self.load)(template, options) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_qweb.py", line 122, in load template = env['ir.ui.view'].read_template(name) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_ui_view.py", line 1170, in read_template return self._read_template(self.get_view_id(xml_id)) File "/home/hui/odoo-dev/odoo12/odoo/odoo/addons/base/models/ir_ui_view.py", line 1185, in get_view_id view = self.search([('key', '=', template)], limit=1) File "/home/hui/odoo-dev/odoo12/odoo/odoo/models.py", line 1561, in search res = self._search(args, offset=offset, limit=limit, order=order, count=count) File "/home/hui/odoo-dev/odoo12/odoo/odoo/models.py", line 4071, in _search self._cr.execute(query_str, where_clause_params) File "/home/hui/odoo-dev/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/home/hui/odoo-dev/odoo12/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block load could not load template Template: web.login_layout - - -
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login