more
than a few hours of experience with the MySQL codebase can see some possible
pitfalls in this fix.
Thx
ImRe
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 23 November 2006 12:14
> To: 'mysql@lists.mysql.com'
> Subject: Weird error
Hi,
I am trying to use stored functions through the prepared statement C API. I
have one application that issues relatively long running queries, while the
other is doing some inserts, updates, and short queries. If the second
application somehow calls a stored function (either directly through
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
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,
James
Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may
be bigger than the available space in /tmp
Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table, a
Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:
Error Code : 1114
The table '#sql_910_0' is full
I read the following in the documentation:
http://dev.mysql.com/doc/mysql/en/full-table.html
But none of the reasons lis
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
lt;[EMAIL PROTECTED]>
Sent: Thursday, April 01, 2004 12:40 PM
Subject: Weird Error message
Hi All,
has anyone seen this error message before
040331 0:26:00 ft_read_next: Got error 127 when reading table ./
040331 0:26:38 ft_read_next: Got error 127 when reading table ./
040401 0:23:10 ft
Hi All,
has anyone seen this error message before
040331 0:26:00 ft_read_next: Got error 127 when reading table ./
040331 0:26:38 ft_read_next: Got error 127 when reading table ./
040401 0:23:10 ft_read_first: Got error 127 when reading table ./
040401 0:23:19 ft_read_next: Got error 127
>Description:
When I create a fulltext index I get:
ERROR 1005: Can't create table './inventory/#sql-4024_116c.frm' (errno: 140)
>How-To-Repeat:
alter table inventory.item add fulltext(storeId, catId, itemNo, title,
type, publisher, condition, color, subCategory, descri
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.site
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,
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 t0.test = 0 AND t1.synd = '1'
AND t0.sport='football' ORDER BY `
has anyone ever seen this MySQL error? The database has a high-traffic table
with about a million rows, is this the problem?
Warning: MySQL: Unable to save result set
TIA,
Sincerely,
Daren Cotter
CEO, InboxDollars.com
[EMAIL PROTECTED]
http://www.inboxdollars.com
(507) 382-0435
--
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
--
From: "Chris Aitken" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 12:08 PM
Subject: Weird Error Inserting
>
>
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) V
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
eam_id_2) VALUES ('1','3','2','3')' at line 1.
I have the above weird error when im trying to insert into a database. No
matter what I try, I cannot seem to find the error. Any suggestions that
im missing here. Its driving me nuts. th
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
e image that it should be.
>
> HTH
> Lezz Giles
> - Original Message -
> From: "christopher sagayam" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 31, 2001 3:01 PM
> Subject: weird error that I have not encountered in 2 years
>
>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 3:01 PM
Subject: weird error that I have not encountered in 2 years
> can anyone please tell me what is happening here ?
>
>
> [root@ns dump]# /usr/local/mysql/bin/mysql
> /usr/local/mysql/bin/mysql: DROP: command
can anyone please tell me what is happening here ?
[root@ns dump]# /usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysql: DROP: command not found
/usr/local/mysql/bin/mysql: syntax error near unexpected token `('
/usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
TABLE bad
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
Hi,
I worked with PHP and MySQL for about a year now, but this is the first time
I did my own MySQL instalation on my server instead of having it
preinstalled. This is when i got a very weird error that I've never seen
before.
Warning: Host 'blahblahblah.com' is not allowed to
29 matches
Mail list logo
