[MonetDB-users] Strange io exception
Hi, 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() What does this mean? Why does this happen? I am using v2.28.5 compiled on Windows from CVS (branch May2009). -- View this message in context: http://www.nabble.com/Strange-io-exception-tp23692587p23692587.html Sent from the monetdb-users mailing list archive at Nabble.com.
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).
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. 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
-- View this message in context: http://www.nabble.com/Strange-io-exception-tp23692587p23692861.html Sent from the monetdb-users mailing list archive at Nabble.com.
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
I run concurrent threads - each doing a login-select-result sequence. Martin Kersten wrote:
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
------------------------------------------------------------------------------ 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
-- View this message in context: http://www.nabble.com/Strange-io-exception-tp23692587p23693003.html Sent from the monetdb-users mailing list archive at Nabble.com.
Alex Bo. wrote:
I run concurrent threads - each doing a login-select-result sequence.
So to understand you exacly right... Something like this is executed in seperated threads n-times. dbh = mapi_connect(hdl->src_ref->host.buf, hdl->src_ref->port, props->user.buf, props->password.buf, "sql", NULL); And you query on each different dbh? If that is the case, I never ran into this issue. If you do it one only one connection, I ran into the issue before. Stefan
Yes, exactly. mapi_connect is executed in seperated threads. Stefan de Konink-3 wrote:
Alex Bo. wrote:
I run concurrent threads - each doing a login-select-result sequence.
So to understand you exacly right...
Something like this is executed in seperated threads n-times.
dbh = mapi_connect(hdl->src_ref->host.buf, hdl->src_ref->port, props->user.buf, props->password.buf, "sql", NULL);
And you query on each different dbh?
If that is the case, I never ran into this issue. If you do it one only one connection, I ran into the issue before.
Stefan
------------------------------------------------------------------------------ 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
-- View this message in context: http://www.nabble.com/Strange-io-exception-tp23692587p23694658.html Sent from the monetdb-users mailing list archive at Nabble.com.
participants (3)
-
Alex Bo. -
Martin Kersten -
Stefan de Konink