Re: [Obm] erreur lors de la synchronisation du carnet d'adresses

Mon, 23 May 2011 08:24:13 -0700 


Un oubli ma part pour la 2ème commande :

A la place de :
/bash:~# psql obm < /usr/share/obm/www/scripts/2.3/updates/update-2.3.16-2.3.17.psql.sql / 

Préférez celle-ci :
/bash:~# psql -U <user_obm_db> obm < /usr/share/obm/www/scripts/2.3/updates/update-2.3.16-2.3.17.psql.sql / où <user_obm_db> correspond au nom de l'utilisateur ayant accès à la base obm/.
/Si jamais vous l'avez déjà exécutée, lancer la commande en tant qu'utilisateur postgres : 
/bash:~# psql obm -c "ALTER TABLE deletedsyncedaddressbook OWNER TO obm;"/


Le 23/05/2011 16:18, Cedric LIARD a écrit :

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

Répondre à