[Obm] erreur lors de la synchronisation du carnet d'adresses
Cedric LIARD
cliard at linagora.com
Mon May 23 16:18:02 CEST 2011
Bonjour,
Comme il est indiqué dans les logs, il vous manque une table (relation)
dans votre base de données OBM. Pour y remédier il suffit de lancer les
commandes suivantes :
bash:~# su postgres
bash:~# psql obm <
/usr/share/obm/www/scripts/2.3/updates/update-2.3.16-2.3.17.psql.sql
Cordialement,
Cédric.
Le 23/05/2011 16:02, Renauld MAMBOUNDOU a écrit :
> Bonjour,
>
> Je suis toujours en attente d'une aide concernant mon problème de
> synchronisation du carnet d'adresses.
>
> En effet, j'ai installé Lightning et OBM-connector pour synchroniser mon
> agenda et mes contacts mais seul l'agenda arrive à se synchroniser
> correctement. J'obtiens l'erreur suivante dans les logs:
>
>
> 2011-05-23 13:58:34,689 LoginHandler INFO - method: doLogin
> 2011-05-23 13:58:34,693 SessionManagement INFO - [CUID 409] logout.
> 2011-05-23 13:58:34,693 SessionManagement INFO - [CUID 528]
> admin at satcom1.com logged in from thunderbird[ext: 2.4.2.2, light:
> 1.0b2.08obm]. auth type: OBM DB (mail: admin at satcom1.com) on obm-sync
> 2.3.25
> 2011-05-23 13:58:34,694 SyncServlet INFO - handler responded to
> login/doLogin in 4ms.
> 2011-05-23 13:58:34,747 AddressBookBindingImpl INFO - [CUID 528]
> AddressBook : getAddressBookSync()
> 2011-05-23 13:58:34,776 ContactDao INFO - returning 6 contact(s) updated
> 2011-05-23 13:58:34,776 ContactDao INFO - returning 0 contact(s)
> archived
> 2011-05-23 13:58:34,777 ContactDao INFO - Returning 0 contact(s) deleted
> 2011-05-23 13:58:34,779 ContactDao INFO - returning 2 folder(s) updated
> 2011-05-23 13:58:34,780 ContactDao ERROR - Could not find deleted
> folder(s) in OBM
> org.postgresql.util.PSQLException: ERREUR: la relation «
> deletedsyncedaddressbook » n'existe pas
> 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.executeQuery(AbstractJdbc2Statement.java:254)
> at
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
> at
> fr.aliacom.obm.common.contact.ContactDao.findRemovedFolders(ContactDao.java:1485)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getFolderChanges(AddressBookBindingImpl.java:376)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:133)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:121)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.CGLIB$getAddressBookSync$18(<generated>)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f$$FastClassByGuice
> $$e0102f53.invoke(<generated>)
> at
> com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> org.obm.sync.server.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:44)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:44)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.getAddressBookSync(<generated>)
> at
> org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:270)
> at
> org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:94)
> at org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:114)
> at org.obm.sync.server.SyncServlet.service(SyncServlet.java:73)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
> at org.apache.coyote.http11.Http11NioProtocol
> $Http11ConnectionHandler.process(Http11NioProtocol.java:722)
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.run(NioEndpoint.java:2214)
> 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:662)
> 2011-05-23 13:58:34,781 AddressBookBindingImpl ERROR - [CUID 528]
> 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: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:336)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
> fr.aliasource.obm.aliapool.pool.StatementProxy.execute(StatementProxy.java:78)
> at fr.aliacom.obm.utils.ObmHelper.getConnection(ObmHelper.java:126)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:134)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:121)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.CGLIB$getAddressBookSync$18(<generated>)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f$$FastClassByGuice
> $$e0102f53.invoke(<generated>)
> at
> com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> org.obm.sync.server.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:44)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:44)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.getAddressBookSync(<generated>)
> at
> org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:270)
> at
> org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:94)
> at org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:114)
> at org.obm.sync.server.SyncServlet.service(SyncServlet.java:73)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
> at org.apache.coyote.http11.Http11NioProtocol
> $Http11ConnectionHandler.process(Http11NioProtocol.java:722)
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.run(NioEndpoint.java:2214)
> 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:662)
> 2011-05-23 13:58:34,781 AddressBookBindingImpl ERROR - [CUID 528]
> 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.sync.auth.ServerFault: org.postgresql.util.PSQLException:
> ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à
> la fin du bloc
> de la transaction
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:137)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:121)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.CGLIB$getAddressBookSync$18(<generated>)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f$$FastClassByGuice
> $$e0102f53.invoke(<generated>)
> at
> com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> org.obm.sync.server.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:44)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:44)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.getAddressBookSync(<generated>)
> at
> org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:270)
> at
> org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:94)
> at org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:114)
> at org.obm.sync.server.SyncServlet.service(SyncServlet.java:73)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
> at org.apache.coyote.http11.Http11NioProtocol
> $Http11ConnectionHandler.process(Http11NioProtocol.java:722)
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.run(NioEndpoint.java:2214)
> 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:662)
> 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: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:336)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
> fr.aliasource.obm.aliapool.pool.StatementProxy.execute(StatementProxy.java:78)
> at fr.aliacom.obm.utils.ObmHelper.getConnection(ObmHelper.java:126)
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:134)
> ... 28 more
> 2011-05-23 13:58:34,782 TransactionalInterceptor ERROR - transaction was
> rollback
> org.obm.sync.auth.ServerFault: error synchronizing contacts
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:124)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.CGLIB$getAddressBookSync$18(<generated>)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f$$FastClassByGuice
> $$e0102f53.invoke(<generated>)
> at
> com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> org.obm.sync.server.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:44)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:44)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.getAddressBookSync(<generated>)
> at
> org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:270)
> at
> org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:94)
> at org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:114)
> at org.obm.sync.server.SyncServlet.service(SyncServlet.java:73)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
> at org.apache.coyote.http11.Http11NioProtocol
> $Http11ConnectionHandler.process(Http11NioProtocol.java:722)
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.run(NioEndpoint.java:2214)
> 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:662)
> 2011-05-23 13:58:34,782 SyncServlet ERROR - error synchronizing
> contacts
> org.obm.sync.auth.ServerFault: error synchronizing contacts
> at
> fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:124)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.CGLIB$getAddressBookSync$18(<generated>)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f$$FastClassByGuice
> $$e0102f53.invoke(<generated>)
> at
> com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> org.obm.sync.server.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:44)
> at com.google.inject.InterceptorStackCallback
> $InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
> at
> com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:44)
> at fr.aliacom.obm.common.contact.AddressBookBindingImpl
> $$EnhancerByGuice$$9030743f.getAddressBookSync(<generated>)
> at
> org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:270)
> at
> org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:94)
> at org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:114)
> at org.obm.sync.server.SyncServlet.service(SyncServlet.java:73)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
> at org.apache.coyote.http11.Http11NioProtocol
> $Http11ConnectionHandler.process(Http11NioProtocol.java:722)
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.run(NioEndpoint.java:2214)
> 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:662)
> 2011-05-23 13:58:58,211 PingThread INFO - 80 unused connections pinged.
>
>
>
> Une idée?
>
> Merci,
>
> Renauld.
>
>
>
> Le samedi 21 mai 2011 à 12:00 +0200, obm-request at list.obm.org a écrit :
>
>> erreur lors de la synchronisation du carnet d'adresses
>>
> _______________________________________________
> Obm mailing list
> Obm at list.obm.org
> http://list.obm.org/mailman/listinfo/obm
>
More information about the Obm
mailing list