[ https://issues.apache.org/jira/browse/CASSANDRA-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-5568: -------------------------------------- Affects Version/s: (was: 1.2.4) 1.2.0 Fix Version/s: 1.2.5 > Invalid tracing info for execute_prepared_cql3_query > ---------------------------------------------------- > > Key: CASSANDRA-5568 > URL: https://issues.apache.org/jira/browse/CASSANDRA-5568 > Project: Cassandra > Issue Type: Bug > Components: Core > Affects Versions: 1.2.0 > Environment: Windows 8 x64 > Java HotSpot(TM) 64-Bit Server VM/1.7.0_11 > Reporter: Pierre Chalamet > Priority: Minor > Fix For: 1.2.5 > > > When using trace_next_query() then execute_prepared_cql3_query(), it looks > like tracing info are invalid (number of sessions/events and columns values > are wrong). > How to reproduce: > {code} > create keyspace Tests with replication = {'class': 'SimpleStrategy', > 'replication_factor' : 1} > create table Tests.stresstest (strid varchar,intid int, primary key (strid)) > {code} > and then executing the following prepared query 50,000 times: > {code} > insert into Tests.stresstest (intid, strid) values (?, ?) > {code} > produces the following results: > {code} > localhost> select count(*) from Tests.stresstest > +------------+ > | count | > +============+ > | 50000 | > +------------+ > localhost> select count(*) from system_traces.events > +------------+ > | count | > +============+ > | 20832 | > +------------+ > localhost> select count(*) from system_traces.sessions > +------------+ > | count | > +============+ > | 26717 | > +------------+ > localhost> select * from system_traces.sessions limit 10 > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | sessionid | coordinator | duration | > parameters | request | startedat | > +==========================================+=================+==============+================+=================================+===========================+ > | 9aefc263-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:55 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9ce0bcf7-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:59 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9dbe4ba4-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:17:00 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9d4d3a54-bcdb-11e2-8c60-fb495ee6a12c | | 44 | > | | | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9a790bc1-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:55 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9c992c98-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:58 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9e27e2f6-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 53 | > | execute_prepared_cql3_query | 5/14/2013 9:17:01 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9b172074-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:56 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9a7cdc53-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 53 | > | execute_prepared_cql3_query | 5/14/2013 9:16:55 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 9b6eb654-bcdb-11e2-8c60-fb495ee6a12c | 127.0.0.1 | | > | execute_prepared_cql3_query | 5/14/2013 9:16:56 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > {code} > Using binary protocol and enabling tracing produces expected results: > {code} > localhost> select count(*) from Tests.stresstest > +------------+ > | count | > +============+ > | 50000 | > +------------+ > localhost> select count(*) from system_traces.events > +-------------+ > | count | > +=============+ > | 200002 | > +-------------+ > localhost> select count(*) from system_traces.sessions > +------------+ > | count | > +============+ > | 50001 | > +------------+ > localhost> select * from system_traces.sessions limit 10 > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | sessionid | coordinator | duration | > parameters | request | startedat | > +==========================================+=================+==============+================+=================================+===========================+ > | 745f5d10-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 141 | > | Execute CQL3 prepared query | 5/14/2013 9:23:00 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 7ad9b050-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 131 | > | Execute CQL3 prepared query | 5/14/2013 9:23:11 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 7ba00d90-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 123 | > | Execute CQL3 prepared query | 5/14/2013 9:23:12 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 6ba0e635-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 60 | > | Execute CQL3 prepared query | 5/14/2013 9:22:45 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 7f4595f0-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 254 | > | Execute CQL3 prepared query | 5/14/2013 9:23:18 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 88c82020-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 1138 | > | Execute CQL3 prepared query | 5/14/2013 9:23:34 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 83c6ff60-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 142 | > | Execute CQL3 prepared query | 5/14/2013 9:23:26 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 824e1b05-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 75 | > | Execute CQL3 prepared query | 5/14/2013 9:23:23 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 73957d60-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 147 | > | Execute CQL3 prepared query | 5/14/2013 9:22:59 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > | 79f25d90-bcdc-11e2-8c60-fb495ee6a12c | 127.0.0.1 | 153 | > | Execute CQL3 prepared query | 5/14/2013 9:23:09 PM | > +------------------------------------------+-----------------+--------------+----------------+---------------------------------+---------------------------+ > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira