ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From René Bos (JIRA) <j...@apache.org>
Subject [jira] [Commented] (ODE-787) column "detailsext" is of type bytea but expression is of type oid
Date Fri, 17 May 2013 08:55:16 GMT

    [ https://issues.apache.org/jira/browse/ODE-787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13660486#comment-13660486
] 

René Bos commented on ODE-787:
------------------------------

I can confirm this is working when I converted the bytea column to be oid.

I think the problem happend because we made the "detailsExt" column be the same datatype as
the old "details" column.

Changing the datatype from bytea to oid can be done with the following SQL:

UPDATE ODE_JOB SET detailsExt = (
    SELECT oid FROM (
      SELECT oid, lowrite(lo_open(oid, 131072), ODE_JOB.details)
      FROM lo_create(0) o(oid)) x); 

I executed this instead of "update ODE_JOB oj set detailsExt = (select details from ODE_JOB
where jobid = oj.jobid);" as stated in the original upgrade script.

Thanks!
                
> column "detailsext" is of type bytea but expression is of type oid
> ------------------------------------------------------------------
>
>                 Key: ODE-787
>                 URL: https://issues.apache.org/jira/browse/ODE-787
>             Project: ODE
>          Issue Type: Bug
>          Components: BPEL Runtime
>    Affects Versions: 1.3.5, 2.0-beta3
>         Environment: Linux localhost.localdomain 2.6.32.9-70.fc12.x86_64 #1 SMP Wed Mar
3 04:40:41 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux
> psql (PostgreSQL) 8.4.2
>            Reporter: Terry Mueller
>            Assignee: Tammo van Lessen
>              Labels: patch
>             Fix For: 1.3.6, 1.4
>
>         Attachments: ODE-787.patch
>
>
> 13:48:03,400 ODEServerImpl-1 ERROR [SimpleScheduler] Database error.
> org.apache.ode.scheduler.simple.DatabaseException: org.postgresql.util.PSQLException:
ERROR: column "detailsext" is of type bytea but expression is of type oid
> 	at org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:218)
> 	at org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:230)
> 	at org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:187)
> 	at org.apache.ode.bpel.engine.ODEProcess.scheduleJob(ODEProcess.java:811)
> 	at org.apache.ode.bpel.engine.ODEWSProcess.scheduleInvokeCheck(ODEWSProcess.java:706)
> 	at org.apache.ode.bpel.engine.ODEWSProcess.invokePartner(ODEWSProcess.java:641)
> 	at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.invoke(BpelRuntimeContextImpl.java:739)
> 	at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.invoke(RuntimeInstanceImpl.java:654)
> 	at org.apache.ode.bpel.rtrep.v2.INVOKE.wsdlInvoke(INVOKE.java:108)
> 	at org.apache.ode.bpel.rtrep.v2.INVOKE.run(INVOKE.java:71)
> 	at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:450)
> 	at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
> 	at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:716)
> 	at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:844)
> 	at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:832)
> 	at org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:235)
> 	at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:410)
> 	at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:408)
> 	at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
> 	at org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:171)
> 	at org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:106)
> 	at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:355)
> 	at org.apache.ode.bpel.engine.ODEWSProcess.invokeProcess(ODEWSProcess.java:408)
> 	at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
> 	at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
> 	at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:44)
> 	at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
> 	at org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:110)
> 	at org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:1031)
> 	at org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:1011)
> 	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: org.postgresql.util.PSQLException: ERROR: column "detailsext" is of type bytea
but expression is of type oid
> 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
> 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
> 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> 	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> 	at org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:216)
> 	... 37 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message