EC
1429
MariaDBerrorserverhigh confidence

Unable to connect to foreign data source

Production Risk

High — all queries against the federated table fail until the remote connection is restored.

What this means

A FEDERATED or CONNECT engine table could not establish a connection to the remote data source.

Why it happens
  1. 1Remote MySQL server is down or unreachable
  2. 2Incorrect connection string in the CREATE TABLE COMMENT
  3. 3Firewall blocking the outbound connection
  4. 4Authentication failure on the remote server
How to reproduce
trigger — this will error
trigger — this will error
SELECT * FROM federated_table;

expected output

ERROR 1429 (HY000): Unable to connect to foreign data source: 'mysql://user@remote_host/db/tbl'

Fix 1

Verify remote server is accessible

Why this works

Test connectivity with mysql -h remote_host -u user -p.

Fix 2

Correct the connection URL in the table definition

Correct the connection URL in the table definition
ALTER TABLE federated_table CONNECTION='mysql://user:pass@correct_host:3306/db/tbl';

Why this works

Updates the remote connection string.

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 1429 ER_CONNECT_TO_FOREIGN_DATA_SOURCE

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors