by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Apr 15 2019 18:14
    vivekmenezes closed #36840
  • Apr 15 2019 18:14
    vivekmenezes commented #36840
  • Apr 15 2019 18:13
    cockroach-teamcity commented #36848
  • Apr 15 2019 18:13
    vivekmenezes review_requested #36848
  • Apr 15 2019 18:13
    vivekmenezes review_requested #36848
  • Apr 15 2019 18:13
    vivekmenezes opened #36848
  • Apr 15 2019 18:10

    craig[bot] on staging.tmp

    (compare)

  • Apr 15 2019 18:10

    craig[bot] on staging

    exec/colserde: add arrow format… Merge #36578 36578: exec/colse… (compare)

  • Apr 15 2019 18:10

    craig[bot] on staging.tmp

    exec/colserde: add arrow format… [ci skip] -bors-staging-tmp-365… (compare)

  • Apr 15 2019 18:10

    craig[bot] on staging.tmp

    [ci skip] (compare)

  • Apr 15 2019 18:10
    asubiotto commented #36578
  • Apr 15 2019 18:09
    craig[bot] closed #36844
  • Apr 15 2019 18:09
    craig[bot] closed #36643
  • Apr 15 2019 18:09
    craig[bot] closed #36838
  • Apr 15 2019 18:09
    craig[bot] closed #36817
  • Apr 15 2019 18:08
    craig[bot] commented #36844
  • Apr 15 2019 18:08
    craig[bot] commented #36838
  • Apr 15 2019 18:08

    craig[bot] on master

    roachprod: distributed authoriz… changefeedccl: deflake TestChan… workload,workloadccl: standardi… and 3 more (compare)

  • Apr 15 2019 18:08
    craig[bot] commented #36817
  • Apr 15 2019 17:52
    ajwerner edited #36838
