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] > [email protected] logged in from thunderbird[ext: 2.4.2.2, light: > 1.0b2.08obm]. auth type: OBM DB (mail: [email protected]) 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, [email protected] a écrit : > >> erreur lors de la synchronisation du carnet d'adresses >> > _______________________________________________ > Obm mailing list > [email protected] > http://list.obm.org/mailman/listinfo/obm > _______________________________________________ Obm mailing list [email protected] http://list.obm.org/mailman/listinfo/obm
