Skip to content

Instantly share code, notes, and snippets.

@gregjan

gregjan/system.log

Created March 14, 2019 19:10
Show Gist options
  • Save gregjan/fda9ffcca10c038fc08fcc2c21137556 to your computer and use it in GitHub Desktop.
Save gregjan/fda9ffcca10c038fc08fcc2c21137556 to your computer and use it in GitHub Desktop.
Download ZIP
log lines from time of testing
Raw
system.log
DEBUG [cluster1-nio-worker-4] 2019-03-14 19:06:40,293 QueryLogger.java:711 - [cluster1] [/10.0.19.7:9042] Query completed normally, took 5 ms: [1 bound values] SELECT modified FROM mutabledata WHERE identifier = ?;
DEBUG [cluster1-nio-worker-4] 2019-03-14 19:06:40,296 QueryLogger.java:711 - [cluster1] [/10.0.19.7:9042] Query completed normally, took 9 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,182 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 4 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,184 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 6 ms: [1 bound values] SELECT modified FROM mutabledata WHERE identifier = ?;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,207 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 1 ms: [2 bound values] SELECT quads FROM mutabledata WHERE identifier = :identifier AND createdSeconds <= :createdSeconds LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,211 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 1 ms: [1 bound values] SELECT quads FROM immutabledata WHERE identifier = ? ;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,217 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 4 ms: [1 bound values] SELECT identifier AS contained FROM basiccontainment WHERE container = :container ;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:06:46,222 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 1 ms: [1 bound values] SELECT identifier AS contained FROM basiccontainment WHERE container = :container ;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,628 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 5 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,629 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 6 ms: [1 bound values] SELECT modified FROM mutabledata WHERE identifier = ?;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,636 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 1 ms: [2 bound values] SELECT quads FROM mutabledata WHERE identifier = :identifier AND createdSeconds <= :createdSeconds LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,639 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 2 ms: [1 bound values] SELECT quads FROM immutabledata WHERE identifier = ? ;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,645 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 5 ms: [1 bound values] SELECT identifier AS contained FROM basiccontainment WHERE container = :container ;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:06:51,650 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 4 ms: [1 bound values] SELECT identifier AS contained FROM basiccontainment WHERE container = :container ;
DEBUG [cluster1-nio-worker-2] 2019-03-14 19:07:30,551 QueryLogger.java:711 - [cluster1] [cassandra-1/10.0.19.5:9042] Query completed normally, took 2 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:30,554 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 5 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:07:30,564 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 3 ms: [4 bound values] INSERT INTO binarydata (identifier, chunkSize, chunkIndex, chunk) VALUES (:identifier, :chunkSize, :chunkIndex, :chunk);
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:30,569 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 2 ms: [3 bound values] INSERT INTO immutabledata (identifier, quads, created) VALUES (?,?,?);
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:30,571 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 4 ms: [9 bound values] INSERT INTO mutabledata (interactionModel, mimeType, createdSeconds, container, quads, modified, binaryIdentifier, created, identifier) VALUES (?,?,?,?,?,?,?,?,?);
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:30,574 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 2 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:45,400 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 2 ms: [1 bound values] SELECT modified FROM mutabledata WHERE identifier = ?;
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:07:45,401 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 3 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:07:45,415 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 4 ms: [1 bound values] SELECT chunkSize FROM binarydata WHERE identifier = :identifier LIMIT 1;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:07:45,420 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 1 ms: [1 bound values] SELECT chunkIndex FROM binarydata WHERE identifier = :identifier;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:07:45,438 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 3 ms: [2 bound values] SELECT chunk FROM binarydata WHERE identifier = :identifier and chunkIndex = :chunkIndex;
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:08:06,329 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 1 ms: [2 bound values] SELECT * FROM mutabledata WHERE identifier = ? AND createdSeconds <= ? LIMIT 1 ALLOW FILTERING;
DEBUG [cluster1-nio-worker-6] 2019-03-14 19:08:06,330 QueryLogger.java:711 - [cluster1] [/10.0.19.10:9042] Query completed normally, took 3 ms: [1 bound values] SELECT modified FROM mutabledata WHERE identifier = ?;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:08:06,335 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 3 ms: [1 bound values] SELECT chunkSize FROM binarydata WHERE identifier = :identifier LIMIT 1;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:08:06,338 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 2 ms: [1 bound values] SELECT chunkIndex FROM binarydata WHERE identifier = :identifier;
DEBUG [cluster1-nio-worker-8] 2019-03-14 19:08:06,340 QueryLogger.java:711 - [cluster1] [/10.0.19.13:9042] Query completed normally, took 1 ms: [2 bound values] SELECT chunk FROM binarydata WHERE identifier = :identifier and chunkIndex = :chunkIndex;
#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment