-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Can you please file this on the bug tracker bugs.monetdb.org? Thanks. On 22/01/16 01:51, Puthick Hok wrote:
Hi,
I'm using MonetDB-11.19.7 compiled from source on openSUSE 12.1. I'm also using the Perl client code from MonetDB source to connect to MonetDB from Perl via Perl DBI module. It works fine for a physical server but a VM server with a vmdk drive.
It has an issue that the database handler must be disconnected and reconnected in order to execute more SQL statements; otherwise there will be an error saying 'Statement handle not marked as Active'.
So I have written 2 testing Perl scripts doing SQL select for 100 iterations. One script is to demonstrate that it will fail while the other will work for all the iterations. The one that works is the script that connect and disconnect to MonetDB in every iteration before executing the SQL.
In order to help you replicate the problem, there is an attached tar.gz file containing the 2 perl scripts - one for success and the other one for failure. Due to the size limitation, I cannot include the database dump file for the demonstration.
Regards, Puthick
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWoft9AAoJEISMxT6LrWYgj7AH/3nu9IiHpg79il3Ya767+NrA n4zd+shfcNf5ttvENhY8xPATsMrLvJL+nS+eO401e0SXFNIGaqYFbO8mjFDImy6l H8AY2llmWfEVScrUr+HHtidVp+bAXVxMEGX4j5CdkR9hfKFJb9q1D63V+OcQjkfg NYjp+A40lsfpqhAHMzNez7FR91u+UixroBVtjl8CiGM0YToXpd9wn3z5l9rpkE3g gDYt404po17gIeBk/9M3uoyz3wcpJ32eN9354XU0QWvmAPDbzPhUXsy6S1g5Gz9t PPAliGJb13VnROAPdUVg/yM6W6rO8HFc7j8CHaCoWL5uqnHq+YFelxFAfBeMIyk= =OapY -----END PGP SIGNATURE-----