[Obm] SyncStorage ERROR - ERREUR: la colonne « is_read » n'existe pas
scolson at linagora.com
scolson at linagora.com
Mon May 30 16:15:09 CEST 2011
Bonjour,
un script de mise à jour de la base de donnée n'a pas été appliqué.
L'erreur montre qu'il manque la colonne "is_read" dans la table
"opush_sync_mail".
Voir le contenu du script suivant pour la commande exacte à exécuter
dans pgsql ou mysql:
/usr/share/obm/www/scripts/2.3/updates/update-2.3.17-2.3.18.<DB>.sql où
DB est pgsql ou mysql selon votre installation.
Cordialement,
S. Colson
On Mon, 30 May 2011 16:02:42 +0200, Renauld MAMBOUNDOU wrote:
> Bonjour,
>
> J'essaie de synchroniser mon htc wildfire(android 2.2) avec OBM et
> j'obtiens l'erreur suivante:
>
> SyncStorage ERROR - ERREUR: la colonne « is_read » n'existe pas
>
> J'arrive bien à me connecter comme le montre les logs de opush que
> voici:
>
> 2011-05-30 13:51:58,518 SyncHandler INFO -
> process(test10 at domain/htcbuzz)
> 2011-05-30 13:51:58,521 MailBackend INFO - Collection: obm:\
> \test10 at domain\email\INBOX
> 2011-05-30 13:51:58,521 EmailManager INFO - creating storeClient
> with
> login: test10 at domain (loginWithDomain: true, activateTLS:true)
> 2011-05-30 13:51:58,526 StoreClientCallback INFO - connected()
> callback
> called.
> 2011-05-30 13:51:58,527 ClientSupport INFO - Connection established
> 2011-05-30 13:51:58,529 StartTLSCommand INFO - STARTTLS accepted by
> server.
> 2011-05-30 13:51:58,530 ClientSupport INFO - Network traffic with
> IMAP
> server will be encrypted.
> 2011-05-30 13:51:58,530 ClientSupport INFO - Sending test10 at domain
> login informations.
> 2011-05-30 13:51:58,644 SyncStorage ERROR - ERREUR: la colonne «
> is_read » n'existe pas
> org.postgresql.util.PSQLException: ERREUR: la colonne « is_read »
> n'existe pas
> 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.executeQuery(AbstractJdbc2Statement.java:254)
> at
>
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.getSyncedMail(SyncStorage.java:1001)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:176)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,648 EmailSyncCache INFO - [test10 at domain] 5 mails
> on
> imap after Fri May 27 12:00:00 GMT 2011
> 2011-05-30 13:51:58,648 OBMPoolActivator ERROR - Error getting SQL
> connection to the OBM database
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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:336)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
>
> fr.aliasource.obm.aliapool.pool.StatementProxy.execute(StatementProxy.java:78)
> at
>
> org.minig.obm.pool.OBMPoolActivator.getConnection(OBMPoolActivator.java:148)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.getDeletedMail(SyncStorage.java:1063)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getRemoved(EmailSyncCache.java:74)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:187)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,649 SyncStorage ERROR - ERREUR: la transaction
> est
> annulée, les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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.executeQuery(AbstractJdbc2Statement.java:254)
> at
>
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.getDeletedMail(SyncStorage.java:1071)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getRemoved(EmailSyncCache.java:74)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:187)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,650 OBMPoolActivator ERROR - Error getting SQL
> connection to the OBM database
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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:336)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
>
> fr.aliasource.obm.aliapool.pool.StatementProxy.execute(StatementProxy.java:78)
> at
>
> org.minig.obm.pool.OBMPoolActivator.getConnection(OBMPoolActivator.java:148)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.getUpdatedMail(SyncStorage.java:1028)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getUpdated(EmailSyncCache.java:101)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:189)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,650 SyncStorage ERROR - ERREUR: la transaction
> est
> annulée, les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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.executeQuery(AbstractJdbc2Statement.java:254)
> at
>
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.getUpdatedMail(SyncStorage.java:1035)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getUpdated(EmailSyncCache.java:101)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:189)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,651 OBMPoolActivator ERROR - Error getting SQL
> connection to the OBM database
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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:336)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
>
> fr.aliasource.obm.aliapool.pool.StatementProxy.execute(StatementProxy.java:78)
> at
>
> org.minig.obm.pool.OBMPoolActivator.getConnection(OBMPoolActivator.java:148)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.addMessages(SyncStorage.java:1144)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.updateDbCache(EmailSyncCache.java:137)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:197)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,652 EmailSyncCache ERROR - ERREUR: la transaction
> est annulée, les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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.executeUpdate(AbstractJdbc2Statement.java:304)
> at
>
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:180)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.addMessages(SyncStorage.java:1150)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.updateDbCache(EmailSyncCache.java:137)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:197)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> 2011-05-30 13:51:58,653 MailBackend ERROR -
> org.obm.push.exception.ServerErrorException:
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> org.obm.push.exception.ServerErrorException:
> org.obm.push.exception.ServerErrorException:
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:165)
> at
>
> org.obm.push.backend.obm22.mail.MailBackend.getContentChanges(MailBackend.java:118)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getMailChanges(ContentsExporter.java:108)
> at
>
> org.obm.push.backend.obm22.ContentsExporter.getChanged(ContentsExporter.java:134)
> at org.obm.push.impl.SyncHandler.doUpdates(SyncHandler.java:187)
> at
> org.obm.push.impl.SyncHandler.processResponse(SyncHandler.java:501)
> at org.obm.push.impl.SyncHandler.process(SyncHandler.java:135)
> at
>
> org.obm.push.impl.WbxmlRequestHandler.process(WbxmlRequestHandler.java:70)
> at
>
> org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:254)
> at
> org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:141)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.registry.internal.ServletManager
> $ServletWrapper.service(ServletManager.java:180)
> at
>
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
> at
>
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.eclipse.equinox.http.jetty.internal.HttpServerManager
> $InternalHttpServiceServlet.service(HttpServerManager.java:318)
> at
>
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
> at
>
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
> at
>
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
>
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at
>
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
>
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:880)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:219)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at org.mortbay.thread.QueuedThreadPool
> $PoolThread.run(QueuedThreadPool.java:520)
> Caused by: org.obm.push.exception.ServerErrorException:
> org.postgresql.util.PSQLException: ERREUR: la transaction est
> annulée,
> les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:221)
> at
>
> org.obm.push.backend.obm22.mail.EmailManager.getSync(EmailManager.java:161)
> ... 29 more
> Caused by: org.postgresql.util.PSQLException: ERREUR: la transaction
> est
> annulée, les commandes sont ignorées jusqu'à la fin du bloc
> de la transaction
> 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.executeUpdate(AbstractJdbc2Statement.java:304)
> at
>
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:180)
> at
>
> org.obm.push.storage.jdbc.SyncStorage.addMessages(SyncStorage.java:1150)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.updateDbCache(EmailSyncCache.java:137)
> at
>
> org.obm.push.backend.obm22.mail.EmailSyncCache.getSync(EmailSyncCache.java:197)
> ... 30 more
> 2011-05-30 13:51:58,653 StoreClientCallback INFO - disconnected()
> callback called.
> 2011-05-30 13:51:58,656 MailBackend INFO - 0 email(s) will be
> deleted
> on the PDA
> 2011-05-30 13:51:58,656 ContentsExporter INFO - Get changed from
> 2011-05-30 12:45:24.422 on collectionPath[75]
> 2011-05-30 13:51:58,656 SyncHandler INFO - should send 0 change(s)
> 2011-05-30 13:51:58,656 SyncHandler INFO - WindowsSize value is 50,
> 0
> changes will not send
> 2011-05-30 13:51:58,681 SyncHandler INFO - Resp for requestId: 706
> 2011-05-30 13:51:58,681 Responder INFO - to pda:
> <?xml version="1.0" encoding="UTF-8"?>
> <Sync>
> <Collections>
> <Collection>
> <SyncKey>a36ca761-fb7a-4606-861b-7fe5bc487127</SyncKey>
> <CollectionId>75</CollectionId>
> <Status>1</Status>
> </Collection>
> </Collections>
> </Sync>
>
>
> J'ai rien trouvé dans les archives, un peu d'aide svp.
>
> Merci,
>
> Renauld
>
>
> _______________________________________________
> Obm mailing list
> Obm at list.obm.org
> http://list.obm.org/mailman/listinfo/obm
More information about the Obm
mailing list