com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?')))

DataStax JIRA | Massimiliano Tomassi | 10 months ago
  1. 0

    Considering the following scenario: 1. from a CQL query containing a column A that exists in C* prepare a statement and cache it 2. run the prepared statement, it succeeds 3. remove the column A from C* 4. run the prepared statement, it fails with the following stack trace {code} com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?'))) com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?'))) at com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:218) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler.access$1000(RequestHandler.java:43) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler$SpeculativeExecution.sendRequest(RequestHandler.java:284) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler$SpeculativeExecution$1.run(RequestHandler.java:406) [cassandra-driver-core-3.0.0.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_72] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72] {code} Being it a problem of query preparation in C* an InvalidQueryException should be expected instead.

    DataStax JIRA | 10 months ago | Massimiliano Tomassi
    com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?')))
  2. 0

    Considering the following scenario: 1. from a CQL query containing a column A that exists in C* prepare a statement and cache it 2. run the prepared statement, it succeeds 3. remove the column A from C* 4. run the prepared statement, it fails with the following stack trace {code} com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?'))) com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?'))) at com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:218) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler.access$1000(RequestHandler.java:43) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler$SpeculativeExecution.sendRequest(RequestHandler.java:284) [cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.RequestHandler$SpeculativeExecution$1.run(RequestHandler.java:406) [cassandra-driver-core-3.0.0.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_72] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72] {code} Being it a problem of query preparation in C* an InvalidQueryException should be expected instead.

    DataStax JIRA | 10 months ago | Massimiliano Tomassi
    com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?')))
  3. 0

    Cassandra Java Exception - NoHostAvailableException - Code - Help To User

    helptouser.com | 11 months ago
    com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.1:9042 (com.datastax.driver.core.exceptions.DriverException: Host replied with server error: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.io.FileNotFoundException: C:\apache-cassandra-new\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-tmplink-ka-4839-Data.db (The process cannot access the file because it is being used by another process)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 832#156657004

    GitHub | 1 year ago | drax68
    com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: cassandra.example.com/1.2.3.4:9042 (com.datastax.driver.core.OperationTimedOutException: [cassandra.example.com/1.2.3.4:9042] Operation timed out))
  6. 0

    NoHostAvailableException

    pr8x.com | 1 year ago
    com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.1:9042 (com.datastax.driver.core.exceptions.DriverException: Host replied with server error: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.io.FileNotFoundException: C:\apache-cassandra-new\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-tmplink-ka-4839-Data.db (The process cannot access the file because it is being used by another process)))

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.datastax.driver.core.exceptions.NoHostAvailableException

      All host(s) tried for query failed (tried: /192.168.3.11:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: Undefined name edge_id in where clause ('edge_id = ?')))

      at com.datastax.driver.core.RequestHandler.reportNoMoreHosts()
    2. DataStax Java Driver for Apache Cassandra - Core
      RequestHandler$SpeculativeExecution$1.run
      1. com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:218)[cassandra-driver-core-3.0.0.jar:na]
      2. com.datastax.driver.core.RequestHandler.access$1000(RequestHandler.java:43)[cassandra-driver-core-3.0.0.jar:na]
      3. com.datastax.driver.core.RequestHandler$SpeculativeExecution.sendRequest(RequestHandler.java:284)[cassandra-driver-core-3.0.0.jar:na]
      4. com.datastax.driver.core.RequestHandler$SpeculativeExecution$1.run(RequestHandler.java:406)[cassandra-driver-core-3.0.0.jar:na]
      4 frames
    3. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_72]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_72]
      3. java.lang.Thread.run(Thread.java:745)[na:1.8.0_72]
      3 frames