logout login fails

[Gerhard du Toit]

Running 5.0.12 server and webclient firefox 3.6.6 on ubuntu 10.04 localhost

When running for a while on one database, then logout and try to login with another database i get the following error. After restarting the server everything is okay again.

Unrecoverable error in the server.
Traceback (most recent call last):
  File "/mnt/downloads/OpenERP/oocrm-web/lib/cherrypy/_cprequest.py", line 541, in run
    self.respond(pi)
  File "/mnt/downloads/OpenERP/oocrm-web/lib/cherrypy/_cprequest.py", line 624, in respond
    self.handle_error()
  File "/mnt/downloads/OpenERP/oocrm-web/lib/cherrypy/_cprequest.py", line 746, in handle_error
    self.error_response()
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/controllers/root.py", line 52, in _cp_on_error
    message = errorpage.render()
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/controllers/error_page.py", line 61, in render
    return self.__render(value)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/tools/expose.py", line 204, in func_wrapper
    res = func(*args, **kw)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/controllers/error_page.py", line 81, in __render
    oocrm_edition = self.is_edition()
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/controllers/error_page.py", line 119, in is_edition
    edition = proxy_mdl.search([('name', 'ilike', 'oocrm.edition')], 0, 0, 0, rpc.session.context)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/rpc.py", line 390, in <lambda>
    return lambda *args: self._session.execute("object", "execute", self._resource, name, *args)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/rpc.py", line 351, in execute
    return self.gateway.execute(obj, method, *args)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/rpc.py", line 153, in execute
    return self.__execute(obj, method, args)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/rpc.py", line 139, in __execute
    raise common.error(_('Application Error!'), err.backtrace)
  File "/mnt/downloads/OpenERP/oocrm-web/openerp/common.py", line 72, in error
    raise TinyError(message=msg, title=title or _("Error"))
TinyError: Traceback (most recent call last):
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/service/web_services.py", line 575, in execute
    security.check(db, uid, passwd)
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/addons/use_control/services.py", line 43, in check_one
    cr.execute('SELECT name FROM use_control_db_block')
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/mnt/downloads/OpenERP/openerp-server-5.0.12/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "use_control_db_block" does not exist
LINE 1: SELECT name FROM use_control_db_block

[Nhomar - Vauxoo (nhomar)]

I received exactly the same error.... I tried in the GTK Client and Web Client.

ERROR:common.message:Message relation "use_control_db_block" does not exist
:
Environment Information :
System : Linux-2.6.31-21-generic-i686-with-Ubuntu-9.10-karmic
OS Name : posix
LSB Version: core-2.0-ia32:core-2.0-noarch:core-3.0-ia32:core-3.0-noarch:core-3.1-ia32:core-3.1-noarch:core-3.2-ia32:core-3.2-noarch:core-4.0-ia32:core-4.0-noarch:cxx-3.0-ia32:cxx-3.0-noarch:cxx-3.1-ia32:cxx-3.1-noarch:cxx-3.2-ia32:cxx-3.2-noarch:cxx-4.0-ia32:cxx-4.0-noarch:desktop-3.1-ia32:desktop-3.1-noarch:desktop-3.2-ia32:desktop-3.2-noarch:desktop-4.0-ia32:desktop-4.0-noarch:graphics-2.0-ia32:graphics-2.0-noarch:graphics-3.0-ia32:graphics-3.0-noarch:graphics-3.1-ia32:graphics-3.1-noarch:graphics-3.2-ia32:graphics-3.2-noarch:graphics-4.0-ia32:graphics-4.0-noarch:qt4-3.1-ia32:qt4-3.1-noarch
Distributor ID: Ubuntu
Description: Ubuntu 9.10
Release: 9.10
Codename: karmic
Operating System Release : 2.6.31-21-generic
Operating System Version : #59-Ubuntu SMP Wed Mar 24 07:28:56 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : es_ES.UTF8
Python Version : 2.6.4
OpenERP-Client Version : 5.0.12
Last revision No. & ID :1085 <email address hidden>
Traceback (most recent call last):
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/service/web_services.py", line 575, in execute
    security.check(db, uid, passwd)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/addons/use_control/services.py", line 43, in check_one
    cr.execute('SELECT name FROM use_control_db_block')
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "use_control_db_block" does not exist

Traceback (most recent call last):
  File "./openerp-client.py", line 138, in <module>
    win.sig_login()
  File "/home/nhomar/proyectos_bazaar/client5.0/bin/modules/gui/main.py", line 1058, in sig_login
    log_response = rpc.session.login(*res)
  File "/home/nhomar/proyectos_bazaar/client5.0/bin/rpc.py", line 234, in login
    self.context_reload()
  File "/home/nhomar/proyectos_bazaar/client5.0/bin/rpc.py", line 290, in context_reload
    self.context = self.rpc_exec_auth('/object', 'execute', 'res.users', 'context_get') or {}
  File "/home/nhomar/proyectos_bazaar/client5.0/bin/rpc.py", line 187, in rpc_exec_auth
    common.error(_('Application Error'), e.faultCode, e.faultString)
  File "/home/nhomar/proyectos_bazaar/client5.0/bin/common/common.py", line 342, in error
    maintenance = rpc.session.rpc_exec_auth_try('/object', 'execute', 'maintenance.contract', 'status')
  File...