Nathan VanBenschoten
@nvanbenschoten
@swinSpo we've taken the stance that we'd like to avoid publishing benchmark results for other databases, as it's dangerously easy to misrepresent others and come across as disingenuous. https://medium.com/@PingCAP/why-benchmarking-distributed-databases-is-so-hard-2765a26cc2bf provides a good perspective on why this is so hard.
Nathan VanBenschoten
@nvanbenschoten
We've also favored publishing benchmark results for transactional benchmarks like TPC-C in the past because those are closer to the workloads users of CockroachDB actually run, but these are even harder to tune properly across different databases. That said, we recognize that there is a use for "microbenchmark" style benchmarks running non-transactional workloads like sysbench. We've been building out https://www.cockroachlabs.com/docs/dev/performance.html to provide information about how CockroachDB performs both on transactional and non-transactional workloads, with a focus on using industry-standard benchmarks.
Nathan VanBenschoten
@nvanbenschoten
Reproduction steps for all results published there are coming in the next few weeks.
lsraj
@lsraj
I have table in CRDB with key-value pair (value is JSONB). If I add new fields into JSONB, is there a tool to migrate from older to newer JSONB? Also if I change the table names, how do I migrate ? Thanks.
Kelly Sommers
@kellabyte
is it possible to implement a CAS operation with CockroachDB?
Ben Darnell
@bdarnell
@kellabyte I don't think there's a one-statement way to get compare-and-swap (cockroachdb/cockroach#28956). You can do it with multiple statements in a transaction (which will have the correct semantics but maybe not the performance you're looking for). Slightly weaker forms like compare-and-set are doable with an UPDATE statement
Kelly Sommers
@kellabyte
@bdarnell I think that is good enough, I'm trying to understand what our current thing is doing so that I can try to understand how to make it work in CRDB
István Soós
@isoos
@kellabyte: you can have a simple tracking column for incremental data version, and then UPDATE table SET value=123, version=2 WHERE version=1 AND id=234;?
Kelly Sommers
@kellabyte
@isoos if I already have a field I know I can check I can avoid the version column right?
István Soós
@isoos
@kellabyte yeah, sure, but you probably want to mutate that field to prevent concurrent updates overriding each other.
mert
@volknanebo
hi
when i'm doing clustering , my QPS falling down so fast
from thousands to hundreds
almost 10x
mert
@volknanebo
sh-3.2# cockroach gen haproxy --host=127.0.0.1:26257 --certs-dir=./certs/clientkey
Error: initial connection heartbeat failed: rpc error: code = Unknown desc = version compatibility check failed on ping request: cluster requires at least version 19.1, but peer has version 2.1
Failed running "gen haproxy"
HashtagGo
@HashtagGo
hi
I'm using docker-compose in Development and also in Product . if i want to do query (get data from cockroachdb) through docker . How to do this ?
Thanks in Advance
version: '3'
services:
  cockroachdb:
    container_name: cockroachdb
    image: cockroachdb/cockroach:v2.1.6
    command: start --insecure --store=attrs=ssd,path=/var/lib/cockroach/
    restart: always
    volumes:
      - data:/var/lib/cockroach
    expose:
      - "8080"
      - "26257"
    ports:
      - "26257:26257"
      - "8080:8080"
Jordan Lewis
@jordanlewis

Gitter folks! Thank you all so much for participating in this community with us. We really value the ability to chat back and forth about CockroachDB and related topics - which is why we’re inviting all of you to join our CockroachDB Community Slack workspace. Our hope is that Slack will be a better environment for growing this community to reach more people and answer more questions. We’re inviting you before we announce the Slack channel to the general public so that you can get in early and grab your prefered user name. Here is the link: https://join.slack.com/t/cockroachdb/shared_invite/enQtODE2MjY0MDA3OTIxLTQxNWNlOTAzYTlkOTdlZTljMzM4ZTZjMjU5ODcyZjUzYzIyMzIzMjZkY2ZmOWU0OTBkYmNlMjc4YTg5NzE3YTQWe

We will be deprecating our Gitter on November 20th, so please jump into Slack before then. Thanks for everything and we’ll see you in Slack!

Kelly Sommers
@kellabyte
@jordanlewis: is that invite link working? slack says it’s expired
it also says you need a cockroach labs email address
Kelly Sommers
@kellabyte
I want to join the slack!
Jordan Lewis
@jordanlewis
Hmm! That's not good...
Kelly Sommers
@kellabyte
trying!
yup that worked!
would you be able to enable the irccloud integration option to please? a lot of people use this to consolidate all their slacks and gitters and irc channels into one interface. it works great with slack
I keep all my slacks in one place using irccloud
Jordan Lewis
@jordanlewis
we did enable irccloud - is it not working for you?
HashtagGo
@HashtagGo
how to multiple nodes of cockraoch db through docker-compose and how to join them
Jordan Lewis
@jordanlewis

Check out our Slack instance: This Gitter will be deprecated on November 20th. Thanks!

https://cockroa.ch/slack

chris
@cgebe
Hey guys, i got a master failure on one of our kubernetes clusters where a crdb cluster with some secondary data ran, unfortunately we are unable to recover the master, therefore i am asking if it possible to recover the crdb cluster somehow? e.g. extract the data directly from filesystem?
kena
@knz
@cgebe: I don't understand the question
what did you lose? if you have all the files you can simply restart the crdb node
chris
@cgebe
yeah, i migrated the crdb cluster, everything works fine with new certificates. Anyway, i try to cockroach dump the tables now, however i get Error: pq: communication error: rpc error: code = Canceled desc = context canceled after a while. Is there an additional parameter to set for large tables despite gc.ttlseconds? (The version is v19.1.5)
Endre Karlson
@ekarlso
Is CRDB not free anymore as in opensource ?
James Rasell
@jrasell
Andrei Matei
@andreimatei
the BSL license that newer crdb versions use is not technically open source according to the Open Source Initiative certifications. However, it is extremely permissive.
Kev Jackson
@foamdino
good morning - I have a question concerning this --join=<node1 address>,<node2 address>,<node3 address> in the example systemd unit file
is it possible to avoid hardcoded addresses here and instead use service discovery (we are using Consul)
HashtagGo
@HashtagGo

Scenerio
I have made a live multiplayer game. It is using CockroachDB. There are some already registered users with their default values in Profile meta data.(which accepts jsonB)
I have added some new data field for every new user getting registered from now on.

PROBLEM
I want to add these newly created data fields for the users that are already registered

Nopcea Flavius
@domnulnopcea
hello! when are you going to release version 2020.1?
any planned dates?
Bo Maryniuk
@isbm
Guys, I just followed secure manual and I never can shutdown my cluster that all three nodes quit. Always last node times out.
What I am doing wrong?
I mean, this doesn't work as described: https://www.cockroachlabs.com/docs/v19.2/secure-a-cluster.html
Gvpalem
@Gvpalem
Hello, would like to know the pricing model for cockroachdb
Jesse Seldess
@jseldess

HI @isbm, I think that's expected. There's a note on that page that mentions that the final nodes will take longer to shut down because the cluster has lost consensus:

For nodes 4 and 5, the shutdown process will take longer (about a minute each) and will eventually force the nodes to stop. This is because, with only 2 of 5 nodes left, a majority of replicas are not available, and so the cluster is no longer operational.

@isbm and @Gvpalem, this channel has been deprecated. Please use our public Slack instead: https://cockroa.ch/slack

Jason Knight
@00jknight_gitlab
How do ya'll browse your cockroach database? I tried pgAdmin, but it doesnt seem to work.
Jeffrey Spies
@JeffSpies
@00jknight_gitlab I like dbeaver.io (community edition; free). See https://www.cockroachlabs.com/docs/stable/dbeaver.html for an overview.