[Obm] Découverte d une erreur opush
ib
ib at ice-dev.com
Thu Nov 29 12:00:24 CET 2012
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/ivantest at ice-dev.com]: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,
<http://www.ice-dev.com> *Ivan BERTHELOT*
Administrateur Réseaux
ICE DEVELOPMENT
16 rue Maurice Bouchor
Tel : 08 21 23 03 54
http://www.ice-dev.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.obm.org/pipermail/obm/attachments/20121129/f8561118/attachment-0001.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo-ice-dev.gif
Type: image/gif
Size: 3153 bytes
Desc: not available
Url : http://list.obm.org/pipermail/obm/attachments/20121129/f8561118/attachment-0001.gif
More information about the Obm
mailing list