Hello.
Please, could you send a more detailed report. Include information
about MySQL and operating system versions. See:
http://dev.mysql.com/doc/mysql/en/Bug_reports.html
You may want to force a recovery. See:
http://dev.mysql.com/doc/mysql/en/forcing-recovery.html
Pierre-Henry
Hi!
On Aug 01, Helge Jung wrote:
Description:
When I start up my fresh compiled mysqld it crashes immediately, the
error log file says:
It was reported just a few hours ago at bugs.mysql.com
(which is the recommended way to report bugs, by the way :)
you may follow the progress using
Eric,
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
please use the resolve_stack_dump program in combination with the
Nils Wisiol wrote:
hi
There is a Bug in the InstallWizard Engine. If I install mysql on my winxp
professional system WITHOUT sp1, install shield say goodbye when the setup is almost
ready. i've tried custom and completly installation. maybe its a failied download.
the mysql version is:
Johnson, David C [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: LIMIT of 1000 rows returned on SELECT (2nd try)
Description:
When doing a query on a table with more than 1000 rows,
the SELECT * query returns only the first 1000 rows.
Do
On 26 Mar 2003 at 9:23, Alejandro Paz wrote:
As you can see the colum `b' is updated, too.
Note, you have to insert a delay of almost 1 second
between the first select
and the update, because the column `b' takes the
current time!.
Only happens with timestamp columns not with datetime
Keith,
please upgrade to 3.23.55. Your MySQL version is very old.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
- Original Message
On Wed, Jan 15, 2003 at 11:44:24AM +1100, Daniel Kasak wrote:
Hi all,
I recently had to restore from a backup and discovered that mysql didn't
want to re-create a table which had the minus symbol (-) in it, eg
Yeah, you need to quote such names now.
Upgrade your version of mysqldump and
MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing
Adam,
in your earlier message you quoted 3 log files, but below in the printout it
says 2 log files. Best to do
SHOW VARIABLES;
and check from the current directory innodb_log_group_home_dir how many
ib_logfiles there really are.
030107 06:42:58 mysqld started
/usr/local/mysql/bin/mysqld:
Matt,
I am forwarding this to MySQL developers.
Problem description:
MySQL does not return key information about any column after the first
in a unique multi-column key. Also, the MUL flag seems to indicate
that the key is non-unique, when in fact it is.
This output
At 16:44 -0800 12/27/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
Christopher,
- Original Message -
From: Christopher Stephan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, December 21, 2002 6:00 PM
Subject: Bug Report
Hello,
following problem occurs using MySql.
Can you help me with that Error?
this is memory corruption,
: Henry Bequet
Subject: Re: Bug report: Embedded MySQL version 4.05a
At 15:39 -0800 12/10/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs
At 15:39 -0800 12/10/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET
http://www.mysql.com
sql query
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 12:24 AM
Subject: Re: Bug Report: Replication in 4.0.5beta
Michael,
I have been running tests on 4.0.6 with big insert
Subject: Re: Bug Report: Replication in 4.0.5beta
Michael,
- Original Message -
From: Michael Ryan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 12:34 PM
Subject: Bug Report: Replication in 4.0.5beta
The environment info was copied from
Michael,
- Original Message -
From: Michael Ryan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 12:34 PM
Subject: Bug Report: Replication in 4.0.5beta
The environment info was copied from the mysqlbug command by our
external
hosting company who
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all MySQL modules, like
Monty instructed a week ago. But I guess that
PROTECTED]
Cc: Henry Bequet
Subject: Re: Bug report: Embedded MySQL v4.04b
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does
not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all
Angeloluca,
Tuesday, November 19, 2002, 12:21:58 PM, you wrote:
AdBamdc I have a problem with key creation :
AdBamdc Server version: 4.0.4-beta-max-nt Binary version
AdBamdc PC : DELL OPTIPLEX GX100
AdBamdc OS : Windows 2000 Professional
AdBamdc RAM: 256 Mb
[skip]
AdBamdc 236 Is the maximum
Matt,
since you are using InnoDB, you cannot call server_end() and server_init()
again during the lifetime of the process. InnoDB does not clean up its
internal data structures in server_end().
Is there some special reason you would need to shut down the server and
open it again?
Regards,
Heikki
: Egor Egorov [EMAIL PROTECTED]
D To: [EMAIL PROTECTED]
D Sent: Saturday, October 19, 2002 6:35 AM
D Subject: re: Bug report
Douglas,
Saturday, October 19, 2002, 1:08:14 AM, you wrote:
D INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different
D size
D INNODB: than specified
Douglas,
Saturday, October 19, 2002, 1:08:14 AM, you wrote:
D INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
D INNODB: than specified in the my.cnf file!
D INNODB:Assertion failure in thread 138207232 in file os0file.c
D send bug report to [EMAIL PROTECTED]
D mysqld
Quasimodo wrote:
This occured while using phpmyadmin 2.3.0-rc4:
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
[snip]
This is reporting a bug in
This is documented behavior.
Indexes are not used with DESC.
Ver 4.X does, however support DESC with an index.
Grigoriy Vinogradov wrote:
Bug Report:
Version: 3.23.51-max
OS: Windows ME
Problem:
Synopsis: Does not use index when ordering records on datetime field in
the descending order, even
Sergey S. Kostyliov writes:
Description:
Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege
not working
ERROR 1142
How-To-Repeat:
1) (under root)
mysql GRANT CREATE TEMPORARY TABLES ON *.* TO
test_user@localhost IDENTIFIED BY 'test_pass';
Sergey S. Kostyliov writes:
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
snip
Note:
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote:
Sergey S. Kostyliov writes:
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
How-To-Repeat:
select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
s.nick, s.address, s.contact_person, s.email,
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
snip
Note:
The same results with oficial
Hi!
- Original Message -
From: Wan YU [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, June 27, 2002 8:25 PM
Subject: BUG REPORT FOR MYSQL
Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think it will be
Patrice,
Thursday, April 04, 2002, 4:41:24 AM, you wrote:
P MySQL Version: 3.23.49
P OS: Win 98
P Query 1: select length ('abc') returns
P You have an error in your SQL syntax near '('abc')' at
P line 1
P Query2: select length('abc') returns 3: OK
P Note the space between the 'h' and '(' in
Legault, Alain writes:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
Subject: Mysqld hangs on initialization with mysql_install_db.
Hi!
A usual cause for the above
Legault, Alain writes:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
Subject: Mysqld hangs on initialization with mysql_install_db.
Hi!
A usual cause for the above
Michael Cook writes:
Hi folks,
Here is a bug report using the bug tool...
[skip]
Thanks!!!
Michael
== CigarPool ==
http://www.cigarpool.com
Hi!
You should check why your configure is broken.
Instead of lines :
configure:1592: checking whether the C++ compiler (c++
Hi Rick,
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Description:
The SELECT statement fails to recognize that an alias (mycol) was set for a
column. Note the column name is created from a table alias (c1)
mysql select c1.id as mycol from colors c1 right join colors
At 10:33 05/09/2001 +0200, abadon wrote:
Hi,
Hi,
I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver (
http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to
Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server
( Client API version 3.23.32
Hi!
What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.
Regards,
Heikki
At 05:40 PM 8/4/01 +0300, you wrote:
Content-Type: message/rfc822
Content-Description: forwarded message
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
Content-Type: text/plain;
]; [EMAIL PROTECTED]
Subject: Re: Bug report.
Hi!
What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.
Regards,
Heikki
At 05:40 PM 8/4/01 +0300, you wrote:
Content-Type: message/rfc822
Content-Description: forwarded message
Content-Transfer-Encoding: 7bit
MIME-Version
Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 1:49 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi!
3.23 (but 4.0 hasn't that bug either).
Will be 2.23.40 soon.
And have nice trip, btw.
On Jul 20, Carsten Gehling
Carsten Gehling writes:
I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
work!
Now I only wait for the Win32 binary to be released. I didn't think there
were any delays between the releasins anymore?
- Carsten
Thanks for the compliments.
Win32 binaries will
I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through your MySQL on an empty database with
mysql -uusername -ppassword dbname scriptname
and the last command
Thanks for your bug report.
I am sure Sergei will have the answer before you come back from Spain ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_,
Hi!
Ok, confirmed (finally :-) )
My fault was that I was using our latest developmnet tree.
When I've tried this on 3.23.39 as went public, the bug appeared.
So, looks like the bug was fixed even before it was found :-)
Probably, it is somehow related to over bug I've fixed
since 3.23.39
20, 2001 12:06 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through
||
|||
++-+---+---+-++-+-+---+-
-+-+-+---+--+--+-+--
--++++
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Sergei Golubchik [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 12:06 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Which dev. tree is that? 3.23 or 4.0?
- Carsten (who hasn't left yet ;-)
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 1:22 PM
Subject: Re: Bug report: FULLTEXT index corrupts
Hi!
3.23 (but 4.0 hasn't that bug either).
Will be 2.23.40 soon.
And have nice trip, btw.
On Jul 20, Carsten Gehling wrote:
Which dev. tree is that? 3.23 or 4.0?
- Carsten (who hasn't left yet ;-)
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
Subject: Re: Bug
Hi
Where can we get V4.0?
Thanks Simon
-Original Message-
From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 12:30
To: Carsten Gehling; Sergei Golubchik
Cc: [EMAIL PROTECTED]
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT
: Friday, July 20, 2001 2:55 PM
Subject: RE: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi
Where can we get V4.0?
Thanks Simon
-Original Message-
From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 12:30
To: Carsten Gehling
Hi!
On Jul 19, Carsten Gehling wrote:
Finally I was able to produce a complete step-by-step to corrupt the index
;-)
mysql insert into visitkort (kategori_id) values (108);
mysql select last_insert_id();
mysql update visitkort set navn = 'test5' where id = 1;
mysql update visitkort set
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 6:26 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi!
On Jul 16, Carsten Gehling wrote
]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 6:26 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi!
On Jul 16, Carsten Gehling wrote:
Description:
A specific table (see How-To-Repeat) with a FULLTEXT index causes
errors in
the MYI file when
Hi!
On Jul 16, Carsten Gehling wrote:
Description:
A specific table (see How-To-Repeat) with a FULLTEXT index causes errors in
the MYI file when inserting new rows.
1) Create the following table:
CREATE TABLE `visitkort` (
[skip]
) TYPE=MyISAM;
2) Insert a row with the following
Werner Stuerenburg writes:
_
Win98 4.10.98, AMD Duron, 128 MB RAM
MySQL 3.23.39 running on localhost
_
Query is
DELETE FROM staticStrings
WHERE ruri LIKE
At 00:13 10/06/2001 +0900, atsushi wrote:
Hi,
The problem reported happens on Win9x and ME platform because
mysqld.exe was compiled accidentally with a __NT__ define for
the InnoDB library.
Use instead the mysqld-max.exe server on these OSs.
This issue is already fixed for the next release.
George Mihalcea writes:
Hello!
I compiled mysql 3.23.38 with support for innodb tables.
The server is a dual PIII 850, with 1 GB RAM, 1 SCSI disk.
OS is Slackware current . Kernel version is 2.4.4 , no patches.
I created 4 tablespaces of 1000M each.
I took a dump from another mysql server
George,
this is the bug that slipped into the rollback code in .38.
You can download a patch from my website
http://www.innobase.fi/bugfixes.html
You are running out of tablespace when doing the table import.
MyISAM tables take a lot more space when converted to the InnoDB
type. Make your
Can you try this with a more recent MySQL version?
I cannot reproduce it here, on FreeBSD 4.3 running MySQL 3.23.38.
G'luck,
Peter
--
This sentence contains exactly threee erors.
On Tue, May 22, 2001 at 08:32:24PM +0300, Tarog Adrian wrote:
Hello,
I think me and my fellows here at office,
That is pretty old.
3.23.38 works fine.
Tarog Adrian wrote:
Hello,
I think me and my fellows here at office, found a bug in mysql.
The system is:
RedHat 7.0, kernel 2.2.16, on Celeron 700MHz
mysql version 3.23.22
Here is the script:
(
cat EOF
connect test;
create table test (i
Thanks for the hint. I'll try it with more tablespace.
The indexes have been optimized pretty much. I have to check whether I
can send you the table layout.
Just for your information. 3.23.38 has the same problem.
Heikki Tuuri wrote:
Frank,
there is obviously a bug in the insert buffer code
On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
Is there a way of turning the transactional logging off during the
load of a table? I know that I'm out on my own then but this table
is loaded only every once in a while.
Am I running out of space on the log/or data files?
Oops,
I read the file size wrong in the printout. It was only
300 MB. Then we can suspect that you ran out of disk space.
But knowing the MySQL version would help.
Regards,
Heikki
...
Eugene,
does your operating system support
Max file size is 300M, not 2G. Isn't it?
B.R. Eugene
On Tue, 15 May 2001, Heikki Tuuri wrote:
Eugene,
does your operating system support over 2 GB files?
Which MySQL version you are running? What is the opeerating system?
I guess the problem is that the OS does not support over 2 GB
mysql Ver 11.15 Distrib 3.23.37, for sun-solaris2.7 (sparc)
SunOS 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-5_10
On Tue, 15 May 2001, Heikki Tuuri wrote:
Hi!
Ok, the error turned out to be out of disk space. But for some reason
the error handling code in os0file.c did not recognize
Hi
Try
select from_days(to_days(curdate())-1);
+-+
| from_days(to_days(curdate())-1) |
+-+
| 2001-04-30 |
+-+
1 row in set (0.00 sec)
Simon
On Tuesday 01 May 2001 14:45,
Aurelian Dumitru [EMAIL PROTECTED] wrote:
Please record the following bug identified on the MySQL server:
1. Hardware: SUN Ultra 10
2. Operating system: Sun Solaris 2.7
2. MySQL server version: 3.23.33
3. Error description:
- The following SQL statement returns incorrect results when
For over a year the topic of mathematical operations on date values
has been disussed. It has never been possible to perform such math
on a date value without using DATE_ADD or converting the to days or
seconds first.
Why is this now all the sudden a reasonable bug?
Aurelian:
I suggest that
Steve Ruby writes:
For over a year the topic of mathematical operations on date values
has been disussed. It has never been possible to perform such math
on a date value without using DATE_ADD or converting the to days or
seconds first.
Why is this now all the sudden a reasonable bug?
Hello Aurelian,
I do the same thing but use the following code and it works fine.
SELECT @myvar := DATE_SUB( CURRENT_DATE, INTERVAL 1 DAY) ;
Edward
5/1/2001 6:45:19 AM, Aurelian Dumitru [EMAIL PROTECTED] wrote:
Please record the following bug identified on the MySQL server:
1.
Andrew Schmidt writes:
Description:
tough one to describe. the step by step example shows all
basicly once a table gets more than 1 row and doing a select with no
result will yield a blank date... gah please see the example =)
How-To-Repeat:
create database tmpdb;
use tmpdb;
Verified. this is a bug
empty table or 1 record returns expected result, insert one more record and
the result of now() is empty.
mysql select now(), count(*) from t where a in (2);
| now() | count(*) |
| 2001-04-21 08:12:03 |0 |
1 row in set (0.00 sec)
mysql insert
On Sun, Apr 08, 2001 at 12:22:32PM -0500, Rodrigo Zerlotti wrote:
Description:
INSTALL-BIN file has errors:
shell chown -R mysql /usr/local/mysql/var
it should be
chown -R mysql /usr/local/mysql/data
instead "var"
Thanks, Rodrigo. I have fixed it now.
Tim
--
__
Daren Cotter writes:
Sorry to post AGAIN, but I have new info. I was monitoring the Error Log,
and when I run the query that crashes MySQL, I get the following error:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the
75 matches
Mail list logo
