[Obm] Découverte d une erreur opush
Hilaire Thomas
thilaire at linagora.com
Thu Dec 20 10:53:55 CET 2012
Bonjour Ivan,
Il semble que vous rencontrez un problème de migration de base de donnée.
Veuillez, après avoir fait un backup de votre base, appliquer le script
//usr/share/dbconfig-common/scripts/obm-storage/upgrade/[DB]/2.4.1~alpha9+git/
Est-ce que vous rencontrez toujours l'erreur en question ?
Merci
On 11/29/2012 12:00 PM, ib wrote:
> 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
>
>
>
> _______________________________________________
> Obm mailing list
> Obm at list.obm.org
> http://list.obm.org/mailman/listinfo/obm
--
Thomas Hilaire
Développeur LGS/OBM/R&D
+33 6 43 65 66 03
------------------
GROUPE LINAGORA
74-80 rue Roque de Fillol
92800 Puteaux
+33 (0)8 10 25 12 51
+33 (0)6 79 60 12 91
thilaire at linagora.com
------------------
La présente transmission contient des informations confidentielles
appartenant à Linagora, exclusivement destinées au(x) destinataire(s)
identifié(s) ci-dessus. Si vous n'en faites pas partie, toute
reproduction, distribution ou divulgation de tout ou partie des
informations de cette transmission, ou toute action effectuée sur la
base de celles-ci vous sont formellement interdites.
Si vous avez reçu cette transmission par erreur, nous vous remercions de
nous en avertir et de la détruire de votre système d'information.
The present transmission contains privileged and confidential
information belonging to Linagora, exclusively intended for the
recipient(s) thereabove identified. If you are not one of these
aforementioned recipients, any reproduction, distribution, disclosure of
said information in whole or in part, as well as any action undertaken
on the basis of said information are strictly prohbited. If you received
the present transmission by mistake, please inform us and destroy it
from your messenging and information systems.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.obm.org/pipermail/obm/attachments/20121220/02a9a8bc/attachment-0001.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3153 bytes
Desc: not available
Url : http://list.obm.org/pipermail/obm/attachments/20121220/02a9a8bc/attachment-0001.gif
More information about the Obm
mailing list