Re: VCL 2.4 Frontend issue

[to...@inf.mit.bme.hu]

Thanks for the fix, it is working corretly now.
 
Br,
Aaron Toth

-----Andy Kurth <an...@ncsu.edu> ezt írta: ----- 
Címzett: dev@vcl.apache.org
Feladó: Andy Kurth <an...@ncsu.edu>
Dátum: 2015/01/28 06:37du.
Tárgy: Re: VCL 2.4 Frontend issue

I committed changes to vcl.sql and update-vcl.sql to not add the constraint
on sublog.blockRequestid.  The real problem is that sublog.blockRequestid
is set to 'NOT NULL'.  When the web frontend inserts a sublog entry for a
non-block request reservation it sets sublog.blockRequestid to 0 -- a
non-existent value.  We should change things to allow this value to be null
and set it to null for non-block request reservations.  Not wanting to make
too many changes at this point with the upcoming release, I simply removed
the constraint.

The update-vcl.sql file was updated to remove the sublog.blockRequestid
constraint if it exists.  You should be able to apply it to your database
in order to fix things.

-Andy

On Tue, Jan 27, 2015 at 8:57 AM, Andy Kurth <an...@ncsu.edu> wrote:

> I will look into it.  The constraint may be exposing an underlying problem
> with the database.
> Thanks,
> Andy
>
> On Tue, Jan 27, 2015 at 8:39 AM, <to...@inf.mit.bme.hu> wrote:
>
>> Dear all,
>>
>> I ran into another frontend issue, I cannot create a basic reservation
>> and get the following rather generic error message: "Error encountered:
>> Please try again later"
>>
>> With IE11 Developer Tools, I got this as the error message for the AJAX
>> request:
>>     Cannot add or update a child row: a foreign key constraint fails
>> (`vcl`.`sublog`, CONSTRAINT `sublog_ibfk_8` FOREIGN KEY (`blockRequestid`)
>> REFERENCES `blockRequest` (`id`))
>>     INSERT INTO sublog (logid, imageid, imagerevisionid, computerid,
>> managementnodeid, predictivemoduleid, hostcomputerid) VALUES (4, 3, 2, 2,
>> 1, 8, 1)
>>     ERROR(101): General MySQL error
>>
>> The problem seems to be that the frontend tries to INSERT into the sublog
>> table incorrectly (under the new set of foreign key constraints).
>> The problematic constraint seems to have appeared with the same commit as
>> the one I wrote about earlier:
>>
>> Constraint commited:
>>     Revision: 1646344
>>     Author: arkurth
>>     Date: 2014. december 17. 22:51:21
>>     Message:
>>     VCL-763
>>     Added constraints to the several columns which reference another
>> table.
>>     ----
>>     Modified : /vcl/trunk/mysql/vcl.sql
>>
>> Again, due to this, we are unable to create any new reservations in a 2.4
>> (test version) clean install (using the install script provided by Josh).
>> As before, we would appreciate if you could fix this in the trunk.
>>
>> Br,
>> Aaron Toth
>>
>
>