java-driver icon indicating copy to clipboard operation
java-driver copied to clipboard

Endless loop of Query [...] is not prepared [...], preparing before retrying executing.

Open avelanarius opened this issue 3 years ago • 1 comments

On this execution of integration tests: https://github.com/avelanarius/java-driver/runs/6175179427?check_suite_focus=true tests running against 5.0.rc3 and 2022.1.rc3 got stuck on an endless loop of:

    400406 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query UPDATE test SET c_int = ? WHERE pk = 42 is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400406 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query INSERT INTO test (pk) VALUES (?) is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400407 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query UPDATE test SET c_int = ? WHERE pk = 42 is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400407 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query INSERT INTO test (pk) VALUES (?) is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400408 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query UPDATE test SET c_int = ? WHERE pk = 42 is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400408 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query INSERT INTO test (pk) VALUES (?) is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400409 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query UPDATE test SET c_int = ? WHERE pk = 42 is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400409 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query INSERT INTO test (pk) VALUES (?) is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400410 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query UPDATE test SET c_int = ? WHERE pk = 42 is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems
    400410 [cluster68-nio-worker-2] INFO  com.datastax.driver.core.RequestHandler - Query INSERT INTO test (pk) VALUES (?) is not prepared on ks_17, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems

This test might be flaky, as I believe that 5.0.rc3 passed correctly before.

avelanarius avatar Apr 26 '22 13:04 avelanarius

I am not able to reproduce the issue locally, but thankfully running it a couple times on GitHub Actions (all tests - not only the offending one) is able to reproduce the problem.

avelanarius avatar Apr 26 '22 17:04 avelanarius

Closing as Dup of https://github.com/scylladb/scylladb/issues/10440 and #126 will take care of client side hardening.

roydahan avatar Jun 13 '24 13:06 roydahan