$ podman volume create m57
|
m57
|
|
$ vi d/m57.sql
|
|
$ cat d/m57.sql
|
CREATE TABLESPACE space1 ADD DATAFILE 'space1f1.ibd';
|
CREATE TABLE t1 (i int) TABLESPACE space1;
|
SHOW CREATE TABLE t1;
|
INSERT INTO t1 VALUES (1),(2);
|
SELECT * FROM t1;
|
|
$ podman run -v m57:/var/lib/mysql -v ./d:/docker-entrypoint-initdb.d:Z -e MYSQL_ROOT_PASSWORD=bob -e MYSQL_DATABASE=test -e MYSQL_USER=test -e MYSQL_PASSWORD=test --rm mysql:5.7
|
2023-11-29 23:30:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
|
2023-11-29 23:30:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
|
2023-11-29 23:30:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
|
....
|
2023-11-29 23:30:52+00:00 [Note] [Entrypoint]: Creating database test
|
2023-11-29 23:30:52+00:00 [Note] [Entrypoint]: Creating user test
|
2023-11-29 23:30:53+00:00 [Note] [Entrypoint]: Giving user test access to schema test
|
|
2023-11-29 23:30:53+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/m57.sql
|
Table Create Table
|
t1 CREATE TABLE `t1` (\n `i` int(11) DEFAULT NULL\n) /*!50100 TABLESPACE `space1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
|
i
|
1
|
2
|
|
|
2023-11-29 23:30:53+00:00 [Note] [Entrypoint]: Stopping temporary server
|
....
|
2023-11-29T23:31:00.127796Z 0 [Note] mysqld: Shutdown complete
|
|
|
$ podman run -v m57:/var/lib/mysql/ -e MARIADB_AUTO_UPGRADE=1 --name m106 mariadb:10.6
|
2023-11-29 23:31:37+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.16+maria~ubu2004 started.
|
2023-11-29 23:31:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
|
2023-11-29 23:31:39+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.16+maria~ubu2004 started.
|
2023-11-29 23:31:40+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
|
2023-11-29 23:31:40+00:00 [Note] [Entrypoint]: Starting temporary server
|
2023-11-29 23:31:40+00:00 [Note] [Entrypoint]: Waiting for server startup
|
2023-11-29 23:31:40 0 [Note] Starting MariaDB 10.6.16-MariaDB-1:10.6.16+maria~ubu2004 source revision b83c379420a8846ae4b28768d3c81fa354cca056 as process 103
|
2023-11-29 23:31:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2023-11-29 23:31:40 0 [Note] InnoDB: Number of pools: 1
|
2023-11-29 23:31:40 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2023-11-29 23:31:40 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
|
2023-11-29 23:31:40 0 [Note] InnoDB: Using Linux native AIO
|
2023-11-29 23:31:40 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
2023-11-29 23:31:40 0 [Note] InnoDB: Completed initialization of buffer pool
|
2023-11-29 23:31:40 0 [Note] InnoDB: 128 rollback segments are active.
|
2023-11-29 23:31:40 0 [ERROR] InnoDB: Table test/t1 in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=161 SYS_TABLES.N_COLS=2147483649
|
2023-11-29 23:31:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2023-11-29 23:31:40 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2023-11-29 23:31:40 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2023-11-29 23:31:40 0 [Note] InnoDB: 10.6.16 started; log sequence number 12230849; transaction id 1794
|
2023-11-29 23:31:40 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2023-11-29 23:31:40 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
|
2023-11-29 23:31:40 0 [Note] mariadbd: ready for connections.
|
Version: '10.6.16-MariaDB-1:10.6.16+maria~ubu2004' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
|
2023-11-29 23:31:41+00:00 [Note] [Entrypoint]: Temporary server started.
|
2023-11-29 23:31:41+00:00 [Note] [Entrypoint]: Backing up system database to system_mysql_backup_unknown_version.sql.zst
|
2023-11-29 23:31:41+00:00 [Note] [Entrypoint]: Backing up complete
|
2023-11-29 23:31:41+00:00 [Note] [Entrypoint]: Starting mariadb-upgrade
|
The --upgrade-system-tables option was used, user tables won't be touched.
|
MariaDB upgrade detected
|
Phase 1/8: Checking and upgrading mysql database
|
Processing databases
|
mysql
|
mysql.columns_priv OK
|
mysql.db OK
|
mysql.engine_cost OK
|
mysql.event OK
|
mysql.func OK
|
mysql.gtid_executed OK
|
mysql.help_category OK
|
mysql.help_keyword OK
|
mysql.help_relation OK
|
mysql.help_topic OK
|
mysql.innodb_index_stats OK
|
mysql.innodb_table_stats OK
|
mysql.ndb_binlog_index OK
|
mysql.plugin OK
|
mysql.proc OK
|
mysql.procs_priv OK
|
mysql.proxies_priv OK
|
mysql.server_cost OK
|
mysql.servers OK
|
mysql.slave_master_info OK
|
mysql.slave_relay_log_info OK
|
mysql.slave_worker_info OK
|
mysql.tables_priv OK
|
mysql.time_zone OK
|
mysql.time_zone_leap_second OK
|
mysql.time_zone_name OK
|
mysql.time_zone_transition OK
|
mysql.time_zone_transition_type OK
|
mysql.user OK
|
Phase 2/8: Installing used storage engines... Skipped
|
Phase 3/8: Running 'mysql_fix_privilege_tables'
|
Phase 4/8: Fixing views from mysql
|
mysql.user OK
|
sys.host_summary OK
|
sys.host_summary_by_file_io OK
|
sys.host_summary_by_file_io_type OK
|
sys.host_summary_by_stages OK
|
sys.host_summary_by_statement_latency OK
|
sys.host_summary_by_statement_type OK
|
sys.innodb_buffer_stats_by_schema OK
|
sys.innodb_buffer_stats_by_table OK
|
sys.innodb_lock_waits OK
|
sys.io_by_thread_by_latency OK
|
sys.io_global_by_file_by_bytes OK
|
sys.io_global_by_file_by_latency OK
|
sys.io_global_by_wait_by_bytes OK
|
sys.io_global_by_wait_by_latency OK
|
sys.latest_file_io OK
|
sys.memory_by_host_by_current_bytes OK
|
sys.memory_by_thread_by_current_bytes OK
|
sys.memory_by_user_by_current_bytes OK
|
sys.memory_global_by_current_bytes OK
|
sys.memory_global_total OK
|
sys.metrics OK
|
sys.processlist OK
|
sys.ps_check_lost_instrumentation OK
|
sys.schema_auto_increment_columns OK
|
sys.schema_index_statistics OK
|
sys.schema_object_overview OK
|
sys.schema_redundant_indexes OK
|
sys.schema_table_lock_waits OK
|
sys.schema_table_statistics OK
|
sys.schema_table_statistics_with_buffer OK
|
sys.schema_tables_with_full_table_scans OK
|
sys.schema_unused_indexes OK
|
sys.session OK
|
sys.session_ssl_status OK
|
sys.statement_analysis OK
|
sys.statements_with_errors_or_warnings OK
|
sys.statements_with_full_table_scans OK
|
sys.statements_with_runtimes_in_95th_percentile OK
|
sys.statements_with_sorting OK
|
sys.statements_with_temp_tables OK
|
sys.user_summary OK
|
sys.user_summary_by_file_io OK
|
sys.user_summary_by_file_io_type OK
|
sys.user_summary_by_stages OK
|
sys.user_summary_by_statement_latency OK
|
sys.user_summary_by_statement_type OK
|
sys.version OK
|
sys.wait_classes_global_by_avg_latency OK
|
sys.wait_classes_global_by_latency OK
|
sys.waits_by_host_by_latency OK
|
sys.waits_by_user_by_latency OK
|
sys.waits_global_by_latency OK
|
sys.x$host_summary OK
|
sys.x$host_summary_by_file_io OK
|
sys.x$host_summary_by_file_io_type OK
|
sys.x$host_summary_by_stages OK
|
sys.x$host_summary_by_statement_latency OK
|
sys.x$host_summary_by_statement_type OK
|
sys.x$innodb_buffer_stats_by_schema OK
|
sys.x$innodb_buffer_stats_by_table OK
|
sys.x$innodb_lock_waits OK
|
sys.x$io_by_thread_by_latency OK
|
sys.x$io_global_by_file_by_bytes OK
|
sys.x$io_global_by_file_by_latency OK
|
sys.x$io_global_by_wait_by_bytes OK
|
sys.x$io_global_by_wait_by_latency OK
|
sys.x$latest_file_io OK
|
sys.x$memory_by_host_by_current_bytes OK
|
sys.x$memory_by_thread_by_current_bytes OK
|
sys.x$memory_by_user_by_current_bytes OK
|
sys.x$memory_global_by_current_bytes OK
|
sys.x$memory_global_total OK
|
sys.x$processlist OK
|
sys.x$ps_digest_95th_percentile_by_avg_us OK
|
sys.x$ps_digest_avg_latency_distribution OK
|
sys.x$ps_schema_table_statistics_io OK
|
sys.x$schema_flattened_keys OK
|
sys.x$schema_index_statistics OK
|
sys.x$schema_table_lock_waits OK
|
sys.x$schema_table_statistics OK
|
sys.x$schema_table_statistics_with_buffer OK
|
sys.x$schema_tables_with_full_table_scans OK
|
sys.x$session OK
|
sys.x$statement_analysis OK
|
sys.x$statements_with_errors_or_warnings OK
|
sys.x$statements_with_full_table_scans OK
|
sys.x$statements_with_runtimes_in_95th_percentile OK
|
sys.x$statements_with_sorting OK
|
sys.x$statements_with_temp_tables OK
|
sys.x$user_summary OK
|
sys.x$user_summary_by_file_io OK
|
sys.x$user_summary_by_file_io_type OK
|
sys.x$user_summary_by_stages OK
|
sys.x$user_summary_by_statement_latency OK
|
sys.x$user_summary_by_statement_type OK
|
sys.x$wait_classes_global_by_avg_latency OK
|
sys.x$wait_classes_global_by_latency OK
|
sys.x$waits_by_host_by_latency OK
|
sys.x$waits_by_user_by_latency OK
|
sys.x$waits_global_by_latency OK
|
Phase 5/8: Fixing table and database names ... Skipped
|
Phase 6/8: Checking and upgrading tables... Skipped
|
Phase 7/8: uninstalling plugins
|
Phase 8/8: Running 'FLUSH PRIVILEGES'
|
OK
|
2023-11-29 23:31:43+00:00 [Note] [Entrypoint]: Finished mariadb-upgrade
|
2023-11-29 23:31:43+00:00 [Note] [Entrypoint]: Stopping temporary server
|
2023-11-29 23:31:43 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
|
2023-11-29 23:31:43 0 [Note] InnoDB: FTS optimize thread exiting.
|
2023-11-29 23:31:43 0 [Note] InnoDB: Starting shutdown...
|
2023-11-29 23:31:43 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
|
2023-11-29 23:31:43 0 [Note] InnoDB: Shutdown completed; log sequence number 12246560; transaction id 1833
|
2023-11-29 23:31:43 0 [Note] mariadbd: Shutdown complete
|
|
2023-11-29 23:31:43+00:00 [Note] [Entrypoint]: Temporary server stopped
|
2023-11-29 23:31:43 0 [Note] Starting MariaDB 10.6.16-MariaDB-1:10.6.16+maria~ubu2004 source revision b83c379420a8846ae4b28768d3c81fa354cca056 as process 1
|
2023-11-29 23:31:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2023-11-29 23:31:43 0 [Note] InnoDB: Number of pools: 1
|
2023-11-29 23:31:43 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2023-11-29 23:31:43 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
|
2023-11-29 23:31:43 0 [Note] InnoDB: Using Linux native AIO
|
2023-11-29 23:31:43 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
2023-11-29 23:31:43 0 [Note] InnoDB: Completed initialization of buffer pool
|
2023-11-29 23:31:43 0 [Note] InnoDB: 128 rollback segments are active.
|
2023-11-29 23:31:43 0 [ERROR] InnoDB: Table test/t1 in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=161 SYS_TABLES.N_COLS=2147483649
|
2023-11-29 23:31:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2023-11-29 23:31:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2023-11-29 23:31:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2023-11-29 23:31:43 0 [Note] InnoDB: 10.6.16 started; log sequence number 12246560; transaction id 1828
|
2023-11-29 23:31:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
2023-11-29 23:31:43 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2023-11-29 23:31:43 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
|
2023-11-29 23:31:43 0 [Note] InnoDB: Buffer pool(s) load completed at 231129 23:31:43
|
2023-11-29 23:31:43 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2023-11-29 23:31:43 0 [Note] Server socket created on IP: '::'.
|
2023-11-29 23:31:43 0 [Note] mariadbd: ready for connections.
|
Version: '10.6.16-MariaDB-1:10.6.16+maria~ubu2004' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
|