DataError 1406, “Data too long for column ‘exposed

阅读: 评论:0

DataError 1406, “Data too long for column ‘exposed

openstack中管理容器暴露范围端口,转换为单个端口,端口暴露包括 tcp和udp 协议,出现个数过多,数据过长,zun-api请求报错如下:

2021-10-21 19:14:49.926 2925 ption [req-b037140d-79d6-4a91-9fcd-926321baf4b1 - - - - -] ab065d5e-faf3-4e28-b88b-551336ab3985:(DataError) (1406, “Data too long for column ‘exposed_ports’ at row 1”)
[SQL: INSERT INTO container (created_at, updated_at, project_id, user_id, uuid, container_id, name, image, cpu, cpu_policy, cpuset, command, memory, status, status_reason, task_state, environment, workdir, ports, hostname, labels, meta, addresses, image_pull_policy, host, restart_policy, status_detail, interactive, tty, image_driver, websocket_url, websocket_token, security_groups, auto_remove, runtime, disk, auto_heal, capsule_id, started_at, privileged, healthcheck, exposed_ports, registry_id, container_type) VALUES (%(created_at)s, %(updated_at)s, %(project_id)s, %(user_id)s, %(uuid)s, %(container_id)s, %(name)s, %(image)s, %(cpu)s, %(cpu_policy)s, %(cpuset)s, %(command)s, %(memory)s, %(status)s, %(status_reason)s, %(task_state)s, %(environment)s, %(workdir)s, %(ports)s, %(hostname)s, %(labels)s, %(meta)s, %(addresses)s, %(image_pull_policy)s, %(host)s, %(restart_policy)s, %(status_detail)s, %(interactive)s, %(tty)s, %(image_driver)s, %(websocket_url)s, %(websocket_token)s, %(security_groups)s, %(auto_remove)s, %(runtime)s, %(disk)s, %(auto_heal)s, %(capsule_id)s, %(started_at)s, %(privileged)s, %(healthcheck)s, %(exposed_ports)s, %(registry_id)s, %(container_type)s)]
[parameters: {‘created_at’: datetime.datetime(2021, 10, 21, 11, 14, 49, 195735), ‘updated_at’: None, ‘project_id’: ‘cb5388a3555346d0b224b45a1fc0aa2e’, ‘user_id’: ‘8e949daa55634ef48777ecd989daa6ab’, ‘uuid’: ‘78a36eee-c370-4415-b473-4ad28425f94c’, ‘container_id’: None, ‘name’: ‘9be5e7ba0fb840ed9b36eed483c2af10’, ‘image’: ‘d30a9dbc-1f75-4179-8f66-cca641848277’, ‘cpu’: 2.0, ‘cpu_policy’: ‘shared’, ‘cpuset’: b’{}’, ‘command’: b’[]’, ‘memory’: ‘1024’, ‘status’: ‘Creating’, ‘status_reason’: None, ‘task_state’: None, ‘environment’: b’{“USERNAME”: “admin111”, “PASSWORD”: “ppp@ssw0rd”, “BASEPATH”: “/bbbbb001”, “HOOKJS”: “/obama.js”, “WEBPORT”: “4444/tcp”, “ssh_port”: “22/tcp”, “HTT … (4 characters truncated) … XY”: “6789/tcp”, “NAT_SERVER_TOKEN”: “e0ee37bf-1257-40fc-9682-0ac98e6f60b5”, “NAT_SERVER_ADDR”: “192.168.1.1”, “NAT_CLIENT_EXPOSE_PORT”: “5678-9999”}’, ‘workdir’: None, ‘ports’: b’[]’, ‘hostname’: ‘beef’, ‘labels’: b’{}’, ‘meta’: b’{}’, ‘addresses’: b’{}’, ‘image_pull_policy’: None, ‘host’: None, ‘restart_policy’: b’{}’, ‘status_detail’: None, ‘interactive’: 1, ‘tty’: 1, ‘image_driver’: ‘glance’, ‘websocket_url’: None, ‘websocket_token’: None, ‘security_groups’: b’[]’, ‘auto_remove’: 0, ‘runtime’: ‘runc’, ‘disk’: 5, ‘auto_heal’: 0, ‘capsule_id’: None, ‘started_at’: None, ‘privileged’: 1, ‘healthcheck’: b’{}’, ‘exposed_ports’: b’{“4444/tcp”: {}, “22/tcp”: {}, “6789/tcp”: {}, “5678/tcp”: {}, “5678/udp”: {}, “5679/tcp”: {}, “5679/udp”: {}, “5680/tcp”: {}, “5680/udp”: {}, "5681 … (138037 characters truncated) … : {}, “9995/udp”: {}, “9996/tcp”: {}, “9996/udp”: {}, “9997/tcp”: {}, “9997/udp”: {}, “9998/tcp”: {}, “9998/udp”: {}, “9999/tcp”: {}, “9999/udp”: {}}’, ‘registry_id’: None, ‘container_type’: 0}]
(Background on this error at: ): ption.DBDataError: (DataError) (1406, “Data too long for column ‘exposed_ports’ at row 1”)
[SQL: INSERT INTO container (created_at, updated_at, project_id, user_id, uuid, container_id, name, image, cpu, cpu_policy, cpuset, command, memory, status, status_reason, task_state, environment, workdir, ports, hostname, labels, meta, addresses, image_pull_policy, host, restart_policy, status_detail, interactive, tty, image_driver, websocket_url, websocket_token, security_groups, auto_remove, runtime, disk, auto_heal, capsule_id, started_at, privileged, healthcheck, exposed_ports, registry_id, container_type) VALUES (%(created_at)s, %(updated_at)s, %(project_id)s, %(user_id)s, %(uuid)s, %(container_id)s, %(name)s, %(image)s, %(cpu)s, %(cpu_policy)s, %(cpuset)s, %(command)s, %(memory)s, %(status)s, %(status_reason)s, %(task_state)s, %(environment)s, %(workdir)s, %(ports)s, %(hostname)s, %(labels)s, %(meta)s, %(addresses)s, %(image_pull_policy)s, %(host)s, %(restart_policy)s, %(status_detail)s, %(interactive)s, %(tty)s, %(image_driver)s, %(websocket_url)s, %(websocket_token)s, %(security_groups)s, %(auto_remove)s, %(runtime)s, %(disk)s, %(auto_heal)s, %(capsule_id)s, %(started_at)s, %(privileged)s, %(healthcheck)s, %(exposed_ports)s, %(registry_id)s, %(container_type)s)]
[parameters: {‘created_at’: datetime.datetime(2021, 10, 21, 11, 14, 49, 195735), ‘updated_at’: None, ‘project_id’: ‘cb5388a3555346d0b224b45a1fc0aa2e’, ‘user_id’: ‘8e949daa55634ef48777ecd989daa6ab’, ‘uuid’: ‘78a36eee-c370-4415-b473-4ad28425f94c’, ‘container_id’: None, ‘name’: ‘9be5e7ba0fb840ed9b36eed483c2af10’, ‘image’: ‘d30a9dbc-1f75-4179-8f66-cca641848277’, ‘cpu’: 2.0, ‘cpu_policy’: ‘shared’, ‘cpuset’: b’{}’, ‘command’: b’[]’, ‘memory’: ‘1024’, ‘status’: ‘Creating’, ‘status_reason’: None, ‘task_state’: None, ‘environment’: b’{“USERNAME”: “admin111”, “PASSWORD”: “ppp@ssw0rd”, “BASEPATH”: “/bbbbb001”, “HOOKJS”: “/obama.js”, “WEBPORT”: “4444/tcp”, “ssh_port”: “22/tcp”, “HTT … (4 characters truncated) … XY”: “6789/tcp”, “NAT_SERVER_TOKEN”: “e0ee37bf-1257-40fc-9682-0ac98e6f60b5”, “NAT_SERVER_ADDR”: “192.168.1.1”, “NAT_CLIENT_EXPOSE_PORT”: “5678-9999”}’, ‘workdir’: None, ‘ports’: b’[]’, ‘hostname’: ‘beef’, ‘labels’: b’{}’, ‘meta’: b’{}’, ‘addresses’: b’{}’, ‘image_pull_policy’: None, ‘host’: None, ‘restart_policy’: b’{}’, ‘status_detail’: None, ‘interactive’: 1, ‘tty’: 1, ‘image_driver’: ‘glance’, ‘websocket_url’: None, ‘websocket_token’: None, ‘security_groups’: b’[]’, ‘auto_remove’: 0, ‘runtime’: ‘runc’, ‘disk’: 5, ‘auto_heal’: 0, ‘capsule_id’: None, ‘started_at’: None, ‘privileged’: 1, ‘healthcheck’: b’{}’, ‘exposed_ports’: b’{“4444/tcp”: {}, “22/tcp”: {}, “6789/tcp”: {}, “5678/tcp”: {}, “5678/udp”: {}, “5679/tcp”: {}, “5679/udp”: {}, “5680/tcp”: {}, “5680/udp”: {}, "5681 … (138037 characters truncated) … : {}, “9995/udp”: {}, “9996/tcp”: {}, “9996/udp”: {}, “9997/tcp”: {}, “9997/udp”: {}, “9998/tcp”: {}, “9998/udp”: {}, “9999/tcp”: {}, “9999/udp”: {}}’, ‘registry_id’: None, ‘container_type’: 0}]
(Background on this error at: )
2021-10-21 19:14:49.926 2925 ption Traceback (most recent call last):
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1249, in _execute_context
2021-10-21 19:14:49.926 2925 ption cursor, statement, parameters, context
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/default.py”, line 552, in do_execute
2021-10-21 19:14:49.926 2925 ute(statement, parameters)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/cursors.py”, line 170, in execute
2021-10-21 19:14:49.926 2925 ption result = self._query(query)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/cursors.py”, line 328, in _query
2021-10-21 19:14:49.926 2925 ption conn.query(q)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 517, in query
2021-10-21 19:14:49.926 2925 ption self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 732, in _read_query_result
2021-10-21 19:14:49.926 2925 ad()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 1075, in read
2021-10-21 19:14:49.926 2925 ption first_packet = tion._read_packet()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 684, in _read_packet
2021-10-21 19:14:49.926 2925 ption packet.check_error()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/protocol.py”, line 220, in check_error
2021-10-21 19:14:49.926 2925 ption err.raise_mysql_exception(self._data)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
2021-10-21 19:14:49.926 2925 ption raise errorclass(errno, errval)
2021-10-21 19:14:49.926 2925 DataError: (1406, “Data too long for column ‘exposed_ports’ at row 1”)
2021-10-21 19:14:49.926 2925 ption
2021-10-21 19:14:49.926 2925 ption The above exception was the direct cause of the following exception:
2021-10-21 19:14:49.926 2925 ption
2021-10-21 19:14:49.926 2925 ption Traceback (most recent call last):
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/common/exception.py”, line 110, in wrapped
2021-10-21 19:14:49.926 2925 ption return func(*args, **kwargs)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/api/validation/init.py”, line 55, in wrapper
2021-10-21 19:14:49.926 2925 ption return func(*args, **kwargs)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/api/validation/init.py”, line 33, in wrapper
2021-10-21 19:14:49.926 2925 ption return func(*args, **kwargs)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/api/controllers/v1/containers.py”, line 286, in post
2021-10-21 19:14:49.926 2925 ption return self._do_post(run, **container_dict)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/api/controllers/v1/containers.py”, line 413, in _do_post
2021-10-21 19:14:49.926 2925 ption ate(context)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/oslo_versionedobjects/base.py”, line 226, in wrapper
2021-10-21 19:14:49.926 2925 ption return fn(self, *args, **kwargs)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/objects/container.py”, line 239, in create
2021-10-21 19:14:49.926 2925 ption db_container = ate_container(context, values)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/osprofiler/profiler.py”, line 160, in wrapper
2021-10-21 19:14:49.926 2925 ption result = f(*args, **kwargs)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/db/api.py”, line 80, in create_container
2021-10-21 19:14:49.926 2925 ption return _get_dbdriver_instance().create_container(context, values)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/db/sqlalchemy/api.py”, line 204, in create_container
2021-10-21 19:14:49.926 2925 ption container.save()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/zun/db/sqlalchemy/models.py”, line 104, in save
2021-10-21 19:14:49.926 2925 ption super(ZunBase, self).save(session)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/oslo_db/sqlalchemy/models.py”, line 48, in save
2021-10-21 19:14:49.926 2925 ption session.flush()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py”, line 2459, in flush
2021-10-21 19:14:49.926 2925 ption self._flush(objects)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py”, line 2597, in _flush
2021-10-21 19:14:49.926 2925 llback(_capture_exception=True)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in exit
2021-10-21 19:14:49.926 2925 aise(exc_type, exc_value, exc_tb)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/compat.py”, line 153, in reraise
2021-10-21 19:14:49.926 2925 ption raise value
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py”, line 2557, in _flush
2021-10-21 19:14:49.926 2925 ption ute()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py”, line 422, in execute
2021-10-21 19:14:49.926 2925 ute(self)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py”, line 589, in execute
2021-10-21 19:14:49.926 2925 ption uow,
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py”, line 245, in save_obj
2021-10-21 19:14:49.926 2925 ption insert,
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py”, line 1138, in _emit_insert_statements
2021-10-21 19:14:49.926 2925 ption statement, params
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 988, in execute
2021-10-21 19:14:49.926 2925 ption return meth(self, multiparams, params)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py”, line 287, in _execute_on_connection
2021-10-21 19:14:49.926 2925 ption return connection._execute_clauseelement(self, multiparams, params)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1107, in _execute_clauseelement
2021-10-21 19:14:49.926 2925 ption distilled_params,
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1253, in _execute_context
2021-10-21 19:14:49.926 2925 ption e, statement, parameters, cursor, context
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1471, in _handle_dbapi_exception
2021-10-21 19:14:49.926 2925 ption util.raise_from_cause(newraise, exc_info)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/compat.py”, line 398, in raise_from_cause
2021-10-21 19:14:49.926 2925 ption reraise(type(exception), exception, tb=exc_tb, cause=cause)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/compat.py”, line 152, in reraise
2021-10-21 19:14:49.926 2925 ption raise value.with_traceback(tb)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1249, in _execute_context
2021-10-21 19:14:49.926 2925 ption cursor, statement, parameters, context
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/default.py”, line 552, in do_execute
2021-10-21 19:14:49.926 2925 ute(statement, parameters)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/cursors.py”, line 170, in execute
2021-10-21 19:14:49.926 2925 ption result = self._query(query)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/cursors.py”, line 328, in _query
2021-10-21 19:14:49.926 2925 ption conn.query(q)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 517, in query
2021-10-21 19:14:49.926 2925 ption self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 732, in _read_query_result
2021-10-21 19:14:49.926 2925 ad()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 1075, in read
2021-10-21 19:14:49.926 2925 ption first_packet = tion._read_packet()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/connections.py”, line 684, in _read_packet
2021-10-21 19:14:49.926 2925 ption packet.check_error()
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/protocol.py”, line 220, in check_error
2021-10-21 19:14:49.926 2925 ption err.raise_mysql_exception(self._data)
2021-10-21 19:14:49.926 2925 ption File “/usr/local/lib/python3.6/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
2021-10-21 19:14:49.926 2925 ption raise errorclass(errno, errval)
2021-10-21 19:14:49.926 2925 ption ption.DBDataError: (DataError) (1406, “Data too long for column ‘exposed_ports’ at row 1”)
2021-10-21 19:14:49.926 2925 ption [SQL: INSERT INTO container (created_at, updated_at, project_id, user_id, uuid, container_id, name, image, cpu, cpu_policy, cpuset, command, memory, status, status_reason, task_state, environment, workdir, ports, hostname, labels, meta, addresses, image_pull_policy, host, restart_policy, status_detail, interactive, tty, image_driver, websocket_url, websocket_token, security_groups, auto_remove, runtime, disk, auto_heal, capsule_id, started_at, privileged, healthcheck, exposed_ports, registry_id, container_type) VALUES (%(created_at)s, %(updated_at)s, %(project_id)s, %(user_id)s, %(uuid)s, %(container_id)s, %(name)s, %(image)s, %(cpu)s, %(cpu_policy)s, %(cpuset)s, %(command)s, %(memory)s, %(status)s, %(status_reason)s, %(task_state)s, %(environment)s, %(workdir)s, %(ports)s, %(hostname)s, %(labels)s, %(meta)s, %(addresses)s, %(image_pull_policy)s, %(host)s, %(restart_policy)s, %(status_detail)s, %(interactive)s, %(tty)s, %(image_driver)s, %(websocket_url)s, %(websocket_token)s, %(security_groups)s, %(auto_remove)s, %(runtime)s, %(disk)s, %(auto_heal)s, %(capsule_id)s, %(started_at)s, %(privileged)s, %(healthcheck)s, %(exposed_ports)s, %(registry_id)s, %(container_type)s)]
2021-10-21 19:14:49.926 2925 ption [parameters: {‘created_at’: datetime.datetime(2021, 10, 21, 11, 14, 49, 195735), ‘updated_at’: None, ‘project_id’: ‘cb5388a3555346d0b224b45a1fc0aa2e’, ‘user_id’: ‘8e949daa55634ef48777ecd989daa6ab’, ‘uuid’: ‘78a36eee-c370-4415-b473-4ad28425f94c’, ‘container_id’: None, ‘name’: ‘9be5e7ba0fb840ed9b36eed483c2af10’, ‘image’: ‘d30a9dbc-1f75-4179-8f66-cca641848277’, ‘cpu’: 2.0, ‘cpu_policy’: ‘shared’, ‘cpuset’: b’{}’, ‘command’: b’[]’, ‘memory’: ‘1024’, ‘status’: ‘Creating’, ‘status_reason’: None, ‘task_state’: None, ‘environment’: b’{“USERNAME”: “admin111”, “PASSWORD”: “ppp@ssw0rd”, “BASEPATH”: “/bbbbb001”, “HOOKJS”: “/obama.js”, “WEBPORT”: “4444/tcp”, “ssh_port”: “22/tcp”, “HTT … (4 characters truncated) … XY”: “6789/tcp”, “NAT_SERVER_TOKEN”: “e0ee37bf-1257-40fc-9682-0ac98e6f60b5”, “NAT_SERVER_ADDR”: “192.168.1.1”, “NAT_CLIENT_EXPOSE_PORT”: “5678-9999”}’, ‘workdir’: None, ‘ports’: b’[]’, ‘hostname’: ‘beef’, ‘labels’: b’{}’, ‘meta’: b’{}’, ‘addresses’: b’{}’, ‘image_pull_policy’: None, ‘host’: None, ‘restart_policy’: b’{}’, ‘status_detail’: None, ‘interactive’: 1, ‘tty’: 1, ‘image_driver’: ‘glance’, ‘websocket_url’: None, ‘websocket_token’: None, ‘security_groups’: b’[]’, ‘auto_remove’: 0, ‘runtime’: ‘runc’, ‘disk’: 5, ‘auto_heal’: 0, ‘capsule_id’: None, ‘started_at’: None, ‘privileged’: 1, ‘healthcheck’: b’{}’, ‘exposed_ports’: b’{“4444/tcp”: {}, “22/tcp”: {}, “6789/tcp”: {}, “5678/tcp”: {}, “5678/udp”: {}, “5679/tcp”: {}, “5679/udp”: {}, “5680/tcp”: {}, “5680/udp”: {}, "5681 … (138037 characters truncated) … : {}, “9995/udp”: {}, “9996/tcp”: {}, “9996/udp”: {}, “9997/tcp”: {}, “9997/udp”: {}, “9998/tcp”: {}, “9998/udp”: {}, “9999/tcp”: {}, “9999/udp”: {}}’, ‘registry_id’: None, ‘container_type’: 0}]
2021-10-21 19:14:49.926 2925 ption (Background on this error at: )
2021-10-21 19:14:49.926 2925 ption


解决方法:

一、查看数据库设计,限制数据长度,也就是限制端口暴露的个数或者端口的范围大小:

mysql -uroot -p
use zun;
show tables;
desc container;


可以看到 exposed_ports 字段类型为 text 类型,在mysql中不同类型支持的长度如下:

TINYTEXT 256 bytes
TEXT 65,535 bytes ~64kb
MEDIUMTEXT 16,777,215 bytes ~16MB
LONGTEXT 4,294,967,295 bytes ~4GB

因此,你可以手动修改对应的数据表字段类型,但是一般不建议这么做。
可以采用在应用层做限制,根据 text 字段的长度,可以计算出支持的端口个数或者范围。

二、把容器的端口暴露改为关联一个安全组,安全组中添加若干个安全组规则,从而避免容器调用直接提供的参数暴露长度限制。


人生总有那么几步路需要自己鼓起勇气走完~

本文发布于:2024-02-03 04:41:47,感谢您对本站的认可!

本文链接:https://www.4u4v.net/it/170690650748716.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:pymysql   err   exception   zun   common
留言与评论(共有 0 条评论)
   
验证码:

Copyright ©2019-2022 Comsenz Inc.Powered by ©

网站地图1 网站地图2 网站地图3 网站地图4 网站地图5 网站地图6 网站地图7 网站地图8 网站地图9 网站地图10 网站地图11 网站地图12 网站地图13 网站地图14 网站地图15 网站地图16 网站地图17 网站地图18 网站地图19 网站地图20 网站地图21 网站地图22/a> 网站地图23