Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. [Netdot - Bug #1778] (New) Foreign constraint bug when trying
to delete a device ([email protected])
----------------------------------------------------------------------
Message: 1
Date: Wed, 2 Oct 2013 07:29:58 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1778] (New) Foreign constraint
bug when trying to delete a device
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1778 has been reported by Carlos Vicente.
----------------------------------------
Bug #1778: Foreign constraint bug when trying to delete a device
https://osl.uoregon.edu/redmine/issues/1778
Author: Carlos Vicente
Status: New
Priority: High
Assignee:
Category: Netdot
Target version: 1.0.5
Resolution:
I was able to delete it by first deleting its (only) IP address.
<pre>
Transaction aborted: Can't delete 2067238: DBD::mysql::st execute failed:
Cannot delete or update a parent row: a foreign key constraint fails
(`netdot`.`device_history`, CONSTRAINT `fk_snmp_target_1` FOREIGN KEY
(`snmp_target`) REFERENCES `ipblock` (`id`)) [for Statement "DELETE
FROM ipblock
WHERE id=?
" with ParamValues: 0='2067238'] at /usr/share/perl5/DBIx/ContextualFetch.pm
line 52, line 4.
Stack:
[/usr/share/perl5/DBIx/ContextualFetch.pm:52]
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]
[/usr/share/perl5/Class/DBI.pm:737]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Ipblock.pm:1758]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Interface.pm:271]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Device.pm:2390]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/htdocs/generic/delete.html:161]
[/usr/local/netdot/htdocs/generic/delete.html:163]
[/usr/local/netdot/htdocs/autohandler:110]
[/usr/local/netdot/htdocs/management/dhandler:1]
[/usr/local/netdot/htdocs/management/autohandler:83]
[/usr/share/perl5/HTML/Mason/Request.pm:948]
[/usr/local/netdot/htdocs/masondata/obj/1249759374/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/share/perl5/Class/DBI/Iterator.pm line 106
Stack:
[/usr/share/perl/5.14/Carp.pm:79]
[/usr/share/perl5/Class/DBI.pm:169]
[/usr/share/perl5/Class/DBI.pm:175]
[/usr/share/perl5/Class/DBI.pm:739]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Ipblock.pm:1758]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Interface.pm:271]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Device.pm:2390]
[/usr/share/perl5/Class/DBI/Iterator.pm:106]
[/usr/share/perl5/Class/DBI/Cascade/Delete.pm:21]
[/usr/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
[/usr/share/perl5/Class/Trigger.pm:74]
[/usr/share/perl5/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/htdocs/generic/delete.html:161]
[/usr/local/netdot/htdocs/generic/delete.html:163]
[/usr/local/netdot/htdocs/autohandler:110]
[/usr/local/netdot/htdocs/management/dhandler:1]
[/usr/local/netdot/htdocs/management/autohandler:83]
[/usr/share/perl5/HTML/Mason/Request.pm:948]
[/usr/local/netdot/htdocs/masondata/obj/1249759374/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
</pre>
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 79, Issue 3
*******************************************
