[ERROR] mysqldump-secure: 1937: return: Illegal number:

[dattapw]

Using devilbox. Tried running mysqldump-secure. Got error. Re-installed devilbox, imported SQL backup. Still getting the error. Please help.

devilbox@php-7.3.16 in /shared/httpd $ mysqldump-secure -v [DEBUG] (CFG): Using config: /etc/mysqldump-secure.conf [INFO] (OPT): Logging enabled [DEBUG] (OPT): Log level: 2 [DEBUG] (OPT): Log file: /var/log/mysqldump-secure.log [DEBUG] (CFG): Destination dir: /shared/backups/mysql [DEBUG] (CFG): Using file Prefix: 2020-06-24_10-43__ [INFO] (OPT): MySQL SSL connection disabled [INFO] (OPT): Compression enabled [DEBUG] (OPT): Compression arguments: gzip -9 -c [INFO] (OPT): Encryption disabled [INFO] (OPT): Deletion disabled [INFO] (OPT): Nagios log disabled [INFO] (OPT): Info files enabled [DEBUG] (SRV): MySQL server connection: mysql via TCP/IP [DEBUG] (SRV): MySQL server connection: Not using SSL (plain). [DEBUG] (SRV): MySQL server rep type: master [DEBUG] (SRV): MySQL server version: MySQL 8.0.19 MySQL Community Server - GPL [DEBUG] (SRV): MySQL server hostname: mysql:3306 [DEBUG] (SQL): Retrieving list of databases... 5 /usr/local/bin/mysqldump-secure: 1937: return: Illegal number:

[ianmjones]

Same problem for me, even after down, ./update-docker.sh, and then bringing back up.

devilbox@php-7.4.4 in /shared/httpd $ mysqldump-secure -vv
[DEBUG] (CFG): Using config: /etc/mysqldump-secure.conf
[INFO]  (OPT): Logging enabled
[DEBUG] (OPT): Log level: 2
[DEBUG] (OPT): Log file: /var/log/mysqldump-secure.log
[TRACE] (CFG): Using temporary directory: /tmp
[DEBUG] (CFG): Destination dir: /shared/backups/mysql
[DEBUG] (CFG): Using file Prefix: 2020-07-27_16-55__
[INFO]  (OPT): MySQL SSL connection disabled
[TRACE] (CFG): mysqldump custom options: --opt --default-character-set=utf8 --events --triggers --routines --hex-blob --complete-insert --extended-insert --compress
[TRACE] (CFG): mysqldump '--quick':      Applied to DB's >= 200 MB
[TRACE] (CFG): mysqldump '--skip-quick': Applied to DB's  < 200 MB
[TRACE] (CFG): InnoDB-only:  Dumping consistently across tables (using '--single-transaction')
[TRACE] (CFG): InnoDB-none:  Dumping consistently across tables (using '--lock-tables')
[TRACE] (CFG): InnoDB-mixed: Dumping consistently across tables (using '--lock-tables')
[TRACE] (CFG): Ignored DB's: information_schema performance_schema
[TRACE] (CFG): Required DB's: mysql
[INFO]  (OPT): Compression enabled
[DEBUG] (OPT): Compression arguments: gzip -9 -c
[INFO]  (OPT): Encryption disabled
[INFO]  (OPT): Deletion disabled
[INFO]  (OPT): Nagios log disabled
[INFO]  (OPT): Info files enabled
[TRACE] (RUN): MySQL connection test successful.
[DEBUG] (SRV): MySQL server connection: mysql via TCP/IP
[DEBUG] (SRV): MySQL server connection: Not using SSL (plain).
[DEBUG] (SRV): MySQL server rep type:   master
[DEBUG] (SRV): MySQL server version:    MySQL 8.0.19 MySQL Community Server - GPL
[DEBUG] (SRV): MySQL server hostname:   mysql:3306
[TRACE] (RUN): Creating tmp dir:  /tmp/mysqldump-secure.QQMyNF9B6u
[DEBUG] (SQL): Retrieving list of databases...  9
/usr/local/bin/mysqldump-secure: 1937: return: Illegal number:

Container and host info if it helps...

ian@ians-tuxedo:~/Projects/devilbox (master) $ docker ps -a
CONTAINER ID        IMAGE                             COMMAND                  CREATED             STATUS              PORTS                                          NAMES
c465be97bf62        memcached:1.5                     "docker-entrypoint.s…"   10 minutes ago      Up 10 minutes       127.0.0.1:11211->11211/tcp                     devilbox_memcd_1
2488983dc74f        mongo:4.2                         "docker-entrypoint.s…"   10 minutes ago      Up 10 minutes       127.0.0.1:27017->27017/tcp                     devilbox_mongo_1
7f293f06b573        postgres:12.1                     "docker-entrypoint.s…"   10 minutes ago      Up 10 minutes       127.0.0.1:5432->5432/tcp                       devilbox_pgsql_1
42ef81361abb        devilbox/mysql:mysql-8.0-0.4      "docker-entrypoint.s…"   10 minutes ago      Up 10 minutes       127.0.0.1:3306->3306/tcp, 33060/tcp            devilbox_mysql_1
186c89bbdfa1        redis:5.0                         "docker-entrypoint.s…"   10 minutes ago      Up 10 minutes       127.0.0.1:6379->6379/tcp                       devilbox_redis_1
3291c6826bbc        devilbox/apache-2.4:0.32          "/docker-entrypoint.…"   10 minutes ago      Up 10 minutes       127.0.0.1:80->80/tcp, 127.0.0.1:443->443/tcp   devilbox_httpd_1
38eedb9e6c05        devilbox/php-fpm:7.4-work-0.106   "/docker-entrypoint.…"   10 minutes ago      Up 10 minutes       9000/tcp                                       devilbox_php_1
17db1a1f1914        cytopia/bind:0.15                 "/docker-entrypoint.…"   10 minutes ago      Up 10 minutes       127.0.0.1:53->53/tcp, 127.0.0.1:53->53/udp     devilbox_bind_1

ian@ians-tuxedo:~/Projects/devilbox (master) $ uname -a
Linux ians-tuxedo 5.3.0-62-generic #56~18.04.1-Ubuntu SMP Wed Jun 24 16:17:03 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

[fibis]

Will there be a fix for this in the near future?

[robots4life]

?

[fibis]

Am So., Feb. 6, 2022 at 14:06 schrieb @.***>:

?

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.***>

[jrbecart]

Since the fix was never released, to fix it yourself just change the line: 1930 from _query="SELECT IF(COUNT(*) = 0, '0', '1') AS empty to _query="SELECT IF(COUNT(*) = 0, '0', '1') AS is_empty

Then

./configure
make
sudo make reinstall

[muratyarali]

what is the latest progress on this error? I am getting same one.