MySQL Forums
Forum List  »  NDB clusters

MYSQL NDB runs for a period of time, restarts, data nodes, can not start up properly, do not know what methods can be less loss of data to start up properly
Posted by: xuxu xu
Date: January 08, 2021 01:15AM

021-01-05 16:57:19 [ndbd] INFO -- DROP_TAB_REQ: tab: 2243, tabLcpStatus: 3
2021-01-05 16:57:19 [ndbd] INFO -- DROP_TAB_REQ: tab: 1690, tabLcpStatus: 3
2021-01-05 16:57:21 [ndbd] INFO -- DROP_TAB_REQ: tab: 1691, tabLcpStatus: 3
2021-01-05 16:57:21 [ndbd] INFO -- DROP_TAB_REQ: tab: 2243, tabLcpStatus set to 3
2021-01-05 16:57:21 [ndbd] INFO -- DROP_TAB_REQ: tab: 1964, tabLcpStatus: 3
2021-01-05 16:57:21 [ndbd] INFO -- DROP_TAB_REQ: tab: 1690, tabLcpStatus set to 3
2021-01-05 16:57:23 [ndbd] INFO -- DROP_TAB_REQ: tab: 1691, tabLcpStatus: 3
2021-01-05 16:57:23 [ndbd] INFO -- DROP_TAB_REQ: tab: 2243, tabLcpStatus: 3
2021-01-05 16:57:23 [ndbd] INFO -- DROP_TAB_REQ: tab: 1964, tabLcpStatus: 3
2021-01-05 16:57:23 [ndbd] INFO -- DROP_TAB_REQ: tab: 1690, tabLcpStatus: 3
dirty pages
0 : [ Page: ptr.i: 572946 [ m_m_page_lsn_hi: 0 m_m_page_lsn_lo: 22578959 m_page_type: 2 m_file_no: 0 m_page_no: 2167802 m_table_id: 780 m_fragment_id: 1 m_extent_no: 3223 m_extent_info_ptr: 2148662496 m_restart_seq: 2] list_index: 0 free_space: 5 uncommitted_used_space: 0 ] [ Page: ptr.i: 572955 [ m_m_page_lsn_hi: 0 m_m_page_lsn_lo: 22578092 m_page_type: 2 m_file_no: 0 m_page_no: 2167801 m_table_id: 780 m_fragment_id: 1 m_extent_no: 3223 m_extent_info_ptr: 2148662496 m_restart_seq: 2] list_index: 0 free_space: 5 uncommitted_used_space: 0 1 : ]
[ Page: ptr.i: 572945 [ m_m_page_lsn_hi: 0 m_m_page_lsn_lo: 22579543 m_page_type: 2 m_file_no: 0 m_page_no: 2167803 m_table_id: 780 m_fragment_id: 1 m_extent_no: 3223 m_extent_info_ptr: 2148662496 m_restart_seq: 2] list_index: 1 free_space: 5 uncommitted_used_space: 0 2 : ]

3 : 0 : 1 : 2 : 3 : 0 :
page requests




Extent matrix
[ Extent_info: ptr.i 2147949120 [ m_page_no: 1709802 m_file_no: 0 m_page_idx: 54447] m_first_page_no: 1709802 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=1709802 m_page_idx=54447 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147949092 [ m_page_no: 1709866 m_file_no: 0 m_page_idx: 54449] m_first_page_no: 1709866 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=1709866 m_page_idx=54449 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147949064 [ m_page_no: 1709930 m_file_no: 0 m_page_idx: 54451] m_first_page_no: 1709930 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=1709930 m_page_idx=54451 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147949036 [ m_page_no: 1709994 m_file_no: 0 m_page_idx: 54453] m_first_page_no: 1709994 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=1709994 m_page_idx=54453 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754950 [ m_page_no: 2156682 m_file_no: 0 m_page_idx: 2876] m_first_page_no: 2156682 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2156682 m_page_idx=2876 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754936 [ m_page_no: 2156714 m_file_no: 0 m_page_idx: 2877] m_first_page_no: 2156714 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2156714 m_page_idx=2877 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754908 [ m_page_no: 2156778 m_file_no: 0 m_page_idx: 2879] m_first_page_no: 2156778 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2156778 m_page_idx=2879 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754866 [ m_page_no: 2156874 m_file_no: 0 m_page_idx: 2882] m_first_page_no: 2156874 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2156874 m_page_idx=2882 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754838 [ m_page_no: 2156938 m_file_no: 0 m_page_idx: 2884] m_first_page_no: 2156938 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2156938 m_page_idx=2884 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754726 [ m_page_no: 2157194 m_file_no: 0 m_page_idx: 2892] m_first_page_no: 2157194 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157194 m_page_idx=2892 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754656 [ m_page_no: 2157354 m_file_no: 0 m_page_idx: 2897] m_first_page_no: 2157354 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157354 m_page_idx=2897 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754544 [ m_page_no: 2157610 m_file_no: 0 m_page_idx: 2905] m_first_page_no: 2157610 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157610 m_page_idx=2905 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754516 [ m_page_no: 2157674 m_file_no: 0 m_page_idx: 2907] m_first_page_no: 2157674 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157674 m_page_idx=2907 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754488 [ m_page_no: 2157738 m_file_no: 0 m_page_idx: 2909] m_first_page_no: 2157738 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157738 m_page_idx=2909 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754460 [ m_page_no: 2157802 m_file_no: 0 m_page_idx: 2911] m_first_page_no: 2157802 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157802 m_page_idx=2911 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754432 [ m_page_no: 2157866 m_file_no: 0 m_page_idx: 2913] m_first_page_no: 2157866 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157866 m_page_idx=2913 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754418 [ m_page_no: 2157898 m_file_no: 0 m_page_idx: 2914] m_first_page_no: 2157898 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157898 m_page_idx=2914 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754390 [ m_page_no: 2157962 m_file_no: 0 m_page_idx: 2916] m_first_page_no: 2157962 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2157962 m_page_idx=2916 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754362 [ m_page_no: 2158026 m_file_no: 0 m_page_idx: 2918] m_first_page_no: 2158026 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158026 m_page_idx=2918 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754334 [ m_page_no: 2158090 m_file_no: 0 m_page_idx: 2920] m_first_page_no: 2158090 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158090 m_page_idx=2920 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754292 [ m_page_no: 2158186 m_file_no: 0 m_page_idx: 2923] m_first_page_no: 2158186 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158186 m_page_idx=2923 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754264 [ m_page_no: 2158250 m_file_no: 0 m_page_idx: 2925] m_first_page_no: 2158250 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158250 m_page_idx=2925 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754236 [ m_page_no: 2158314 m_file_no: 0 m_page_idx: 2927] m_first_page_no: 2158314 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158314 m_page_idx=2927 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754082 [ m_page_no: 2158698 m_file_no: 0 m_page_idx: 2939] m_first_page_no: 2158698 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158698 m_page_idx=2939 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754054 [ m_page_no: 2158762 m_file_no: 0 m_page_idx: 2941] m_first_page_no: 2158762 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158762 m_page_idx=2941 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754026 [ m_page_no: 2158826 m_file_no: 0 m_page_idx: 2943] m_first_page_no: 2158826 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158826 m_page_idx=2943 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147754012 [ m_page_no: 2158858 m_file_no: 0 m_page_idx: 2944] m_first_page_no: 2158858 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158858 m_page_idx=2944 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753984 [ m_page_no: 2158922 m_file_no: 0 m_page_idx: 2946] m_first_page_no: 2158922 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158922 m_page_idx=2946 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753940 [ m_page_no: 2158986 m_file_no: 0 m_page_idx: 2948] m_first_page_no: 2158986 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2158986 m_page_idx=2948 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753912 [ m_page_no: 2159050 m_file_no: 0 m_page_idx: 2950] m_first_page_no: 2159050 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159050 m_page_idx=2950 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753870 [ m_page_no: 2159146 m_file_no: 0 m_page_idx: 2953] m_first_page_no: 2159146 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159146 m_page_idx=2953 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753856 [ m_page_no: 2159178 m_file_no: 0 m_page_idx: 2954] m_first_page_no: 2159178 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159178 m_page_idx=2954 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753814 [ m_page_no: 2159274 m_file_no: 0 m_page_idx: 2957] m_first_page_no: 2159274 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159274 m_page_idx=2957 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753786 [ m_page_no: 2159338 m_file_no: 0 m_page_idx: 2959] m_first_page_no: 2159338 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159338 m_page_idx=2959 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753744 [ m_page_no: 2159434 m_file_no: 0 m_page_idx: 2962] m_first_page_no: 2159434 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159434 m_page_idx=2962 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753674 [ m_page_no: 2159594 m_file_no: 0 m_page_idx: 2967] m_first_page_no: 2159594 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159594 m_page_idx=2967 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753618 [ m_page_no: 2159722 m_file_no: 0 m_page_idx: 2971] m_first_page_no: 2159722 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159722 m_page_idx=2971 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753534 [ m_page_no: 2159914 m_file_no: 0 m_page_idx: 2977] m_first_page_no: 2159914 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2159914 m_page_idx=2977 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753156 [ m_page_no: 2160778 m_file_no: 0 m_page_idx: 3004] m_first_page_no: 2160778 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2160778 m_page_idx=3004 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753058 [ m_page_no: 2161002 m_file_no: 0 m_page_idx: 3011] m_first_page_no: 2161002 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161002 m_page_idx=3011 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147753002 [ m_page_no: 2161130 m_file_no: 0 m_page_idx: 3015] m_first_page_no: 2161130 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161130 m_page_idx=3015 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752904 [ m_page_no: 2161354 m_file_no: 0 m_page_idx: 3022] m_first_page_no: 2161354 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161354 m_page_idx=3022 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752820 [ m_page_no: 2161546 m_file_no: 0 m_page_idx: 3028] m_first_page_no: 2161546 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161546 m_page_idx=3028 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752764 [ m_page_no: 2161674 m_file_no: 0 m_page_idx: 3032] m_first_page_no: 2161674 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161674 m_page_idx=3032 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752722 [ m_page_no: 2161770 m_file_no: 0 m_page_idx: 3035] m_first_page_no: 2161770 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161770 m_page_idx=3035 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752666 [ m_page_no: 2161898 m_file_no: 0 m_page_idx: 3039] m_first_page_no: 2161898 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2161898 m_page_idx=3039 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752456 [ m_page_no: 2162378 m_file_no: 0 m_page_idx: 3054] m_first_page_no: 2162378 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2162378 m_page_idx=3054 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752358 [ m_page_no: 2162602 m_file_no: 0 m_page_idx: 3061] m_first_page_no: 2162602 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2162602 m_page_idx=3061 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752302 [ m_page_no: 2162730 m_file_no: 0 m_page_idx: 3065] m_first_page_no: 2162730 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2162730 m_page_idx=3065 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752246 [ m_page_no: 2162858 m_file_no: 0 m_page_idx: 3069] m_first_page_no: 2162858 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2162858 m_page_idx=3069 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147752190 [ m_page_no: 2162986 m_file_no: 0 m_page_idx: 3073] m_first_page_no: 2162986 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2162986 m_page_idx=3073 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751868 [ m_page_no: 2163754 m_file_no: 0 m_page_idx: 3097] m_first_page_no: 2163754 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2163754 m_page_idx=3097 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751812 [ m_page_no: 2163882 m_file_no: 0 m_page_idx: 3101] m_first_page_no: 2163882 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2163882 m_page_idx=3101 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751756 [ m_page_no: 2164010 m_file_no: 0 m_page_idx: 3105] m_first_page_no: 2164010 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164010 m_page_idx=3105 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751700 [ m_page_no: 2164138 m_file_no: 0 m_page_idx: 3109] m_first_page_no: 2164138 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164138 m_page_idx=3109 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751644 [ m_page_no: 2164266 m_file_no: 0 m_page_idx: 3113] m_first_page_no: 2164266 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164266 m_page_idx=3113 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751588 [ m_page_no: 2164394 m_file_no: 0 m_page_idx: 3117] m_first_page_no: 2164394 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164394 m_page_idx=3117 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751462 [ m_page_no: 2164682 m_file_no: 0 m_page_idx: 3126] m_first_page_no: 2164682 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164682 m_page_idx=3126 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751406 [ m_page_no: 2164810 m_file_no: 0 m_page_idx: 3130] m_first_page_no: 2164810 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164810 m_page_idx=3130 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751350 [ m_page_no: 2164938 m_file_no: 0 m_page_idx: 3134] m_first_page_no: 2164938 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2164938 m_page_idx=3134 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751280 [ m_page_no: 2165098 m_file_no: 0 m_page_idx: 3139] m_first_page_no: 2165098 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2165098 m_page_idx=3139 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751168 [ m_page_no: 2165354 m_file_no: 0 m_page_idx: 3147] m_first_page_no: 2165354 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2165354 m_page_idx=3147 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147751014 [ m_page_no: 2165706 m_file_no: 0 m_page_idx: 3158] m_first_page_no: 2165706 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2165706 m_page_idx=3158 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750958 [ m_page_no: 2165834 m_file_no: 0 m_page_idx: 3162] m_first_page_no: 2165834 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2165834 m_page_idx=3162 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750902 [ m_page_no: 2165962 m_file_no: 0 m_page_idx: 3166] m_first_page_no: 2165962 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2165962 m_page_idx=3166 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750846 [ m_page_no: 2166090 m_file_no: 0 m_page_idx: 3170] m_first_page_no: 2166090 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2166090 m_page_idx=3170 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750664 [ m_page_no: 2166538 m_file_no: 0 m_page_idx: 3184] m_first_page_no: 2166538 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2166538 m_page_idx=3184 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750580 [ m_page_no: 2166730 m_file_no: 0 m_page_idx: 3190] m_first_page_no: 2166730 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2166730 m_page_idx=3190 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750524 [ m_page_no: 2166858 m_file_no: 0 m_page_idx: 3194] m_first_page_no: 2166858 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2166858 m_page_idx=3194 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750468 [ m_page_no: 2166986 m_file_no: 0 m_page_idx: 3198] m_first_page_no: 2166986 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2166986 m_page_idx=3198 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750412 [ m_page_no: 2167114 m_file_no: 0 m_page_idx: 3202] m_first_page_no: 2167114 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167114 m_page_idx=3202 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750356 [ m_page_no: 2167242 m_file_no: 0 m_page_idx: 3206] m_first_page_no: 2167242 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167242 m_page_idx=3206 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750286 [ m_page_no: 2167402 m_file_no: 0 m_page_idx: 3211] m_first_page_no: 2167402 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167402 m_page_idx=3211 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750230 [ m_page_no: 2167530 m_file_no: 0 m_page_idx: 3215] m_first_page_no: 2167530 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167530 m_page_idx=3215 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750174 [ m_page_no: 2167658 m_file_no: 0 m_page_idx: 3219] m_first_page_no: 2167658 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167658 m_page_idx=3219 ] m_free_space: 160 m_free_matrix_pos: 0 m_free_page_count: [ 32 0 0 0 ] ] [ Extent_info: ptr.i 2147750118 [ m_page_no: 2167786 m_file_no: 0 m_page_idx: 3223] m_first_page_no: 2167786 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=2167786 m_page_idx=3223 ] m_free_space: 146 m_free_matrix_pos: 0 m_free_page_count: [ 29 1 : 2 : 1 2 0 ] ]


3 : 4 : 5 : 6 : 7 : 8 : 9 : 10 : 11 : 12 : 13 : 14 : 15 : 16 :












[ Extent_info: ptr.i 2148662496 [ m_page_no: 70634 m_file_no: 0 m_page_idx: 3223] m_first_page_no: 70634 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=70634 m_page_idx=3223 ] m_free_space: 13 m_free_matrix_pos: 16 m_free_page_count: [ 2 0 30 17 : 0 ] ]

18 : 19 :

current extent: [ Extent_info: ptr.i 2147949148 [ m_page_no: 1709738 m_file_no: 0 m_page_idx: 54445] m_first_page_no: 1709738 m_empty_page_no: 65536 m_key: [ m_file_no=0 m_page_no=1709738 m_page_idx=54445 ] m_free_space: 160 m_free_matrix_pos: 4294967040 m_free_page_count: [ 32 0 0 0 ] ]
For help with below stacktrace consult:
https://dev.mysql.com/doc/refman/en/using-stack-trace.html
Also note that stack_bottom and thread_stack will always show up as zero.
stack_bottom = 0 thread_stack 0x0
./ndbd(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x86da7e]
./ndbd(ndb_print_stacktrace()+0x45) [0x826305]
./ndbd(ErrorReporter::handleError(int, char const*, char const*, NdbShutdownType)+0x1f) [0x7def1f]
./ndbd(SimulatedBlock::progError(int, int, char const*, char const*) const+0xf2) [0x83f792]
./ndbd(Dbtup::disk_page_prealloc_dirty_page(Dbtup::Disk_alloc_info&, Ptr<Tup_page>, unsigned int, unsigned int, Dbtup::Fragrecord*)+0) [0x6a5af0]
./ndbd(Dbtup::disk_page_free(Signal*, Dbtup::Tablerec*, Dbtup::Fragrecord*, Local_key*, Ptr<Tup_page>, unsigned int, Local_key const*, unsigned int)+0x2af) [0x6a600f]
./ndbd(Dbtup::dealloc_tuple(Signal*, unsigned int, unsigned int, Tup_page*, Dbtup::Tuple_header*, Dbtup::KeyReqStruct*, Dbtup::Operationrec*, Dbtup::Fragrecord*, Dbtup::Tablerec*, Ptr<GlobalPage>)+0x101) [0x7be191]
./ndbd(Dbtup::execTUP_COMMITREQ(Signal*)+0xeec) [0x7c0a0c]
./ndbd(Dblqh::commitContinueAfterBlockedLab(Signal*, Ptr<Dblqh::TcConnectionrec>)+0x1ab) [0x62a4eb]
./ndbd(Dblqh::execCOMMIT(Signal*)+0x194) [0x62b2b4]
./ndbd(Dblqh::execPACKED_SIGNAL(Signal*)+0x3af) [0x62c03f]
./ndbd(FastScheduler::doJob(unsigned int)+0x1da) [0x83bd5a]
./ndbd(ThreadConfig::ipControlLoop(NdbThread*)+0x6b2) [0x84a762]
./ndbd(ndbd_run(bool, int, char const*, int, char const*, bool, bool, bool, unsigned int, int, int, unsigned long)+0x758) [0x4f4468]
./ndbd(real_main(int, char**)+0x2e5) [0x4f25b5]
./ndbd(angel_run(char const*, Vector<BaseString> const&, char const*, int, char const*, bool, bool, bool, int, int)+0xfeb) [0x4f213b]
./ndbd(real_main(int, char**)+0x34c) [0x4f261c]
./ndbd(main+0x37) [0x4eea27]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f1da4302505]
./ndbd() [0x4f0011]
2021-01-05 16:57:25 [ndbd] INFO -- ../../../../../../mysql-cluster-gpl-8.0.22/storage/ndb/src/kernel/blocks/dbtup/DbtupDiskAlloc.cpp
2021-01-05 16:57:25 [ndbd] INFO -- DBTUP (Line: 1058) 0x00000002
2021-01-05 16:57:25 [ndbd] INFO -- Error handler shutting down system
2021-01-05 16:57:26 [ndbd] ALERT -- Node 12: Forced node shutdown completed. Caused by error 2301: 'Assertion(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL NDB runs for a period of time, restarts, data nodes, can not start up properly, do not know what methods can be less loss of data to start up properly
235
January 08, 2021 01:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.