Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unknown system variable 'innodb_file_format' #572

Open
susnick opened this issue Jan 3, 2025 · 6 comments
Open

Unknown system variable 'innodb_file_format' #572

susnick opened this issue Jan 3, 2025 · 6 comments

Comments

@susnick
Copy link

susnick commented Jan 3, 2025

Does this image not work with mysql v8?
@jcormier
Copy link
Collaborator

jcormier commented Jan 3, 2025

Could you provide any details? What tag of the docker image are you using? How are you starting the different docker images? Logs?

Does this image not work with mysql v8?

It does

@jcormier
Copy link
Collaborator

jcormier commented Jan 3, 2025

The latest docker tag launches just find with mysql8

$ docker compose -f docker-compose-mysql.yml up
[+] Running 13/13
 ✔ mysql Pulled                                                                                  8.8s
   ✔ fd674058ff8f Pull complete                                                                  1.9s
   ✔ aa12f7d8d896 Pull complete                                                                  2.2s
   ✔ 30f0a3b3870a Pull complete                                                                  2.6s
   ✔ e54e47c01863 Pull complete                                                                  3.0s
   ✔ bc572deb6e07 Pull complete                                                                  3.4s
   ✔ 7757eda5e705 Pull complete                                                                  4.3s
   ✔ 562073742226 Pull complete                                                                  4.7s
   ✔ 4dd9445023d3 Pull complete                                                                  5.0s
   ✔ 32d6ae1e671e Pull complete                                                                  7.0s
   ✔ 71316b073395 Pull complete                                                                  7.4s
   ✔ 1fd76318d7ba Pull complete                                                                  7.8s
   ✔ 781116e21f02 Pull complete                                                                  8.1s
[+] Running 3/3
 ✔ Network docker-redmine_default      Created                                                   0.2s
 ✔ Container docker-redmine-mysql-1    Created                                                   9.4s
 ✔ Container docker-redmine-redmine-1  Created                                                   0.8s
Attaching to mysql-1, redmine-1
mysql-1    | 2025-01-03 14:32:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1debian12 started.
mysql-1    | 2025-01-03 14:32:15+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-1    | 2025-01-03 14:32:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1debian12 started.
mysql-1    | 2025-01-03 14:32:15+00:00 [Note] [Entrypoint]: Initializing database files
mysql-1    | 2025-01-03T14:32:15.358377Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 81
mysql-1    | 2025-01-03T14:32:15.371002Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
redmine-1  | Initializing logdir...
redmine-1  | Initializing datadir...
redmine-1  | Generating OpenSSH client keys...
mysql-1    | 2025-01-03T14:32:16.121499Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
redmine-1  | Symlinking dotfiles...
redmine-1  | Installing configuration templates...
redmine-1  | Configuring redmine...
redmine-1  | Configuring redmine::database
mysql-1    | 2025-01-03T14:32:18.061642Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
mysql-1    | 2025-01-03 14:32:22+00:00 [Note] [Entrypoint]: Database files initialized
mysql-1    | 2025-01-03 14:32:22+00:00 [Note] [Entrypoint]: Starting temporary server
mysql-1    | 2025-01-03T14:32:22.496070Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 125
mysql-1    | 2025-01-03T14:32:22.513883Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql-1    | 2025-01-03T14:32:22.780322Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql-1    | 2025-01-03T14:32:23.101570Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql-1    | 2025-01-03T14:32:23.101597Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql-1    | 2025-01-03T14:32:23.137228Z 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.
mysql-1    | 2025-01-03T14:32:23.162485Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
mysql-1    | 2025-01-03T14:32:23.162565Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
mysql-1    | 2025-01-03 14:32:23+00:00 [Note] [Entrypoint]: Temporary server started.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
mysql-1    | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
mysql-1    | 2025-01-03 14:32:24+00:00 [Note] [Entrypoint]: GENERATED ROOT PASSWORD: l0oTKkn8SY6T1lMOriVujIF03ZSHyrfV
mysql-1    | 2025-01-03 14:32:24+00:00 [Note] [Entrypoint]: Creating database redmine_production
mysql-1    | 2025-01-03 14:32:24+00:00 [Note] [Entrypoint]: Creating user redmine
mysql-1    | 2025-01-03 14:32:24+00:00 [Note] [Entrypoint]: Giving user redmine access to schema redmine_production
mysql-1    |
mysql-1    | 2025-01-03 14:32:24+00:00 [Note] [Entrypoint]: Stopping temporary server
mysql-1    | 2025-01-03T14:32:24.557774Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
mysql-1    | 2025-01-03T14:32:26.081966Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40)  MySQL Community Server - GPL.
mysql-1    | 2025-01-03 14:32:26+00:00 [Note] [Entrypoint]: Temporary server stopped
mysql-1    |
mysql-1    | 2025-01-03 14:32:26+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
mysql-1    |
mysql-1    | 2025-01-03T14:32:26.827930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
mysql-1    | 2025-01-03T14:32:26.841186Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql-1    | 2025-01-03T14:32:27.100993Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql-1    | 2025-01-03T14:32:27.386555Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql-1    | 2025-01-03T14:32:27.386585Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql-1    | 2025-01-03T14:32:27.421320Z 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.
mysql-1    | 2025-01-03T14:32:27.447174Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
mysql-1    | 2025-01-03T14:32:27.447266Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
redmine-1  | ...........
redmine-1  | Checking transaction isolation level... READ-COMMITTED
redmine-1  | Configuring redmine::logger...
redmine-1  | Configuring redmine::puma...
redmine-1  | Configuring redmine::secret_token...
redmine-1  | Generating a session token...
redmine-1  | Note:
redmine-1  |   All old sessions will become invalid.
redmine-1  |   Please specify the REDMINE_SECRET_TOKEN parameter for persistence.
redmine-1  |   **SHOULD** be defined if you have a load-balancing Redmine cluster.
redmine-1  | Configuring redmine::max_concurrent_ajax_uploads...
redmine-1  | Configuring redmine::sudo_mode...
redmine-1  | Configuring redmine::autologin_cookie...
redmine-1  | Configuring redmine::backups...
redmine-1  | Configuring redmine::rmagic::font...
redmine-1  | Configuring redmine::avatar::url...
redmine-1  | Configuring nginx...
redmine-1  | Configuring nginx::redmine...
redmine-1  | New image version. Clearing cache
redmine-1  | Creating database...
redmine-1  | Database 'redmine_production' already exists
redmine-1  | Migrating database. Please be patient, this could take a while...
mysql-1    | 2025-01-03T14:32:55.928163Z 13 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
redmine-1  | Installing plugins...
redmine-1  | Installing gems required by plugins...
redmine-1  | You are replacing the current local value of without, which is currently "development:test"
redmine-1  | Migrating plugins. Please be patient, this could take a while...
redmine-1  | Installing themes...
redmine-1  | 2025-01-03 20:03:00,676 INFO Included extra file "/etc/supervisor/conf.d/cron.conf" during parsing
redmine-1  | 2025-01-03 20:03:00,683 INFO Included extra file "/etc/supervisor/conf.d/nginx.conf" during parsing
redmine-1  | 2025-01-03 20:03:00,683 INFO Included extra file "/etc/supervisor/conf.d/puma.conf" during parsing
redmine-1  | 2025-01-03 20:03:00,683 INFO Set uid to user 0 succeeded
redmine-1  | 2025-01-03 20:03:00,685 INFO RPC interface 'supervisor' initialized
redmine-1  | 2025-01-03 20:03:00,685 INFO supervisord started with pid 1
redmine-1  | 2025-01-03 20:03:01,688 INFO spawned: 'puma' with pid 389
redmine-1  | 2025-01-03 20:03:01,690 INFO spawned: 'cron' with pid 390
redmine-1  | 2025-01-03 20:03:01,691 INFO spawned: 'nginx' with pid 391
redmine-1  | 2025-01-03 20:03:02,981 INFO success: puma entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
redmine-1  | 2025-01-03 20:03:02,981 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
redmine-1  | 2025-01-03 20:03:02,981 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

