Query with LISTAGG function fails on secondary subcluster but passes on primary (Error loading file)
we have Vertica12 EON db on Google Cloud. Users reported a strange problem with one of the reports using a query with LISTAGG function in it.
We have 6 nodes in primary subcluster used for ETL/ELT and 6 nodes in secondary subcluster used for analytics.
Vertica native connection load balancing works great and analytics users are routed to the secondary subcluster.
This is the error we get on secondary subcluster:
SQL Error  : [Vertica]VJDBC ERROR: Error loading library file [/vertica/catalog/NessieGCP/v_nessiegcp_node0008_catalog/Libraries/02ffc9adc1834b5e837f96abfca0502d00a00000000003d6/VFunctionsLib_02ffc9adc1834b5e837f96abfca0502d00a00000000003d6.so]: Failure in UDx RPC call InvokeCheckLibrary(): Error calling setupExecContext() in User Defined Object  at [/data/jenkins/workspace/RE-ReleaseBuilds/RE-Knuckleboom_2/server/vertica/OSS/UDxFence/vertica-udx-C++.cpp:241], error code: 0, message: Error happened in dlopen(): [/vertica/catalog/NessieGCP/v_nessiegcp_node0008_catalog/Libraries/02ffc9adc1834b5e837f96abfca0502d00a00000000003d6/VFunctionsLib_02ffc9adc1834b5e837f96abfca0502d00a00000000003d6.so: cannot open shared object file: No such file or directory]
It works on primary no problem.
Should I copy those files to all nodes of secondary subcluster? Why arent they already there? What's going on?