Function already registered: presto.default.array_split_into_chunks<T>(array(T),integer):array(array(T))

[majetideepak]

Starting a newly built coordinator is throwing the following error

2025-09-09T13:28:25.638-0400 ERROR main com.facebook.presto.server.PrestoServer Function already registered: presto.default.array_split_into_chunks(array(T),integer):array(array(T)) java.lang.IllegalArgumentException: Function already registered: presto.default.array_split_into_chunks(array(T),integer):array(array(T)) at com.google.common.base.Preconditions.checkArgument(Preconditions.java:218)
at com.facebook.presto.metadata.BuiltInPluginFunctionNamespaceManager.checkForNamingConflicts(BuiltInPluginFunctionNamespaceManager.java:51)
at com.facebook.presto.metadata.BuiltInPluginFunctionNamespaceManager.registerBuiltInSpecialFunctions(BuiltInPluginFunctionNamespaceManager.java:42) at com.facebook.presto.metadata.FunctionAndTypeManager.registerPluginFunctions(FunctionAndTypeManager.java:498) at com.facebook.presto.server.PluginManager.installPlugin(PluginManager.java:312) at com.facebook.presto.server.PluginManager$MainPluginInstaller.installPlugin(PluginManager.java:358) at com.facebook.presto.server.PluginManagerUtil.loadPlugin(PluginManagerUtil.java:165)
at com.facebook.presto.server.PluginManagerUtil.loadPlugin(PluginManagerUtil.java:145)
at com.facebook.presto.server.PluginManagerUtil.loadPlugins(PluginManagerUtil.java:95) at com.facebook.presto.server.PluginManager.loadPlugins(PluginManager.java:180)
at com.facebook.presto.server.PrestoServer.run(PrestoServer.java:160)
at com.facebook.presto.server.PrestoServer.main(PrestoServer.java:99)

[majetideepak]

Introduced from #25870

[zoltan]

would be interesting to see how this passed CI in the first place?

[majetideepak]

A workaround for this issue is to delete "${PRESTO_SERVER_DIR}/plugin/native-sql-invoked-functions-plugin" from the deployment.
CI is passing because it uses a query runner that does not load all the plugins.

[pdabre12]

@majetideepak I have a potential fix: #25984, PTAL.

[pdabre12]

In #25870, presto-product-tests CI job was failing and I removed the native-sql-invoked-functions-plugin to pass the CI.

# The following plugin results in a function signature conflict when loaded in Java/ sidecar disabled native clusters.
# This plugin is only meant for sidecar enabled native clusters, hence exclude it.
PLUGIN_TO_EXCLUDE="native-sql-invoked-functions-plugin"

if [[ -d "${PRESTO_SERVER_DIR}/plugin/${PLUGIN_TO_EXCLUDE}" ]]; then
    echo "Excluding plugin: $PLUGIN_TO_EXCLUDE"
    rm -rf "${PRESTO_SERVER_DIR}/plugin/${PLUGIN_TO_EXCLUDE}"
fi

I removed the exclusion in #25984, waiting for the CI (presto-product-tests) to pass now.

[majetideepak]

Resolved with #25984