← Back to team overview

credativ team mailing list archive

[Bug 1292862] [NEW] [7.0] Cannot migrate a database with testdata

 

Public bug reported:

I get the following error,

apart from res.user errors,
I get stuck at a query in res.partner , see the end of the log file. It tries to create a row with a Null value in a required column. I guess migrating test databases (OERP testdata) should just work.....

2014-03-14 11:28:03,222 14965 ERROR A03_14_testdata_db openerp.sql_db: bad query: insert into "res_partner" (id,"lang","customer","tz","color","image","company_id","use_parent_address","supplier","employee","active","type","is_company",create_uid,create_date,write_uid,write_date) values (65,'en_US','True',NULL,0,'\x6956424f5277304b47676f414141414e5355684555674141414659414141434143415941414143524d5a37464141416741456c4551565234587057394235686b5a334875587a335463584c61325a787a31456246565934674353514549706767454d6e47786c646b673046674844454f3177594d686775327565626943385932594275546853516b4a4b3343537276614f4c737a75354e7a37756b4a665839766e66504e746762682f2f4e7650614f64365844366e5072717133727272584153762f384f7a425264694f466d746442436942426c4f4b447758466b627630794f632b454a4e44414b636d5a7961502f5a436f59594c6672486e772f476d4f623858577a4139703857646d346d55594e356d6c746a71734d7357666b2f34724a3550785362766c375a36764b427a73536b49357a6a2f766a76656646396b593756714a5676494e5156427a78577873644d7a4c73424d4d6d5735696f776c4f5a69656d357161744c6e736332724d416b72743232332b6d55726254615a3570787a306b735830487851494a764a393469397736624e793355683374554c364f753838394c697a78566e334554e2374533622f6335346745333633784c5559452b6f384a7050594b354b6b5549775a6b464f43716c444e7843346e4a79586d653565586954422b714b715630766171306a4c715a775141455355614d43326d6859613645653958314f5a505a6f445277663035494c694d5a474678334e304849744a566f4c654c4a4977556249526b516b4437316e59702f695247476f557064674e55784e384576366f5346764551794c78716347652b31656e2b2b52456f784363477561737073417a62754a692b5a6b592f38663037504d754d6a6a43774d41414141415355564f524b35435949493d'::bytea,1,'False','False','False','True','contact','False',1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/home/jeroen/workspace/OU/source/code/openupgrade-server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "name" violates not-null constraint

2014-03-14 11:28:03,230 14965 ERROR A03_14_testdata_db openerp.tools.convert: Parse error in /home/jeroen/workspace/OU/source/code/openupgrade-server/openerp/addons/base/res/res_partner_image_demo.xml:17: 
<record id="base.res_partner_address_5" model="res.partner">

Ideally, OpenUpgrade should be able to migrate a database with existing
demo data, without loading the demo data from the new version. This is
what server revno. 4620 attempts, but apparently it is not enough.

** Affects: openupgrade-server
     Importance: Low
         Status: New

** Summary changed:

- Cannot migrate a database with testdata
+ [7.0] Cannot migrate a database with testdata

** Changed in: openupgrade-server
   Importance: Undecided => Low

-- 
You received this bug notification because you are a member of
OpenUpgrade Committers, which is subscribed to OpenUpgrade Server.
https://bugs.launchpad.net/bugs/1292862

Title:
  [7.0] Cannot migrate a database with testdata

Status in OpenUpgrade Server:
  New

Bug description:
  I get the following error,

  apart from res.user errors,
  I get stuck at a query in res.partner , see the end of the log file. It tries to create a row with a Null value in a required column. I guess migrating test databases (OERP testdata) should just work.....

  2014-03-14 11:28:03,222 14965 ERROR A03_14_testdata_db openerp.sql_db: bad query: insert into "res_partner" (id,"lang","customer","tz","color","image","company_id","use_parent_address","supplier","employee","active","type","is_company",create_uid,create_date,write_uid,write_date) values (65,'en_US','True',NULL,0,'\x6956424f5277304b47676f414141414e5355684555674141414659414141434143415941414143524d5a37464141416741456c4551565234587057394235686b5a334875587a335463584c61325a787a31456246565934674353514549706767454d6e47786c646b673046674844454f3177594d686775327565626943385932594275546853516b4a4b3343537276614f4c737a75354e7a37756b4a665839766e66504e746762682f2f4e7650614f64365844366e5072717133727272584153762f384f7a425264694f466d746442436942426c4f4b447758466b627630794f632b454a4e44414b636d5a7961502f5a436f59594c6672486e772f476d4f623858577a4139703857646d346d55594e356d6c746a71734d7357666b2f34724a3550785362766c375a36764b427a73536b49357a6a2f766a76656646396b593756714a5676494e5156427a78577873644d7a4c73424d4d6d5735696f776c4f5a69656d357161744c6e736332724d416b72743232332b6d55726254615a3570787a306b735830487851494a764a393469397736624e793355683374554c364f753838394c697a78566e334554e2374533622f6335346745333633784c5559452b6f384a7050594b354b6b5549775a6b464f43716c444e7843346e4a79586d653565586954422b714b715630766171306a4c715a775141455355614d43326d6859613645653958314f5a505a6f445277663035494c694d5a474678334e304849744a566f4c654c4a4977556249526b516b4437316e59702f695247476f557064674e55784e384576366f5346764551794c78716347652b31656e2b2b52456f784363477561737073417a62754a692b5a6b592f38663037504d754d6a6a43774d41414141415355564f524b35435949493d'::bytea,1,'False','False','False','True','contact','False',1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'))
  Traceback (most recent call last):
    File "/home/jeroen/workspace/OU/source/code/openupgrade-server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "name" violates not-null constraint

  2014-03-14 11:28:03,230 14965 ERROR A03_14_testdata_db openerp.tools.convert: Parse error in /home/jeroen/workspace/OU/source/code/openupgrade-server/openerp/addons/base/res/res_partner_image_demo.xml:17: 
  <record id="base.res_partner_address_5" model="res.partner">

  Ideally, OpenUpgrade should be able to migrate a database with
  existing demo data, without loading the demo data from the new
  version. This is what server revno. 4620 attempts, but apparently it
  is not enough.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openupgrade-server/+bug/1292862/+subscriptions


Follow ups

References