我的Odoo8出现Internal Server Error

[sdzxy]

不知怎么回事，我的Odoo8出错了，重装也一样
出错信息如下

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.

[royalier]

总的把log文件贴上来吧

[sdzxy]

2014-11-22 14:14:07,704 1824 ERROR number1 werkzeug: Error on request:
Traceback (most recent call last):
  File "werkzeug\serving.py", line 177, in run_wsgi
   
  File "werkzeug\serving.py", line 165, in execute
   
  File "C:\Program Files (x86)\Odoo8\server\openerp\service\server.py", line 280, in app
    return self.app(e, s)
  File "C:\Program Files (x86)\Odoo8\server\openerp\service\wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "C:\Program Files (x86)\Odoo8\server\openerp\service\wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "C:\Program Files (x86)\Odoo8\server\openerp\http.py", line 1215, in call
    return self.dispatch(environ, start_response)
  File "C:\Program Files (x86)\Odoo8\server\openerp\http.py", line 1189, in call
    return self.app(environ, start_wrapped)
  File "werkzeug\wsgi.py", line 579, in call
   
  File "C:\Program Files (x86)\Odoo8\server\openerp\http.py", line 1356, in dispatch
    result = ir_http._dispatch()
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\ir_http.py", line 125, in _dispatch
    return super(ir_http, self)._dispatch()
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\base\ir\ir_http.py", line 110, in _dispatch
    return self._handle_exception(e)
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\ir_http.py", line 253, in _handle_exception
    html = request.website._render('website.http_error', values)
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\website.py", line 286, in _render
    return self.pool['ir.ui.view'].render(cr, uid, template, values=values, context=context)
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\ir_ui_view.py", line 151, in render
    editable=request.website.is_publisher(),
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\website.py", line 267, in is_publisher
    is_website_publisher = Access.check(cr, uid, 'ir.ui.view', 'write', False, context=context)
  File "C:\Program Files (x86)\Odoo8\server\openerp\api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "<string>", line 2, in check
   
  File "C:\Program Files (x86)\Odoo8\server\openerp\tools\cache.py", line 75, in lookup
    return self.method(*args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\addons\base\ir\ir_model.py", line 761, in check
    , (model_name, uid,)
  File "C:\Program Files (x86)\Odoo8\server\openerp\sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo8\server\openerp\sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
InternalError: 错误:  当前事务被终止, 事务块结束之前的查询被忽略

[sdzxy]

我修复了，双出现同样的错误，我看了一下log
最后一行是
File "C:\Program Files (x86)\Odoo 8.0-20141231\server\openerp\sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
InternalError: 错误:  当前事务被终止, 事务块结束之前的查询被忽略
这很明显是数据库的问题，
仍不放心，用 netstat -an 看了一下  8069 5432这两个端口处在监听状态
这说明系统正常，所以我的结论是这个错误是访问数据库时出现的错误，
于是我打开postGreSQL修改了一个，果然可以了，
  步骤如下，右键单击数据库---维护 ---选中vacuum(这个意思是真空，不知何解) ，其下选择FULL
如图所示（这个论坛系统能不能改进一下直接插入图片啊）

虽然成功了，这说明了一个问题  postGreSQL这种数据库不是很坚强啊，这么容易出错（这段时间我是正常开关机啊，还是这东东在windows下水士不服）

[mrshelly]

能把 错误  log  多贴点儿不?

[sdzxy]

这已经是那个时点的全部log了

[mrshelly]

<br /><br />&nbsp; File &quot;C:\Program Files (x86)\Odoo8\server\openerp\addons\website\models\website.py&quot;, line 267, in is_publisher<br />&nbsp; &nbsp; is_website_publisher = Access.check(cr, uid, &#039;ir.ui.view&#039;, &#039;write&#039;, False, context=context)<br /><br />

看起来好象是权限上面的问题造成的数据回滚.
修复后能用, 可能的解释就是, 修复后, 将你做的部分改动也回滚了. 这样就不出错了...