[MDEV-13924] CONNECT engine table_type=JDBC very broken on 10.1.27 hangs SUSPECT POOLING Created: 2017-09-27  Updated: 2018-01-24  Resolved: 2017-10-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.1.27
Fix Version/s: 10.0.33, 10.1.29, 10.2.10

Type: Bug Priority: Critical
Reporter: Robert Dyas Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: None
Environment:

centos7



 Description   

I just upgraded from 10.1.26 (very stable) to 10.1.27 and CONNECT with JDBC table types is now hanging The first few requests work, but then it hangs. Suspect this is somehow related to pooling (ApacheWrapper) since recreating the tables without pooling seems to eliminate the error.

With pooling ON it seems to hang after maybe 8 to 10 queries. No error, just never returns. This would seem to correspond roughly to the default number of connections in the Apache pool. So suspect connections are no longer being free'ed aka closed.

Non-connect tables CAN be queried.

When I turn OFF pooling for the tables - i.e. recreate them without using the ApacheWrapper the system does not appear to hang (50 queries and still ok). So my wild guess is that something changed with how ApacheWrapper works, or possibly since the connections need to go back in the pool, maybe the connections in 10.1.27 are not getting a connection.close() or something.



 Comments   
Comment by Olivier Bertrand [ 2017-09-27 ]

Version 10.1.27 was recalled because of regression errors. Stay with MariaDB 10.1.26 until 10.1.28 is released.

Comment by Olivier Bertrand [ 2017-10-03 ]

Indeed, this is a regression bug. Thanks for reporting, it will be fixed asap.

Comment by Olivier Bertrand [ 2017-10-11 ]

Will be fixed later for 10.2 and 10.3 because of other pending changes.
Done.

Generated at Thu Feb 08 08:09:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.