Re: Upgrade to Scientific Linux 6.5 x86_64 breaks query

I concur, and too am curious as to the "(now() - $2)" result, but even if
that clears up the symptom it doesn't make any sense...

David J.


Dave Cramer-8 wrote
> The crux of the problem is this:  ERROR: operator does not exist:
> timestamp
> with time zone >= interval
>
> which appears to be caused by trans_date between now() - $2 and now()
>
> What happens if you change it to :
>
> trans_date between (now() - $2) and now()
>
>
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On 23 July 2014 12:10, CG <

> cgg007@

> > wrote:
>
>> Using PostgreSQL 9.1.3; JDBC3 driver (tried several versions-- all suffer
>> from the same issue); MyBatis 2.3.5
>>
>> We're migrating our app to a virtualized 64bit Linux server from a
>> virtualized 32bit Linux server, same farm. What worked fine on 32bit
>> Scientific Linux breaks on 64bit... Same JVM version (although we tried
>> 64
>> and 32 bit JVM both with same issue). We've done our best to make sure
>> the
>> ONLY thing different is the 64bit OS. Hitting the same 9.1.3 back end...
>>
>> We've been sifting through everything and we can't conceive of what could
>> possibly cause this problem. Also, this query runs fine on other
>> platforms.
>>
>> Maybe you can see something I can't:
>>
>> 10:02:40.596 (2)  <=BE ReadyForQuery(I)
>> 10:02:40.601 (2) simple execute,
>> handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@1792d2c,
>> maxRows=0, fetchSize=0, flags=1
>> 10:02:40.601 (2)  FE=> Bind(stmt=S_1,portal=null)
>> 10:02:40.601 (2)  FE=> Execute(portal=null,limit=0)
>> 10:02:40.601 (2)  FE=> Parse(stmt=null,query="      select    t_uuid as
>> t_uuid,    last(latitude) as latitude,    last(longitude) as longitude,
>>  last(trans_date) as trans_date,    last(speed) as speed,
>>  last(direction) as direction,    last(revision) as revision   from (
>> SELECT     trans_date,     t_uuid,     latitude,     longitude,
>> speed,
>>     direction,     revision    FROM     t_vectors    WHERE     group_uuid
>> =
>> $1     and trans_date between now() - $2 and now()
>> AND       t_uuid in        (        $3       ,        $4       ,
>> $5
>>       ,        $6       ,        $7       ,        $8       ,        $9
>>   ,        $10       ,        $11       ,        $12       ,        $13
>>   ,        $14       ,        $15       ,        $16       ,        $17
>>   ,        $18       ,        $19       ,        $20       ,        $21
>>   ,        $22       ,        $23       ,        $24       ,        $25
>>   ,
>>     $26       ,        $27       ,        $28       ,        $29       ,
>>      $30       ,        $31       ,        $32       ,        $33       ,
>>      $34       ,        $35       ,        $36       ,        $37       ,
>>      $38       ,        $39       ,        $40       ,        $41       ,
>>      $42       ,        $43       ,        $44       ,        $45       ,
>>      $46       ,        $47       ,        $48       ,        $49       )
>>             order by     trans_date asc       ) foo   group by    t_uuid
>>
>> ",oids={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})
>> 10:02:40.601 (2)  FE=>
>> Bind(stmt=null,portal=null,$1=<394fa90e-75a3-4dd1-9205-341409bcba4b>,$2=<0
>> years 0 mons 0 days 1 hours 0 mins 0.00
>>
>>  secs>,$3=
> <cdd1aa29-48ae-4a8d-884f-43ea795defde>
> ,$4=<3552acd6-e294-4d88-bd67-a856b4f5965c>,$5=<881d0513-37b9-4935-8051-b66552bada74>,$6=
> <fa21ec58-47e7-478a-b8b0-42a937200e70>
> ,$7=
> <ec909e6b-c214-4fbe-aea0-9baf4a33b54a>
>
,$8=<13c75de7-1e73-4dcd-906b-cee83ee0212e>,$9=<362d4c76-c09d-4e4f-8c05-821e9d46ba83>,$10=<76e02c3d-c108-443a-9cb3-6a1e138f00c6>,$11=
> <dbc8ee6d-b04d-4f48-90a3-b2a2bbd5de6e>
> ,$12=<197c368a-669c-4d44-867b-6382726bae99>,$13=<8ae1f446-8364-4061-a89e-0058735cd35a>,$14=
> <fd148cc9-4b13-4773-9b7b-d5f2d1ca3a00>
> ,$15=<7a4777eb-3767-43f8-9d67-f1caf3eff2b4>,$16=
> <f526b7ee-7823-4e4b-8bd5-dca091ca6aea>
>
,$17=<8f4c2594-b368-43d2-8a27-8af24dc92512>,$18=<10ad0508-9eca-47e3-96f5-99745fbdcede>,$19=<112944c7-eef0-49c3-af79-9b54b484ca0c>,$20=
> <da94401d-10c5-4607-9b09-fa2202bba846>
> ,$21=
> <ce9a4ddd-3c47-4bb9-af55-4d0c6c0600f8>
> ,$22=<3448505e-b740-4084-891e-e2ff34c3754f>,$23=<8a3b486d-5e41-46e1-99fa-51f4f38af2fa>,$24=
> <a3260ac3-3811-4857-95a6-2cbcd1f8119b>
> ,$25=<12a70091-0853-44
>>
>> 99-8f05-d80e3045ce5e>,$26=
> <e21a63e8-2835-4942-9a9e-18e1310a74e6>
>
,$27=<5b41b6cb-de51-40ff-8488-7f3403b1f0a8>,$28=<83a3fe9b-cfb5-4908-b5fb-5b32a7be5eb1>,$29=<0a963150-eea0-4396-aa2a-9319ca9c9866>,$30=<0346505e-98be-4585-aeea-3b38df4a56a2>,$31=<069bf54d-c230-4bef-884b-46e54e28c65e>,$32=<8286bd41-ccd1-47bd-a1aa-1631d3ccbd56>,$33=
> <f7a3f9e2-e94b-4ff7-8b03-4e8549be07cb>
>
,$34=<72f2af01-c359-45f9-bb20-37c7479869f3>,$35=<0143076a-3f9e-487d-bdec-c1a6a110f748>,$36=<2bc64e73-c771-43c8-aa83-b11059512a0f>,$37=
> <a5b56133-7cd2-476d-bde6-1b8af68bc265>
>
,$38=<3c43a0dd-292a-44cc-a097-ab2f77757d25>,$39=<8b84e953-d6a9-42ae-9caa-481c164354db>,$40=<26d842b6-71e2-438f-a147-e18d102d21d5>,$41=
> <f588610a-507a-4c4c-93bb-a6466ed140ba>
> ,$42=
> <d5a145c8-f8bd-486f-a0d7-f897715915c5>
> ,$43=
> <bd0ed505-27e8-43b4-be4e-664adc98a38c>
> ,$44=
> <b0948960-11b7-4bca-9d9c-4f8d7b91962c>
>
,$45=<70d2924f-c8cb-4594-a67b-261ca300406e>,$46=<60ad8ae8-4722-4a02-8d4f-88a0052299fc>,$47=<350558cc-e56f-4fb2-86f8-3d3252b56bce>
>>
>> ,$48=
> <de7259b4-e1c8-481c-9043-46f09a0926de>
> ,$49=<2e5ecda2-bfdd-400a-a48a-e08e07d4ced4>)
>> 10:02:40.602 (2)  FE=> Describe(portal=null)
>> 10:02:40.602 (2)  FE=> Execute(portal=null,limit=0)
>> 10:02:40.602 (2)  FE=> Sync
>> 10:02:40.604 (2)  <=BE BindComplete [null]
>> 10:02:40.604 (2)  <=BE CommandStatus(BEGIN)
>> 10:02:40.607 (2)  <=BE ErrorMessage(ERROR: operator does not exist:
>> timestamp with time zone >= interval
>>   Hint: No operator matches the given name and argument type(s). You
>> might
>> need to add explicit type casts.
>>   Position: 410)
>> org.postgresql.util.PSQLException: ERROR: operator does not exist:
>> timestamp with time zone >= interval
>>   Hint: No operator matches the given name and argument type(s). You
>> might
>> need to add explicit type casts.
>>   Position: 410
>>         at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
>>         at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
>>         at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
>>         at
>> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
>>         at
>> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
>>         at
>> com.ibatis.sqlmap.engine.execution.DefaultSqlExecutor.executeQuery(DefaultSqlExecutor.java:183)
>>         at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
>>         at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
>>         at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
>>         at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:578)
>>         at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:552)
>>         at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>>         at
>> com.foo.service.db.ibatis.lib.SqlMapExecutor.queryForList(SqlMapExecutor.java:139)
>>         at
>> com.foo.service.db.ibatis.DepDaoIbatis.usersList(DepDaoIbatis.java:3352)
>>         at com.foo.util.Util.fetchSettings(Util.java:109)
>>         at com.foo.util.Util.fetchUpdates(Util.java:221)
>>         at com.foo.util.Util.fetchInit(Util.java:168)
>>         at
>> com.foo.service.process.InitProcessor.process(InitProcessor.java:57)
>>         at
>> com.foo.service.process.InitProcessor.process(InitProcessor.java:29)
>>         at
>> com.foo.service.scaffolding.AbstractProcessor.process(AbstractProcessor.java:55)
>>         at
>> com.foo.service.scaffolding.AbstractProcessor.process(AbstractProcessor.java:28)
>>         at
>> com.restservice.process.AuthenticatedProcessor.process(AuthenticatedProcessor.java:38)
>>         at
>> com.restservice.process.AuthenticatedProcessor.process(AuthenticatedProcessor.java:12)
>>         at
>> com.restservice.process.SerializedProcessor.processRequest(SerializedProcessor.java:74)
>>         at
>> com.restservice.process.SerializedProcessor.process(SerializedProcessor.java:59)
>>         at com.restservice.RestService.process(RestService.java:224)
>>         at
>> com.restservice.RestService.processWrapper(RestService.java:122)
>>         at com.restservice.RestService.doPost(RestService.java:101)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>>         at
>> org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>>         at com.foo.util.GZIPFilter.doFilter(GZIPFilter.java:33)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>>         at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
>>         at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
>>         at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
>>         at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>         at
>> com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:38)
>>         at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>>         at
>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
>>         at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
>>         at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>         at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
>>         at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
>>         at
>> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
>>         at
>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>>         at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>>         at
>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>         at java.lang.Thread.run(Thread.java:662)
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (

> pgsql-jdbc@

> )
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>>





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Upgrade-to-Scientific-Linux-6-5-x86-64-breaks-query-tp5812546p5812571.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.