# Docker upgrade from 4.0.0 to 4.0.1 or 4.0.2 fails with mysql error
**URL:** https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997
**Category:** CMS Installation
**Created:** [September 12, 2023, 4:21pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997 "2023-09-12T16:21:24Z")
**Posts on this page:** 11
**Page:** 2
### Author:  [@pp\_browser](https://community.xibo.org.uk/u/pp_browser)
#### Post date: [September 29, 2023, 12:45pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/21 "2023-09-29T12:45:34Z")
Thank you.
Dan asked me mysql logs a few weeks ago. Here are the results
Same logs between 4.0.0 and 4.0.2 version
**root@s001linux03:/opt/xibo# docker-compose ps**
Name Command State Ports
xibo\_cms-db\_1 docker-entrypoint.sh mysqld Up 3306/tcp, 33060/tcp
xibo\_cms-memcached\_1 docker-entrypoint.sh memca … Up 11211/tcp
xibo\_cms-quickchart\_1 yarn start Up 3400/tcp
xibo\_cms-web\_1 /entrypoint.sh Up 0.0.0.0:8080-\>80/tcp,:::8080-\>80/tcp
xibo\_cms-xmr\_1 docker-php-entrypoint /ent … Up 50001/tcp, 0.0.0.0:9505-\>9505/tcp,:::9505-\>9505/tcp
**docker-compose logs -f cms-db**
**(returns many lines like these)**
cms-db\_1 | 2023-09-11T04:53:54.536445Z 67143 [Warning] [MY-013360] [Server] Plugin mysql\_native\_password reported: ‘‘mysql\_native\_password’ is deprecated and will be removed in a future release. Please use caching\_sha2\_password instead’
cms-db\_1 | 2023-09-11T04:53:55.136175Z 67144 [Warning] [MY-013360] [Server] Plugin mysql\_native\_password reported: ‘‘mysql\_native\_password’ is deprecated and will be removed in a future release. Please use caching\_sha2\_password instead’
---
### Author:  [@natasha](https://community.xibo.org.uk/u/natasha)
#### Post date: [September 29, 2023, 1:46pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/22 "2023-09-29T13:46:30Z")
Can you provide logs after the recent changes have been made and ensure that you provide all of the log messages?
Thank you
---
### Author:  [@pp\_browser](https://community.xibo.org.uk/u/pp_browser)
#### Post date: [September 29, 2023, 2:00pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/23 "2023-09-29T14:00:08Z")
Here are the logs after upgrade 4.0.0 to 4.0.3
cms-db\_1 | 2023-09-29 13:58:21+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:23+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:24.823467Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:24.834195Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:24.872883Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:25.530880Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:25.530926Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:25.634780Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:25.634976Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:25.634997Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:25.635859Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:27+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:28.608747Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:28.612874Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:28.628004Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:28.977947Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:28.977995Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:29.270216Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:29.270518Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:29.270545Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:29.271154Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:30+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:30+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:30+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:31.771378Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:31.774089Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:31.785395Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:32.116384Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:32.116630Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:32.411507Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:32.411680Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:32.411696Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:32.412225Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:33+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:34+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:34+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:35.696423Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:35.699169Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:35.711567Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:35.882279Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:35.882331Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:36.291475Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:36.291840Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:36.291990Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:36.292701Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:38+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:39.226699Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:39.230022Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:39.249623Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:39.506665Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:39.506911Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:39.896147Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:39.896379Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:39.896410Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:39.896963Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:42+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:43.519550Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:43.524558Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:43.539409Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:43.698500Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:43.698544Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:44.109412Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:44.109813Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:44.109927Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:44.110647Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:48+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:58:49.998862Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:58:50.001749Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:58:50.012742Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:58:50.234813Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:58:50.234863Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:58:50.627152Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:58:50.628083Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:58:50.628668Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:58:50.630657Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
cms-db\_1 | 2023-09-29 13:58:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | 2023-09-29 13:58:58+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db\_1 | 2023-09-29 13:58:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db\_1 | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
cms-db\_1 | 2023-09-29T13:59:00.340559Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host\_cache\_size=0 instead.
cms-db\_1 | 2023-09-29T13:59:00.346664Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db\_1 | 2023-09-29T13:59:00.368676Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db\_1 | 2023-09-29T13:59:00.804673Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
cms-db\_1 | 2023-09-29T13:59:00.805156Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db\_1 | 2023-09-29T13:59:01.032996Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db\_1 | 2023-09-29T13:59:01.033177Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db\_1 | 2023-09-29T13:59:01.033202Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db\_1 | 2023-09-29T13:59:01.033996Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
---
### Author:  [@natasha](https://community.xibo.org.uk/u/natasha)
#### Post date: [September 29, 2023, 2:46pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/24 "2023-09-29T14:46:42Z")
The database is still in MySQL 5.6 format which needs to be upgraded to MySQL 5.7 before you can upgrade to MySQL 8.
Down the containers and follow this: [Xibo CMS 2.3.10 Released - #2 by alex](https://community.xibo.org.uk/t/xibo-cms-2-3-10-released/24844/2)
Bring them up again and that should fix it.
---
### Author:  [@pp\_browser](https://community.xibo.org.uk/u/pp_browser)
#### Post date: [September 29, 2023, 3:30pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/25 "2023-09-29T15:30:50Z")
I get an error
It tried this and it doesn’t work neither
I tried with mysqld --user=root --skip-grant-tables &
but failure again
root@9d66dd614b30:/# mysqld --user=root --skip-grant-tables &
[1] 36
root@9d66dd614b30:/# 2023-09-29T15:36:18.353276Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
2023-09-29T15:36:18.355749Z 0 [Note] mysqld (mysqld 5.7.34) starting as process 36 …
2023-09-29T15:36:18.359750Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-09-29T15:36:18.359774Z 0 [Note] InnoDB: Mutexes and rw\_locks use GCC atomic builtins
2023-09-29T15:36:18.359780Z 0 [Note] InnoDB: Uses event mutexes
2023-09-29T15:36:18.359786Z 0 [Note] InnoDB: GCC builtin \_\_atomic\_thread\_fence() is used for memory barrier
2023-09-29T15:36:18.359836Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-29T15:36:18.359865Z 0 [Note] InnoDB: Using Linux native AIO
2023-09-29T15:36:18.360720Z 0 [Note] InnoDB: Number of pools: 1
2023-09-29T15:36:18.361134Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-09-29T15:36:18.364546Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-09-29T15:36:18.377043Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-29T15:36:18.380418Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-09-29T15:36:18.392351Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4000!
2023-09-29 15:36:18 0x7fd8a663b740 InnoDB: Assertion failure in thread 140568481216320 in file ut0ut.cc line 921
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to [http://bugs.mysql.com](http://bugs.mysql.com).
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: [http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html](http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html)
InnoDB: about forcing recovery.
15:36:18 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key\_buffer\_size=8388608
read\_buffer\_size=131072
max\_used\_connections=0
max\_threads=151
thread\_count=0
connection\_count=0
It is possible that mysqld could use up to
key\_buffer\_size + (read\_buffer\_size + sort\_buffer\_size)\*max\_threads = 68197 K bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong…
stack\_bottom = 0 thread\_stack 0x40000
mysqld(my\_print\_stacktrace+0x2c)[0x55885fd004fc]
mysqld(handle\_fatal\_signal+0x501)[0x55885f61dff1]
/lib/x86\_64-linux-gnu/libpthread.so.0(+0x12730)[0x7fd8a6b9c730]
/lib/x86\_64-linux-gnu/libc.so.6(gsignal+0x10b)[0x7fd8a66777bb]
/lib/x86\_64-linux-gnu/libc.so.6(abort+0x121)[0x7fd8a6662535]
mysqld(+0x6c1f13)[0x55885f5e4f13]
mysqld(+0x6c22f1)[0x55885f5e52f1]
mysqld(+0x11ab32c)[0x5588600ce32c]
mysqld(+0x11ab95e)[0x5588600ce95e]
mysqld(_Z6fil\_ioRK9IORequestbRK9page\_id\_tRK11page\_size\_tmmPvS8_+0x312)[0x5588600d6462]
mysqld(+0x116bce8)[0x55886008ece8]
mysqld(\_Z13buf\_read\_pageRK9page\_id\_tRK11page\_size\_t+0x31)[0x55886008f311]
mysqld(\_Z16buf\_page\_get\_genRK9page\_id\_tRK11page\_size\_tmP11buf\_block\_tmPKcmP5mtr\_tb+0x409)[0x558860063249]
mysqld(\_Z31trx\_rseg\_get\_n\_undo\_tablespacesPm+0x13e)[0x5588600000de]
mysqld(+0x10aed87)[0x55885ffd1d87]
mysqld(\_Z34innobase\_start\_or\_create\_for\_mysqlv+0x2f67)[0x55885ffd5947]
mysqld(+0xf85080)[0x55885fea8080]
mysqld(\_Z24ha\_initialize\_handlertonP13st\_plugin\_int+0x55)[0x55885f66fa45]
mysqld(+0xbd9326)[0x55885fafc326]
mysqld(\_Z40plugin\_register\_builtin\_and\_init\_core\_sePiPPc+0x1dc)[0x55885fafe1fc]
mysqld(+0x6f580e)[0x55885f61880e]
mysqld(\_Z11mysqld\_mainiPPc+0x758)[0x55885f619c78]
/lib/x86\_64-linux-gnu/libc.so.6(\_\_libc\_start\_main+0xeb)[0x7fd8a666409b]
mysqld(\_start+0x2a)[0x55885f60ecba]
The manual page at [http://dev.mysql.com/doc/mysql/en/crashing.html](http://dev.mysql.com/doc/mysql/en/crashing.html) contains
information that should help you find out what is causing the crash.
---
### Author:  [@dan](https://community.xibo.org.uk/u/dan)
#### Post date: [October 2, 2023, 1:23pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/26 "2023-10-02T13:23:59Z")
The instructions in the link Natasha sent over are for if you’re using MySQL 5.7. I think you’re using MySQL 8.0 which we supply in the docker files.
In that case the first instruction is slightly different:
```auto
docker run --rm -ti -v /opt/xibo/shared/db:/var/lib/mysql mysql:8.0 bash
```
We have another case we’re looking at where the user gets the following logs running the instructions in the link, with a MySQL 8.0 container:
```auto
bash-4.4# mysqld --skip-grant-tables &
[1] 8
bash-4.4# 2023-10-02T12:21:54.620768Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-10-02T12:21:54.622328Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 8
2023-10-02T12:21:54.631248Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-02T12:21:55Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=6b049f17400f850658b2eb3ff165ec9a085d9655
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213de91]
/usr/sbin/mysqld(print_fatal_signal(int)+0x387) [0xfdeac7]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xfdeb85]
/lib64/libpthread.so.0(+0x12d00) [0x7fbe7a52bd00]
/usr/sbin/mysqld(page_cur_insert_rec_low(unsigned char*, dict_index_t*, unsigned char const*, unsigned long*, mtr_t*)+0x62e) [0x233806e]
/usr/sbin/mysqld(page_cur_parse_insert_rec(bool, unsigned char const*, unsigned char const*, buf_block_t*, dict_index_t*, mtr_t*)+0x80d) [0x233b32d]
/usr/sbin/mysqld() [0x2304d8c]
/usr/sbin/mysqld(recv_recover_page_func(bool, buf_block_t*)+0x69b) [0x23084bb]
/usr/sbin/mysqld(buf_page_io_complete(buf_page_t*, bool)+0x39f) [0x24a3f5f]
/usr/sbin/mysqld(fil_aio_wait(unsigned long)+0x166) [0x25ab476]
/usr/sbin/mysqld() [0x23def78]
/usr/sbin/mysqld(std::thread::_State_impl > >::_M_run()+0xb6) [0x23df956]
/lib64/libstdc++.so.6(+0xc2ba3) [0x7fbe794b9ba3]
/lib64/libpthread.so.0(+0x81da) [0x7fbe7a5211da]
/lib64/libc.so.6(clone+0x43) [0x7fbe78acfe73]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
```
We’re trying to understand why
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [October 2, 2023, 2:07pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/27 "2023-10-02T14:07:20Z")
Sorry but it’s correct to be running the MySQL 5.7 container here. We’re trying to upgrade MySQL 5.6 to 5.7 before running MySQL 8. Please don’t run MySQL 8 against the data at this point.
We know that’s the case because of the log line:
```auto
cms-db_1 | 2023-09-29T13:58:25.530880Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (v0). The redo log was created before MySQL 5.7.9
```
which tells us the database files are in MySQL 5.6 format.
The error you get comes from a change in the MySQL 5.7 containers. You need to make a small change.
```auto
mysqld --user=mysql --skip-grant-tables &
```
Although I think it should work as documented with the latest mysql:5.7 container, so you might instead do
```auto
docker pull mysql:5.7
```
to ensure you have the latest container version and then try as documented rather than with the modification shown above.
Then continue with the steps given before - ie
```auto
mysql_upgrade
exit
```
then upgrade to 4.x with MySQL 8.0.
> [@dan](#):
>
> We have another case we’re looking at where the user gets the following logs running the instructions in the link, with a MySQL 8.0 container:
I don’t think that error is related to this case.
---
### Author:  [@pp\_browser](https://community.xibo.org.uk/u/pp_browser)
#### Post date: [December 12, 2023, 4:56pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/28 "2023-12-12T16:56:53Z")
Hi,
do you have news about this issue ? Xibo is still in version 4.0.0 and i’m unable to upgrade to 4.0.1, …,4.0.6
Unable to upgrade mysql with mysql\_upgrade
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [December 12, 2023, 5:10pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/29 "2023-12-12T17:10:47Z")
If you still can’t get it to work then I would take your pre-upgrade backup, dump the data with mysqldump, stop the containers, move `shared/db` to `shared/db_old`, and put your database dump as `shared/backup/import.sql`.
Then do the upgrade, and your backup will be loaded in to a clean MySQL database and it should all be fine from there.
---
### Author:  [@wojb](https://community.xibo.org.uk/u/wojb)
#### Post date: [January 25, 2024, 10:09pm UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/30 "2024-01-25T22:09:57Z")
Hello. Only for the purpose of replying to this thread I created account on this platform. I hope that this post would save hours of hairpulling for others.
I struggled for 2 days with fixing my issue, which looked exactly like @pp_browser . I could login to mysql DB, all pings were OK.
The magic trick that fixed my issue was adding ‘–remove-orphans’ at the end of ‘up’ command. So the magic command was:
> docker-compose up -d --remove-orphans
After that - Boom! . New version installed.
An interesting fact is that, every upgrade between v3 versions were OK ( 3.3.3 → 3.3.7 → 3.3.8 → 3.3.9), but every upgrade between v3 and v4 was a failure (3.3.3 → 4.0.0 , 3.3.3 → 4.0.6 , 3.3.7 → 4.0.0 etc.).
---
### Author:  [@system](https://community.xibo.org.uk/u/system)
#### Post date: [April 26, 2024, 4:10am UTC](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997/31 "2024-04-26T04:10:15Z")
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.
[Previous page](https://community.xibo.org.uk/t/docker-upgrade-from-4-0-0-to-4-0-1-or-4-0-2-fails-with-mysql-error/29997.md?page=1)