API tools faq
paste
Advertisement
Guest User

mysql.error.log

a guest
Sep 21st, 2017
199
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.72 KB | None | 0 0
raw download clone embed print report
  1. 2017-09-19T08:13:34.065151Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2. 2017-09-19T08:13:34.315559Z 0 [Warning] InnoDB: New log files created, LSN=45790
  3. 2017-09-19T08:13:34.481760Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
  4. 2017-09-19T08:13:34.541319Z 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: 6e68a3d1-9d12-11e7-a56a-0242ac110003.
  5. 2017-09-19T08:13:34.543246Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
  6. 2017-09-19T08:13:34.543619Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
  7. 2017-09-19T08:13:37.521043Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  8. 2017-09-19T08:13:37.522335Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 289 ...
  9. 2017-09-19T08:13:37.524993Z 0 [Note] InnoDB: PUNCH HOLE support available
  10. 2017-09-19T08:13:37.525009Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  11. 2017-09-19T08:13:37.525013Z 0 [Note] InnoDB: Uses event mutexes
  12. 2017-09-19T08:13:37.525016Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  13. 2017-09-19T08:13:37.525019Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  14. 2017-09-19T08:13:37.525022Z 0 [Note] InnoDB: Using Linux native AIO
  15. 2017-09-19T08:13:37.525219Z 0 [Note] InnoDB: Number of pools: 1
  16. 2017-09-19T08:13:37.525302Z 0 [Note] InnoDB: Using CPU crc32 instructions
  17. 2017-09-19T08:13:37.526598Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  18. 2017-09-19T08:13:37.533172Z 0 [Note] InnoDB: Completed initialization of buffer pool
  19. 2017-09-19T08:13:37.534910Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  20. 2017-09-19T08:13:37.547120Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  21. 2017-09-19T08:13:37.557988Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  22. 2017-09-19T08:13:37.558042Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  23. 2017-09-19T08:13:37.580085Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  24. 2017-09-19T08:13:37.580766Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  25. 2017-09-19T08:13:37.580780Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  26. 2017-09-19T08:13:37.581029Z 0 [Note] InnoDB: Waiting for purge to start
  27. 2017-09-19T08:13:37.631230Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539315
  28. 2017-09-19T08:13:37.631339Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  29. 2017-09-19T08:13:37.631570Z 0 [Note] Plugin 'FEDERATED' is disabled.
  30. 2017-09-19T08:13:37.633027Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170919 8:13:37
  31. 2017-09-19T08:13:37.635590Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  32. 2017-09-19T08:13:37.653071Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  33. 2017-09-19T08:13:37.653105Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
  34. 2017-09-19T08:13:37.653139Z 0 [Note] Server socket created on IP: '127.0.0.1'.
  35. 2017-09-19T08:13:37.661165Z 0 [Note] Event Scheduler: Loaded 0 events
  36. 2017-09-19T08:13:37.661244Z 0 [Note] Execution of init_file '/var/lib/mysql-files/DYFLYOFdGW' started.
  37. 2017-09-19T08:13:37.664353Z 0 [Note] Execution of init_file '/var/lib/mysql-files/DYFLYOFdGW' ended.
  38. 2017-09-19T08:13:37.664410Z 0 [Note] mysqld: ready for connections.
  39. Version: '5.7.19' socket: '/tmp/tmp.Dlc2I8QgCt/mysqld.sock' port: 3306 MySQL Community Server (GPL)
  40. 2017-09-19T08:13:37.664422Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
  41. 2017-09-19T08:13:37.664430Z 0 [Note] Beginning of list of non-natively partitioned tables
  42. 2017-09-19T08:13:37.664491Z 0 [Note] Giving 1 client threads a chance to die gracefully
  43. 2017-09-19T08:13:37.664553Z 0 [Note] Shutting down slave threads
  44. 2017-09-19T08:13:37.664684Z 3 [ERROR] 1053 Server shutdown in progress
  45. 2017-09-19T08:13:37.664723Z 0 [Note] End of list of non-natively partitioned tables
  46. 2017-09-19T08:13:39.664692Z 0 [Note] Forcefully disconnecting 0 remaining clients
  47. 2017-09-19T08:13:39.664729Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  48. 2017-09-19T08:13:39.664789Z 0 [Note] Binlog end
  49. 2017-09-19T08:13:39.665218Z 0 [Note] Shutting down plugin 'auth_socket'
  50. 2017-09-19T08:13:39.665225Z 0 [Note] Shutting down plugin 'ngram'
  51. 2017-09-19T08:13:39.665227Z 0 [Note] Shutting down plugin 'ARCHIVE'
  52. 2017-09-19T08:13:39.665230Z 0 [Note] Shutting down plugin 'partition'
  53. 2017-09-19T08:13:39.665232Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  54. 2017-09-19T08:13:39.665235Z 0 [Note] Shutting down plugin 'MyISAM'
  55. 2017-09-19T08:13:39.665242Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  56. 2017-09-19T08:13:39.665245Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  57. 2017-09-19T08:13:39.665247Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  58. 2017-09-19T08:13:39.665249Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  59. 2017-09-19T08:13:39.665252Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  60. 2017-09-19T08:13:39.665254Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  61. 2017-09-19T08:13:39.665256Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  62. 2017-09-19T08:13:39.665258Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  63. 2017-09-19T08:13:39.665260Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  64. 2017-09-19T08:13:39.665262Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  65. 2017-09-19T08:13:39.665265Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  66. 2017-09-19T08:13:39.665267Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  67. 2017-09-19T08:13:39.665269Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  68. 2017-09-19T08:13:39.665271Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  69. 2017-09-19T08:13:39.665273Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  70. 2017-09-19T08:13:39.665275Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  71. 2017-09-19T08:13:39.665277Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  72. 2017-09-19T08:13:39.665279Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  73. 2017-09-19T08:13:39.665281Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  74. 2017-09-19T08:13:39.665283Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  75. 2017-09-19T08:13:39.665285Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  76. 2017-09-19T08:13:39.665287Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  77. 2017-09-19T08:13:39.665289Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  78. 2017-09-19T08:13:39.665291Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  79. 2017-09-19T08:13:39.665293Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  80. 2017-09-19T08:13:39.665295Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  81. 2017-09-19T08:13:39.665297Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  82. 2017-09-19T08:13:39.665299Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  83. 2017-09-19T08:13:39.665301Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  84. 2017-09-19T08:13:39.665303Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  85. 2017-09-19T08:13:39.665305Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  86. 2017-09-19T08:13:39.665307Z 0 [Note] Shutting down plugin 'InnoDB'
  87. 2017-09-19T08:13:39.665364Z 0 [Note] InnoDB: FTS optimize thread exiting.
  88. 2017-09-19T08:13:39.665424Z 0 [Note] InnoDB: Starting shutdown...
  89. 2017-09-19T08:13:39.765761Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  90. 2017-09-19T08:13:39.765972Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170919 8:13:39
  91. 2017-09-19T08:13:41.272747Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2539536
  92. 2017-09-19T08:13:41.274383Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  93. 2017-09-19T08:13:41.274394Z 0 [Note] Shutting down plugin 'CSV'
  94. 2017-09-19T08:13:41.274399Z 0 [Note] Shutting down plugin 'MEMORY'
  95. 2017-09-19T08:13:41.274402Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  96. 2017-09-19T08:13:41.274422Z 0 [Note] Shutting down plugin 'sha256_password'
  97. 2017-09-19T08:13:41.274424Z 0 [Note] Shutting down plugin 'mysql_native_password'
  98. 2017-09-19T08:13:41.274566Z 0 [Note] Shutting down plugin 'binlog'
  99. 2017-09-19T08:13:41.275531Z 0 [Note] mysqld: Shutdown complete
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!