You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Dmitri Chebotarov <dc...@gmu.edu> on 2012/07/24 16:03:21 UTC
Updating VCL DB to version 2.3 error
Hello
I'm upgrading VCL 2.2.1 to VCL 2.3 and during database upgrade getting this error:
# mysql vcl < mysql/update-vcl.sql
ERROR 1452 (23000) at line 484: Cannot add or update a child row: a foreign key constraint fails (`vcl`.`usergroupmembers`, CONSTRAINT `usergroupmembers_ibfk_2` FOREIGN KEY (`usergroupid`) REFERENCES `usergroup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
I'm using VCL 2.3 release.
Does anyone else have this problem?
--
Thank you,
Dmitri Chebotarov
Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
223 Aquia Building, Ffx, MSN: 1B5
Phone: (703) 993-6175
Fax: (703) 993-3404
Re: Updating VCL DB to version 2.3 error
Posted by Dmitri Chebotarov <dc...@gmu.edu>.
Thank you.
The error is specific to our VCL configuration. It works fine now.
On Jul 24, 2012, at 10:26 , Georgy Mathew Kallumkal wrote:
> I also did an upgrade from 2.2.1 to 2.3 but didn't face this error.
>
> Thanks
> Georgy
>
> On Tue, Jul 24, 2012 at 10:03 AM, Dmitri Chebotarov <dc...@gmu.edu> wrote:
>
> Hello
>
> I'm upgrading VCL 2.2.1 to VCL 2.3 and during database upgrade getting this error:
>
> # mysql vcl < mysql/update-vcl.sql
>
> ERROR 1452 (23000) at line 484: Cannot add or update a child row: a foreign key constraint fails (`vcl`.`usergroupmembers`, CONSTRAINT `usergroupmembers_ibfk_2` FOREIGN KEY (`usergroupid`) REFERENCES `usergroup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
>
> I'm using VCL 2.3 release.
> Does anyone else have this problem?
>
> --
> Thank you,
>
> Dmitri Chebotarov
> Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
> 223 Aquia Building, Ffx, MSN: 1B5
> Phone: (703) 993-6175
> Fax: (703) 993-3404
>
>
>
>
>
--
Thank you,
Dmitri Chebotarov
Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
223 Aquia Building, Ffx, MSN: 1B5
Phone: (703) 993-6175
Fax: (703) 993-3404
Re: Updating VCL DB to version 2.3 error
Posted by Georgy Mathew Kallumkal <ge...@ncsu.edu>.
I also did an upgrade from 2.2.1 to 2.3 but didn't face this error.
Thanks
Georgy
On Tue, Jul 24, 2012 at 10:03 AM, Dmitri Chebotarov <dc...@gmu.edu>wrote:
>
> Hello
>
> I'm upgrading VCL 2.2.1 to VCL 2.3 and during database upgrade getting
> this error:
>
> # mysql vcl < mysql/update-vcl.sql
>
> ERROR 1452 (23000) at line 484: Cannot add or update a child row: a
> foreign key constraint fails (`vcl`.`usergroupmembers`, CONSTRAINT
> `usergroupmembers_ibfk_2` FOREIGN KEY (`usergroupid`) REFERENCES
> `usergroup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
>
> I'm using VCL 2.3 release.
> Does anyone else have this problem?
>
> --
> Thank you,
>
> Dmitri Chebotarov
> Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
> 223 Aquia Building, Ffx, MSN: 1B5
> Phone: (703) 993-6175
> Fax: (703) 993-3404
>
>
>
>
>