Alex Bo. wrote:
I'm not using mclient - I created my own tester in which I use mapi to connect to Monet and run queries and retrieve their results. I open 6 mapi connections concurrently and send 'Select * from tables' requests. When all of them return I do this again, and so on... After a while I get the reported error, but consequent queries do run successfully. Your test script is a C program? or a Java program?
How is the test organized ? ?? 1) establish 6 concurrent logins 2) issue 6 concurrent queries after 1) is completed? 3) collect 6 results or are you use concurrent C-threads that each perform a login-select-result
Martin Kersten wrote:
Alex Bo. wrote:
Hi,
Hi,
just to be sure how you do it. Do you have a script how you get to this situation? You run mclients in parallel on the same machine?
I am running "Select * from tables" and am going over the results with Mapi commands. I tried to run this query with parallel clients, and reran the query hundreds of times. Once in a while I get this exception: !TypeException:user.s32_7[157]:'io.s3019_1' undefined in: _233:any := io.s3019_1() Given the number of queries you have ran (>3000), i suspect that the sql cache is cleared at some point, without a proper corrective action elsewhere. This leads to a failure to find the proper cached plan. But, with a script we can look into it.
Thanks for reporting this.
regards, Martin
What does this mean? Why does this happen?
I am using v2.28.5 compiled on Windows from CVS (branch May2009).
------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users