This is a current production database with about 100Gb + of data and the
DB is extremely busy.
On 09/10/2012 12:08 PM, Akshay Suryavanshi wrote:
> Hi,
>
> If you dont have data on the server, would you please initialize the
> data directory.
>
> Use mysql-install-db and give proper data directory and proper cnf
> file if you are giving so.
>
> Also specify the user as root if you have root access.
>
> Thanks
>
> On Mon, Sep 10, 2012 at 3:34 PM, Machiel Richards - Gmail
> <machiel.richards@stripped <mailto:machiel.richards@stripped>> wrote:
>
> Hi,
> still no luck, same error being given immediately after
> pressing enter.
>
>
>
>
> On 09/10/2012 12:02 PM, Ananda Kumar wrote:
>
> start with 500MB and try
>
> On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail
> <machiel.richards@stripped
> <mailto:machiel.richards@stripped>
> <mailto:machiel.richards@stripped
> <mailto:machiel.richards@stripped>>> wrote:
>
> Hi, the sort_buffer_size was set to 8Mb as well as 32M
> for the
> session (currently 1M) and retried with same result.
>
>
>
>
>
> On 09/10/2012 11:55 AM, Ananda Kumar wrote:
>
> can you trying setting sort_buffer_size to big value
> at your
> session level and create the table
>
> On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail
> <machiel.richards@stripped
> <mailto:machiel.richards@stripped>
> <mailto:machiel.richards@stripped
> <mailto:machiel.richards@stripped>>>
>
> wrote:
>
> Hi
>
> We tried that as well, however the databases
> are quite
> busy and either other transactions overwrite the
> info, or
> there is nothing logged.
>
> We even tried running the create statement and
> immediately running Show innodb status, but
> nothing for that
> statement.
>
> Regards
>
>
>
>
>
> On 09/10/2012 11:05 AM, Ananda Kumar wrote:
>
> try this command and see if you can get more
> info about the
> error
>
> show innodb status\G
>
> On Mon, Sep 10, 2012 at 2:25 PM, Machiel
> Richards - Gmail
> <machiel.richards@stripped
> <mailto:machiel.richards@stripped>
> <mailto:machiel.richards@stripped
> <mailto:machiel.richards@stripped>>> wrote:
>
> Hi All
>
> I am hoping someone can point me in
> the right direction.
>
> We have a mysql 5.0 database which is
> giving us
> hassles when trying to create a temporary
> table.
>
> The creation works perfectly on the
> slave machine as
> well as all our other db's, however on the
> one specific
> main server we are getting the message
> "ERROR 1005
> (HY000): Can't create table
> '/tmp/#sql4a27_68eed1_0.frm'
> (errno: -1)"
>
>
> We have been trying to figure this
> out for more
> than a week now with no luck.
>
> When looking in the mysql error.log
> file, the
> innodb states that there is either another
> mysqld
> running (confirmed and not the case) or it
> is a
> filesystem permissions problem.
>
>
> We have checked several times and
> the permissions
> on the /tmp filesystem is the same as on
> all servers.
>
>
> Any suggestions would be greatly
> appreciated as
> google didnt help much either.
>
>
> Regards
>
>
> -- MySQL General Mailing List
> For list archives:
> http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
>
>
>
>
>
>
