How to fix "mbind: Operation not permitted" in mysql error log

gamasexual :

I have a problem with my MySQL error log which currently mostly consists of "mbind: Operation not permitted" lines (see below). Why does it happen and how do I fix it?

It's the "mostly" part that bothers me. As you can see below, not all lines are "mbind: Operation not permitted". I suspect that MySQL query errors should be instead of that line, but for some reason they can't be written into the file.

MySQL itself is a Docker container where log files are volumed via:

volumes:
- ./mysql/log:/var/log/mysql

What's interesting is that:

  • "docker logs mysql_container" shows nothing...
  • slow.log, which resides in the same volume folder, is completely OK and has real slow log lines in it, no "mbind: Operation not permitted" whatsoever!
  • same as slow.log goes to general.log — no problem here, either

Any ideas? Thank you in advance.

2019-04-07T12:56:22.478504Z 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.
2019-04-07T12:56:22.478533Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2019-04-07T12:56:22.478605Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 1
2019-04-07T12:56:22.480115Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-04-07T12:56:22.480122Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
[same line goes forever]

P.S. MySQL starts and runs well, no problem with that. It's just this error.log that keeps bothering me and prevents me from seeing actual errors.

Laurent Gosselin :

Add the capability CAP_SYS_NICE to your container until MySQL server can handle the error itself "silently".

service:
  mysql:
    image: mysql:8.0.15
    # ...
    cap_add:
      - SYS_NICE  # CAP_SYS_NICE

References:

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

mbind: Operation not permitted when connecting with sequel pro

How to fix cpanel log in error?

MYSQL error 1064 ,how to fix it?

How to fix the error log not appearing at once?

How to log error queries in mysql?

How can I fix MySQL error #1064?

How to fix this MySql syntax error in PHP?

How to fix join error in mysql update query

How to fix error with MySQL because of timezone change?

how to fix "MySQL 1064 error Syntax Workbench"

How to fix mysql query syntax error

how can fix error 1064 mysql

How to fix this mysql create table syntax error

How do I fix this MYSQL//Phpmyadmin error?

How do I fix this manifest error in my ChueckSUR.log?

How to fix Error: laravel.log could not be opened?

How to fix Error: laravel.log could not be opened Permission denied?

How do I fix this design error on my log in page?

How to fix 'memmove' not declared error in log4cxx

How to Fix "A Database Error Occurred" in Codeigniter for IF condition in MySQL?

How to fix SQL syntax error using liquibase and mysql to create trigger

How do I fix the error when updating information in a MySQL table?

How to fix 'Can't connect to MySQL server on 'localhost:3306' error

How to fix duplicate key error while SET in MySQL

How to fix the error coming pip install MySQL-python

How to fix the the error in migration when migrating in mysql in django

How to fix error when dropping a Foreign key in MySQL table?

How to fix the error "unknown variable datadir" in mysql on raspbian?

How to fix ‘bind_param() ’ error in PHP with PDO mysql conection