please share the command ur using to create the temp table On Mon, Sep 10, 2012 at 6:11 PM, Machiel Richards - Gmail < machiel.richa...@gmail.com> wrote:
> 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> 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> 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 >>> >>> >> >> > >