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.richa...@gmail.com <mailto:machiel.richa...@gmail.com>> 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.richa...@gmail.com <mailto:machiel.richa...@gmail.com>>
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.richa...@gmail.com
<mailto:machiel.richa...@gmail.com>> 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