This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out.
Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved.
Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement.
Terms of Use |
Privacy Policy |
Trademarks |
Patents |
Contact Us
Additional aspects that must be considered while implementing the IDEA.
The Hyperscale HA will dynamically drop and create instances of the read-only replicas.
The issue with this methodology is that the TDV data source adapter and driver do not gracefully recognize when a replica goes away as the connection in TDV is still being held. What shows up in TDV is 08S01 which gets sent back to the client.
Making use of the "Microsoft SQL Server 2019" adapter and driver because there is no full support for Azure SQL DB and the HA capabilities.
What we would like to happen is for the adapter to gracefully handle the 08S01 connection is closed or connection is reset at the adapter level. It should close that connection and remove it from the connection pool so that other connections do not attempt to reuse it.
Even better would be for TDV to drop the connection out of the pool and retry with a new connection to Hyperscale so that Hyperscale can route to the new replica.
Currently, Hyperscale HA routes to a replica, and TDV will be holding a direct connection to that replica. Now Hyperscale destroys that replica and creates a new one but TDV does not know about the new one and still thinks the old one is viable. TDV does not remove that connection from the pool.
Once 08S01 errors start they keep happening because the connection is never released from the TDV connection pool.