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/ivant...@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,
|
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@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
thila...@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.
|
_______________________________________________
Obm mailing list
Obm@list.obm.org
http://list.obm.org/mailman/listinfo/obm