Question

export to parquet suddenly gone

Forum|Forum|2 years ago
November 4, 2023
14 replies
16 views

lvehbiu
Participating Frequently

I have 9.2.0. It was working previously but then the db got corrupted. Everything is working fine besides this
function.

I followed this discussion but nothing: https://forum.vertica.com/discussion/239397/export-to-parquet-error-3457

When I try to install I get:

vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:13: ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:16: ROLLBACK 3861: Library not found: public.ParquetExportLib
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:17: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ParquetExport
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:19: ROLLBACK 3861: Library not found: public.ParquetExportLib
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:20: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ParquetExportMulti
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:22: ROLLBACK 3861: Library not found: public.ParquetExportLib
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ParquetExportFinalize

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 5, 2023

023-11-05 11:46:03.992 Init Session:7fce25440700-a000000003d337 [Txn] <INFO> Begin Txn: a000000003d337 'CREATE OR REPLACE LIBRARY public.ParquetExportLib AS '/opt/vertica/packages/ParquetExport/lib/parquetexport.so';'
2023-11-05 11:46:03.992 Init Session:7fce25440700-a000000003d337 [Command] <INFO> Processing Create Library statement
2023-11-05 11:46:03.992 Init Session:7fce25440700-a000000003d337 [EE] <INFO> The UDx zygote process is down, restarting it...
2023-11-05 11:46:04.049 Init Session:7fce25440700-a000000003d337 [EE] <INFO> Trying to set up a new UDx side process
2023-11-05 11:46:04.050 Init Session:7fce25440700-a000000003d337 <ROLLBACK> @v_datamart_node0001: 57V03/2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:19: ROLLBACK 3861:  Library not found: public.ParquetExportLib
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:20: ROLLBACK 2059:  Transform Function with specified name and parameters does not exist: ParquetExportMulti
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:22: ROLLBACK 3861:  Library not found: public.ParquetExportLib
    LOCATION:  createNewUDxSideProcess, /data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_0-x_grader/build/vertica/EE/EEUtil/UDxFenceSupport.cpp:812
2023-11-05 11:46:04.051 Init Session:7fce25440700-a000000003d337 [Txn] <INFO> Rollback Txn: a000000003d337 'CREATE OR REPLACE LIBRARY public.ParquetExportLib AS '/opt/vertica/packages/ParquetExport/lib/parquetexport.so';'
2023-11-05 11:46:04.051 Init Session:7fce25440700-a000000003d337 [Catalog] <WARNING> Transaction contains incomplete objects. Removing them now
2023-11-05 11:46:04.051 Init Session:7fce25440700-a000000003d337 [Catalog] <WARNING> Removing incomplete object 45035996274159652 from transaction.
2023-11-05 11:46:04.051 Init Session:7fce25440700 [Session] <INFO> [Query] TX:0(v_datamart_node0001-69:0x159d1) ;
2023-11-05 11:46:04.051 Init Session:7fce25440700 [Session] <INFO> [Query] TX:0(v_datamart_node0001-69:0x159d1) CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExport AS LANGUAGE 'C++' NAME 'ParquetExportFactory' LIBRARY public.ParquetExportLib NOT FENCED;
2023-11-05 11:46:04.051 Init Session:7fce25440700-a000000003d338 [Txn] <INFO> Begin Txn: a000000003d338 'CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExport AS LANGUAGE 'C++' NAME 'ParquetExportFactory' LIBRARY public.ParquetExportLib NOT FENCED;'
2023-11-05 11:46:04.052 Init Session:7fce25440700-a000000003d338 [Proc] <INFO> Processing Create User Defined Transform statement
2023-11-05 11:46:04.052 Init Session:7fce25440700-a000000003d338 [Txn] <INFO> Rollback Txn: a000000003d338 'CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExport AS LANGUAGE 'C++' NAME 'ParquetExportFactory' LIBRARY public.ParquetExportLib NOT FENCED;'
2023-11-05 11:46:04.052 Init Session:7fce25440700 <ROLLBACK> @v_datamart_node0001: 42V13/3861: Library not found: public.ParquetExportLib
    LOCATION:  setLibraryAndOptionsInfo, /data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_0-x_grader/build/vertica/Catalog/LanguageSupport.cpp:1696
