API tools faq
paste
Advertisement
Guest User

mysql.error

a guest
Feb 21st, 2018
272
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.63 KB | None | 0 0
raw download clone embed print report
  1. 2018-02-19T11:09:01.155244Z 304850 [Note] Aborted connection 304850 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  2. 2018-02-19T11:09:01.188504Z 304849 [Note] Aborted connection 304849 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  3. 2018-02-19T12:43:29.758453Z 315084 [Note] Aborted connection 315084 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  4. 2018-02-19T12:43:36.425400Z 315176 [Note] Aborted connection 315176 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  5. 2018-02-19T12:44:26.203869Z 315164 [Note] Aborted connection 315164 to db: '*******' user: '**********' host: '*******.********.com' (Got an error reading communication packets)
  6. 2018-02-19T12:44:58.140944Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5662ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
  7. 2018-02-19T12:45:10.499670Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7960ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
  8. 2018-02-19T12:45:45.347239Z 315213 [Note] Aborted connection 315213 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  9. 2018-02-19T12:45:48.355716Z 315208 [Note] Aborted connection 315208 to db: '*******' user: '**********' host: '*******.********.com' (Got an error reading communication packets)
  10. 2018-02-19T12:45:49.351396Z 315218 [Note] Aborted connection 315218 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  11. 2018-02-19T12:45:53.374893Z 315214 [Note] Aborted connection 315214 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  12. 2018-02-19T12:45:53.999772Z 315180 [Note] Aborted connection 315180 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  13. 2018-02-19T12:45:57.883309Z 315220 [Note] Aborted connection 315220 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  14. 2018-02-19T12:45:59.164128Z 315188 [Note] Aborted connection 315188 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  15. 2018-02-19T12:45:59.164177Z 315184 [Note] Aborted connection 315184 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  16. 2018-02-19T12:46:03.896567Z 315232 [Note] Aborted connection 315232 to db: '*******' user: '**********' host: '*******.********.com' (Got an error reading communication packets)
  17. 2018-02-19T12:46:04.956557Z 315192 [Note] Aborted connection 315192 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  18. 2018-02-19T12:46:17.978804Z 315231 [Note] Aborted connection 315231 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  19. 2018-02-19T12:46:18.231166Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5283ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
  20. 2018-02-19T12:46:28.314339Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4650ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
  21. 2018-02-19T12:46:30.253141Z 315207 [Note] Aborted connection 315207 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  22. 2018-02-19T12:46:45.049033Z 315210 [Note] Aborted connection 315210 to db: '*******' user: '**********' host: '*******.********.com' (Got an error reading communication packets)
  23. 2018-02-19T12:46:45.986365Z 315259 [Note] Aborted connection 315259 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  24. 2018-02-19T12:46:50.269809Z 315264 [Note] Aborted connection 315264 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  25. 2018-02-19T12:46:50.269809Z 315264 [Note] Aborted connection 315264 to db: '********' user: '********' host: '*******.********.com' (Got an error reading communication packets)
  26. 2018-02-19T12:47:18.600323Z 315229 [Note] Aborted connection 315229 to db: '********' user: '********' host: '*******.********.com' (Got an error writing communication packets)
  27. 2018-02-19T12:47:23.415847Z 315228 [Note] Aborted connection 315228 to db: '********' user: '********' host: '*******.********.com' (Got an error writing communication packets)
  28. 2018-02-19T12:47:27.636043Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  29. 2018-02-19T12:47:27.636163Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  30. 2018-02-19T12:47:27.759910Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  31. 2018-02-19T12:47:27.759986Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  32. 2018-02-19T12:47:27.769601Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1-log) starting as process 8146 ...
  33. 2018-02-19T12:47:27.879986Z 0 [Note] InnoDB: PUNCH HOLE support available
  34. 2018-02-19T12:47:27.880066Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  35. 2018-02-19T12:47:27.880072Z 0 [Note] InnoDB: Uses event mutexes
  36. 2018-02-19T12:47:27.880077Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  37. 2018-02-19T12:47:27.880081Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  38. 2018-02-19T12:47:27.880085Z 0 [Note] InnoDB: Using Linux native AIO
  39. 2018-02-19T12:47:27.882891Z 0 [Note] InnoDB: Number of pools: 1
  40. 2018-02-19T12:47:27.887689Z 0 [Note] InnoDB: Using CPU crc32 instructions
  41. 2018-02-19T12:47:27.893308Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
  42. 2018-02-19T12:47:28.029038Z 0 [Note] InnoDB: Completed initialization of buffer pool
  43. 2018-02-19T12:47:28.061925Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  44. 2018-02-19T12:47:28.121893Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  45. 2018-02-19T12:47:28.200838Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4804395798
  46. 2018-02-19T12:47:28.200910Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4804395807
  47. 2018-02-19T12:47:28.200916Z 0 [Note] InnoDB: Database was not shutdown normally!
  48. 2018-02-19T12:47:28.200920Z 0 [Note] InnoDB: Starting crash recovery.
  49. 2018-02-19T12:47:29.073270Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  50. 2018-02-19T12:47:29.073315Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  51. 2018-02-19T12:47:29.073388Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  52. 2018-02-19T12:47:29.216962Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  53. 2018-02-19T12:47:29.217793Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  54. 2018-02-19T12:47:29.217807Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  55. 2018-02-19T12:47:29.218665Z 0 [Note] InnoDB: Waiting for purge to start
  56. 2018-02-19T12:47:29.268833Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 4804395807
  57. 2018-02-19T12:47:29.270719Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  58. 2018-02-19T12:47:29.217807Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  59. 2018-02-19T12:47:29.218665Z 0 [Note] InnoDB: Waiting for purge to start
  60. 2018-02-19T12:47:29.268833Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 4804395807
  61. 2018-02-19T12:47:29.270719Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  62. 2018-02-19T12:47:29.272780Z 0 [Note] Plugin 'FEDERATED' is disabled.
  63. 2018-02-19T12:47:29.297323Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  64. 2018-02-19T12:47:29.297368Z 0 [Note] Server hostname (bind-address): '***.***.***.***'; port: 3306
  65. 2018-02-19T12:47:29.297381Z 0 [Note] - '***.***.***.***' resolves to '***.***.***.***';
  66. 2018-02-19T12:47:29.297398Z 0 [Note] Server socket created on IP: '***.***.***.***'.
  67. 2018-02-19T12:47:29.503024Z 0 [Note] Event Scheduler: Loaded 0 events
  68. 2018-02-19T12:47:29.503202Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  69. Version: '5.7.21-0ubuntu0.16.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
  70. 2018-02-19T12:47:29.561236Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
  71. 2018-02-19T12:47:29.708825Z 2 [ERROR] /usr/sbin/mysqld: Table './*******/********' is marked as crashed and should be repaired
  72. 2018-02-19T12:47:29.708981Z 2 [Warning] Checking table: './*******/********'
  73. 2018-02-19T12:47:29.719238Z 4 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  74. 2018-02-19T12:47:29.719390Z 4 [Warning] Checking table: './******/********'
  75. 2018-02-19T12:47:29.752917Z 2 [ERROR] /usr/sbin/mysqld: Table './*******/********' is marked as crashed and should be repaired
  76. 2018-02-19T12:47:29.753058Z 2 [Warning] Checking table: './*******/********'
  77. 2018-02-19T12:47:29.806877Z 4 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  78. 2018-02-19T12:47:29.807156Z 4 [Warning] Checking table: './******/********'
  79. 2018-02-19T12:47:29.877414Z 2 [ERROR] /usr/sbin/mysqld: Table './*******/********' is marked as crashed and should be repaired
  80. 2018-02-19T12:47:29.877547Z 2 [Warning] Checking table: './*******/********'
  81. 2018-02-19T12:47:29.956069Z 10 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  82. 2018-02-19T12:47:29.956310Z 10 [Warning] Checking table: './******/********'
  83. 2018-02-19T12:47:30.093224Z 4 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  84. 2018-02-19T12:47:30.093380Z 4 [Warning] Checking table: './******/********'
  85. 2018-02-19T12:47:30.439480Z 10 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  86. 2018-02-19T12:47:30.439626Z 10 [Warning] Checking table: './******/********'
  87. 2018-02-19T12:47:31.572319Z 10 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  88. 2018-02-19T12:47:31.572506Z 10 [Warning] Checking table: './******/********'
  89. 2018-02-19T12:47:32.300267Z 12 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  90. 2018-02-19T12:47:32.300568Z 12 [Warning] Checking table: './******/********'
  91. 2018-02-19T12:47:32.326981Z 12 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  92. 2018-02-19T12:47:32.327109Z 12 [Warning] Checking table: './******/********'
  93. 2018-02-19T12:47:32.326981Z 12 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  94. 2018-02-19T12:47:32.327109Z 12 [Warning] Checking table: './******/********'
  95. 2018-02-19T12:47:32.425310Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180219 12:47:32
  96. 2018-02-19T12:47:37.557481Z 18 [ERROR] /usr/sbin/mysqld: Table './*********/*******' is marked as crashed and should be repaired
  97. 2018-02-19T12:47:37.557619Z 18 [Warning] Checking table: './********/********'
  98. 2018-02-19T12:47:37.868118Z 18 [ERROR] /usr/sbin/mysqld: Table './********/********' is marked as crashed and should be repaired
  99. 2018-02-19T12:47:37.868377Z 18 [Warning] Checking table: './********/********'
  100. 2018-02-19T12:47:37.899893Z 19 [ERROR] /usr/sbin/mysqld: Table './********/********' is marked as crashed and should be repaired
  101. 2018-02-19T12:47:37.900023Z 19 [Warning] Checking table: './********/********'
  102. 2018-02-19T12:47:39.197760Z 21 [ERROR] /usr/sbin/mysqld: Table './******/********' is marked as crashed and should be repaired
  103. 2018-02-19T12:47:39.197943Z 21 [Warning] Checking table: './******/********'
  104. 2018-02-19T22:25:13.247160Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4282ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
  105. 2018-02-20T00:19:03.321887Z 0 [Note] Giving 0 client threads a chance to die gracefully
  106. 2018-02-20T00:19:03.325367Z 0 [Note] Shutting down slave threads
  107. 2018-02-20T00:19:03.326815Z 0 [Note] Forcefully disconnecting 0 remaining clients
  108. 2018-02-20T00:19:03.329372Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  109. 2018-02-20T00:19:03.332364Z 0 [Note] Binlog end
  110. 2018-02-20T00:19:03.450351Z 0 [Note] Shutting down plugin 'ngram'
  111. 2018-02-20T00:19:03.453802Z 0 [Note] Shutting down plugin 'partition'
  112. 2018-02-20T00:19:03.453820Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  113. 2018-02-20T00:19:03.454907Z 0 [Note] Shutting down plugin 'ARCHIVE'
  114. 2018-02-20T00:19:03.454919Z 0 [Note] Shutting down plugin 'MyISAM'
  115. 2018-02-20T00:19:03.455863Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  116. 2018-02-20T00:19:03.457873Z 0 [Note] Shutting down plugin 'MEMORY'
  117. 2018-02-20T00:19:03.457900Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  118. 2018-02-20T00:19:03.457912Z 0 [Note] Shutting down plugin 'CSV'
  119. 2018-02-20T00:19:03.457923Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  120. 2018-02-20T00:19:03.459279Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  121. 2018-02-20T00:19:03.459290Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  122. 2018-02-20T00:19:03.459293Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  123. 2018-02-20T00:19:03.459296Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  124. 2018-02-20T00:19:03.459299Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  125. 2018-02-20T00:19:03.459301Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  126. 2018-02-20T00:19:03.459304Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  127. 2018-02-20T00:19:03.459309Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  128. 2018-02-20T00:19:03.459304Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  129. 2018-02-20T00:19:03.459309Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  130. 2018-02-20T00:19:03.459312Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  131. 2018-02-20T00:19:03.459315Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  132. 2018-02-20T00:19:03.459318Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  133. 2018-02-20T00:19:03.459320Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  134. 2018-02-20T00:19:03.459323Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  135. 2018-02-20T00:19:03.459326Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  136. 2018-02-20T00:19:03.459329Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  137. 2018-02-20T00:19:03.459336Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  138. 2018-02-20T00:19:03.459339Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  139. 2018-02-20T00:19:03.459342Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  140. 2018-02-20T00:19:03.459344Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  141. 2018-02-20T00:19:03.459347Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  142. 2018-02-20T00:19:03.459350Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  143. 2018-02-20T00:19:03.459359Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  144. 2018-02-20T00:19:03.459362Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  145. 2018-02-20T00:19:03.459365Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  146. 2018-02-20T00:19:03.459367Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  147. 2018-02-20T00:19:03.459370Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  148. 2018-02-20T00:19:03.459373Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  149. 2018-02-20T00:19:03.459376Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  150. 2018-02-20T00:19:03.459379Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  151. 2018-02-20T00:19:03.459382Z 0 [Note] Shutting down plugin 'InnoDB'
  152. 2018-02-20T00:19:03.470853Z 0 [Note] InnoDB: FTS optimize thread exiting.
  153. 2018-02-20T00:19:03.472316Z 0 [Note] InnoDB: Starting shutdown...
  154. 2018-02-20T00:19:03.574802Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  155. 2018-02-20T00:19:03.580308Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180220 0:19:03
  156. 2018-02-20T00:19:05.416017Z 0 [Note] InnoDB: Shutdown completed; log sequence number 5039060258
  157. 2018-02-20T00:19:05.422584Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  158. 2018-02-20T00:19:05.422626Z 0 [Note] Shutting down plugin 'sha256_password'
  159. 2018-02-20T00:19:05.422631Z 0 [Note] Shutting down plugin 'mysql_native_password'
  160. 2018-02-20T00:19:05.423037Z 0 [Note] Shutting down plugin 'binlog'
  161. 2018-02-20T00:19:05.435833Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  162. 2018-02-20T00:19:05.666772Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  163. 2018-02-20T00:19:05.666859Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  164. 2018-02-20T00:19:05.789353Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  165. 2018-02-20T00:19:05.789392Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  166. 2018-02-20T00:19:05.790978Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1-log) starting as process 15990 ...
  167. 2018-02-20T00:19:05.835273Z 0 [Note] InnoDB: PUNCH HOLE support available
  168. 2018-02-20T00:19:05.835339Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  169. 2018-02-20T00:19:05.835344Z 0 [Note] InnoDB: Uses event mutexes
  170. 2018-02-20T00:19:05.835348Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  171. 2018-02-20T00:19:05.835352Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  172. 2018-02-20T00:19:05.835355Z 0 [Note] InnoDB: Using Linux native AIO
  173. 2018-02-20T00:19:05.835792Z 0 [Note] InnoDB: Number of pools: 1
  174. 2018-02-20T00:19:05.836877Z 0 [Note] InnoDB: Using CPU crc32 instructions
  175. 2018-02-20T00:19:05.839442Z 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
  176. 2018-02-20T00:19:05.883669Z 0 [Note] InnoDB: Completed initialization of buffer pool
  177. 2018-02-20T00:19:05.895645Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  178. 2018-02-20T00:19:05.917289Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  179. 2018-02-20T00:19:06.243002Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  180. 2018-02-20T00:19:06.243112Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  181. 2018-02-20T00:19:06.346719Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  182. 2018-02-20T00:19:06.349301Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  183. 2018-02-20T00:19:06.349385Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  184. 2018-02-20T00:19:06.350270Z 0 [Note] InnoDB: Waiting for purge to start
  185. 2018-02-20T00:19:06.400502Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 5039060258
  186. 2018-02-20T00:19:06.400994Z 0 [Note] Plugin 'FEDERATED' is disabled.
  187. 2018-02-20T00:19:06.401436Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  188. 2018-02-20T00:19:06.431253Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  189. 2018-02-20T00:19:06.431282Z 0 [Note] Server hostname (bind-address): '***.***.***.***'; port: 3306
  190. 2018-02-20T00:19:06.431294Z 0 [Note] - '***.***.***.***' resolves to '***.***.***.***';
  191. 2018-02-20T00:19:06.431328Z 0 [Note] Server socket created on IP: '***.***.***.***'.
  192. 2018-02-20T00:19:06.605592Z 0 [Note] Event Scheduler: Loaded 0 events
  193. 2018-02-20T00:19:06.605873Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  194. 2018-02-20T00:19:06.605592Z 0 [Note] Event Scheduler: Loaded 0 events
  195. 2018-02-20T00:19:06.605873Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  196. Version: '5.7.21-0ubuntu0.16.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
  197. 2018-02-20T00:19:06.637272Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
  198. 2018-02-20T00:19:10.226777Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180220 0:19:10
  199. 2018-02-20T11:24:00.858289Z 90638 [Note] Aborted connection 90638 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  200. 2018-02-20T11:25:09.350202Z 90640 [Note] Aborted connection 90640 to db: '*******' user: '**********' host: '*******.********.com' (Got an error reading communication packets)
  201. 2018-02-20T17:03:49.808704Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6333ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
  202. 2018-02-20T17:10:52.908747Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4339ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
  203. 2018-02-20T17:19:41.802849Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15957ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
  204. 2018-02-20T17:40:02.044527Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 79119ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
  205. 2018-02-20T20:35:18.293969Z 168163 [Note] Access denied for user '********'@'********' (using password: YES)
  206. 2018-02-20T22:06:44.342297Z 183149 [Note] Aborted connection 183149 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  207. 2018-02-20T22:06:52.556415Z 183201 [Note] Aborted connection 183201 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  208. 2018-02-20T22:07:19.840596Z 183231 [Note] Aborted connection 183231 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  209. 2018-02-20T22:07:41.860459Z 183326 [Note] Aborted connection 183326 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  210. 2018-02-20T22:23:13.377733Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9927ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
  211. 2018-02-20T22:24:12.252106Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6810ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
  212. 2018-02-21T02:34:07.296234Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21571ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
  213. 2018-02-21T10:29:22.570089Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30304ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  214. 2018-02-21T10:30:13.051016Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8476ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
  215. 2018-02-21T10:42:13.330614Z 294803 [Note] Aborted connection 294803 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  216. 2018-02-21T12:37:24.484146Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4175ms. The settings might not be optimal. (flushed=76 and evicted=0, during the time.)
  217. 2018-02-21T23:54:38.033120Z 428855 [Note] Aborted connection 428855 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  218. 2018-02-21T23:54:48.659265Z 428970 [Note] Aborted connection 428970 to db: '******' user: '******' host: '*******.********.com' (Got an error reading communication packets)
  219. 2018-02-22T00:50:16.725109Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6894ms. The settings might not be optimal. (flushed=2 and evicted=5, during the time.)
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!