lim_4981 2021-08-20 09:29 采纳率: 0%
浏览 7
已结题

springData cassandra 查询条件in的参数个数限制

使用spring-data-cassandra进行查询
报错日志(已删除日志中in条件参数,原总共1006项):

10:47:00.708[WARN ][cluster10-nio-worker-3] c.d.driver.core.RequestHandler 630 - /192.168.1.211:9042 replied with server error (partition key cartesian product size 1006 is greater than maximum 100), defuncting connection.
10:47:00.720[ERROR][https-jsse-nio-8888-exec-7] c.t.i.j.p.GlobalExceptionHandler 26 - Global Exception Catch : 
org.springframework.data.cassandra.CassandraConnectionFailureException: Query; CQL [SELECT * FROM user_info WHERE id IN ('f', ''....);]; All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100)); nested exception is com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100))
    at org.springframework.data.cassandra.core.cql.CassandraExceptionTranslator.translate(CassandraExceptionTranslator.java:155) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
    at org.springframework.data.cassandra.core.cql.CassandraAccessor.translate(CassandraAccessor.java:334) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
    at org.springframework.data.cassandra.core.cql.CqlTemplate.translateException(CqlTemplate.java:732) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
...

Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100))
  • 写回答

0条回答 默认 最新

    报告相同问题?

    问题事件

    • 系统已结题 8月28日
    • 创建了问题 8月20日

    悬赏问题

    • ¥15 cannot import name '_MissingValues' from 'sklearn.utils._param_validation'引用smoke
    • ¥15 shiro springboot集成问题
    • ¥15 求PHP跨站免登录技术
    • ¥15 AVL fire DVI中的Design Explorer里面的Objectives /Constraints的scale应该怎么设置
    • ¥15 qml如何绘制三维笛卡尔坐标系并向其中添加折线?
    • ¥15 treelib库有读取树数据方法吗?
    • ¥15 咨询一个PYTHON的问题
    • ¥15 机器学习建模调参,roc评价指标
    • ¥15 RCS plot 包内置数据集使用时报错,如何解决?
    • ¥15 keil+mspm0g3507+二维总线舵机