List:General Discussion« Previous MessageNext Message »
From:Machiel Richards - Gmail Date:September 10 2012 1:35pm
Subject:Re: Temporary table creation fails
View as plain text  
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.richards@stripped>;
> *To: * Ananda Kumar <anandkl@stripped>;
> *Cc: * <mysql@stripped>;
> *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.richards@stripped <javascript:return> 
> <mailto:machiel.richards@stripped <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.richards@stripped <javascript:return> 
> <mailto:machiel.richards@stripped <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
> >>
> >>
> >
> >
>


Thread
Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsAnanda Kumar10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
                • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsRik Wasmus10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAnanda Kumar10 Sep
          • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
    • Re: Temporary table creation failsManuel Arostegui10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsShawn Green10 Sep