Guest User

/var/log/mysql/error.log

a guest
Feb 28th, 2020
26
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2020-02-27T18:07:21.633566Z 0 [Note] Giving 2 client threads a chance to die gracefully
  2. 2020-02-27T18:07:21.633611Z 0 [Note] Shutting down slave threads
  3. 2020-02-27T18:07:21.634863Z 2 [Note] Error reading relay log event for channel '': slave SQL thread was killed
  4. 2020-02-27T18:07:21.635136Z 2 [Note] Slave SQL thread for channel '' exiting, replication stopped in log 'mysql-bin.000031' at position 711276
  5. 2020-02-27T18:07:21.639342Z 1 [Note] Slave I/O thread killed during or after a reconnect done to recover from failed read
  6. 2020-02-27T18:07:21.640151Z 1 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000031', position 711276
  7. 2020-02-27T18:07:21.640962Z 0 [Note] Forcefully disconnecting 0 remaining clients
  8. 2020-02-27T18:07:21.641624Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  9. 2020-02-27T18:07:21.643759Z 0 [Note] Binlog end
  10. 2020-02-27T18:07:21.662839Z 0 [Note] Shutting down plugin 'auth_socket'
  11. 2020-02-27T18:07:21.663005Z 0 [Note] Shutting down plugin 'ngram'
  12. 2020-02-27T18:07:21.663013Z 0 [Note] Shutting down plugin 'partition'
  13. 2020-02-27T18:07:21.663017Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  14. 2020-02-27T18:07:21.663153Z 0 [Note] Shutting down plugin 'ARCHIVE'
  15. 2020-02-27T18:07:21.663160Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  16. 2020-02-27T18:07:21.663770Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  17. 2020-02-27T18:07:21.664040Z 0 [Note] Shutting down plugin 'MyISAM'
  18. 2020-02-27T18:07:21.664051Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  19. 2020-02-27T18:07:21.664176Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  20. 2020-02-27T18:07:21.664183Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  21. 2020-02-27T18:07:21.664187Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  22. 2020-02-27T18:07:21.664190Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  23. 2020-02-27T18:07:21.664194Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  24. 2020-02-27T18:07:21.664198Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  25. 2020-02-27T18:07:21.664202Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  26. 2020-02-27T18:07:21.664206Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  27. 2020-02-27T18:07:21.664210Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  28. 2020-02-27T18:07:21.664214Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  29. 2020-02-27T18:07:21.664218Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  30. 2020-02-27T18:07:21.664221Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  31. 2020-02-27T18:07:21.664225Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  32. 2020-02-27T18:07:21.664229Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  33. 2020-02-27T18:07:21.664233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  34. 2020-02-27T18:07:21.664237Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  35. 2020-02-27T18:07:21.664241Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  36. 2020-02-27T18:07:21.664245Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  37. 2020-02-27T18:07:21.664248Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  38. 2020-02-27T18:07:21.664252Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  39. 2020-02-27T18:07:21.664256Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  40. 2020-02-27T18:07:21.664259Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  41. 2020-02-27T18:07:21.664263Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  42. 2020-02-27T18:07:21.664274Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  43. 2020-02-27T18:07:21.664278Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  44. 2020-02-27T18:07:21.664281Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  45. 2020-02-27T18:07:21.664284Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  46. 2020-02-27T18:07:21.664288Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  47. 2020-02-27T18:07:21.664291Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  48. 2020-02-27T18:07:21.664294Z 0 [Note] Shutting down plugin 'InnoDB'
  49. 2020-02-27T18:07:21.666516Z 0 [Note] InnoDB: FTS optimize thread exiting.
  50. 2020-02-27T18:07:21.666866Z 0 [Note] InnoDB: Starting shutdown...
  51. 2020-02-27T18:07:21.767582Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  52. 2020-02-27T18:07:21.767819Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200227 21:07:21
  53. 2020-02-27T18:07:23.387143Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2777921
  54. 2020-02-27T18:07:23.388619Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  55. 2020-02-27T18:07:23.388637Z 0 [Note] Shutting down plugin 'MEMORY'
  56. 2020-02-27T18:07:23.388644Z 0 [Note] Shutting down plugin 'CSV'
  57. 2020-02-27T18:07:23.388650Z 0 [Note] Shutting down plugin 'sha256_password'
  58. 2020-02-27T18:07:23.388654Z 0 [Note] Shutting down plugin 'mysql_native_password'
  59. 2020-02-27T18:07:23.389530Z 0 [Note] Shutting down plugin 'binlog'
  60. 2020-02-27T18:07:23.392972Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  61.  
  62. 2020-02-27T18:07:23.915418Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  63. 2020-02-27T18:07:23.918230Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1-log) starting as process 5748 ...
  64. 2020-02-27T18:07:23.926054Z 0 [Note] InnoDB: PUNCH HOLE support available
  65. 2020-02-27T18:07:23.926096Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  66. 2020-02-27T18:07:23.926102Z 0 [Note] InnoDB: Uses event mutexes
  67. 2020-02-27T18:07:23.926106Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  68. 2020-02-27T18:07:23.926111Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  69. 2020-02-27T18:07:23.926117Z 0 [Note] InnoDB: Using Linux native AIO
  70. 2020-02-27T18:07:23.928788Z 0 [Note] InnoDB: Number of pools: 1
  71. 2020-02-27T18:07:23.928952Z 0 [Note] InnoDB: Using CPU crc32 instructions
  72. 2020-02-27T18:07:23.931819Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  73. 2020-02-27T18:07:23.942081Z 0 [Note] InnoDB: Completed initialization of buffer pool
  74. 2020-02-27T18:07:23.944921Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  75. 2020-02-27T18:07:23.964392Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  76. 2020-02-27T18:07:23.993451Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  77. 2020-02-27T18:07:23.993547Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  78. 2020-02-27T18:07:24.032928Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  79. 2020-02-27T18:07:24.033843Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  80. 2020-02-27T18:07:24.033857Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  81. 2020-02-27T18:07:24.034171Z 0 [Note] InnoDB: Waiting for purge to start
  82. 2020-02-27T18:07:24.084375Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 2777921
  83. 2020-02-27T18:07:24.084835Z 0 [Note] Plugin 'FEDERATED' is disabled.
  84. 2020-02-27T18:07:24.085067Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  85. 2020-02-27T18:07:24.085324Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200227 21:07:24
  86. 2020-02-27T18:07:24.119307Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  87. 2020-02-27T18:07:24.119334Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  88. 2020-02-27T18:07:24.121090Z 0 [Warning] CA certificate ca.pem is self signed.
  89. 2020-02-27T18:07:24.121147Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  90. 2020-02-27T18:07:24.121511Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  91. 2020-02-27T18:07:24.121745Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  92. 2020-02-27T18:07:24.121782Z 0 [Note] Server socket created on IP: '0.0.0.0'.
  93. 2020-02-27T18:07:24.152897Z 1 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
  94. 2020-02-27T18:07:24.155478Z 2 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
  95. 2020-02-27T18:07:24.155546Z 2 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000031' at position 711276, relay log '/var/log/mysql/mysql-relay-bin.000078' position: 711489
  96. 2020-02-27T18:07:24.189429Z 0 [Note] Event Scheduler: Loaded 0 events
  97. 2020-02-27T18:07:24.189659Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  98. Version: '5.7.29-0ubuntu0.18.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
RAW Paste Data