Mailing List
Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
ODBC - ODBC with the MySQL Connector/ODBC driver
Perl - Perl support for MySQL with DBI and DBD::mysql
MySQL++ - Programming with the C++ API to MySQL
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
URGENT !! InnoDB Constraint problem !

URGENT !! InnoDB Constraint problem !

2004-06-08       - By Heikki Tuuri

 Back
Reply:     1     2     3     4  

Dimitri,

please upgrade to a newer MySQL version.

"
Starting from MySQL 4.0.13, you can use SHOW INNODB STATUS to display a
detailed explanation of the latest InnoDB foreign key error in the server.
"

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/



-- -- Original Message -- --
From: "Dimitri Bosiers " <dimitri.bosiers@(protected) >
Newsgroups: mailing.database.myodbc
Sent: Monday, June 07, 2004 12:56 PM
Subject: URGENT !! InnoDB Constraint problem !


> i dont have that section in my status report (ill tried it before)
> here 's the report
> *************************** 1. row ***************************
> Status:
> =====================================
> 040607 10:04:41 INNODB MONITOR OUTPUT
> =====================================
> Per second averages calculated from the last 5 seconds
> -- ---- --
> SEMAPHORES
> -- ---- --
> OS WAIT ARRAY INFO: reservation count 24, signal count 24
> Mutex spin waits 4, rounds 41, OS waits 0
> RW-shared spins 48, OS waits 24; RW-excl spins 1, OS waits 0
> -- ---- ----
> TRANSACTIONS
> -- ---- ----
> Trx id counter 0 22817
> Purge done for trx 's n:o < 0 22815 undo n:o < 0 0
> Total number of lock structs in row lock hash table 0
> LIST OF TRANSACTIONS FOR EACH SESSION:
> -- -----
> FILE I/O
> -- -----
> I/O thread 0 state: waiting for i/o request
> I/O thread 1 state: waiting for i/o request
> I/O thread 2 state: waiting for i/o request
> I/O thread 3 state: waiting for i/o request
> Pending normal aio reads: 0, aio writes: 0,
> ibuf aio reads: 0, log i/o 's: 0, sync i/o 's: 0
> Pending flushes (fsync) log: 0; buffer pool: 0
> 78 OS file reads, 157 OS file writes, 94 OS fsyncs
> 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
> -- ---- ---- ---- ---- ---- ---- ----
> INSERT BUFFER AND ADAPTIVE HASH INDEX
> -- ---- ---- ---- ---- ---- ---- ----
> Ibuf for space 0: size 1, free list len 0, seg size 2,
> 0 inserts, 0 merged recs, 0 merges
> Hash table size 34679, used cells 0, node heap has 1 buffer(s)
> 0.00 hash searches/s, 0.00 non-hash searches/s
> ---
> LOG
> ---
> Log sequence number 0 1345367
> Log flushed up to 0 1345367
> Last checkpoint at 0 1345367
> 0 pending log writes, 0 pending chkp writes
> 53 log i/o 's done, 0.00 log i/o 's/second
> -- ---- ---- ---- ----
> BUFFER POOL AND MEMORY
> -- ---- ---- ---- ----
> Total memory allocated 16796660; in additional pool allocated 673536
> Buffer pool size 512
> Free buffers 473
> Database pages 38
> Modified db pages 0
> Pending reads 0
> Pending writes: LRU 0, flush list 0, single page 0
> Pages read 38, created 0, written 103
> 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
> No buffer pool activity since the last printout
> -- ---- ------
> ROW OPERATIONS
> -- ---- ------
> 0 queries inside InnoDB, 0 queries in queue; main thread: waiting for
> server activity
> Number of rows inserted 6, updated 0, deleted 5, read 1264
> 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
> -- ---- ---- ---- ---- -----
> END OF INNODB MONITOR OUTPUT
> ============================
> On 06 Jun 2004, at 16:37, Josh Trutwin wrote:
>
> > On Sun, 6 Jun 2004 15:48:37 +0200
> > Dimitri Bosiers <dimitri.bosiers@(protected) > wrote:
> >
> > <snip >
> >
> > > INSERT INTO
> > > pages(hidden,name,page_number,data,is_section_root,layout_id,group_
> > > id) VALUES(1, 'nieuwe pagina ',100, ' ',2,1,@(protected));
> > >
> > > this fails with a "ERROR 1216: Cannot add a child row: a foreign key
> > >
> > > constraint fails "
> >
> > Run:
> >
> > SHOW INNODB STATUS;
> >
> > And post the results in the "Latest Foreign Key Error " section.
> >
> > Josh
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=dimitri.bosiers @(protected)
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=myodbc @(protected)
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)