Forum Discussion
jwight1464
Nimbostratus
NimbostratusTCP Universal Persistence not saving
We are currently working on a MS SQL server persistence iRule that will read the TCP::payload for a certain SQL parameter that we are passing and save the value in the uie table for persistence looku...
I think part of the problem here is you are setting a persist entry before the LTM has made a LB choice. The LTM is accepting the connection and doing a data collect on the third packet, it is then using the data from the third packet to make the persist setting but at this time there is no selected pool member for the persist to happen on. The next client data though should have a connection built and when the persist command is run you should get a result back.
if you look through the MySql Proxy iRule
https://devcentral.f5.com/wiki/iRules.MySQL-Proxy.ashx
You can see the persist statement is not called till the session has been auth.
A way around what you are doing would be to peform the persist in LB_SELECTED and set persistence there.
Again I could be wrong but with the info I see, I think this is a good starting point to look at the problem. Thanks
