[gold-users] Fwd: refunding reserved amount in gold

[Christopher Samuel]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 14/10/11 13:46, akshar bhosale wrote:

> One of the jobs went for execution and reserved the equivalent amount.
> The same job came out of execution and went in queue from execution.
> This happened 30 times for the same job. Every time job has reserved
> amount.

My guess is that you are using MySQL and your table type
is MyISAM and not InnoDB.  Unfortunately the Gold scripts
don't specify a table type and so you're going to pick up
one that doesn't support transactions by default.

We would see that behaviour all the time until Scott
mentioned this to us - changing to InnoDB (which can
be done live) fixed it for us.

cheers,
Chris
- -- 
    Christopher Samuel - Senior Systems Administrator
 VLSCI - Victorian Life Sciences Computation Initiative
 Email: samuel at unimelb.edu.au Phone: +61 (0)3 903 55545
         http://www.vlsci.unimelb.edu.au/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6kobsACgkQO2KABBYQAh/5EwCfWNrZoYtIpK3tw0SPgF5d6oof
GfwAoIyB/V6JB8Br8Bs3zkzs1VMpt5FG
=zmP/
-----END PGP SIGNATURE-----