james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Charles <e...@apache.org>
Subject Re: Escape strings still not correct with latest beta4 PGSQL
Date Tue, 06 Mar 2012 18:59:45 GMT
Thx for the feedback.
I will add this information on the 3.0b4 documentation.
Eric


On 06/03/12 14:28, lclhst wrote:
> Some more threads on this problem:
> https://www.google.nl/webhp?sourceid=chrome-instant&ix=seb&ie=UTF-8&ion=1#hl=nl&safe=off&output=search&sclient=psy-ab&q=%22Invalid%20escape%20string%22&pbx=1&oq=&aq=&aqi=&aql=&gs_sm=&gs_upl=&gs_l=&fp=ebc5b602cbd83cfb&ix=seb&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1280&bih=939
>
>
> I hackety-fixed it now by adding
> standard_conforming_strings = off
> to my postgresql.conf.
>
> On Tue, Mar 6, 2012 at 2:15 PM, l0c4l h0st<l0c4lh0st.dump@gmail.com>  wrote:
>
>> INFO  14:13:21,609 | james.imapserver | ID=1451155144 List failed
>> org.apache.james.mailbox.exception.MailboxException: Search of mailbox
>> #private:xxx@yyy.nl:Trash failed
>>         at
>> org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.findMailboxWithPathLike(JPAMailboxMapper.java:124)
>>         at
>> org.apache.james.mailbox.store.StoreMailboxManager.search(StoreMailboxManager.java:508)
>>         at
>> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:166)
>>         at
>> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:64)
>>         at
>> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:47)
>>         at
>> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:100)
>>         at
>> org.apache.james.imap.processor.AbstractMailboxProcessor.process(AbstractMailboxProcessor.java:89)
>>         at
>> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:83)
>>         at
>> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:66)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:52)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>>         at
>> org.apache.james.imapserver.netty.ImapChannelUpstreamHandler.messageReceived(ImapChannelUpstreamHandler.java:181)
>>         at
>> org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
>>         at
>> org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:558)
>>         at
>> org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:777)
>>         at
>> org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
>>         at
>> org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:327)
>>         at
>> org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:305)
>>         at
>> org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:207)
>>         at
>> org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
>>         at
>> org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:558)
>>         at
>> org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:777)
>>         at
>> org.jboss.netty.handler.execution.ChannelUpstreamEventRunnable.run(ChannelUpstreamEventRunnable.java:44)
>>         at
>> org.jboss.netty.handler.execution.OrderedMemoryAwareThreadPoolExecutor$ChildExecutor.run(OrderedMemoryAwareThreadPoolExecutor.java:312)
>>         at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
>> Source)
>>         at java.lang.Thread.run(Unknown Source)
>> Caused by:<openjpa-2.1.0-r422266:1071316 fatal general error>
>> org.apache.openjpa.persistence.PersistenceException: ERROR: invalid
>> escape string
>>   Hint: Escape string must be empty or one character. {prepstmnt
>> 174928937 SELECT t0.mailbox_id, t0.mailbox_highest_modseq,
>> t0.mailbox_last_uid, t0.mailbox_name, t0.mailbox_namespace,
>> t0.mailbox_uid_validity, t0.user_name FRO
>> M public.james_mailbox t0 WHERE (t0.mailbox_name LIKE ? ESCAPE '\\'
>> AND t0.user_name = ? AND t0.mailbox_namespace = ?) [params=?, ?, ?]}
>> [code=0, state=22025]
>> FailedObject: SELECT mailbox FROM Mailbox mailbox WHERE mailbox.name
>> LIKE :nameParam and mailbox.user= :userParam and mailbox.namespace=
>> :namespaceParam [java.lang.String]
>>         at
>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
>>         at
>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
>>         at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
>>         at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
>>         at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
>>         at
>> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
>>         at
>> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
>>         at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
>>         at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
>>         at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
>>         at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
>>         at
>> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
>>         at
>> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:305)
>>         at
>> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:319)
>>         at
>> org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.findMailboxWithPathLike(JPAMailboxMapper.java:121)
>>         ... 39 more
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
>> invalid escape string
>>   Hint: Escape string must be empty or one character. {prepstmnt
>> 174928937 SELECT t0.mailbox_id, t0.mailbox_highest_modseq,
>> t0.mailbox_last_uid, t0.mailbox_name, t0.mailbox_namespace,
>> t0.mailbox_uid_validity, t0.user_name FRO
>> M public.james_mailbox t0 WHERE (t0.mailbox_name LIKE ? ESCAPE '\\'
>> AND t0.user_name = ? AND t0.mailbox_namespace = ?) [params=?, ?, ?]}
>> [code=0, state=22025]
>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1183)
>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:284)
>>         at
>> org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:1004)
>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:284)
>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1785)
>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:274)
>>         at
>> org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
>>         at
>> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
>>         at
>> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:391)
>>         at
>> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
>>         at
>> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
>>         at
>> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
>>         at
>> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
>>         at
>> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
>>         ... 47 more
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-dev-help@james.apache.org
>>
>>
>

-- 
eric | http://about.echarles.net | @echarles

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message