[trunk] Pool error and timeout problem on windows while installing extra tools/wiki.

[forstera]

Hello,
I tried to install the helpdesk module (version 6) and here's the error I get :
--------------------- Error at the commande line (putty) ----------------------------------------------------------------------------------------------

[2010-10-06 07:35:24,387][test6] ERROR:addons.base.ir.model.data:Could not delete id: 7 of model ir.attachment
There should be some relation that points to this resource
You should manually fix this and restart with --update=module
Traceback (most recent call last):
  File "/usr/lib/erp6/bin/addons/base/ir/ir_model.py", line 671, in _process_end
    self.pool.get(model).unlink(cr, uid, [res_id])
  File "/usr/lib/erp6/bin/addons/document/document.py", line 258, in unlink
    assert storage_id, "Strange, found file #%s w/o storage!" % f.id
AssertionError: Strange, found file #7 w/o storage!
[2010-10-06 07:35:25,362][test6] INFO:actions:getting next operation
[2010-10-06 07:35:25,363][test6] INFO:actions:getting next <base.ir.ir_actions.ir_actions_todo object at 0x96839ac>
[2010-10-06 07:35:25,390][test6] INFO:actions:next action is browse_record(ir.actions.todo, 6)
[2010-10-06 07:35:52,934][test6] INFO:base.ir.module.module:Sending web content of modules [u'wiki'] to web client
Traceback (most recent call last):
  File "/usr/lib/python2.6/logging/__init__.py", line 773, in emit stream.write(fs % msg.encode("UTF-8"))
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1059: ordinal not in range (128)

 ------------------- Error displayed in the web page ----------------------------------------------------------------------------------------

Unrecoverable error in the server.
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 541, in run
    self.respond(pi)
  File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 624, in respond
    self.handle_error()
  File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 746, in handle_error
    self.error_response()
  File "/usr/lib/web6/addons/openerp/controllers/root.py", line 38, in _cp_on_error
    errorpage = cherrypy.request.pool.get_controller("/openerp/errorpage")
  File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/__init__.py", line 301, in __getattr__
    return getattr(child, name)
AttributeError: 'Request' object has no attribute 'pool'

[GEM (nimp3)]

Hi, duplicate bug here :
https://bugs.launchpad.net/openobject-client-web/+bug/655753 (posted same day)
Bye

[Chirag Patel (OpenERP) (cpa-openerp)]

Hello forstera ,

I have checked with the following revisions but not facing any problem.
Please update your code and notify us.

trunk addons: 4280
trunk (web-client): 3477
trunk server: 2840

Thanks

[GEM (nimp3)]

Hi cpa,
I confirm again the bug with installer windows.
web revision 3531
server 2871
addons 4333.
First, i can't create a database (error of cherrypy.timeout, I open a bug for this), then i create a complete database full options checked and with extended view, when finished, I login with client web, ok I can login, and when I logout, I have this message :

Unrecoverable error in the server.
Traceback (most recent call last):
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 541, in run
    self.respond(pi)
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 624, in respond
    self.handle_error()
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 746, in handle_error
    self.error_response()
  File "d:\openerp allinone\web\python25\lib\site-packages\openerp_web-6.0dev-py2.5.egg\openerp-web\addons\openerp\controllers\root.py", line 38, in _cp_on_error
    errorpage = cherrypy.request.pool.get_controller("/openerp/errorpage")
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\__init__.py", line 301, in __getattr__
    return getattr(child, name)
AttributeError: 'Request' object has no attribute 'pool'

In fact in openerp-web\addons\openerp\controllers\root.py :
there is no import pooler
pool is not define like in openerp-web\openobject\controllers\_root.py
    line 3 from openobject import pooler
    line 73 pool = request.pool = pooler.get_pool()

after this I had an other error with line 30 in openerp-web\addons\openerp\controllers\root.py :
from openerp.controllers import SecuredController, unsecured, actions, login as tiny_login, form
problem with form, just delete form of this line and add the line before:
import form

after this, I have a new error but in openerp-server, see :
Unrecoverable error in the server.
Traceback (most recent call last):
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 541, in run
    self.respond(pi)
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 624, in respond
    self.handle_error()
  File "d:\OpenERP allinone\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 746, in handle_error
    self.error_response()
  File "d:\openerp allinone\web\python25\lib\site-packages\openerp_web-6.0dev-py2.5.egg\openerp-web\addons\openerp\controllers\root.py", line 39, in _cp_on_error
    pool = request.pool = pooler.get_pool()
  File "d:\openerp allinone\web\python25\lib\site-packages\openerp_web-6.0dev-py2.5.egg\openerp-web\openobject\pooler.py", line 93, in get_pool
    addons.load_addons(db_name, config)
  File "d:\openerp allinone\web\python25\lib\site-packages\openerp_web-6.0dev-py2.5.egg\openerp-web\openobject\addons.py", line 219, in load_addons
    new_modules = obj.get_new_modules()
  File "d:\openerp allinone\web\python25\lib\site-packages\openerp_web-6.0dev-py2.5.egg\openerp-web\ad...

[GEM (nimp3)]

bug error of cherrypy.timeout is due of a too low timeout in web config file (if all applications are checked with configurator):
openerp.server.timeout = 450

