Message-ID: From: "RamaTripathi (@RamaTripathi)" To: "postgresql-interfaces/psqlodbc" Date: Wed, 17 Jun 2026 07:56:21 +0000 Subject: Re: [postgresql-interfaces/psqlodbc] issue #191: catalogfunctions test exits with code 1 (no output) with UseServerSidePrepare=0 + Protocol=7.4-1 on EL10 / Rocky Linux 10 In-Reply-To: References: List-Id: X-GitHub-Author-Login: RamaTripathi X-GitHub-Comment-Id: 4727448079 X-GitHub-Comment-Type: issue_comment X-GitHub-Edited-At: 2026-06-17T08:03:37Z X-GitHub-Issue: 191 X-GitHub-Repo: postgresql-interfaces/psqlodbc X-GitHub-Type: comment X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/191#issuecomment-4727448079 Content-Type: text/plain; charset=utf-8 Hi @davecramer Thanks for the response. This issue occurs when we run the install check for psqlodbc after compiling the source code of psqlodbc on Rocky10 linux. make installcheck-all -C source/psqlodbc-REL-18_00_0001/test Below are the logs 2026-06-06T18:12:50.6037801Z rm -f odbc.ini odbcinst.ini 2026-06-06T18:12:50.6068031Z make installcheck odbc_ini_extras="UseDeclareFetch=0 UseServerSidePrepare=0 Protocol=7.4-1" 2026-06-06T18:12:50.6198120Z make[1]: Entering directory '/home/postgres/source/psqlodbc-REL-18_00_0001/test' 2026-06-06T18:12:50.6200175Z ./odbcini-gen.sh UseDeclareFetch=0 UseServerSidePrepare=0 Protocol=7.4-1 2026-06-06T18:12:50.6216140Z creating odbcinst.ini 2026-06-06T18:12:50.6255038Z creating odbc.ini: UseDeclareFetch=0 UseServerSidePrepare=0 Protocol=7.4-1 2026-06-06T18:12:50.6374296Z rm -f regression.diffs 2026-06-06T18:12:50.6445434Z ODBCSYSINI=. ODBCINSTINI=./odbcinst.ini ODBCINI=./odbc.ini ./reset-db < ./sampletables.sql 2026-06-06T18:12:50.6719061Z connected to DSN=psqlodbc_test_dsn;Database=postgres 2026-06-06T18:12:50.6720650Z Dropping and creating database contrib_regression... 2026-06-06T18:12:50.8024732Z connected to DSN=psqlodbc_test_dsn;Database=contrib_regression 2026-06-06T18:12:50.8028165Z Running initialization script... 2026-06-06T18:12:50.8871487Z Done! 2026-06-06T18:12:50.8901039Z prove -e ./runsuite connect stmthandles select update commands multistmt getresult colattribute result-conversions prepare premature params param-conversions parse identity notice arraybinding insertreturning dataatexecution boolsaschar cvtnulldate alter async-enable quotes cursors cursor-movement cursor-scrollable cursor-commit cursor-name cursor-block-delete bookmark declare-fetch-commit declare-fetch-block positioned-update bulkoperations catalogfunctions bindcol lfconversion cte errors error-rollback diagnostic numeric large-object large-object-data-at-exec odbc-escapes odbc-conformance wchar-char params-batch-exec fetch-refcursors descrec :: --inputdir=. 2026-06-06T18:12:51.0467954Z connect .................... 2026-06-06T18:12:51.0469158Z connect .................... 1/? 2026-06-06T18:12:51.0470165Z 2026-06-06T18:12:51.0471847Z connect .................... ok 2026-06-06T18:12:51.0940325Z stmthandles ................ 2026-06-06T18:12:51.0941983Z stmthandles ................ 1/? 2026-06-06T18:12:51.0943038Z 2026-06-06T18:12:51.0944492Z stmthandles ................ ok 2026-06-06T18:12:51.1383857Z select ..................... 2026-06-06T18:12:51.1385069Z select ..................... 1/? 2026-06-06T18:12:51.1386394Z 2026-06-06T18:12:51.1388079Z select ..................... ok 2026-06-06T18:12:51.1854154Z update ..................... 2026-06-06T18:12:51.1857209Z update ..................... 1/? 2026-06-06T18:12:51.1858213Z 2026-06-06T18:12:51.1859495Z update ..................... ok 2026-06-06T18:12:51.2379691Z commands ................... 2026-06-06T18:12:51.2381357Z commands ................... 1/? 2026-06-06T18:12:51.2382797Z 2026-06-06T18:12:51.2384491Z commands ................... ok 2026-06-06T18:12:51.2830856Z multistmt .................. 2026-06-06T18:12:51.2833771Z multistmt .................. 1/? 2026-06-06T18:12:51.2834850Z 2026-06-06T18:12:51.2836465Z multistmt .................. ok 2026-06-06T18:12:51.3236556Z getresult .................. 2026-06-06T18:12:51.3237792Z getresult .................. 1/? 2026-06-06T18:12:51.3238779Z 2026-06-06T18:12:51.3239956Z getresult .................. ok 2026-06-06T18:12:51.3841149Z colattribute ............... 2026-06-06T18:12:51.3843021Z colattribute ............... 1/? 2026-06-06T18:12:51.3844004Z 2026-06-06T18:12:51.3845555Z colattribute ............... ok 2026-06-06T18:12:51.4908621Z result-conversions ......... 2026-06-06T18:12:51.4909891Z result-conversions ......... 1/? 2026-06-06T18:12:51.4910883Z 2026-06-06T18:12:51.4912078Z result-conversions ......... ok 2026-06-06T18:12:51.5672014Z prepare .................... 2026-06-06T18:12:51.5673251Z prepare .................... 1/? 2026-06-06T18:12:51.5674316Z 2026-06-06T18:12:51.5676299Z prepare .................... ok 2026-06-06T18:12:51.6159140Z premature .................. 2026-06-06T18:12:51.6160893Z premature .................. 1/? 2026-06-06T18:12:51.6162408Z 2026-06-06T18:12:51.6163617Z premature .................. ok 2026-06-06T18:12:51.6620124Z params ..................... 2026-06-06T18:12:51.6621638Z params ..................... 1/? 2026-06-06T18:12:51.6622638Z 2026-06-06T18:12:51.6623839Z params ..................... ok 2026-06-06T18:12:51.7037372Z param-conversions .......... 2026-06-06T18:12:51.7038736Z param-conversions .......... 1/? 2026-06-06T18:12:51.7039789Z 2026-06-06T18:12:51.7041641Z param-conversions .......... ok 2026-06-06T18:12:51.7514805Z parse ...................... 2026-06-06T18:12:51.7516401Z parse ...................... 1/? 2026-06-06T18:12:51.7518323Z 2026-06-06T18:12:51.7519566Z parse ...................... ok 2026-06-06T18:12:51.8175895Z identity ................... 2026-06-06T18:12:51.8176468Z identity ................... 1/? 2026-06-06T18:12:51.8176858Z 2026-06-06T18:12:51.8177313Z identity ................... ok 2026-06-06T18:12:51.8586247Z notice ..................... 2026-06-06T18:12:51.8587757Z notice ..................... 1/? 2026-06-06T18:12:51.8588757Z 2026-06-06T18:12:51.8589975Z notice ..................... ok 2026-06-06T18:12:52.0398324Z arraybinding ............... 2026-06-06T18:12:52.0399587Z arraybinding ............... 1/? 2026-06-06T18:12:52.0400565Z 2026-06-06T18:12:52.0401767Z arraybinding ............... ok 2026-06-06T18:12:52.1658134Z insertreturning ............ 2026-06-06T18:12:52.1659436Z insertreturning ............ 1/? 2026-06-06T18:12:52.1660963Z 2026-06-06T18:12:52.1662368Z insertreturning ............ ok 2026-06-06T18:12:52.2074229Z dataatexecution ............ 2026-06-06T18:12:52.2074778Z dataatexecution ............ 1/? 2026-06-06T18:12:52.2075308Z 2026-06-06T18:12:52.2075766Z dataatexecution ............ ok 2026-06-06T18:12:52.2549094Z boolsaschar ................ 2026-06-06T18:12:52.2550365Z boolsaschar ................ 1/? 2026-06-06T18:12:52.2551361Z 2026-06-06T18:12:52.2552549Z boolsaschar ................ ok 2026-06-06T18:12:52.2997343Z cvtnulldate ................ 2026-06-06T18:12:52.3000211Z cvtnulldate ................ 1/? 2026-06-06T18:12:52.3001390Z 2026-06-06T18:12:52.3003059Z cvtnulldate ................ ok 2026-06-06T18:12:52.3478231Z alter ...................... 2026-06-06T18:12:52.3479537Z alter ...................... 1/? 2026-06-06T18:12:52.3480728Z 2026-06-06T18:12:52.3482056Z alter ...................... ok 2026-06-06T18:12:52.3870589Z async-enable ............... 2026-06-06T18:12:52.3872424Z async-enable ............... 1/? 2026-06-06T18:12:52.3873893Z 2026-06-06T18:12:52.4247435Z async-enable ............... ok 2026-06-06T18:12:52.4248854Z quotes ..................... 2026-06-06T18:12:52.4249871Z quotes ..................... 1/? 2026-06-06T18:12:52.4250820Z 2026-06-06T18:12:52.4252282Z quotes ..................... ok 2026-06-06T18:12:52.4695717Z cursors .................... 2026-06-06T18:12:52.4697089Z cursors .................... 1/? 2026-06-06T18:12:52.4698080Z 2026-06-06T18:12:52.4699253Z cursors .................... ok 2026-06-06T18:12:52.5109192Z cursor-movement ............ 2026-06-06T18:12:52.5110675Z cursor-movement ............ 1/? 2026-06-06T18:12:52.5111859Z 2026-06-06T18:12:52.5113340Z cursor-movement ............ ok 2026-06-06T18:12:52.5497009Z cursor-scrollable .......... 2026-06-06T18:12:52.5498272Z cursor-scrollable .......... 1/? 2026-06-06T18:12:52.5499267Z 2026-06-06T18:12:52.5500448Z cursor-scrollable .......... ok 2026-06-06T18:12:52.5917456Z cursor-commit .............. 2026-06-06T18:12:52.5918834Z cursor-commit .............. 1/? 2026-06-06T18:12:52.5919817Z 2026-06-06T18:12:52.5921036Z cursor-commit .............. ok 2026-06-06T18:12:52.6379345Z cursor-name ................ 2026-06-06T18:12:52.6380598Z cursor-name ................ 1/? 2026-06-06T18:12:52.6381561Z 2026-06-06T18:12:52.6382737Z cursor-name ................ ok 2026-06-06T18:12:52.8516279Z cursor-block-delete ........ 2026-06-06T18:12:52.8517573Z cursor-block-delete ........ 1/? 2026-06-06T18:12:52.8519423Z 2026-06-06T18:12:52.8520683Z cursor-block-delete ........ ok 2026-06-06T18:12:52.8916554Z bookmark ................... 2026-06-06T18:12:52.8917790Z bookmark ................... 1/? 2026-06-06T18:12:52.8918770Z 2026-06-06T18:12:52.8919960Z bookmark ................... ok 2026-06-06T18:12:52.9319676Z declare-fetch-commit ....... 2026-06-06T18:12:52.9322235Z declare-fetch-commit ....... 1/? 2026-06-06T18:12:52.9323466Z 2026-06-06T18:12:52.9325866Z declare-fetch-commit ....... ok 2026-06-06T18:12:52.9963665Z declare-fetch-block ........ 2026-06-06T18:12:52.9965014Z declare-fetch-block ........ 1/? 2026-06-06T18:12:52.9966440Z 2026-06-06T18:12:52.9967692Z declare-fetch-block ........ ok 2026-06-06T18:12:53.0602436Z positioned-update .......... 2026-06-06T18:12:53.0603706Z positioned-update .......... 1/? 2026-06-06T18:12:53.0604805Z 2026-06-06T18:12:53.0606382Z positioned-update .......... ok 2026-06-06T18:12:53.1126298Z bulkoperations ............. 2026-06-06T18:12:53.1127574Z bulkoperations ............. 1/? 2026-06-06T18:12:53.1128564Z 2026-06-06T18:12:53.1129755Z bulkoperations ............. ok 2026-06-06T18:12:53.2500544Z catalogfunctions ...........  2026-06-06T18:12:53.2503021Z catalogfunctions ........... 1/?  2026-06-06T18:12:53.2504342Z  2026-06-06T18:12:53.2506820Z catalogfunctions ........... Dubious, test returned 1 (wstat 256, 0x100) 2026-06-06T18:12:53.2508537Z Failed 1/1 subtests  2026-06-06T18:12:53.2922591Z bindcol .................... 2026-06-06T18:12:53.2923769Z bindcol .................... 1/? 2026-06-06T18:12:53.2925500Z 2026-06-06T18:12:53.2927205Z bindcol .................... ok 2026-06-06T18:12:53.3290476Z lfconversion ............... 2026-06-06T18:12:53.3291707Z lfconversion ............... 1/? 2026-06-06T18:12:53.3292671Z 2026-06-06T18:12:53.3293825Z lfconversion ............... ok 2026-06-06T18:12:53.3781149Z cte ........................ 2026-06-06T18:12:53.3782356Z cte ........................ 1/? 2026-06-06T18:12:53.3783320Z 2026-06-06T18:12:53.3784474Z cte ........................ ok 2026-06-06T18:12:53.4185720Z errors ..................... 2026-06-06T18:12:53.4186928Z errors ..................... 1/? 2026-06-06T18:12:53.4187895Z 2026-06-06T18:12:53.4189061Z errors ..................... ok 2026-06-06T18:12:53.4879098Z error-rollback ............. 2026-06-06T18:12:53.4879892Z error-rollback ............. 1/? 2026-06-06T18:12:53.4880565Z 2026-06-06T18:12:53.4880565Z 2026-06-06T18:12:53.4881344Z error-rollback ............. ok 2026-06-06T18:12:53.5304746Z diagnostic ................. 2026-06-06T18:12:53.5306186Z diagnostic ................. 1/? 2026-06-06T18:12:53.5307063Z 2026-06-06T18:12:53.5308129Z diagnostic ................. ok 2026-06-06T18:12:53.5717084Z numeric .................... 2026-06-06T18:12:53.5718298Z numeric .................... 1/? 2026-06-06T18:12:53.5719268Z 2026-06-06T18:12:53.5720424Z numeric .................... ok 2026-06-06T18:12:53.6206304Z large-object ............... 2026-06-06T18:12:53.6206819Z large-object ............... 1/? 2026-06-06T18:12:53.6207142Z 2026-06-06T18:12:53.6207536Z large-object ............... ok 2026-06-06T18:12:53.6694363Z large-object-data-at-exec .. 2026-06-06T18:12:53.6696777Z large-object-data-at-exec .. 1/? 2026-06-06T18:12:53.6697911Z 2026-06-06T18:12:53.6699317Z large-object-data-at-exec .. ok 2026-06-06T18:12:53.7173082Z odbc-escapes ............... 2026-06-06T18:12:53.7174366Z odbc-escapes ............... 1/? 2026-06-06T18:12:53.7175873Z 2026-06-06T18:12:53.7177115Z odbc-escapes ............... ok 2026-06-06T18:12:53.7503974Z odbc-conformance ........... 2026-06-06T18:12:53.7505620Z odbc-conformance ........... 1/? 2026-06-06T18:12:53.7506654Z 2026-06-06T18:12:53.7507863Z odbc-conformance ........... ok 2026-06-06T18:12:53.7874386Z wchar-char ................. 2026-06-06T18:12:53.7876000Z wchar-char ................. 1/? 2026-06-06T18:12:53.7876997Z 2026-06-06T18:12:53.7878175Z wchar-char ................. ok 2026-06-06T18:12:53.8462264Z params-batch-exec .......... 2026-06-06T18:12:53.8463612Z params-batch-exec .......... 1/? 2026-06-06T18:12:53.8466565Z 2026-06-06T18:12:53.8467860Z params-batch-exec .......... ok 2026-06-06T18:12:53.9695727Z fetch-refcursors ........... 2026-06-06T18:12:53.9697167Z fetch-refcursors ........... 1/? 2026-06-06T18:12:53.9698176Z 2026-06-06T18:12:53.9699409Z fetch-refcursors ........... ok 2026-06-06T18:12:54.0149443Z descrec .................... 2026-06-06T18:12:54.0150682Z descrec .................... 1/? 2026-06-06T18:12:54.0151659Z 2026-06-06T18:12:54.0152875Z descrec .................... ok 2026-06-06T18:12:54.0157409Z  2026-06-06T18:12:54.0158218Z Test Summary Report 2026-06-06T18:12:54.0160212Z ------------------- 2026-06-06T18:12:54.0162364Z catalogfunctions (Wstat: 256 (exited 1) Tests: 1 Failed: 1) 2026-06-06T18:12:54.0164450Z  Failed test: 1 2026-06-06T18:12:54.0166072Z  Non-zero exit status: 1 2026-06-06T18:12:54.0167962Z Files=51, Tests=51, 4 wallclock secs ( 0.25 usr 0.16 sys + 0.61 cusr 0.91 csys = 1.93 CPU) 2026-06-06T18:12:54.0169614Z Result: FAIL 2026-06-06T18:12:54.0233744Z make[1]: *** [Makefile:33: installcheck] Error 1 2026-06-06T18:12:54.0235925Z make[1]: Leaving directory '/home/postgres/source/psqlodbc-REL-18_00_0001/test' 2026-06-06T18:12:54.0238279Z make: *** [Makefile:71: installcheck-all] Error 2 2026-06-06T18:12:54.0239897Z make: Leaving directory '/home/postgres/source/psqlodbc-REL-18_00_0001/test'