Advertisement
Guest User

mysql error.log

a guest
Jan 17th, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 26.88 KB | None | 0 0
  1. 2018-01-17T09:42:12.372354Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  2. 2018-01-17T09:42:12.378459Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  3. 2018-01-17T09:42:12.671432Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  4. 2018-01-17T09:42:12.687143Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 11743 ...
  5. 2018-01-17T09:42:12.759888Z 0 [Note] InnoDB: PUNCH HOLE support available
  6. 2018-01-17T09:42:12.759967Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  7. 2018-01-17T09:42:12.759979Z 0 [Note] InnoDB: Uses event mutexes
  8. 2018-01-17T09:42:12.759986Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  9. 2018-01-17T09:42:12.759994Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  10. 2018-01-17T09:42:12.760018Z 0 [Note] InnoDB: Using Linux native AIO
  11. 2018-01-17T09:42:12.761786Z 0 [Note] InnoDB: Number of pools: 1
  12. 2018-01-17T09:42:12.766556Z 0 [Note] InnoDB: Using CPU crc32 instructions
  13. 2018-01-17T09:42:12.771423Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  14. 2018-01-17T09:42:12.771777Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  15. 2018-01-17T09:42:12.771797Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  16. 2018-01-17T09:42:12.771811Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  17. 2018-01-17T09:42:12.771823Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  18. 2018-01-17T09:42:12.771830Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  19. 2018-01-17T09:42:12.771838Z 0 [ERROR] Failed to initialize plugins.
  20. 2018-01-17T09:42:12.771843Z 0 [ERROR] Aborting
  21.  
  22. 2018-01-17T09:42:12.771864Z 0 [Note] Binlog end
  23. 2018-01-17T09:42:12.772161Z 0 [Note] Shutting down plugin 'CSV'
  24. 2018-01-17T09:42:12.772184Z 0 [Note] Shutting down plugin 'MyISAM'
  25. 2018-01-17T09:42:12.772863Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  26.  
  27. 2018-01-17T09:42:42.545765Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  28. 2018-01-17T09:42:42.545861Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  29. 2018-01-17T09:42:42.803196Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  30. 2018-01-17T09:42:42.810378Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 11823 ...
  31. 2018-01-17T09:42:42.818797Z 0 [Note] InnoDB: PUNCH HOLE support available
  32. 2018-01-17T09:42:42.818857Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  33. 2018-01-17T09:42:42.818876Z 0 [Note] InnoDB: Uses event mutexes
  34. 2018-01-17T09:42:42.818894Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  35. 2018-01-17T09:42:42.818909Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  36. 2018-01-17T09:42:42.818983Z 0 [Note] InnoDB: Using Linux native AIO
  37. 2018-01-17T09:42:42.819507Z 0 [Note] InnoDB: Number of pools: 1
  38. 2018-01-17T09:42:42.819687Z 0 [Note] InnoDB: Using CPU crc32 instructions
  39. 2018-01-17T09:42:42.823450Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  40. 2018-01-17T09:42:42.840192Z 0 [Note] InnoDB: Completed initialization of buffer pool
  41. 2018-01-17T09:42:42.846866Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  42. 2018-01-17T09:42:42.954142Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  43. 2018-01-17T09:42:42.989509Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2861608696
  44. 2018-01-17T09:42:42.989575Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2861608824
  45. 2018-01-17T09:42:43.002076Z 0 [Note] InnoDB: Database was not shutdown normally!
  46. 2018-01-17T09:42:43.002108Z 0 [Note] InnoDB: Starting crash recovery.
  47. 2018-01-17T09:42:46.766767Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  48. 2018-01-17T09:42:46.766854Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  49. 2018-01-17T09:42:46.767011Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  50. 2018-01-17T09:42:47.225563Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  51. 2018-01-17T09:42:47.227812Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  52. 2018-01-17T09:42:47.227832Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  53. 2018-01-17T09:42:47.228505Z 0 [Note] InnoDB: Waiting for purge to start
  54. 2018-01-17T09:42:47.278734Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 2861608824
  55. 2018-01-17T09:42:47.279346Z 0 [Note] Plugin 'FEDERATED' is disabled.
  56. 2018-01-17T09:42:47.279575Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4433ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  57. 2018-01-17T09:42:47.280419Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  58. 2018-01-17T09:42:47.298905Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  59. 2018-01-17T09:42:47.298981Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  60. 2018-01-17T09:42:47.299026Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  61. 2018-01-17T09:42:47.299080Z 0 [Note] Server socket created on IP: '0.0.0.0'.
  62. 2018-01-17T09:42:47.648526Z 0 [Note] Event Scheduler: Loaded 0 events
  63. 2018-01-17T09:42:47.648844Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  64. Version: '5.7.20-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  65. 2018-01-17T09:42:47.648867Z 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.
  66. 2018-01-17T09:42:47.648874Z 0 [Note] Beginning of list of non-natively partitioned tables
  67. 2018-01-17T09:42:48.408805Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180117 12:42:48
  68. 2018-01-17T09:42:49.143279Z 0 [Note] End of list of non-natively partitioned tables
  69. 2018-01-17T09:42:49.195802Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
  70. 2018-01-17T09:47:38.250327Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8251ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
  71. 2018-01-17T09:48:01.725130Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  72. 2018-01-17T09:48:01.728525Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  73. 2018-01-17T09:48:02.045264Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  74. 2018-01-17T09:48:02.050848Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 11914 ...
  75. 2018-01-17T09:48:02.072833Z 0 [Note] InnoDB: PUNCH HOLE support available
  76. 2018-01-17T09:48:02.073134Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  77. 2018-01-17T09:48:02.073158Z 0 [Note] InnoDB: Uses event mutexes
  78. 2018-01-17T09:48:02.073177Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  79. 2018-01-17T09:48:02.073195Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  80. 2018-01-17T09:48:02.073212Z 0 [Note] InnoDB: Using Linux native AIO
  81. 2018-01-17T09:48:02.085204Z 0 [Note] InnoDB: Number of pools: 1
  82. 2018-01-17T09:48:02.098396Z 0 [Note] InnoDB: Using CPU crc32 instructions
  83. 2018-01-17T09:48:02.105986Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  84. 2018-01-17T09:48:02.106322Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  85. 2018-01-17T09:48:02.106342Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  86. 2018-01-17T09:48:02.106356Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  87. 2018-01-17T09:48:02.106368Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  88. 2018-01-17T09:48:02.106376Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  89. 2018-01-17T09:48:02.106398Z 0 [ERROR] Failed to initialize plugins.
  90. 2018-01-17T09:48:02.106405Z 0 [ERROR] Aborting
  91.  
  92. 2018-01-17T09:48:02.106439Z 0 [Note] Binlog end
  93. 2018-01-17T09:48:02.106793Z 0 [Note] Shutting down plugin 'CSV'
  94. 2018-01-17T09:48:02.106821Z 0 [Note] Shutting down plugin 'MyISAM'
  95. 2018-01-17T09:48:02.116773Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  96.  
  97. 2018-01-17T09:48:32.047483Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  98. 2018-01-17T09:48:32.047563Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  99. 2018-01-17T09:48:32.246999Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  100. 2018-01-17T09:48:32.250084Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 11991 ...
  101. 2018-01-17T09:48:32.257155Z 0 [Note] InnoDB: PUNCH HOLE support available
  102. 2018-01-17T09:48:32.257196Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  103. 2018-01-17T09:48:32.257205Z 0 [Note] InnoDB: Uses event mutexes
  104. 2018-01-17T09:48:32.257212Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  105. 2018-01-17T09:48:32.257227Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  106. 2018-01-17T09:48:32.257236Z 0 [Note] InnoDB: Using Linux native AIO
  107. 2018-01-17T09:48:32.257640Z 0 [Note] InnoDB: Number of pools: 1
  108. 2018-01-17T09:48:32.257818Z 0 [Note] InnoDB: Using CPU crc32 instructions
  109. 2018-01-17T09:48:32.260328Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  110. 2018-01-17T09:48:32.274102Z 0 [Note] InnoDB: Completed initialization of buffer pool
  111. 2018-01-17T09:48:32.277458Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  112. 2018-01-17T09:48:32.292973Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  113. 2018-01-17T09:48:32.328084Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2861810284
  114. 2018-01-17T09:48:32.328124Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2861810293
  115. 2018-01-17T09:48:32.328137Z 0 [Note] InnoDB: Database was not shutdown normally!
  116. 2018-01-17T09:48:32.328146Z 0 [Note] InnoDB: Starting crash recovery.
  117. 2018-01-17T09:48:33.937992Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  118. 2018-01-17T09:48:33.938031Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  119. 2018-01-17T09:48:33.938099Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  120. 2018-01-17T09:48:34.311656Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  121. 2018-01-17T09:48:34.313592Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  122. 2018-01-17T09:48:34.313611Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  123. 2018-01-17T09:48:34.314257Z 0 [Note] InnoDB: Waiting for purge to start
  124. 2018-01-17T09:48:34.364539Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 2861810293
  125. 2018-01-17T09:48:34.365039Z 0 [Note] Plugin 'FEDERATED' is disabled.
  126. 2018-01-17T09:48:34.365991Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  127. 2018-01-17T09:48:34.486620Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  128. 2018-01-17T09:48:34.486668Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  129. 2018-01-17T09:48:34.486705Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  130. 2018-01-17T09:48:34.486776Z 0 [Note] Server socket created on IP: '0.0.0.0'.
  131. 2018-01-17T09:48:34.497951Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180117 12:48:34
  132. 2018-01-17T09:48:34.765737Z 0 [Note] Event Scheduler: Loaded 0 events
  133. 2018-01-17T09:48:34.766075Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  134. Version: '5.7.20-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  135. 2018-01-17T09:48:34.766092Z 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.
  136. 2018-01-17T09:48:34.766110Z 0 [Note] Beginning of list of non-natively partitioned tables
  137. 2018-01-17T09:48:35.847931Z 0 [Note] End of list of non-natively partitioned tables
  138. 2018-01-17T09:48:35.856365Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
  139. 2018-01-17T09:51:58.065630Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  140. 2018-01-17T09:51:58.069071Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  141. 2018-01-17T09:51:58.300138Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  142. 2018-01-17T09:51:58.305629Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12061 ...
  143. 2018-01-17T09:51:58.321692Z 0 [Note] InnoDB: PUNCH HOLE support available
  144. 2018-01-17T09:51:58.321776Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  145. 2018-01-17T09:51:58.321789Z 0 [Note] InnoDB: Uses event mutexes
  146. 2018-01-17T09:51:58.321798Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  147. 2018-01-17T09:51:58.321805Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  148. 2018-01-17T09:51:58.321813Z 0 [Note] InnoDB: Using Linux native AIO
  149. 2018-01-17T09:51:58.323308Z 0 [Note] InnoDB: Number of pools: 1
  150. 2018-01-17T09:51:58.329179Z 0 [Note] InnoDB: Using CPU crc32 instructions
  151. 2018-01-17T09:51:58.335197Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  152. 2018-01-17T09:51:58.338340Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  153. 2018-01-17T09:51:58.338368Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  154. 2018-01-17T09:51:58.338383Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  155. 2018-01-17T09:51:58.338394Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  156. 2018-01-17T09:51:58.338401Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  157. 2018-01-17T09:51:58.338408Z 0 [ERROR] Failed to initialize plugins.
  158. 2018-01-17T09:51:58.338414Z 0 [ERROR] Aborting
  159.  
  160. 2018-01-17T09:51:58.338433Z 0 [Note] Binlog end
  161. 2018-01-17T09:51:58.340392Z 0 [Note] Shutting down plugin 'CSV'
  162. 2018-01-17T09:51:58.340416Z 0 [Note] Shutting down plugin 'MyISAM'
  163. 2018-01-17T09:51:58.349687Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  164.  
  165. 2018-01-17T09:52:28.293354Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  166. 2018-01-17T09:52:28.293491Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  167. 2018-01-17T09:52:28.551305Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  168. 2018-01-17T09:52:28.555524Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12140 ...
  169. 2018-01-17T09:52:28.565722Z 0 [Note] InnoDB: PUNCH HOLE support available
  170. 2018-01-17T09:52:28.565792Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  171. 2018-01-17T09:52:28.565804Z 0 [Note] InnoDB: Uses event mutexes
  172. 2018-01-17T09:52:28.565812Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  173. 2018-01-17T09:52:28.565820Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  174. 2018-01-17T09:52:28.565837Z 0 [Note] InnoDB: Using Linux native AIO
  175. 2018-01-17T09:52:28.566449Z 0 [Note] InnoDB: Number of pools: 1
  176. 2018-01-17T09:52:28.566714Z 0 [Note] InnoDB: Using CPU crc32 instructions
  177. 2018-01-17T09:52:28.571246Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  178. 2018-01-17T09:52:28.571342Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  179. 2018-01-17T09:52:28.571360Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  180. 2018-01-17T09:52:28.571385Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  181. 2018-01-17T09:52:28.571399Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  182. 2018-01-17T09:52:28.571421Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  183. 2018-01-17T09:52:28.571430Z 0 [ERROR] Failed to initialize plugins.
  184. 2018-01-17T09:52:28.571436Z 0 [ERROR] Aborting
  185.  
  186. 2018-01-17T09:52:28.571460Z 0 [Note] Binlog end
  187. 2018-01-17T09:52:28.571573Z 0 [Note] Shutting down plugin 'CSV'
  188. 2018-01-17T09:52:28.571595Z 0 [Note] Shutting down plugin 'MyISAM'
  189. 2018-01-17T09:52:28.571993Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  190.  
  191. 2018-01-17T09:52:58.682425Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  192. 2018-01-17T09:52:58.682522Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  193. 2018-01-17T09:52:58.875908Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  194. 2018-01-17T09:52:58.878290Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12223 ...
  195. 2018-01-17T09:52:58.884797Z 0 [Note] InnoDB: PUNCH HOLE support available
  196. 2018-01-17T09:52:58.884838Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  197. 2018-01-17T09:52:58.884847Z 0 [Note] InnoDB: Uses event mutexes
  198. 2018-01-17T09:52:58.884854Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  199. 2018-01-17T09:52:58.884865Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  200. 2018-01-17T09:52:58.884872Z 0 [Note] InnoDB: Using Linux native AIO
  201. 2018-01-17T09:52:58.885224Z 0 [Note] InnoDB: Number of pools: 1
  202. 2018-01-17T09:52:58.885391Z 0 [Note] InnoDB: Using CPU crc32 instructions
  203. 2018-01-17T09:52:58.888476Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  204. 2018-01-17T09:52:58.888538Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  205. 2018-01-17T09:52:58.888554Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  206. 2018-01-17T09:52:58.888563Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  207. 2018-01-17T09:52:58.888571Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  208. 2018-01-17T09:52:58.888577Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  209. 2018-01-17T09:52:58.888583Z 0 [ERROR] Failed to initialize plugins.
  210. 2018-01-17T09:52:58.888588Z 0 [ERROR] Aborting
  211.  
  212. 2018-01-17T09:52:58.888602Z 0 [Note] Binlog end
  213. 2018-01-17T09:52:58.888663Z 0 [Note] Shutting down plugin 'CSV'
  214. 2018-01-17T09:52:58.888677Z 0 [Note] Shutting down plugin 'MyISAM'
  215. 2018-01-17T09:52:58.888982Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  216.  
  217. 2018-01-17T09:53:29.056441Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  218. 2018-01-17T09:53:29.056593Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  219. 2018-01-17T09:53:29.316283Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  220. 2018-01-17T09:53:29.321352Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12363 ...
  221. 2018-01-17T09:53:29.332981Z 0 [Note] InnoDB: PUNCH HOLE support available
  222. 2018-01-17T09:53:29.333041Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  223. 2018-01-17T09:53:29.333055Z 0 [Note] InnoDB: Uses event mutexes
  224. 2018-01-17T09:53:29.333066Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  225. 2018-01-17T09:53:29.333077Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  226. 2018-01-17T09:53:29.333088Z 0 [Note] InnoDB: Using Linux native AIO
  227. 2018-01-17T09:53:29.333900Z 0 [Note] InnoDB: Number of pools: 1
  228. 2018-01-17T09:53:29.334258Z 0 [Note] InnoDB: Using CPU crc32 instructions
  229. 2018-01-17T09:53:29.339213Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  230. 2018-01-17T09:53:29.339324Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  231. 2018-01-17T09:53:29.339345Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  232. 2018-01-17T09:53:29.339364Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  233. 2018-01-17T09:53:29.339378Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  234. 2018-01-17T09:53:29.339404Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  235. 2018-01-17T09:53:29.339415Z 0 [ERROR] Failed to initialize plugins.
  236. 2018-01-17T09:53:29.339423Z 0 [ERROR] Aborting
  237.  
  238. 2018-01-17T09:53:29.339445Z 0 [Note] Binlog end
  239. 2018-01-17T09:53:29.339569Z 0 [Note] Shutting down plugin 'CSV'
  240. 2018-01-17T09:53:29.339593Z 0 [Note] Shutting down plugin 'MyISAM'
  241. 2018-01-17T09:53:29.340099Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  242.  
  243. 2018-01-17T09:53:59.546472Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  244. 2018-01-17T09:53:59.546611Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  245. 2018-01-17T09:53:59.774096Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  246. 2018-01-17T09:53:59.777727Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12475 ...
  247. 2018-01-17T09:53:59.785919Z 0 [Note] InnoDB: PUNCH HOLE support available
  248. 2018-01-17T09:53:59.785971Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  249. 2018-01-17T09:53:59.785982Z 0 [Note] InnoDB: Uses event mutexes
  250. 2018-01-17T09:53:59.785989Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  251. 2018-01-17T09:53:59.785997Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  252. 2018-01-17T09:53:59.786004Z 0 [Note] InnoDB: Using Linux native AIO
  253. 2018-01-17T09:53:59.786588Z 0 [Note] InnoDB: Number of pools: 1
  254. 2018-01-17T09:53:59.786867Z 0 [Note] InnoDB: Using CPU crc32 instructions
  255. 2018-01-17T09:53:59.790442Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  256. 2018-01-17T09:53:59.790533Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
  257. 2018-01-17T09:53:59.790549Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  258. 2018-01-17T09:53:59.790564Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  259. 2018-01-17T09:53:59.790576Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  260. 2018-01-17T09:53:59.790583Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  261. 2018-01-17T09:53:59.790590Z 0 [ERROR] Failed to initialize plugins.
  262. 2018-01-17T09:53:59.790595Z 0 [ERROR] Aborting
  263.  
  264. 2018-01-17T09:53:59.790612Z 0 [Note] Binlog end
  265. 2018-01-17T09:53:59.790707Z 0 [Note] Shutting down plugin 'CSV'
  266. 2018-01-17T09:53:59.790754Z 0 [Note] Shutting down plugin 'MyISAM'
  267. 2018-01-17T09:53:59.791190Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  268.  
  269. 2018-01-17T09:54:30.048428Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
  270. 2018-01-17T09:54:30.048531Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  271. 2018-01-17T09:54:30.275485Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  272. 2018-01-17T09:54:30.279257Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 12601 ...
  273. 2018-01-17T09:54:30.287714Z 0 [Note] InnoDB: PUNCH HOLE support available
  274. 2018-01-17T09:54:30.287768Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  275. 2018-01-17T09:54:30.287778Z 0 [Note] InnoDB: Uses event mutexes
  276. 2018-01-17T09:54:30.287786Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  277. 2018-01-17T09:54:30.287793Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  278. 2018-01-17T09:54:30.287801Z 0 [Note] InnoDB: Using Linux native AIO
  279. 2018-01-17T09:54:30.288382Z 0 [Note] InnoDB: Number of pools: 1
  280. 2018-01-17T09:54:30.288647Z 0 [Note] InnoDB: Using CPU crc32 instructions
  281. 2018-01-17T09:54:30.292236Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  282. 2018-01-17T09:54:30.312478Z 0 [Note] InnoDB: Completed initialization of buffer pool
  283. 2018-01-17T09:54:30.317869Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  284. 2018-01-17T09:54:30.335429Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  285. 2018-01-17T09:54:30.355688Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2861919248
  286. 2018-01-17T09:54:30.355760Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2861919257
  287. 2018-01-17T09:54:30.355777Z 0 [Note] InnoDB: Database was not shutdown normally!
  288. 2018-01-17T09:54:30.355787Z 0 [Note] InnoDB: Starting crash recovery.
  289. 2018-01-17T09:54:31.875927Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  290. 2018-01-17T09:54:31.878013Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  291. 2018-01-17T09:54:31.878108Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  292. 2018-01-17T09:54:32.384640Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  293. 2018-01-17T09:54:32.385942Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  294. 2018-01-17T09:54:32.385962Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  295. 2018-01-17T09:54:32.386378Z 0 [Note] InnoDB: Waiting for purge to start
  296. 2018-01-17T09:54:32.436654Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 2861919257
  297. 2018-01-17T09:54:32.437337Z 0 [Note] Plugin 'FEDERATED' is disabled.
  298. 2018-01-17T09:54:32.437806Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  299. 2018-01-17T09:54:32.618181Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  300. 2018-01-17T09:54:32.618231Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  301. 2018-01-17T09:54:32.618260Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  302. 2018-01-17T09:54:32.618305Z 0 [Note] Server socket created on IP: '0.0.0.0'.
  303. 2018-01-17T09:54:32.699504Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180117 12:54:32
  304. 2018-01-17T09:54:32.953267Z 0 [Note] Event Scheduler: Loaded 0 events
  305. 2018-01-17T09:54:32.953631Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  306. Version: '5.7.20-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  307. 2018-01-17T09:54:32.953652Z 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.
  308. 2018-01-17T09:54:32.953661Z 0 [Note] Beginning of list of non-natively partitioned tables
  309. 2018-01-17T09:54:34.196576Z 0 [Note] End of list of non-natively partitioned tables
  310. 2018-01-17T09:54:34.209760Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement