Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
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-users digest..."
Today's Topics:
1. Weird DB issue after weekly clean (Michael T. Voity)
----------------------------------------------------------------------
Message: 1
Date: Mon, 24 Mar 2014 14:53:20 -0400
From: "Michael T. Voity" <[email protected]>
Subject: [Netdot-users] Weird DB issue after weekly clean
To: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello,
The table 'fwtableentry' seems to disappear from my db weekly after
'prune_db.pl -F -A -d 7 -r' runs.
Ideas on whats happening?
To fix I run the following from MySql console.
SET FOREIGN_KEY_CHECKS = 0;
SET AUTOCOMMIT = 0;
CREATE TABLE `fwtableentry` (
`fwtable` bigint NOT NULL,
`id` bigint NOT NULL auto_increment,
`interface` bigint NOT NULL,
`physaddr` bigint NOT NULL,
INDEX `FWTableEntry1` (`fwtable`),
INDEX `FWTableEntry2` (`interface`),
INDEX `FWTableEntry3` (`physaddr`),
PRIMARY KEY (`id`),
CONSTRAINT `fk_fwtable` FOREIGN KEY (`fwtable`) REFERENCES `fwtable`
(`id`),
CONSTRAINT `fk_interface_1` FOREIGN KEY (`interface`) REFERENCES
`interface` (`id`),
CONSTRAINT `fk_physaddr_3` FOREIGN KEY (`physaddr`) REFERENCES
`physaddr` (`id`)
) ENGINE=InnoDB;
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;
SET AUTOCOMMIT = 1;
-Mike
--
Michael T. Voity
Network Engineer
University of Vermont
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 64, Issue 11
********************************************
