no index

Question

no index

pengpeng-fan opened this issue 4 years ago · 0 comments

pengpeng-fan commented 4 years ago

Describe the feature:

Elassandra version:6.2.3

Plugins installed: []

JVM version (java -version):1.8

OS version (uname -a if on a Unix-like system): CentOS Linux release 7.6.1810

Description of the problem including expected versus actual behavior:
Query prompt has no index. After our preliminary investigation, we found that elastic_ The data in the admin table is empty and 'select comment from system' is used_ schema.tables WHERE keyspace_ name='elastic_ admin' AND table_ name='metadata';’ Query results show that there is no information about indexes

Steps to reproduce:

Please include a minimal but complete recreation of the problem, including
(e.g.) index creation, mappings, settings, query etc. The easier you make for
us to reproduce it, the more likely that somebody will take the time to look at it.

Install elassandra service
Create a table space
Restart service

Please provide the following information:

elassandra logs (logs/system.logs or /var/lib/cassandra/system.log)

2021-06-15 10:59:12,400 INFO [main] YamlConfigurationLoader.java:89 getStorageConfigURL Configuration location: file:/tdfs/opt/td_elassandra/elassandra/conf/cassandra.yaml
2021-06-15 10:59:12,554 INFO [main] Config.java:495 log Node configuration:[allocate_tokens_for_keyspace=null; authenticator=PasswordAuthenticator; authorizer=CassandraAuthorizer; auto_bootstrap=true; auto_snapshot=true; back_pressure_enabled=false; back_pressure_strategy=null; batch_size_fail_threshold_in_kb=5000; batch_size_warn_threshold_in_kb=3000; batchlog_replay_throttle_in_kb=1024; broadcast_address=null; broadcast_rpc_address=null; buffer_pool_use_heap_if_exhausted=true; cas_contention_timeout_in_ms=3000; cdc_enabled=false; cdc_free_space_check_interval_ms=250; cdc_raw_directory=null; cdc_total_space_in_mb=0; client_encryption_options=; cluster_name=TiandyCluster; column_index_cache_size_in_kb=2; column_index_size_in_kb=512; commit_failure_policy=stop; commitlog_compression=LZ4Compressor; commitlog_directory=null; commitlog_max_compression_buffers_in_pool=3; commitlog_periodic_queue_size=-1; commitlog_segment_size_in_mb=64; commitlog_sync=periodic; commitlog_sync_batch_window_in_ms=NaN; commitlog_sync_period_in_ms=10000; commitlog_total_space_in_mb=1024; compaction_large_partition_warning_threshold_mb=100; compaction_throughput_mb_per_sec=16; concurrent_compactors=null; concurrent_counter_writes=8; concurrent_materialized_view_writes=1; concurrent_reads=16; concurrent_replicates=null; concurrent_writes=16; counter_cache_keys_to_save=2147483647; counter_cache_save_period=7200; counter_cache_size_in_mb=50; counter_write_request_timeout_in_ms=60000; credentials_cache_max_entries=1000; credentials_update_interval_in_ms=-1; credentials_validity_in_ms=2000; cross_node_timeout=false; data_file_directories=[Ljava.lang.String;@7e0b85f9; disk_access_mode=auto; disk_failure_policy=stop; disk_optimization_estimate_percentile=0.95; disk_optimization_page_cross_chance=0.1; disk_optimization_strategy=ssd; dynamic_snitch=true; dynamic_snitch_badness_threshold=0.1; dynamic_snitch_reset_interval_in_ms=600000; dynamic_snitch_update_interval_in_ms=100; enable_materialized_views=true; enable_scripted_user_defined_functions=false; enable_user_defined_functions=false; enable_user_defined_functions_threads=true; encryption_options=null; endpoint_snitch=GossipingPropertyFileSnitch; file_cache_round_up=null; file_cache_size_in_mb=128; gc_log_threshold_in_ms=200; gc_warn_threshold_in_ms=1000; hinted_handoff_disabled_datacenters=[]; hinted_handoff_enabled=true; hinted_handoff_throttle_in_kb=1024; hints_compression=null; hints_directory=/mnt/data/elassandra/data/cassandra/hints; hints_flush_period_in_ms=10000; incremental_backups=false; index_interval=null; index_summary_capacity_in_mb=null; index_summary_resize_interval_in_minutes=60; initial_token=null; inter_dc_stream_throughput_outbound_megabits_per_sec=200; inter_dc_tcp_nodelay=false; internode_authenticator=null; internode_compression=all; internode_recv_buff_size_in_bytes=0; internode_send_buff_size_in_bytes=0; key_cache_keys_to_save=2147483647; key_cache_save_period=14400; key_cache_size_in_mb=100; listen_address=127.0.0.1; listen_interface=null; listen_interface_prefer_ipv6=false; listen_on_broadcast_address=false; max_hint_window_in_ms=10800000; max_hints_delivery_threads=2; max_hints_file_size_in_mb=256; max_mutation_size_in_kb=null; max_streaming_retries=3; max_value_size_in_mb=256; memtable_allocation_type=offheap_buffers; memtable_cleanup_threshold=null; memtable_flush_writers=0; memtable_heap_space_in_mb=512; memtable_offheap_space_in_mb=512; min_free_space_per_drive_in_mb=50; native_transport_max_concurrent_connections=-1; native_transport_max_concurrent_connections_per_ip=-1; native_transport_max_frame_size_in_mb=256; native_transport_max_threads=128; native_transport_port=9043; native_transport_port_ssl=null; num_tokens=256; otc_backlog_expiration_interval_ms=200; otc_coalescing_enough_coalesced_messages=8; otc_coalescing_strategy=DISABLED; otc_coalescing_window_us=200; partitioner=org.apache.cassandra.dht.Murmur3Partitioner; permissions_cache_max_entries=1000; permissions_update_interval_in_ms=-1; permissions_validity_in_ms=2000; phi_convict_threshold=8.0; prepared_statements_cache_size_mb=null; range_request_timeout_in_ms=180000; read_request_timeout_in_ms=180000; request_scheduler=org.apache.cassandra.scheduler.RoundRobinScheduler; request_scheduler_id=keyspace; request_scheduler_options=org.apache.cassandra.config.RequestSchedulerOptions@9353778; request_timeout_in_ms=180000; role_manager=CassandraRoleManager; roles_cache_max_entries=1000; roles_update_interval_in_ms=-1; roles_validity_in_ms=2000; row_cache_class_name=org.apache.cassandra.cache.OHCProvider; row_cache_keys_to_save=2147483647; row_cache_save_period=0; row_cache_size_in_mb=0; rpc_address=127.0.0.1; rpc_interface=null; rpc_interface_prefer_ipv6=false; rpc_keepalive=true; rpc_listen_backlog=50; rpc_max_threads=16; rpc_min_threads=4; rpc_port=9160; rpc_recv_buff_size_in_bytes=null; rpc_send_buff_size_in_bytes=null; rpc_server_type=sync; saved_caches_directory=null; seed_provider=org.apache.cassandra.locator.SimpleSeedProvider{seeds=127.0.0.1}; server_encryption_options=; slow_query_log_timeout_in_ms=500; snapshot_before_compaction=false; ssl_storage_port=7701; sstable_preemptive_open_interval_in_mb=50; start_native_transport=true; start_rpc=true; storage_port=7700; stream_throughput_outbound_megabits_per_sec=200; streaming_keep_alive_period_in_secs=300; streaming_socket_timeout_in_ms=86400000; thrift_framed_transport_size_in_mb=15; thrift_max_message_length_in_mb=16; thrift_prepared_statements_cache_size_mb=null; tombstone_failure_threshold=100000; tombstone_warn_threshold=1000; tracetype_query_ttl=86400; tracetype_repair_ttl=604800; transparent_data_encryption_options=org.apache.cassandra.config.TransparentDataEncryptionOptions@63355449; trickle_fsync=false; trickle_fsync_interval_in_kb=10240; truncate_request_timeout_in_ms=180000; unlogged_batch_across_partitions_warn_threshold=10; user_defined_function_fail_timeout=1500; user_defined_function_warn_timeout=500; user_function_timeout_policy=die; windows_timer_interval=1; write_request_timeout_in_ms=40000]
2021-06-15 10:59:12,554 INFO [main] DatabaseDescriptor.java:367 applySimpleConfig DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap
2021-06-15 10:59:12,554 INFO [main] DatabaseDescriptor.java:425 applySimpleConfig Global memtable on-heap threshold is enabled at 512MB
2021-06-15 10:59:12,554 INFO [main] DatabaseDescriptor.java:429 applySimpleConfig Global memtable off-heap threshold is enabled at 512MB
2021-06-15 10:59:12,647 INFO [main] RateBasedBackPressure.java:123 Initialized back-pressure with high ratio: 0.9, factor: 5, flow: FAST, window size: 40000.
2021-06-15 10:59:12,647 INFO [main] DatabaseDescriptor.java:729 applySimpleConfig Back-pressure is disabled with strategy null.
2021-06-15 10:59:12,744 INFO [main] GossipingPropertyFileSnitch.java:64 Loaded cassandra-topology.properties for compatibility
2021-06-15 10:59:12,755 INFO [main] RoundRobinScheduler.java:72 Started the RoundRobin Request Scheduler
2021-06-15 10:59:13,583 INFO [main] NativeLibrary.java:174 tryMlockall JNA mlockall successful
2021-06-15 10:59:14,538 INFO [main] QueryProcessor.java:116 Initialized prepared statement caches with 10 MB (native) and 10 MB (Thrift)
2021-06-15 10:59:14,700 INFO [main] ClientState.java:101 Using org.elassandra.index.ElasticQueryHandler as query handler for native protocol queries (as requested with -Dcassandra.custom_query_handler_class)
2021-06-15 10:59:14,774 INFO [main] ColumnFamilyStore.java:411 Initializing system.IndexInfo
2021-06-15 10:59:15,098 INFO [main] ColumnFamilyStore.java:411 Initializing system.batches
2021-06-15 10:59:15,101 INFO [main] ColumnFamilyStore.java:411 Initializing system.paxos
2021-06-15 10:59:15,105 INFO [main] ColumnFamilyStore.java:411 Initializing system.local
2021-06-15 10:59:15,108 INFO [main] ColumnFamilyStore.java:411 Initializing system.peers
2021-06-15 10:59:15,111 INFO [main] ColumnFamilyStore.java:411 Initializing system.peer_events
2021-06-15 10:59:15,113 INFO [main] ColumnFamilyStore.java:411 Initializing system.range_xfers
2021-06-15 10:59:15,115 INFO [main] ColumnFamilyStore.java:411 Initializing system.compaction_history
2021-06-15 10:59:15,118 INFO [main] ColumnFamilyStore.java:411 Initializing system.sstable_activity
2021-06-15 10:59:15,121 INFO [main] ColumnFamilyStore.java:411 Initializing system.size_estimates
2021-06-15 10:59:15,123 INFO [main] ColumnFamilyStore.java:411 Initializing system.available_ranges
2021-06-15 10:59:15,125 INFO [main] ColumnFamilyStore.java:411 Initializing system.transferred_ranges
2021-06-15 10:59:15,127 INFO [main] ColumnFamilyStore.java:411 Initializing system.views_builds_in_progress
2021-06-15 10:59:15,129 INFO [main] ColumnFamilyStore.java:411 Initializing system.built_views
2021-06-15 10:59:15,131 INFO [main] ColumnFamilyStore.java:411 Initializing system.hints
2021-06-15 10:59:15,133 INFO [main] ColumnFamilyStore.java:411 Initializing system.batchlog
2021-06-15 10:59:15,135 INFO [main] ColumnFamilyStore.java:411 Initializing system.prepared_statements
2021-06-15 10:59:15,137 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_keyspaces
2021-06-15 10:59:15,139 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_columnfamilies
2021-06-15 10:59:15,141 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_columns
2021-06-15 10:59:15,142 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_triggers
2021-06-15 10:59:15,144 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_usertypes
2021-06-15 10:59:15,146 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_functions
2021-06-15 10:59:15,148 INFO [main] ColumnFamilyStore.java:411 Initializing system.schema_aggregates
2021-06-15 10:59:15,149 INFO [main] ViewManager.java:137 reload Not submitting build tasks for views in keyspace system as storage service is not initialized
2021-06-15 10:59:15,169 INFO [main] ApproximateTime.java:44 Scheduling approximate time-check task with a precision of 10 milliseconds
2021-06-15 10:59:15,180 WARN [main] SystemKeyspace.java:1087 getLocalHostId No host ID found, created 3490f371-a327-443d-87a4-00d1542005b9 (Note: This should happen exactly once per node).
2021-06-15 10:59:16,618 INFO [main] JMXServerUtils.java:246 logJmxServiceUrl Configured JMX server at: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:7199/jmxrmi
2021-06-15 10:59:16,621 INFO [main] CassandraDaemon.java:481 logSystemInfo Hostname: localhost
2021-06-15 10:59:16,621 INFO [main] CassandraDaemon.java:488 logSystemInfo JVM vendor/version: Java HotSpot(TM) 64-Bit Server VM/1.8.0_212
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:489 logSystemInfo Heap size: 2.000GiB/2.000GiB
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:494 logSystemInfo Code Cache Non-heap memory: init = 2555904(2496K) used = 14886656(14537K) committed = 14942208(14592K) max = 251658240(245760K)
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:494 logSystemInfo Metaspace Non-heap memory: init = 0(0K) used = 56966816(55631K) committed = 60555264(59136K) max = -1(-1K)
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:494 logSystemInfo Compressed Class Space Non-heap memory: init = 0(0K) used = 7650184(7470K) committed = 8912896(8704K) max = 1073741824(1048576K)
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:494 logSystemInfo G1 Eden Space Heap memory: init = 880803840(860160K) used = 824180736(804864K) committed = 880803840(860160K) max = -1(-1K)
2021-06-15 10:59:16,622 INFO [main] CassandraDaemon.java:494 logSystemInfo G1 Survivor Space Heap memory: init = 0(0K) used = 42991616(41984K) committed = 42991616(41984K) max = -1(-1K)
2021-06-15 10:59:16,623 INFO [main] CassandraDaemon.java:494 logSystemInfo G1 Old Gen Heap memory: init = 1266679808(1236992K) used = 14680136(14336K) committed = 1266679808(1236992K) max = 2147483648(2097152K)
2021-06-15 10:59:16,623 INFO [main] CassandraDaemon.java:496 logSystemInfo Classpath: /opt/td_elassandra/elassandra/conf:/opt/td_elassandra/elassandra/lib/airline-0.6.jar:/opt/td_elassandra/elassandra/lib/ant-1.7.0.jar:/opt/td_elassandra/elassandra/lib/ant-launcher-1.7.0.jar:/opt/td_elassandra/elassandra/lib/antlr-3.5.2.jar:/opt/td_elassandra/elassandra/lib/antlr-runtime-3.5.2.jar:/opt/td_elassandra/elassandra/lib/automaton-1.11-8.jar:/opt/td_elassandra/elassandra/lib/caffeine-2.2.6.jar:/opt/td_elassandra/elassandra/lib/cassandra-all-3.11.3.jar:/opt/td_elassandra/elassandra/lib/cassandra-driver-core-3.0.1-shaded.jar:/opt/td_elassandra/elassandra/lib/cassandra-thrift-3.11.3.jar:/opt/td_elassandra/elassandra/lib/commons-cli-1.3.1.jar:/opt/td_elassandra/elassandra/lib/commons-codec-1.10.jar:/opt/td_elassandra/elassandra/lib/commons-lang3-3.4.jar:/opt/td_elassandra/elassandra/lib/commons-logging-1.2.jar:/opt/td_elassandra/elassandra/lib/commons-math3-3.2.jar:/opt/td_elassandra/elassandra/lib/compress-lzf-0.8.4.jar:/opt/td_elassandra/elassandra/lib/concurrentlinkedhashmap-lru-1.4.jar:/opt/td_elassandra/elassandra/lib/concurrent-trees-2.4.0.jar:/opt/td_elassandra/elassandra/lib/disruptor-3.0.1.jar:/opt/td_elassandra/elassandra/lib/dropwizard-metrics-influxdb-1.1.10-SNAPSHOT.jar:/opt/td_elassandra/elassandra/lib/ecj-4.4.2.jar:/opt/td_elassandra/elassandra/lib/elasticsearch-6.2.3.jar:/opt/td_elassandra/elassandra/lib/elasticsearch-cli-6.2.3.jar:/opt/td_elassandra/elassandra/lib/elasticsearch-core-6.2.3.jar:/opt/td_elassandra/elassandra/lib/elasticsearch-launchers-6.2.3.jar:/opt/td_elassandra/elassandra/lib/fastutil-6.5.7.jar:/opt/td_elassandra/elassandra/lib/guava-19.0.jar:/opt/td_elassandra/elassandra/lib/HdrHistogram-2.1.9.jar:/opt/td_elassandra/elassandra/lib/hibernate-validator-4.3.0.Final.jar:/opt/td_elassandra/elassandra/lib/high-scale-lib-1.0.6.jar:/opt/td_elassandra/elassandra/lib/hppc-0.7.1.jar:/opt/td_elassandra/elassandra/lib/httpclient-4.5.2.jar:/opt/td_elassandra/elassandra/lib/httpcore-4.4.5.jar:/opt/td_elassandra/elassandra/lib/jackson-core-2.8.10.jar:/opt/td_elassandra/elassandra/lib/jackson-core-asl-1.9.13.jar:/opt/td_elassandra/elassandra/lib/jackson-dataformat-cbor-2.8.10.jar:/opt/td_elassandra/elassandra/lib/jackson-dataformat-smile-2.8.10.jar:/opt/td_elassandra/elassandra/lib/jackson-dataformat-yaml-2.8.10.jar:/opt/td_elassandra/elassandra/lib/jackson-mapper-asl-1.9.13.jar:/opt/td_elassandra/elassandra/lib/javassist-3.20.0-GA.jar:/opt/td_elassandra/elassandra/lib/javax.inject-1.jar:/opt/td_elassandra/elassandra/lib/jbcrypt-0.3m.jar:/opt/td_elassandra/elassandra/lib/jboss-logging-3.1.0.CR2.jar:/opt/td_elassandra/elassandra/lib/jcl-over-slf4j-1.7.7.jar:/opt/td_elassandra/elassandra/lib/jctools-core-1.2.1.jar:/opt/td_elassandra/elassandra/lib/jflex-1.6.0.jar:/opt/td_elassandra/elassandra/lib/jna-4.5.1.jar:/opt/td_elassandra/elassandra/lib/joda-time-2.9.9.jar:/opt/td_elassandra/elassandra/lib/jopt-simple-5.0.2.jar:/opt/td_elassandra/elassandra/lib/json-simple-1.1.jar:/opt/td_elassandra/elassandra/lib/jts-1.13.jar:/opt/td_elassandra/elassandra/lib/libthrift-0.9.2.jar:/opt/td_elassandra/elassandra/lib/log4j-api-2.9.1.jar:/opt/td_elassandra/elassandra/lib/log4j-core-2.9.1.jar:/opt/td_elassandra/elassandra/lib/log4j-over-slf4j-1.7.7.jar:/opt/td_elassandra/elassandra/lib/log4j-to-slf4j-2.9.1.jar:/opt/td_elassandra/elassandra/lib/logback-classic-1.1.8.jar:/opt/td_elassandra/elassandra/lib/logback-core-1.1.8.jar:/opt/td_elassandra/elassandra/lib/lucene-analyzers-common-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-backward-codecs-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-core-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-grouping-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-highlighter-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-join-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-memory-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-misc-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-queries-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-queryparser-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-sandbox-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-spatial3d-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-spatial-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-spatial-extras-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lucene-suggest-7.2.1.jar:/opt/td_elassandra/elassandra/lib/lz4-1.3.0.jar:/opt/td_elassandra/elassandra/lib/metrics-core-3.1.0.jar:/opt/td_elassandra/elassandra/lib/metrics-influxdb-1.1.10-SNAPSHOT.jar:/opt/td_elassandra/elassandra/lib/metrics-jvm-3.1.5.jar:/opt/td_elassandra/elassandra/lib/netty-all-4.1.16.Final.jar:/opt/td_elassandra/elassandra/lib/ohc-core-0.4.4.jar:/opt/td_elassandra/elassandra/lib/ohc-core-j8-0.4.4.jar:/opt/td_elassandra/elassandra/lib/plugin-classloader-6.2.3.jar:/opt/td_elassandra/elassandra/lib/plugin-cli-6.2.3.jar:/opt/td_elassandra/elassandra/lib/reporter-config3-3.0.4.jar:/opt/td_elassandra/elassandra/lib/reporter-config-base-3.0.4.jar:/opt/td_elassandra/elassandra/lib/securesm-1.2.jar:/opt/td_elassandra/elassandra/lib/sigar-1.6.4.jar:/opt/td_elassandra/elassandra/lib/slf4j-api-1.7.25.jar:/opt/td_elassandra/elassandra/lib/snakeyaml-1.17.jar:/opt/td_elassandra/elassandra/lib/snappy-java-1.1.1.7.jar:/opt/td_elassandra/elassandra/lib/spatial4j-0.6.jar:/opt/td_elassandra/elassandra/lib/ST4-4.0.8.jar:/opt/td_elassandra/elassandra/lib/strapdata-core-6.2.3.jar:/opt/td_elassandra/elassandra/lib/stream-2.5.2.jar:/opt/td_elassandra/elassandra/lib/t-digest-3.0.jar:/opt/td_elassandra/elassandra/lib/thrift-server-0.3.7.jar:/opt/td_elassandra/elassandra/lib/validation-api-1.0.0.GA.jar:/opt/td_elassandra/elassandra/lib/jamm-0.3.0.jar
2021-06-15 10:59:16,623 INFO [main] CassandraDaemon.java:498 logSystemInfo JVM Arguments: [-Djava.library.path=/opt/td_elassandra/elassandra/lib/sigar-bin, -Xms2G, -Xmx2G, -Xmn800M, -ea, -XX:+UseThreadPriorities, -XX:ThreadPriorityPolicy=42, -XX:+HeapDumpOnOutOfMemoryError, -XX:StringTableSize=1000003, -XX:+AlwaysPreTouch, -XX:-UseBiasedLocking, -XX:+UseTLAB, -XX:+ResizeTLAB, -XX:+UseNUMA, -XX:+PerfDisableSharedMem, -Djava.net.preferIPv4Stack=true, -XX:+UseG1GC, -XX:G1RSetUpdatingPauseTimePercent=5, -XX:MaxGCPauseMillis=500, -XX:InitiatingHeapOccupancyPercent=70, -XX:ParallelGCThreads=8, -XX:ConcGCThreads=8, -XX:+PrintGCDetails, -XX:+PrintGCDateStamps, -XX:+PrintHeapAtGC, -XX:+PrintTenuringDistribution, -XX:+PrintGCApplicationStoppedTime, -XX:+PrintPromotionFailure, -XX:+UseGCLogFileRotation, -XX:NumberOfGCLogFiles=10, -XX:GCLogFileSize=10M, -Xss1m, -Dfile.encoding=UTF-8, -Djna.nosys=true, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -XX:+UseCompressedOops, -Dcassandra.ignore_corrupted_schema_tables=true, -Dfile.encoding=UTF-8, -Djava.awt.headless=true, -XX:+UseCompressedOops, -Dcassandra.compaction.priority=1, -XX:CompileCommandFile=/opt/td_elassandra/elassandra/conf/hotspot_compiler, -javaagent:/opt/td_elassandra/elassandra/lib/jamm-0.3.0.jar, -Dcassandra.custom_query_handler_class=org.elassandra.index.ElasticQueryHandler, -Xss256k, -Dcassandra.max_queued_native_transport_requests=10240, -Dcassandra.jmx.local.port=7199, -Dcom.sun.management.jmxremote.authenticate=false, -Dcom.sun.management.jmxremote.password.file=/etc/cassandra/jmxremote.password, -Djava.library.path=/opt/td_elassandra/elassandra/lib/sigar-bin, -Dfile.encoding=UTF-8, -Djna.nosys=true, -Djdk.io.permissionsUseCanonicalPath=true, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j.skipJansi=true, -Djava.awt.headless=true, -Dlogback.configurationFile=/opt/td_elassandra/elassandra/conf/logback.xml, -Dcassandra.logdir=/opt/td_elassandra/elassandra/logs, -Dcassandra.storagedir=/opt/td_elassandra/elassandra/data]
2021-06-15 10:59:16,667 INFO [main] NativeLibrary.java:174 tryMlockall JNA mlockall successful
2021-06-15 10:59:16,667 WARN [main] StartupChecks.java:136 execute jemalloc shared library could not be preloaded to speed up memory allocations
2021-06-15 10:59:16,667 WARN [main] StartupChecks.java:169 execute JMX is not enabled to receive remote connections. Please see cassandra-env.sh for more info.
2021-06-15 10:59:16,668 WARN [main] StartupChecks.java:220 checkOutOfMemoryHandling The JVM is not configured to stop on OutOfMemoryError which can cause data corruption. Use one of the following JVM options to configure the behavior on OutOfMemoryError: -XX:+ExitOnOutOfMemoryError, -XX:+CrashOnOutOfMemoryError, or -XX:OnOutOfMemoryError=";"
2021-06-15 10:59:16,669 INFO [main] SigarLibrary.java:44 Initializing SIGAR library
2021-06-15 10:59:16,678 INFO [main] SigarLibrary.java:57 Could not initialize SIGAR library org.hyperic.sigar.Sigar.getFileSystemListNative()[Lorg/hyperic/sigar/FileSystem;
2021-06-15 10:59:16,678 INFO [main] SigarLibrary.java:185 warnIfRunningInDegradedMode Sigar could not be initialized, test for checking degraded mode omitted.
2021-06-15 10:59:16,695 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.keyspaces
2021-06-15 10:59:16,698 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.tables
2021-06-15 10:59:16,701 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.columns
2021-06-15 10:59:16,703 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.triggers
2021-06-15 10:59:16,705 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.dropped_columns
2021-06-15 10:59:16,707 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.views
2021-06-15 10:59:16,709 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.types
2021-06-15 10:59:16,711 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.functions
2021-06-15 10:59:16,713 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.aggregates
2021-06-15 10:59:16,715 INFO [main] ColumnFamilyStore.java:411 Initializing system_schema.indexes
2021-06-15 10:59:16,715 INFO [main] ViewManager.java:137 reload Not submitting build tasks for views in keyspace system_schema as storage service is not initialized
2021-06-15 10:59:17,328 INFO [MemtableFlushWriter:1] CacheService.java:112 initKeyCache Initializing key cache with capacity of 100 MBs.
2021-06-15 10:59:17,343 INFO [MemtableFlushWriter:1] CacheService.java:134 initRowCache Initializing row cache with capacity of 0 MBs
2021-06-15 10:59:17,347 INFO [MemtableFlushWriter:1] CacheService.java:163 initCounterCache Initializing counter cache with capacity of 50 MBs
2021-06-15 10:59:17,349 INFO [MemtableFlushWriter:1] CacheService.java:174 initCounterCache Scheduling counter cache save to every 7200 seconds (going to save all keys).
2021-06-15 10:59:17,752 INFO [ScheduledTasks:1] TokenMetadata.java:498 updateTopology Updating topology for all endpoints that have changed
2021-06-15 10:59:18,197 INFO [CompactionExecutor:2] BufferPool.java:230 Global buffer pool is enabled, when pool is exhausted (max is 128.000MiB) it will allocate on heap
2021-06-15 10:59:19,452 INFO [main] StorageService.java:600 populateTokenMetadata Populating token metadata from system tables
2021-06-15 10:59:19,469 INFO [main] StorageService.java:607 populateTokenMetadata Token metadata:
2021-06-15 10:59:19,474 INFO [main] ElassandraDaemon.java:253 systemKeyspaceInitialized Elasticsearch activation delayed after boostraping, no mapping available
2021-06-15 10:59:19,481 INFO [pool-5-thread-1] AutoSavingCache.java:174 run Completed loading (3 ms; 4 keys) KeyCache cache
2021-06-15 10:59:19,491 INFO [main] CommitLog.java:152 recoverSegmentsOnDisk No commitlog files found; skipping replay
2021-06-15 10:59:19,491 INFO [main] StorageService.java:600 populateTokenMetadata Populating token metadata from system tables
2021-06-15 10:59:19,497 INFO [main] StorageService.java:607 populateTokenMetadata Token metadata:
2021-06-15 10:59:19,544 INFO [main] QueryProcessor.java:163 preloadPreparedStatement Preloaded 0 prepared statements
2021-06-15 10:59:19,544 INFO [main] StorageService.java:618 initServer Cassandra version: 3.11.3
2021-06-15 10:59:19,544 INFO [main] StorageService.java:619 initServer Thrift API version: 20.1.0
2021-06-15 10:59:19,544 INFO [main] StorageService.java:620 initServer CQL supported versions: 3.4.4 (default: 3.4.4)
2021-06-15 10:59:19,544 INFO [main] StorageService.java:622 initServer Native protocol supported versions: 3/v3, 4/v4, 5/v5-beta (default: 4/v4)
2021-06-15 10:59:19,562 INFO [main] IndexSummaryManager.java:85 Initializing index summary manager with a memory pool size of 102 MB and a resize interval of 60 minutes
2021-06-15 10:59:19,566 INFO [main] MessagingService.java:761 getServerSockets Starting Messaging Service on /127.0.0.1:7700 (lo)
2021-06-15 10:59:19,574 INFO [main] StorageService.java:550 checkForEndpointCollision Unable to gossip with any peers but continuing anyway since node is in its own seed list
2021-06-15 10:59:19,579 INFO [main] StorageService.java:704 loadRingState Loading persisted ring state
2021-06-15 10:59:19,580 INFO [main] StorageService.java:822 prepareToJoin Starting up server gossip
2021-06-15 10:59:20,162 INFO [main] StorageService.java:883 joinTokenRing This node will not auto bootstrap because it is configured to be a seed node.
2021-06-15 10:59:20,166 INFO [main] BootStrapper.java:228 getRandomTokens Generated random tokens. tokens are [-2306284434704009459, 1827857312922626824, -2958650105659367408, 7083622328515765894, -8686490372404160124, -8179544281530261641, 1112091501995976733, -3233092270144161409, -5135129667858446890, 7254432729818789701, 7525141904069568188, 4951557265668678299, 3043347575867939268, 4562911647303411588, -8258341883706997917, -448595810828108224, 2326906195911311429, -4857820586212942491, -2003052698157954084, 5119023019275473284, 4432456491162110476, 3691799631603172996, -1329752803208018737, 6602598494151578552, -3376954379410061216, -8391091498593097330, -8845301161801092864, -649459230506122983, -2302459432614433755, -195537704442418046, -6854330798358369162, -2666501983783847445, -5047865019287966863, 6246843571411990237, -138703274471311935, 3407401416328649616, -82855446902849964, -3329381310525458793, 1865709307296119966, 854289002393131492, -4966781917846626663, -8183543197705041841, -5469120734979271128, 7347338937057536987, 6432039819578749958, 2699697561209776480, 1398223356312492576, -313771578909949461, -2589296000053898956, -8754889464525693550, -2091582058249259287, -1720756575615011634, 2710377230861007039, 3999086900838848814, 6905239279622173135, 5998445075643055934, -1812691413861888223, 8928271391287548412, -5196920569887189960, -3383387901934641645, -13923972995053985, 3721692068627554576, 7007194433095243716, 4995426265748257036, -3588137701324323612, -7906824665480936879, -6456133073338695220, 7065787049429238878, -2550336168182260853, 5936840936218091579, 6266552437504291719, 8737761352364008878, -3097067104857139436, -5857280369676322520, -7725334931271714269, 2974186494338624965, -2493603804023593474, -9077088919229815936, 6906308432936316372, 5201983698440365266, 892181016945376638, -6913706246004354593, 3871143317380680296, 2145298811023433889, 334378463847527262, -7676450819059819170, 4619902209839137451, 7204228604563619161, 5113104465073045778, 4760025152928928078, 4997915651837892369, -8001281872781593652, 3656040336593149029, -681737610770671994, -8263927816839974076, 9123091459443188475, -5906781948921166468, 4663325734171574585, 987625634614878473, 5704629784989260319, 1313859649258693203, -3612693794183145905, -3476627419760674810, 2294161995135671934, -9053777687959543702, -2161780301546528, -4376332094324503541, 7162768722274061035, -7927446276387435174, 2437094817723533708, -8311298655921511413, 6229039895832934581, -4273170562106050715, 5084091303201996621, -6960892542468073442, 2013363825763224212, 7094457062598188001, 426228195396082320, -1430936551335273086, 4042523631314505650, -971249105426307375, -4365301552313746883, 2550197851187684327, 361272463285644753, -8897203933434089681, -7166176193576852676, -1414185466357219286, 8355324798100323173, -4401090596550494928, -192719397458987467, -4095473421669371105, 5049682255547949357, 2977551131108698849, 1120405167827281604, -4135496015349161785, -5397192642543897810, -6240140327967539227, -2541083790919343666, -8763314851873679402, 2312342032113824400, 2048151804479029848, -8967278640940478015, 8293607801390890527, 6374809255519223882, -2846719259328442625, -4224184130795932540, 6691463628976969685, 1900616426879628730, -6963942733555626293, 8917150203967867000, 7191073002280384255, 5871483541264347386, 7061017307861736162, 1872576286994033635, 2414075884906371367, 2125050466698367806, -4119880140542300936, -8829638321107757120, -5371774493616991817, 4419849825235109470, 5775955063393862110, 7459221035455744437, 5815470551951536267, -2578658803160256843, 5044034525650612179, -3630539883908649126, -6074963686993806049, -4512891656198706545, -413955776999371958, -23048617318607426, -5948279945725095282, -3350805702255543207, 68710534484619270, 4090200140538973675, 6668314714274931156, 489849279939898555, -2553876296937740717, -668172828359177058, -1259994817859982828, -8377575564162092391, -3651625900209966346, -8996182840379451485, 5948308000704090090, -3071928579161103188, -5406834884079831323, 6663496385613591345, -2736594610740758974, -9146019490042028818, -3318074669404726326, 4204824998079354909, -5288866638548515117, -2651453312311303121, 3745138026301929408, -341759118321607019, 313942287068001707, -8596423864865919805, -5663411436901215945, 2198066156202954697, 1017292766287533779, 590289206634405229, -5299666181618824155, -2694596004925704426, -1732907482064604350, 7488908259621308969, -8786183182772802014, -6192858384856991796, -963312719308303073, 4244327956008673940, 3264610636497344172, 7171472929920455310, 8266697674687582687, 2827124267200667720, 3226597550354828341, 423468579842366748, -980297224670618092, -900780087865495645, 50801435702608297, 2984259233905708957, -1790190108171890968, -7117625496436491930, -3550183081935976485, -2316198997233581593, 5401589464281001799, 6232559521280463740, 6596335632908738746, -6419050414462619553, -1919449487636761305, 6380369852005049336, 2872787351730288031, -8087459445998707289, -8576443213526333926, -9078926939070073656, -2255291717502133697, 6226496838114527400, 7468310156806599189, -809057641658037404, -5903393920927942488, 5212442804667345582, 406997831061746924, -1689142628393578121, -7512884207811847813, 3057139931140243805, 1049387173508875709, -5850373773476796531, 4883407892834042883, 7567240508735890153, 7720171002096504170, -4632426910272061606, -1581289074033548532, -8367510314410146675, 2444775140361807588, 3185668026540794804, -8943143262773553543, 7287439997405174144, -1582755864606340639, -4577451334100824177]
2021-06-15 10:59:20,167 INFO [main] ElassandraDaemon.java:339 ringReady waiting 30000ms for CQL schema to get the elasticsearch mapping
2021-06-15 10:59:50,172 WARN [main] ElassandraDaemon.java:361 ringReady Failed to load elasticsearch mapping from CQL schema after after joining without boostraping:
org.elassandra.NoPersistedMetaDataException: Failed to read comment from elastic_admin+metadata
at org.elasticsearch.cluster.service.ClusterService.readMetaDataAsComment(ClusterService.java:2416)
at org.apache.cassandra.service.ElassandraDaemon.ringReady(ElassandraDaemon.java:358)
at org.apache.cassandra.service.StorageService.joinTokenRing(StorageService.java:995)
at org.apache.cassandra.service.StorageService.initServer(StorageService.java:679)
at org.apache.cassandra.service.StorageService.initServer(StorageService.java:613)
at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:387)
at org.apache.cassandra.service.ElassandraDaemon.activate(ElassandraDaemon.java:224)
at org.apache.cassandra.service.ElassandraDaemon.main(ElassandraDaemon.java:554)
2021-06-15 10:59:50,173 INFO [main] ElassandraDaemon.java:372 activateAndWaitShards Activating Elasticsearch, shards starting with empty elasticsearch mapping
2021-06-15 10:59:50,282 INFO [elasticsearch[127.0.0.1][masterService#updateTask][T#1]] CassandraGatewayService.java:143 clusterStateProcessed Recovered [0] indices into cluster_state metadata=3490f371-a327-443d-87a4-00d1542005b9/0
2021-06-15 10:59:50,283 INFO [main] ElassandraDaemon.java:376 activateAndWaitShards Elasticsearch shards started, ready to go on.

elasticsearch cluster state (curl http://localhost:9200/_cluster/state)
curl http://localhost:9200/_cluster/state?pretty
{
"cluster_name" : "TiandyCluster",
"compressed_size_in_bytes" : 208,
"version" : 4,
"state_uuid" : "G43NI0AlQUS74nSPopUuSw",
"master_node" : "3490f371-a327-443d-87a4-00d1542005b9",
"blocks" : { },
"nodes" : {
"3490f371-a327-443d-87a4-00d1542005b9" : {
"name" : "127.0.0.1",
"status" : "ALIVE",
"ephemeral_id" : "3490f371-a327-443d-87a4-00d1542005b9",
"transport_address" : "127.0.0.1:9300",
"attributes" : {
"rack" : "r1",
"dc" : "DC1"
}
}
},
"metadata" : {
"version" : 0,
"cluster_uuid" : "3490f371-a327-443d-87a4-00d1542005b9",
"templates" : { },
"indices" : { },
"index-graveyard" : {
"tombstones" : [ ]
}
},
"routing_table" : {
"indices" : { }
},
"routing_nodes" : {
"unassigned" : [ ],
"nodes" : {
"3490f371-a327-443d-87a4-00d1542005b9" : [ ]
}
},
"snapshot_deletions" : {
"snapshot_deletions" : [ ]
},
"snapshots" : {
"snapshots" : [ ]
},
"restore" : {
"snapshots" : [ ]
}
}
cassandra schema (cqlsh>DESC KEYSPACE <your_keyspace>)

tab_passenger_flow_access_record videosliceinfo
fileinfo deckedmotorvehicle
tab_device_user videolabel
system_auth sceneinfo
geo_gps nonmotorvehicle
statistic system_traces
tab_ruijie_call_history tab_access_record
subscribenotification wifiusersdata
vehiclemotorvehicle vehiclenonmotorvehicle
tab_log_info case
tab_ruijie_unlock_history tab_access_down_task_detail
imageinfo tab_visitor_historical_record_details
person vehicledispositionnotification
illegal tab_alarm_info
system tab_visitor_historical_record
motorvehicle face
system_distributed vehicleillegal
thinginfo tab_job_runlog
pagecache elastic_admin
dispositionnotification geo_resource
tab_alert_info carflow
wifidata mobileinfo
system_schema tab_alarm_picture

cassandra gossip state (run: nodetool gossipinfo)
/127.0.0.1
generation:1623730853
heartbeat:636387
STATUS:16:NORMAL,-1259994817859982828
LOAD:636332:7.56799923E8
SCHEMA:12:ec929802-c012-3e54-b08d-6b4c9f39db0a
DC:8:DC1
RACK:10:r1
RELEASE_VERSION:4:3.11.3
INTERNAL_IP:6:127.0.0.1
RPC_ADDRESS:3:127.0.0.1
NET_VERSION:1:11
HOST_ID:2:3490f371-a327-443d-87a4-00d1542005b9
RPC_READY:18:true
X1:20:{}
X2:22:3490f371-a327-443d-87a4-00d1542005b9/0
TOKENS:15: