You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hugegraph.apache.org by GitBox <gi...@apache.org> on 2022/09/19 03:32:41 UTC

[GitHub] [incubator-hugegraph] cbb0610 opened a new issue, #1964: mysql作为存储后端，一段时间后插入数据失败

cbb0610 opened a new issue, #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964

   ### Bug Type (问题类型)
   
   other exception / error (其他异常报错)
   
   ### Before submit
   
   - [X] 我已经确认现有的 [Issues](https://github.com/hugegraph/hugegraph/issues) 与 [FAQ](https://hugegraph.github.io/hugegraph-doc/guides/faq.html) 中没有相同 / 重复问题
   
   ### Environment (环境信息)
   
   - Server Version: v0.12.x
   - Backend: mysql
   - OS: xx CPUs, xx G RAM, Centos 7.x 
   - Data Size:  xx vertices, xx edges <!-- (like 1000W 点, 9000W 边) -->
   
   
   ### Expected & Actual behavior (期望与实际表现)
   
   mysql作为存储后端，一段时间后插入数据失败，重启服务后正常插入，一直重复失败，重启，正常的步骤
   - [ ] 
   ![Uploading 微信图片_20220919113006![微信图片_20220919113013](https://user-images.githubusercontent.com/19340021/190945541-b2840f66-be05-408d-a829-66826c931820.jpg)jpg…]()
   
   
   ### Vertex/Edge example (问题点 / 边数据举例)
   
   _No response_
   
   ### Schema [VertexLabel, EdgeLabel, IndexLabel] (元数据结构)
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] cbb0610 commented on issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by GitBox <gi...@apache.org>.
cbb0610 commented on issue #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964#issuecomment-1253607924

   > 稳定复现的，来回多创建几次label 和index mysql5.7.30 task 表是什么？，我的操作代码是 ： 都是执行到 插入conceptId index 报错了
   > HugeClient client = getLocalClient(concept.getKg().getId());
   > SchemaManager schema = client.schema();
   > //创建概念顶点类型
   > schema.vertexLabel(concept.getIdentifier())//值为概念标识
   > .properties("name", "conceptId","entityId")
   > .ifNotExist()
   > .create();
   > //给概念顶点类型添加索引
   > schema.indexLabel(concept.getIdentifier().hashCode()+"_name_index")
   > .onV(concept.getIdentifier())
   > .by("name")
   > .secondary()
   > .ifNotExist()
   > .create();
   > schema.indexLabel(concept.getIdentifier().hashCode()+"_conceptId_index")
   > .onV(concept.getIdentifier())
   > .by("conceptId")
   > .secondary()
   > .ifNotExist()
   > .create();
   > schema.indexLabel(concept.getIdentifier().hashCode()+"_entityId_index")
   > .onV(concept.getIdentifier())
   > .by("entityId")
   > .secondary()
   > .ifNotExist()
   > .create();
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] cbb0610 commented on issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by GitBox <gi...@apache.org>.
cbb0610 commented on issue #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964#issuecomment-1253586719

   稳定复现的，来回多创建几次label 和index   mysql5.7.30  task 表是什么？，我的操作代码是 ： 都是执行到 插入conceptId index 报错了
    HugeClient client = getLocalClient(concept.getKg().getId());
               SchemaManager schema = client.schema();
               //创建概念顶点类型
               schema.vertexLabel(concept.getIdentifier())//值为概念标识
                       .properties("name", "conceptId","entityId")
                       .ifNotExist()
                       .create();
               //给概念顶点类型添加索引
               schema.indexLabel(concept.getIdentifier().hashCode()+"_name_index")
                       .onV(concept.getIdentifier())
                       .by("name")
                       .secondary()
                       .ifNotExist()
                       .create();
               schema.indexLabel(concept.getIdentifier().hashCode()+"_conceptId_index")
                       .onV(concept.getIdentifier())
                       .by("conceptId")
                       .secondary()
                       .ifNotExist()
                       .create();
               schema.indexLabel(concept.getIdentifier().hashCode()+"_entityId_index")
                       .onV(concept.getIdentifier())
                       .by("entityId")
                       .secondary()
                       .ifNotExist()
                       .create();


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] javeme closed issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by "javeme (via GitHub)" <gi...@apache.org>.
javeme closed issue #1964: mysql作为存储后端，一段时间后插入数据失败
URL: https://github.com/apache/incubator-hugegraph/issues/1964


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] cbb0610 commented on issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by GitBox <gi...@apache.org>.
cbb0610 commented on issue #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964#issuecomment-1253689625

   ![1](https://user-images.githubusercontent.com/19340021/191512518-dcff88b9-5fe6-4ad2-8191-d077d89ec8e6.jpg)
   ![2](https://user-images.githubusercontent.com/19340021/191512570-d19b1f8b-20e4-4618-8aa6-2cb319e3b5ed.jpg)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] imbajin commented on issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by GitBox <gi...@apache.org>.
imbajin commented on issue #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964#issuecomment-1252141061

   mysql 版本是? 另外是可以稳定复现的么, 如果可能提供一下最小复现的方式?
   
   从你的报错看似乎是 task 那边有啥异常, 你可以手动把 task 对应的表里, 那个 id 的数据添加/删除一下试试


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-hugegraph] javeme commented on issue #1964: mysql作为存储后端，一段时间后插入数据失败

Posted by "javeme (via GitHub)" <gi...@apache.org>.
javeme commented on issue #1964:
URL: https://github.com/apache/incubator-hugegraph/issues/1964#issuecomment-1443971193

   maybe related to: https://github.com/apache/incubator-hugegraph/pull/1672


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@hugegraph.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org