Hey there,
Hopefully someone can point me in the right direction or knows the answer. I'm using a recreation of the sample MSDN SessionStateStore provider which is designed for MSSQL server.
This one was done by Harry Kimpel.
The particular issue I am having is with the "CreateUninitializedItem" routine. Basicaly the error I get often is:
ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Duplicate entry '1fd3ph2xfkvlnz55ozveoy55-/' for key 1
I realise that the System.Web.SessionState.SessionStateModule does not realise that the session id already exists in the database. I have read on some websites (assuming I am on track) is that maybe the application is recycling and hence requiring a new session id.
I don't think that this is 100% the case here. What I think is that a preceding routine that "looks" for a particualr session id or lock variable etc is not getting what is expected.
I can't find any information of the flow of routines which come to this point so I don't know where to look for this bug/error.
The provider code I am using is HERE
Hopefully someone may know the solution or maybe we can solve it by trial and error.