Hi,
I have got the correct answer now, from Linus Larsson, just forwarding
it for the archives:
---8<---
Hello, my name is Linus Larsson.
I saw you got a problem with mysql on Ubuntu 9.10, I was researching the
exact same problem and found your post. In the end I turned off
app-armo
does the table ur trying to delete has any primary-foreign key relation.
do "show create table table_name\G"
Also instead of delete, use truncate, i t will be faster.
regards
anandkl
On Tue, Nov 10, 2009 at 3:19 AM, Sebastiaan van Erk wrote:
> Hi,
>
> I followed the instructions but still get:
Hi,
I followed the instructions but still get:
mysql> delete from mytable;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)
mysql>
Regards,
Sebastiaan
Krishna Chandra Prajapati wrote:
Hi Sebastiaan,
Steps to fix the issu
Hi Sebastiaan,
Steps to fix the issue.
1. Do proper shutdown of mysql server.
2. Check the error log file that mysql server is shutdown properly.
3. Remove log files (ib_logfile0 and ib_logfile1).
4. Start mysql server (The log files will be created automatically)
Thanks,
Krishna
On Sun, Nov 8,
Hi,
Not that I am aware of. I'm just running a standard out of the box 9.10
Ubuntu, upgraded from 9.04. Note that when I'm using /tmp/mysql or /tmp
as tmpdir, at least InnoDB starts up, but then I still get the strange
"temp file operation failed" message instead of the constraint when I
try
Are you running selinux?
On Sunday, November 8, 2009, Sebastiaan van Erk wrote:
> Hi,
>
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference
>
Hi,
$ ls -ld /tmp/mysql
drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
$ ls -ld /tmpfs/mysql
drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
So I don't see the difference
Has anyone encountered similar problems, or know what's going on here?
Best regards,
Sebastiaan
Sebastiaan van Erk wrote:
Hi all,
I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts
of temp file problems. For example, when I try to delete a row and
violate a contraint I get:
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
key constraint fails (tem
Hi all,
I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts of
temp file problems. For example, when I try to delete a row and violate
a contraint I get:
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)