@susnick
Copy link
Author

susnick commented Jan 3, 2025

Here is the compose file i was using.

version: '3.4'
services:
redmine:
image: sameersbn/redmine:6.0.2
environment:
DB_ADAPTER: mysql2
DB_HOST: atrprddb1
DB_NAME: cti-redmine
DB_USER: xxx
DB_PASS: xxxx
REDMINE_PORT: 3000
REDMINE_SECRET_TOKEN: xxxxx
volumes:
- redmine_data:/home/redmine/data
- redmine_logs:/var/log/redmine/
- /var/run/docker.sock:/var/run/docker.sock:ro
networks:
- traefik-public
logging:
driver: json-file
deploy:
labels:
traefik.http.routers.cti-http.rule: Host(issues.xxxx.io)
traefik.http.routers.cti-https.entrypoints: https
traefik.http.routers.cti-https.tls.certresolver: le
traefik.http.services.cti.loadbalancer.server.port: '3000'
traefik.http.routers.cti-http.entrypoints: http
traefik.http.routers.cti-http.middlewares: https-redirect
traefik.http.routers.cti-https.tls: 'true'
traefik.http.routers.cti-https.rule: Host(issues.xxxx.io)
traefik.constraint-label: traefik-public
traefik.docker.network: traefik-public
traefik.enable: 'true'
update_config:
order: start-first
placement:
constraints:
- node.role == worker
networks:
traefik-public:
external: true
volumes:
redmine_data:
driver: local
driver_opts:
device: :/mnt/data/containers/cti-redmine/redmine
o: addr=PRD-NAS-CR-L02,rw
type: nfs
redmine_logs:
driver: local
driver_opts:
device: :/mnt/data/containers/cti-redmine/redmine_logs
o: addr=PRD-NAS-CR-L02,rw
type: nfs

I have since moved to mysql 5.7 I have running, but now the image is giving another error message:
There was an error creating
/home/redmine/data/tmp/bundle/ruby/3.3.0/bundler.lock.
The underlying system error is Errno::ENOLCK: No locks available @ rb_file_flock

  • /home/redmine/data/tmp/bundle/ruby/3.3.0/bundler.lock

@jcormier
Copy link
Collaborator

jcormier commented Jan 3, 2025

I have since moved to mysql 5.7 I have running, but now the image is giving another error message:

https://www.redmine.org/projects/redmine/wiki/RedmineInstall
redmine 6 dropped support for MySQL 5.7

@susnick
Copy link
Author

susnick commented Jan 3, 2025

I don't know what to say, other than its working for me. Also the innodb_file_format was removed from mysql 8 which explains why it was not working for me. See https://dev.mysql.com/worklog/task/?id=7704

@jcormier
Copy link
Collaborator

jcormier commented Jan 4, 2025

I don't know what to say, other than its working for me. Also the innodb_file_format was removed from mysql 8 which explains why it was not working for me. See https://dev.mysql.com/worklog/task/?id=7704

yeah, but those settings are set on the server itself. There is no reference to that setting in this repo.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@susnick @jcormier