>I'm experiencing very strange innodb behavior.
>
> What version of mysqld?
>
About test system. FreeBSD 4.2, MySQL 3.23.49, my.cnf innodb settings:
===
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:2M
innodb_data_home_dir = /db/m
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "gbu" <[EMAIL PROTECTED]>
I'm experiencing very strange innodb behavior.
What version of mysqld?
-
Before posting, please check:
ht
ame_zero)
>+ block = buf_pool_get_nth_block(buf_pool, ((ulint)(ptr - frame_zero))
> >> UNIV_PAGE_SIZE_SHIFT);
> ut_a(block >= buf_pool->blocks);
> ut_a(block < buf_pool->blocks + buf_pool->max_size);
>
>- Original Message -
>From: "Heikki Tuuri
Shakeel,
this may be something with 32-bit unsigned integer / signed integer
arithmetic. I assume mysqld runs in the 32-bit mode?
Are you able to compile mysqld yourself? You could add the following to line
214 of mysql/innobase/include/buf0buf.ic
...
if (block < buf_pool->blocks) {
printf(
Bert --
Your problem is not the same as Shakeel's. For you, the database is
saying that it couldn't allocate memory. For Shakeel, it is saying that
an assert failed. At about line 213, there is a right shift (X >> Y)
that is occuring. The behavior of a right shift is different depending
o
CTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 4:42 PM
Subject: Re: innodb bug
> Shakeel,
>
> this may be something with 32-bit unsigned integer / signed integer
> arithmetic. I assume mysqld runs in the 32-bit mode?
>
> Are you able to compile mysqld
Ah, that makes sense. So it potentially could be the simple matter of
telling the compiler that the type is unsigned.
--shak
Chuck Simmons wrote:
> Bert --
>
> Your problem is not the same as Shakeel's. For you, the database is
> saying that it couldn't allocate memory. For Shakeel, it is
Hi,
I'm sort of glad we're not the only one having this problem.
Yesterday we had kind of the same error message on an Solaris 8 machine with
512Mb of ram.
Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by
the orion-web-server.
Today I will perform crash-tests on another
