amorynan opened a new pull request, #45305:
URL: https://github.com/apache/doris/pull/45305
### What problem does this PR solve?
if we create table with array/map/struct column which defined not null
then we alter column to null, in fact it can be work ,
but when we select it ,here may meet core below
```
mysql> create table etest ( `id` VARCHAR(50) NOT NULL COMMENT '主键id',
`second_categories` ARRAY < VARCHAR(255)> NOT NULL COMMENT '二级分类') ENGINE =
OLAP UNIQUE KEY(`id`) DISTRIBUTED BY HASH(`id`) BUCKETS 1 PROPERTIES (
'replication_allocation' = 'tag.location.default: 1',
'enable_unique_key_merge_on_write' = 'true', 'light_schema_change' = 'true',
'disable_auto_compaction'='true');
Query OK, 0 rows affected (0.12 sec)
mysql> insert into etest values (3, ['aaa', 'bbb', 'ccc']);
Query OK, 1 row affected (0.22 sec)
{'label':'label_e30fad022ff5423f_9c74c9fc9eb886a7', 'status':'VISIBLE',
'txnId':'1025'}
mysql> alter table etest modify column `second_categories`
array<varchar(255)> NULL COMMENT '二级分类';
Query OK, 0 rows affected (0.10 sec)
mysql> show alter table column;
+-------+-----------+-------------------------+-------------------------+-----------+---------+---------------+---------------+---------------+----------+------+----------+---------+
| JobId | TableName | CreateTime | FinishTime |
IndexName | IndexId | OriginIndexId | SchemaVersion | TransactionId | State
| Msg | Progress | Timeout |
+-------+-----------+-------------------------+-------------------------+-----------+---------+---------------+---------------+---------------+----------+------+----------+---------+
| 11109 | mtest | 2024-12-10 20:46:04.491 | 2024-12-10 20:46:05.731 |
mtest | 11110 | 11093 | 1:1857912462 | 1007 | FINISHED
| | NULL | 2592000 |
| 11156 | btest | 2024-12-10 21:07:07.575 | 2024-12-10 21:07:08.901 |
btest | 11157 | 11147 | 1:70379151 | 1018 | FINISHED
| | NULL | 2592000 |
| 11178 | ctest | 2024-12-10 21:10:52.656 | 2024-12-10 21:10:53.931 |
ctest | 11179 | 11162 | 1:1462395050 | 1022 | FINISHED
| | NULL | 2592000 |
| 11189 | dtest | 2024-12-10 21:22:17.019 | 2024-12-10 21:22:18.029 |
dtest | 11190 | 11184 | 1:1194829729 | 1024 | FINISHED
| | NULL | 2592000 |
| 11200 | etest | 2024-12-10 21:30:06.902 | 2024-12-10 21:30:08.094 |
etest | 11201 | 11195 | 1:18626462 | 1026 | FINISHED
| | NULL | 2592000 |
+-------+-----------+-------------------------+-------------------------+-----------+---------+---------------+---------------+---------------+----------+------+----------+---------+
5 rows in set (0.10 sec)
mysql> select * from etest;
ERROR 1105 (HY000): errCode = 2, detailMessage = There is no scanNode
Backend available.[10048: not alive]
```
be core:
```
StdoutLogger 2024-12-10 21:09:52,967 Start time: 2024年 12月 10日 星期二 21:09:52
CST
INFO: java_cmd /mnt/disk2/wangqiannan/tool/jdk-17.0.10/bin/java
INFO: jdk_version 17
Java HotSpot(TM) 64-Bit Server VM warning: Option CriticalJNINatives was
deprecated in version 16.0 and will likely be removed in a future release.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/mnt/disk2/wangqiannan/amory/master/doris/output/be/lib/java_extensions/preload-extensions/preload-extensions-jar-with-dependencies.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/mnt/disk2/wangqiannan/amory/master/doris/output/be/lib/java_extensions/java-udf/java-udf-jar-with-dependencies.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/mnt/disk2/wangqiannan/amory/master/doris/output/be/lib/hadoop_hdfs/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Reload4jLoggerFactory]
[WARNING!] /sys/kernel/mm/transparent_hugepage/enabled: [always] madvise
never, Doris not recommend turning on THP, which may cause the BE process to
use more memory and cannot be freed in time. Turn off THP: `echo madvise | sudo
tee /sys/kernel/mm/transparent_hugepage/enabled`
*** Query id: 5a013c428ba942dd-afd4481a8e7ec4b3 ***
*** is nereids: 1 ***
*** tablet id: 0 ***
*** Aborted at 1733836267 (unix time) try "date -d @1733836267" if you are
using GNU date ***
*** Current BE git commitID: 443e87e203 ***
*** SIGSEGV address not mapped to object (@0x0) received by PID 3270216 (TID
3276799 OR 0x7f0aae76a700) from PID 0; stack trace: ***
0# doris::signal::(anonymous namespace)::FailureSignalHandler(int,
siginfo_t*, void*) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/common/signal_handler.h:421
1# PosixSignals::chained_handler(int, siginfo*, void*) [clone .part.0] in
/mnt/disk2/wangqiannan/tool/jdk-17.0.10/lib/server/libjvm.so
2# JVM_handle_linux_signal in
/mnt/disk2/wangqiannan/tool/jdk-17.0.10/lib/server/libjvm.so
3# 0x00007F10737305B0 in /lib64/libc.so.6
4# doris::segment_v2::ArrayFileColumnIterator::next_batch(unsigned long*,
COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>&,
bool*) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/segment_v2/column_reader.cpp:999
5# doris::segment_v2::ArrayFileColumnIterator::read_by_rowids(unsigned int
const*, unsigned long,
COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>&) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/segment_v2/column_reader.cpp:1012
6#
doris::segment_v2::SegmentIterator::_read_columns_by_rowids(std::vector<unsigned
int, std::allocator<unsigned int> >&, std::vector<unsigned int,
std::allocator<unsigned int> >&, unsigned short*, unsigned long,
std::vector<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>,
std::allocator<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>
> >*) in /mnt/disk2/wangqiannan/amory/master/doris/output/be/lib/doris_be
7#
doris::segment_v2::SegmentIterator::_next_batch_internal(doris::vectorized::Block*)
at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/segment_v2/segment_iterator.cpp:2222
8#
doris::segment_v2::SegmentIterator::next_batch(doris::vectorized::Block*) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/segment_v2/segment_iterator.cpp:1908
9#
doris::segment_v2::LazyInitSegmentIterator::next_batch(doris::vectorized::Block*)
at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/segment_v2/lazy_init_segment_iterator.h:45
10# doris::BetaRowsetReader::next_block(doris::vectorized::Block*) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/olap/rowset/beta_rowset_reader.cpp:342
11#
doris::vectorized::VCollectIterator::Level0Iterator::refresh_current_row() at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/vec/olap/vcollect_iterator.cpp:508
12#
doris::vectorized::VCollectIterator::Level0Iterator::ensure_first_row_ref() at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/vec/olap/vcollect_iterator.cpp:483
13#
doris::vectorized::VCollectIterator::Level1Iterator::ensure_first_row_ref() in
/mnt/disk2/wangqiannan/amory/master/doris/output/be/lib/doris_be
14#
doris::vectorized::VCollectIterator::build_heap(std::vector<std::shared_ptr<doris::RowsetReader>,
std::allocator<std::shared_ptr<doris::RowsetReader> > >&) at
/mnt/disk2/wangqiannan/amory/master/doris/be/src/vec/olap/vcollect_iterator.cpp:186
```
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should
merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
