Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failing to setup connection: "Failed to fetch schema. Please try again" #1818

Closed
ChristopheDuong opened this issue Jan 25, 2021 · 0 comments · Fixed by #1833
Closed

Failing to setup connection: "Failed to fetch schema. Please try again" #1818

ChristopheDuong opened this issue Jan 25, 2021 · 0 comments · Fixed by #1833
Labels
type/bug Something isn't working

Comments

@ChristopheDuong
Copy link
Contributor

Expected Behavior

Setting up a connection between MySQL and Postgres where I replicate from a schema named "test.dir"

Current Behavior

Even though the logs seems to be completing successfully:

2021-01-25 16:50:38 INFO (/tmp/workspace/24/0) WorkerRun(call):58 - Executing worker wrapper...
2021-01-25 16:50:38 INFO (/tmp/workspace/24/0) LineGobbler(voidCall):69 - Checking if airbyte/source-mysql:0.1.8 exists...
2021-01-25 16:50:38 INFO (/tmp/workspace/24/0) LineGobbler(voidCall):69 - airbyte/source-mysql:0.1.8 was found locally.
2021-01-25 16:50:38 DEBUG (/tmp/workspace/24/0) DockerProcessBuilderFactory(create):104 - Preparing command: docker run --rm -i -v airbyte_workspace_dev:/data -v /tmp/airbyte_local_dev:/local -w /data/24/0 --network host airbyte/source-mysql:0.1.8 discover --config tap_config.json
2021-01-25 16:50:39 INFO (/tmp/workspace/24/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-01-25 16:50:39 INFO i.a.i.s.m.MySqlSource(main):75 - {} - starting source: class io.airbyte.integrations.source.mysql.MySqlSource
2021-01-25 16:50:39 INFO (/tmp/workspace/24/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-01-25 16:50:39 INFO i.a.i.b.IntegrationRunner(run):78 - {} - Running integration: io.airbyte.integrations.source.mysql.MySqlSource
2021-01-25 16:50:39 INFO (/tmp/workspace/24/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-01-25 16:50:39 INFO i.a.i.b.IntegrationCliParser(parseOptions):135 - {} - integration args: {discover=null, config=tap_config.json}
2021-01-25 16:50:39 INFO (/tmp/workspace/24/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-01-25 16:50:39 INFO i.a.i.b.IntegrationRunner(run):82 - {} - Command: DISCOVER
2021-01-25 16:50:39 INFO (/tmp/workspace/24/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-01-25 16:50:39 INFO i.a.i.b.IntegrationRunner(run):83 - {} - Integration config: IntegrationConfig{command=DISCOVER, configPath='tap_config.json', catalogPath='null', statePath='null'}
2021-01-25 16:50:40 INFO (/tmp/workspace/24/0) LoggingTrackingClient(track):55 - track. userId: f7542c84-e807-4033-88a1-1687c765a7d0 action: Connector Jobs, metadata: {job_type=discoverSchema, job_id=24, attempt_id=[], job_uuid=98b435f7-720f-3958-a425-b55930bfd239, attempt_uuid=98b435f7-720f-3958-a425-b55930bfd239, connector_source=MySQL, connector_source_definition_id=435bb9a5-7887-4809-aa58-28c27df0d7ad, attempt_stage=ENDED, attempt_completion_status=SUCCEEDED}
(venv) 

The UI shows:
"Failed to fetch schema. Please try again"

Screenshot 2021-01-25 at 17 52 03

Steps to Reproduce

  1. docker run --rm --name mysql-test-source -e MYSQL_ROOT_PASSWORD=password -p 3001:3306 mysql:8.0
  2. Create test data:
create schema if not exists `test.dir`;
create table if not exists `test.dir`.`Product.property`
(
	col1 varchar(100),
	`col2.3` varchar(100)	
); 
insert into `test.dir`.`Product.property`(col1, `col2.3`)
values('Test Product', 'Product Description');
  1. sync between MySQL source to Destination

Severity of the bug for you

High

Airbyte Version

0.13.0

Additional context

Related to #1816

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant