AWS keyspaces #40
Comments
|
I think somehow the Consistency level setting is not being honored somewhere inside the driver, any help is much appreciated. |
|
Yep, @skaravad ...that doesn't surprise me. The Simba driver is supported by DataStax. I'm pretty certain they aren't concerned about Cassandra on AWS. Sure would be cool if someone build a JDBC driver that worked with all of those cloud providers! Ha! I'm going to keep this open and see what we can do on our end to resolve this. Thank you! |
|
Hi, @skaravad . If you have any friends at AWS that work on their Managed Cassandra, we'd love to chat with them! |
|
@r2liquibase , unfortunately no, but let me check with my dev team, we have aws support contract , may be we can explore the option, not sure if support folks can do something, but will check. |
|
Yeah, let's talk about that. Would love to chat about this. I'm hitting a wall at AWS Cassandra. Which is odd cause the AWS Redshift have partnered directly with us. Hit us up at liquibase.com and let's loop in the solution architects to help us. |
|
What would be helpful is talking to your AWS Sales person, not the support people at AWS. |
|
@skaravad can you provide the original .sql file? Thanks! |
|
Hi, @skaravad ! We've connected to the AWS Keyspaces team and got some direction on how to fix this. We need to wait on the table creation so we added some logic validate tables are ACTIVE and not just CREATING before working with them. This was needed especially for the Liquibase meta tables. Expected an update on this soon! |
|
Thank you @r2liquibase , do you still need the SQL file ? I've reached out to my dev teams to see if we can share , but we might need to sanitize it a bit. |
|
Sure! @skaravad ! Put it in a gist and put the link here. Thanks! |
|
Hey, @skaravad , this might help: https://github.com/liquibase/liquibase-cassandra/releases/tag/liquibase-cassandra-4.3.2.1-beta. We got some great help from our friends at AWS for the connection information. There is some code that overrides some behavior from the Simba Cassandra driver. Also, Keyspaces doesn't immediately apply DDL changes. So, we had to put in a check to see if the Liquibase meta tables are created before accessing them. Please let us know your thoughts! Would love to have feedback so we can continue to improve this and release. |
|
Fixed in 4.3.2.1. Please review and provide feedback. Thanks! |
|
Hi I checked 4.3.2.1-beta, but not sure if it is in current versions yet? Anyway, checking the code I can see attempts were made to wait for and ensure tables are created, but altering tables and dropping tables are not immediate either, which I believe isn't checked currently. Our use case is that sometimes we have to drop an entire table and recreate it, and of course the table needs to be removed before one with the same name can be created. Further, I've unfortunately noticed that these actions can take several minutes to complete (I once had to wait 5 minutes for an empty table to be removed) when doing the changes manually in cqlsh. I am not sure what would be the best way to solve this in liquibase. I guess we could do a workaround in those cases by either manually dropping tables before deploy, or deploying with a different table name. |
|
May be introducing a configurable query timeout setting would satisfy ? AWS keyspaces do take good amount of time depending on the keyspace IOPS settings (provisioned vs on demand) and of course the amount of data you need to work with (more of a cassandra thing). |
|
Ah, yes...I have 10 checks max in there with a timeout of 3. So, if it doesn't get done in 30 seconds, it will continue. I can see how that would be bad and require rerunning Liquibase after those table changes persist and the tables are ACTIVE. I agree with a timeout config, but let's just try it without for now and just bump the time up. So, what do you think is an actually time limit that we should wait for you. You said 5 minutes above, so that would mean changing the time checks to 100 from 10, right? |
|
TODO: Need to bump this timeout up to a 30 minutes (and write to the log showing status) per the AWS Keyspaces team. They don't have DDL change SLAs and that's for all the right reasons. |
|
To start with, I am not very experienced with Cassandra, AWS Keyspaces or Liquibase, I am exploring solutions to our custom built database migration script that worked fine when we ran Cassandra, but now we need to move to AWS Keyspaces and I suggested checking Liquibase as I've heard about it before. Therefore I am not 100% experienced in how Liquibase is typically used. If a change could take upward 30 minutes to finish, would you generally try to group independent changes and execute them all at once, then wait for them in bulk, instead of executing each separately and in worst case wait 30 minutes per change? From my experience creating some tables in a new keyspace generally took 10 - 15 seconds, and I'd imagine 30 minutes would be pretty rare? Or does it depend on the size of the database? If whole sets of changes that do not depend on each other to run in order is executed at once, I'd assume there would need to be care to not mix stuff that depend on each other in a change set. So it would be fine to create 5 tables concurrently (here I assume that they are actually created concurrently in AWS Keyspaces) and drop some tables not related to to the table being created, and alter some other tables and so on. But you should be careful to not drop one table to recreate it if it would all would run at the same time. I see that it is best practice to only do one change per changeset. Would having the entire changelog run and awaited before taking the next one be an idea? But in that case the developer needs to be aware of not to mix dependent changes in a changelog, but create two. I am probably overthinking this as well as it's a bit late, and I'm feeling a little bit pessimistic about the idea of a (rare) possibility of a 2.5 hour migration to create 5 tables if they would be awaited separately. Luckily database changes are usually small (at least for us), unless setting up a new keyspace and app of course. |
|
@galaxyAbstractor , liquibase purpose is to manage schema vs manage data as such (though you can do it , but not recommend), you might want to check with your dev teams why a change would take so much time, from what I suspect, you are either changing the data types or adding/modifying keys in the existing tables, which are recommend in cassandra world, it would be hard to understand the issue without looking at the change sets from version to version. |
|
I'm facing exact same issue by using the latest version changeLogFile: ./dbchangelog.yaml Any ideas?
|
|
@skaravad Has your original issue got resolved?
|
|
@yayfeng This issue does not look like it is resolved. @r2liquibase I am unsure if this is a liquibase issue or a driver issue, however, if it is the latter it may be worth looking into and checking with the AWS team. |
|
I was able to connect to keyspace following this guide with datagrip. |
|
I have been trying to get the above-mentioned driver to work. |
|
I have also detailed the use cases here:
|
|
Does 4.10.0 release supports connecting to AWS Keyspaces using the 4.x DataStax Java driver for Apache Cassandra and the SigV4 authentication plugin? if yes, how do i pass auth mechanism to use SigV4 authentication? |
Hello there, I just tried with AWS keyspaces, though I set the TunableConsistency in the URL, the apply fails, any help is much appreciated.
liquibase --changeLogFile=dbchangelog.sql '--url=jdbc:cassandra://cassandra.us-east-1.amazonaws.com:9142/delete_ks;DefaultKeyspace=delete_ks;SSLMode=1;AuthMech=1;UID=sxxxxxPWD=xxxxxx=;SSLTruststorePath=/cassandra_truststore.jks;SSLTrustStorePwd=admin123;LogLevel=6;TunableConsistency=6' update`Liquibase Community 4.1.0 by Datical
####################################################
_ _ _ _
| | () () |
| | _ __ _ _ _ | |_ __ _ _ _
| | | |/ _
| | | | | '_ \ / _/ __|/ _ \| |**| | (| | || | | |) | (_| ** \ __/
_**/|*, |*,||./ **,_|_/___|
| |
|_|
Get documentation at docs.liquibase.com
Get certified courses at learn.liquibase.com
Get support at liquibase.com/support
####################################################
Starting Liquibase at 04:20:08 (version 4.1.0 #3 built at 2020-09-28 21:02+0000)
[Simba]JDSI Cannot access file to use for logging: begin 0, end -1, length 24. Switching to default logging output.
Oct 16 04:20:08.230 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: SDK Version: 10.1.17.1129
Oct 16 04:20:08.231 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(5): +++++ enter +++++
Oct 16 04:20:08.232 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Driver Version: 02.00.04.1004
Oct 16 04:20:08.232 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: JVM Name: OpenJDK 64-Bit Server VM
Oct 16 04:20:08.232 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: JVM Specification Version: 11
Oct 16 04:20:08.233 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: JVM Implementation Version: 11.0.8+10
Oct 16 04:20:08.233 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: JVM Vendor: Oracle Corporation
Oct 16 04:20:08.233 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Operating System Name: Linux
Oct 16 04:20:08.234 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Operating System Version: 4.9.184-linuxkit
Oct 16 04:20:08.234 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Operating System Architecture: amd64
Oct 16 04:20:08.234 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Locale Name: en
Oct 16 04:20:08.235 INFO 1 com.simba.cassandra.jdbc.common.BaseConnectionFactory.getConnection: Default Charset Encoding: UTF-8
Oct 16 04:20:08.235 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(20): +++++ enter +++++
Oct 16 04:20:08.237 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIEnvironment.DSIEnvironment(com.simba.cassandra.cassandra.core.CDBJDBCDriver@503d687a): +++++ enter +++++
Oct 16 04:20:08.237 TRACE 1 com.simba.cassandra.cassandra.core.CDBJDBCEnvironment.CDBJDBCEnvironment(com.simba.cassandra.cassandra.core.CDBJDBCDriver@503d687a): +++++ enter +++++
Oct 16 04:20:08.237 TRACE 1 com.simba.cassandra.cassandra.core.CDBJDBCEnvironment.createConnection(): +++++ enter +++++
Oct 16 04:20:08.242 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(3): +++++ enter +++++
Oct 16 04:20:08.243 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(5): +++++ enter +++++
Oct 16 04:20:08.243 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(1001): +++++ enter +++++
Oct 16 04:20:08.243 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIDriver.getProperty(1002): +++++ enter +++++
[Simba]JDSI Cannot access file to use for logging: begin 0, end -1, length 30. Switching to default logging output.
Oct 16 04:20:08.244 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.DSIConnection(com.simba.cassandra.cassandra.core.CDBJDBCEnvironment@34f7cfd9): +++++ enter +++++
Oct 16 04:20:08.244 TRACE 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.CDBJDBCConnection(com.simba.cassandra.cassandra.core.CDBJDBCEnvironment@34f7cfd9): +++++ enter +++++
Oct 16 04:20:08.247 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(23, Variant[type: TYPE_UINT32, value: 0]): +++++ enter +++++
Oct 16 04:20:08.260 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.registerWarningListener(com.simba.cassandra.jdbc.common.SWarningListener@1cbb87f3): +++++ enter +++++
Oct 16 04:20:08.261 TRACE 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.updateConnectionSettings(): +++++ enter +++++
Oct 16 04:20:08.264 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: AuthMech is set to: 1
Oct 16 04:20:08.264 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Port is set to: 9142
Oct 16 04:20:08.265 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Default Keyspace is set to : sk_delete_ks
Oct 16 04:20:08.265 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: SSL Mode is set to: 1
Oct 16 04:20:08.266 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: SSL Truststore Path is set to: /cassandra_truststore.jks
Oct 16 04:20:08.266 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Tunable Consistency is set to : LOCAL_QUORUM
Oct 16 04:20:08.269 TRACE 1 com.simba.cassandra.jdbc.common.CommonCoreUtils.logConnectionFunctionEntrance({AuthMech=Variant[type: TYPE_WSTRING, value: 1], ConnSchema=Variant[type: TYPE_WSTRING, value: sk_delete_ks], DefaultKeyspace=Variant[type: TYPE_WSTRING, value: sk_delete_ks], Host=Variant[type: TYPE_WSTRING, value: cassandra.us-east-1.amazonaws.com], LogLevel=Variant[type: TYPE_WSTRING, value: 6], Port=Variant[type: TYPE_WSTRING, value: 9142], PWD=Variant[type: TYPE_WSTRING, value: *], SSLMode=Variant[type: TYPE_WSTRING, value: 1], SSLTruststorePath=Variant[type: TYPE_WSTRING, value: /cassandra_truststore.jks], SSLTrustStorePwd=Variant[type: TYPE_WSTRING, value: admin123], TunableConsistency=Variant[type: TYPE_WSTRING, value: 6], UID=Variant[type: TYPE_WSTRING, value: *]}, "Major Version: 2", "Minor Version: 0", "Hot Fix Version: 4", "Build Number: 1004", "java.vendor:N/A", "java.version:11.0.8", "os.arch:amd64", "os.name:Linux", "os.version:4.9.184-linuxkit", "Runtime.totalMemory:33554432", "Runtime.maxMemory:524288000", "Runtime.avaialableProcessors:4", URLClassLoader.getURLs(): No URLClassLoader available.): +++++ enter +++++
Oct 16 04:20:08.270 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: AuthMech is set to: 1
Oct 16 04:20:08.270 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Port is set to: 9142
Oct 16 04:20:08.270 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Default Keyspace is set to : sk_delete_ks
Oct 16 04:20:08.271 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: SSL Mode is set to: 1
Oct 16 04:20:08.271 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: SSL Truststore Path is set to: /cassandra_truststore.jks
Oct 16 04:20:08.271 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.getConnectionSettings: Tunable Consistency is set to : LOCAL_QUORUM
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Oct 16 04:20:10.956 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.957 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.958 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.959 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.959 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.211/3.234.248.211: 1
Oct 16 04:20:10.959 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.211/3.234.248.211: 32768
Oct 16 04:20:10.960 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.211/3.234.248.211: 256
Oct 16 04:20:10.960 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.960 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.960 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.960 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.961 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.195/3.234.248.195: 1
Oct 16 04:20:10.961 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.195/3.234.248.195: 32768
Oct 16 04:20:10.962 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.195/3.234.248.195: 256
Oct 16 04:20:10.962 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.962 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.963 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.963 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.963 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.231/3.234.248.231: 1
Oct 16 04:20:10.964 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.231/3.234.248.231: 32768
Oct 16 04:20:10.964 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.231/3.234.248.231: 256
Oct 16 04:20:10.964 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.965 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.965 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.966 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.966 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.199/3.234.248.199: 1
Oct 16 04:20:10.967 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.199/3.234.248.199: 32768
Oct 16 04:20:10.967 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.199/3.234.248.199: 256
Oct 16 04:20:10.968 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.968 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.968 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.969 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.970 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.198/3.234.248.198: 1
Oct 16 04:20:10.970 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.198/3.234.248.198: 32768
Oct 16 04:20:10.971 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.198/3.234.248.198: 256
Oct 16 04:20:10.971 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.971 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.972 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.973 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.973 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.221/3.234.248.221: 1
Oct 16 04:20:10.974 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.221/3.234.248.221: 32768
Oct 16 04:20:10.974 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.221/3.234.248.221: 256
Oct 16 04:20:10.975 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.975 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.976 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.976 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.977 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.203/3.234.248.203: 1
Oct 16 04:20:10.978 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.203/3.234.248.203: 32768
Oct 16 04:20:10.979 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.203/3.234.248.203: 256
Oct 16 04:20:10.979 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.980 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.980 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.981 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.982 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host cassandra.us-east-1.amazonaws.com/3.234.248.255: 1
Oct 16 04:20:10.982 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host cassandra.us-east-1.amazonaws.com/3.234.248.255: 32768
Oct 16 04:20:10.983 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host cassandra.us-east-1.amazonaws.com/3.234.248.255: 256
Oct 16 04:20:10.984 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.984 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.985 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.986 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.987 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.239/3.234.248.239: 1
Oct 16 04:20:10.987 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.239/3.234.248.239: 32768
Oct 16 04:20:10.988 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.239/3.234.248.239: 256
Oct 16 04:20:10.988 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Datacenter: us-east-1
Oct 16 04:20:10.988 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Rack: us-east-1
Oct 16 04:20:10.989 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host Cassandra Version: 3.11.2
Oct 16 04:20:10.989 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Host State: UP
Oct 16 04:20:10.990 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxConnections for Host 3.234.248.222/3.234.248.222: 1
Oct 16 04:20:10.990 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxRequestsPerConnection for Host 3.234.248.222/3.234.248.222: 32768
Oct 16 04:20:10.991 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: MaxQueueSize for Host 3.234.248.222/3.234.248.222: 256
Oct 16 04:20:10.992 INFO 1 com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect: Concurrent Requests Limit for the cluster is set to: 330240
Oct 16 04:20:10.993 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(9, Variant[type: TYPE_WSTRING, value: Y]): +++++ enter +++++
Oct 16 04:20:10.994 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(11, Variant[type: TYPE_WSTRING, value: catalog]): +++++ enter +++++
Oct 16 04:20:10.994 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(12, Variant[type: TYPE_UINT32, value: 31]): +++++ enter +++++
Oct 16 04:20:10.994 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(16, Variant[type: TYPE_UINT32, value: 0]): +++++ enter +++++
Oct 16 04:20:10.995 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(40, Variant[type: TYPE_WSTRING, value: N]): +++++ enter +++++
Oct 16 04:20:10.995 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(1000, Variant[type: TYPE_INT16, value: 0]): +++++ enter +++++
Oct 16 04:20:10.996 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(99, Variant[type: TYPE_WSTRING, value: schema]): +++++ enter +++++
Oct 16 04:20:10.996 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(100, Variant[type: TYPE_UINT32, value: 31]): +++++ enter +++++
Oct 16 04:20:10.997 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(81, Variant[type: TYPE_UINT16, value: 256]): +++++ enter +++++
Oct 16 04:20:10.997 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(96, Variant[type: TYPE_WSTRING, value: ]): +++++ enter +++++
Oct 16 04:20:10.998 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(97, Variant[type: TYPE_WSTRING, value: N]): +++++ enter +++++
Oct 16 04:20:10.998 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(101, Variant[type: TYPE_WSTRING, value: CassandraJDBC]): +++++ enter +++++
Oct 16 04:20:10.999 TRACE 1 com.simba.cassandra.dsi.core.impl.DSIConnection.setProperty(41, Variant[type: TYPE_WSTRING, value: Cassandra]): +++++ enter +++++
Oct 16 04:20:11.731 ERROR 1 com.simba.cassandra.exceptions.ExceptionConverter.toSQLException: [Simba]CassandraJDBCDriver Error setting default connection property values.
java.sql.SQLException: [Simba]CassandraJDBCDriver Error setting default connection property values.
at com.simba.cassandra.cassandra.core.CDBJDBCConnection.setDefaultProperties(Unknown Source)
at com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect(Unknown Source)
at com.simba.cassandra.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.cassandra.jdbc.common.AbstractDriver.connect(Unknown Source)
at liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:37)
at com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)
at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:33)
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247)
at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:140)
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:91)
at liquibase.integration.commandline.Main.doMigration(Main.java:1408)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:361)
at liquibase.Scope.lambda$child$0(Scope.java:160)
at liquibase.Scope.child(Scope.java:169)
at liquibase.Scope.child(Scope.java:159)
at liquibase.Scope.child(Scope.java:138)
at liquibase.Scope.child(Scope.java:222)
at liquibase.Scope.child(Scope.java:226)
at liquibase.integration.commandline.Main$1.run(Main.java:360)
at liquibase.integration.commandline.Main$1.run(Main.java:193)
at liquibase.Scope.child(Scope.java:169)
at liquibase.Scope.child(Scope.java:145)
at liquibase.integration.commandline.Main.run(Main.java:193)
Caused by: com.simba.cassandra.support.exceptions.GeneralException: [Simba]CassandraJDBCDriver Error setting default connection property values.
... 23 more
Caused by: com.simba.cassandra.shaded.datastax.driver.core.exceptions.InvalidQueryException: Consistency level ALL is not supported for this operation. Supported consistency levels are: ONE, LOCAL_QUORUM, LOCAL_ONE
at com.simba.cassandra.shaded.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)
at com.simba.cassandra.shaded.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:35)
at com.simba.cassandra.shaded.datastax.driver.core.ChainedResultSetFuture.getUninterruptibly(ChainedResultSetFuture.java:59)
at com.simba.cassandra.shaded.datastax.driver.core.AbstractSession.execute(AbstractSession.java:58)
at com.simba.cassandra.shaded.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39)
at com.simba.cassandra.cassandra.core.CDBJDBCConnection.getReleaseVersion(Unknown Source)
at com.simba.cassandra.cassandra.core.CDBJDBCConnection.setDefaultProperties(Unknown Source)
at com.simba.cassandra.cassandra.core.CDBJDBCConnection.connect(Unknown Source)
at com.simba.cassandra.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.cassandra.jdbc.common.AbstractDriver.connect(Unknown Source)
at liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:37)
at com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)
at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:33)
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247)
at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:140)
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:91)
at liquibase.integration.commandline.Main.doMigration(Main.java:1408)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:361)
at liquibase.Scope.lambda$child$0(Scope.java:160)
at liquibase.Scope.child(Scope.java:169)
at liquibase.Scope.child(Scope.java:159)
at liquibase.Scope.child(Scope.java:138)
at liquibase.Scope.child(Scope.java:222)
at liquibase.Scope.child(Scope.java:226)
at liquibase.integration.commandline.Main$1.run(Main.java:360)
at liquibase.integration.commandline.Main$1.run(Main.java:193)
at liquibase.Scope.child(Scope.java:169)
at liquibase.Scope.child(Scope.java:145)
at liquibase.integration.commandline.Main.run(Main.java:193)
at liquibase.integration.commandline.Main.main(Main.java:156)
Caused by: com.simba.cassandra.shaded.datastax.driver.core.exceptions.InvalidQueryException: Consistency level ALL is not supported for this operation. Supported consistency levels are: ONE, LOCAL_QUORUM, LOCAL_ONE
at com.simba.cassandra.shaded.datastax.driver.core.Responses$Error.asException(Responses.java:181)
at com.simba.cassandra.shaded.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:215)
at com.simba.cassandra.shaded.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:235)
at com.simba.cassandra.shaded.datastax.driver.core.RequestHandler.access$2600(RequestHandler.java:61)
at com.simba.cassandra.shaded.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:1005)
at com.simba.cassandra.shaded.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:808)
at com.simba.cassandra.shaded.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1262)
at com.simba.cassandra.shaded.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1180)
at com.simba.cassandra.shaded.io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312)
at com.simba.cassandra.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
at com.simba.cassandra.shaded.datastax.driver.core.InboundTrafficMeter.channelRead(InboundTrafficMeter.java:38)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.handler.ssl.SslHandler.unwrap(SslHandler.java:1337)
at com.simba.cassandra.shaded.io.netty.handler.ssl.SslHandler.decodeJdkCompatible(SslHandler.java:1108)
at com.simba.cassandra.shaded.io.netty.handler.ssl.SslHandler.decode(SslHandler.java:1151)
at com.simba.cassandra.shaded.io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:491)
at com.simba.cassandra.shaded.io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:430)
at com.simba.cassandra.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:267)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
at com.simba.cassandra.shaded.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1304)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
at com.simba.cassandra.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
at com.simba.cassandra.shaded.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:921)
at com.simba.cassandra.shaded.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:135)
at com.simba.cassandra.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:646)
at com.simba.cassandra.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:546)
at com.simba.cassandra.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:500)
at com.simba.cassandra.shaded.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:460)
at com.simba.cassandra.shaded.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131)
at com.simba.cassandra.shaded.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
at java.base/java.lang.Thread.run(Unknown Source)
`
┆Issue is synchronized with this Jira Bug by Unito
The text was updated successfully, but these errors were encountered: