Hi,
It seems that the problem was the following:
In mysql_stmt_execute() sp_cache_flush_obsolete() is called to flush the
statement cache (or something similar). But the proper
sp_cache_routines_and_add_tables() functions won't be called from
open_tables(), because thd->lex->query_tables_own_las
mes Sherwood" <[EMAIL PROTECTED]>
Cc: "mysqllist"
Sent: Monday, June 19, 2006 11:56 AM
Subject: Re: Weird error when creating a field
James, that is a "permission denied" OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongs
James, that is a "permission denied" OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongside the old, then swaps them. Some file move/rename
perations are associated with that.
I would check that the mysql user on your system has full privileges on
James Sherwood schrieb:
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI"
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
Ja
Sent: Thursday, April 01, 2004 1:16 PM
To: Jason Chuong; [EMAIL PROTECTED]
Subject: Re: Weird Error message
It would really help if you could tell us at least which version of MySQL
you are using. It might also help to know which OS you are using and what
command you issued to get this error
It would really help if you could tell us at least which version of MySQL
you are using. It might also help to know which OS you are using and what
command you issued to get this error message.
Rhino
- Original Message -
From: "Jason Chuong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Se
perror 28
No space left on device.
I guess your disk is getting full.
John Wards wrote:
>Hi,
>
>I am getting a weird error message in mysql.
>
>I am doing this query
>
>SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
>WHERE t0.sid = t1.siteid AND t1.hold='no' AND t
John,
> and I am getting this error message
>
> ERROR 1030: Got error 28 from table handler
# perror 28
Error code 28: No space left on device
Free some disk space!
> I have figured out that it is t0.test that is causeing the problem as when i
> remove it the query works. This query has bee
Yup I used repair table as well.
Also I have resarted mysql and that made no difference
John
- Original Message -
From: "Karthik" <[EMAIL PROTECTED]>
To: "John Wards" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 11:11 AM
Subject: Re: Weird err
Hi All!
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
(Yes, I see the reserved word comments.)
Debug
Hi,
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
MATCH is a keyword... :) How did you manage to c
Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
- Original Message -
From: "Chris Ait
hi,
MATCH is a reserved word. Try to rename your table.
HTH.
Anton Tichawa.
> -Original Message-
> From: Chris Aitken [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: Weird Error Inserting
>
>
>
I'll bet somebody did a
cat afile > /usr/local/mysql/bin/mysql
instead of
cat afile | /usr/local/mysql/bin/mysql
That is why you should not be doing stuff as root.
s . keeling wrote:
> On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
>
>> so how to fix the error ?
>>
>> Ho
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
> so how to fix the error ?
>
> How did file /usr/local/mysql/bin/mysql
>
> become a text file ?
You tell us.
Regardless, is your data still intact? Make sure it's safe, rip out
mysql, and re-install.
Binaries don't just "b
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
chris
- Original Message -
From: "Lezz Giles" <[EMAIL PROTECTED]>
To: "christopher sagayam" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, Septemb
I'm not a mysql person, but I've seen similar stuff.
I think that for some reason Unix thinks that the file
you're trying to execute is not an executable, so it
is trying to run it as a shell script. Try this first:
file /usr/local/mysql/bin/mysql
and when it tells you that it is a text file,
Dejan,
It seems that you have to add "blahblahblah.com" to the hosts allowed to
connect to the server.
Check the privilegies table and add that domain to the list.
On Fri, 27 Jul 2001 22:49:32 -0700 "Dejan Nikic" <[EMAIL PROTECTED]> wrote:
| Warning: Host 'blahblahblah.com' is
18 matches
Mail list logo
