MySQL Forums
Forum List  »  InnoDB

what does DATA TUPLE mean? what to do?
Posted by: yvonne kire
Date: November 24, 2008 05:06PM

What is this?
And what do I do?
only found by doing a SHOW INNODB STATUS \G
noting in mysql.err log
anything to worry about?
How do I avoid / fix this error?
thx

------------------------
LATEST FOREIGN KEY ERROR
------------------------
081124 9:47:41 Transaction:
TRANSACTION 0 169478121, ACTIVE 0 sec, process no 4036, OS thread id 1955060656 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 3, locked 3
5 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 20979681, query id 317154772 portal preparing
update tablex set last_date = @'0', tablex_id = ( select tably_id from tabley_def where short_name = @'1') where use_id = @'2' and talbley_id not in (select tabley_id from tablex where short_name in ('posed','ated'))
Foreign key constraint fails for table `tablex`:
,
CONSTRAINT `tablex_fk_2` FOREIGN KEY (`tabley_id`) REFERENCES `tablex` (`tablex_id`)
Trying to add in child table, in index `tablex_id` tuple:
DATA TUPLE: 2 fields;
0: len 4; hex 00000000; asc ;; 1: len 4; hex 00006a10; asc j ;;

But in parent table `tablex`, in index `PRIMARY`,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 7; compact format; info bits 0
0: len 4; hex 00000001; asc ;; 1: len 6; hex 000009a25740; asc W@;; 2: len 7; hex 80000000340110; asc 4 ;; 3: len 4; hex 45bffa7a; asc E z;; 4: len 4; hex 45bffa7a; asc E z;; 5: len 18; hex 41637469766174696f6e2050656e64696e67; asc Activation Pending;; 6: len 7; hex 756e626f756e64; asc unbound;;

-----------

Options: ReplyQuote


Subject
Views
Written By
Posted
what does DATA TUPLE mean? what to do?
10865
November 24, 2008 05:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.