[Nhomar - Vauxoo (nhomar)]

How can you reproduce this error:

install 2 databases..... with crm and crm_configuration modules with all options, add some example files by FTP in both data bases installations.....

Try to log in the another one.... It broke..

 In the log of server I only receive this (checking the log file)

No LSB modules are available.
No LSB modules are available.
No LSB modules are available.
No LSB modules are available.
No LSB modules are available.
sh: pdftotext: not found

[Nhomar - Vauxoo (nhomar)]

I correct.... You dont receive _anything_ in server log... these logs were olds....

[Nhomar - Vauxoo (nhomar)]

In web client i receive:

Unrecoverable error in the server.
Traceback (most recent call last):
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/lib/CherryPy-3.1.2-py2.5.egg/cherrypy/_cprequest.py", line 541, in run
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/lib/CherryPy-3.1.2-py2.5.egg/cherrypy/_cprequest.py", line 624, in respond
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/lib/CherryPy-3.1.2-py2.5.egg/cherrypy/_cprequest.py", line 746, in handle_error
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/controllers/root.py", line 52, in _cp_on_error
    message = errorpage.render()
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/controllers/error_page.py", line 61, in render
    return self.__render(value)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/tools/expose.py", line 204, in func_wrapper
    res = func(*args, **kw)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/controllers/error_page.py", line 81, in __render
    maintenance = proxy.status()
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/rpc.py", line 390, in <lambda>
    return lambda *args: self._session.execute("object", "execute", self._resource, name, *args)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/rpc.py", line 351, in execute
    return self.gateway.execute(obj, method, *args)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/rpc.py", line 153, in execute
    return self.__execute(obj, method, args)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/rpc.py", line 139, in __execute
    raise common.error(_('Application Error!'), err.backtrace)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/web-client/openerp/common.py", line 72, in error
    raise TinyError(message=msg, title=title or _("Error"))
TinyError: Traceback (most recent call last):
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/service/web_services.py", line 575, in execute
    security.check(db, uid, passwd)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/addons/use_control/services.py", line 43, in check_one
    cr.execute('SELECT name FROM use_control_db_block')
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/home/nhomar/openerp/stable/5.0/instancias/netquatro/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "use_control_db_block" does not exist

[xrg (xrg)]

On Wednesday 04 August 2010, you wrote:
> I received exactly the same error.... I tried in the GTK Client and Web
> Client.
>
> ERROR:common.message:Message relation "use_control_db_block" does not exist
>
What is that table? Does it belong to some "use.control.db.block" object? If
so, please try to locate which module it comes from, because it doesn't seem
like a known one (certainly is NOT in document).

[Nhomar - Vauxoo (nhomar)]

Hello.....

if you look on extra-addons "use_control_db_block" is a module _part of core_ called on demmand use control, for some reason this module was deleted of my db, and when it tried to switch between 2 databases the server broken. I will mark this module as invalid until i can demostrate that it was a problem of "Finger!" or "System".

regards

[Gerhard du Toit (gdutoit)]

Please assist?
This problems remains and every-time I want to login onto another database I must restart the server.

[Gerhard du Toit (gdutoit)]

I may have found a solution. I had this problem in my test environment where I simply copy in all modules from extra-addons. The module "use_control" is one of them.

What I do not know or understand is what installed it because I cannot recall installing it. (Is it possible that it installs itself it if it is available in the addons path?)

Anyway, I deleted the module from addons in the server, restarted and in the database(s) where it was installed I un-installed it. And in future, do not have this module in addons.

An now everything is working fine.
I shall appreciate any comments if I am possibly digging a hole for myself with this solution.

[Borja López Soilán (NeoPolus) (borjals)]

Gerhard du Toit as you say that module installs itself automatically when you launch OpenERP:

If you look in the __terp__.py or __openerp__.py files of any module, you will find a line like:
     'active': False,
But if you look in the use_control module or the base module, you will find the line to be like this:
    'active': True,

That means that those modules are active by default, without the need of installing.

And if you are wondering what is the use_control module (and why it needs to auto-install itself): it seems to be used by OpenERP S.A. on their "software as a service" (http://www.odoo.com/) systems to control the usage of OpenERP by its customers. It is always active to prevent ODOO customers from uninstalling it.

[Gerhard du Toit (gdutoit)]

Borja López Soilán,
Thank you very much for this explanation.
This helps a lot.