Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27074

container start-up to take a long time

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.6.5
    • 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6, 10.7.2
    • Docker
    • None
    • Windows 10, Docker Desktop for Windows WSLv2, AMD Ryzen 5800X CPU, 32GB 3600MHz DDR4, and 2TB Samsung 980 Pro PCI-E 4.0 x4 SSD

    Description

      On startup the image throws the following warnings, each of which seems to contribute to the container taking longer to finish start-up tasks, making full start-up take over a minute.

      Least impactful is the first warning-

      2021-11-17 20:47:02 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")

      This one is probably fine as-is, but if it can be addressed, would be nice.

      The bigger issues are these three-

      2021-11-17 20:47:07 0 [Note] mariadbd: ready for connections.
      		 
      Version: '10.6.5-MariaDB-1:10.6.5+maria~focal-log'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
      		 
      2021-11-17 20:47:07+00:00 [Note] [Entrypoint]: Temporary server started.
      		 
      Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
      		 
      Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
      		 
      Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
      		 
      2021-11-17 20:47:57 6 [Warning] 'proxies_priv' entry '@% root@3ca6dd5b620d' ignored in --skip-name-resolve mode.
      		 
      2021-11-17 20:47:57+00:00 [Note] [Entrypoint]: Creating database test
      		 
      2021-11-17 20:47:57+00:00 [Note] [Entrypoint]: Creating user tester
      		 
      2021-11-17 20:47:57+00:00 [Note] [Entrypoint]: Giving user tester access to schema test
      		 
      2021-11-17 20:47:57+00:00 [Note] [Entrypoint]: Stopping temporary server
      		 
      2021-11-17 20:47:57 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
      		 
      2021-11-17 20:47:57 0 [Note] InnoDB: FTS optimize thread exiting.

      Key here are the time stamps- it is 20:47:07 before the Warning: Unable to load... entries occur and then 20:47:57 after. It seems like the system waits for these to time out before proceeding.

      The amount of time here doesn't look significant, but this was a faster than typical run for this- it can take longer. It also feels inordinately long compared to when the temporary server starts up (and also quite long compared to Nginx and PHP-FPM container start-up times, making MariaDB the bottleneck for launching new EMP stacks). If we can resolve or work-around this issue, the MariaDB Docker container will feel much more responsive and yield a much improved user experience.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28103 container /docker-entrypoint-initdb.d sql on master doesn't replicate

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23326 aria TRANSACTIONAL=1 significantly slow on timezone intialisation (was: time zone initialision significantly slower in 10.4 compared to 10.3 (myisam))

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28188 Database initialization commands can be written into binary log with Docker

          • Major - Major loss of function.
          • Closed

          Activity

            People

              danblack Daniel Black
              rob.schwyzer@mariadb.com Rob Schwyzer (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.