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-armor. It seems to have a buggy profile for mysql.
sudo /etc/init.d/apparmor stop
Of course the correct fix is to update the profile, but I have no time
to look into that now. I'm only using mysql temporarily on my computer
anyway.
Regards,
Linus
-------8<-------
Thanks to everybody who answered. :)
Regards,
Sebastiaan
Ananda Kumar wrote:
> 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 <sebster@stripped
> <mailto:sebster@stripped>> wrote:
>
> 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 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, 2009 at 2:51 PM, Sebastiaan van Erk
> <sebster@stripped <mailto:sebster@stripped>
> <mailto:sebster@stripped <mailto:sebster@stripped>>>
> 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 (temp file operation failed)
>
> Instead of telling me which constraint is violated, it tells
> me the
> temp file creation failed. I have no reason why it failed, I
> don't
> see any error messages in the log.
>
> To solve this problem I tried to make a tmpfs partition (I
> thought,
> maybe somehow my using ext4 might be a problem):
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
>
> and changed the tmpdir in the mysql config to /tmpfs/mysql
>
> tmpdir=/tmpfs/mysql
>
> But then mysql fails on startup:
>
> /usr/sbin/mysqld: Can't create/write to file
> '/tmpfs/mysql/ibGgjPv7'
> (Errcode: 13)
> 091108 10:12:46 InnoDB: Error: unable to create temporary file;
> errno: 13
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function
> returned error.
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE
> ENGINE failed.
>
> I checked error code 13, which is permission denied, but I don't
> understand this, because if I change tmpdir to /tmp/mysql it does
> work, and I have:
>
> $ 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
>
>
>
Attachment: [application/x-pkcs7-signature] S/MIME Cryptographic Signature smime.p7s
