分类：技术

MySQL 容器异常 - mbind: Operation not permitted

24-06-03 10:39 1004 0 技术

2024-06-03 09:23:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
2024-06-03 09:23:25+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-06-03 09:23:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
2024-06-03T09:23:25.944402Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2024-06-03T09:23:25.944530Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-06-03T09:23:25.944549Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27) starting as process 1
2024-06-03T09:23:25.970311Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-03T09:23:26.546899Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-03T09:23:26.881580Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2024-06-03T09:23:26.881612Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2024-06-03T09:23:26.899326Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-03T09:23:26.899366Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-03T09:23:26.989154Z 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.
2024-06-03T09:23:27.078117Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-06-03T09:23:27.078165Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted

这就是天天跑步的后果，希望大家引以为戒！

24-01-12 11:29 751 0 技术

最近三个月的体重稳定维持在118斤～122斤之间。

六年前我曾是一个将近150斤的油腻大胖子，而如今我变成了120斤的阳光小鲜肉！

我真是越活越倒退了，希望大家不要学我，一切遵循自然规律！
这些年我跑过的马拉松比赛

23-11-27 13:32 962 0 技术
2023 年七夕节快乐！

23-08-22 12:38 636 0 技术

13.14公里，配速5:20
2023年 520 / 521 打卡

23-05-21 12:38 686 0 技术
入职满 8 周年纪念日

23-01-20 12:38 567 0 技术
Undefined index: constraint_name 报错解决方法

22-12-09 16:32 610 0 技术

错误日志
```
[error][yii\base\ErrorException:8] yii\base\ErrorException: Undefined index: constraint_name in /path/to/vendor/yiisoft/yii2/db/mysql/Schema.php:394
```
原因

MySQL 8.0.21 中返回的列名大小写不一致，导致 Yii2 在获取数据库模式时出错。

解决方法
1. 编辑 common/config/main-local.php，设置 PDO 属性 PDO::ATTR_CASE => PDO::CASE_LOWER
```
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=db_name',
'username' => 'username',
'password' => '******',
'attributes' => [PDO::ATTR_CASE => PDO::CASE_LOWER],
],
```
2. 修改 /path/to/vendor/yiisoft/yii2/db/mysql/Schema.php:394
```
foreach ($rows as $row) {
$row = array_change_key_case($row, CASE_LOWER);
```
推荐第一种方法，使列名明确指定为一致的大小写。

参考文章：https://github.com/yiisoft/yii2/issues/18171
我也算是半个米粉吧！

22-08-09 14:28 508 0 技术
入职满 7 周年纪念日

22-01-20 12:38 614 0 技术
入职满 6 周年纪念日

21-01-20 12:38 600 0 技术