Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009357 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | critical | always | 2009-06-06 10:36 | 2009-06-09 00:00 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP2 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 194be8d7ded7 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | Gentoo - 2.6.26 | Database version | 8.3.5 | Ant version | 1.7.0 | |||
| Product Version | pi | SCM revision | 1dbeb09b3b1f | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009357: create.database: database.preimport.POSTGRE fails on column binarydata | |||||||
| Description | It 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 Reproduce | Run "ant install.source" on rev id 1dbeb09b3b1f | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017055) jpabloae (viewer) 2009-06-06 10:36 |
Hudson build log: http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/126/console [^] |
|
(0017058) psarobe (viewer) 2009-06-06 20:03 |
Same issue in the QA machines |
|
(0017079) hgbot (developer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-06 10:36 | jpabloae | New Issue | |
| 2009-06-06 10:36 | jpabloae | Assigned To | => rafaroda |
| 2009-06-06 10:36 | jpabloae | OBNetwork customer | => No |
| 2009-06-06 10:36 | jpabloae | Note Added: 0017055 | |
| 2009-06-06 11:00 | iciordia | Assigned To | rafaroda => marvintm |
| 2009-06-06 20:03 | psarobe | Note Added: 0017058 | |
| 2009-06-08 08:50 | psarobe | Status | new => scheduled |
| 2009-06-08 08:50 | psarobe | fix_in_branch | => pi |
| 2009-06-08 11:03 | hgbot | Checkin | |
| 2009-06-08 11:03 | hgbot | Note Added: 0017079 | |
| 2009-06-08 11:03 | hgbot | Status | scheduled => resolved |
| 2009-06-08 11:03 | hgbot | Resolution | open => fixed |
| 2009-06-08 11:05 | hgbot | Checkin | |
| 2009-06-08 11:05 | hgbot | Note Added: 0017080 | |
| 2009-06-08 11:05 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/194be8d7ded7f94c1236905b9becf07834af0d62 [^] |
| 2009-06-08 12:07 | psarobe | Status | resolved => closed |
| 2009-06-08 12:07 | psarobe | Fixed in Version | => 2.50MP2 |
| 2009-06-09 00:00 | anonymous | sf_bug_id | 0 => 2803196 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |