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

reading information_schema.plugins during --bootstrap - mtr error: mysql-test/var/tmp/#sql_4d64_0.MYI' (errno: 2 "No such file or directory")

    XMLWordPrintable

Details

    Description

      Add the following to scripts/mysql_system_tables.sql, (after the plugin table created) causes mtr to fail.

      SET @auth_socket_installed=(SELECT COUNT(*) FROM information_schema.plugins where plugin_name='unix_socket');
      

      result:

      10.2-6e63db265f9c81518a144a0d4e89ea0ce09b3bd3

      build-mariadb-server-10.2]$ mysql-test/mtr --mem  main.select
       
      Logging: /home/dan/repos/mariadb-server-10.2/mysql-test/mysql-test-run.pl  --mem main.select
      vardir: /home/dan/repos/build-mariadb-server-10.2/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/dan/repos/build-mariadb-server-10.2/mysql-test/var'...
       - symlinking 'var' to '/dev/shm/var_auto_fnCD'
      Checking supported features...
      MariaDB Version 10.2.16-MariaDB
       - SSL connections supported
      Collecting tests...
      Installing system database...
      mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
      Could not install system database from /home/dan/repos/build-mariadb-server-10.2/mysql-test/var/log/bootstrap.sql
      The /home/dan/repos/build-mariadb-server-10.2/mysql-test/var/log/bootstrap.log file contains:
      /home/dan/repos/build-mariadb-server-10.2/sql/mysqld --no-defaults --disable-getopt-prefix-matching --bootstrap --basedir=/home/dan/repos/mariadb-server-10.2 --datadir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/install.db --plugin-dir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/plugins --default-storage-engine=myisam --loose-skip-plugin-aria --loose-skip-plugin-feedback --loose-skip-plugin-innodb --loose-skip-plugin-innodb-buffer-page --loose-skip-plugin-innodb-buffer-page-lru --loose-skip-plugin-innodb-buffer-pool-stats --loose-skip-plugin-innodb-cmp --loose-skip-plugin-innodb-cmp-per-index --loose-skip-plugin-innodb-cmp-per-index-reset --loose-skip-plugin-innodb-cmp-reset --loose-skip-plugin-innodb-cmpmem --loose-skip-plugin-innodb-cmpmem-reset --loose-skip-plugin-innodb-ft-being-deleted --loose-skip-plugin-innodb-ft-config --loose-skip-plugin-innodb-ft-default-stopword --loose-skip-plugin-innodb-ft-deleted --loose-skip-plugin-innodb-ft-index-cache --loose-skip-plugin-innodb-ft-index-table --loose-skip-plugin-innodb-lock-waits --loose-skip-plugin-innodb-locks --loose-skip-plugin-innodb-metrics --loose-skip-plugin-innodb-mutexes --loose-skip-plugin-innodb-sys-columns --loose-skip-plugin-innodb-sys-datafiles --loose-skip-plugin-innodb-sys-fields --loose-skip-plugin-innodb-sys-foreign --loose-skip-plugin-innodb-sys-foreign-cols --loose-skip-plugin-innodb-sys-indexes --loose-skip-plugin-innodb-sys-semaphore-waits --loose-skip-plugin-innodb-sys-tables --loose-skip-plugin-innodb-sys-tablespaces --loose-skip-plugin-innodb-sys-tablestats --loose-skip-plugin-innodb-sys-virtual --loose-skip-plugin-innodb-tablespaces-encryption --loose-skip-plugin-innodb-tablespaces-scrubbing --loose-skip-plugin-innodb-trx --loose-skip-plugin-partition --loose-skip-plugin-sequence --loose-skip-plugin-user-variables --loose-innodb --loose-innodb-log-file-size=5M --disable-sync-frm --tmpdir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/tmp/ --core-file --console --lc-messages-dir=/home/dan/repos/build-mariadb-server-10.2/sql/share/ --character-sets-dir=/home/dan/repos/mariadb-server-10.2/sql/share/charsets
      2018-05-23 13:52:45 139701921904448 [Note] /home/dan/repos/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.16-MariaDB) starting as process 19812 ...
      2018-05-23 13:52:45 139701921904448 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
      2018-05-23 13:52:45 139701921904448 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'SEQUENCE' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'partition' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Uses event mutexes
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Using Linux native AIO
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Number of pools: 1
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Using SSE2 crc32 instructions
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Completed initialization of buffer pool
      2018-05-23 13:52:45 139701401270016 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: File './ibdata1' size is now 12 MB.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting log file ./ib_logfile101 size to 5242880 bytes
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting log file ./ib_logfile1 size to 5242880 bytes
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: New log files created, LSN=45790
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Doublewrite buffer not found: creating new
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Doublewrite buffer created
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating foreign key constraint system tables.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating tablespace and datafile system tables.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating sys_virtual system tables.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating shared tablespace for temporary tables
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Waiting for purge to start
      2018-05-23 13:52:45 139701921904448 [Note] InnoDB: 5.7.22 started; log sequence number 0
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'Aria' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_LOCKS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_MUTEXES' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMPMEM' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'FEEDBACK' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'user_variables' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TRX' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_METRICS' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
      2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
      ERROR: 1017  Can't find file: '/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/tmp/#sql_4d64_0.MYI' (errno: 2 "No such file or directory")
      2018-05-23 13:52:45 139701921904448 [ERROR] Aborting
      

      5.5-6a04c2a1aa60e67c07d4e6ada63f65cc3b26a5a9

      build-mariadb-server-5.5]$ mysql-test/mtr  --mem main.select
      Logging: /home/dan/repos/mariadb-server-5.5/mysql-test/mysql-test-run.pl  --mem main.select
      vardir: /home/dan/repos/build-mariadb-server-5.5/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/dan/repos/build-mariadb-server-5.5/mysql-test/var'...
       - symlinking 'var' to '/dev/shm/var_auto_K7Rs'
      Checking supported features...
      MariaDB Version 5.5.61-MariaDB
      Installing system database...
      mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
      Could not install system database from /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/bootstrap.sql
      see /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/log/bootstrap.log for errors
       
      build-mariadb-server-5.5]$ cat /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/log/bootstrap.log
      /home/dan/repos/build-mariadb-server-5.5/sql/mysqld --no-defaults --bootstrap --basedir=/home/dan/repos/mariadb-server-5.5 --datadir=/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/install.db --default-storage-engine=myisam --skip-aria --skip-innodb --skip-innodb-buffer-page --skip-innodb-buffer-page-lru --skip-innodb-buffer-pool-pages --skip-innodb-buffer-pool-pages-blob --skip-innodb-buffer-pool-pages-index --skip-innodb-buffer-pool-stats --skip-innodb-changed-pages --skip-innodb-cmp --skip-innodb-cmp-reset --skip-innodb-cmpmem --skip-innodb-cmpmem-reset --skip-innodb-index-stats --skip-innodb-lock-waits --skip-innodb-locks --skip-innodb-rseg --skip-innodb-sys-columns --skip-innodb-sys-fields --skip-innodb-sys-foreign --skip-innodb-sys-foreign-cols --skip-innodb-sys-indexes --skip-innodb-sys-stats --skip-innodb-sys-tables --skip-innodb-sys-tablestats --skip-innodb-table-stats --skip-innodb-trx --skip-innodb-undo-logs --skip-partition --skip-xtradb-admin-command --disable-sync-frm --tmpdir=/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/ --core-file --lc-messages-dir=/home/dan/repos/build-mariadb-server-5.5/sql/share/ --character-sets-dir=/home/dan/repos/mariadb-server-5.5/sql/share/charsets
      180523 13:58:31 [Note] /home/dan/repos/build-mariadb-server-5.5/sql/mysqld (mysqld 5.5.61-MariaDB) starting as process 19877 ...
      180523 13:58:31 [Note] Plugin 'Aria' is disabled.
      180523 13:58:31 [Note] Plugin 'InnoDB' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_RSEG' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_UNDO_LOGS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_TRX' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_CMP' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_CMPMEM' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_SYS_STATS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_TABLE_STATS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_INDEX_STATS' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES_INDEX' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES_BLOB' is disabled.
      180523 13:58:31 [Note] Plugin 'XTRADB_ADMIN_COMMAND' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_CHANGED_PAGES' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
      180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
      180523 13:58:31 [Note] Plugin 'partition' is disabled.
      ERROR: 1017  Can't find file: '/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/#sql_4da5_0' (errno: 20)
      180523 13:58:31 [ERROR] Aborting
       
      180523 13:58:31 [Note] /home/dan/repos/build-mariadb-server-5.5/sql/mysqld: Shutdown complete
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.