API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 8th, 2020
386
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 34.73 KB | None | 0 0
raw download clone embed print report
  1. 2020-04-08T10:47:52.300607Z 139548005 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  2. TRANSACTION 421683251558152, ACTIVE 0 sec fetching rows
  3. mysql tables in use 26, locked 1
  4. 0 lock struct(s), heap size 1136, 0 row lock(s)
  5. MySQL thread id 139548005, OS thread handle 140038067308288, query id 22151888882 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  6. select
  7. case @_lang
  8.      when 'en' then (
  9.          select
  10.          json_arrayagg(
  11.              json_object(
  12.                    'header', sisu1.header_EN
  13.                  , 'page', sisu1.page
  14.                  , 'wordpress_id', sisu1.wordpress_id
  15.                  , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)
  16.                 )
  17.             )
  18.          from (
  19.              select
  20.                a1.page_id
  21.              , a1.wordpress_id
  22.              , a1.page
  23.              , a2.header_EN
  24.              f
  25.  
  26. 2020-04-08T10:47:52.302710Z 139548005 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 140038067308288
  27. InnoDB: We intentionally generate a memory trap.
  28. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  29. InnoDB: If you get repeated assertion failures or crashes, even
  30. InnoDB: immediately after the mysqld startup, there may be
  31. InnoDB: corruption in the InnoDB tablespace. Please refer to
  32. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  33. InnoDB: about forcing recovery.
  34. 10:47:52 UTC - mysqld got signal 6 ;
  35. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  36. Thread pointer: 0x7f5ba4de5930
  37. Attempting backtrace. You can use the following information to find out
  38. where mysqld died. If you see no messages after this, something went
  39. terribly wrong...
  40. stack_bottom = 7f5d2741bd50 thread_stack 0x46000
  41. /usr/sbin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x3d) [0x55d06f2cabad]
  42. /usr/sbin/mysqld(handle_fatal_signal+0x303) [0x55d06e57f7f3]
  43. /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890) [0x7f84dcea6890]
  44. /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7) [0x7f84db014e97]
  45. /lib/x86_64-linux-gnu/libc.so.6(abort+0x141) [0x7f84db016801]
  46. /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x2ec) [0x55d06f58cd5c]
  47. /usr/sbin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x2ec3) [0x55d06f507423]
  48. /usr/sbin/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0xd8) [0x55d06f3a3b48]
  49. /usr/sbin/mysqld(handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x19e) [0x55d06e19aa4e]
  50. /usr/sbin/mysqld(RefIterator<false>::Read()+0x15b) [0x55d06e3fb76b]
  51. /usr/sbin/mysqld(NestedLoopIterator::Read()+0x7b) [0x55d06e63dd3b]
  52. /usr/sbin/mysqld(AggregateIterator::Read()+0x153) [0x55d06e63fed3]
  53. /usr/sbin/mysqld(JOIN::exec()+0x722) [0x55d06e401012]
  54. /usr/sbin/mysqld(subselect_single_select_engine::exec(THD*)+0x9c) [0x55d06e27812c]
  55. /usr/sbin/mysqld(Item_subselect::exec(THD*)+0xca) [0x55d06e279a1a]
  56. /usr/sbin/mysqld(Item_singlerow_subselect::val_str(String*)+0x4e) [0x55d06e27854e]
  57. /usr/sbin/mysqld(Item_func_case::val_str(String*)+0x42) [0x55d06e1e04f2]
  58. /usr/sbin/mysqld(Item_func_set_user_var::save_item_result(Item*)+0xd0) [0x55d06e233990]
  59. /usr/sbin/mysqld(Query_dumpvar::send_data(THD*, List<Item>&)+0x20b) [0x55d06e6d955b]
  60. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55d06e4010c5]
  61. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55d06e492a7e]
  62. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55d06e49a008]
  63. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55d06e442dc5]
  64. /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x50) [0x55d06e3a4ab0]
  65. /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1aa) [0x55d06e3a6a1a]
  66. /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xba) [0x55d06e3a768a]
  67. /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xdf) [0x55d06e3a909f]
  68. /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5a1) [0x55d06e39e3d1]
  69. /usr/sbin/mysqld(sp_head::execute_function(THD*, Item**, unsigned int, Field*)+0x646) [0x55d06e3a0896]
  70. /usr/sbin/mysqld(Item_func_sp::execute_impl(THD*)+0x135) [0x55d06e235b55]
  71. /usr/sbin/mysqld(Item_func_sp::execute()+0x81) [0x55d06e235d11]
  72. /usr/sbin/mysqld(Item_func_sp::val_str(String*)+0x48) [0x55d06e235eb8]
  73. /usr/sbin/mysqld(Item::send(Protocol*, String*)+0x265) [0x55d06e1acfa5]
  74. /usr/sbin/mysqld(THD::send_result_set_row(List<Item>*)+0xcb) [0x55d06e3d930b]
  75. /usr/sbin/mysqld(Query_result_send::send_data(THD*, List<Item>&)+0x31) [0x55d06e6d9cf1]
  76. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55d06e4010c5]
  77. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55d06e492a7e]
  78. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55d06e49a008]
  79. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55d06e442dc5]
  80. /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x41b) [0x55d06e445afb]
  81. /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d93) [0x55d06e448dd3]
  82. /usr/sbin/mysqld(do_command(THD*)+0x1f9) [0x55d06e449969]
  83. /usr/sbin/mysqld(+0x1123a10) [0x55d06e570a10]
  84. /usr/sbin/mysqld(+0x2355ae9) [0x55d06f7a2ae9]
  85. /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f84dce9b6db]
  86. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f84db0f788f]
  87.  
  88. Trying to get some variables.
  89. Some pointers may be invalid and cause the dump to abort.
  90. Query (7f5ba4091858): select  case @_lang       when 'en' then (           select           json_arrayagg(               json_object(                     'header', sisu1.header_EN                   , 'page', sisu1.page                   , 'wordpress_id', sisu1.wordpress_id                   , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)                  )              )           from (               select                 a1.page_id               , a1.wordpress_id               , a1.page               , a2.header_EN               from tbl_company_stories a1               join tbl_company_story_header a2 on a2.id = a1.header_id               where a1.reg_code = @_code              ) sisu1          )       else (           select           json_arrayagg(               json_object(                     'header', sisu2.header_ET                   , 'page', sisu2.page                   , 'wordpress_id', sisu2.wordpress_id                   , 'story', ca
  91. Connection ID (thread ID): 139548005
  92. Status: NOT_KILLED
  93.  
  94. Please help us make Percona Server better by reporting any
  95. bugs at https://bugs.percona.com/
  96.  
  97. You may download the Percona Server operations manual by visiting
  98. http://www.percona.com/software/percona-server/. You may find information
  99. in the manual which will help you identify the cause of the crash.
  100. 2020-04-08T10:48:01.310517Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-8) starting as process 11758
  101. 2020-04-08T10:59:15.350776Z 0 [System] [MY-010229] [Server] Starting crash recovery...
  102. 2020-04-08T10:59:15.360243Z 0 [System] [MY-010232] [Server] Crash recovery finished.
  103. 2020-04-08T10:59:17.120715Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  104. 2020-04-08T10:59:17.203392Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '8', Revision '868a4ef'.
  105. 2020-04-08T10:59:27.189599Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-8)  Percona Server (GPL), Release '8', Revision '868a4ef'.
  106. 2020-04-08T10:59:41.204791Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-8) starting as process 12230
  107. 2020-04-08T10:59:50.604767Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  108. 2020-04-08T10:59:50.650342Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '8', Revision '868a4ef'.
  109. 2020-04-08T10:59:50.733656Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
  110. 2020-04-08T11:00:23.832302Z 418 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  111. TRANSACTION 421322304518528, ACTIVE 0 sec fetching rows
  112. mysql tables in use 26, locked 1
  113. 0 lock struct(s), heap size 1136, 0 row lock(s)
  114. MySQL thread id 418, OS thread handle 139676077483776, query id 149411 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  115. select
  116. case @_lang
  117.      when 'en' then (
  118.          select
  119.          json_arrayagg(
  120.              json_object(
  121.                    'header', sisu1.header_EN
  122.                  , 'page', sisu1.page
  123.                  , 'wordpress_id', sisu1.wordpress_id
  124.                  , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)
  125.                 )
  126.             )
  127.          from (
  128.              select
  129.                a1.page_id
  130.              , a1.wordpress_id
  131.              , a1.page
  132.              , a2.header_EN
  133.              f
  134.  
  135. 2020-04-08T11:00:23.832451Z 418 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 139676077483776
  136. InnoDB: We intentionally generate a memory trap.
  137. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  138. InnoDB: If you get repeated assertion failures or crashes, even
  139. InnoDB: immediately after the mysqld startup, there may be
  140. InnoDB: corruption in the InnoDB tablespace. Please refer to
  141. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  142. InnoDB: about forcing recovery.
  143. 11:00:23 UTC - mysqld got signal 6 ;
  144. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  145. Thread pointer: 0x7f08a4214c30
  146. Attempting backtrace. You can use the following information to find out
  147. where mysqld died. If you see no messages after this, something went
  148. terribly wrong...
  149. stack_bottom = 7f08defb5d50 thread_stack 0x46000
  150. /usr/sbin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x3d) [0x55e14b335bad]
  151. /usr/sbin/mysqld(handle_fatal_signal+0x303) [0x55e14a5ea7f3]
  152. /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890) [0x7f30d2cbc890]
  153. /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7) [0x7f30d0e2ae97]
  154. /lib/x86_64-linux-gnu/libc.so.6(abort+0x141) [0x7f30d0e2c801]
  155. /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x2ec) [0x55e14b5f7d5c]
  156. /usr/sbin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x2ec3) [0x55e14b572423]
  157. /usr/sbin/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0xd8) [0x55e14b40eb48]
  158. /usr/sbin/mysqld(handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x19e) [0x55e14a205a4e]
  159. /usr/sbin/mysqld(RefIterator<false>::Read()+0x15b) [0x55e14a46676b]
  160. /usr/sbin/mysqld(NestedLoopIterator::Read()+0x7b) [0x55e14a6a8d3b]
  161. /usr/sbin/mysqld(AggregateIterator::Read()+0x153) [0x55e14a6aaed3]
  162. /usr/sbin/mysqld(JOIN::exec()+0x722) [0x55e14a46c012]
  163. /usr/sbin/mysqld(subselect_single_select_engine::exec(THD*)+0x9c) [0x55e14a2e312c]
  164. /usr/sbin/mysqld(Item_subselect::exec(THD*)+0xca) [0x55e14a2e4a1a]
  165. /usr/sbin/mysqld(Item_singlerow_subselect::val_str(String*)+0x4e) [0x55e14a2e354e]
  166. /usr/sbin/mysqld(Item_func_case::val_str(String*)+0x42) [0x55e14a24b4f2]
  167. /usr/sbin/mysqld(Item_func_set_user_var::save_item_result(Item*)+0xd0) [0x55e14a29e990]
  168. /usr/sbin/mysqld(Query_dumpvar::send_data(THD*, List<Item>&)+0x20b) [0x55e14a74455b]
  169. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55e14a46c0c5]
  170. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55e14a4fda7e]
  171. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55e14a505008]
  172. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55e14a4addc5]
  173. /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x50) [0x55e14a40fab0]
  174. /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1aa) [0x55e14a411a1a]
  175. /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xba) [0x55e14a41268a]
  176. /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xdf) [0x55e14a41409f]
  177. /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5a1) [0x55e14a4093d1]
  178. /usr/sbin/mysqld(sp_head::execute_function(THD*, Item**, unsigned int, Field*)+0x646) [0x55e14a40b896]
  179. /usr/sbin/mysqld(Item_func_sp::execute_impl(THD*)+0x135) [0x55e14a2a0b55]
  180. /usr/sbin/mysqld(Item_func_sp::execute()+0x81) [0x55e14a2a0d11]
  181. /usr/sbin/mysqld(Item_func_sp::val_str(String*)+0x48) [0x55e14a2a0eb8]
  182. /usr/sbin/mysqld(Item::send(Protocol*, String*)+0x265) [0x55e14a217fa5]
  183. /usr/sbin/mysqld(THD::send_result_set_row(List<Item>*)+0xcb) [0x55e14a44430b]
  184. /usr/sbin/mysqld(Query_result_send::send_data(THD*, List<Item>&)+0x31) [0x55e14a744cf1]
  185. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55e14a46c0c5]
  186. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55e14a4fda7e]
  187. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55e14a505008]
  188. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55e14a4addc5]
  189. /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x41b) [0x55e14a4b0afb]
  190. /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d93) [0x55e14a4b3dd3]
  191. /usr/sbin/mysqld(do_command(THD*)+0x1f9) [0x55e14a4b4969]
  192. /usr/sbin/mysqld(+0x1123a10) [0x55e14a5dba10]
  193. /usr/sbin/mysqld(+0x2355ae9) [0x55e14b80dae9]
  194. /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f30d2cb16db]
  195. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f30d0f0d88f]
  196.  
  197. Trying to get some variables.
  198. Some pointers may be invalid and cause the dump to abort.
  199. Query (7f08a41e7f78): select  case @_lang       when 'en' then (           select           json_arrayagg(               json_object(                     'header', sisu1.header_EN                   , 'page', sisu1.page                   , 'wordpress_id', sisu1.wordpress_id                   , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)                  )              )           from (               select                 a1.page_id               , a1.wordpress_id               , a1.page               , a2.header_EN               from tbl_company_stories a1               join tbl_company_story_header a2 on a2.id = a1.header_id               where a1.reg_code = @_code              ) sisu1          )       else (           select           json_arrayagg(               json_object(                     'header', sisu2.header_ET                   , 'page', sisu2.page                   , 'wordpress_id', sisu2.wordpress_id                   , 'story', ca
  200. Connection ID (thread ID): 418
  201. Status: NOT_KILLED
  202.  
  203. Please help us make Percona Server better by reporting any
  204. bugs at https://bugs.percona.com/
  205.  
  206. You may download the Percona Server operations manual by visiting
  207. http://www.percona.com/software/percona-server/. You may find information
  208. in the manual which will help you identify the cause of the crash.
  209. 2020-04-08T11:00:25.473152Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-8) starting as process 12382
  210. 2020-04-08T11:00:45.228164Z 0 [System] [MY-010229] [Server] Starting crash recovery...
  211. 2020-04-08T11:00:45.240102Z 0 [System] [MY-010232] [Server] Crash recovery finished.
  212. 2020-04-08T11:00:45.303820Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  213. 2020-04-08T11:00:45.363067Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '8', Revision '868a4ef'.
  214. 2020-04-08T11:00:45.409108Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
  215. 2020-04-08T11:01:02.914735Z 287 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  216. TRANSACTION 421152445650248, ACTIVE 0 sec fetching rows
  217. mysql tables in use 21, locked 1
  218. 0 lock struct(s), heap size 1136, 0 row lock(s)
  219. MySQL thread id 287, OS thread handle 139676632360704, query id 92724 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  220. select
  221. case @_lang
  222.      when 'en' then (
  223.          select json_arrayagg(
  224.          json_object(
  225.                'id', aa1.id
  226.              , 'author_userid', aa1.author_userid
  227.              , 'reg_code', aa1.reg_code
  228.              , 'idPublic', aa1.idPublic
  229.              , 'slug', aa1.slug
  230.              , 'category', aa1.category
  231.              , 'emtak', cast((f_get_emtak_codes(aa1.reg_code)) as json)
  232.              , 'header', aa1.header
  233.              , 'htmltext', if(@_htmltext_length = -1, aa1.htmltext, if(@_htmltext_length > 0, f_smart_cut(f_strip_tags(left(aa1.htmltext, @_htmltext_length
  234.  
  235. 2020-04-08T11:01:02.914882Z 287 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 139676632360704
  236. InnoDB: We intentionally generate a memory trap.
  237. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  238. InnoDB: If you get repeated assertion failures or crashes, even
  239. InnoDB: immediately after the mysqld startup, there may be
  240. InnoDB: corruption in the InnoDB tablespace. Please refer to
  241. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  242. InnoDB: about forcing recovery.
  243. 11:01:02 UTC - mysqld got signal 6 ;
  244. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  245. Thread pointer: 0x7ee0e83e1bb0
  246. Attempting backtrace. You can use the following information to find out
  247. where mysqld died. If you see no messages after this, something went
  248. terribly wrong...
  249. stack_bottom = 7f09000e1d50 thread_stack 0x46000
  250. /usr/sbin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x3d) [0x55675f964bad]
  251. /usr/sbin/mysqld(handle_fatal_signal+0x303) [0x55675ec197f3]
  252. /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890) [0x7f09466b2890]
  253. /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7) [0x7f0944820e97]
  254. /lib/x86_64-linux-gnu/libc.so.6(abort+0x141) [0x7f0944822801]
  255. /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x2ec) [0x55675fc26d5c]
  256. /usr/sbin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x2ec3) [0x55675fba1423]
  257. /usr/sbin/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0xd8) [0x55675fa3db48]
  258. /usr/sbin/mysqld(handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x10c) [0x55675e8349bc]
  259. /usr/sbin/mysqld(RefIterator<false>::Read()+0x15b) [0x55675ea9576b]
  260. /usr/sbin/mysqld(FilterIterator::Read()+0x14) [0x55675ecd7564]
  261. /usr/sbin/mysqld(AggregateIterator::Read()+0x153) [0x55675ecd9ed3]
  262. /usr/sbin/mysqld(JOIN::exec()+0x722) [0x55675ea9b012]
  263. /usr/sbin/mysqld(subselect_single_select_engine::exec(THD*)+0x9c) [0x55675e91212c]
  264. /usr/sbin/mysqld(Item_subselect::exec(THD*)+0xca) [0x55675e913a1a]
  265. /usr/sbin/mysqld(Item_singlerow_subselect::val_str(String*)+0x4e) [0x55675e91254e]
  266. /usr/sbin/mysqld(Item_func_case::val_str(String*)+0x42) [0x55675e87a4f2]
  267. /usr/sbin/mysqld(Item_func_set_user_var::save_item_result(Item*)+0xd0) [0x55675e8cd990]
  268. /usr/sbin/mysqld(Query_dumpvar::send_data(THD*, List<Item>&)+0x20b) [0x55675ed7355b]
  269. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55675ea9b0c5]
  270. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55675eb2ca7e]
  271. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55675eb34008]
  272. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55675eadcdc5]
  273. /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x50) [0x55675ea3eab0]
  274. /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1aa) [0x55675ea40a1a]
  275. /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xba) [0x55675ea4168a]
  276. /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xdf) [0x55675ea4309f]
  277. /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5a1) [0x55675ea383d1]
  278. /usr/sbin/mysqld(sp_head::execute_function(THD*, Item**, unsigned int, Field*)+0x646) [0x55675ea3a896]
  279. /usr/sbin/mysqld(Item_func_sp::execute_impl(THD*)+0x135) [0x55675e8cfb55]
  280. /usr/sbin/mysqld(Item_func_sp::execute()+0x81) [0x55675e8cfd11]
  281. /usr/sbin/mysqld(Item_func_sp::val_str(String*)+0x48) [0x55675e8cfeb8]
  282. /usr/sbin/mysqld(Item::send(Protocol*, String*)+0x265) [0x55675e846fa5]
  283. /usr/sbin/mysqld(THD::send_result_set_row(List<Item>*)+0xcb) [0x55675ea7330b]
  284. /usr/sbin/mysqld(Query_result_send::send_data(THD*, List<Item>&)+0x31) [0x55675ed73cf1]
  285. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x55675ea9b0c5]
  286. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x55675eb2ca7e]
  287. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x55675eb34008]
  288. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x55675eadcdc5]
  289. /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x41b) [0x55675eadfafb]
  290. /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d93) [0x55675eae2dd3]
  291. /usr/sbin/mysqld(do_command(THD*)+0x1f9) [0x55675eae3969]
  292. /usr/sbin/mysqld(+0x1123a10) [0x55675ec0aa10]
  293. /usr/sbin/mysqld(+0x2355ae9) [0x55675fe3cae9]
  294. /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f09466a76db]
  295. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f094490388f]
  296.  
  297. Trying to get some variables.
  298. Some pointers may be invalid and cause the dump to abort.
  299. Query (7ee0e8236ee8): select  case @_lang       when 'en' then (           select json_arrayagg(           json_object(                 'id', aa1.id               , 'author_userid', aa1.author_userid               , 'reg_code', aa1.reg_code               , 'idPublic', aa1.idPublic               , 'slug', aa1.slug               , 'category', aa1.category               , 'emtak', cast((f_get_emtak_codes(aa1.reg_code)) as json)               , 'header', aa1.header               , 'htmltext', if(@_htmltext_length = -1, aa1.htmltext, if(@_htmltext_length > 0, f_smart_cut(f_strip_tags(left(aa1.htmltext, @_htmltext_length * 10)), @_htmltext_length), null))               , 'riskscore', cast((select f_get_riskscore(aa1.reg_code)) as json)               , 'tags', cast((select f_get_story_tags(aa1.id, @_lang)) as json)               , 'last_updated', date_format(aa1.last_updated, @_date_format)               , 'company_name', (select f_get_company_name(aa1.reg_code))               , 'img_thumbnail', cast((select f_emtak_to_img_thumbnail2(aa1
  300. Connection ID (thread ID): 287
  301. Status: NOT_KILLED
  302.  
  303. Please help us make Percona Server better by reporting any
  304. bugs at https://bugs.percona.com/
  305.  
  306. You may download the Percona Server operations manual by visiting
  307. http://www.percona.com/software/percona-server/. You may find information
  308. in the manual which will help you identify the cause of the crash.
  309. 2020-04-08T11:01:04.472333Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-8) starting as process 12639
  310. 2020-04-08T11:01:18.952016Z 0 [System] [MY-010229] [Server] Starting crash recovery...
  311. 2020-04-08T11:01:18.962510Z 0 [System] [MY-010232] [Server] Crash recovery finished.
  312. 2020-04-08T11:01:19.044312Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  313. 2020-04-08T11:01:19.085591Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '8', Revision '868a4ef'.
  314. 2020-04-08T11:01:19.170170Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
  315. 2020-04-08T11:01:39.479828Z 375 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  316. TRANSACTION 421416258493880, ACTIVE 0 sec fetching rows
  317. mysql tables in use 26, locked 1
  318. 0 lock struct(s), heap size 1136, 0 row lock(s)
  319. MySQL thread id 375, OS thread handle 139941243082496, query id 120256 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  320. select
  321. case @_lang
  322.      when 'en' then (
  323.          select
  324.          json_arrayagg(
  325.              json_object(
  326.                    'header', sisu1.header_EN
  327.                  , 'page', sisu1.page
  328.                  , 'wordpress_id', sisu1.wordpress_id
  329.                  , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)
  330.                 )
  331.             )
  332.          from (
  333.              select
  334.                a1.page_id
  335.              , a1.wordpress_id
  336.              , a1.page
  337.              , a2.header_EN
  338.              f
  339.  
  340. 2020-04-08T11:01:39.480105Z 375 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 139941243082496
  341. InnoDB: We intentionally generate a memory trap.
  342. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  343. InnoDB: If you get repeated assertion failures or crashes, even
  344. InnoDB: immediately after the mysqld startup, there may be
  345. InnoDB: corruption in the InnoDB tablespace. Please refer to
  346. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  347. InnoDB: about forcing recovery.
  348. 11:01:39 UTC - mysqld got signal 6 ;
  349. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  350. Thread pointer: 0x7f1e78ebc140
  351. Attempting backtrace. You can use the following information to find out
  352. where mysqld died. If you see no messages after this, something went
  353. terribly wrong...
  354. stack_bottom = 7f469c154d50 thread_stack 0x46000
  355. /usr/sbin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x3d) [0x56310f2cabad]
  356. /usr/sbin/mysqld(handle_fatal_signal+0x303) [0x56310e57f7f3]
  357. /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890) [0x7f46b2e3a890]
  358. /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7) [0x7f46b0fa8e97]
  359. /lib/x86_64-linux-gnu/libc.so.6(abort+0x141) [0x7f46b0faa801]
  360. /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x2ec) [0x56310f58cd5c]
  361. /usr/sbin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x2ec3) [0x56310f507423]
  362. /usr/sbin/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0xd8) [0x56310f3a3b48]
  363. /usr/sbin/mysqld(handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x19e) [0x56310e19aa4e]
  364. /usr/sbin/mysqld(RefIterator<false>::Read()+0x15b) [0x56310e3fb76b]
  365. /usr/sbin/mysqld(NestedLoopIterator::Read()+0x7b) [0x56310e63dd3b]
  366. /usr/sbin/mysqld(AggregateIterator::Read()+0x153) [0x56310e63fed3]
  367. /usr/sbin/mysqld(JOIN::exec()+0x722) [0x56310e401012]
  368. /usr/sbin/mysqld(subselect_single_select_engine::exec(THD*)+0x9c) [0x56310e27812c]
  369. /usr/sbin/mysqld(Item_subselect::exec(THD*)+0xca) [0x56310e279a1a]
  370. /usr/sbin/mysqld(Item_singlerow_subselect::val_str(String*)+0x4e) [0x56310e27854e]
  371. /usr/sbin/mysqld(Item_func_case::val_str(String*)+0x42) [0x56310e1e04f2]
  372. /usr/sbin/mysqld(Item_func_set_user_var::save_item_result(Item*)+0xd0) [0x56310e233990]
  373. /usr/sbin/mysqld(Query_dumpvar::send_data(THD*, List<Item>&)+0x20b) [0x56310e6d955b]
  374. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x56310e4010c5]
  375. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x56310e492a7e]
  376. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x56310e49a008]
  377. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x56310e442dc5]
  378. /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x50) [0x56310e3a4ab0]
  379. /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1aa) [0x56310e3a6a1a]
  380. /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xba) [0x56310e3a768a]
  381. /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xdf) [0x56310e3a909f]
  382. /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5a1) [0x56310e39e3d1]
  383. /usr/sbin/mysqld(sp_head::execute_function(THD*, Item**, unsigned int, Field*)+0x646) [0x56310e3a0896]
  384. /usr/sbin/mysqld(Item_func_sp::execute_impl(THD*)+0x135) [0x56310e235b55]
  385. /usr/sbin/mysqld(Item_func_sp::execute()+0x81) [0x56310e235d11]
  386. /usr/sbin/mysqld(Item_func_sp::val_str(String*)+0x48) [0x56310e235eb8]
  387. /usr/sbin/mysqld(Item::send(Protocol*, String*)+0x265) [0x56310e1acfa5]
  388. /usr/sbin/mysqld(THD::send_result_set_row(List<Item>*)+0xcb) [0x56310e3d930b]
  389. /usr/sbin/mysqld(Query_result_send::send_data(THD*, List<Item>&)+0x31) [0x56310e6d9cf1]
  390. /usr/sbin/mysqld(JOIN::exec()+0x7d5) [0x56310e4010c5]
  391. /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0x56310e492a7e]
  392. /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x458) [0x56310e49a008]
  393. /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x21f5) [0x56310e442dc5]
  394. /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x41b) [0x56310e445afb]
  395. /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d93) [0x56310e448dd3]
  396. /usr/sbin/mysqld(do_command(THD*)+0x1f9) [0x56310e449969]
  397. /usr/sbin/mysqld(+0x1123a10) [0x56310e570a10]
  398. /usr/sbin/mysqld(+0x2355ae9) [0x56310f7a2ae9]
  399. /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f46b2e2f6db]
  400. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f46b108b88f]
  401.  
  402. Trying to get some variables.
  403. Some pointers may be invalid and cause the dump to abort.
  404. Query (7f1e793ae268): select  case @_lang       when 'en' then (           select           json_arrayagg(               json_object(                     'header', sisu1.header_EN                   , 'page', sisu1.page                   , 'wordpress_id', sisu1.wordpress_id                   , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)                  )              )           from (               select                 a1.page_id               , a1.wordpress_id               , a1.page               , a2.header_EN               from tbl_company_stories a1               join tbl_company_story_header a2 on a2.id = a1.header_id               where a1.reg_code = @_code              ) sisu1          )       else (           select           json_arrayagg(               json_object(                     'header', sisu2.header_ET                   , 'page', sisu2.page                   , 'wordpress_id', sisu2.wordpress_id                   , 'story', ca
  405. Connection ID (thread ID): 375
  406. Status: NOT_KILLED
  407.  
  408. Please help us make Percona Server better by reporting any
  409. bugs at https://bugs.percona.com/
  410.  
  411. You may download the Percona Server operations manual by visiting
  412. http://www.percona.com/software/percona-server/. You may find information
  413. in the manual which will help you identify the cause of the crash.
  414. 2020-04-08T11:01:40.966838Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-8) starting as process 12791
  415. 2020-04-08T11:01:54.600421Z 0 [System] [MY-010229] [Server] Starting crash recovery...
  416. 2020-04-08T11:01:54.612528Z 0 [System] [MY-010232] [Server] Crash recovery finished.
  417. 2020-04-08T11:01:54.695259Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  418. 2020-04-08T11:01:54.728395Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '8', Revision '868a4ef'.
  419. 2020-04-08T11:01:54.813159Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
  420. 2020-04-08T11:01:58.223433Z 19 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  421. TRANSACTION 421209827133600, ACTIVE 0 sec fetching rows
  422. mysql tables in use 26, locked 1
  423. 0 lock struct(s), heap size 1136, 0 row lock(s)
  424. MySQL thread id 19, OS thread handle 139734817949440, query id 165 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  425. select
  426. case @_lang
  427.      when 'en' then (
  428.          select
  429.          json_arrayagg(
  430.              json_object(
  431.                    'header', sisu1.header_EN
  432.                  , 'page', sisu1.page
  433.                  , 'wordpress_id', sisu1.wordpress_id
  434.                  , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)
  435.                 )
  436.             )
  437.          from (
  438.              select
  439.                a1.page_id
  440.              , a1.wordpress_id
  441.              , a1.page
  442.              , a2.header_EN
  443.              f
  444.  
  445. 2020-04-08T11:01:58.223535Z 19 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 139734817949440
  446. InnoDB: We intentionally generate a memory trap.
  447. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  448. InnoDB: If you get repeated assertion failures or crashes, even
  449. InnoDB: immediately after the mysqld startup, there may be
  450. InnoDB: corruption in the InnoDB tablespace. Please refer to
  451. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  452. InnoDB: about forcing recovery.
  453. 11:01:58 UTC - mysqld got signal 6 ;
  454. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  455. Thread pointer: 0x7eee68000ed0
  456. Attempting backtrace. You can use the following information to find out
  457. where mysqld died. If you see no messages after this, something went
  458. terribly wrong...
  459. stack_bottom = 7f168c2fbd50 thread_stack 0x46000
  460. 2020-04-08T11:01:58.244386Z 33 [ERROR] [MY-012856] [InnoDB] MySQL is trying to perform a consistent read but the read view is not assigned!
  461. TRANSACTION 421209827142240, ACTIVE 0 sec fetching rows
  462. mysql tables in use 26, locked 1
  463. 0 lock struct(s), heap size 1136, 0 row lock(s)
  464. MySQL thread id 33, OS thread handle 139734817359616, query id 3228 static.139.127.216.95.clients.your-server.de 95.216.127.139 ssb-webapi closing tables
  465. select
  466. case @_lang
  467.      when 'en' then (
  468.          select
  469.          json_arrayagg(
  470.              json_object(
  471.                    'header', sisu1.header_EN
  472.                  , 'page', sisu1.page
  473.                  , 'wordpress_id', sisu1.wordpress_id
  474.                  , 'story', cast((f_get_story_for_tease_post_v2(sisu1.page_id, @_htmltext_length, @_lang, @_inc_nutulugu, @_inc_img, 'B')) as json)
  475.                 )
  476.             )
  477.          from (
  478.              select
  479.                a1.page_id
  480.              , a1.wordpress_id
  481.              , a1.page
  482.              , a2.header_EN
  483.              f
  484.  
  485. 2020-04-08T11:01:58.244537Z 33 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0sel.cc:4719 thread 139734817359616
  486. InnoDB: We intentionally generate a memory trap.
  487. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  488. InnoDB: If you get repeated assertion failures or crashes, even
  489. InnoDB: immediately after the mysqld startup, there may be
  490. InnoDB: corruption in the InnoDB tablespace. Please refer to
  491. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  492. InnoDB: about forcing recovery.
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!