mysql shutdown이 계속됩니다

Question

안녕하세요. ec2안에 docker로 mysql을 돌리고 있었는데 어느날 shutdown이 되어있었습니다. 그래서 mysql container를 삭제하고 다시 실행해보면, 또 며칠 뒤에 똑같이 shutdown 되어있었습니다. shutdown되는 이유는 다양할 것 같은데, 혹시 아래 2가지 중 문제가 있는 것이 있으면 말씀해주세요!docker-compose.ymlversion: &#34;3.9&#34; services: db: image: mysql:8.0.28 platform: linux/amd64 ports: - &#34;3306:3306&#34; environment: MYSQL_DATABASE: DB이름 MYSQL_ROOT_HOST: '%' MYSQL_ROOT_PASSWORD: root TZ: Asia/Seoul command: - --character-set-server&#61;utf8mb4 - --collation-server&#61;utf8mb4_unicode_ci - --lower_case_table_names&#61;1인바운드에서 열어둔 것?2 개가 확실한 문제인 것일까요? 아니면 그냥 보안적으로 문제있다. 이정도인건가요?아래는 mysql log입니다!2023-06-16T10:40:49.874554Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28) starting as process 12023-06-16T10:40:49.889729Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2023-06-16T10:40:50.311076Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2023-06-16T10:40:50.644169Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2023-06-16T10:40:50.644401Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2023-06-16T10:40:50.648004Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.2023-06-16T10:40:50.697737Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock2023-06-16T10:40:50.698137Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.mbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permittedmbind: Operation not permitted2023-06-17T16:04:05.875125Z 730 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.28).2023-06-17T16:04:07.951190Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 696 user: 'root'.2023-06-17T16:04:07.951679Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 697 user: 'root'.2023-06-17T16:04:07.951948Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 698 user: 'root'.2023-06-17T16:04:07.952239Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 690 user: 'root'.2023-06-17T16:04:07.952468Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 691 user: 'root'.2023-06-17T16:04:07.952750Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 699 user: 'root'.2023-06-17T16:04:07.953067Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 692 user: 'root'.2023-06-17T16:04:07.953307Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 693 user: 'root'.2023-06-17T16:04:07.953644Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 694 user: 'root'.2023-06-17T16:04:07.953912Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 695 user: 'root'.2023-06-17T16:04:13.411032Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28) MySQL Community Server - GPL.

scissors hand · Answer

에러 문구로 검색해 보면 다음과 같이 나오네요.[MYSQL] Docker MYSQL 로그에서 "mbind: Operation not permitted" 이슈 해결방법 (tistory.com)docker Mysql MBind : Operation Not permitted 오류 (velog.io)

mysql shutdown이 계속됩니다

1개의 답변

기술 목록