 | | | Subject: Re: sporadic error 13 on windows | Subject: Re: sporadic error 13 on windows 2007-11-02 - By Artem Kuchin
Back
Baron Schwartz wrote:
> What do you get from the following:
>
> mysql> show variables like '%tmp%';
1) if i set
tmpdir=C:/temp
it shows:
mysql> show variables like '%tmp%';
+-- ---- ---- ------+-- ---- ---+
| Variable_name | Value |
+-- ---- ---- ------+-- ---- ---+
| max_tmp_tables | 32 |
| slave_load_tmpdir | C:\temp\ |
| tmp_table_size | 527433728 |
| tmpdir | C:/temp |
+-- ---- ---- ------+-- ---- ---+
4 rows in set (0.00 sec)
Got error
DBD::mysql::st execute failed: Can't create/write to file '#sql_8c4_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN> line
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
1) if i set
tmpdir=C:\\temp
(setting C:\Temp result in C:<TAB>emp, so it must be \\)
mysql> show variables like '%tmp%';
+-- ---- ---- ------+-- ---- ---+
| Variable_name | Value |
+-- ---- ---- ------+-- ---- ---+
| max_tmp_tables | 32 |
| slave_load_tmpdir | C:\temp\ |
| tmp_table_size | 527433728 |
| tmpdir | C:\temp |
+-- ---- ---- ------+-- ---- ---+
4 rows in set (0.00 sec)
got errors
DBD::mysql::st execute failed: Can't create/write to file 'C:\Program Files
\MySQL\MySQL Server 5.0\Data\#sql_150c_0.MYI' (Errcode:
13) at cleanfilestore.pl line 89, <STDIN> line 1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
DBD::mysql::st execute failed: Can't create/write to file '#sql_150c_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN> line
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
DBD::mysql::st execute failed: Can't create/write to file '#sql_150c_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN> line
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
1) if i set
tmpdir=C:\\temp\\
+-- ---- ---- ------+-- ---- ---+
| Variable_name | Value |
+-- ---- ---- ------+-- ---- ---+
| max_tmp_tables | 32 |
| slave_load_tmpdir | C:\temp\ |
| tmp_table_size | 527433728 |
| tmpdir | C:\temp\ |
+-- ---- ---- ------+-- ---- ---+
4 rows in set (0.20 sec)
DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN>
ine 1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN>
ine 1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD'
(Errcode: 13) at cleanfilestore.pl line 89, <STDIN>
ine 1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
cleanfilestore.pl line 90, <STDIN> line 1.
Two points here
1) The number of errors is different, rerunning the script will result in
different number of errors and sometimes no errors
at all, so, this error is unstable and sporadic
2) As you see file mentioned in the error message is sometime in uknown dir
(like '#sql_948_0.MYD' ) and sometimes
in 'C:\Program Files\MySQL\MySQL Server 5.0\Data\
HELP!
--
Artem
> Artem Kuchin wrote:
>> anyone any idea on this ?
>>
>>>> On 10/31/07, Artem Kuchin <matrix@(protected)> wrote:
>>>>> I am running
>>>>> Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
>>>>> on WIndows 2003 R2 Service Pack 2 Standard Edition
>>>>>
>>>>> I have a database dig perl script with basically does a lot of
>>>>> SELECT [somefield] as tt FROM table;
>>>>>
>>>>>
>>>>> When i run it i get:
>>>>>
>>>>> DBD::mysql::st execute failed: Can't create/write to file
>>>>> 'C:\Program Files\MySQL\MySQL Server 5.0\Data\#sql_bdc_0.MYI'
>>>>> (Errcode
>>>>>> 13) at cleanfilestore.pl line 89, <STDIN> line 1.
>>>>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at
>>>>> cleanfilestore.pl line 90, <STDIN> line 1.
>>>>> DBD::mysql::st execute failed: Can't create/write to file
>>>>> 'C:\Program Files\MySQL\MySQL Server 5.0\Data\#sql_bdc_0.MYI'
>>>>> (Errcode
>>>>>> 13) at cleanfilestore.pl line 89, <STDIN> line 1.
>>>>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at
>>>>> cleanfilestore.pl line 90, <STDIN> line 1.
>>>>> DBD::mysql::st execute failed: Can't create/write to file
>>>>> '#sql_bdc_0.MYD' (Errcode: 13) at cleanfilestore.pl line 89,
>>>>> <STDIN> l ine 1.
>>>>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at
>>>>> cleanfilestore.pl line 90, <STDIN> line 1.
>>>>>
>>>>>
>>>>> I have
>>>>> [mysqld]
>>>>> tmpdir=C:/temp
>>>>>
>>>>> in my.ini
>>>>>
>>>>> SO, first of all, why is it trying to create something in Programe
>>>>> files?
>>>>> Why there are files w/o path at all (Can't create/write to file
>>>>> '#sql_bdc_0.MYD') ?
>>>>>
>>>>> These error accure at different moments every time script is run.
>>>>>
>>>>> Anynow any idea what's going on here?
>>>>>
>>>>> TEMP has full rights for ALL. But anyway, as you see, it is not
>>>>> even mentioned here.
>>
>>
>>
>>
>
> --
> Baron Schwartz
> Xaprb LLC
> http://www.xaprb.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|