Advertisement
Guest User

Untitled

a guest
Oct 13th, 2017
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.59 KB | None | 0 0
  1. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ rm -rf data
  2. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
  3. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
  4. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
  5. [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
  6. 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).
  7. 2017-10-13T13:42:44.479644Z 0 [Warning] InnoDB: New log files created, LSN=45790
  8. 2017-10-13T13:42:44.944578Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
  9. 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.
  10. 2017-10-13T13:42:45.079749Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
  11. 2017-10-13T13:42:45.086632Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
  12. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$
  13.  
  14.  
  15. [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 &
  16. [1] 10172
  17.  
  18.  
  19. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysql -uroot -e"create database test;"
  20. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysql -uroot test --force <./bin/test.sql
  21.  
  22. [sbester@localhost mysql-5.7.19-linux-glibc2.12-x86_64]$ ./bin/mysqladmin shutdown -uroot
  23.  
  24. startup 8.0.3 :
  25. ------------------
  26.  
  27. [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
  28. 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/
  29. 2017-10-13T13:51:32.091675Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
  30. 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 ...
  31. 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.
  32. 2017-10-13T13:51:32.136593Z 0 [Note] InnoDB: Using Linux native AIO
  33. 2017-10-13T13:51:32.136801Z 0 [Note] Plugin 'FEDERATED' is disabled.
  34. 2017-10-13T13:51:32.145760Z 1 [Note] Starting upgrade on data directory.
  35. 2017-10-13T13:51:32.145876Z 1 [Note] InnoDB: PUNCH HOLE support available
  36. 2017-10-13T13:51:32.145935Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  37. 2017-10-13T13:51:32.146472Z 1 [Note] InnoDB: Uses event mutexes
  38. 2017-10-13T13:51:32.146524Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  39. 2017-10-13T13:51:32.146575Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
  40. 2017-10-13T13:51:32.151431Z 1 [Note] InnoDB: Number of pools: 1
  41. 2017-10-13T13:51:32.151764Z 1 [Note] InnoDB: Using CPU crc32 instructions
  42. 2017-10-13T13:51:32.155718Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  43. 2017-10-13T13:51:32.178753Z 1 [Note] InnoDB: Completed initialization of buffer pool
  44. 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().
  45. 2017-10-13T13:51:32.237494Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
  46. 2017-10-13T13:51:32.237589Z 1 [Note] InnoDB: Apply batch completed!
  47. 2017-10-13T13:51:32.240458Z 1 [Note] InnoDB: Upgrading redo log: 2*3072 pages, LSN=57364015
  48. 2017-10-13T13:51:32.350656Z 1 [Note] InnoDB: Starting to delete and rewrite log files.
  49. 2017-10-13T13:51:32.378674Z 1 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
  50. 2017-10-13T13:51:33.080886Z 1 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
  51. 2017-10-13T13:51:33.978605Z 1 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
  52. 2017-10-13T13:51:33.978878Z 1 [Note] InnoDB: New log files created, LSN=57364015
  53. 2017-10-13T13:51:33.995608Z 1 [Note] InnoDB: Expected to open 2 undo tablespaces but found none. Will create 2 new undo tablespaces.
  54. 2017-10-13T13:51:34.008551Z 1 [Note] InnoDB: Creating UNDO Tablespace ./undo_001
  55. 2017-10-13T13:51:34.008627Z 1 [Note] InnoDB: Setting file ./undo_001 size to 10 MB
  56. 2017-10-13T13:51:34.008674Z 1 [Note] InnoDB: Physically writing the file full
  57. 2017-10-13T13:51:34.156889Z 1 [Note] InnoDB: Creating UNDO Tablespace ./undo_002
  58. 2017-10-13T13:51:34.156966Z 1 [Note] InnoDB: Setting file ./undo_002 size to 10 MB
  59. 2017-10-13T13:51:34.157630Z 1 [Note] InnoDB: Physically writing the file full
  60. 2017-10-13T13:51:34.388715Z 1 [Note] InnoDB: Created 2 undo tablespaces.
  61. 2017-10-13T13:51:34.744924Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
  62. 2017-10-13T13:51:34.746605Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  63. 2017-10-13T13:51:34.879551Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  64. 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.
  65. 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.
  66. 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.
  67. 2017-10-13T13:51:35.837600Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 0
  68. 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
  69. 2017-10-13T13:51:40.333587Z 1 [Note] Created Data Dictionary for upgrade
  70. 2017-10-13T13:51:59.778455Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171013 15:51:59
  71. 2017-10-13T13:53:53.444899Z 2 [ERROR] InnoDB: Assertion failure: dict0dict.cc:1331:table2 == NULL
  72. InnoDB: thread 139746059917056
  73. InnoDB: We intentionally generate a memory trap.
  74. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  75. InnoDB: If you get repeated assertion failures or crashes, even
  76. InnoDB: immediately after the mysqld startup, there may be
  77. InnoDB: corruption in the InnoDB tablespace. Please refer to
  78. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  79. InnoDB: about forcing recovery.
  80. 13:53:53 UTC - mysqld got signal 6 ;
  81. This could be because you hit a bug. It is also possible that this binary
  82. or one of the libraries it was linked against is corrupt, improperly built,
  83. or misconfigured. This error can also be caused by malfunctioning hardware.
  84. Attempting to collect some information that could help diagnose the problem.
  85. As this is a crash and something is definitely wrong, the information
  86. collection process might fail.
  87.  
  88. key_buffer_size=8388608
  89. read_buffer_size=131072
  90. max_used_connections=0
  91. max_threads=151
  92. thread_count=1
  93. connection_count=0
  94. It is possible that mysqld could use up to
  95. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68136 K bytes of memory
  96. Hope that's ok; if not, decrease some variables in the equation.
  97.  
  98. Thread pointer: 0x6959720
  99. Attempting backtrace. You can use the following information to find out
  100. where mysqld died. If you see no messages after this, something went
  101. terribly wrong...
  102. stack_bottom = 7f192a428dc8 thread_stack 0x46000
  103. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(my_print_stacktrace+0x2e) [0x196899e]
  104. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld(handle_fatal_signal+0x4c1) [0xea3fd1]
  105. /lib64/libpthread.so.0(+0xf130) [0x7f193747f130]
  106. /lib64/libc.so.6(gsignal+0x37) [0x7f1935df85d7]
  107. /lib64/libc.so.6(abort+0x148) [0x7f1935df9cc8]
  108. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0xa234c6]
  109. /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]
  110. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1cffa92]
  111. /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]
  112. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1d007cf]
  113. /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]
  114. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x1cff916]
  115. /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]
  116. /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]
  117. /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]
  118. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x117aba7]
  119. /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]
  120. /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]
  121. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0xf3f703]
  122. /home/sbester/mysql/release/mysql-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld() [0x198e61f]
  123. /lib64/libpthread.so.0(+0x7df5) [0x7f1937477df5]
  124. /lib64/libc.so.6(clone+0x6d) [0x7f1935eb960d]
  125.  
  126. Trying to get some variables.
  127. Some pointers may be invalid and cause the dump to abort.
  128. Query (0): Connection ID (thread ID): 2
  129. Status: NOT_KILLED
  130.  
  131. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  132. information that should help you find out what is causing the crash.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement