« Internal Server error » pour certaines bases de données

**lapagept** · 21/10/2014, 16h08

Bonjour à tous,

Je suis capable de me connecter à : http://24.226.196.31:8069/web/database/selector

Nom : Copie_ecran_pt_ 2014-10-21 à 10.07.07.png
Affichages : 3669
Taille : 29,7 Ko

Nom : Copie_ecran_pt_ 2014-10-21 à 10.07.07.png
Affichages : 3669
Taille : 29,7 Ko

Pour une des trois bases de données disponibles, je suis capable de me connecter à Odoo.

Mais pour deux des bases de données disponibles, si je choisis la base de données dans la liste déroulante, j'obtiens immédiatement cette erreur, sans refresh de la page :

«Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
»

Je ne sais plus quoi faire, encore un fois.

Merci de me donner vos idées.

**lapagept** · 22/10/2014, 02h28

Dans le fichier log de Odoo, cette erreur se répète sans arrêt. Je voudrais bien désactiver fetchmail, mais comme mentionné plus haut, je ne peux pas entrer dans l'administration de Odoo...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2014-10-22 00:03:44,501 19648 ERROR la_page_pt openerp.addons.fetchmail.fetchmail: Failed to process mail from pop server Dragons Judo Club.
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/addons/fetchmail/fetchmail.py", line 237, in fetch_mail
    context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 1158, in message_process
    routes = self.message_route(cr, uid, msg_txt, msg, model, thread_id, custom_values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 1043, in message_route
    update_author=True, assert_model=True, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 822, in message_route_verify
    raise ValueError('Routing: posting a message without model should be with a parent_id (private mesage).')
ValueError: Routing: posting a message without model should be with a parent_id (private mesage).

**lapagept** · 22/10/2014, 02h33

Voilà encore le début de mon fichier log, juste après avoir redémarré le serveur Odoo et sélectionné ma base de données la_page_pt. La base de données qui me donne un Internal server error...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
2014-10-22 00:29:48,848 19648 INFO la_page_pt openerp.service.server: Initiating shutdown
2014-10-22 00:29:48,848 19648 INFO la_page_pt openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2014-10-22 00:29:50,922 24991 INFO ? openerp: OpenERP version 8.0-8a9027e
2014-10-22 00:29:50,922 24991 INFO ? openerp: addons paths: ['/var/lib/odoo/addons/8.0', u'/usr/lib/python2.7/dist-packages/openerp/addons']
2014-10-22 00:29:50,922 24991 INFO ? openerp: database hostname: localhost
2014-10-22 00:29:50,922 24991 INFO ? openerp: database port: 5432
2014-10-22 00:29:50,922 24991 INFO ? openerp: database user: odoo
2014-10-22 00:29:51,092 24991 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-10-22 00:29:51,098 24991 INFO la_page_pt openerp.modules.loading: loading 1 modules...
2014-10-22 00:29:51,235 24991 INFO la_page_pt openerp.modules.loading: 1 modules loaded in 0.14s, 0 queries
2014-10-22 00:29:51,260 24991 INFO la_page_pt openerp.modules.loading: loading 83 modules...
2014-10-22 00:29:51,264 24991 INFO la_page_pt passlib.registry: registered crypt handler 'pbkdf2_sha512': <class 'passlib.handlers.pbkdf2.pbkdf2_sha512'>
2014-10-22 00:29:51,264 24991 INFO la_page_pt passlib.registry: registered crypt handler 'md5_crypt': <class 'passlib.handlers.md5_crypt.md5_crypt'>
2014-10-22 00:29:51,328 24991 INFO ? openerp.addons.bus.bus: Bus.loop listen imbus on db postgres
2014-10-22 00:29:51,339 24991 INFO la_page_pt openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2014-10-22 00:29:53,891 24991 INFO la_page_pt openerp.modules.loading: 83 modules loaded in 2.63s, 0 queries
2014-10-22 00:29:53,981 24991 INFO la_page_pt openerp.modules.loading: Modules loaded.
2014-10-22 00:29:54,100 24991 INFO ? openerp.http: HTTP Configuring static files
2014-10-22 00:29:54,101 24991 INFO la_page_pt openerp.addons.base.ir.ir_http: Generating routing map
2014-10-22 00:29:54,167 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "GET /web/database/manager HTTP/1.1" 200 -
2014-10-22 00:29:54,523 24991 INFO None openerp.http: Generating nondb routing
2014-10-22 00:29:54,529 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "POST /web/session/get_session_info HTTP/1.1" 200 -
2014-10-22 00:29:54,559 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "POST /web/webclient/bootstrap_translations HTTP/1.1" 200 -
2014-10-22 00:29:54,587 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "POST /web/proxy/load HTTP/1.1" 200 -
2014-10-22 00:29:54,623 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "POST /web/session/get_lang_list HTTP/1.1" 200 -
2014-10-22 00:29:54,675 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:54] "POST /web/database/get_list HTTP/1.1" 200 -
2014-10-22 00:29:56,791 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:56] "GET /web HTTP/1.1" 303 -
2014-10-22 00:29:56,805 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:29:56] "GET /web/database/selector HTTP/1.1" 200 -
2014-10-22 00:30:01,494 24991 INFO None werkzeug: 192.168.1.1 - - [22/Oct/2014 00:30:01] "GET /web?db=la_page_pt HTTP/1.1" 302 -
2014-10-22 00:30:01,499 24991 INFO la_page_pt werkzeug: 192.168.1.1 - - [22/Oct/2014 00:30:01] "GET /web?db=la_page_pt HTTP/1.1" 200 -
2014-10-22 00:30:01,525 24991 ERROR la_page_pt openerp.sql_db: Programming error: operator does not exist: integer = boolean
LINE 1: ...roup_id)  WHERE m.model = 'website'    AND gu.uid = false   ...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END)   FROM ir_model_access a   JOIN ir_model m ON (m.id = a.model_id)   JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)  WHERE m.model = %s    AND gu.uid = %s    AND a.active IS True 
2014-10-22 00:30:01,582 24991 INFO la_page_pt werkzeug: 192.168.1.1 - - [22/Oct/2014 00:30:01] "GET /web/login?redirect=http%3A%2F%2F24.226.196.31%3A8069%2Fweb%3Fdb%3Dla_page_pt HTTP/1.1" 500 -
2014-10-22 00:30:01,595 24991 ERROR la_page_pt werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 280, in app
    return self.app(e, s)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1215, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1189, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1356, in dispatch
    result = ir_http._dispatch()
  File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_http.py", line 91, in _dispatch
    langs = [lg[0] for lg in request.website.get_languages()]
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/website.py", line 235, in get_languages
    return self._get_languages(cr, uid, ids[0], context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "<string>", line 2, in _get_languages
    
  File "/usr/lib/python2.7/dist-packages/openerp/tools/cache.py", line 75, in lookup
    return self.method(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/website.py", line 232, in _get_languages
    return [(lg.code, lg.name) for lg in website.language_ids]
  File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 754, in __get__
    self.determine_value(record)
  File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 849, in determine_value
    record._prefetch_field(self)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3154, in _prefetch_field
    result = records.read(list(fnames), load='_classic_write')
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3087, in read
    self.check_access_rights('read')
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 442, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3401, in check_access_rights
    return self.pool.get('ir.model.access').check(cr, uid, self._name, operation, raise_exception)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "<string>", line 2, in check
    
  File "/usr/lib/python2.7/dist-packages/openerp/tools/cache.py", line 71, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_model.py", line 750, in check
    , (model_name, uid,)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...roup_id)  WHERE m.model = 'website'    AND gu.uid = false   ...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

J'espère que quelqu'un saura nous dire comment éviter Internal server error. C'est la panique (encore) depuis 2 jours.

Merci

**harryboy** · 22/10/2014, 16h13

Envoyé par lapagept

Dans le fichier log de Odoo, cette erreur se répète sans arrêt. Je voudrais bien désactiver fetchmail, mais comme mentionné plus haut, je ne peux pas entrer dans l'administration de Odoo...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2014-10-22 00:03:44,501 19648 ERROR la_page_pt openerp.addons.fetchmail.fetchmail: Failed to process mail from pop server Dragons Judo Club.
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/addons/fetchmail/fetchmail.py", line 237, in fetch_mail
    context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 1158, in message_process
    routes = self.message_route(cr, uid, msg_txt, msg, model, thread_id, custom_values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 1043, in message_route
    update_author=True, assert_model=True, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/mail/mail_thread.py", line 822, in message_route_verify
    raise ValueError('Routing: posting a message without model should be with a parent_id (private mesage).')
ValueError: Routing: posting a message without model should be with a parent_id (private mesage).

Salut, si tu ne peux pas entrer dans l'administration d'odoo pour désactiver le module, tu peux le faire via la base en faisant :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

UPDATE ir_module_module SET state='uninstalled' WHERE name='fetchmail';

Cela aura pour effet de marquer le module comme désinstallé, et odoo ne cherchera plus à le mettre à jour lors du démarrage sur la base
En espérant que cela t'aidera

**lapagept** · 22/10/2014, 16h58

J'ai vraiment hâte d'essayer cela plus tard. Merci beaucoup.

**lapagept** · 23/10/2014, 00h54

Alors voilà... J'ai désactivé le module fetchmail de par PGAdmin. Maintenant, c'est « internal Server Error » partout. Même dans le gestionnaire de Base de données.

Log :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
2014-10-22 22:47:02,330 1210 INFO la_page_pt openerp.service.server: Initiating shutdown
2014-10-22 22:47:02,330 1210 INFO la_page_pt openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2014-10-22 22:47:04,396 2820 INFO ? openerp: OpenERP version 8.0-8a9027e
2014-10-22 22:47:04,396 2820 INFO ? openerp: addons paths: ['/var/lib/odoo/addons/8.0', u'/usr/lib/python2.7/dist-packages/openerp/addons']
2014-10-22 22:47:04,396 2820 INFO ? openerp: database hostname: localhost
2014-10-22 22:47:04,396 2820 INFO ? openerp: database port: 5432
2014-10-22 22:47:04,396 2820 INFO ? openerp: database user: odoo
2014-10-22 22:47:04,564 2820 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-10-22 22:47:04,570 2820 INFO la_page_pt openerp.modules.loading: loading 1 modules...
2014-10-22 22:47:04,701 2820 INFO la_page_pt openerp.modules.loading: 1 modules loaded in 0.13s, 0 queries
2014-10-22 22:47:04,726 2820 INFO la_page_pt openerp.modules.loading: loading 82 modules...
2014-10-22 22:47:04,730 2820 INFO la_page_pt passlib.registry: registered crypt handler 'pbkdf2_sha512': <class 'passlib.handlers.pbkdf2.pbkdf2_sha512'>
2014-10-22 22:47:04,730 2820 INFO la_page_pt passlib.registry: registered crypt handler 'md5_crypt': <class 'passlib.handlers.md5_crypt.md5_crypt'>
2014-10-22 22:47:04,793 2820 INFO ? openerp.addons.bus.bus: Bus.loop listen imbus on db postgres
2014-10-22 22:47:04,804 2820 INFO la_page_pt openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2014-10-22 22:47:05,824 2820 CRITICAL la_page_pt openerp.service.server: Failed to initialize database `la_page_pt`.
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 901, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 324, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 354, in load_modules
    force, status, report, loaded_modules, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 263, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 158, in load_module_graph
    models = registry.load(cr, package)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 147, in load
    model = cls._build_model(self, cr)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 592, in _build_model
    'You may need to add a dependency on the parent class\' module.' % (name, parent))
TypeError: The model "project.config.settings" specifies an unexisting parent class "fetchmail.config.settings"
You may need to add a dependency on the parent class' module.
2014-10-22 22:47:06,773 2820 INFO ? openerp.http: HTTP Configuring static files
2014-10-22 22:47:06,775 2820 INFO la_page_pt openerp.modules.loading: loading 1 modules...
2014-10-22 22:47:06,905 2820 INFO la_page_pt openerp.modules.loading: 1 modules loaded in 0.13s, 0 queries
2014-10-22 22:47:06,929 2820 INFO la_page_pt openerp.modules.loading: loading 82 modules...
2014-10-22 22:47:07,623 2820 INFO la_page_pt werkzeug: 127.0.0.1 - - [22/Oct/2014 22:47:07] "GET /web/database/manager HTTP/1.1" 500 -
2014-10-22 22:47:07,629 2820 ERROR la_page_pt werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 280, in app
    return self.app(e, s)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1215, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1189, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1347, in dispatch
    ir_http = request.registry['ir.http']
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 319, in registry
    return openerp.modules.registry.RegistryManager.get(self.db) if self.db else None
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 293, in get
    update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 324, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 354, in load_modules
    force, status, report, loaded_modules, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 263, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 158, in load_module_graph
    models = registry.load(cr, package)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 147, in load
    model = cls._build_model(self, cr)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 592, in _build_model
    'You may need to add a dependency on the parent class\' module.' % (name, parent))
TypeError: The model "project.config.settings" specifies an unexisting parent class "fetchmail.config.settings"
You may need to add a dependency on the parent class' module.

Nom : asdf.png
Affichages : 3448
Taille : 23,5 Ko

Nom : aedfgas.png
Affichages : 3502
Taille : 44,6 Ko

**lapagept** · 23/10/2014, 21h16

Je viens de trouver deux entrées se référant à fetchmail que je vais tenter de retirer de la base de données dans ir_module_module_dependency... Il faut savoir vivre dangereusement. On verra bien.
Nom : asdfasdf.png
Affichages : 3568
Taille : 84,7 Ko

Nom : asdfasdf.png
Affichages : 3568
Taille : 84,7 Ko

« Internal Server error » pour certaines bases de données

Odoo (ex-OpenERP)

Discussions similaires

Partager

Partager