API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 4th, 2022
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.50 KB | None | 0 0
raw download clone embed print report
  1. [root@KirillPC mysql]# sudo mysql_upgrade
  2. Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
  3. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  4. FATAL ERROR: Upgrade failed
  5. [root@KirillPC mysql]# sudo mysql_upgrade -p
  6. Enter password:
  7. Major version upgrade detected from 10.3.34-MariaDB to 10.7.3-MariaDB. Check required!
  8. Phase 1/7: Checking and upgrading mysql database
  9. Processing databases
  10. mysql
  11. mysql.column_stats OK
  12. mysql.columns_priv OK
  13. mysql.db OK
  14. mysql.event OK
  15. mysql.func OK
  16. mysql.gtid_slave_pos
  17. Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
  18. status : Operation failed
  19. mysql.help_category OK
  20. mysql.help_keyword OK
  21. mysql.help_relation OK
  22. mysql.help_topic OK
  23. mysql.host OK
  24. mysql.index_stats OK
  25. mysql.innodb_index_stats
  26. Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
  27. status : Operation failed
  28. mysql.innodb_table_stats
  29. Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
  30. status : Operation failed
  31. mysql.plugin OK
  32. mysql.proc OK
  33. mysql.procs_priv OK
  34. mysql.proxies_priv OK
  35. mysql.roles_mapping OK
  36. mysql.servers OK
  37. mysql.table_stats OK
  38. mysql.tables_priv OK
  39. mysql.time_zone OK
  40. mysql.time_zone_leap_second OK
  41. mysql.time_zone_name OK
  42. mysql.time_zone_transition OK
  43. mysql.time_zone_transition_type OK
  44. mysql.transaction_registry
  45. Error : Table 'mysql.transaction_registry' doesn't exist in engine
  46. status : Operation failed
  47. mysql.user OK
  48.  
  49. Repairing tables
  50. mysql.gtid_slave_pos
  51. Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
  52. status : Operation failed
  53. mysql.innodb_index_stats
  54. Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
  55. status : Operation failed
  56. mysql.innodb_table_stats
  57. Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
  58. status : Operation failed
  59. mysql.transaction_registry
  60. Error : Table 'mysql.transaction_registry' doesn't exist in engine
  61. status : Operation failed
  62. Phase 2/7: Installing used storage engines... Skipped
  63. Phase 3/7: Fixing views
  64. Phase 4/7: Running 'mysql_fix_privilege_tables'
  65. ERROR 1932 (42S02) at line 475: Table 'mysql.innodb_index_stats' doesn't exist in engine
  66. FATAL ERROR: Upgrade failed
  67. [root@KirillPC mysql]# sudo mysql_upgrade -p
  68. Enter password:
  69. Major version upgrade detected from 10.3.34-MariaDB to 10.7.3-MariaDB. Check required!
  70. Phase 1/7: Checking and upgrading mysql database
  71. Processing databases
  72. mysql
  73. mysql.column_stats OK
  74. mysql.columns_priv OK
  75. mysql.db OK
  76. mysql.event OK
  77. mysql.func OK
  78. mysql.global_priv OK
  79. mysql.gtid_slave_pos
  80. Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
  81. status : Operation failed
  82. mysql.help_category OK
  83. mysql.help_keyword OK
  84. mysql.help_relation OK
  85. mysql.help_topic OK
  86. mysql.index_stats OK
  87. mysql.innodb_index_stats
  88. Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
  89. status : Operation failed
  90. mysql.innodb_table_stats
  91. Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
  92. status : Operation failed
  93. mysql.plugin OK
  94. mysql.proc OK
  95. mysql.procs_priv OK
  96. mysql.proxies_priv OK
  97. mysql.roles_mapping OK
  98. mysql.servers OK
  99. mysql.table_stats OK
  100. mysql.tables_priv OK
  101. mysql.time_zone OK
  102. mysql.time_zone_leap_second OK
  103. mysql.time_zone_name OK
  104. mysql.time_zone_transition OK
  105. mysql.time_zone_transition_type OK
  106. mysql.transaction_registry
  107. Error : Table 'mysql.transaction_registry' doesn't exist in engine
  108. status : Operation failed
  109.  
  110. Repairing tables
  111. mysql.gtid_slave_pos
  112. Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
  113. status : Operation failed
  114. mysql.innodb_index_stats
  115. Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
  116. status : Operation failed
  117. mysql.innodb_table_stats
  118. Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
  119. status : Operation failed
  120. mysql.transaction_registry
  121. Error : Table 'mysql.transaction_registry' doesn't exist in engine
  122. status : Operation failed
  123. Phase 2/7: Installing used storage engines... Skipped
  124. Phase 3/7: Fixing views
  125. mysql.user
  126. Error : The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  127. error : Corrupt
  128. sys.host_summary OK
  129. sys.host_summary_by_file_io OK
  130. sys.host_summary_by_file_io_type OK
  131. sys.host_summary_by_stages OK
  132. sys.host_summary_by_statement_latency OK
  133. sys.host_summary_by_statement_type OK
  134. sys.innodb_buffer_stats_by_schema OK
  135. sys.innodb_buffer_stats_by_table OK
  136. sys.innodb_lock_waits OK
  137. sys.io_by_thread_by_latency OK
  138. sys.io_global_by_file_by_bytes OK
  139. sys.io_global_by_file_by_latency OK
  140. sys.io_global_by_wait_by_bytes OK
  141. sys.io_global_by_wait_by_latency OK
  142. sys.latest_file_io OK
  143. sys.memory_by_host_by_current_bytes OK
  144. sys.memory_by_thread_by_current_bytes OK
  145. sys.memory_by_user_by_current_bytes OK
  146. sys.memory_global_by_current_bytes OK
  147. sys.memory_global_total OK
  148. sys.metrics OK
  149. sys.processlist OK
  150. sys.ps_check_lost_instrumentation OK
  151. sys.schema_auto_increment_columns OK
  152. sys.schema_index_statistics OK
  153. sys.schema_object_overview OK
  154. sys.schema_redundant_indexes OK
  155. sys.schema_table_lock_waits OK
  156. sys.schema_table_statistics OK
  157. sys.schema_table_statistics_with_buffer OK
  158. sys.schema_tables_with_full_table_scans OK
  159. sys.schema_unused_indexes OK
  160. sys.session OK
  161. sys.session_ssl_status OK
  162. sys.statement_analysis OK
  163. sys.statements_with_errors_or_warnings OK
  164. sys.statements_with_full_table_scans OK
  165. sys.statements_with_runtimes_in_95th_percentile OK
  166. sys.statements_with_sorting OK
  167. sys.statements_with_temp_tables OK
  168. sys.user_summary OK
  169. sys.user_summary_by_file_io OK
  170. sys.user_summary_by_file_io_type OK
  171. sys.user_summary_by_stages OK
  172. sys.user_summary_by_statement_latency OK
  173. sys.user_summary_by_statement_type OK
  174. sys.version OK
  175. sys.wait_classes_global_by_avg_latency OK
  176. sys.wait_classes_global_by_latency OK
  177. sys.waits_by_host_by_latency OK
  178. sys.waits_by_user_by_latency OK
  179. sys.waits_global_by_latency OK
  180. sys.x$host_summary OK
  181. sys.x$host_summary_by_file_io OK
  182. sys.x$host_summary_by_file_io_type OK
  183. sys.x$host_summary_by_stages OK
  184. sys.x$host_summary_by_statement_latency OK
  185. sys.x$host_summary_by_statement_type OK
  186. sys.x$innodb_buffer_stats_by_schema OK
  187. sys.x$innodb_buffer_stats_by_table OK
  188. sys.x$innodb_lock_waits OK
  189. sys.x$io_by_thread_by_latency OK
  190. sys.x$io_global_by_file_by_bytes OK
  191. sys.x$io_global_by_file_by_latency OK
  192. sys.x$io_global_by_wait_by_bytes OK
  193. sys.x$io_global_by_wait_by_latency OK
  194. sys.x$latest_file_io OK
  195. sys.x$memory_by_host_by_current_bytes OK
  196. sys.x$memory_by_thread_by_current_bytes OK
  197. sys.x$memory_by_user_by_current_bytes OK
  198. sys.x$memory_global_by_current_bytes OK
  199. sys.x$memory_global_total OK
  200. sys.x$processlist OK
  201. sys.x$ps_digest_95th_percentile_by_avg_us OK
  202. sys.x$ps_digest_avg_latency_distribution OK
  203. sys.x$ps_schema_table_statistics_io OK
  204. sys.x$schema_flattened_keys OK
  205. sys.x$schema_index_statistics OK
  206. sys.x$schema_table_lock_waits OK
  207. sys.x$schema_table_statistics OK
  208. sys.x$schema_table_statistics_with_buffer OK
  209. sys.x$schema_tables_with_full_table_scans OK
  210. sys.x$session OK
  211. sys.x$statement_analysis OK
  212. sys.x$statements_with_errors_or_warnings OK
  213. sys.x$statements_with_full_table_scans OK
  214. sys.x$statements_with_runtimes_in_95th_percentile OK
  215. sys.x$statements_with_sorting OK
  216. sys.x$statements_with_temp_tables OK
  217. sys.x$user_summary OK
  218. sys.x$user_summary_by_file_io OK
  219. sys.x$user_summary_by_file_io_type OK
  220. sys.x$user_summary_by_stages OK
  221. sys.x$user_summary_by_statement_latency OK
  222. sys.x$user_summary_by_statement_type OK
  223. sys.x$wait_classes_global_by_avg_latency OK
  224. sys.x$wait_classes_global_by_latency OK
  225. sys.x$waits_by_host_by_latency OK
  226. sys.x$waits_by_user_by_latency OK
  227. sys.x$waits_global_by_latency OK
  228. Phase 4/7: Running 'mysql_fix_privilege_tables'
  229. ERROR 1449 (HY000) at line 32: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  230. ERROR 1449 (HY000) at line 41: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  231. ERROR 1449 (HY000) at line 84: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  232. ERROR 1449 (HY000) at line 93: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  233. ERROR 1449 (HY000) at line 111: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  234. ERROR 1449 (HY000) at line 197: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  235. ERROR 1449 (HY000) at line 206: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  236. ERROR 1449 (HY000) at line 208: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  237. ERROR 1449 (HY000) at line 219: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  238. ERROR 1449 (HY000) at line 224: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  239. ERROR 1449 (HY000) at line 227: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  240. ERROR 1449 (HY000) at line 353: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  241. ERROR 1449 (HY000) at line 356: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  242. ERROR 1449 (HY000) at line 425: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  243. ERROR 1449 (HY000) at line 430: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  244. ERROR 1449 (HY000) at line 432: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  245. ERROR 1449 (HY000) at line 435: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  246. ERROR 1449 (HY000) at line 439: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  247. ERROR 1449 (HY000) at line 444: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  248. ERROR 1449 (HY000) at line 465: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  249. ERROR 1449 (HY000) at line 473: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
  250. ERROR 1932 (42S02) at line 475: Table 'mysql.innodb_index_stats' doesn't exist in engine
  251. FATAL ERROR: Upgrade failed
  252.  
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!