How to check Scylla version thru cqlsh - need it for handling Scylla bugs and workarounds

[rkgit833@earthlink.net]

Hi,

There are sometimes little bugs at specific Scylla versions. I need to test for the version in my code from from golang cql driver. If it is a specific version then I would use a specific workaround until the fix is available. My code needs to be dynamic because it runs against several databases, which can be at different Scylla versions.

I tried 'select release_version from system.local'   This has worked until now because I needed to know the difference between 1.7 and 2.0. But now I need to know the difference between 2.x.y and 2.x.y+1. But this is no longer sufficient. There weren't any changes in the system.local row between 2.0 thru 2.2.

Is there some other table I can check?

Thanks

[Tomer Sandler]

Can you share which specific bug/s you are referring to? 

scylla --version will show you the version you are using. 

FYI, versions older that 2.1 are no longer supported. Latest version is 2.2 and 2.3 is around the corner. 

--
Tomer Sandler
ScyllaDB

(Sent from my android)

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-user...@googlegroups.com.
To post to this group, send email to scyllad...@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/1d7d2a9b-69d6-4876-90c9-1274debfb9e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[rkgit833@earthlink.net]

I have one bug that has been fixed and will be 2.3.0. The fix went in last week. It has to do with trying to update a static list element. It didn't work at all from 2.x on.

I know the other versions are no longer supported. But I don't have a choice, the versions of the databases are not under my control. So I need to be able to dynamically determine the version thru cql driver. I don't have access to the Scylla nodes directly.

From querying in the scylla version I can workaround the bugs, often in less efficient ways, until the database has been upgraded to the fix level I need.

Rich

[Dor Laor]

It makes sense to have an API for it. Amnon, does our RESTapi returns the exact version?

--

You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-user...@googlegroups.com.
To post to this group, send email to scyllad...@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/f46ad0f3-c2a6-408d-b46a-d09e0432ef67%40googlegroups.com.

[Tzach Livyatan]

There is a REST API for Scylla version. Try the following from the Scylla node:

curl localhost:10000/storage_service/scylla_release_version

Note that the REST API is bound to localhost IP by default, not accessible from a remote machine.

On Thu, Sep 6, 2018 at 7:13 PM, Dor Laor <d...@scylladb.com> wrote:

It makes sense to have an API for it. Amnon, does our RESTapi returns the exact version?

On Thu, Sep 6, 2018 at 8:29 AM <rkgi...@earthlink.net> wrote:

I have one bug that has been fixed and will be 2.3.0. The fix went in last week. It has to do with trying to update a static list element. It didn't work at all from 2.x on.

I know the other versions are no longer supported. But I don't have a choice, the versions of the databases are not under my control. So I need to be able to dynamically determine the version thru cql driver. I don't have access to the Scylla nodes directly.

From querying in the scylla version I can workaround the bugs, often in less efficient ways, until the database has been upgraded to the fix level I need.

Rich

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.

Visit this group at https://groups.google.com/group/scylladb-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/f46ad0f3-c2a6-408d-b46a-d09e0432ef67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.

Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/CAKUaUn7p78Fhw%2B5o%3DPoU%2BNeZyQ-w2Ts0pjtUeniYaS_D7ptM%2Bw%40mail.gmail.com.

[rkgit833@earthlink.net]

Unfortunately that won't help me.  I have no access to the internal servers. I only have standard remote access.

[Asias He]

On Fri, Sep 7, 2018 at 6:22 AM, <rkgi...@earthlink.net> wrote:

Unfortunately that won't help me.  I have no access to the internal servers. I only have standard remote access.

In case you can modify the config file.

Modify

api_address: remote_ip_address

in conf/scylla.yaml.

 

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/1c9a07fd-6b2e-42c4-9da0-02e1b65cc2e0%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Asias

[Glauber Costa]

On Thu, Sep 6, 2018 at 8:09 PM, Asias He <as...@scylladb.com> wrote:

On Fri, Sep 7, 2018 at 6:22 AM, <rkgi...@earthlink.net> wrote:

Unfortunately that won't help me.  I have no access to the internal servers. I only have standard remote access.

In case you can modify the config file.

Modify

api_address: remote_ip_address

in conf/scylla.yaml.

For what is worth, I don't see a reason for us not to export the version string in system.local

Avi / Duarte / Tomek - Any objections ?

It wouldn't help our friend now, but it can help with version checks in the future.

 

 

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.

To post to this group, send email to scyllad...@googlegroups.com.

Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/1c9a07fd-6b2e-42c4-9da0-02e1b65cc2e0%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Asias

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/CAO1GqFYCHFiUW%3DxExUj5yZvLvdXysL0Mt%3DZnz-1Gr48DYcKpVw%40mail.gmail.com.