[GEM (nimp3)]

Hi,
confirmation of bug AttributeError: 'Request' object has no attribute 'pool' with official RC1 package for windows :

see this post on openerp forum.
http://www.openerp.com/forum/topic20734.html

the patch I gave works well and client web has no error with :

Bye

[GEM (nimp3)]

oops I forgot the import in patch see this corrected patch

[GEM (nimp3)]

file to modify is :
client-web\addons\openerp\controllers\root.py

[Xavier (Open ERP) (xmo-deactivatedaccount)]

Issue should be fixed, could you check if you still encounter it as of revision 3788 (<email address hidden>)?

[GEM (nimp3)]

I reopen the bug,
when i logout I have the error :
Unrecoverable error in the server.
Traceback (most recent call last):
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 541, in run
    self.respond(pi)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 624, in respond
    self.handle_error()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 746, in handle_error
    self.error_response()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\root.py", line 42, in _cp_on_error
    pool = request.pool = pooler.get_pool()
NameError: global name 'pooler' is not defined

[GEM (nimp3)]

I explain what i done to obtain that :

I'm login on a database admin with client web.
With my client gtk, I delete the database admin.
I do logout with client web and I have the error.
I'm obliged to delete cache firefox to obtain the login page of openerp web.

[GEM (nimp3)]

If I had in root.py :
from openobject import pooler
I have this error with same operations I described before (obliged to delete firefox cache too) :

Unrecoverable error in the server.
Traceback (most recent call last):
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 541, in run
    self.respond(pi)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 624, in respond
    self.handle_error()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 746, in handle_error
    self.error_response()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\root.py", line 44, in _cp_on_error
    message = errorpage.render()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\error_page.py", line 55, in render
    return self.__render(value)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\openobject\tools\_expose.py", line 199, in func_wrapper
    res = func(*args, **kw)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\error_page.py", line 75, in __render
    maintenance = proxy.status()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 396, in <lambda>
    return lambda *args: self._session.execute("object", "execute", self._resource, name, *args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 357, in execute
    return self.gateway.execute(obj, method, *args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 155, in execute
    return self.__execute(obj, method, args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 141, in __execute
    common.error(_('Application Error'), err.backtrace)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\common.py", line 74, in error
    raise TinyError(message=msg, title=title or _("Error"))
TinyError: Traceback (most recent call last):
  File "netsvc.pyo", line 489, in dispatch
  File "service\web_services.pyo", line 586, in dispatch
  File "osv\osv.pyo", line 57, in wrapper
  File "osv\osv.pyo", line 135, in execute
  File "sql_db.pyo", line 332, in cursor
  File "sql_db.pyo", line 92, in __init__
  File "sql_db.pyo", line 243, in _locked
  File "sql_db.pyo", line 293, in borrow
OperationalError: FATAL: database "admin" does not exist

[forstera (arnaud-forster-deactivatedaccount)]

ok, will test tomorrow,
Thanks

[GEM (nimp3)]

Hi
In the same way, problem cache firefox, with previous error in client web :

vista revision 3791
when I create a database with the client gtk and try to connect with the client web during the modules are installed and database is installed (configurator I check all in step "Install Applications"), I have this error :

Unrecoverable error in the server.
Traceback (most recent call last):
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 541, in run
    self.respond(pi)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 624, in respond
    self.handle_error()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\cherrypy-3.1.2-py2.5-win32.egg\cherrypy\_cprequest.py", line 746, in handle_error
    self.error_response()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\root.py", line 39, in _cp_on_error
    cherrypy.request.pool = openobject.pooler.get_pool()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\openobject\pooler.py", line 93, in get_pool
    addons.load_addons(db_name, config)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\openobject\addons.py", line 210, in load_addons
    new_modules = obj.get_new_modules()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\controllers\modules.py", line 54, in get_new_modules
    web_modules = modules.list_web()
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 396, in <lambda>
    return lambda *args: self._session.execute("object", "execute", self._resource, name, *args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 357, in execute
    return self.gateway.execute(obj, method, *args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 155, in execute
    return self.__execute(obj, method, args)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\rpc.py", line 137, in __execute
    common.warning(err.data)
  File "d:\OpenERP AllInOne\Web\python25\lib\site-packages\openerp_web-6.0.0_rc1-py2.5.egg\addons\openerp\utils\common.py", line 77, in warning
    raise TinyWarning(message=msg, title=title or _("Warning"))
TinyWarning: Currently, this database is not fully loaded and can not be used.

if I have the firefox cache deleted I have the normal page with the ok button :
Warning
 Currently, this database is not fully loaded and can not be used.
                                                                                       ok

Bye

[Xavier (Open ERP) (xmo-deactivatedaccount)]

Please avoid overloading existing bugs with new, different issues. I can not reproduce the third trace from last, and the last two should be separate issues, they have to do with the web client's management of server-reported errors rather than a bug in the web client itself.

[GEM (nimp3)]

Hi Xavier,
sorry but for error in root.py, there is just with the patch I give no error.

import openobject
from openobject import pooler
import form
and delete ',form' from the line 32
from openerp.controllers import SecuredController, unsecured, actions, login as tiny_login, form

Bye