2023-11-05 11:46:04.053 Init Session:7fce25440700 [Session] <INFO> [Query] TX:0(v_datamart_node0001-69:0x159d1) GRANT EXECUTE ON TRANSFORM FUNCTION public.ParquetExport() TO PUBLIC;
vsql:/opt/vertica/packages/ParquetExport/ddl/install.sql:23: 2023-11-05 11:46:04.053 Init Session:7fce25440700-a000000003d339 [Txn] <INFO> Begin Txn: a000000003d339 'GRANT EXECUTE ON TRANSFORM FUNCTION public.ParquetExport() TO PUBLIC;'
ROLLBACK 2059:  Transform Function with specified name and parameters does not exist: ParquetExportFinalize
2023-11-05 11:46:04.054 Init Session:7fce25440700-a000000003d339 [Txn] <INFO> Rollback Txn: a000000003d339 'GRANT EXECUTE ON TRANSFORM FUNCTION public.ParquetExport() TO PUBLIC;'
2023-11-05 11:46:04.054 Init Session:7fce25440700 <ROLLBACK> @v_datamart_node0001: VP000/2059: Transform Function with specified name and parameters does not exist: ParquetExport
    LOCATION:  matchProc, /data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_0-x_grader/build/vertica/Proc/ProcHandler.cpp:235
2023-11-05 11:46:04.054 Init Session:7fce25440700 [Session] <INFO> [Query] TX:0(v_datamart_node0001-69:0x159d1) CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExportMulti AS LANGUAGE 'C++' NAME 'ParquetExportMultiFactory' LIBRARY public.ParquetExportLib NOT FENCED;
2023-11-05 11:46:04.054 Init Session:7fce25440700-a000000003d33a [Txn] <INFO> Begin Txn: a000000003d33a 'CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExportMulti AS LANGUAGE 'C++' NAME 'ParquetExportMultiFactory' LIBRARY public.ParquetExportLib NOT FENCED;'
2023-11-05 11:46:04.055 Init Session:7fce25440700-a000000003d33a [Proc] <INFO> Processing Create User Defined Transform statement
2023-11-05 11:46:04.055 Init Session:7fce25440700-a000000003d33a [Txn] <INFO> Rollback Txn: a000000003d33a 'CREATE OR REPLACE TRANSFORM FUNCTION public.ParquetExportMulti AS LANGUAGE 'C++' NAME 'ParquetExportMultiFactory' LIBRARY public.ParquetExportLib NOT FENCED;'
2023-11-05 11:46:04.055 Init Session:7fce25440700 <ROLLBACK> @v_datamart_node0001: 42V13/3861: Library not found: public.ParquetExportLib
    LOCATION:  setLibraryAndOptionsInfo, /data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_0-x_grader/build/vertica/Catalog/LanguageSupport.cpp:1696

Bryan_H
Participating Frequently
Forum|Forum|2 years ago
November 7, 2023

Export library is installed in the database catalog as a library. If the database was corrupted, it's possible the export library was affected. It looks like you tried to run the create library SQL. Did you try on a server node? You can reinstall all packages including export with the following command on a database node as dbadmin:
admintools -t install_package -d dbname -p dbpassword -P all --force-reinstall

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 7, 2023

I tried on the served node and got the same error. I tried your command and see that:

Installing package AWS...
Failed to install package AWS
Installing package MachineLearning...
Failed to install package MachineLearning
Installing package ParquetExport...
Failed to install package ParquetExport
Installing package VFunctions...
Failed to install package VFunctions
Installing package approximate...
Failed to install package approximate
Installing package flextable...
Failed to install package flextable
Package hcat is not allowed to be force-installed...Skip
Installing package logsearch...
Failed to install package logsearch
Installing package place...
Failed to install package place
Installing package txtindex...
Failed to install package txtindex

so none of the packages is able to be installed

SruthiA
Participating Frequently
Forum|Forum|2 years ago
November 7, 2023

could you please share install.log?

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 7, 2023

@SruthiA said:
could you please share install.log?

Part of it:

