List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:September 10 2012 2:10pm
Subject:Re: Temporary table creation fails
View as plain text  
On 9/10/2012 9:55 AM, Garot Conklin wrote:
> Not to beat the perms to death but /tmp should have the sticky bit set as well... so
> 1777 not just 0777.  Perhaps hard kill any lingering mysql PIDS unless this is production
> and u expect other DB's to be running... if u have duplicated this DB schema somewhow by
> mistake and a second or first identical instance is running it is plausable to assume that
> the other running instance has locked the file it is using preventing it from being
> written to.
>
>

Excellent point! Yes, you can have multiple MySQL instances running on 
the same host machine but they cannot share the same --tmpdir location. 
Name collisions can and do occur between them if they attempt to share a 
common folder. Verify that you have properly isolated each instance from 
every other by following these guidelines:
http://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html

-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN


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