what does DATA TUPLE mean? what to do?
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;;
-----------
Subject
Views
Written By
Posted
what does DATA TUPLE mean? what to do?
10865
November 24, 2008 05:06PM
2885
June 11, 2009 07:41AM
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.