openerp-india team mailing list archive

Thread
Date
[Bug 1092549] [NEW] Fails creating new database, PostgreSQL 9.1+

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: David Bowers <sales@xxxxxxxxxxxxx>
Date: Thu, 20 Dec 2012 14:04:50 -0000
Reply-to: Bug 1092549 <1092549@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Fails to base64 decode partner image during database creation.

Create any new database with or without demo data.
OpenERP: openerp-7.0alpha-20121206-000102 from openerp-server-setup-7.0alpha-20121206-000102 pulled out of the allinone setup. (because of the openpgpwd password bug where the password is still not passed from the allinone installer to the server installer, just look at the commandline).
Windows 7 x64 SP1.
PostgreSQL 8.3: OK
PostgreSQL 9.2.2: FAILS

No error if OpenERP runs on PostgreSQL 8.3 either from the all in 1 installer, or my own install of 8.3.
Error occurs if I try to run it on PostgreSQL 9.1.7 x64, 9.2.2 or 9.2.2 x64.
Occurs for PostgreSQL locale set to any of default, C, en_GB or en_US (I installed PostgreSQL 9.1/9.2 many times using various locales).

Note: had to manually add in missing files from pytz (missing
practically everything) and docutils (missing template.txt etc).

Is there a difference in how various versions of PostgreSQL store base64
encoded binary data, especially when the image is missing?

If you comment out the main_partner, it gets past that point, but then
of course fails further on because that record is missing and gets
referenced.

Trace of creating fresh database with no demo data:
2012-12-20 21:40:36,398 5816 INFO None openerp.service.web_services: Create database `testit`.
2012-12-20 21:40:37,785 5816 INFO testit openerp.modules.loading: module base: loading objects
2012-12-20 21:40:37,805 5816 INFO testit openerp.modules.module: module base: creating or updating database tables
2012-12-20 21:40:39,755 5816 INFO testit openerp.osv.orm: Computing parent left and right for table res_partner_category...
2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'report_file'
2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'global'
2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'web_icon_data'
2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'web_icon_hover_data'
2012-12-20 21:40:40,821 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'menus_by_module'
2012-12-20 21:40:40,921 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'reports_by_module'
2012-12-20 21:40:41,016 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'views_by_module'
2012-12-20 21:40:41,112 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'image_medium'
2012-12-20 21:40:41,114 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'image_small'
2012-12-20 21:40:41,118 5816 INFO testit openerp.modules.loading: module base: loading base_data.xml
2012-12-20 21:40:41,207 5816 WARNING testit openerp.addons.base.res.res_lang: Unable to get information for locale en_GB. Information from the default locale (en_AU) have been used.
2012-12-20 21:40:41,256 5816 ERROR testit openerp.tools.convert: Parse error in file:///D:/OpenERP/OpenERP%207.0alpha-20121206-000102/server/openerp/addons/base/base_data.xml:32: 
<record id="main_partner" model="res.partner" context="{'default_is_company': True}">
            <field name="name">Your Company</field>
            <field name="company_id" eval="None"/>
            <field name="customer" eval="False"/>
            <field name="is_company" eval="True"/>
            <field name="street"/>
            <field name="city"/>
            <field name="zip"/>
            <field name="phone"/>
            <field name="email">info@xxxxxxxxxxxxxxx</field>
            <field name="website">www.yourcompany.com</field>
        </record>
Traceback (most recent call last):
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 848, in parse
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 815, in _tag_record
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\ir\ir_model.py", line 956, in _update
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 389, in create
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4448, in create
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4570, in _store_set_values
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\fields.py", line 1116, in get
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 179, in _get_image
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 156, in image_get_resized_images
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 94, in image_resize_image_medium
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 64, in image_resize_image
  File "encodings\base64_codec.pyo", line 42, in base64_decode
  File "base64.pyo", line 321, in decodestring
Error: Incorrect padding
2012-12-20 21:40:41,257 5816 ERROR testit openerp.service.web_services: CREATE DATABASE failed:
Traceback (most recent call last):
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 71, in _initialize_db
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\pooler.py", line 39, in restart_pool
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\registry.py", line 178, in new
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 296, in load_modules
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 187, in load_module_graph
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 77, in <lambda>
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 128, in _load_data
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 955, in convert_xml_import
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 848, in parse
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 815, in _tag_record
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\ir\ir_model.py", line 956, in _update
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 389, in create
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4448, in create
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4570, in _store_set_values
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\fields.py", line 1116, in get
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 179, in _get_image
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 156, in image_get_resized_images
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 94, in image_resize_image_medium
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 64, in image_resize_image
  File "encodings\base64_codec.pyo", line 42, in base64_decode
  File "base64.pyo", line 321, in decodestring
Error: Incorrect padding
2012-12-20 21:40:41,259 5816 ERROR testit openerp.netsvc: Unable to use a closed cursor.
Traceback (most recent call last):
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\netsvc.py", line 361, in dispatch_rpc
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 117, in dispatch
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 157, in exp_create_database
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 93, in _initialize_db
  File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\sql_db.py", line 161, in wrapper
OperationalError: Unable to use a closed cursor.
2012-12-20 21:40:41,263 5816 INFO testit werkzeug: 127.0.0.1 - - [20/Dec/2012 21:40:41] "POST /web/database/create HTTP/1.1" 200 -

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1092549

Title:
  Fails creating new database, PostgreSQL 9.1+

Status in OpenERP Server:
  New