2023-01-31 14:30:01: (install_vertica_verify_libraries) locale command produced no recognized error messages
2023-01-31 14:30:01: (install_vertica_verify_libraries) /proc/sys/crypto/fips_enabled does not exist
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /lib
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /lib64
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /usr/lib
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /usr/lib64
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /lib/x86_64-linux-gnu
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /lib/i386-linux-gnu
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /usr/lib/x86_64-linux-gnu
2023-01-31 14:30:01: (install_vertica_verify_libraries) versions_with_matching_libssl called with no args
2023-01-31 14:30:01: (install_vertica_verify_libraries) no candidate list for /usr/lib/i386-linux-gnu
2023-01-31 14:30:01: (install_vertica_verify_libraries) extract_version called with no arguments
2023-01-31 14:30:01: (install_vertica_verify_libraries) Cannot find the libcrypto directory; using the RPM version
2023-01-31 14:30:02: (install_vertica_verify_libraries) Vertica starts up okay
2023-01-31 14:30:04.246 installer/1:0x7f6a94b53100 [root.setup_custom_logging] New log for 'installer'
2023-01-31 14:30:04.248 installer/1:0x7f6a94b53100 [root.setup_custom_logging] sys.argv: '/opt/vertica/share/eggs/vertica/install/main.py' --license CE --accept-eula --hosts '127.0.0.1' --dba-user-password-disabled --failure-threshold NONE --no-system-configuration
2023-01-31 14:30:04.249 installer/1:0x7f6a94b53100 [OpSys._version_helper] Found /etc/debian_version
2023-01-31 14:30:04.250 installer/1:0x7f6a94b53100 [OpSys._version_helper] release string = 'jessie bullseye/sid'
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData.load] Picked default URL
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData.load] Getting metadata from URL: http://169.254.169.254/latest/meta-data/
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData._detect_vm_from_cpuinfo] Checking to see if we are in a vm at all
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData._detect_vm_from_cpuinfo] Detected hypervisor in cpuinfo
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData._check_connection] Looking for AWS metadata at url http://169.254.169.254/latest/meta-data/
2023-01-31 14:30:04.252 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/
2023-01-31 14:30:04.257 installer/1:0x7f6a94b53100 [AWSMetaData._check_connection] Found AWS metadata connection
2023-01-31 14:30:04.257 installer/1:0x7f6a94b53100 [AWSMetaData._get_instance_type] Getting instance-type meta data
2023-01-31 14:30:04.257 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/instance-type
2023-01-31 14:30:04.259 installer/1:0x7f6a94b53100 [AWSMetaData._get_instance_type] Found instance type t3.micro
2023-01-31 14:30:04.259 installer/1:0x7f6a94b53100 [AWSMetaData._get_availability_zone] Getting availability zone meta data
2023-01-31 14:30:04.259 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/placement/availability-zone/
2023-01-31 14:30:04.260 installer/1:0x7f6a94b53100 [AWSMetaData._get_security_group] Getting security group
2023-01-31 14:30:04.260 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/security-groups
2023-01-31 14:30:04.262 installer/1:0x7f6a94b53100 [AWSMetaData._get_macs] Getting network info
2023-01-31 14:30:04.262 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/network/interfaces/macs/
2023-01-31 14:30:04.268 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/network/interfaces/macs/0a:1a:f5:ef:fd:17/subnet-id
2023-01-31 14:30:04.269 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/network/interfaces/macs/0a:1a:f5:ef:fd:17/vpc-id
2023-01-31 14:30:04.271 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Fetching from http://169.254.169.254/latest/meta-data/product-codes
2023-01-31 14:30:04.272 installer/1:0x7f6a94b53100 [AWSMetaData._fetch_metadata] Could not get information from url http://169.254.169.254/latest/meta-data/product-codes
Message: HTTP Error 404: Not Found
2023-01-31 14:30:04.272 installer/1:0x7f6a94b53100 [AWSMetaData._log_summary] AWS metadata detection summary:
is_aws = True
instance_type = t3.micro
availability_zone = us-west-2c
security_group = docker
bastion.rm
default
dev
macs = ['0a:1a:f5:ef:fd:17']
network_infos = MAC 0a:1a:f5:ef:fd:17 Info VPC = vpc-8d3686e8 Subnet = subnet-19b97540
product_codes = []

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 7, 2023

@SruthiA said:
could you please share install.log?

Bryan_H
Participating Frequently
Forum|Forum|2 years ago
November 8, 2023

Those events are a bit too old to be related. Please check "admintools.log" for recent messages and any errors related to package install. You may need to run the command again so the package install will be the most recent log entry.

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 8, 2023

@Bryan_H said:
Those events are a bit too old to be related. Please check "admintools.log" for recent messages and any errors related to package install. You may need to run the command again so the package install will be the most recent log entry.

Pexpect state: matched pattern 2
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue prior to split: 'Vertica Analytic Database v9.2.0-0\r\nALTER SESSION\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done\r\nCREATE SCHEMA\r\nALTER SESSION\r\nGRANT PRIVILEGE\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn\'t create new UDx side process, failed to get UDx side process info from zygote: Broken pipe\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)\r\nHINT: No function matches the given name and argument types. You may need to add explicit type casts\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)\r\nHINT: No function matches the given name and argument types. You may need to add explicit type casts\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams\r\n'
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue after split: ['Vertica Analytic Database v9.2.0-0', 'ALTER SESSION', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done', 'CREATE SCHEMA', 'ALTER SESSION', 'GRANT PRIVILEGE', "vsql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe", 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)', 'HINT: No function matches the given name and argument types. You may need to add explicit type casts', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)', 'HINT: No function matches the given name and argument types. You may need to add explicit type casts', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams', '']
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] Parsing response with offset = 0
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [adminExec.manageExtensionPackage] Package txtindex management script ddl/install.sql returncode 0
Output:
Vertica Analytic Database v9.2.0-0
ALTER SESSION
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done
CREATE SCHEMA

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 8, 2023

@lvehbiu said:

@Bryan_H said:
Those events are a bit too old to be related. Please check "admintools.log" for recent messages and any errors related to package install. You may need to run the command again so the package install will be the most recent log entry.

