Sym 上的评论同步到 Solo 时,可能会报下面的错误,看着像是主键重复的错误,但是评论也是同步过去了的,这就奇怪了。评论的 ID 也是同步过来的吗?如果是的话这样很容易重复,个人觉得同步过来的时候应该重新生成 ID 。
[ERROR]-[2017-04-23 23:27:16]-[org.b3log.latke.repository.jdbc.JdbcRepository:149]: add:Unique index or primary key violation: "PRIMARY_KEY_5 ON PUBLIC.B3_SOLO_COMMENT(OID) VALUES ('1492961195666', 96)"; SQL statement: insert into b3_solo_comment(commentSharpURL,commentName,commentThumbnailURL,commentOnId,commentEmail,commentURL,commentDate,commentOriginalCommentId,commentOnType,oId,commentContent,commentOriginalCommentName) values (?,?,?,?,?,?,?,?,?,?,?,?) [23505-190] org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_5 ON PUBLIC.B3_SOLO_COMMENT(OID) VALUES ('1492961195666', 96)"; SQL statement: insert into b3_solo_comment(commentSharpURL,commentName,commentThumbnailURL,commentOnId,commentEmail,commentURL,commentDate,commentOriginalCommentId,commentOnType,oId,commentContent,commentOriginalCommentName) values (?,?,?,?,?,?,?,?,?,?,?,?) [23505-190] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102) at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231) at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:190) at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704) at org.h2.command.dml.Insert.insertRows(Insert.java:156) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198) at org.b3log.latke.repository.jdbc.util.JdbcUtil.executeSql(JdbcUtil.java:89) at org.b3log.latke.repository.jdbc.JdbcRepository.add(JdbcRepository.java:147) at org.b3log.latke.repository.AbstractRepository.add(AbstractRepository.java:117) at org.b3log.solo.repository.impl.CommentRepositoryImpl_$$_jvst889_37._d0add(CommentRepositoryImpl_$$_jvst889_37.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.ioc.bean.JavassistMethodHandler.invoke(JavassistMethodHandler.java:101) at org.b3log.solo.repository.impl.CommentRepositoryImpl_$$_jvst889_37.add(CommentRepositoryImpl_$$_jvst889_37.java) at org.b3log.solo.api.symphony.CommentReceiver.addComment(CommentReceiver.java:250) at org.b3log.solo.api.symphony.CommentReceiver_$$_jvst889_48._d0addComment(CommentReceiver_$$_jvst889_48.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.ioc.bean.JavassistMethodHandler.invoke(JavassistMethodHandler.java:101) at org.b3log.solo.api.symphony.CommentReceiver_$$_jvst889_48.addComment(CommentReceiver_$$_jvst889_48.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.servlet.handler.MethodInvokeHandler.handle(MethodInvokeHandler.java:58) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.AdviceHandler.handle(AdviceHandler.java:108) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.ArgsHandler.handle(ArgsHandler.java:60) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.RequestDispatchHandler.handle(RequestDispatchHandler.java:92) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.RequestPrepareHandler.handle(RequestPrepareHandler.java:45) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.StaticResourceHandler.handle(StaticResourceHandler.java:119) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.DispatcherServlet.service(DispatcherServlet.java:84) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.b3log.solo.filter.InitCheckFilter.doFilter(InitCheckFilter.java:87) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.b3log.solo.filter.PermalinkFilter.doFilter(PermalinkFilter.java:92) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.b3log.latke.servlet.filter.EncodingFilter.doFilter(EncodingFilter.java:71) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Unknown Source) [ERROR]-[2017-04-23 23:27:16]-[org.b3log.latke.servlet.HttpControl:104]: Request [ method=PUT, URL=http://zixizixi.cn/apis/symphony/comment, contentType=null, characterEncoding=UTF-8, local=[ addr=0:0:0:0:0:0:0:1, port=****, name=0:0:0:0:0:0:0:1], remote=[ addr=121.40.142.200, port=61755, host=0:0:0:0:0:0:0:1], headers=[ Cache-Control=no-cache Accept=text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 Connection=close User-Agent=Java/1.8.0_121 X-Forwarded-For=121.40.142.200 Host=zixizixi.cn REMOTE-HOST=121.40.142.200 Pragma=no-cache Content-Length=374 X-Real-IP=121.40.142.200 ] ] processing failed java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.servlet.handler.MethodInvokeHandler.handle(MethodInvokeHandler.java:58) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.AdviceHandler.handle(AdviceHandler.java:108) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.ArgsHandler.handle(ArgsHandler.java:60) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.RequestDispatchHandler.handle(RequestDispatchHandler.java:92) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.RequestPrepareHandler.handle(RequestPrepareHandler.java:45) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.handler.StaticResourceHandler.handle(StaticResourceHandler.java:119) at org.b3log.latke.servlet.HttpControl.nextHandler(HttpControl.java:99) at org.b3log.latke.servlet.DispatcherServlet.service(DispatcherServlet.java:84) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.b3log.solo.filter.InitCheckFilter.doFilter(InitCheckFilter.java:87) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.b3log.solo.filter.PermalinkFilter.doFilter(PermalinkFilter.java:92) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.b3log.latke.servlet.filter.EncodingFilter.doFilter(EncodingFilter.java:71) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Unknown Source) Caused by: org.b3log.latke.repository.jdbc.JDBCRepositoryException: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_5 ON PUBLIC.B3_SOLO_COMMENT(OID) VALUES ('1492961195666', 96)"; SQL statement: insert into b3_solo_comment(commentSharpURL,commentName,commentThumbnailURL,commentOnId,commentEmail,commentURL,commentDate,commentOriginalCommentId,commentOnType,oId,commentContent,commentOriginalCommentName) values (?,?,?,?,?,?,?,?,?,?,?,?) [23505-190] at org.b3log.latke.repository.jdbc.JdbcRepository.add(JdbcRepository.java:150) at org.b3log.latke.repository.AbstractRepository.add(AbstractRepository.java:117) at org.b3log.solo.repository.impl.CommentRepositoryImpl_$$_jvst889_37._d0add(CommentRepositoryImpl_$$_jvst889_37.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.ioc.bean.JavassistMethodHandler.invoke(JavassistMethodHandler.java:101) at org.b3log.solo.repository.impl.CommentRepositoryImpl_$$_jvst889_37.add(CommentRepositoryImpl_$$_jvst889_37.java) at org.b3log.solo.api.symphony.CommentReceiver.addComment(CommentReceiver.java:250) at org.b3log.solo.api.symphony.CommentReceiver_$$_jvst889_48._d0addComment(CommentReceiver_$$_jvst889_48.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.b3log.latke.ioc.bean.JavassistMethodHandler.invoke(JavassistMethodHandler.java:101) at org.b3log.solo.api.symphony.CommentReceiver_$$_jvst889_48.addComment(CommentReceiver_$$_jvst889_48.java) ... 43 more Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_5 ON PUBLIC.B3_SOLO_COMMENT(OID) VALUES ('1492961195666', 96)"; SQL statement: insert into b3_solo_comment(commentSharpURL,commentName,commentThumbnailURL,commentOnId,commentEmail,commentURL,commentDate,commentOriginalCommentId,commentOnType,oId,commentContent,commentOriginalCommentName) values (?,?,?,?,?,?,?,?,?,?,?,?) [23505-190] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102) at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231) at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:190) at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704) at org.h2.command.dml.Insert.insertRows(Insert.java:156) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198) at org.b3log.latke.repository.jdbc.util.JdbcUtil.executeSql(JdbcUtil.java:89) at org.b3log.latke.repository.jdbc.JdbcRepository.add(JdbcRepository.java:147) ... 59 more
欢迎来到这里!
我们正在构建一个小众社区,大家在这里相互信任,以平等 • 自由 • 奔放的价值观进行分享交流。最终,希望大家能够找到与自己志同道合的伙伴,共同成长。
注册 关于