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: [email protected] [[email protected]] 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</methodName><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 -----------------------
