-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mike,
What version of VCL do you have installed? Josh On Monday June 20, 2011, Waldron, Michael H wrote: > I have a block allocation setup for 16 machines. When it was processed this > morning, I received 6 emails identical to the one below with an error > about table VMhostCheck already existing. When I look in the > blockComputers table, there are 10 computers listed, so it appears it > reserved 10 out of the 16 machines, and the remaining 6 got this error. > > Any ideas what the source of the problem could be? > > > Mike Waldron > Systems Specialist > ITS Research Computing > University of North Carolina at Chapel Hill > CB #3420, ITS Manning, Rm 2509 > 919-962-9778 > ________________________________________ > From: mwald...@email.unc.edu [mwald...@email.unc.edu] > Sent: Monday, June 20, 2011 8:45 AM > To: Waldron, Michael H > Subject: Error with VCL XMLRPC call > > Table 'VMhostCheck' already exists > > CREATE TEMPORARY TABLE VMhostCheck ( RAM mediumint unsigned NOT NULL, > allocRAM mediumint unsigned NOT NULL, vmhostid smallint unsigned NOT NULL > ) ENGINE=MEMORY ERROR(101): General MySQL error > Logged in user was vclsystem > Mode was xmlrpccall > > > Backtrace: > =-=-=-=-=-=-=-=-=-=-=-= > Call#:1 => index.php:xmlrpccall() (line#:86) > Call#:2 => utils.php:xmlrpc_server_call_method() (line#:8355) > Call#:3 => unknown:xmlRPChandler() (line#:unknown) > Call#:4 => utils.php:call_user_func_array() (line#:8431) > Call#:5 => unknown:XMLRPCprocessBlockTime() (line#:unknown) > Call#:6 => xmlrpcWrappers.php:isAvailable() (line#:1081) > Call#:7 => utils.php:doQuery() (line#:3693) > Call#:8 => utils.php:abort() (line#:1044) > > Backtrace with Arguments: > =-=-=-=-=-=-=-=-=-=-=-= > Call#:1 => index.php:xmlrpccall() (line#:86) > Arguments(none): > ----------------------- > Call#:2 => utils.php:xmlrpc_server_call_method() (line#:8355) > Arguments(3) > > Argument#: 1 => Resource id #26 > Argument#: 2 => <?xml version="1.0" > encoding="us-ascii"?><methodCall><methodName>XMLRPCprocessBlockTime</metho > dName><params><param><value><int>2</int></value></param><param><value><int> > 1</int></value></param></params></methodCall> Argument#: 3 => (empty > string) > ----------------------- > Call#:3 => unknown:xmlRPChandler() (line#:unknown) > Arguments(3) > > Argument#: 1 => XMLRPCprocessBlockTime > Argument#: 2 => Array > ( > [0] => 2 > [1] => 1 > ) > > Argument#: 3 => (empty string) > ----------------------- > Call#:4 => utils.php:call_user_func_array() (line#:8431) > Arguments(2) > > Argument#: 1 => XMLRPCprocessBlockTime > Argument#: 2 => Array > ( > [0] => 2 > [1] => 1 > ) > > ----------------------- > Call#:5 => unknown:XMLRPCprocessBlockTime() (line#:unknown) > Arguments(2) > > Argument#: 1 => 2 > Argument#: 2 => 1 > ----------------------- > Call#:6 => xmlrpcWrappers.php:isAvailable() (line#:1081) > Arguments(8) > > Argument#: 1 => Array > ( > [1022] => Array > ( > [id] => 1022 > [name] => vmwarewinxp-Stata11WinXPvmware1022-v5 > [prettyname] => Stata 11, WinXP (vmware) > [ownerid] => 8 > [owner] => mwaldron@UNC > [platformid] => 1 > [platform] => i386 > [osid] => 16 > [os] => vmwarewinxp > [minram] => 1024 > [minprocnumber] => 1 > [minprocspeed] => 500 > [minnetwork] => 10 > [maxconcurrent] => 75 > [reloadtime] => 20 > [deleted] => 0 > [test] => 0 > [resourceid] => 1047 > [lastupdate] => 2011-02-01 09:13:44 > [forcheckout] => 1 > [maxinitialtime] => 0 > [imagemetaid] => 41 > [checkuser] => 0 > [rootaccess] => 1 > [usergroupid] => > [usergroup] => > [sysprep] => 0 > [subimages] => Array > ( > ) > > [imagerevision] => Array > ( > [831] => Array > ( > [id] => 831 > [revision] => 4 > [userid] => 8 > [user] => mwaldron@UNC > [datecreated] => 2010-12-28 10:13:28 > [prettydate] => 12/28/10 10:13 AM > [production] => 0 > [imagename] => > vmwarewinxp-Stata11WinXPvmware1022-v4 ) > > [867] => Array > ( > [id] => 867 > [revision] => 5 > [userid] => 8 > [user] => mwaldron@UNC > [datecreated] => 2011-02-01 08:43:46 > [prettydate] => 2/01/11 8:43 AM > [production] => 1 > [imagename] => > vmwarewinxp-Stata11WinXPvmware1022-v5 ) > > ) > > ) > > ) > > Argument#: 2 => 1022 > Argument#: 3 => 867 > Argument#: 4 => 1308594448 > Argument#: 5 => 1308604500 > Argument#: 6 => (empty integer) > Argument#: 7 => (empty integer) > Argument#: 8 => 1 > ----------------------- > Call#:7 => utils.php:doQuery() (line#:3693) > Arguments(2) > > Argument#: 1 => CREATE TEMPORARY TABLE VMhostCheck ( RAM mediumint unsigned > NOT NULL, allocRAM mediumint unsigned NOT NULL, vmhostid smallint unsigned > NOT NULL ) ENGINE=MEMORY Argument#: 2 => 101 > ----------------------- > Call#:8 => utils.php:abort() (line#:1044) > Arguments(2) > > Argument#: 1 => 101 > Argument#: 2 => CREATE TEMPORARY TABLE VMhostCheck ( RAM mediumint unsigned > NOT NULL, allocRAM mediumint unsigned NOT NULL, vmhostid smallint unsigned > NOT NULL ) ENGINE=MEMORY ----------------------- - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found at pgp.mit.edu -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) iEYEARECAAYFAk3/S5YACgkQV/LQcNdtPQOObQCfSVWSYTSAOFJFeB0OsFB3tjJv UbEAn30v/h8m5hNOWKdqzj20XpG97sJ/ =RJ9O -----END PGP SIGNATURE-----