Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ rm -rf data
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysqld --no-defaults --basedir=. --datadir=/home/sbester/mysql/release/mysql-5.7.19-linux-glibc2.12-x86_64/data --initialize-insecure --console
- 2017-10-13T13:42:42.648791Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2017-10-13T13:42:44.479644Z 0 [Warning] InnoDB: New log files created, LSN=45790
- 2017-10-13T13:42:44.944578Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2017-10-13T13:42:45.067777Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 648dcdc7-b01c-11e7-ba30-080027e87879.
- 2017-10-13T13:42:45.079749Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
- 2017-10-13T13:42:45.086632Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysqld --no-defaults --basedir=. --datadir=/home/sbester/mysql/release/mysql-5.7.19-linux-glibc2.12-x86_64/data --console &
- [1] 10172
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysql -uroot -e"create database test;"
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysql -uroot test --force <./bin/test.sql
- [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysqladmin shutdown -uroot
- startup 8.0.3 :
- ------------------
- [sbester@localhost mysql-8.0.3-rc-linux-glibc2.12-x86_64]$ ./bin/mysqld --no-defaults --basedir=. --datadir=/home/sbester/mysql/release/mysql-5.7.19-linux-glibc2.12-x86_64/data --console
- 2017-10-13T13:51:32.090767Z 0 [Note] Basedir set to /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/
- 2017-10-13T13:51:32.091675Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
- 2017-10-13T13:51:32.091775Z 0 [Note] /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.3-rc-log) starting as process 10309 ...
- 2017-10-13T13:51:32.099688Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.
- 2017-10-13T13:51:32.136593Z 0 [Note] InnoDB: Using Linux native AIO
- 2017-10-13T13:51:32.136801Z 0 [Note] Plugin 'FEDERATED' is disabled.
- 2017-10-13T13:51:32.145760Z 1 [Note] Starting upgrade on data directory.
- 2017-10-13T13:51:32.145876Z 1 [Note] InnoDB: PUNCH HOLE support available
- 2017-10-13T13:51:32.145935Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-10-13T13:51:32.146472Z 1 [Note] InnoDB: Uses event mutexes
- 2017-10-13T13:51:32.146524Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2017-10-13T13:51:32.146575Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
- 2017-10-13T13:51:32.151431Z 1 [Note] InnoDB: Number of pools: 1
- 2017-10-13T13:51:32.151764Z 1 [Note] InnoDB: Using CPU crc32 instructions
- 2017-10-13T13:51:32.155718Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
- 2017-10-13T13:51:32.178753Z 1 [Note] InnoDB: Completed initialization of buffer pool
- 2017-10-13T13:51:32.216459Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
- 2017-10-13T13:51:32.237494Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
- 2017-10-13T13:51:32.237589Z 1 [Note] InnoDB: Apply batch completed!
- 2017-10-13T13:51:32.240458Z 1 [Note] InnoDB: Upgrading redo log: 2*3072 pages, LSN=57364015
- 2017-10-13T13:51:32.350656Z 1 [Note] InnoDB: Starting to delete and rewrite log files.
- 2017-10-13T13:51:32.378674Z 1 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2017-10-13T13:51:33.080886Z 1 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2017-10-13T13:51:33.978605Z 1 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2017-10-13T13:51:33.978878Z 1 [Note] InnoDB: New log files created, LSN=57364015
- 2017-10-13T13:51:33.995608Z 1 [Note] InnoDB: Expected to open 2 undo tablespaces but found none. Will create 2 new undo tablespaces.
- 2017-10-13T13:51:34.008551Z 1 [Note] InnoDB: Creating UNDO Tablespace ./undo_001
- 2017-10-13T13:51:34.008627Z 1 [Note] InnoDB: Setting file ./undo_001 size to 10 MB
- 2017-10-13T13:51:34.008674Z 1 [Note] InnoDB: Physically writing the file full
- 2017-10-13T13:51:34.156889Z 1 [Note] InnoDB: Creating UNDO Tablespace ./undo_002
- 2017-10-13T13:51:34.156966Z 1 [Note] InnoDB: Setting file ./undo_002 size to 10 MB
- 2017-10-13T13:51:34.157630Z 1 [Note] InnoDB: Physically writing the file full
- 2017-10-13T13:51:34.388715Z 1 [Note] InnoDB: Created 2 undo tablespaces.
- 2017-10-13T13:51:34.744924Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
- 2017-10-13T13:51:34.746605Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
- 2017-10-13T13:51:34.879551Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
- 2017-10-13T13:51:35.047407Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
- 2017-10-13T13:51:35.391234Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
- 2017-10-13T13:51:35.835364Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
- 2017-10-13T13:51:35.837600Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 0
- 2017-10-13T13:51:38.665676Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/sbester/mysql/release/mysql-5.7.19-linux-glibc2.12-x86_64/data/ib_buffer_pool
- 2017-10-13T13:51:40.333587Z 1 [Note] Created Data Dictionary for upgrade
- 2017-10-13T13:51:59.778455Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171013 15:51:59
- 2017-10-13T13:53:53.444899Z 2 [ERROR] InnoDB: Assertion failure: dict0dict.cc:1331:table2 == NULL
- InnoDB: thread 139746059917056
- InnoDB: We intentionally generate a memory trap.
- InnoDB: Submit a detailed bug report to 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 13:53:53 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=1
- connection_count=0
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68136 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x6959720
- 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 = 7f192a428dc8 thread_stack 0x46000
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(my_print_stacktrace+0x2e) [0x196899e]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(handle_fatal_signal+0x4c1) [0xea3fd1]
- /lib64/libpthread.so.0(+0xf130) [0x7f193747f130]
- /lib64/libc.so.6(gsignal+0x37) [0x7f1935df85d7]
- /lib64/libc.so.6(abort+0x148) [0x7f1935df9cc8]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0xa234c6]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*)+0x300) [0x1cd6810]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1cffa92]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dict_load_table(char const*, bool, dict_err_ignore_t)+0x7ba) [0x1d0027a]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1d007cf]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dict_load_foreigns(char const*, char const**, bool, bool, dict_err_ignore_t, std::deque<char const*, ut_allocator<char const*> >&)+0x128) [0x1cfb898]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1cff916]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dict_load_table(char const*, bool, dict_err_ignore_t)+0x7ba) [0x1d0027a]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t)+0x1b0) [0x1cdc900]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dd_upgrade_table(THD*, char const*, char const*, dd::Table*, TABLE*)+0xa0) [0x1d1bc30]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x117aba7]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dd::upgrade::migrate_all_frm_to_dd(THD*, char const*, bool)+0x409) [0x117c039]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(dd::upgrade::fill_dd_and_finalize(THD*)+0xb4) [0xe83d04]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0xf3f703]
- /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x198e61f]
- /lib64/libpthread.so.0(+0x7df5) [0x7f1937477df5]
- /lib64/libc.so.6(clone+0x6d) [0x7f1935eb960d]
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (0): Connection ID (thread ID): 2
- Status: NOT_KILLED
- 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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement