-
1. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 7:09 AM (in response to m.ardito)That isn't related to the odbc issue, so a new thread would be appropriate. Can you retry with logging at a debug level to see if there are any relevant server entries? If not, then there is something unexpected happening on the client side that is not being reported very well.
Steve
-
2. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 8:25 AM (in response to shawkins)Also if this is easiest to reproduce in squirrel, then set File->Global Preferences->SQL option of Debug to either writer or stream - that will at least give the client's full stacktrace.
Steve
-
3. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Aug 1, 2013 10:15 AM (in response to shawkins)hey you hijacked my post :-D I didn't notice... good...
I see that behaviour also with 8.4, so it is not a regression of the new beta.
From squirrelsql, if i query a sqlserver db with jtds, the error does not happen.
eg:
select * from ApiMn.dbo.MA_CostAccEntriesDetail
gives: Query 1 of 1, Rows read: 403,364, Elapsed time (seconds) - Total: 11.069, SQL query: 0.002, Reading results: 11.067
same table (and others, also on mysql) through teiid 8.4 or 8.5, give that error
eg: with teiid 8.4
enabling sql log in squirrel i have the attached logs executing the exact same query
Let me know if I can collect more or better details
Thanks
Marco
-
squirrel-sql.log.zip 3.6 KB
-
jdbcdebug.log.zip 1.0 KB
-
-
4. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 10:32 AM (in response to m.ardito)The SQLFeatureNotSupportedException exceptions are expected and the AsynchPositioningException is being erroneously reported (I'll change it to not be a static instance for clarity). The serialization exception you're getting is with the 8.4 client and an 8.5 server correct? Do you get the same exception when using the 8.5 Beta1 client?
Steve
-
5. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Aug 1, 2013 10:56 AM (in response to shawkins)The report attached before was on server 8.4 teiid client... not sure... probably 8.2 (? why ?)
The following (attached) is for sure with server 8.5beta1 and client 8.5beta1:
queries are run on the same mixed mssql/mysql vdb i reported before
if needed tomorrow I'll test in a amore structurated way, I'm a bit tired now... :-)
Marco
-
squirrel-sql.log.zip 3.6 KB
-
jdbcdebug.log.zip 1.0 KB
-
-
6. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 11:33 AM (in response to m.ardito)This seems to be a classloading issue in squirrel. In both cases you are producing the same stacktrace - however the code line numbers have changed between versions. And the line number matches up to the 8.3 client (rather than 8.4 or 8.5). I can confirm though that there is an issue using the 8.3 client as the server assumes that it can send the results back in new way, even though it's not appropriate. I believe that any combination of 8.4/8.5 client/server should work as well as using the 8.3/8.4/8.5 clients against 8.3.
Steve
-
7. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 1, 2013 12:42 PM (in response to shawkins)https://issues.jboss.org/browse/TEIID-2611 has been worked which will allow Teiid 8.5 Beta2+ to work with 8.3 and older clients. Unfortunately this means that using 8.4 Final server with an older client won't generally work. So the next question for your setup is why the 8.3 client is being used when you expect a different version.
Steve
-
8. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Aug 2, 2013 4:02 AM (in response to shawkins)Hi Steve,
I never used 8.3, neither server nor client: in the past I used 7.2, 8.2, and recently i have only experimented with 8.4 and 8.5b1.
As a result, I have quite a mess of test setup area on my pc :-D And yesterday, I was quite tired, so I think I mistakenly used 8.2 driver in squirrel to test 8.4 server
Today, fresh, i repeated tests and double checked everything, afaik, with 84 setup and 85 beta setup
(getting errors, in both situations, although different, btw)
Attached you find two screenshot that I hope clarify what I used, 84 setup and 85 beta setup and the error shown
It could be I setup something wrong, just let me understand and I'll correct before testing/logging again.
I have recorded logs for both queries, if needed.
Unfortunately (?) Today is my last work day before summer, I should be here again around september 2.
SO I don't know how can I participate i nthie thread, but until I'm here...
Have a wonderful summer :-)
Cheers from Italy
Marco
-
9. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
shawkins Aug 2, 2013 6:21 AM (in response to m.ardito)I assumed 8.3 above since that was the first version with a matching line number. In any case your pictures show what is happening. You have all the driver jars in the classpath for the 8.4/8.5 driver definitions and the classloader will load things from the first in the list - thus all of your driver definitions are effectively 8.2. You need to only have the driver jar for the specific version in the squirell jar list.
Have a good holiday and thanks again,
Steve
-
10. Re: msaccess odbc queries hang forever, server log: Binding on a statement, that has not been prepared
m.ardito Aug 2, 2013 6:42 AM (in response to shawkins)Oh what a n00b!
In fact, I moved client drivers 82 and 84 away, and now it works perfectly on 85beta!
select * from ApiMn.dbo.MA_CostAccEntriesDetail
Query 1 of 1, Rows read: 403,374, Elapsed time (seconds) - Total: 19.431, SQL query: 0.359, Reading results: 19.072
now, I can go on holidays happier :-)
Thanks,
Marco