no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have also gone through the firewall settings and that is only rules
for connections.
On 09/10/2012 02:40 PM, Ananda Kumar wrote:
did u check if there any firewall settings, forbidding you to create
files, check if " SELinux is disabled"
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail
<machiel.richa...@gmail.com <mailto:machiel.richa...@gmail.com>> wrote:
Hi
at the moment this does not really matter to us.
we have even tried to create a temp table with only one field
in order to insert one row for testing, but we are currently not
able to create any temporary tables whatsoever as even the
simplest form of table still gives the same error.
Regards
On 09/10/2012 02:33 PM, Ananda Kumar wrote:
this temp table will hold how many rows, what would be its size.
On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail
<machiel.richa...@gmail.com <mailto:machiel.richa...@gmail.com>>
wrote:
Hi,
We confirmed that the /tmp directory permissions is set
to rwxrwxrwxt and is owned by root , the same as all our
other servers.
There is also about 60Gb of free space on the filesystem
where /tmp resides.
Regards
On 09/10/2012 01:11 PM, Rik Wasmus wrote:
the message "ERROR 1005 (HY000): Can't create table
'/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
Basics first:
1) Is the /tmp directory write & readable for the user
mysql runs as?
2) Has the /tmp directory enough free space?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql