Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009357Openbravo ERPA. Platformpublic2009-06-06 10:362009-06-09 00:00
Reporterjpabloae 
Assigned Tomarvintm 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionGentoo - 2.6.26
Product Versionpi 
Target VersionFixed in Version2.50MP2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009357: create.database: database.preimport.POSTGRE fails on column binarydata
DescriptionIt is not possible to create the database in PostgreSQL, it fails with this error:

database.preimport.POSTGRE:
Reading tables...
Reading views...
Reading sequences...
Reading triggers...
Reading functions...
Sorting foreign keys and checks...
Starting function and trigger standardization.
Model loaded from database.
Executed 416 SQL command(s) with 0 error(s)
Executed 2289 SQL command(s) with 0 error(s)
Executed 74 SQL command(s) with 0 error(s)
Error while inserting into the database: ERROR: column "binarydata" is of type bytea but expression is of type oid
End event threw exception
Error at line 10 char 25: org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: column "binarydata" is of type bytea but expression is of type oid
[importdata] org.apache.ddlutils.DdlUtilsException: org.apache.ddlutils.io.DataSinkException: org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: column "binarydata" is of type bytea but expression is of type oid
[importdata] at org.apache.ddlutils.io.DatabaseDataIO.writeDataToDatabase(DatabaseDataIO.java:895)
[importdata] at org.openbravo.ddlutils.task.ImportDataXML.doExecute(ImportDataXML.java:141)
[importdata] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:79)
[importdata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importdata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[importdata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importdata] at java.lang.reflect.Method.invoke(Method.java:597)
[importdata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[importdata] at org.apache.tools.ant.Task.perform(Task.java:348)
[importdata] at org.apache.tools.ant.Target.execute(Target.java:357)
[importdata] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[importdata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[importdata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importdata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[importdata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importdata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importdata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[importdata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importdata] at java.lang.reflect.Method.invoke(Method.java:597)
[importdata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[importdata] at org.apache.tools.ant.Task.perform(Task.java:348)
[importdata] at org.apache.tools.ant.Target.execute(Target.java:357)
[importdata] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[importdata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[importdata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importdata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[importdata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importdata] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
[importdata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importdata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[importdata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importdata] at java.lang.reflect.Method.invoke(Method.java:597)
[importdata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[importdata] at org.apache.tools.ant.Task.perform(Task.java:348)
[importdata] at org.apache.tools.ant.Target.execute(Target.java:357)
[importdata] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[importdata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[importdata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
[importdata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[importdata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[importdata] at org.apache.tools.ant.Main.runBuild(Main.java:758)
[importdata] at org.apache.tools.ant.Main.startAnt(Main.java:217)
[importdata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[importdata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
[importdata] Caused by: org.apache.ddlutils.io.DataSinkException: org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: column "binarydata" is of type bytea but expression is of type oid
[importdata] at org.apache.commons.digester.Digester.createSAXException(Digester.java:3181)
[importdata] at org.apache.commons.digester.Digester.createSAXException(Digester.java:3207)
[importdata] at org.apache.commons.digester.Digester.endElement(Digester.java:1225)
[importdata] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[importdata] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
[importdata] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
[importdata] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[importdata] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[importdata] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[importdata] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[importdata] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[importdata] at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
[importdata] at org.apache.commons.digester.Digester.parse(Digester.java:1728)
[importdata] at org.apache.ddlutils.io.DatabaseDataIO.writeDataToDatabase(DatabaseDataIO.java:893)
[importdata] ... 43 more
Steps To ReproduceRun "ant install.source" on rev id 1dbeb09b3b1f
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-06 10:36jpabloaeNew Issue
2009-06-06 10:36jpabloaeAssigned To => rafaroda
2009-06-06 10:36jpabloaeOBNetwork customer => No
2009-06-06 10:36jpabloaeNote Added: 0017055
2009-06-06 11:00iciordiaAssigned Torafaroda => marvintm
2009-06-06 20:03psarobeNote Added: 0017058
2009-06-08 08:50psarobeStatusnew => scheduled
2009-06-08 08:50psarobefix_in_branch => pi
2009-06-08 11:03hgbotCheckin
2009-06-08 11:03hgbotNote Added: 0017079
2009-06-08 11:03hgbotStatusscheduled => resolved
2009-06-08 11:03hgbotResolutionopen => fixed
2009-06-08 11:05hgbotCheckin
2009-06-08 11:05hgbotNote Added: 0017080
2009-06-08 11:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/194be8d7ded7f94c1236905b9becf07834af0d62 [^]
2009-06-08 12:07psarobeStatusresolved => closed
2009-06-08 12:07psarobeFixed in Version => 2.50MP2
2009-06-09 00:00anonymoussf_bug_id0 => 2803196

Notes
(0017055)
jpabloae   
2009-06-06 10:36   
Hudson build log:
http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/126/console [^]
(0017058)
psarobe   
2009-06-06 20:03   
Same issue in the QA machines
(0017079)
hgbot   
2009-06-08 11:03   
Repository: dbsourcemanager
Revision: 333
Author: marvintm
Date: 2009-06-08 11:02:59 +0200 (Mon, 08 Jun 2009)

Fixed issue 9357. Create.database should no longer fail in PostgreSQL due to NULL values in BLOB columns.

---
U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=333&sc=1 [^]
(0017080)
hgbot   
2009-06-08 11:05   
Repository: erp/devel/pi
Changeset: 194be8d7ded7f94c1236905b9becf07834af0d62
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Jun 08 11:02:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/194be8d7ded7f94c1236905b9becf07834af0d62 [^]

Fixed issue 9357. Create.database should no longer fail in PostgreSQL due to NULL values in BLOB columns.

---
M src-db/database/lib/dbsourcemanager.jar
---