Hello,
I launch an update for odoo (v12) yesterday and also apps.
Now, I’ve got « internal server error »,
Could you help me please ? Here the odoo server log file
Regards
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_menu.py", line 234, in load_menus
menu_roots_data = menu_roots.read(fields) if menu_roots else []
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2926, in _read_from_database
field.read(fetched)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in read
for att in records.env['ir.attachment'].sudo().search(domain)}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in <dictcomp>
for att in records.env['ir.attachment'].sudo().search(domain)}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1095, in determine_value
self.compute_value(recs)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in compute_value
self._compute_value(records)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1042, in _compute_value
getattr(records, self.compute)()
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 201, in _compute_datas
if attach.store_fname:
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1085, in determine_value
record._prefetch_field(self)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2827, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 450, in read
return super(IrAttachment, self).read(fields, load=load)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2892, in _read_from_database
cr.execute(query_str, 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.ProgrammingError: column ir_attachment.temporary does not exist
LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...
^ - - -
2019-04-23 08:42:53,251 1160 WARNING 3A-dentaire odoo.sql_db: Cursor not closed explicitly
Please enable sql debugging to trace the caller.
2019-04-23 08:42:53,251 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/database/manager HTTP/1.1" 200 - 4 0.005 0.054
2019-04-23 08:42:53,353 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/fontawesome/css/font-awesome.css HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,356 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/util.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,356 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/index.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,366 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/popper/popper.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,385 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/css/bootstrap.css HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,398 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/jquery/jquery.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,423 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/alert.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,429 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/carousel.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,439 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/button.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,441 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/collapse.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,468 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/dropdown.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,513 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/modal.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,529 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/tooltip.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,539 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/popover.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,547 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/scrollspy.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,555 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/tab.js HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,612 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/src/img/logo2.png HTTP/1.1" 200 - - - -
2019-04-23 08:42:53,908 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/fontawesome/fonts/fontawesome-webfont.woff2?v=4.7.0 HTTP/1.1" 200 - - - -
2019-04-23 08:43:00,533 1160 INFO 3A-dentaire odoo.sql_db: ConnectionPool(used=0/count=3/max=64): Free leaked connection to 'user=odoo sslmode=prefer dbname=3A-dentaire'
2019-04-23 08:43:00,565 1160 ERROR 3A-dentaire odoo.sql_db: bad query: b'SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."res_id" as "res_id","ir_attachment"."create_uid" as "create_uid","ir_attachment"."create_date" as "create_date","ir_attachment"."description" as "description","ir_attachment"."access_token" as "access_token","ir_attachment"."public" as "public","ir_attachment"."res_name" as "res_name","ir_attachment"."write_uid" as "write_uid","ir_attachment"."write_date" as "write_date","ir_attachment"."store_fname" as "store_fname","ir_attachment"."company_id" as "company_id","ir_attachment"."file_size" as "file_size","ir_attachment"."res_model" as "res_model","ir_attachment"."key" as "key","ir_attachment"."checksum" as "checksum","ir_attachment"."active" as "active","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."mimetype" as "mimetype","ir_attachment"."name" as "name","ir_attachment"."temporary" as "temporary","ir_attachment"."type" as "type","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."res_field" as "res_field","ir_attachment"."url" as "url" FROM "ir_attachment" WHERE "ir_attachment".id IN (2302, 256, 260, 261, 265, 273, 279, 539, 543, 1825, 2115, 2119, 330, 340, 745, 749, 753, 243, 244, 1146, 508)'
ERROR: column ir_attachment.temporary does not exist
LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...
^
2019-04-23 08:43:00,619 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:43:00] "GET /web/webclient/qweb?mods=base,web,muk_utils,bus,web_tour,mail,sales_team,calendar,utm,contacts,portal,digest,crm,web_editor,website,rating,project,product,barcodes,stock,account,payment,sale,sale_management,hr,hr_timesheet,note,purchase,hr_expense,account_bank_statement_import,auth_signup,automatic_backup,base_import,event,event_sale,google_calendar,hr_holidays,web_settings_dashboard,iap,l10n_fr,mail_bot,muk_web_utils,muk_account_accountant,muk_account_bank_statement_import_sheet,muk_web_attachment_dnd,muk_web_theme,payment_transfer,product_expiry,sale_stock,sale_timesheet,sms,snailmail,web_diagram,web_kanban_gauge,web_unsplash,website_helpdesk_support_ticket,website_mail,website_partner,website_rating,website_theme_install,fleet,website_event,repair,theme_bootswatch,theme_default HTTP/1.1" 304 - 1 0.000 0.077
2019-04-23 08:43:00,620 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:43:00] "GET /web HTTP/1.1" 500 - 10 0.025 0.064
2019-04-23 08:43:00,633 1160 ERROR 3A-dentaire werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 409, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1486, in dispatch
result = ir_http._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 398, in _dispatch
result = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/utm/models/ir_http.py", line 26, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 207, in _dispatch
return cls._handle_exception(e)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 195, in _handle_exception
return super(Http, cls)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/addons/utm/models/ir_http.py", line 31, in _handle_exception
response = super(IrHttp, cls)._handle_exception(exc)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 177, in _handle_exception
return request._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 774, in _handle_exception
return super(HttpRequest, 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/addons/base/models/ir_http.py", line 203, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 833, in dispatch
r = 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 457, in web_client
context = request.env['ir.http'].webclient_rendering_context()
File "/usr/lib/python3/dist-packages/odoo/addons/web/models/ir_http.py", line 17, in webclient_rendering_context
'menu_data': request.env['ir.ui.menu'].load_menus(request.debug),
File "<decorator-gen-31>", line 2, in load_menus
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_menu.py", line 234, in load_menus
menu_roots_data = menu_roots.read(fields) if menu_roots else []
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2926, in _read_from_database
field.read(fetched)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in read
for att in records.env['ir.attachment'].sudo().search(domain)}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in <dictcomp>
for att in records.env['ir.attachment'].sudo().search(domain)}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1095, in determine_value
self.compute_value(recs)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in compute_value
self._compute_value(records)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1042, in _compute_value
getattr(records, self.compute)()
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 201, in _compute_datas
if attach.store_fname:
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1085, in determine_value
record._prefetch_field(self)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2827, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 450, in read
return super(IrAttachment, self).read(fields, load=load)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2892, in _read_from_database
cr.execute(query_str, 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.ProgrammingError: column ir_attachment.temporary does not exist
LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...
^ - - -
2019-04-23 08:44:28,744 1160 INFO 3A-dentaire werkzeug: 86.203.251.254 - - [23/Apr/2019 08:44:28] "GET /logo.png?company=1 HTTP/1.1" 200 - 3 0.004 0.010
2019-04-23 08:45:07,983 1160 INFO 3A-dentaire odoo.addons.base.models.ir_cron: Starting job `Mail: Fetchmail Service`.
2019-04-23 08:45:07,996 1160 INFO 3A-dentaire odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server 3A Dentaire
2019-04-23 08:45:08,382 1160 INFO 3A-dentaire odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server 3A Dentaire; 0 succeeded, 0 failed.
See on many info: ERROR: column ir_attachment.temporary does not exist