Package: mysql-server-core-5.1 Version: 5.1.63-0+squeeze1 Severity: normal File: /usr/sbin/mysqld
Hi, Just debugging why creation of temporary tables fails following an upgrade to SQUEEZE. Turns out that the mysql user record is wrong Running SQL like "CREATE TABLE blah SELECT * FROM fred" results in an error similar to: Can't create file './chill@002dtmp/contact.frm' (errno: 9) Checking the ownership of the temp file showed: drwx------ 2 mysql crontab 4096 Sep 11 17:04 chill@002dtmp Checking the user shows the problem: # id mysql uid=106(mysql) gid=101(crontab) groups=101(crontab) Fixing the gid field in /etc/passwd fixes the problem. Google shows other people having a similar problem (though possibly unrelated) so hopefully this helps document the issue. I suspect the problem has been fixed long ago. Thanks. Ronny -- System Information: Debian Release: 6.0.5 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages mysql-server-core-5.1 depends on: ii libc6 2.11.3-3 Embedded GNU C Library: Shared lib ii libgcc1 1:4.4.5-8 GCC support library ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3 ii libwrap0 7.6.q-19 Wietse Venema's TCP wrappers libra ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime mysql-server-core-5.1 recommends no packages. mysql-server-core-5.1 suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org