Warning Message after successful insert

Hi,

I have a 3 node cockroach cluster running on 3 vms in secure mode. These are the environment variable I use to run each node


COCKROACH_CA_CERT=/export/home/younglee/certs/ca.cert
COCKROACH_CERT=/export/home/younglee/certs/sl73commapd002.cert
COCKROACH_HOST=sl73commapd002.visa.com
COCKROACH_PORT=9080 

I am inserting records into the table below from an external CSV file with the following command

\| IFS=","; sed -e '1d' -e 's/"//g' DMPD_API_Latency_092316.csv | while read caller component mthd u count min median avg perc90 perc95 perc96 perc97 perc98 perc99 max; do echo "insert into api (date, caller, component, method, url, count, min, median, perc90, perc95, perc96, perc97, perc98, perc99, max) values (TIMESTAMP '2016-09-23', '$caller', '$component', '$mthd', '$u', $count, $min, $median, $perc90, $perc95, $perc96, $perc97, $perc98, $perc99, $max);"; done`


This is the table definition


    root@sl73commapd002.visa.com:9080> show columns from api;
    +-----------+-----------+-------+----------------+
    |   Field   |   Type    | Null  |    Default     |
    +-----------+-----------+-------+----------------+
    | id        | INT       | false | unique_rowid() |
    | date      | TIMESTAMP | true  | NULL           |
    | caller    | STRING    | true  | NULL           |
    | component | STRING    | true  | NULL           |
    | method    | STRING    | true  | NULL           |
    | url       | STRING    | true  | NULL           |
    | count     | INT       | true  | NULL           |
    | min       | INT       | true  | NULL           |
    | median    | INT       | true  | NULL           |
    | perc90    | INT       | true  | NULL           |
    | perc95    | INT       | true  | NULL           |
    | perc96    | INT       | true  | NULL           |
    | perc97    | INT       | true  | NULL           |
    | perc98    | INT       | true  | NULL           |
    | perc99    | INT       | true  | NULL           |
    | max       | INT       | true  | NULL           |
    +-----------+-----------+-------+----------------+

I am getting the following log messages from the cockroach.WARN log file. What should I do to not get these types of warning messages? Is this serious?

The records are inserted properly and I can query and access all the records just fine.


    W160924 11:09:08.949589 1143960 kv/dist_sender.go:695  [n1] 1 retries for an RPC at sequence 4, last error was: <nil>, remaining key ranges {"/Table/3/1/1/2/1" "/Table/3/1/1/2/1/NULL"}: [txn: 2156cc5b], Get [/Table/3/1/1/2/1,/Min)
    W160924 11:09:08.961362 1143960 kv/dist_sender.go:695  [n1] 1 retries for an RPC at sequence 4, last error was: <nil>, remaining key ranges {"/Table/2/1/1/\"lease\"/3/1" "/Table/2/1/1/\"lease\"/3/1/NULL"}: [txn: 346ce56b], Get [/Table/2/1/1/"lease"/3/1,/Min)

Hi,

this warning isn’t serious and in fact has been removed in newer builds. I recommend upgrading to the beta version that is going to be released this coming week - it contains a fix for this.

Sorry about the inconvenience!

Tobias