search

OpenLiberty / open-liberty

Open Liberty is a highly composable, fast to start, dynamic application server runtime environment
https://openliberty.io
Eclipse Public License 2.0
1.15k stars 588 forks source link

Improve testing 2pc against SQLServer #10835

Open KyleAure opened 4 years ago

KyleAure commented 4 years ago

Two of our tests in the jdbc_fat are skipped when running against SQLServer:

https://github.com/OpenLiberty/open-liberty/blob/6d409ba92cad78ce82455ad3d3b6acbb661b2ced/dev/com.ibm.ws.jdbc_fat/fat/src/com/ibm/ws/jdbc/fat/tests/DataSourceTest.java#L192-L198

https://github.com/OpenLiberty/open-liberty/blob/6d409ba92cad78ce82455ad3d3b6acbb661b2ced/dev/com.ibm.ws.jdbc_fat/fat/src/com/ibm/ws/jdbc/fat/tests/DataSourceTest.java#L288-L294

Both of these tests involve using XA datasources and 2pc against a SQLServer back end database. These test's fail due to what seems like a bug in the SQLServer docker image. Execution of a stored procedure hangs indefinitely.

An issue has been raised with Microsoft to get help with this issue here: https://github.com/microsoft/mssql-docker/issues/554

And in case something has been configured wrong I have also asked this question on SO: https://stackoverflow.com/questions/60174070/sqlserver-hung-on-using-xplog70-dll-version-xxx-to-execute-extended-stored-p

Once a resolution with the config or container has been achieved we can re-enable these tests.

KyleAure commented 4 years ago

Perhaps a solution to this may be to create a connection, and execute the stored procedure a little later in the setup process after the database has fully been initialized. Maybe the startup script is running a bit too early and some resources are not available.