sql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams
2023-11-08 08:25:10.374 admintools/15827:0x7f8714e28100 [vsql.executeSql] Sending query \i /opt/vertica/packages/txtindex/ddl/isinstalled.sql to pexpect.
2023-11-08 08:25:10.474 admintools/15827:0x7f8714e28100 [vsql.executeSql] Query size = 90, bytes sent: 91, timeout=None
2023-11-08 08:25:10.474 admintools/15827:0x7f8714e28100 [vsql.executeSql] Pexpect state: before Vertica Analytic Database v9.2.0-0
ALTER SESSION
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done
CREATE SCHEMA
ALTER SESSION
GRANT PRIVILEGE
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams
after datamart=>
2023-11-08 08:25:10.482 admintools/15827:0x7f8714e28100 [vsql.executeSql] Pexpect state: matched pattern 2
2023-11-08 08:25:10.482 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue prior to split: 'f\r\n'
2023-11-08 08:25:10.482 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue after split: ['f', '']
2023-11-08 08:25:10.482 admintools/15827:0x7f8714e28100 [vsql.executeSql] Parsing response with offset = 0
2023-11-08 08:25:10.482 admintools/15827:0x7f8714e28100 [adminExec.manageExtensionPackage] Package txtindex management script ddl/isinstalled.sql returncode 0
Output:

Pexpect state: matched pattern 2
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue prior to split: 'Vertica Analytic Database v9.2.0-0\r\nALTER SESSION\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done\r\nCREATE SCHEMA\r\nALTER SESSION\r\nGRANT PRIVILEGE\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn\'t create new UDx side process, failed to get UDx side process info from zygote: Broken pipe\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)\r\nHINT: No function matches the given name and argument types. You may need to add explicit type casts\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)\r\nHINT: No function matches the given name and argument types. You may need to add explicit type casts\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib\r\nvsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams\r\n'
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] returnValue after split: ['Vertica Analytic Database v9.2.0-0', 'ALTER SESSION', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done', 'CREATE SCHEMA', 'ALTER SESSION', 'GRANT PRIVILEGE', "vsql:/opt/vertica/packages/txtindex/ddl/install.sql:11: ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: Broken pipe", 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:13: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:14: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseSensitive', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:16: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)', 'HINT: No function matches the given name and argument types. You may need to add explicit type casts', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:17: ROLLBACK 2059: Function with specified name and parameters does not exist: StemmerCaseInsensitive', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:19: ROLLBACK 3457: Function v_txtindex.StemmerCaseSensitive(long varchar) does not exist, or permission is denied for v_txtindex.StemmerCaseSensitive(long varchar)', 'HINT: No function matches the given name and argument types. You may need to add explicit type casts', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:20: ROLLBACK 2059: Function with specified name and parameters does not exist: Stemmer', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:22: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizer', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:25: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:26: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: StringTokenizerDelim', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:28: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:29: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: TwoGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:31: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:32: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: ThreeGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:34: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:35: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FourGrams', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:37: ROLLBACK 3861: Library not found: v_txtindex.TxtIndexLib', 'vsql:/opt/vertica/packages/txtindex/ddl/install.sql:38: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: FiveGrams', '']
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [vsql.executeSql] Parsing response with offset = 0
2023-11-08 08:25:10.373 admintools/15827:0x7f8714e28100 [adminExec.manageExtensionPackage] Package txtindex management script ddl/install.sql returncode 0
Output:
Vertica Analytic Database v9.2.0-0
ALTER SESSION
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650: Schema "TxtIndex" does not exist
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214: Object "v_txtindex" already exists; nothing was done
CREATE SCHEMA

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 8, 2023

I think no packages can be installe not jut the ParquetExport

SruthiA
Participating Frequently
Forum|Forum|2 years ago
November 8, 2023

Could you please open a support case as it requires webex to review what is going on.

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 9, 2023

@SruthiA said:
Could you please open a support case as it requires webex to review what is going on.

Do I need to have an enterprise account to be able to open support cases?

VValdar
Participating Frequently
Forum|Forum|2 years ago
November 9, 2023

Yes of course, and a on-going support contract as well, unless you're using a Community Edition where official support is not embedded.
9.2 is a five years old version, you may want to upgrade it.

lvehbiu
Author
Participating Frequently
Forum|Forum|2 years ago
November 9, 2023

@VValdar said:
Yes of course, and a on-going support contract as well, unless you're using a Community Edition where official support is not embedded.
9.2 is a five years old version, you may want to upgrade it.

Thank you. Is there any support for transitioning from a Community Edition version? Need a bit of help as I am stuck with this version. My company would gladly switch to a new paid version. Currently only one node suffices for all our work and we self host vertica on a k8 cluster inside AWS.

Sign up

Please log in or register:

Welcome to the Rocket Forum!

Please log in or register: