Samarth Jain created PHOENIX-1596:
-------------------------------------
Summary: Setting tracing frequency to ALWAYS on the client side
results in too many traces
Key: PHOENIX-1596
URL: https://issues.apache.org/jira/browse/PHOENIX-1596
Project: Phoenix
Issue Type: Bug
Reporter: Samarth Jain
After setting trace collection frequency to always by setting the following in
hbase-site.xml, I noticed that it created way too many traces in the trace
table.
<property>
<name>phoenix.trace.frequency</name>
<value>always</value>
</property>
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 1283 |
+------------------------------------------+
1 row selected (1.104 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 4051 |
+------------------------------------------+
1 row selected (1.058 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 10668 |
+------------------------------------------+
1 row selected (1.105 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 11361 |
+------------------------------------------+
1 row selected (1.046 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 193119 |
+------------------------------------------+
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 1283 |
+------------------------------------------+
1 row selected (1.104 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 4051 |
+------------------------------------------+
1 row selected (1.058 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 10668 |
+------------------------------------------+
1 row selected (1.105 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 11361 |
+------------------------------------------+
1 row selected (1.046 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 193119 |
+------------------------------------------+
1 row selected (6.737 seconds)
0: jdbc:phoenix:localhost> select count (*) from system.tracing_stats;
15/01/19 17:26:57 WARN client.HConnectionManager$HConnectionImplementation:
This client just lost it's session with ZooKeeper, closing it. It will be
recreated next time someone needs it
Even though the only query that was being executed was the select count(*) to
get the number of rows in the trace table, it ended up creating way too many
traces than I had expected.
On my mac, it in fact ended up killing the local hbase cluster altogether!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
