我正在使用docker-compose尝试使用python连接mariadb:
泊坞窗,compose.yml
version: '2'
services:
mariadb:
image: bitnami/mariadb
ports:
- "3306:3306"
environment:
MARIADB_DATABASE: 'mary_db'
MARIADB_USER: user2
MARIADB_PASSWORD: 'pass1234'
consumer:
build: ./consumer
links:
- mariadb
consumer.py
import mysql.connector as mariadb1
mariadb_connection = mariadb1.connect(host='mariadb',
port=3306,
user='user2',
password='pass1234',
database='mary_db')
cursor = mariadb_connection.cursor(buffered=True)
try:
cursor.execute('DROP TABLE names')
except:
pass
comm = "CREATE TABLE names(id VARCHAR(20), location VARCHAR(100)," \
"PRIMARY KEY (mac,location)) ENGINE=InnoDB"
cursor.execute(comm)
print 'created'
Dockerfile入口点只是调用consumer.py函数,如:
ENTRYPOINT python -u consumer.py
问题非常随机(超过90%的试验),python代码无法连接数据库并打印此错误:
文件“consumer.py”,第7行,在database ='mary_db'中)文件“/usr/local/lib/python2.7/dist-packages/mysql/connector/init.py”,第179行,在连接返回MySQLConnection(* args,** kwargs)文件“/usr/local/lib/python2.7/dist-packages/mysql/connector/connection.py”,第95行,在init self.connect(** kwargs)文件中“ /usr/local/lib/python2.7/dist-packages/mysql/connector/abstracts.py“,第719行,在连接self._open_connection()文件”/usr/local/lib/python2.7/dist-packages /mysql/connector/connection.py“,第206行,在_open_connection self.socket.open_connection()文件”/usr/local/lib/python2.7/dist-packages/mysql/connector/network.py“,第475行,在open_connection中errno = 2003,values =(self.get_address(), strioerror(err)))mysql.connector.errors.InterfaceError:2003:无法连接到'mariadb:3306'上的MySQL服务器(111连接被拒绝)
知道发生了什么事吗?
1 回答
问题不在于数据库或Python代码;它是来自Docker的引发问题,因为数据库需要一些时间来加载并且python(consumer.py)容器的启动速度比数据库快 .
可能的解决方案:
码头 Worker Health 检查
在码头 Worker 的等待时间
给python使用者添加一个延迟