OpenERP Connector - Magento

Error when updating connector module

Bug #1340742 reported by Corinne Cobbel
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenERP Connector - Magento
Incomplete
Undecided
Unassigned

Bug Description

Hello,

Since we upgraded to the latest version of the connector (July 06) we have the following error when trying to update :

2014-07-11 12:49:29,526 8918 INFO dupray01 openerp.modules.migration: module connector: Running migration [>2.2.0] Convert jobs pickled func to bytea
2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp.sql_db: Programming error: function convert_to(bytea, unknown) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
, in query ALTER TABLE queue_job ALTER func TYPE bytea USING convert_to(func, 'LATIN1')
2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp: Failed to initialize database `dupray01`.
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/cli/server.py", line 98, in preload_registry
    db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 218, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 344, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 259, 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.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 161, in load_module_graph
    migrations.migrate_module(package, 'pre')
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/migration.py", line 186, in migrate_module
    mod.migrate(self.cr, pkg.installed_version)
  File "connector/migrations/2.2.0/pre-migration.py", line 8, in migrate
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: function convert_to(bytea, unknown) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Can you help
Thanks

Revision history for this message
Guewen Baconnier @ Camptocamp (gbaconnier-c2c) wrote : Re: [Bug 1340742] [NEW] Error when updating connector module
Download full text (6.8 KiB)

What version of postgresql do you use?
Le 11 juil. 2014 15:25, "Corinne Cobbel" <email address hidden> a
écrit :

> Public bug reported:
>
> Hello,
>
> Since we upgraded to the latest version of the connector (July 06) we
> have the following error when trying to update :
>
> 2014-07-11 12:49:29,526 8918 INFO dupray01 openerp.modules.migration:
> module connector: Running migration [>2.2.0] Convert jobs pickled func to
> bytea
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp.sql_db: Programming
> error: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> , in query ALTER TABLE queue_job ALTER func TYPE bytea USING
> convert_to(func, 'LATIN1')
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp: Failed to initialize
> database `dupray01`.
> Traceback (most recent call last):
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/cli/server.py",
> line 98, in preload_registry
> db, registry =
> openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/pooler.py",
> line 33, in get_db_and_pool
> registry = RegistryManager.get(db_name, force_demo, status,
> update_module)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py",
> line 192, in get
> update_module)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py",
> line 218, in new
> openerp.modules.load_modules(registry.db, force_demo, status,
> update_module)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
> line 344, in load_modules
> processed = load_marked_modules(cr, graph, states_to_load, force,
> status, report, loaded_modules, update_module)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
> line 259, 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.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
> line 161, in load_module_graph
> migrations.migrate_module(package, 'pre')
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/migration.py",
> line 186, in migrate_module
> mod.migrate(self.cr, pkg.installed_version)
> File "connector/migrations/2.2.0/pre-migration.py", line 8, in migrate
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py",
> line 161, in wrapper
> return f(self, *args, **kwargs)
> File
> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py",
> line 226, in execute
> res = self._obj.execute(query, params)
> ProgrammingError: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument...

Read more...

Revision history for this message
Corinne Cobbel (ccobbel) wrote :
Download full text (10.5 KiB)

Postgresql V9.1

Le 2014-07-11 à 16:02, "Guewen Baconnier @ Camptocamp" <email address hidden> a écrit :

> What version of postgresql do you use?
> Le 11 juil. 2014 15:25, "Corinne Cobbel" <email address hidden> a
> écrit :
>
>> Public bug reported:
>>
>> Hello,
>>
>> Since we upgraded to the latest version of the connector (July 06) we
>> have the following error when trying to update :
>>
>> 2014-07-11 12:49:29,526 8918 INFO dupray01 openerp.modules.migration:
>> module connector: Running migration [>2.2.0] Convert jobs pickled func to
>> bytea
>> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp.sql_db: Programming
>> error: function convert_to(bytea, unknown) does not exist
>> HINT: No function matches the given name and argument types. You might
>> need to add explicit type casts.
>> , in query ALTER TABLE queue_job ALTER func TYPE bytea USING
>> convert_to(func, 'LATIN1')
>> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp: Failed to initialize
>> database `dupray01`.
>> Traceback (most recent call last):
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/cli/server.py",
>> line 98, in preload_registry
>> db, registry =
>> openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/pooler.py",
>> line 33, in get_db_and_pool
>> registry = RegistryManager.get(db_name, force_demo, status,
>> update_module)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py",
>> line 192, in get
>> update_module)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py",
>> line 218, in new
>> openerp.modules.load_modules(registry.db, force_demo, status,
>> update_module)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
>> line 344, in load_modules
>> processed = load_marked_modules(cr, graph, states_to_load, force,
>> status, report, loaded_modules, update_module)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
>> line 259, 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.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py",
>> line 161, in load_module_graph
>> migrations.migrate_module(package, 'pre')
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/migration.py",
>> line 186, in migrate_module
>> mod.migrate(self.cr, pkg.installed_version)
>> File "connector/migrations/2.2.0/pre-migration.py", line 8, in migrate
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py",
>> line 161, in wrapper
>> return f(self, *args, **kwargs)
>> File
>> "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py",
>> line 226, in execute
>> ...

Revision history for this message
Guewen Baconnier @ Camptocamp (gbaconnier-c2c) wrote :

The migration script changes the column 'func' from text to a bytea column, while keeping content in the correct format.
It fails because the column is *already* a bytea column. I don't how it could happen because the migration script is not supposed to run twice. The solution for you is to comment the content of the file connector/migrations/2.2.0/pre-migration.py before the upgrade.

Changed in openerp-connector-magento:
status: New → Incomplete
Revision history for this message
Guewen Baconnier @ Camptocamp (gbaconnier-c2c) wrote :

I put the state to "Incomplete" because I can't find how to reproduce it.

Revision history for this message
Corinne Cobbel (ccobbel) wrote : Re: [Bug 1340742] Re: Error when updating connector module
Download full text (3.8 KiB)

Is there a special sequence to install and\or upgrade the 3 conector modules ?
Our Odoo version is one year old, can it be an issue with this connectors version?
Thanks

> Le 2014-07-15 à 13:29, "Guewen Baconnier @ Camptocamp" <email address hidden> a écrit :
>
> I put the state to "Incomplete" because I can't find how to reproduce
> it.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1340742
>
> Title:
> Error when updating connector module
>
> Status in OpenERP Connector - Magento:
> Incomplete
>
> Bug description:
> Hello,
>
> Since we upgraded to the latest version of the connector (July 06) we
> have the following error when trying to update :
>
> 2014-07-11 12:49:29,526 8918 INFO dupray01 openerp.modules.migration: module connector: Running migration [>2.2.0] Convert jobs pickled func to bytea
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp.sql_db: Programming error: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.
> , in query ALTER TABLE queue_job ALTER func TYPE bytea USING convert_to(func, 'LATIN1')
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp: Failed to initialize database `dupray01`.
> Traceback (most recent call last):
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/cli/server.py", line 98, in preload_registry
> db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/pooler.py", line 33, in get_db_and_pool
> registry = RegistryManager.get(db_name, force_demo, status, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 192, in get
> update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 218, in new
> openerp.modules.load_modules(registry.db, force_demo, status, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 344, in load_modules
> processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 259, 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.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 161, in load_module_graph
> migrations.migrate_module(package, 'pre')
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/migration.py", line 186, in migrate_module
> mod.migrate(self.cr, pkg.installed_version)
> File "connector/migrations/2.2.0/pre-migration.py", line 8, in migrate
> File "/usr/l...

Read more...

Revision history for this message
Corinne Cobbel (ccobbel) wrote :

Guewen,

We started with a fresh data base and installed directly the new code.
Everything is good.
Thank you very much

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.