-
15. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
rareddy Jul 31, 2013 7:55 AM (in response to m.ardito)Originally treated "closeBoundStatement" "closePrepareStatement" as same, that a was a mistake
-
16. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Jul 31, 2013 10:29 AM (in response to rareddy)Ramesh to clarify in closeBoundStatement there is the autoCommit check and a call to closePreparedStatement with the comment about http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1007690&group_id=1000125
Are you now saying that is not correct?
Steve
-
17. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
rareddy Jul 31, 2013 11:21 AM (in response to shawkins)I think that is the issue.
But I remember during tests at that time, i never seen a "closePrepareStmt" call from client, just the "closeBoundStatement" call, thus the way it was coded. Now I am not sure if that is fixed in > 9 version of the PG driver or not and how we are going to support older drivers. Trying to think how the link in the comment is relevent?
-
18. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Jul 31, 2013 11:34 AM (in response to rareddy)If you think that trying with a newer pg odbc driver from here http://www.postgresql.org/ftp/odbc/versions/msi/ would be useful, let me know.
Would that give you more info or hints?
Marco
-
19. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Jul 31, 2013 11:41 AM (in response to m.ardito)Using the older one is probably better. We should have enough to go on for now and will have a better baseline for you with 8.5 Beta1.
Steve
-
20. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Jul 31, 2013 1:54 PM (in response to rareddy)Ramesh,
I'll open a new issue for this. You are correct that the odbc client does not issue an explicit close message of a prepared statement - instead it uses DEALLOCATE. So I don't think we should be removing the query from the prepared map ever when just closing the portal. If we're worried about the memory consumption, we can hold the Prepared statement with a soft reference. But that doesn't seem necessary and is somewhat complicated. We could also just put a hard limit on the number of open portals/prepared plans.
The pg jdbc client has different behavior. It uses phantom references to issue specific close of the portal and statement when the corresponding objects have been garbage collected.
Steve
-
21. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
rareddy Jul 31, 2013 2:22 PM (in response to shawkins)Since on DEALLOCATE Teiid already closes the prepare statements, that is why you are saying memory consumption on runway stuff is not of a concern?
-
22. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Jul 31, 2013 2:49 PM (in response to rareddy)No I'm saying that the odbc client code has the ability to close statements through DEALLOCATE. I was assuming from your previous statement that you assumed we should cleanup on bound to prevent a leak of prepared statements. I think for now we can just ignore system limits on the number of plans/portals as it's unlikely to be an issue any time soon.
Steve
-
23. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
rareddy Jul 31, 2013 3:06 PM (in response to shawkins)Originally I do not think I assosiated the DELLOCATE with closing the prepare statements I belive (I do not remember), thus I was closing them close bound.
-
24. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 12:41 AM (in response to rareddy)Marco,
8.5 Beta1 with TEIID-2604 TEIID-2608 and TEIID-2610 has been posted to http://www.jboss.org/teiid/downloads
This should get you further hopefully. If there are any problems just post the org.teiid.ODBC trace logs and we'll get them resolved.
Thanks,
Steve
-
25. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Aug 1, 2013 4:29 AM (in response to shawkins)Hi all,
I can confirm that the new 8.5 beta fixes that "hanging" behaviour thanks!
my successful tests are on 2 vdb, each one connected respectively to mssql and mysql
and works also on this mixed vdb that combines, as said mssql and mysql together through above 2 vdbs
all of them work and open in squirrelsql, liberoffice, msaccess97 and msaccess2010.
I will test more today, but I'm happy!
Marco