钉钉同步问题

胡辣汤 发表于 2022-7-12 10:14:55

钉钉同步时报网管超时是啥原因呢
{
"readyState": 4,
"responseText": "{\n\"servlet\":\"com.x.server.console.server.web.Proxy-f227e60\",\n\"message\":\"Gateway Timeout\",\n\"url\":\"/x_program_center/jaxrs/dingding/pull/sync\",\n\"status\":\"504\"\n}",
"responseJSON": {
   "servlet": "com.x.server.console.server.web.Proxy-f227e60",
   "message": "Gateway Timeout",
   "url": "/x_program_center/jaxrs/dingding/pull/sync",
   "status": "504"
},
"status": 504,
"statusText": "Gateway Timeout"
}

xadmin 发表于 2022-7-12 10:43:31

这个不用管，前端超时，可能您有nginx超时，后端同步程序还在跑的。

胡辣汤 发表于 2022-7-12 10:47:53

xadmin 发表于 2022-7-12 10:43
这个不用管，前端超时，可能您有nginx超时，后端同步程序还在跑的。

嗯嗯，但是数据没同步完，数据库数据也没变化了，跑了一晚上了

飞龙在天 发表于 2022-7-12 17:02:02

胡辣汤发表于 2022-7-12 10:47
嗯嗯，但是数据没同步完，数据库数据也没变化了，跑了一晚上了

那得查查日志，是否同步有啥问题

胡辣汤 发表于 2022-7-13 12:37:42

FancyLou 发表于 2022-7-12 17:02
那得查查日志，是否同步有啥问题

这个是日志报错，但是每次同步都增加几个人的数据

java.lang.Exception: commit error

at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1077)

at com.x.program.center.dingding.SyncOrganization.createOrLinkPerson(SyncOrganization.java:305)

at com.x.program.center.dingding.SyncOrganization.checkPerson(SyncOrganization.java:247)

at com.x.program.center.dingding.SyncOrganization.check(SyncOrganization.java:124)

at com.x.program.center.dingding.SyncOrganization.check(SyncOrganization.java:140)

at com.x.program.center.dingding.SyncOrganization.check(SyncOrganization.java:140)

at com.x.program.center.dingding.SyncOrganization.check(SyncOrganization.java:140)

at com.x.program.center.dingding.SyncOrganization.execute(SyncOrganization.java:68)

at com.x.program.center.jaxrs.dingding.ActionPullSync.execute(ActionPullSync.java:28)

at com.x.program.center.jaxrs.dingding.DingdingAction.pullSync(DingdingAction.java:66)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)

at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159)

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)

at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)

at org.glassfish.jersey.internal.Errors.process(Errors.java:292)

at org.glassfish.jersey.internal.Errors.process(Errors.java:274)

at org.glassfish.jersey.internal.Errors.process(Errors.java:244)

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)

at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)

at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)

at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)

at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763)

at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633)

at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228)

at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)

at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609)

at com.x.base.core.project.jaxrs.AnonymousCipherManagerUserJaxrsFilter.doFilter(AnonymousCipherManagerUserJaxrsFilter.java:31)

at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)

at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)

at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)

at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)

at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:766)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)

at org.eclipse.jetty.server.Server.handle(Server.java:516)

at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)

at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)

at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)

at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773)

at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by:org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.See the nested exceptions for details on the errors that occurred.

FailedObject: com.x.organization.core.entity.Person@1bdab38c

at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:713)

at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1073)

... 79 more

Caused by:org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.See the nested exceptions for details on the errors that occurred.

FailedObject: com.x.organization.core.entity.Person@1bdab38c

at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2475)

at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310)

at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201)

at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118)

at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84)

at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603)

at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)

at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690)

... 80 more

Caused by:org.apache.openjpa.persistence.PersistenceException: Incorrect string value: '\xF0\x9F\xA4\x98@1...' for column 'xdistinguishedName' at row 1 {prepstmnt 30105761 INSERT INTO ORG_PERSON (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xage, xbirthday, xboardDate, xchangePasswordTime, xdescription, xdingdingHash, xdingdingId, xdistinguishedName, xemployee, xfailureCount, xfailureTime, xgenderType, xhiddenMobile, xicon, xiconLdpi, xiconMdpi, xipAddress, xlanguage, xlastLoginAddress, xlastLoginClient, xlastLoginTime, xmail, xmobile, xmpwxopenId, xname, xnickName, xofficePhone, xopen1Id, xopen2Id, xopen3Id, xopen4Id, xopen5Id, xorderNumber, xpassword, xpasswordExpiredTime, xpinyin, xpinyinInitial, xqiyeweixinHash, xqiyeweixinId, xqq, xsignature, xsuperior, xunique, xweLinkHash, xweLinkId, xweixin, xzhengwuDingdingHash, xzhengwuDingdingId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}

FailedObject: com.x.organization.core.entity.Person@1bdab38c

at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5320)

at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5280)

at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)

at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)

at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)

at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)

at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)

at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)

at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:555)

at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:109)

at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)

at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:109)

at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)

at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:755)

at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)

... 87 more

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect string value: '\xF0\x9F\xA4\x98@1...' for column 'xdistinguishedName' at row 1 {prepstmnt 30105761 INSERT INTO ORG_PERSON (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xage, xbirthday, xboardDate, xchangePasswordTime, xdescription, xdingdingHash, xdingdingId, xdistinguishedName, xemployee, xfailureCount, xfailureTime, xgenderType, xhiddenMobile, xicon, xiconLdpi, xiconMdpi, xipAddress, xlanguage, xlastLoginAddress, xlastLoginClient, xlastLoginTime, xmail, xmobile, xmpwxopenId, xname, xnickName, xofficePhone, xopen1Id, xopen2Id, xopen3Id, xopen4Id, xopen5Id, xorderNumber, xpassword, xpasswordExpiredTime, xpinyin, xpinyinInitial, xqiyeweixinHash, xqiyeweixinId, xqq, xsignature, xsuperior, xunique, xweLinkHash, xweLinkId, xweixin, xzhengwuDingdingHash, xzhengwuDingdingId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}

at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)

at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)

at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)

at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188)

at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)

at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1860)

at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:272)

at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121)

... 97 more

飞龙在天 发表于 2022-7-13 14:52:03

胡辣汤发表于 2022-7-13 12:37
这个是日志报错，但是每次同步都增加几个人的数据

你这个好像是数据库字符集的问题你是mysql吗？要用utf8mb4的字符集

胡辣汤 发表于 2022-7-14 17:15:05

FancyLou 发表于 2022-7-13 14:52
你这个好像是数据库字符集的问题你是mysql吗？要用utf8mb4的字符集

是mysql,改了还是不行，每次都能比上次多几条数据，然后就再报错

飞龙在天 发表于 2022-7-15 15:21:19

胡辣汤发表于 2022-7-14 17:15
是mysql,改了还是不行，每次都能比上次多几条数据，然后就再报错
改了字符集还是这个错？贴错误出来看看

胡辣汤 发表于 2022-7-18 08:59:56

FancyLou 发表于 2022-7-15 15:21
改了字符集还是这个错？贴错误出来看看

对，改了字符集还是这个错误

论坛管理员 发表于 2022-7-18 09:21:05

错误贴出来看看

页: [1]

藕粉社区's Archiver

钉钉同步问题