cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Haddad (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-13002) per table slow query times
Date Tue, 21 Feb 2017 22:37:44 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-13002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876894#comment-15876894
] 

Jon Haddad commented on CASSANDRA-13002:
----------------------------------------

I don't believe this patch correctly handles upgrading from previous versions.  To test this,
I built off the cassandra-3.0 branch, and loaded the movielens dataset using {{cdm}} https://github.com/rustyrazorblade/cdm

I shut down the server, ran {{ant clean}} and {{ant}}, then restarted.  The server immediately
died with this at the end of the logs:

{code}INFO  [main] 2017-02-21 14:34:30,438 ColumnFamilyStore.java:419 - Initializing system_schema.views
INFO  [main] 2017-02-21 14:34:30,448 ColumnFamilyStore.java:419 - Initializing system_schema.types
INFO  [main] 2017-02-21 14:34:30,458 ColumnFamilyStore.java:419 - Initializing system_schema.functions
INFO  [main] 2017-02-21 14:34:30,469 ColumnFamilyStore.java:419 - Initializing system_schema.aggregates
INFO  [main] 2017-02-21 14:34:30,481 ColumnFamilyStore.java:419 - Initializing system_schema.indexes
INFO  [main] 2017-02-21 14:34:30,488 ViewManager.java:125 - Not submitting build tasks for
views in keyspace system_schema as storage service is not initialized
Exception (java.lang.NullPointerException) encountered during startup: null
java.lang.NullPointerException
	at org.apache.cassandra.serializers.Int32Serializer.deserialize(Int32Serializer.java:31)
	at org.apache.cassandra.serializers.Int32Serializer.deserialize(Int32Serializer.java:25)
	at org.apache.cassandra.db.marshal.AbstractType.compose(AbstractType.java:116)
	at org.apache.cassandra.cql3.UntypedResultSet$Row.getInt(UntypedResultSet.java:287)
	at org.apache.cassandra.schema.SchemaKeyspace.createTableParamsFromRow(SchemaKeyspace.java:987)
	at org.apache.cassandra.schema.SchemaKeyspace.fetchTable(SchemaKeyspace.java:961)
	at org.apache.cassandra.schema.SchemaKeyspace.fetchTables(SchemaKeyspace.java:928)
	at org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspace(SchemaKeyspace.java:887)
	at org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspacesWithout(SchemaKeyspace.java:878)
	at org.apache.cassandra.schema.SchemaKeyspace.fetchNonSystemKeyspaces(SchemaKeyspace.java:866)
	at org.apache.cassandra.schema.Schema.loadFromDisk(Schema.java:113)
	at org.apache.cassandra.schema.Schema.loadFromDisk(Schema.java:103)
	at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:238)
	at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:557)
	at org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:646)
ERROR [main] 2017-02-21 14:34:30,562 CassandraDaemon.java:663 - Exception encountered during
startup
java.lang.NullPointerException: null
	at org.apache.cassandra.serializers.Int32Serializer.deserialize(Int32Serializer.java:31)
~[main/:na]
	at org.apache.cassandra.serializers.Int32Serializer.deserialize(Int32Serializer.java:25)
~[main/:na]
	at org.apache.cassandra.db.marshal.AbstractType.compose(AbstractType.java:116) ~[main/:na]
	at org.apache.cassandra.cql3.UntypedResultSet$Row.getInt(UntypedResultSet.java:287) ~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.createTableParamsFromRow(SchemaKeyspace.java:987)
~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.fetchTable(SchemaKeyspace.java:961) ~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.fetchTables(SchemaKeyspace.java:928) ~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspace(SchemaKeyspace.java:887) ~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspacesWithout(SchemaKeyspace.java:878)
~[main/:na]
	at org.apache.cassandra.schema.SchemaKeyspace.fetchNonSystemKeyspaces(SchemaKeyspace.java:866)
~[main/:na]
	at org.apache.cassandra.schema.Schema.loadFromDisk(Schema.java:113) ~[main/:na]
	at org.apache.cassandra.schema.Schema.loadFromDisk(Schema.java:103) ~[main/:na]
	at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:238) [main/:na]
	at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:557) [main/:na]
	at org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:646) [main/:na]{code}

> per table slow query times
> --------------------------
>
>                 Key: CASSANDRA-13002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13002
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Jon Haddad
>            Assignee: Murukesh Mohanan
>             Fix For: 4.x
>
>         Attachments: 0001-Add-per-table-slow_query_log_timeout_in_ms-property.patch
>
>
> CASSANDRA-12403 made it possible to log slow queries, but the time specified is a global
one.  This isn't useful if we know different tables have different access patterns, as we'll
end up with a lot of noise.  We should be able to override the slow query time at a per table
level.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message