Bug description:
  Fails to base64 decode partner image during database creation.

  Create any new database with or without demo data.
  OpenERP: openerp-7.0alpha-20121206-000102 from openerp-server-setup-7.0alpha-20121206-000102 pulled out of the allinone setup. (because of the openpgpwd password bug where the password is still not passed from the allinone installer to the server installer, just look at the commandline).
  Windows 7 x64 SP1.
  PostgreSQL 8.3: OK
  PostgreSQL 9.2.2: FAILS

  No error if OpenERP runs on PostgreSQL 8.3 either from the all in 1 installer, or my own install of 8.3.
  Error occurs if I try to run it on PostgreSQL 9.1.7 x64, 9.2.2 or 9.2.2 x64.
  Occurs for PostgreSQL locale set to any of default, C, en_GB or en_US (I installed PostgreSQL 9.1/9.2 many times using various locales).

  Note: had to manually add in missing files from pytz (missing
  practically everything) and docutils (missing template.txt etc).

  Is there a difference in how various versions of PostgreSQL store
  base64 encoded binary data, especially when the image is missing?

  If you comment out the main_partner, it gets past that point, but then
  of course fails further on because that record is missing and gets
  referenced.

  Trace of creating fresh database with no demo data:
  2012-12-20 21:40:36,398 5816 INFO None openerp.service.web_services: Create database `testit`.
  2012-12-20 21:40:37,785 5816 INFO testit openerp.modules.loading: module base: loading objects
  2012-12-20 21:40:37,805 5816 INFO testit openerp.modules.module: module base: creating or updating database tables
  2012-12-20 21:40:39,755 5816 INFO testit openerp.osv.orm: Computing parent left and right for table res_partner_category...
  2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'report_file'
  2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'global'
  2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'web_icon_data'
  2012-12-20 21:40:40,819 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'web_icon_hover_data'
  2012-12-20 21:40:40,821 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'menus_by_module'
  2012-12-20 21:40:40,921 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'reports_by_module'
  2012-12-20 21:40:41,016 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'views_by_module'
  2012-12-20 21:40:41,112 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'image_medium'
  2012-12-20 21:40:41,114 5816 INFO testit openerp.osv.orm: storing computed values of fields.function 'image_small'
  2012-12-20 21:40:41,118 5816 INFO testit openerp.modules.loading: module base: loading base_data.xml
  2012-12-20 21:40:41,207 5816 WARNING testit openerp.addons.base.res.res_lang: Unable to get information for locale en_GB. Information from the default locale (en_AU) have been used.
  2012-12-20 21:40:41,256 5816 ERROR testit openerp.tools.convert: Parse error in file:///D:/OpenERP/OpenERP%207.0alpha-20121206-000102/server/openerp/addons/base/base_data.xml:32: 
  <record id="main_partner" model="res.partner" context="{'default_is_company': True}">
              <field name="name">Your Company</field>
              <field name="company_id" eval="None"/>
              <field name="customer" eval="False"/>
              <field name="is_company" eval="True"/>
              <field name="street"/>
              <field name="city"/>
              <field name="zip"/>
              <field name="phone"/>
              <field name="email">info@xxxxxxxxxxxxxxx</field>
              <field name="website">www.yourcompany.com</field>
          </record>
  Traceback (most recent call last):
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 848, in parse
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 815, in _tag_record
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\ir\ir_model.py", line 956, in _update
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 389, in create
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4448, in create
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4570, in _store_set_values
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\fields.py", line 1116, in get
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 179, in _get_image
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 156, in image_get_resized_images
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 94, in image_resize_image_medium
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 64, in image_resize_image
    File "encodings\base64_codec.pyo", line 42, in base64_decode
    File "base64.pyo", line 321, in decodestring
  Error: Incorrect padding
  2012-12-20 21:40:41,257 5816 ERROR testit openerp.service.web_services: CREATE DATABASE failed:
  Traceback (most recent call last):
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 71, in _initialize_db
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\pooler.py", line 39, in restart_pool
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\registry.py", line 178, in new
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 296, in load_modules
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 187, in load_module_graph
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 77, in <lambda>
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\modules\loading.py", line 128, in _load_data
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 955, in convert_xml_import
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 848, in parse
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\convert.py", line 815, in _tag_record
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\ir\ir_model.py", line 956, in _update
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 389, in create
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4448, in create
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\orm.py", line 4570, in _store_set_values
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\osv\fields.py", line 1116, in get
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\openerp\addons\base\res\res_partner.py", line 179, in _get_image
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 156, in image_get_resized_images
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 94, in image_resize_image_medium
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\tools\image.py", line 64, in image_resize_image
    File "encodings\base64_codec.pyo", line 42, in base64_decode
    File "base64.pyo", line 321, in decodestring
  Error: Incorrect padding
  2012-12-20 21:40:41,259 5816 ERROR testit openerp.netsvc: Unable to use a closed cursor.
  Traceback (most recent call last):
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\netsvc.py", line 361, in dispatch_rpc
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 117, in dispatch
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 157, in exp_create_database
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\service\web_services.py", line 93, in _initialize_db
    File "D:\OpenERP\OpenERP 7.0alpha-20121206-000102\server\.\openerp\sql_db.py", line 161, in wrapper
  OperationalError: Unable to use a closed cursor.
  2012-12-20 21:40:41,263 5816 INFO testit werkzeug: 127.0.0.1 - - [20/Dec/2012 21:40:41] "POST /web/database/create HTTP/1.1" 200 -

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1092549/+subscriptions
Follow ups

[Bug 1092549] Re: Fails creating new database, PostgreSQL 9.1+
From: David Bowers, 2012-12-22
[Bug 1092549] [NEW] Fails creating new database, PostgreSQL 9.1+
From: David Bowers, 2012-12-20
References

[Bug 1092549] [NEW] Fails creating new database, PostgreSQL 9.1+
From: David Bowers, 2012-12-20