Hi, I cant delete sources or connections. When I d...
# ask-community-for-troubleshooting
m
Hi, I cant delete sources or connections. When I delete sources I have a popup with a massive error message. When I delete a connection, on refresh it come back šŸ˜•
m
What error and what version of Airbyte are you using?
m
Airbyte is up to date. When I try to delete the source :
Copy code
Something went wrong
The provided configuration does not fulfill the specification. Errors: json schema validation failed when comparing the data to the json schema. Errors: $.replication_method: string found, object expected, $.replication_method: should be valid to one and only one of the schemas Schema: { "type" : "object", "title" : "MySql Source Spec", "$schema" : "<http://json-schema.org/draft-07/schema#>", "required" : [ "host", "port", "database", "username", "replication_method" ], "properties" : { "ssl" : { "type" : "boolean", "order" : 6, "title" : "SSL Connection", "default" : true, "description" : "Encrypt data using SSL." }, "host" : { "type" : "string", "order" : 0, "title" : "Host", "description" : "The host name of the database." }, "port" : { "type" : "integer", "order" : 1, "title" : "Port", "default" : 3306, "maximum" : 65536, "minimum" : 0, "examples" : [ "3306" ], "description" : "The port to connect to." }, "database" : { "type" : "string", "order" : 2, "title" : "Database", "description" : "The database name." }, "password" : { "type" : "string", "order" : 4, "title" : "Password", "description" : "The password associated with the username.", "airbyte_secret" : true }, "ssl_mode" : { "type" : "object", "oneOf" : [ { "title" : "preferred", "required" : [ "mode" ], "properties" : { "mode" : { "enum" : [ "preferred" ], "type" : "string", "const" : "preferred", "order" : 0, "default" : "preferred" } }, "description" : "Preferred SSL mode." }, { "title" : "required", "required" : [ "mode" ], "properties" : { "mode" : { "enum" : [ "required" ], "type" : "string", "const" : "required", "order" : 0, "default" : "required" } }, "description" : "Require SSL mode." }, { "title" : "Verify CA", "required" : [ "mode", "ca_certificate" ], "properties" : { "mode" : { "enum" : [ "verify_ca" ], "type" : "string", "const" : "verify_ca", "order" : 0, "default" : "verify_ca" }, "client_key" : { "type" : "string", "order" : 3, "title" : "Client key", "multiline" : true, "description" : "Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)", "airbyte_secret" : true }, "ca_certificate" : { "type" : "string", "order" : 1, "title" : "CA certificate", "multiline" : true, "description" : "CA certificate", "airbyte_secret" : true }, "client_certificate" : { "type" : "string", "order" : 2, "title" : "Client certificate", "multiline" : true, "description" : "Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)", "airbyte_secret" : true }, "client_key_password" : { "type" : "string", "order" : 4, "title" : "Client key password (Optional)", "description" : "Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.", "airbyte_secret" : true } }, "description" : "Verify CA SSL mode." }, { "title" : "Verify Identity", "required" : [ "mode", "ca_certificate" ], "properties" : { "mode" : { "enum" : [ "verify_identity" ], "type" : "string", "const" : "verify_identity", "order" : 0, "default" : "verify_identity" }, "client_key" : { "type" : "string", "order" : 3, "title" : "Client key", "multiline" : true, "description" : "Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)", "airbyte_secret" : true }, "ca_certificate" : { "type" : "string", "order" : 1, "title" : "CA certificate", "multiline" : true, "description" : "CA certificate", "airbyte_secret" : true }, "client_certificate" : { "type" : "string", "order" : 2, "title" : "Client certificate", "multiline" : true, "description" : "Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)", "airbyte_secret" : true }, "client_key_password" : { "type" : "string", "order" : 4, "title" : "Client key password (Optional)", "description" : "Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.", "airbyte_secret" : true } }, "description" : "Verify-full SSL mode." } ], "order" : 7, "title" : "SSL modes", "description" : "SSL connection modes. <li><b>preferred</b> - Automatically attempt SSL connection. If the MySQL server does not support SSL, continue with a regular connection.</li><li><b>required</b> - Always connect with SSL. If the MySQL server doesn't support SSL, the connection will not be established. Certificate Authority (CA) and Hostname are not verified.</li><li><b>verify-ca</b> - Always connect with SSL. Verifies CA, but allows connection even if Hostname does not match.</li><li><b>Verify Identity</b> - Always connect with SSL. Verify both CA and Hostname.</li></ul>Read more <a href=\"<https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-using-ssl.html>\"> in the docs</a>." }, "username" : { "type" : "string", "order" : 3, "title" : "Username", "description" : "The username which is used to access the database." }, "tunnel_method" : { "type" : "object", "oneOf" : [ { "title" : "No Tunnel", "required" : [ "tunnel_method" ], "properties" : { "tunnel_method" : { "type" : "string", "const" : "NO_TUNNEL", "order" : 0, "description" : "No ssh tunnel needed to connect to database" } } }, { "title" : "SSH Key Authentication", "required" : [ "tunnel_method", "tunnel_host", "tunnel_port", "tunnel_user", "ssh_key" ], "properties" : { "ssh_key" : { "type" : "string", "order" : 4, "title" : "SSH Private Key", "multiline" : true, "description" : "OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )", "airbyte_secret" : true }, "tunnel_host" : { "type" : "string", "order" : 1, "title" : "SSH Tunnel Jump Server Host", "description" : "Hostname of the jump server host that allows inbound ssh tunnel." }, "tunnel_port" : { "type" : "integer", "order" : 2, "title" : "SSH Connection Port", "default" : 22, "maximum" : 65536, "minimum" : 0, "examples" : [ "22" ], "description" : "Port on the proxy/jump server that accepts inbound ssh connections." }, "tunnel_user" : { "type" : "string", "order" : 3, "title" : "SSH Login Username", "description" : "OS-level username for logging into the jump server host." }, "tunnel_method" : { "type" : "string", "const" : "SSH_KEY_AUTH", "order" : 0, "description" : "Connect through a jump server tunnel host using username and ssh key" } } }, { "title" : "Password Authentication", "required" : [ "tunnel_method", "tunnel_host", "tunnel_port", "tunnel_user", "tunnel_user_password" ], "properties" : { "tunnel_host" : { "type" : "string", "order" : 1, "title" : "SSH Tunnel Jump Server Host", "description" : "Hostname of the jump server host that allows inbound ssh tunnel." }, "tunnel_port" : { "type" : "integer", "order" : 2, "title" : "SSH Connection Port", "default" : 22, "maximum" : 65536, "minimum" : 0, "examples" : [ "22" ], "description" : "Port on the proxy/jump server that accepts inbound ssh connections." }, "tunnel_user" : { "type" : "string", "order" : 3, "title" : "SSH Login Username", "description" : "OS-level username for logging into the jump server host" }, "tunnel_method" : { "type" : "string", "const" : "SSH_PASSWORD_AUTH", "order" : 0, "description" : "Connect through a jump server tunnel host using username and password authentication" }, "tunnel_user_password" : { "type" : "string", "order" : 4, "title" : "Password", "description" : "OS-level password for logging into the jump server host", "airbyte_secret" : true } } } ], "title" : "SSH Tunnel Method", "description" : "Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use." }, "jdbc_url_params" : { "type" : "string", "order" : 5, "title" : "JDBC URL Params", "description" : "Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3)." }, "replication_method" : { "type" : "object", "oneOf" : [ { "title" : "STANDARD", "required" : [ "method" ], "properties" : { "method" : { "enum" : [ "STANDARD" ], "type" : "string", "const" : "STANDARD", "order" : 0, "default" : "STANDARD" } }, "description" : "Standard replication requires no setup on the DB side but will not be able to represent deletions incrementally." }, { "title" : "Logical Replication (CDC)", "required" : [ "method" ], "properties" : { "method" : { "enum" : [ "CDC" ], "type" : "string", "const" : "CDC", "order" : 0, "default" : "CDC" } }, "description" : "CDC uses the Binlog to detect inserts, updates, and deletes. This needs to be configured on the source database itself." } ], "order" : 8, "title" : "Replication Method", "description" : "Replication method to use for extracting data from the database." } } }
Also, when I try to sync one of these connections I have an error (in Javascript Console) but no sync operations are running at all atm
Copy code
A sync is already running for: 8e3cfef1-f431-4f6c-8e71-0714d155ea7e
To conclude, when I manage to start a connection operation I have an error on Sync task :
Solution for the ones stuck : downgrade Airbyte to 0.39.37-alpha (and never ever upgrade again ^^)
m
oh no! sorry the delay here @Mickaƫl Andrieu. the error is happening with bigquery and not mysql
m
I don't think so, I have also tried to downgrade BigQuery Destination plugin until my "last known good config" and the only thing that solved my issue was to revert the Airbyte upgrade
Even with 0.39.42, the synchronization tasks are failing, sadly I'm not good enough to help you with the root source of the issue
m
You have only one connection to Bigquery?
m
yes this connection is common to all my sources