API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 31st, 2017
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 117.60 KB | None | 0 0
raw download clone embed print report
  1. 2017-05-29T06:54:34.201902Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2. 2017-05-29T06:54:34.201902Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  3. 2017-05-29T06:54:34.217502Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 1968 ...
  4. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  5. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Uses event mutexes
  6. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  7. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  8. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  9. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Number of pools: 1
  10. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  11. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  12. 2017-05-29T06:54:34.233102Z 0 [Note] InnoDB: Completed initialization of buffer pool
  13. 2017-05-29T06:54:34.311102Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  14. 2017-05-29T06:54:35.044303Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  15. 2017-05-29T06:54:35.044303Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  16. 2017-05-29T06:54:35.481104Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  17. 2017-05-29T06:54:35.481104Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  18. 2017-05-29T06:54:35.481104Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  19. 2017-05-29T06:54:35.496704Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536267
  20. 2017-05-29T06:54:35.496704Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  21. 2017-05-29T06:54:35.496704Z 0 [Note] Plugin 'FEDERATED' is disabled.
  22. 2017-05-29T06:54:35.793104Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  23. 2017-05-29T06:54:35.793104Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  24. 2017-05-29T06:54:35.793104Z 0 [Note] IPv6 is available.
  25. 2017-05-29T06:54:35.793104Z 0 [Note] - '::' resolves to '::';
  26. 2017-05-29T06:54:35.793104Z 0 [Note] Server socket created on IP: '::'.
  27. 2017-05-29T06:54:36.073905Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170529 13:54:36
  28. 2017-05-29T06:54:36.105105Z 0 [Note] Event Scheduler: Loaded 0 events
  29. 2017-05-29T06:54:36.105105Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  30. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  31. 2017-05-29T06:54:36.105105Z 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.
  32. 2017-05-29T06:54:36.105105Z 0 [Note] Beginning of list of non-natively partitioned tables
  33. 2017-05-29T06:54:36.120705Z 0 [Note] End of list of non-natively partitioned tables
  34. 2017-05-29T06:54:38.195509Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES)
  35. 2017-05-29T07:10:39.606237Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'localhost' (Got an error writing communication packets)
  36. 2017-05-29T07:52:45.835636Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  37.  
  38. 2017-05-29T07:52:46.007237Z 0 [Note] Giving 0 client threads a chance to die gracefully
  39. 2017-05-29T07:52:46.007237Z 0 [Note] Shutting down slave threads
  40. 2017-05-29T07:52:46.069637Z 0 [Note] Forcefully disconnecting 0 remaining clients
  41. 2017-05-29T07:52:46.100837Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  42. 2017-05-29T07:52:46.194437Z 0 [Note] Binlog end
  43. 2017-05-29T07:52:46.225637Z 0 [Note] Shutting down plugin 'ngram'
  44. 2017-05-29T07:52:46.288037Z 0 [Note] Shutting down plugin 'partition'
  45. 2017-05-29T07:52:46.288037Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  46. 2017-05-29T07:52:46.288037Z 0 [Note] Shutting down plugin 'ARCHIVE'
  47. 2017-05-29T07:52:46.288037Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  48. 2017-05-29T07:52:46.303637Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  49. 2017-05-29T07:52:46.303637Z 0 [Note] Shutting down plugin 'MyISAM'
  50. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  51. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  52. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  53. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  54. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  55. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  56. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  57. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  58. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  59. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  60. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  61. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  62. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  63. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  64. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  65. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  66. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  67. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  68. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  69. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  70. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  71. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  72. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  73. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  74. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  75. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  76. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  77. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  78. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  79. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  80. 2017-05-29T07:52:46.319237Z 0 [Note] Shutting down plugin 'InnoDB'
  81. 2017-05-29T07:52:46.350437Z 0 [Note] InnoDB: FTS optimize thread exiting.
  82. 2017-05-29T07:52:46.350437Z 0 [Note] InnoDB: Starting shutdown...
  83. 2017-05-29T07:52:46.490838Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  84. 2017-05-29T07:52:46.506438Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170529 14:52:46
  85. 2017-05-29T07:52:53.245649Z 0 [Note] InnoDB: Shutdown completed; log sequence number 167217439
  86. 2017-05-29T07:52:53.245649Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  87. 2017-05-29T07:52:53.245649Z 0 [Note] Shutting down plugin 'MEMORY'
  88. 2017-05-29T07:52:53.245649Z 0 [Note] Shutting down plugin 'CSV'
  89. 2017-05-29T07:52:53.245649Z 0 [Note] Shutting down plugin 'sha256_password'
  90. 2017-05-29T07:52:53.245649Z 0 [Note] Shutting down plugin 'mysql_native_password'
  91. 2017-05-29T07:52:53.261249Z 0 [Note] Shutting down plugin 'binlog'
  92. 2017-05-29T07:52:53.417250Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  93.  
  94. 2017-05-29T07:53:38.079250Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  95. 2017-05-29T07:53:38.094850Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  96. 2017-05-29T07:53:38.157250Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 2368 ...
  97. 2017-05-29T07:53:38.328850Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  98. 2017-05-29T07:53:38.328850Z 0 [Note] InnoDB: Uses event mutexes
  99. 2017-05-29T07:53:38.328850Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  100. 2017-05-29T07:53:38.328850Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  101. 2017-05-29T07:53:38.328850Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  102. 2017-05-29T07:53:38.344450Z 0 [Note] InnoDB: Number of pools: 1
  103. 2017-05-29T07:53:38.344450Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  104. 2017-05-29T07:53:38.360050Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  105. 2017-05-29T07:53:38.360050Z 0 [Note] InnoDB: Completed initialization of buffer pool
  106. 2017-05-29T07:53:38.406850Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  107. 2017-05-29T07:53:39.218052Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  108. 2017-05-29T07:53:39.218052Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  109. 2017-05-29T07:53:39.405252Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  110. 2017-05-29T07:53:39.405252Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  111. 2017-05-29T07:53:39.405252Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  112. 2017-05-29T07:53:39.405252Z 0 [Note] InnoDB: Waiting for purge to start
  113. 2017-05-29T07:53:39.467652Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 167217439
  114. 2017-05-29T07:53:39.498852Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  115. 2017-05-29T07:53:39.561252Z 0 [Note] Plugin 'FEDERATED' is disabled.
  116. 2017-05-29T07:53:39.764053Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170529 14:53:39
  117. 2017-05-29T07:53:39.764053Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  118. 2017-05-29T07:53:39.764053Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  119. 2017-05-29T07:53:39.764053Z 0 [Note] IPv6 is available.
  120. 2017-05-29T07:53:39.764053Z 0 [Note] - '::' resolves to '::';
  121. 2017-05-29T07:53:39.764053Z 0 [Note] Server socket created on IP: '::'.
  122. 2017-05-29T07:53:39.935653Z 0 [Note] Event Scheduler: Loaded 0 events
  123. 2017-05-29T07:53:39.935653Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  124. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  125. 2017-05-29T07:53:39.935653Z 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.
  126. 2017-05-29T07:53:39.935653Z 0 [Note] Beginning of list of non-natively partitioned tables
  127. 2017-05-29T07:53:44.568861Z 0 [Note] End of list of non-natively partitioned tables
  128. 2017-05-29T07:58:08.852431Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  129.  
  130. 2017-05-29T07:58:08.852431Z 0 [Note] Giving 0 client threads a chance to die gracefully
  131. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down slave threads
  132. 2017-05-29T07:58:08.852431Z 0 [Note] Forcefully disconnecting 0 remaining clients
  133. 2017-05-29T07:58:08.852431Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  134. 2017-05-29T07:58:08.852431Z 0 [Note] Binlog end
  135. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'ngram'
  136. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'partition'
  137. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  138. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'ARCHIVE'
  139. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  140. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  141. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'MyISAM'
  142. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  143. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  144. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  145. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  146. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  147. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  148. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  149. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  150. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  151. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  152. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  153. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  154. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  155. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  156. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  157. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  158. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  159. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  160. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  161. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  162. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  163. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  164. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  165. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  166. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  167. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  168. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  169. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  170. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  171. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  172. 2017-05-29T07:58:08.852431Z 0 [Note] Shutting down plugin 'InnoDB'
  173. 2017-05-29T07:58:08.852431Z 0 [Note] InnoDB: FTS optimize thread exiting.
  174. 2017-05-29T07:58:08.852431Z 0 [Note] InnoDB: Starting shutdown...
  175. 2017-05-29T07:58:08.961632Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  176. 2017-05-29T07:58:08.961632Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170529 14:58:08
  177. 2017-05-29T07:58:10.147234Z 0 [Note] InnoDB: Shutdown completed; log sequence number 167217467
  178. 2017-05-29T07:58:10.147234Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  179. 2017-05-29T07:58:10.147234Z 0 [Note] Shutting down plugin 'MEMORY'
  180. 2017-05-29T07:58:10.147234Z 0 [Note] Shutting down plugin 'CSV'
  181. 2017-05-29T07:58:10.147234Z 0 [Note] Shutting down plugin 'sha256_password'
  182. 2017-05-29T07:58:10.147234Z 0 [Note] Shutting down plugin 'mysql_native_password'
  183. 2017-05-29T07:58:10.147234Z 0 [Note] Shutting down plugin 'binlog'
  184. 2017-05-29T07:58:10.162834Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  185.  
  186. 2017-05-29T07:58:45.051629Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  187. 2017-05-29T07:58:45.067229Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  188. 2017-05-29T07:58:45.114029Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 1704 ...
  189. 2017-05-29T07:58:45.238829Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  190. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: Uses event mutexes
  191. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  192. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  193. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  194. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: Number of pools: 1
  195. 2017-05-29T07:58:45.254429Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  196. 2017-05-29T07:58:45.270029Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  197. 2017-05-29T07:58:45.270029Z 0 [Note] InnoDB: Completed initialization of buffer pool
  198. 2017-05-29T07:58:45.301229Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  199. 2017-05-29T07:58:46.206031Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  200. 2017-05-29T07:58:46.206031Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  201. 2017-05-29T07:58:46.330831Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  202. 2017-05-29T07:58:46.330831Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  203. 2017-05-29T07:58:46.330831Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  204. 2017-05-29T07:58:46.330831Z 0 [Note] InnoDB: Waiting for purge to start
  205. 2017-05-29T07:58:46.393231Z 0 [Note] InnoDB: Waiting for purge to start
  206. 2017-05-29T07:58:46.455631Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 167217467
  207. 2017-05-29T07:58:46.486831Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  208. 2017-05-29T07:58:46.502431Z 0 [Note] Plugin 'FEDERATED' is disabled.
  209. 2017-05-29T07:58:46.752032Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  210. 2017-05-29T07:58:46.767632Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  211. 2017-05-29T07:58:46.767632Z 0 [Note] IPv6 is available.
  212. 2017-05-29T07:58:46.767632Z 0 [Note] - '::' resolves to '::';
  213. 2017-05-29T07:58:46.767632Z 0 [Note] Server socket created on IP: '::'.
  214. 2017-05-29T07:58:46.830032Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170529 14:58:46
  215. 2017-05-29T07:58:46.986032Z 0 [Note] Event Scheduler: Loaded 0 events
  216. 2017-05-29T07:58:46.986032Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  217. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  218. 2017-05-29T07:58:46.986032Z 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.
  219. 2017-05-29T07:58:46.986032Z 0 [Note] Beginning of list of non-natively partitioned tables
  220. 2017-05-29T07:58:50.574038Z 0 [Note] End of list of non-natively partitioned tables
  221. 2017-05-29T08:12:48.178902Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  222.  
  223. 2017-05-29T08:12:48.178902Z 0 [Note] Giving 0 client threads a chance to die gracefully
  224. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down slave threads
  225. 2017-05-29T08:12:48.178902Z 0 [Note] Forcefully disconnecting 0 remaining clients
  226. 2017-05-29T08:12:48.178902Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  227. 2017-05-29T08:12:48.178902Z 0 [Note] Binlog end
  228. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'ngram'
  229. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'partition'
  230. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  231. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'ARCHIVE'
  232. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  233. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  234. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'MyISAM'
  235. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  236. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  237. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  238. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  239. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  240. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  241. 2017-05-29T08:12:48.178902Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  242. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  243. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  244. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  245. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  246. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  247. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  248. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  249. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  250. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  251. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  252. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  253. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  254. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  255. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  256. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  257. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  258. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  259. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  260. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  261. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  262. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  263. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  264. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  265. 2017-05-29T08:12:48.194502Z 0 [Note] Shutting down plugin 'InnoDB'
  266. 2017-05-29T08:12:48.194502Z 0 [Note] InnoDB: FTS optimize thread exiting.
  267. 2017-05-29T08:12:48.194502Z 0 [Note] InnoDB: Starting shutdown...
  268. 2017-05-29T08:12:48.303702Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  269. 2017-05-29T08:12:48.303702Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170529 15:12:48
  270. 2017-05-29T08:12:49.551704Z 0 [Note] InnoDB: Shutdown completed; log sequence number 167217495
  271. 2017-05-29T08:12:49.551704Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  272. 2017-05-29T08:12:49.551704Z 0 [Note] Shutting down plugin 'MEMORY'
  273. 2017-05-29T08:12:49.551704Z 0 [Note] Shutting down plugin 'CSV'
  274. 2017-05-29T08:12:49.551704Z 0 [Note] Shutting down plugin 'sha256_password'
  275. 2017-05-29T08:12:49.551704Z 0 [Note] Shutting down plugin 'mysql_native_password'
  276. 2017-05-29T08:12:49.551704Z 0 [Note] Shutting down plugin 'binlog'
  277. 2017-05-29T08:12:49.567304Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  278.  
  279. 2017-05-29T08:13:25.315231Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  280. 2017-05-29T08:13:25.330831Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  281. 2017-05-29T08:13:25.377631Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 1796 ...
  282. 2017-05-29T08:13:25.502431Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  283. 2017-05-29T08:13:25.502431Z 0 [Note] InnoDB: Uses event mutexes
  284. 2017-05-29T08:13:25.502431Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  285. 2017-05-29T08:13:25.502431Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  286. 2017-05-29T08:13:25.502431Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  287. 2017-05-29T08:13:25.518031Z 0 [Note] InnoDB: Number of pools: 1
  288. 2017-05-29T08:13:25.518031Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  289. 2017-05-29T08:13:25.549231Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  290. 2017-05-29T08:13:25.549231Z 0 [Note] InnoDB: Completed initialization of buffer pool
  291. 2017-05-29T08:13:25.580431Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  292. 2017-05-29T08:13:26.469633Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  293. 2017-05-29T08:13:26.469633Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  294. 2017-05-29T08:13:26.641233Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  295. 2017-05-29T08:13:26.641233Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  296. 2017-05-29T08:13:26.641233Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  297. 2017-05-29T08:13:26.641233Z 0 [Note] InnoDB: Waiting for purge to start
  298. 2017-05-29T08:13:26.703633Z 0 [Note] InnoDB: Waiting for purge to start
  299. 2017-05-29T08:13:26.766033Z 0 [Note] InnoDB: Waiting for purge to start
  300. 2017-05-29T08:13:26.828434Z 0 [Note] InnoDB: Waiting for purge to start
  301. 2017-05-29T08:13:26.890834Z 0 [Note] InnoDB: Waiting for purge to start
  302. 2017-05-29T08:13:26.953234Z 0 [Note] InnoDB: Waiting for purge to start
  303. 2017-05-29T08:13:27.031234Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 167217495
  304. 2017-05-29T08:13:27.140434Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  305. 2017-05-29T08:13:27.312034Z 0 [Note] Plugin 'FEDERATED' is disabled.
  306. 2017-05-29T08:13:27.686435Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  307. 2017-05-29T08:13:27.733235Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  308. 2017-05-29T08:13:27.733235Z 0 [Note] IPv6 is available.
  309. 2017-05-29T08:13:27.733235Z 0 [Note] - '::' resolves to '::';
  310. 2017-05-29T08:13:27.733235Z 0 [Note] Server socket created on IP: '::'.
  311. 2017-05-29T08:13:27.780035Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170529 15:13:27
  312. 2017-05-29T08:13:27.967236Z 0 [Note] Event Scheduler: Loaded 0 events
  313. 2017-05-29T08:13:27.967236Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  314. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  315. 2017-05-29T08:13:27.967236Z 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.
  316. 2017-05-29T08:13:27.967236Z 0 [Note] Beginning of list of non-natively partitioned tables
  317. 2017-05-29T08:13:31.758042Z 0 [Note] End of list of non-natively partitioned tables
  318. 2017-05-29T08:43:02.948933Z 5 [Note] Aborted connection 5 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  319. 2017-05-29T08:43:02.948933Z 4 [Note] Aborted connection 4 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  320. 2017-05-29T08:43:02.948933Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  321. 2017-05-29T08:43:02.948933Z 9 [Note] Aborted connection 9 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  322. 2017-05-29T08:43:02.948933Z 8 [Note] Aborted connection 8 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  323. 2017-05-29T08:43:02.948933Z 7 [Note] Aborted connection 7 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  324. 2017-05-29T08:44:19.518257Z 17 [Note] Aborted connection 17 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  325. 2017-05-29T08:44:19.518257Z 14 [Note] Aborted connection 14 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  326. 2017-05-29T08:44:19.518257Z 15 [Note] Aborted connection 15 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  327. 2017-05-29T08:44:19.518257Z 13 [Note] Aborted connection 13 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  328. 2017-05-29T08:44:19.533857Z 16 [Note] Aborted connection 16 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  329. 2017-05-29T08:44:19.533857Z 12 [Note] Aborted connection 12 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  330. 2017-05-29T08:45:20.882209Z 21 [Note] Aborted connection 21 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  331. 2017-05-29T08:45:20.882209Z 20 [Note] Aborted connection 20 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  332. 2017-05-29T08:45:20.882209Z 25 [Note] Aborted connection 25 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  333. 2017-05-29T08:45:20.882209Z 23 [Note] Aborted connection 23 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  334. 2017-05-29T08:45:20.882209Z 24 [Note] Aborted connection 24 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  335. 2017-05-29T08:45:20.882209Z 22 [Note] Aborted connection 22 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  336. 2017-05-29T08:54:12.141142Z 29 [Note] Aborted connection 29 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  337. 2017-05-29T08:54:12.141142Z 30 [Note] Aborted connection 30 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  338. 2017-05-29T08:54:12.141142Z 28 [Note] Aborted connection 28 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  339. 2017-05-29T08:54:12.141142Z 31 [Note] Aborted connection 31 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  340. 2017-05-29T08:54:12.141142Z 32 [Note] Aborted connection 32 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  341. 2017-05-29T08:54:12.141142Z 33 [Note] Aborted connection 33 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  342. 2017-05-29T08:54:12.141142Z 38 [Note] Aborted connection 38 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  343. 2017-05-29T08:54:12.141142Z 39 [Note] Aborted connection 39 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  344. 2017-05-29T08:54:12.141142Z 36 [Note] Aborted connection 36 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  345. 2017-05-29T08:54:12.141142Z 35 [Note] Aborted connection 35 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  346. 2017-05-29T08:54:12.141142Z 37 [Note] Aborted connection 37 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  347. 2017-05-29T08:54:12.141142Z 40 [Note] Aborted connection 40 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  348. 2017-05-29T09:37:54.918380Z 42 [Note] Aborted connection 42 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  349. 2017-05-29T09:37:54.918380Z 44 [Note] Aborted connection 44 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  350. 2017-05-29T09:37:54.918380Z 45 [Note] Aborted connection 45 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  351. 2017-05-29T09:37:54.918380Z 47 [Note] Aborted connection 47 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  352. 2017-05-29T09:37:54.918380Z 43 [Note] Aborted connection 43 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  353. 2017-05-29T09:37:54.918380Z 46 [Note] Aborted connection 46 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  354. 2017-05-29T09:37:54.918380Z 50 [Note] Aborted connection 50 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  355. 2017-05-29T09:37:54.918380Z 49 [Note] Aborted connection 49 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  356. 2017-05-29T09:37:54.918380Z 52 [Note] Aborted connection 52 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  357. 2017-05-29T09:37:54.918380Z 53 [Note] Aborted connection 53 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  358. 2017-05-29T09:37:54.918380Z 51 [Note] Aborted connection 51 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  359. 2017-05-29T09:37:54.918380Z 54 [Note] Aborted connection 54 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  360. 2017-05-29T09:53:42.465898Z 70 [Note] Aborted connection 70 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  361. 2017-05-29T09:53:42.465898Z 57 [Note] Aborted connection 57 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  362. 2017-05-29T09:53:42.465898Z 58 [Note] Aborted connection 58 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  363. 2017-05-29T09:53:42.465898Z 59 [Note] Aborted connection 59 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  364. 2017-05-29T09:53:42.465898Z 56 [Note] Aborted connection 56 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  365. 2017-05-29T09:53:42.465898Z 61 [Note] Aborted connection 61 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  366. 2017-05-29T09:53:42.465898Z 60 [Note] Aborted connection 60 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  367. 2017-05-29T09:53:42.465898Z 71 [Note] Aborted connection 71 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  368. 2017-05-29T09:53:42.465898Z 69 [Note] Aborted connection 69 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  369. 2017-05-29T09:53:42.465898Z 63 [Note] Aborted connection 63 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  370. 2017-05-29T09:53:42.465898Z 65 [Note] Aborted connection 65 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  371. 2017-05-29T09:53:42.465898Z 67 [Note] Aborted connection 67 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  372. 2017-05-29T09:53:42.465898Z 68 [Note] Aborted connection 68 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  373. 2017-05-29T09:53:42.465898Z 64 [Note] Aborted connection 64 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  374. 2017-05-29T09:53:42.465898Z 66 [Note] Aborted connection 66 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  375. 2017-05-29T10:00:41.297860Z 74 [Note] Aborted connection 74 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  376. 2017-05-29T10:00:41.297860Z 75 [Note] Aborted connection 75 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  377. 2017-05-29T10:00:41.297860Z 73 [Note] Aborted connection 73 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  378. 2017-05-29T10:00:41.297860Z 76 [Note] Aborted connection 76 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  379. 2017-05-29T10:00:41.297860Z 77 [Note] Aborted connection 77 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  380. 2017-05-29T10:00:41.297860Z 78 [Note] Aborted connection 78 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  381. 2017-05-29T10:00:41.297860Z 80 [Note] Aborted connection 80 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  382. 2017-05-29T10:00:41.297860Z 81 [Note] Aborted connection 81 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  383. 2017-05-29T10:00:41.297860Z 82 [Note] Aborted connection 82 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  384. 2017-05-29T10:00:41.297860Z 83 [Note] Aborted connection 83 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  385. 2017-05-29T10:00:41.297860Z 84 [Note] Aborted connection 84 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  386. 2017-05-29T10:00:41.297860Z 85 [Note] Aborted connection 85 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  387. 2017-05-29T10:01:01.156695Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  388.  
  389. 2017-05-29T10:01:01.156695Z 0 [Note] Giving 0 client threads a chance to die gracefully
  390. 2017-05-29T10:01:01.156695Z 0 [Note] Shutting down slave threads
  391. 2017-05-29T10:01:01.468696Z 0 [Note] Forcefully disconnecting 0 remaining clients
  392. 2017-05-29T10:01:01.468696Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  393. 2017-05-29T10:01:01.468696Z 0 [Note] Binlog end
  394. 2017-05-29T10:01:01.484296Z 0 [Note] Shutting down plugin 'ngram'
  395. 2017-05-29T10:01:01.515496Z 0 [Note] Shutting down plugin 'partition'
  396. 2017-05-29T10:01:01.515496Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  397. 2017-05-29T10:01:01.515496Z 0 [Note] Shutting down plugin 'ARCHIVE'
  398. 2017-05-29T10:01:01.515496Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  399. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  400. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'MyISAM'
  401. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  402. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  403. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  404. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  405. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  406. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  407. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  408. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  409. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  410. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  411. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  412. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  413. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  414. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  415. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  416. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  417. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  418. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  419. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  420. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  421. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  422. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  423. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  424. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  425. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  426. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  427. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  428. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  429. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  430. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  431. 2017-05-29T10:01:01.531096Z 0 [Note] Shutting down plugin 'InnoDB'
  432. 2017-05-29T10:01:01.531096Z 0 [Note] InnoDB: FTS optimize thread exiting.
  433. 2017-05-29T10:01:01.531096Z 0 [Note] InnoDB: Starting shutdown...
  434. 2017-05-29T10:01:01.640296Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  435. 2017-05-29T10:01:01.640296Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170529 17:01:01
  436. 2017-05-29T10:01:02.919498Z 0 [Note] InnoDB: Shutdown completed; log sequence number 168628971
  437. 2017-05-29T10:01:02.919498Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  438. 2017-05-29T10:01:02.919498Z 0 [Note] Shutting down plugin 'MEMORY'
  439. 2017-05-29T10:01:02.919498Z 0 [Note] Shutting down plugin 'CSV'
  440. 2017-05-29T10:01:02.919498Z 0 [Note] Shutting down plugin 'sha256_password'
  441. 2017-05-29T10:01:02.919498Z 0 [Note] Shutting down plugin 'mysql_native_password'
  442. 2017-05-29T10:01:02.919498Z 0 [Note] Shutting down plugin 'binlog'
  443. 2017-05-29T10:01:03.013099Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  444.  
  445. 2017-05-30T01:52:58.493224Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  446. 2017-05-30T01:52:58.493224Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  447. 2017-05-30T01:52:58.540024Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 684 ...
  448. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  449. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Uses event mutexes
  450. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  451. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  452. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  453. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Number of pools: 1
  454. 2017-05-30T01:52:58.649224Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  455. 2017-05-30T01:52:58.680424Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  456. 2017-05-30T01:52:58.680424Z 0 [Note] InnoDB: Completed initialization of buffer pool
  457. 2017-05-30T01:52:58.742825Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  458. 2017-05-30T01:53:00.521228Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  459. 2017-05-30T01:53:00.521228Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  460. 2017-05-30T01:53:01.176429Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  461. 2017-05-30T01:53:01.176429Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  462. 2017-05-30T01:53:01.176429Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  463. 2017-05-30T01:53:01.176429Z 0 [Note] InnoDB: Waiting for purge to start
  464. 2017-05-30T01:53:01.238829Z 0 [Note] InnoDB: Waiting for purge to start
  465. 2017-05-30T01:53:01.316829Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 168628971
  466. 2017-05-30T01:53:01.519629Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  467. 2017-05-30T01:53:01.691230Z 0 [Note] Plugin 'FEDERATED' is disabled.
  468. 2017-05-30T01:53:01.987630Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  469. 2017-05-30T01:53:01.987630Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  470. 2017-05-30T01:53:01.987630Z 0 [Note] IPv6 is available.
  471. 2017-05-30T01:53:01.987630Z 0 [Note] - '::' resolves to '::';
  472. 2017-05-30T01:53:01.987630Z 0 [Note] Server socket created on IP: '::'.
  473. 2017-05-30T01:53:02.050030Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170530 8:53:02
  474. 2017-05-30T01:53:02.252831Z 0 [Note] Event Scheduler: Loaded 0 events
  475. 2017-05-30T01:53:02.252831Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  476. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  477. 2017-05-30T01:53:02.252831Z 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.
  478. 2017-05-30T01:53:02.252831Z 0 [Note] Beginning of list of non-natively partitioned tables
  479. 2017-05-30T01:53:06.605238Z 0 [Note] End of list of non-natively partitioned tables
  480. 2017-05-30T09:50:50.423184Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  481.  
  482. 2017-05-30T09:50:50.423184Z 0 [Note] Giving 0 client threads a chance to die gracefully
  483. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down slave threads
  484. 2017-05-30T09:50:50.423184Z 0 [Note] Forcefully disconnecting 0 remaining clients
  485. 2017-05-30T09:50:50.423184Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  486. 2017-05-30T09:50:50.423184Z 0 [Note] Binlog end
  487. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'ngram'
  488. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'partition'
  489. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  490. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'ARCHIVE'
  491. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  492. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  493. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'MyISAM'
  494. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  495. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  496. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  497. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  498. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  499. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  500. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  501. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  502. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  503. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  504. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  505. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  506. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  507. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  508. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  509. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  510. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  511. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  512. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  513. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  514. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  515. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  516. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  517. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  518. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  519. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  520. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  521. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  522. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  523. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  524. 2017-05-30T09:50:50.423184Z 0 [Note] Shutting down plugin 'InnoDB'
  525. 2017-05-30T09:50:50.423184Z 0 [Note] InnoDB: FTS optimize thread exiting.
  526. 2017-05-30T09:50:50.423184Z 0 [Note] InnoDB: Starting shutdown...
  527. 2017-05-30T09:50:50.532384Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  528. 2017-05-30T09:50:50.532384Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170530 16:50:50
  529. 2017-05-30T09:50:52.357587Z 0 [Note] InnoDB: Shutdown completed; log sequence number 168628999
  530. 2017-05-30T09:50:52.357587Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  531. 2017-05-30T09:50:52.357587Z 0 [Note] Shutting down plugin 'MEMORY'
  532. 2017-05-30T09:50:52.357587Z 0 [Note] Shutting down plugin 'CSV'
  533. 2017-05-30T09:50:52.357587Z 0 [Note] Shutting down plugin 'sha256_password'
  534. 2017-05-30T09:50:52.357587Z 0 [Note] Shutting down plugin 'mysql_native_password'
  535. 2017-05-30T09:50:52.357587Z 0 [Note] Shutting down plugin 'binlog'
  536. 2017-05-30T09:50:52.716388Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  537.  
  538. 2017-05-31T01:57:51.348029Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  539. 2017-05-31T01:57:51.363629Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  540. 2017-05-31T01:57:51.426029Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 1500 ...
  541. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  542. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: Uses event mutexes
  543. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  544. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  545. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  546. 2017-05-31T01:57:51.566430Z 0 [Note] InnoDB: Number of pools: 1
  547. 2017-05-31T01:57:51.582030Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  548. 2017-05-31T01:57:51.597630Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  549. 2017-05-31T01:57:51.597630Z 0 [Note] InnoDB: Completed initialization of buffer pool
  550. 2017-05-31T01:57:51.691230Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  551. 2017-05-31T01:57:52.986032Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  552. 2017-05-31T01:57:52.986032Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  553. 2017-05-31T01:57:53.563233Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  554. 2017-05-31T01:57:53.563233Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  555. 2017-05-31T01:57:53.563233Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  556. 2017-05-31T01:57:53.578833Z 0 [Note] InnoDB: Waiting for purge to start
  557. 2017-05-31T01:57:53.641233Z 0 [Note] InnoDB: Waiting for purge to start
  558. 2017-05-31T01:57:53.719233Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 168628999
  559. 2017-05-31T01:57:53.906434Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  560. 2017-05-31T01:57:54.124834Z 0 [Note] Plugin 'FEDERATED' is disabled.
  561. 2017-05-31T01:57:54.358834Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  562. 2017-05-31T01:57:54.358834Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  563. 2017-05-31T01:57:54.358834Z 0 [Note] IPv6 is available.
  564. 2017-05-31T01:57:54.358834Z 0 [Note] - '::' resolves to '::';
  565. 2017-05-31T01:57:54.358834Z 0 [Note] Server socket created on IP: '::'.
  566. 2017-05-31T01:57:54.421235Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 8:57:54
  567. 2017-05-31T01:57:54.577235Z 0 [Note] Event Scheduler: Loaded 0 events
  568. 2017-05-31T01:57:54.577235Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  569. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  570. 2017-05-31T01:57:54.577235Z 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.
  571. 2017-05-31T01:57:54.577235Z 0 [Note] Beginning of list of non-natively partitioned tables
  572. 2017-05-31T01:57:59.023243Z 0 [Note] End of list of non-natively partitioned tables
  573. 2017-05-31T04:52:35.330843Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  574.  
  575. 2017-05-31T04:52:35.330843Z 0 [Note] Giving 0 client threads a chance to die gracefully
  576. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down slave threads
  577. 2017-05-31T04:52:35.330843Z 0 [Note] Forcefully disconnecting 0 remaining clients
  578. 2017-05-31T04:52:35.330843Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  579. 2017-05-31T04:52:35.330843Z 0 [Note] Binlog end
  580. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'ngram'
  581. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'partition'
  582. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  583. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'ARCHIVE'
  584. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  585. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  586. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'MyISAM'
  587. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  588. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  589. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  590. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  591. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  592. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  593. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  594. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  595. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  596. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  597. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  598. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  599. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  600. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  601. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  602. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  603. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  604. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  605. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  606. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  607. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  608. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  609. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  610. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  611. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  612. 2017-05-31T04:52:35.330843Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  613. 2017-05-31T04:52:35.346443Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  614. 2017-05-31T04:52:35.346443Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  615. 2017-05-31T04:52:35.346443Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  616. 2017-05-31T04:52:35.346443Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  617. 2017-05-31T04:52:35.346443Z 0 [Note] Shutting down plugin 'InnoDB'
  618. 2017-05-31T04:52:35.346443Z 0 [Note] InnoDB: FTS optimize thread exiting.
  619. 2017-05-31T04:52:35.346443Z 0 [Note] InnoDB: Starting shutdown...
  620. 2017-05-31T04:52:35.455643Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  621. 2017-05-31T04:52:35.455643Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170531 11:52:35
  622. 2017-05-31T04:52:36.875246Z 0 [Note] InnoDB: Shutdown completed; log sequence number 168629027
  623. 2017-05-31T04:52:36.875246Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  624. 2017-05-31T04:52:36.875246Z 0 [Note] Shutting down plugin 'MEMORY'
  625. 2017-05-31T04:52:36.875246Z 0 [Note] Shutting down plugin 'CSV'
  626. 2017-05-31T04:52:36.875246Z 0 [Note] Shutting down plugin 'sha256_password'
  627. 2017-05-31T04:52:36.875246Z 0 [Note] Shutting down plugin 'mysql_native_password'
  628. 2017-05-31T04:52:36.875246Z 0 [Note] Shutting down plugin 'binlog'
  629. 2017-05-31T04:52:37.109246Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  630.  
  631. 2017-05-31T04:54:47.760023Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  632. 2017-05-31T04:54:47.760023Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  633. 2017-05-31T04:54:47.775623Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 2164 ...
  634. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  635. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Uses event mutexes
  636. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  637. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  638. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  639. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Number of pools: 1
  640. 2017-05-31T04:54:47.900423Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  641. 2017-05-31T04:54:47.916023Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  642. 2017-05-31T04:54:47.931623Z 0 [Note] InnoDB: Completed initialization of buffer pool
  643. 2017-05-31T04:54:47.962823Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  644. 2017-05-31T04:54:49.023625Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  645. 2017-05-31T04:54:49.023625Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  646. 2017-05-31T04:54:49.382426Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  647. 2017-05-31T04:54:49.382426Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  648. 2017-05-31T04:54:49.382426Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  649. 2017-05-31T04:54:49.382426Z 0 [Note] InnoDB: Waiting for purge to start
  650. 2017-05-31T04:54:49.444826Z 0 [Note] InnoDB: Waiting for purge to start
  651. 2017-05-31T04:54:49.522826Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 168629027
  652. 2017-05-31T04:54:49.600826Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  653. 2017-05-31T04:54:49.725626Z 0 [Note] Plugin 'FEDERATED' is disabled.
  654. 2017-05-31T04:54:49.912827Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  655. 2017-05-31T04:54:49.928427Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  656. 2017-05-31T04:54:49.928427Z 0 [Note] IPv6 is available.
  657. 2017-05-31T04:54:49.928427Z 0 [Note] - '::' resolves to '::';
  658. 2017-05-31T04:54:49.928427Z 0 [Note] Server socket created on IP: '::'.
  659. 2017-05-31T04:54:50.100027Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 11:54:50
  660. 2017-05-31T04:54:50.240427Z 0 [Note] Event Scheduler: Loaded 0 events
  661. 2017-05-31T04:54:50.240427Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  662. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  663. 2017-05-31T04:54:50.240427Z 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.
  664. 2017-05-31T04:54:50.256027Z 0 [Note] Beginning of list of non-natively partitioned tables
  665. 2017-05-31T04:54:52.362031Z 0 [Note] End of list of non-natively partitioned tables
  666. 2017-05-31T06:14:35.394112Z 19 [Note] Aborted connection 19 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  667. 2017-05-31T06:14:35.394112Z 5 [Note] Aborted connection 5 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  668. 2017-05-31T06:14:35.394112Z 4 [Note] Aborted connection 4 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  669. 2017-05-31T06:14:35.394112Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  670. 2017-05-31T06:14:35.394112Z 8 [Note] Aborted connection 8 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  671. 2017-05-31T06:14:35.394112Z 9 [Note] Aborted connection 9 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  672. 2017-05-31T06:14:35.394112Z 7 [Note] Aborted connection 7 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  673. 2017-05-31T06:14:35.394112Z 18 [Note] Aborted connection 18 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  674. 2017-05-31T06:14:35.394112Z 17 [Note] Aborted connection 17 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  675. 2017-05-31T06:14:35.394112Z 13 [Note] Aborted connection 13 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  676. 2017-05-31T06:14:35.394112Z 11 [Note] Aborted connection 11 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  677. 2017-05-31T06:14:35.394112Z 15 [Note] Aborted connection 15 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  678. 2017-05-31T06:14:35.394112Z 14 [Note] Aborted connection 14 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  679. 2017-05-31T06:14:35.394112Z 12 [Note] Aborted connection 12 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  680. 2017-05-31T06:14:35.394112Z 16 [Note] Aborted connection 16 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  681. 2017-05-31T06:57:17.439413Z 23 [Note] Aborted connection 23 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  682. 2017-05-31T06:57:17.439413Z 22 [Note] Aborted connection 22 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  683. 2017-05-31T06:57:17.439413Z 24 [Note] Aborted connection 24 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  684. 2017-05-31T06:57:17.439413Z 21 [Note] Aborted connection 21 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  685. 2017-05-31T06:57:17.439413Z 26 [Note] Aborted connection 26 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  686. 2017-05-31T06:57:17.439413Z 25 [Note] Aborted connection 25 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  687. 2017-05-31T06:57:17.439413Z 28 [Note] Aborted connection 28 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  688. 2017-05-31T06:57:17.439413Z 32 [Note] Aborted connection 32 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  689. 2017-05-31T06:57:17.439413Z 29 [Note] Aborted connection 29 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  690. 2017-05-31T06:57:17.439413Z 31 [Note] Aborted connection 31 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  691. 2017-05-31T06:57:17.439413Z 33 [Note] Aborted connection 33 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  692. 2017-05-31T06:57:17.439413Z 30 [Note] Aborted connection 30 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  693. 07:25:59 UTC - mysqld got exception 0xc000001d ;
  694. This could be because you hit a bug. It is also possible that this binary
  695. or one of the libraries it was linked against is corrupt, improperly built,
  696. or misconfigured. This error can also be caused by malfunctioning hardware.
  697. Attempting to collect some information that could help diagnose the problem.
  698. As this is a crash and something is definitely wrong, the information
  699. collection process might fail.
  700.  
  701. key_buffer_size=8388608
  702. read_buffer_size=65536
  703. max_used_connections=15
  704. max_threads=151
  705. thread_count=13
  706. connection_count=13
  707. It is possible that mysqld could use up to
  708. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58347 K bytes of memory
  709. Hope that's ok; if not, decrease some variables in the equation.
  710.  
  711. Thread pointer: 0x1279d310
  712. Attempting backtrace. You can use the following information to find out
  713. where mysqld died. If you see no messages after this, something went
  714. terribly wrong...
  715. 7fef7245c01 MSVCR120.dll!pow()
  716. 13fad5f5a mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
  717. 14008ebe7 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
  718. 140084be9 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
  719. 140090ed5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
  720. 13fc434fe mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
  721. 13fc41f5d mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
  722. 13fc44cc9 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
  723. 13fc4683b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
  724. 13fc8e509 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
  725. 13fc8c52d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
  726. 13fb03cb7 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
  727. 13fb05be6 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
  728. 13fb09643 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
  729. 13fb026f3 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
  730. 13fb0372a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
  731. 13fad06ac mysqld.exe!handle_connection()
  732. 1404fdd42 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
  733. 14021133c mysqld.exe!my_thread_once()
  734. 7fef71d4f7f MSVCR120.dll!_beginthreadex()
  735. 7fef71d5126 MSVCR120.dll!_endthreadex()
  736. 7710f56d kernel32.dll!BaseThreadInitThunk()
  737. 77243281 ntdll.dll!RtlUserThreadStart()
  738.  
  739. Trying to get some variables.
  740. Some pointers may be invalid and cause the dump to abort.
  741. Query (15960dc0): select distinct supplier2_.id as id14_, supplier2_.version as version14_, supplier2_.accountNo as accountNo14_, supplier2_.address as address14_, supplier2_.area as area14_, supplier2_.bank as bank14_, supplier2_.city as city14_, supplier2_.code as code14_, supplier2_.email as email14_, supplier2_.fax as fax14_, supplier2_.mobile as mobile14_, supplier2_.name as name14_, supplier2_.telephone as telephone14_, supplier2_.kelurahan as kelurahan14_, supplier2_.kecamatan as kecamatan14_, supplier2_.active as active14_, supplier2_.creditPeriod as creditP17_14_, supplier2_.bulkPricePercent as bulkPri18_14_, supplier2_.boxPricePercent as boxPric19_14_, supplier2_.retailPricePercent as retailP20_14_, supplier2_.scope as scope14_, supplier2_.country as country14_, supplier2_.taxNo as taxNo14_, supplier2_.contact as contact14_, supplier2_.birthdate as birthdate14_, supplier2_.birthplace as birthplace14_, supplier2_.weightExpression as weightE27_14_, supplier2_.vat as vat14_, supplier2_.vehicle as vehicle14_, supplier2_.
  742. Connection ID (thread ID): 44
  743. Status: NOT_KILLED
  744.  
  745. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  746. information that should help you find out what is causing the crash.
  747. 2017-05-31T07:49:56.213803Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  748. 2017-05-31T07:49:56.213803Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  749. 2017-05-31T07:49:56.213803Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 3824 ...
  750. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  751. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Uses event mutexes
  752. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  753. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  754. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  755. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Number of pools: 1
  756. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  757. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  758. 2017-05-31T07:49:56.229403Z 0 [Note] InnoDB: Completed initialization of buffer pool
  759. 2017-05-31T07:49:56.276203Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  760. 2017-05-31T07:49:56.276203Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 170931679
  761. 2017-05-31T07:49:56.276203Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 170932402
  762. 2017-05-31T07:49:56.291803Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 170932402
  763. 2017-05-31T07:49:56.291803Z 0 [Note] InnoDB: Database was not shutdown normally!
  764. 2017-05-31T07:49:56.307403Z 0 [Note] InnoDB: Starting crash recovery.
  765. 2017-05-31T07:49:58.429007Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 82 row operations to undo
  766. 2017-05-31T07:49:58.429007Z 0 [Note] InnoDB: Trx id counter is 67584
  767. 2017-05-31T07:49:58.429007Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
  768. InnoDB: Progress in percent: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  769. 2017-05-31T07:49:58.959408Z 0 [Note] InnoDB: Apply batch completed
  770. 2017-05-31T07:50:00.472610Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
  771. 2017-05-31T07:50:00.472610Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  772. 2017-05-31T07:50:00.472610Z 0 [Note] InnoDB: Rolling back trx with id 67090, 82 rows to undo
  773. 2017-05-31T07:50:00.472610Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  774. 2017-05-31T07:50:00.488210Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  775. 2017-05-31T07:50:00.815811Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  776. 2017-05-31T07:50:00.815811Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  777. 2017-05-31T07:50:00.815811Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  778. 2017-05-31T07:50:00.815811Z 0 [Note] InnoDB: Waiting for purge to start
  779. 2017-05-31T07:50:00.878211Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4649ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  780. 2017-05-31T07:50:00.878211Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 170932402
  781. 2017-05-31T07:50:00.893811Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  782. 2017-05-31T07:50:00.893811Z 0 [Note] Plugin 'FEDERATED' is disabled.
  783. 2017-05-31T07:50:00.956211Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  784. 2017-05-31T07:50:00.956211Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  785. 2017-05-31T07:50:00.956211Z 0 [Note] IPv6 is available.
  786. 2017-05-31T07:50:00.956211Z 0 [Note] - '::' resolves to '::';
  787. 2017-05-31T07:50:00.956211Z 0 [Note] Server socket created on IP: '::'.
  788. 2017-05-31T07:50:01.112212Z 0 [Note] InnoDB: Rollback of trx with id 67090 completed
  789. 2017-05-31T07:50:01.112212Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed
  790. 2017-05-31T07:50:01.143412Z 0 [Note] Event Scheduler: Loaded 0 events
  791. 2017-05-31T07:50:01.143412Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  792. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  793. 2017-05-31T07:50:01.143412Z 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.
  794. 2017-05-31T07:50:01.143412Z 0 [Note] Beginning of list of non-natively partitioned tables
  795. 2017-05-31T07:50:01.159012Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 14:50:01
  796. 2017-05-31T07:50:01.205812Z 0 [Note] End of list of non-natively partitioned tables
  797. 2017-05-31T07:50:15.869837Z 4 [Note] Aborted connection 4 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  798. 2017-05-31T07:50:15.869837Z 3 [Note] Aborted connection 3 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  799. 2017-05-31T07:50:15.869837Z 5 [Note] Aborted connection 5 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  800. 2017-05-31T07:50:15.869837Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  801. 2017-05-31T07:50:15.869837Z 8 [Note] Aborted connection 8 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  802. 2017-05-31T07:50:15.869837Z 7 [Note] Aborted connection 7 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  803. 07:53:35 UTC - mysqld got exception 0xc000001d ;
  804. This could be because you hit a bug. It is also possible that this binary
  805. or one of the libraries it was linked against is corrupt, improperly built,
  806. or misconfigured. This error can also be caused by malfunctioning hardware.
  807. Attempting to collect some information that could help diagnose the problem.
  808. As this is a crash and something is definitely wrong, the information
  809. collection process might fail.
  810.  
  811. key_buffer_size=8388608
  812. read_buffer_size=65536
  813. max_used_connections=13
  814. max_threads=151
  815. thread_count=13
  816. connection_count=13
  817. It is possible that mysqld could use up to
  818. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58347 K bytes of memory
  819. Hope that's ok; if not, decrease some variables in the equation.
  820.  
  821. Thread pointer: 0x11456240
  822. Attempting backtrace. You can use the following information to find out
  823. where mysqld died. If you see no messages after this, something went
  824. terribly wrong...
  825. 7fef1f85c01 MSVCR120.dll!pow()
  826. 13f295f5a mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
  827. 13f84ebe7 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
  828. 13f844be9 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
  829. 13f850ed5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
  830. 13f4034fe mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
  831. 13f401f5d mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
  832. 13f404cc9 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
  833. 13f40683b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
  834. 13f44e509 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
  835. 13f44c52d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
  836. 13f2c3cb7 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
  837. 13f2c5be6 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
  838. 13f2c9643 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
  839. 13f2c26f3 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
  840. 13f2c372a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
  841. 13f2906ac mysqld.exe!handle_connection()
  842. 13fcbdd42 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
  843. 13f9d133c mysqld.exe!my_thread_once()
  844. 7fef1f14f7f MSVCR120.dll!_beginthreadex()
  845. 7fef1f15126 MSVCR120.dll!_endthreadex()
  846. 7710f56d kernel32.dll!BaseThreadInitThunk()
  847. 77243281 ntdll.dll!RtlUserThreadStart()
  848.  
  849. Trying to get some variables.
  850. Some pointers may be invalid and cause the dump to abort.
  851. Query (1141b970): select purchasefl0_.unitPrice as col_0_0_ from Flow purchasefl0_ where purchasefl0_.class='com.katalisindonesia.prosper.model.momentum.PurchaseFlow' and purchasefl0_.inventory='4028e48a5c5d4b7b015c5d53c3040005' order by purchasefl0_.date desc, purchasefl0_.id desc limit 1
  852. Connection ID (thread ID): 19
  853. Status: NOT_KILLED
  854.  
  855. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  856. information that should help you find out what is causing the crash.
  857. 2017-05-31T07:54:39.197460Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  858. 2017-05-31T07:54:39.197460Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  859. 2017-05-31T07:54:39.197460Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 1312 ...
  860. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  861. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: Uses event mutexes
  862. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  863. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  864. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  865. 2017-05-31T07:54:39.197460Z 0 [Note] InnoDB: Number of pools: 1
  866. 2017-05-31T07:54:39.213060Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  867. 2017-05-31T07:54:39.213060Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  868. 2017-05-31T07:54:39.213060Z 0 [Note] InnoDB: Completed initialization of buffer pool
  869. 2017-05-31T07:54:39.244260Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  870. 2017-05-31T07:54:39.259860Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 171021261
  871. 2017-05-31T07:54:39.259860Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 171021270
  872. 2017-05-31T07:54:39.259860Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 171021270
  873. 2017-05-31T07:54:39.259860Z 0 [Note] InnoDB: Database was not shutdown normally!
  874. 2017-05-31T07:54:39.259860Z 0 [Note] InnoDB: Starting crash recovery.
  875. 2017-05-31T07:54:40.008661Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  876. 2017-05-31T07:54:40.008661Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  877. 2017-05-31T07:54:40.008661Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  878. 2017-05-31T07:54:40.164662Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  879. 2017-05-31T07:54:40.164662Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  880. 2017-05-31T07:54:40.164662Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  881. 2017-05-31T07:54:40.164662Z 0 [Note] InnoDB: Waiting for purge to start
  882. 2017-05-31T07:54:40.227062Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 171021270
  883. 2017-05-31T07:54:40.227062Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  884. 2017-05-31T07:54:40.227062Z 0 [Note] Plugin 'FEDERATED' is disabled.
  885. 2017-05-31T07:54:40.383062Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  886. 2017-05-31T07:54:40.383062Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  887. 2017-05-31T07:54:40.383062Z 0 [Note] IPv6 is available.
  888. 2017-05-31T07:54:40.383062Z 0 [Note] - '::' resolves to '::';
  889. 2017-05-31T07:54:40.383062Z 0 [Note] Server socket created on IP: '::'.
  890. 2017-05-31T07:54:40.445462Z 0 [Note] Event Scheduler: Loaded 0 events
  891. 2017-05-31T07:54:40.445462Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  892. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  893. 2017-05-31T07:54:40.445462Z 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.
  894. 2017-05-31T07:54:40.445462Z 0 [Note] Beginning of list of non-natively partitioned tables
  895. 2017-05-31T07:54:40.461062Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 14:54:40
  896. 2017-05-31T07:54:40.523462Z 0 [Note] End of list of non-natively partitioned tables
  897. 2017-05-31T07:55:13.829521Z 7 [Note] Aborted connection 7 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  898. 2017-05-31T07:55:13.829521Z 8 [Note] Aborted connection 8 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  899. 2017-05-31T07:55:13.829521Z 4 [Note] Aborted connection 4 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  900. 2017-05-31T07:55:13.829521Z 15 [Note] Aborted connection 15 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  901. 2017-05-31T07:55:13.829521Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  902. 2017-05-31T07:55:13.829521Z 5 [Note] Aborted connection 5 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  903. 2017-05-31T07:55:13.829521Z 17 [Note] Aborted connection 17 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  904. 2017-05-31T07:55:13.829521Z 10 [Note] Aborted connection 10 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  905. 2017-05-31T07:55:13.829521Z 14 [Note] Aborted connection 14 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  906. 2017-05-31T07:55:13.829521Z 9 [Note] Aborted connection 9 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  907. 2017-05-31T07:55:13.829521Z 13 [Note] Aborted connection 13 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  908. 2017-05-31T07:55:13.829521Z 12 [Note] Aborted connection 12 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  909. 2017-05-31T07:55:13.829521Z 3 [Note] Aborted connection 3 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  910. 2017-05-31T07:55:13.829521Z 11 [Note] Aborted connection 11 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  911. 2017-05-31T07:55:13.829521Z 16 [Note] Aborted connection 16 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  912. 2017-05-31T07:55:28.524747Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  913.  
  914. 2017-05-31T07:55:28.524747Z 0 [Note] Giving 0 client threads a chance to die gracefully
  915. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down slave threads
  916. 2017-05-31T07:55:28.524747Z 0 [Note] Forcefully disconnecting 0 remaining clients
  917. 2017-05-31T07:55:28.524747Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  918. 2017-05-31T07:55:28.524747Z 0 [Note] Binlog end
  919. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'ngram'
  920. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'partition'
  921. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  922. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'ARCHIVE'
  923. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  924. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  925. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'MyISAM'
  926. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  927. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  928. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  929. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  930. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  931. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  932. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  933. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  934. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  935. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  936. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  937. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  938. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  939. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  940. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  941. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  942. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  943. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  944. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  945. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  946. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  947. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  948. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  949. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  950. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  951. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  952. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  953. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  954. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  955. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  956. 2017-05-31T07:55:28.524747Z 0 [Note] Shutting down plugin 'InnoDB'
  957. 2017-05-31T07:55:28.524747Z 0 [Note] InnoDB: FTS optimize thread exiting.
  958. 2017-05-31T07:55:28.524747Z 0 [Note] InnoDB: Starting shutdown...
  959. 2017-05-31T07:55:28.633947Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  960. 2017-05-31T07:55:28.633947Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170531 14:55:28
  961. 2017-05-31T07:55:29.913149Z 0 [Note] InnoDB: Shutdown completed; log sequence number 171035194
  962. 2017-05-31T07:55:29.913149Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  963. 2017-05-31T07:55:29.913149Z 0 [Note] Shutting down plugin 'MEMORY'
  964. 2017-05-31T07:55:29.913149Z 0 [Note] Shutting down plugin 'CSV'
  965. 2017-05-31T07:55:29.913149Z 0 [Note] Shutting down plugin 'sha256_password'
  966. 2017-05-31T07:55:29.913149Z 0 [Note] Shutting down plugin 'mysql_native_password'
  967. 2017-05-31T07:55:29.913149Z 0 [Note] Shutting down plugin 'binlog'
  968. 2017-05-31T07:55:29.959949Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  969.  
  970. 2017-05-31T07:55:56.153220Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  971. 2017-05-31T07:55:56.153220Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  972. 2017-05-31T07:55:56.200020Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 2104 ...
  973. 2017-05-31T07:55:56.278020Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  974. 2017-05-31T07:55:56.278020Z 0 [Note] InnoDB: Uses event mutexes
  975. 2017-05-31T07:55:56.278020Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  976. 2017-05-31T07:55:56.278020Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  977. 2017-05-31T07:55:56.278020Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  978. 2017-05-31T07:55:56.293620Z 0 [Note] InnoDB: Number of pools: 1
  979. 2017-05-31T07:55:56.293620Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  980. 2017-05-31T07:55:56.340420Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  981. 2017-05-31T07:55:56.340420Z 0 [Note] InnoDB: Completed initialization of buffer pool
  982. 2017-05-31T07:55:56.418420Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  983. 2017-05-31T07:55:57.323222Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  984. 2017-05-31T07:55:57.323222Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  985. 2017-05-31T07:55:57.432422Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  986. 2017-05-31T07:55:57.432422Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  987. 2017-05-31T07:55:57.432422Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  988. 2017-05-31T07:55:57.432422Z 0 [Note] InnoDB: Waiting for purge to start
  989. 2017-05-31T07:55:57.494822Z 0 [Note] InnoDB: Waiting for purge to start
  990. 2017-05-31T07:55:57.572823Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 171035194
  991. 2017-05-31T07:55:57.682023Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  992. 2017-05-31T07:55:57.728823Z 0 [Note] Plugin 'FEDERATED' is disabled.
  993. 2017-05-31T07:55:57.900423Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 14:55:57
  994. 2017-05-31T07:55:57.916023Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  995. 2017-05-31T07:55:57.916023Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  996. 2017-05-31T07:55:57.916023Z 0 [Note] IPv6 is available.
  997. 2017-05-31T07:55:57.916023Z 0 [Note] - '::' resolves to '::';
  998. 2017-05-31T07:55:57.916023Z 0 [Note] Server socket created on IP: '::'.
  999. 2017-05-31T07:55:58.118823Z 0 [Note] Event Scheduler: Loaded 0 events
  1000. 2017-05-31T07:55:58.118823Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  1001. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  1002. 2017-05-31T07:55:58.118823Z 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.
  1003. 2017-05-31T07:55:58.118823Z 0 [Note] Beginning of list of non-natively partitioned tables
  1004. 2017-05-31T07:55:59.288826Z 0 [Note] End of list of non-natively partitioned tables
  1005. 2017-05-31T07:58:51.079327Z 5 [Note] Aborted connection 5 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1006. 2017-05-31T07:58:51.079327Z 4 [Note] Aborted connection 4 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1007. 2017-05-31T07:58:51.079327Z 6 [Note] Aborted connection 6 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1008. 2017-05-31T07:58:51.079327Z 7 [Note] Aborted connection 7 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1009. 2017-05-31T07:58:51.079327Z 9 [Note] Aborted connection 9 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1010. 2017-05-31T07:58:51.079327Z 8 [Note] Aborted connection 8 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1011. 2017-05-31T07:58:51.079327Z 11 [Note] Aborted connection 11 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1012. 2017-05-31T07:58:51.079327Z 13 [Note] Aborted connection 13 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1013. 2017-05-31T07:58:51.079327Z 12 [Note] Aborted connection 12 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1014. 2017-05-31T07:58:51.079327Z 15 [Note] Aborted connection 15 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1015. 2017-05-31T07:58:51.079327Z 16 [Note] Aborted connection 16 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1016. 2017-05-31T07:58:51.079327Z 14 [Note] Aborted connection 14 to db: 'prosperbali' user: 'prosperbali' host: 'Server' (Got an error reading communication packets)
  1017. 08:07:18 UTC - mysqld got exception 0xc000001d ;
  1018. This could be because you hit a bug. It is also possible that this binary
  1019. or one of the libraries it was linked against is corrupt, improperly built,
  1020. or misconfigured. This error can also be caused by malfunctioning hardware.
  1021. Attempting to collect some information that could help diagnose the problem.
  1022. As this is a crash and something is definitely wrong, the information
  1023. collection process might fail.
  1024.  
  1025. key_buffer_size=8388608
  1026. read_buffer_size=65536
  1027. max_used_connections=13
  1028. max_threads=151
  1029. thread_count=13
  1030. connection_count=13
  1031. It is possible that mysqld could use up to
  1032. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58347 K bytes of memory
  1033. Hope that's ok; if not, decrease some variables in the equation.
  1034.  
  1035. Thread pointer: 0x134e5f20
  1036. Attempting backtrace. You can use the following information to find out
  1037. where mysqld died. If you see no messages after this, something went
  1038. terribly wrong...
  1039. 7fef76d5c01 MSVCR120.dll!pow()
  1040. 13fd05f5a mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
  1041. 1402bebe7 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
  1042. 1402b4be9 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
  1043. 1402c0ed5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
  1044. 13fe734fe mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
  1045. 13fe71f5d mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
  1046. 13fe74cc9 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
  1047. 13fe7683b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
  1048. 13febe509 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
  1049. 13febc52d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
  1050. 13fd33cb7 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
  1051. 13fd35be6 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
  1052. 13fd39643 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
  1053. 13fd326f3 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
  1054. 13fd3372a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
  1055. 13fd006ac mysqld.exe!handle_connection()
  1056. 14072dd42 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
  1057. 14044133c mysqld.exe!my_thread_once()
  1058. 7fef7664f7f MSVCR120.dll!_beginthreadex()
  1059. 7fef7665126 MSVCR120.dll!_endthreadex()
  1060. 776bf56d kernel32.dll!BaseThreadInitThunk()
  1061. 777f3281 ntdll.dll!RtlUserThreadStart()
  1062.  
  1063. Trying to get some variables.
  1064. Some pointers may be invalid and cause the dump to abort.
  1065. Query (aac88c0): select distinct supplier2_.id as id14_, supplier2_.version as version14_, supplier2_.accountNo as accountNo14_, supplier2_.address as address14_, supplier2_.area as area14_, supplier2_.bank as bank14_, supplier2_.city as city14_, supplier2_.code as code14_, supplier2_.email as email14_, supplier2_.fax as fax14_, supplier2_.mobile as mobile14_, supplier2_.name as name14_, supplier2_.telephone as telephone14_, supplier2_.kelurahan as kelurahan14_, supplier2_.kecamatan as kecamatan14_, supplier2_.active as active14_, supplier2_.creditPeriod as creditP17_14_, supplier2_.bulkPricePercent as bulkPri18_14_, supplier2_.boxPricePercent as boxPric19_14_, supplier2_.retailPricePercent as retailP20_14_, supplier2_.scope as scope14_, supplier2_.country as country14_, supplier2_.taxNo as taxNo14_, supplier2_.contact as contact14_, supplier2_.birthdate as birthdate14_, supplier2_.birthplace as birthplace14_, supplier2_.weightExpression as weightE27_14_, supplier2_.vat as vat14_, supplier2_.vehicle as vehicle14_, supplier2_.
  1066. Connection ID (thread ID): 30
  1067. Status: NOT_KILLED
  1068.  
  1069. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  1070. information that should help you find out what is causing the crash.
  1071. 2017-05-31T08:09:17.638313Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  1072. 2017-05-31T08:09:17.638313Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  1073. 2017-05-31T08:09:17.638313Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 4188 ...
  1074. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  1075. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Uses event mutexes
  1076. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  1077. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  1078. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  1079. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Number of pools: 1
  1080. 2017-05-31T08:09:17.638313Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  1081. 2017-05-31T08:09:17.653913Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  1082. 2017-05-31T08:09:17.653913Z 0 [Note] InnoDB: Completed initialization of buffer pool
  1083. 2017-05-31T08:09:17.700713Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  1084. 2017-05-31T08:09:17.716313Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 173722169
  1085. 2017-05-31T08:09:17.809913Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 173842857
  1086. 2017-05-31T08:09:17.825513Z 0 [Note] InnoDB: Database was not shutdown normally!
  1087. 2017-05-31T08:09:17.825513Z 0 [Note] InnoDB: Starting crash recovery.
  1088. 2017-05-31T08:09:19.900317Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 16 row operations to undo
  1089. 2017-05-31T08:09:19.900317Z 0 [Note] InnoDB: Trx id counter is 71936
  1090. 2017-05-31T08:09:19.900317Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
  1091. InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  1092. 2017-05-31T08:09:20.633518Z 0 [Note] InnoDB: Apply batch completed
  1093. 2017-05-31T08:09:22.209121Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
  1094. 2017-05-31T08:09:22.209121Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  1095. 2017-05-31T08:09:22.209121Z 0 [Note] InnoDB: Rolling back trx with id 71500, 16 rows to undo
  1096. 2017-05-31T08:09:22.209121Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  1097. 2017-05-31T08:09:22.209121Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  1098. 2017-05-31T08:09:22.318321Z 0 [Note] InnoDB: Rollback of trx with id 71500 completed
  1099. 2017-05-31T08:09:22.318321Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed
  1100. 2017-05-31T08:09:22.411921Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  1101. 2017-05-31T08:09:22.427521Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  1102. 2017-05-31T08:09:22.427521Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  1103. 2017-05-31T08:09:22.427521Z 0 [Note] InnoDB: Waiting for purge to start
  1104. 2017-05-31T08:09:22.489922Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 173842857
  1105. 2017-05-31T08:09:22.489922Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4836ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  1106. 2017-05-31T08:09:22.489922Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  1107. 2017-05-31T08:09:22.489922Z 0 [Note] Plugin 'FEDERATED' is disabled.
  1108. 2017-05-31T08:09:22.552322Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  1109. 2017-05-31T08:09:22.552322Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  1110. 2017-05-31T08:09:22.552322Z 0 [Note] IPv6 is available.
  1111. 2017-05-31T08:09:22.552322Z 0 [Note] - '::' resolves to '::';
  1112. 2017-05-31T08:09:22.552322Z 0 [Note] Server socket created on IP: '::'.
  1113. 2017-05-31T08:09:22.599122Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 15:09:22
  1114. 2017-05-31T08:09:22.661522Z 0 [Note] Event Scheduler: Loaded 0 events
  1115. 2017-05-31T08:09:22.661522Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  1116. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  1117. 2017-05-31T08:09:22.677122Z 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.
  1118. 2017-05-31T08:09:22.677122Z 0 [Note] Beginning of list of non-natively partitioned tables
  1119. 2017-05-31T08:09:22.755122Z 0 [Note] End of list of non-natively partitioned tables
  1120. 2017-05-31T08:17:58.242427Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
  1121.  
  1122. 2017-05-31T08:17:58.242427Z 0 [Note] Giving 6 client threads a chance to die gracefully
  1123. 2017-05-31T08:17:58.242427Z 0 [Note] Shutting down slave threads
  1124. 2017-05-31T08:18:00.254831Z 0 [Note] Forcefully disconnecting 6 remaining clients
  1125. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 3 user: 'prosperbali'
  1126.  
  1127. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 7 user: 'prosperbali'
  1128.  
  1129. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 4 user: 'prosperbali'
  1130.  
  1131. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 5 user: 'prosperbali'
  1132.  
  1133. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 6 user: 'prosperbali'
  1134.  
  1135. 2017-05-31T08:18:00.254831Z 0 [Warning] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 8 user: 'prosperbali'
  1136.  
  1137. 2017-05-31T08:18:00.254831Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  1138. 2017-05-31T08:18:00.254831Z 0 [Note] Binlog end
  1139. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'ngram'
  1140. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'partition'
  1141. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  1142. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'ARCHIVE'
  1143. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  1144. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  1145. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'MyISAM'
  1146. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  1147. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  1148. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  1149. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  1150. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  1151. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  1152. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  1153. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  1154. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  1155. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  1156. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  1157. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  1158. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  1159. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  1160. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  1161. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  1162. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  1163. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  1164. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  1165. 2017-05-31T08:18:00.270431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  1166. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  1167. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  1168. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  1169. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  1170. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  1171. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  1172. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  1173. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  1174. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  1175. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  1176. 2017-05-31T08:18:00.286031Z 0 [Note] Shutting down plugin 'InnoDB'
  1177. 2017-05-31T08:18:00.286031Z 0 [Note] InnoDB: FTS optimize thread exiting.
  1178. 2017-05-31T08:18:00.286031Z 0 [Note] InnoDB: Starting shutdown...
  1179. 2017-05-31T08:18:00.395231Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  1180. 2017-05-31T08:18:00.395231Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170531 15:18:00
  1181. 2017-05-31T08:18:01.112833Z 0 [Note] InnoDB: Shutdown completed; log sequence number 173967537
  1182. 2017-05-31T08:18:01.112833Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  1183. 2017-05-31T08:18:01.112833Z 0 [Note] Shutting down plugin 'MEMORY'
  1184. 2017-05-31T08:18:01.112833Z 0 [Note] Shutting down plugin 'CSV'
  1185. 2017-05-31T08:18:01.112833Z 0 [Note] Shutting down plugin 'sha256_password'
  1186. 2017-05-31T08:18:01.112833Z 0 [Note] Shutting down plugin 'mysql_native_password'
  1187. 2017-05-31T08:18:01.128433Z 0 [Note] Shutting down plugin 'binlog'
  1188. 2017-05-31T08:18:01.144033Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete
  1189.  
  1190. 2017-05-31T08:18:15.511658Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  1191. 2017-05-31T08:18:15.511658Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  1192. 2017-05-31T08:18:15.511658Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 4112 ...
  1193. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  1194. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Uses event mutexes
  1195. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  1196. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  1197. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
  1198. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Number of pools: 1
  1199. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  1200. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
  1201. 2017-05-31T08:18:15.527258Z 0 [Note] InnoDB: Completed initialization of buffer pool
  1202. 2017-05-31T08:18:15.558458Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  1203. 2017-05-31T08:18:16.057659Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  1204. 2017-05-31T08:18:16.057659Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  1205. 2017-05-31T08:18:16.182459Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  1206. 2017-05-31T08:18:16.182459Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  1207. 2017-05-31T08:18:16.182459Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  1208. 2017-05-31T08:18:16.198059Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 173967537
  1209. 2017-05-31T08:18:16.198059Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
  1210. 2017-05-31T08:18:16.198059Z 0 [Note] Plugin 'FEDERATED' is disabled.
  1211. 2017-05-31T08:18:16.198059Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170531 15:18:16
  1212. 2017-05-31T08:18:16.244859Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
  1213. 2017-05-31T08:18:16.244859Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  1214. 2017-05-31T08:18:16.260459Z 0 [Note] IPv6 is available.
  1215. 2017-05-31T08:18:16.260459Z 0 [Note] - '::' resolves to '::';
  1216. 2017-05-31T08:18:16.260459Z 0 [Note] Server socket created on IP: '::'.
  1217. 2017-05-31T08:18:16.338459Z 0 [Note] Event Scheduler: Loaded 0 events
  1218. 2017-05-31T08:18:16.338459Z 0 [Note] D:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
  1219. Version: '5.7.18-log' socket: '' port: 3306 MySQL Community Server (GPL)
  1220. 2017-05-31T08:18:16.338459Z 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.
  1221. 2017-05-31T08:18:16.338459Z 0 [Note] Beginning of list of non-natively partitioned tables
  1222. 2017-05-31T08:18:16.338459Z 2 [ERROR] Invalid (old?) table or database name 'New folder'
  1223. 2017-05-31T08:18:16.400859Z 0 [Note] End of list of non-natively partitioned tables
  1224. 08:18:25 UTC - mysqld got exception 0xc000001d ;
  1225. This could be because you hit a bug. It is also possible that this binary
  1226. or one of the libraries it was linked against is corrupt, improperly built,
  1227. or misconfigured. This error can also be caused by malfunctioning hardware.
  1228. Attempting to collect some information that could help diagnose the problem.
  1229. As this is a crash and something is definitely wrong, the information
  1230. collection process might fail.
  1231.  
  1232. key_buffer_size=8388608
  1233. read_buffer_size=65536
  1234. max_used_connections=13
  1235. max_threads=151
  1236. thread_count=13
  1237. connection_count=13
  1238. It is possible that mysqld could use up to
  1239. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58347 K bytes of memory
  1240. Hope that's ok; if not, decrease some variables in the equation.
  1241.  
  1242. Thread pointer: 0xa9c3660
  1243. Attempting backtrace. You can use the following information to find out
  1244. where mysqld died. If you see no messages after this, something went
  1245. terribly wrong...
  1246. 7fef28a5c01 MSVCR120.dll!pow()
  1247. 13fcf5f5a mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
  1248. 1402aebe7 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
  1249. 1402a4be9 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
  1250. 1402b0ed5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
  1251. 13fe634fe mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
  1252. 13fe61f5d mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
  1253. 13fe64cc9 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
  1254. 13fe6683b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
  1255. 13feae509 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
  1256. 13feac52d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
  1257. 13fd23cb7 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
  1258. 13fd25be6 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
  1259. 13fd29643 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
  1260. 13fd226f3 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
  1261. 13fd2372a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
  1262. 13fcf06ac mysqld.exe!handle_connection()
  1263. 14071dd42 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
  1264. 14043133c mysqld.exe!my_thread_once()
  1265. 7fef2834f7f MSVCR120.dll!_beginthreadex()
  1266. 7fef2835126 MSVCR120.dll!_endthreadex()
  1267. 776bf56d kernel32.dll!BaseThreadInitThunk()
  1268. 777f3281 ntdll.dll!RtlUserThreadStart()
  1269.  
  1270. Trying to get some variables.
  1271. Some pointers may be invalid and cause the dump to abort.
  1272. Query (de9bf40): select purchasefl0_.unitPrice as col_0_0_ from Flow purchasefl0_ where purchasefl0_.class='com.katalisindonesia.prosper.model.momentum.PurchaseFlow' and purchasefl0_.inventory='4028e48a5c5d4b7b015c5d53c3040005' order by purchasefl0_.date desc, purchasefl0_.id desc limit 1
  1273. Connection ID (thread ID): 8
  1274. Status: NOT_KILLED
  1275.  
  1276. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  1277. information that should help you find out what is causing the crash.
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!