сбой (core)
【Тип теста: SQL-функции】【Тестовая версия: 7.0.0-RC2】 ustore таблица создает индекс при core
【Информация об операционной системе и оборудовании】(запрос команды: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
Linux szvpwebenv03662 4.19.90-2003.4.0.0036.oe1.aarch64 #1:【6.0.1】Ошибка подключения клиента MySQL SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux
【Тестовая среда】(один сервер/1 главный x резервных x каскадных резервных): один главный и два резервных
【Тестируемая функция】: хэш-разделение ubtree индекс -- создание индекса, много таблиц соединяются в запросе
【Тип теста】: функциональное тестирование
【Версия базы данных】(запрос команды: gaussdb -V):
gaussdb (openGauss 7.0.0-RC1 build c20928a5) compiled at 2025-04-14 10:55:59 commit 0 last mr
【Предварительные условия】: база данных работает нормально
【Процедура выполнения】(укажите подробные шаги выполнения):
drop table if exists t_ustore_ubtree_0020_01,t_ustore_ubtree_0020_02 cascade;
drop index if exists index_ustore_0020_01,index_ustore_0020_02;
create table t_ustore_ubtree_0020_01
(
c_integer integer,
c_smallint smallint,
c_bigint bigint,
c_decimal decimal,
c_numeric numeric,
c_real real,
c_double double precision,
c_character_1 character varying(100),
c_varchar varchar(100),
c_character_2 character(100),
c_char_1 char(100),
c_character_3 character,
c_char_2 char,
c_text text,
c_nvarchar2 nvarchar2,
c_name text,
c_timestamp_1 timestamp without time zone ,
c_timestamp_2 timestamp with time zone,
c_date date,
c_tsvector text,
c_tsquery text
) with (storage_type=ustore)
partition by hash(c_integer)
(
partition p1 ,
partition p2 ,
partition p3
);
create table t_ustore_ubtree_0020_02
(
c_integer integer,
c_smallint smallint,
c_bigint bigint,
c_decimal decimal,
c_numeric numeric,
c_real real,
c_double double precision,
c_character_1 character varying(100),
c_varchar varchar(100),
c_character_2 character(100),
c_char_1 char(100),
c_character_3 character,
c_char_2 char,
c_text text,
c_nvarchar2 nvarchar2,
c_name text,
c_timestamp_1 timestamp without time zone ,
c_timestamp_2 timestamp with time zone,
c_date date,
c_tsvector text,
c_tsquery text
) with (storage_type=ustore)
partition by hash(c_integer)
(
partition p1 ,
partition p2 ,
partition p3
);
insert into t_ustore_ubtree_0020_01 values(generate_series(1,140000),10,100,100.3,10,10.2,1000.25,'abcd','abcd','abc','def','a','a','hk','olumnar_storage','b','1954-2-6 00:00:30+8','1954-2-6 23:12:12.2356','1954-2-6 13:12:12.2356','abc db','ege');
insert into t_ustore_ubtree_0020_02 values(generate_series(1,140000),10,100,100.3,10,10.2,1000.25,'abcd','abcd','abc','def','a','a','hk','olumnar_storage','b','1954-2-6 00:00:30+8','1954-2-6 23:12:12.2356','1954-2-6 13:12:12.2356','abc db','ege');
create index index_ustore_0020_01 on t_ustore_ubtree_0020_01(c_integer) ;
create index index_ustore_0020_02 on t_ustore_ubtree_0020_02(c_integer) ;
【Ожидаемый результат】:
【Фактический результат】:
(gdb) bt
#0 0x0000aaab56818d0c in sys_wait4 (ru=0x0, options=options@entry=1073741824, stat_addr=stat_addr@entry=0xfffc766c40dc, upid=upid@entry=1139009)
at bbox_syscall_support.cpp:36
#1 sys_waitpid (pid=pid@entry=1139009, status=status@entry=0xfffc766c40dc, options=options@entry=1073741824) at bbox_syscall_support.cpp:516
#2 0x0000aaab5681a108 in BBOX_GetClonePidResult (iClonePid=iClonePid@entry=1139009, pstArgs=pstArgs@entry=0xfffc766c4160,
iCloneErrno=iCloneErrno@entry=9) at bbox_threads.cpp:572
#3 0x0000aaab5681a448 in BBOX_GetAllThreads (enType=<optimized out>, pDone=pDone@entry=0xaaab56810ff0 <BBOX_FinishDumpFile(void*)>,
pDoneArgs=pDoneArgs@entry=0xfffc766c42a8, pCallback=<optimized out>) at bbox_threads.cpp:700
#4 0x0000aaab568112ac in BBOX_CreateCoredump (file_name=0xfffc766c43d8 "/core/corefile//core-gaussdb-955119-2025_04_15_22_30_30-bbox.lz4",
file_name@entry=0x0) at bbox_create.cpp:440
#5 0x0x fffdc9ca7a in abort () from /lib64/libc.so.6
#6 <signal handler called>
#7 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 x
#8 x x x x x x x x x x x x x x x x x x x x x x x x x x
# a a a a a a a a a a a a a a a a a a a a a a
# b b b b b b b b b b b b b b b b b b b
# c c c c c c c c c c c c c c c c c
# d d d d d d d d d d d d d d d
# e e e e e e e e e e e e e
# f f f f f f f f f f f f
# g g g g g g g g g g g
# h h h h h h h h h h
# i i i i i i i i i i
# j j j j j j j j j j
# k k k k k k k k k k
# l l l l l l l l l l
# m m m m m m m m m m
# n n n n n n n n n n
# o o o o o o o o o o
# p p p p p p p p p p
# q q q q q q q q q q
# r r r r r r r r r r
# s s s s s s s s s s
# t t t t t t t t t t
# u u u u u u u u u u
# v v v v v v v v v v
# w w w w w w w w w w
# x x x x x x x x x x
# y y y y y y y y y y
# z z z z z z z z z z
# A A A A A A A A A A
# B B B B B B B B B B
# C C C C C C C C C C
# D D D D D D D D D D
# E E E E E E E E E E
# F F F F F F F F F F
# G G G G G G G G G G
# H H H H H H H H H H
# I I I I I I I I I I
# J J J J J J J J J J
# K K K K K K K K K K
# L L L L L L L L L L
# M M M M M M M M M M
# N N N N N N N N N N
# O O O O O O O O O O
# P P P P P P P P P P
# Q Q Q Q Q Q Q Q Q Q
# R R R R R R R R R R
# S S S S S S S S S S
# T T T T T T T T T T
# U U U U U U U U U U
# V V V V V V V V V V
# W W W W W W W W W W
# X X X X X X X X X X
# Y Y Y Y Y Y Y Y Y Y
# Z Z Z Z Z Z Z Z Z Z
(gdb) f 18
#18 errfinish (dummy=<optimized out>) at elog.cpp:877
(gdb) p *edata
$1 = {elevel = ERROR, output_to_server = true, output_to_client = false, handle_in_client = false, show_funcname = false, hide_stmt = false,
hide_prefix = false, filename = "xlog.cpp", lineno = 2777, funcname = "XLogWrite", domain = "gaussdb-9.2", sqlerrcode = XXEIO,
mod_id = MOD_MAX, message = "xlog write request %X/%X is past end of log %X/%X", detail = NULL, detail_log = NULL, hint = NULL, context = NULL,
cursorpos = -1, internalpos = -1, internalquery = NULL, saved_errno = -EIO, backtrace_log = "tid[9777]'s backtrace:\n/data/func_c_794/cluster/app/bin/gaussdb(+...<truncated>", internalerrcode = ERRCODE_UNDEFINED_FILE, verbose = false,
ignore_interrupt = false, cause = NULL, action = NULL, sqlstate = NULL, class_origin = NULL, subclass_origin = NULL, cons_catalog = NULL,
cons_schema = NULL, cons_name = NULL, catalog_name = NULL, schema_name = NULL, table_name = NULL, column_name = NULL, cursor_name = NULL,
mysql_errno = NULL, is_warnings_throw = false, is_signal = false, onlyfrontmsg = false}
(gdb)
【Анализ причины】:
【Информация из логов】(приложите файлы логов, скриншоты, информацию из coredump):
【Тестовый код】: