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@domain/htcbuzz) > 2011-05-30 13:51:58,521 MailBackend INFO - Collection: obm:\ > \test10@domain\email\INBOX > 2011-05-30 13:51:58,521 EmailManager INFO - creating storeClient > with > login: test10@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@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@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 > [email protected] > http://list.obm.org/mailman/listinfo/obm _______________________________________________ Obm mailing list [email protected] http://list.obm.org/mailman/listinfo/obm
