Username and password provided but auth provider not specified, inferring PlainTextAuthProvider
DataStax Bulk Loader v1.7.0 starting.
DataStax Java driver for Apache Cassandra(R) (com.datastax.oss:java-driver-core) version 4.7.2
Available processors: 4.
Operation directory: /root/logs/COUNT_20201020-160725-796900
DataStax Bulk Loader Effective settings:
- batch.bufferSize = -1
- batch.maxBatchStatements = 32
- batch.maxSizeInBytes = -1
- batch.mode = "PARTITION_KEY"
- codec.binary = "BASE64"
- codec.booleanNumbers = [1,0]
- codec.booleanStrings = ["1:0","Y:N","T:F","YES:NO","TRUE:FALSE"]
- codec.date = "ISO_LOCAL_DATE"
- codec.epoch = "1970-01-01T00:00:00Z"
- codec.formatNumbers = false
- codec.locale = "en_US"
- codec.nullStrings = []
- codec.number = "#,###.##"
- codec.overflowStrategy = "REJECT"
- codec.roundingStrategy = "UNNECESSARY"
- codec.time = "ISO_LOCAL_TIME"
- codec.timeZone = "UTC"
- codec.timestamp = "CQL_TIMESTAMP"
- codec.unit = "MILLISECONDS"
- codec.uuidStrategy = "RANDOM"
- engine.dataSizeSamplingEnabled = true
- engine.dryRun = false
- engine.maxConcurrentQueries = "AUTO"
- executor.continuousPaging.enabled = true
- executor.continuousPaging.maxConcurrentQueries = 60
- executor.continuousPaging.maxPages = 0
- executor.continuousPaging.maxPagesPerSecond = 0
- executor.continuousPaging.pageSize = 5000
- executor.continuousPaging.pageUnit = "ROWS"
- executor.maxInFlight = -1
- executor.maxPerSecond = -1
- log.ansiMode = "normal"
- log.directory = "./logs"
- log.maxErrors = 100
- log.maxQueryWarnings = 50
- log.row.maxResultSetValueLength = 50
- log.row.maxResultSetValues = 50
- log.sources = true
- log.stmt.level = "EXTENDED"
- log.stmt.maxBoundValueLength = 50
- log.stmt.maxBoundValues = 50
- log.stmt.maxInnerStatements = 10
- log.stmt.maxQueryStringLength = 500
- log.verbosity = 2
- monitoring.console = true
- monitoring.csv = false
- monitoring.durationUnit = "MILLISECONDS"
- monitoring.expectedReads = -1
- monitoring.expectedWrites = -1
- monitoring.jmx = true
- monitoring.rateUnit = "SECONDS"
- monitoring.reportRate = "5 seconds"
- monitoring.trackBytes = false
- runner.promptForPasswords = true
- schema.allowExtraFields = true
- schema.allowMissingFields = false
- schema.keyspace = "qausagcpcommon_channels"
- schema.nullToUnset = true
- schema.queryTtl = -1
- schema.splits = "8C"
- schema.table = "comment_by_commented_id"
- stats.modes = ["global"]
- stats.numPartitions = 10
DataStax Java Driver Effective settings:
- basic.config-reload-interval = 0
- basic.contact-points = ["10.15.25.2:9042","10.15.25.3:9042","10.15.25.4:9042"]
- basic.default-port = 9042
- basic.graph.traversal-source = "g"
- basic.load-balancing-policy.class = "com.datastax.oss.driver.internal.core.loadbalancing.DcInferringLoadBalancingPolicy"
- basic.load-balancing-policy.filter.allow = []
- basic.load-balancing-policy.filter.class = "com.datastax.oss.dsbulk.workflow.commons.policies.lbp.SimpleNodeFilter"
- basic.load-balancing-policy.filter.deny = []
- basic.load-balancing-policy.slow-replica-avoidance = true
- basic.request.consistency = "LOCAL_ONE"
- basic.request.default-idempotence = true
- basic.request.page-size = 5000
- basic.request.serial-consistency = "LOCAL_SERIAL"
- basic.request.timeout = "5 minutes"
- basic.session-name = "driver"
- advanced.address-translator.class = "PassThroughAddressTranslator"
- advanced.auth-provider.class = "PlainTextAuthProvider"
- advanced.auth-provider.password = ***************
- advanced.auth-provider.username = "cassandra"
- advanced.coalescer.reschedule-interval = "10 microseconds"
- advanced.connection.connect-timeout = "30 seconds"
- advanced.connection.init-query-timeout = 300000
- advanced.connection.max-orphan-requests = 256
- advanced.connection.max-requests-per-connection = 32768
- advanced.connection.pool.local.size = 8
- advanced.connection.pool.remote.size = 8
- advanced.connection.set-keyspace-timeout = 300000
- advanced.connection.warn-on-init-error = true
- advanced.continuous-paging.max-enqueued-pages = 4
- advanced.continuous-paging.max-pages = 0
- advanced.continuous-paging.max-pages-per-second = 0
- advanced.continuous-paging.page-size = 5000
- advanced.continuous-paging.page-size-in-bytes = false
- advanced.continuous-paging.timeout.first-page = "5 minutes"
- advanced.continuous-paging.timeout.other-pages = "5 minutes"
- advanced.control-connection.schema-agreement.interval = "200 milliseconds"
- advanced.control-connection.schema-agreement.timeout = "10 seconds"
- advanced.control-connection.schema-agreement.warn-on-failure = true
- advanced.control-connection.timeout = 300000
- advanced.graph.paging-enabled = "AUTO"
- advanced.graph.paging-options.max-enqueued-pages = 4
- advanced.graph.paging-options.max-pages = 0
- advanced.graph.paging-options.max-pages-per-second = 0
- advanced.graph.paging-options.page-size = 5000
- advanced.heartbeat.interval = "1 minute"
- advanced.heartbeat.timeout = "1 minute"
- advanced.metadata.schema.debouncer.max-events = 20
- advanced.metadata.schema.debouncer.window = "1 second"
- advanced.metadata.schema.enabled = true
- advanced.metadata.schema.request-page-size = 5000
- advanced.metadata.schema.request-timeout = "5 minutes"
- advanced.metadata.token-map.enabled = true
- advanced.metadata.topology-event-debouncer.max-events = 20
- advanced.metadata.topology-event-debouncer.window = "1 second"
- advanced.metrics.node.cql-messages.highest-latency = "3 seconds"
- advanced.metrics.node.cql-messages.refresh-interval = "5 minutes"
- advanced.metrics.node.cql-messages.significant-digits = 3
- advanced.metrics.node.enabled = []
- advanced.metrics.node.graph-messages.highest-latency = "3 seconds"
- advanced.metrics.node.graph-messages.refresh-interval = "5 minutes"
- advanced.metrics.node.graph-messages.significant-digits = 3
- advanced.metrics.session.continuous-cql-requests.highest-latency = "120 seconds"
- advanced.metrics.session.continuous-cql-requests.refresh-interval = "5 minutes"
- advanced.metrics.session.continuous-cql-requests.significant-digits = 3
- advanced.metrics.session.cql-requests.highest-latency = "3 seconds"
- advanced.metrics.session.cql-requests.refresh-interval = "5 minutes"
- advanced.metrics.session.cql-requests.significant-digits = 3
- advanced.metrics.session.enabled = []
- advanced.metrics.session.graph-requests.highest-latency = "12 seconds"
- advanced.metrics.session.graph-requests.refresh-interval = "5 minutes"
- advanced.metrics.session.graph-requests.significant-digits = 3
- advanced.metrics.session.throttling.delay.highest-latency = "3 seconds"
- advanced.metrics.session.throttling.delay.refresh-interval = "5 minutes"
- advanced.metrics.session.throttling.delay.significant-digits = 3
- advanced.monitor-reporting.enabled = true
- advanced.netty.admin-group.shutdown.quiet-period = 2
- advanced.netty.admin-group.shutdown.timeout = 15
- advanced.netty.admin-group.shutdown.unit = "SECONDS"
- advanced.netty.admin-group.size = 2
- advanced.netty.daemon = false
- advanced.netty.io-group.shutdown.quiet-period = 2
- advanced.netty.io-group.shutdown.timeout = 15
- advanced.netty.io-group.shutdown.unit = "SECONDS"
- advanced.netty.io-group.size = 0
- advanced.netty.timer.tick-duration = "100 milliseconds"
- advanced.netty.timer.ticks-per-wheel = 2048
- advanced.node-state-listener.class = "NoopNodeStateListener"
- advanced.prepared-statements.prepare-on-all-nodes = true
- advanced.prepared-statements.reprepare-on-up.check-system-table = false
- advanced.prepared-statements.reprepare-on-up.enabled = true
- advanced.prepared-statements.reprepare-on-up.max-parallelism = 100
- advanced.prepared-statements.reprepare-on-up.max-statements = 0
- advanced.prepared-statements.reprepare-on-up.timeout = "30 seconds"
- advanced.protocol.compression = "none"
- advanced.protocol.max-frame-length = "256 MiB"
- advanced.reconnect-on-init = false
- advanced.reconnection-policy.base-delay = "1 second"
- advanced.reconnection-policy.class = "ExponentialReconnectionPolicy"
- advanced.reconnection-policy.max-delay = "60 seconds"
- advanced.request-tracker.class = "NoopRequestTracker"
- advanced.request.log-warnings = false
- advanced.request.trace.attempts = 5
- advanced.request.trace.consistency = "ONE"
- advanced.request.trace.interval = "3 milliseconds"
- advanced.request.warn-if-set-keyspace = false
- advanced.resolve-contact-points = true
- advanced.retry-policy.class = "com.datastax.oss.dsbulk.workflow.commons.policies.retry.MultipleRetryPolicy"
- advanced.retry-policy.max-retries = 10
- advanced.schema-change-listener.class = "NoopSchemaChangeListener"
- advanced.session-leak.threshold = 4
- advanced.socket.tcp-no-delay = true
- advanced.speculative-execution-policy.class = "NoSpeculativeExecutionPolicy"
- advanced.ssl-engine-factory.hostname-validation = true
- advanced.throttler.class = "PassThroughRequestThrottler"
- advanced.timestamp-generator.class = "AtomicTimestampGenerator"
- advanced.timestamp-generator.drift-warning.interval = "10 seconds"
- advanced.timestamp-generator.drift-warning.threshold = "1 second"
- advanced.timestamp-generator.force-java-clock = false
Could not register Graph extensions; this is normal if Tinkerpop was explicitly excluded from classpath
Using native clock for microsecond precision
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver|default] Inferred local DC from contact points: dc1
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.3:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.4:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
[driver] /10.15.25.2:9042 did not send an authentication challenge; This is suspicious because the driver expects authentication
Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
Total number of nodes: 3
DataCenters: [dc1]
Nodes:
address: lab-usa-dse-node-3.c.workjam-development.internal/10.15.25.2:9042, dseVersion: 6.8.3, cassandraVersion: 4.0.0.683, dataCenter: dc1
address: lab-usa-dse-node-2.c.workjam-development.internal/10.15.25.3:9042, dseVersion: 6.8.3, cassandraVersion: 4.0.0.683, dataCenter: dc1
address: lab-usa-dse-node-1.c.workjam-development.internal/10.15.25.4:9042, dseVersion: 6.8.3, cassandraVersion: 4.0.0.683, dataCenter: dc1
Inferred query: SELECT commented_id FROM keyspace.table WHERE token(commented_id) > :start AND token(commented_id) <= :end
Generated 33 bound statements
Using read concurrency: 4 (user-supplied: false)
Operation COUNT_20201020-160725-796900 started.
total | failed | rows/s | p50ms | p99ms | p999ms
1,010 |      0 |  1,592 |  7.86 | 30.67 |  30.67
Operation COUNT_20201020-160725-796900 completed successfully in less than one second.
Operation COUNT_20201020-160725-796900 closing.