Hi, Status; gives your own session id. To be combined to show innodb status (ksh or perl).
Mathias Selon Frank Schröder <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM: > > > > > >>Hello, > >> > >>I have an InnoDB table running on MySQL 4.1.11 with multiple FK > >>constraints. I'm accessing it via JDBC from Java. > >> > >>When an FK constraint fails with error 1216 I need to know which of the > >>constraints failed. > >> > >>SHOW INNODB STATUS returns the following output > >> > >> ... > >> CONSTRAINT `u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`) > >>REFERENCES `u_device` (`DEVICE_ID`) > >> ... > >> > >>Is there a way of getting to the name of the last failed FK constraint > >>without using SHOW INNODB STATUS? What I need is the > >>'u_registration_ibfk_1' from the above example. > >> > >>Any help is highly appreciated > >> > >>-- > >>Frank > >> > > > > > > Have you looked at the results of SHOW INNODB STATUS; ? > > > > Shawn Green > > Database Administrator > > Unimin Corporation - Spruce Pine > > Yes, as you can see from my original post I'm actually trying to figure > out how to do this *without* SHOW INNODB STATUS as this reports the > last FK failure for the entire engine and not just my session - at least > that's how I interpret the documentation. > > The thing that's really a headscratcher for me is why its possible for > me to set a name for a constraint if it isn't displayed in an error and > I can't get to it. It's useless. I have a hard time believing that so I > figure that I just haven't figured out how to get to it. I just didn't > think that it was sooooo hard. > > -- > Frank > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
