Hi,
permissions are confirmed as being correct. Other applications and
users are currently writing files to this directory yes.
The only thing found in the log is innodb error 13 stating that
either a second mysqld is running or that there is a filesystem
permissions issue.
I have now changed the mysql tmp directory and will be restarting
tonight to let it take effect.
Will keep everyone updated tomorrow.
Regards
On 09/10/2012 03:32 PM, Garot Conklin wrote:
Apologies if I missed this in the thread but have you confirmed not
only the effectve perms for the directory but that another user can
write to this dirrectory? Perhaps outside of mysql for instance; I.e.
other processes are successfully writting logs to /tmp? Anything to
share from the mysql logs perhaps?
Sent from Yahoo! Mail on Android
------------------------------------------------------------------------
*From: * Machiel Richards - Gmail <machiel.richa...@gmail.com>;
*To: * Ananda Kumar <anan...@gmail.com>;
*Cc: * <mysql@lists.mysql.com>;
*Subject: * Re: Temporary table creation fails
*Sent: * Mon, Sep 10, 2012 12:41:51 PM
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 <javascript:return>
<mailto:machiel.richa...@gmail.com <javascript:return>>> 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 <javascript:return>
<mailto:machiel.richa...@gmail.com <javascript:return>>>
>> 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
>>
>>
>
>
