[ODBCLoader] SQLDisconnect() failed with error code HY010

[h-serizawa]

When I tried to copy the remote Vertica database, I hit the following error:

2022-03-09 11:06:46.758 Init Session:0x7f1c21ffb700-a0000000011823 <ERROR> @v_trial_node0001: VP001/3399: Failure in UDx RPC call InvokeDestroyUDL(): Error calling destroyUDL() in User Defined Object [ODBCLoader] at [ODBCLoader.cpp:250], error code: 0, message: ODBC Error: SQLDisconnect() failed with error code HY010, native code 0 [[unixODBC][Driver Manager]Function sequence error]
        LOCATION:  makeUDxRemoteProcedureCallHandlingErrors, /data/jenkins/workspace/RE-ReleaseBuilds/RE-Jackhammer/server/vertica/EE/EEUtil/UDxFenceSupport.cpp:574

The trace messages were as below:

[ODBC][116506][1646900363.989931][SQLDisconnect.c][208]
                Entry:
                        Connection = 0x7fc2e4008570
[ODBC][116506][1646900363.990464][SQLDisconnect.c][379]
                Exit:[SQL_ERROR]
                DIAG [25000] [Vertica][ODBC] (11120) Outstanding transactions during disconnect.

[ODBC][116506][1646900363.990571][SQLFreeHandle.c][290]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x7fc2e4008570
[ODBC][116506][1646900363.990581][SQLFreeHandle.c][304]Error: HY010
[ODBC][116506][1646900363.990606][SQLFreeHandle.c][220]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x7fc2e4007f70
[ODBC][116506][1646900363.990644][SQLFreeHandle.c][234]Error: HY010
[ODBC][116506][1646900363.990667][SQLGetDiagRec.c][677]
                Entry:
                        Connection = 0x7fc2e4008570
                        Rec Number = 1
                        SQLState = 0x7fc2f2c852a2
                        Native = 0x7fc2f2c8529c
                        Message Text = 0x7fc2f2c84e90
                        Buffer Length = 1024
                        Text Len Ptr = 0x7fc2f2c8529a
[ODBC][116506][1646900363.990692][SQLGetDiagRec.c][726]
                Exit:[SQL_SUCCESS]
                        SQLState = HY010
                        Native = 0x7fc2f2c8529c -> 0
                        Message Text = [[unixODBC][Driver Manager]Function sequence error]

[h-serizawa]

The cause is no commit/rollback is called before calling SQLDisconnect. I will work on it.

[h-serizawa]

The issue happens if auto-commit is disabled.

[blackeyepanda]

Hello could you please open the issue at https://github.com/vertica/ODBC-Loader. We are going to deprecate this repo and use a separate repo for ODBC-Loader, I am working on adding some tests and Continuous integration for that as well. Thanks

[h-serizawa]

@blackeyepanda
Thank you for your update. I got it. I will try the same test to see if the issue still happens.
BTW, can you add some notes in README regarding the deprecation? I'm also talking about another issue in issue #35. We will need to make sure all users use the source codes in the new repository.

[h-serizawa]

Close this issue since we are moving to new repository.