在Doris4.X别名函数兼容问题

Viewed 7
4.1 4.0

在Doris3.X创建的别名函数

CREATE GLOBAL ALIAS FUNCTION LASTEST_VALUE(DATETIME, STRING, DATETIME, STRING)
WITH PARAMETER(t1, v1, t2, v2) 
AS ARRAY_LAST(x->x IS NOT NULL,ARRAY_SORTBY(ARRAY(v1,v2),ARRAY(t1,t2)));

在升级到Doris4.X后 FE重启失败，日志出现

2026-07-06 20:18:32,319 ERROR (replayer|110) [BDBJournalCursor.next():130] fail to read journal entity key=173783697, will exit
com.google.gson.JsonParseException: cannot deserialize class org.apache.doris.analysis.Expr because it does not define a field named clazz
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:321)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:40)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:40)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:40)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:40)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:40)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
        at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson$FutureTypeAdapter.read(Gson.java:1367)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.readIntoField(ReflectiveTypeAdapterFactory.java:212)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$FieldReflectionAdapter.readField(ReflectiveTypeAdapterFactory.java:433)
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:393)
        at org.apache.doris.persist.gson.GsonUtils$PostProcessTypeAdapterFactory$1.read(GsonUtils.java:956)
        at org.apache.doris.persist.gson.GsonUtils$PreProcessTypeAdapterFactory$1.read(GsonUtils.java:935)
        at com.google.gson.TypeAdapter.fromJsonTree(TypeAdapter.java:299)
        at org.apache.doris.persist.gson.RuntimeTypeAdapterFactory$1.read(RuntimeTypeAdapterFactory.java:330)
        at com.google.gson.TypeAdapter$1.read(TypeAdapter.java:204)
        at com.google.gson.Gson.fromJson(Gson.java:1227)
        at com.google.gson.Gson.fromJson(Gson.java:1137)
        at com.google.gson.Gson.fromJson(Gson.java:1047)
        at com.google.gson.Gson.fromJson(Gson.java:982)
        at org.apache.doris.catalog.Function.read(Function.java:421)
        at org.apache.doris.journal.JournalEntity.readFields(JournalEntity.java:505)
        at org.apache.doris.journal.bdbje.BDBJournalCursor.next(BDBJournalCursor.java:127)
        at org.apache.doris.catalog.Env.replayJournal(Env.java:3079)
        at org.apache.doris.catalog.Env$4.runOneCycle(Env.java:2863)
        at org.apache.doris.common.util.Daemon.run(Daemon.java:119)
2026-07-06 20:18:32,320 INFO (Thread-0|23) [DorisFE.lambda$start$0():159] Received shutdown signal, starting graceful shutdown...
2026-07-06 20:18:32,322 INFO (Thread-0|23) [DorisFE.gracefulShutdown():631] graceful shutdown finished

使用sh bin/start_fe.sh --metadata_failure_recovery --daemon 启动还是失败
在fe.conf 中增加配置：enable_bdbje_debug_mode=true，之后通过 sh start_fe.sh –daemon 启动 FE 但使用mysqlsh无法连接 出现Access denied

排查bdb日志发现

ÿy<87>è^@<84>^@^@èø{"clazz":"AliasFunction","of":{"clazz":"FunctionCallExpr","fnn":{"fn":"element_at"},"fnp":{"isStar":false,"exprs":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array_filter"},"fnp":{"isStar":false,"exprs":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array_sortby"},"fnp":{"isStar":false,"exprs":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}]},{"clazz":"LambdaFunctionCallExpr","fnn":{"fn":"array_map"},"fnp":{"isStar":false,"exprs":[{"clazz":"LambdaFunctionExpr","ns":["x"],"ses":[{"clazz":"IsNullPredicate","inn":true,"type":{"clazz":"ScalarType","type":"BOOLEAN","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"ps":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"type":{"clazz":"ScalarType","type":"LAMBDA_FUNCTION","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"clazz":"IsNullPredicate","inn":true,"type":{"clazz":"ScalarType","type":"BOOLEAN","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array_sortby"},"fnp":{"isStar":false,"exprs":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"BOOLEAN","len":-1,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"LambdaFunctionExpr","ns":["x"],"ses":[{"clazz":"IsNullPredicate","inn":true,"type":{"clazz":"ScalarType","type":"BOOLEAN","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"ps":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"type":{"clazz":"ScalarType","type":"LAMBDA_FUNCTION","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"clazz":"IsNullPredicate","inn":true,"type":{"clazz":"ScalarType","type":"BOOLEAN","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[{"type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array_sortby"},"fnp":{"isStar":false,"exprs":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"v1","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"v2","type":{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},{"clazz":"FunctionCallExpr","fnn":{"fn":"array"},"fnp":{"isStar":false,"exprs":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}],"isDistinct":false},"iafc":false,"itfc":false,"type":{"clazz":"ArrayType","itemType":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"containsNull":true},"opcode":"INVALID_OPCODE","children":[{"clazz":"SlotRef","col":"t1","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]},{"clazz":"SlotRef","col":"t2","type":{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]}]}]}]},{"clazz":"IntLiteral","v":-1,"type":{"clazz":"ScalarType","type":"BIGINT","len":-1,"precision":0,"scale":0},"opcode":"INVALID_OPCODE","children":[]}]},"pm":["t1","v1","t2","v2"],"id":1769034073918,"n":{"fn":"lastest_value"},"rt":{"clazz":"ScalarType","type":"VARCHAR","len":-1,"precision":0,"scale":0},"at":[{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0},{"clazz":"ScalarType","type":"DATETIMEV2","len":-1,"precision":18,"scale":0},{"clazz":"ScalarType","type":"STRING","len":2147483643,"precision":0,"scale":0}],"hva":false,"uv":true,"bt":"JAVA_UDF","nm":"DEPEND_ON_ARGUMENT","cs":"","isU":false,"isS":false,"eT":360}<80>^@^@^@

删除改条及后续日志，启动FE成功

此函数在Doris3.X中可以正常使用，在Doris4.0.2中创建会导致FE直接挂掉，且无法自动恢复，在升级到Doris4.1.0时也会有部分别名函数不兼容导致无法启动FE

希望后续Doris在别名函数有兜底兼容处理方式
可以增加恢复模式，在不加载元数据的情况下启动，以便修复出问题的元数据
FE无法正常启动影响非常大

1 Answers

这个问题后边修复过了，当前得跳过这个 journal_id：
fe.conf force_skip_journal_ids=173783697

然后重启FE试试。

后边将版本升级到4.0.6 或者 4.1.2 上

阿渊@SelectDB (没回帖直接加我主页微信)10160
Related Questions
FE节点内存溢出
1 answers
在Doris4.X别名函数兼容问题
1 answers
SHOW FUNCTIONS 信息不完整
1 answers
4.1.x版本遇到Decimal数据类型报错[NOT_IMPLEMENTED_ERROR]Wrong precision 0, min: 1, max: 76
2 answers
variant字段支持作为JAVA udf输入输出参数吗？
1 answers
建议支持geo结构存储类型