You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by "Martinez, Emerio" <em...@Fullerton.edu> on 2019/08/27 23:13:00 UTC
Block Allocation Request is Failing
Hello VCL User Community,
I am getting the following SQL error in the PHP log from my VCL 2.5 application when I try to request a block allocation. Please advise.
Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
Arguments(none):
-----------------------
Call#:2 => blockallocations.php:doQuery() (line#:630)
Arguments(2)
Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines, groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES ('Emerio testing block allocation', 11, 2, 109, 'weekly', 24, 1, '2019-09-30 23:59:59', 'accepted')
Argument#: 2 => 101
-----------------------
[27-Aug-2019 13:24:21 America/Los_Angeles] Field 'processing' doesn't have a default value
[27-Aug-2019 13:24:21 America/Los_Angeles] INSERT INTO blockRequest (name, imageid, numMachines, groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES ('Emerio test for block allocations', 11, 4, 109, 'weekly', 24, 1, '2019-09-30 23:59:59', 'accepted')
[27-Aug-2019 13:24:21 America/Los_Angeles] ===========================================================================
[27-Aug-2019 13:24:21 America/Los_Angeles] ERROR(101): General MySQL error
[27-Aug-2019 13:24:21 America/Los_Angeles]
Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
Call#:2 => blockallocations.php:doQuery() (line#:630)
Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
Arguments(none):
-----------------------
Call#:2 => blockallocations.php:doQuery() (line#:630)
Arguments(2)
Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines, groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES ('Emerio test for block allocations', 11, 4, 109, 'weekly', 24, 1, '2019-09-30 23:59:59', 'accepted')
Argument#: 2 => 101
-----------------------
Emerio
RE: Block Allocation Request is Failing
Posted by "Martinez, Emerio" <em...@Fullerton.edu>.
Hello Josh,
Thank you for your response! I have to follow my university's change control process before I can implement the blockRequest table change to our VCL system. I inherited our VCL system and I have been told that BA on it has never worked. So later and after I implement the change if other BA work flow issues come up, I would like to continue to reach out to you on this email thread. Again, thank you.
Emerio
-----Original Message-----
From: Josh Thompson <jo...@ncsu.edu>
Sent: Wednesday, August 28, 2019 9:46 AM
To: user@vcl.apache.org
Subject: Re: Block Allocation Request is Failing
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Emerio,
We encountered some similar issues after our MariaDB server was upgraded.
Either a setting was changed or a newer version of MariaDB is more strict about table definitions.
You need to modify blockRequest.processing so that it has a default value of 0. i.e.
ALTER TABLE blockRequest CHANGE processing processing TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
Josh
On Tuesday, August 27, 2019 7:13:00 PM EDT Martinez, Emerio wrote:
> Hello VCL User Community,
>
> I am getting the following SQL error in the PHP log from my VCL 2.5
> application when I try to request a block allocation. Please advise.
>
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status)
> VALUES ('Emerio testing block allocation', 11, 2, 109, 'weekly', 24,
> 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> [27-Aug-2019 13:24:21 America/Los_Angeles] Field 'processing' doesn't
> have a default value [27-Aug-2019 13:24:21 America/Los_Angeles] INSERT
> INTO blockRequest (name, imageid, numMachines, groupid, repeating,
> ownerid, managementnodeid, expireTime, status) VALUES ('Emerio test
> for block allocations', 11, 4, 109, 'weekly', 24, 1, '2019-09-30
> 23:59:59',
> 'accepted') [27-Aug-2019 13:24:21 America/Los_Angeles]
> ======================================================================
> =====
> [27-Aug-2019 13:24:21 America/Los_Angeles] ERROR(101): General MySQL
> error
> [27-Aug-2019 13:24:21 America/Los_Angeles]
> Backtrace:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Call#:2 => blockallocations.php:doQuery() (line#:630)
>
> Backtrace with Arguments:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status)
> VALUES ('Emerio test for block allocations', 11, 4, 109, 'weekly', 24,
> 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> Emerio
- --
- -------------------------------
Josh Thompson
VCL Developer
North Carolina State University
my GPG/PGP key can be found at pgp.mit.edu
All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties.
-----BEGIN PGP SIGNATURE-----
iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXWavygAKCRBX8tBw1209
A9ADAJ41rwKV218O0b2PPk0mxGiBcl4UFgCfYh69b9t0uRmI0CcCqWZEcVMOgyM=
=P7m9
-----END PGP SIGNATURE-----
Re: Block Allocation Request is Failing
Posted by Josh Thompson <jo...@ncsu.edu>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Emerio,
We encountered some similar issues after our MariaDB server was upgraded.
Either a setting was changed or a newer version of MariaDB is more strict
about table definitions.
You need to modify blockRequest.processing so that it has a default value of
0. i.e.
ALTER TABLE blockRequest CHANGE processing processing TINYINT(1) UNSIGNED NOT
NULL DEFAULT '0';
Josh
On Tuesday, August 27, 2019 7:13:00 PM EDT Martinez, Emerio wrote:
> Hello VCL User Community,
>
> I am getting the following SQL error in the PHP log from my VCL 2.5
> application when I try to request a block allocation. Please advise.
>
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES
> ('Emerio testing block allocation', 11, 2, 109, 'weekly', 24, 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> [27-Aug-2019 13:24:21 America/Los_Angeles] Field 'processing' doesn't have a
> default value [27-Aug-2019 13:24:21 America/Los_Angeles] INSERT INTO
> blockRequest (name, imageid, numMachines, groupid, repeating, ownerid,
> managementnodeid, expireTime, status) VALUES ('Emerio test for block
> allocations', 11, 4, 109, 'weekly', 24, 1, '2019-09-30 23:59:59',
> 'accepted') [27-Aug-2019 13:24:21 America/Los_Angeles]
> ===========================================================================
> [27-Aug-2019 13:24:21 America/Los_Angeles] ERROR(101): General MySQL error
> [27-Aug-2019 13:24:21 America/Los_Angeles]
> Backtrace:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Call#:2 => blockallocations.php:doQuery() (line#:630)
>
> Backtrace with Arguments:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES
> ('Emerio test for block allocations', 11, 4, 109, 'weekly', 24, 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> Emerio
- --
- -------------------------------
Josh Thompson
VCL Developer
North Carolina State University
my GPG/PGP key can be found at pgp.mit.edu
All electronic mail messages in connection with State business which
are sent to or received by this account are subject to the NC Public
Records Law and may be disclosed to third parties.
-----BEGIN PGP SIGNATURE-----
iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXWavygAKCRBX8tBw1209
A9ADAJ41rwKV218O0b2PPk0mxGiBcl4UFgCfYh69b9t0uRmI0CcCqWZEcVMOgyM=
=P7m9
-----END PGP SIGNATURE-----