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</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
-----------------------

Reply via email to