Bonjour a tous,

Je viens vous remonter un bug que j ai découvert en installant la version 2.4.1 sur une debian 6.0.6

En gros j ai bien la synchro des contacts sur un ios mais pas du calendrier
d apres les logs de opush il ne trouve pas un champ

[ERROR] {o.o.a.t.TransactionalInterceptor} [t16/cSync/r2/[email protected]]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'event_ext_id_hash' in 'field list'
org.obm.push.exception.DaoException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'event_ext_id_hash' in 'field list'
        at org.obm.push.store.jdbc.CalendarDaoJdbcImpl.insertExtIdMSEventUidMapping(CalendarDaoJdbcImpl.java:118) ~[push-dao-2.4.1.2.jar:na]
        at org.obm.push.calendar.EventServiceImpl.createMSEventUidInDatabase(EventServiceImpl.java:110) ~[push-service-2.4.1.2.jar:na]
        at org.obm.push.calendar.EventServiceImpl.getMSEventUidFor(EventServiceImpl.java:104) ~[push-service-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.managerTransaction(TransactionalInterceptor.java:88) ~[annotations-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:74) ~[annotations-2.4.1.2.jar:na]
        at org.obm.push.calendar.EventServiceImpl.convertEventToMSEvent(EventServiceImpl.java:91) ~[push-service-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.managerTransaction(TransactionalInterceptor.java:88) ~[annotations-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:74) ~[annotations-2.4.1.2.jar:na]
        at org.obm.push.calendar.CalendarBackend.createItemChangeToAddFromEvent(CalendarBackend.java:318) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.calendar.CalendarBackend.addOrUpdateEventFilter(CalendarBackend.java:278) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.calendar.CalendarBackend.buildDataDelta(CalendarBackend.java:264) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.calendar.CalendarBackend.getChanged(CalendarBackend.java:244) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.ContentsExporter.getChanged(ContentsExporter.java:69) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.SyncHandler.doUpdates(SyncHandler.java:250) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.SyncHandler.handleDataSync(SyncHandler.java:417) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.SyncHandler.computeSyncState(SyncHandler.java:400) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.SyncHandler.doTheJob(SyncHandler.java:384) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.SyncHandler.process(SyncHandler.java:166) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.handler.WbxmlRequestHandler.process(WbxmlRequestHandler.java:125) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.ActiveSyncServlet.processActiveSyncMethod(ActiveSyncServlet.java:235) ~[push-module-2.4.1.2.jar:na]
        at org.obm.push.ActiveSyncServlet.service(ActiveSyncServlet.java:153) ~[push-module-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.managerTransaction(TransactionalInterceptor.java:88) ~[annotations-2.4.1.2.jar:na]
        at org.obm.annotations.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:74) ~[annotations-2.4.1.2.jar:na]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [servlet-api-2.5.jar:na]
        at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:na]
        at org.eclipse.jetty.continuation.ContinuationFilter.doFilter(ContinuationFilter.java:99) [jetty-continuation-7.4.2.v20110526.jar:7.4.2.v20110526]
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:na]
        at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:na]
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.Server.handle(Server.java:326) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) [jetty-6.1.24.jar:6.1.24]
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) [jetty-util-6.1.24.jar:6.1.24]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'event_ext_id_hash' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_26]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) ~[na:1.6.0_26]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) ~[na:1.6.0_26]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513) ~[na:1.6.0_26]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) ~[mysql-connector-java-5.1.17.jar:na]
        at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:875) ~[mysql-connector-java-5.1.17.jar:na]
        at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_26]
        at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_26]
        at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:63) ~[btm-2.1.0.jar:na]
        at $Proxy30.executeUpdate(Unknown Source) ~[na:na]
        at org.obm.push.store.jdbc.CalendarDaoJdbcImpl.insertExtIdMSEventUidMapping(CalendarDaoJdbcImpl.java:116) ~[push-dao-2.4.1.2.jar:na]
       ... 49 common frames omitted

En effet dans la table event on a bien un event_ext_id mais pas d event_ext_id_hash

J ai testé pour voir si ca pouvez venir de la en créant le champ dans la table et en copiant le contenu de event_ext_id dans event_ext_id_hash. Le message d erreur dans le log ne réaparez plus mais la synchro ne se fait toujours pas

Auriez vous une idée
--
Cordialement,

Ivan BERTHELOT
Administrateur Réseaux

ICE DEVELOPMENT
16 rue Maurice Bouchor

Tel : 08 21 23 03 54
http://www.ice-dev.com
_______________________________________________
Obm mailing list
[email protected]
http://list.obm.org/mailman/listinfo/obm

Répondre à