> summary of only 10,000 entries in the merge table and 50,000 entries in
> other
> tables. Does anybody experienced this strange problem, too?
Is the long query different than the other queries? Have you done an expain
on it?
> The last thing i found is a possible bug in merge-tab
Aaron Brick writes:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happens
> somewhere in the middle. i am using 3
tries in the merge table and 50,000 entries in other
tables.
Does anybody experienced this strange problem, too?
The last thing i found is a possible bug in merge-table implementation
of
2.23.41. After an update from 2.23.37 to 2.23.41 i got only the first
row
of the result set again and a
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happen
good day -
i have found cases in which the daemon blocks waiting on a select() and
just plain refuses to process certain queries. since i am reading in a 60
meg file, meaning about 3.5 million queries, this consistently happens
somewhere in the middle. i am using 3.23.41.
restarting the server o
Friend,
I learned that 8 + 4 = 12. Maybe you just missed that class ... :D
Before talk, think. ;)
On Thu, 26 Jul 2001 12:31:23 -0700 [EMAIL PROTECTED] wrote:
| 8.00user1
| 14.00 user2
| 160.00 user 3
|
| Now, where I went to school, this adds up to 184!
Cya
Antonio
[
Hello,
Today, I tried to move a part of one of my websites, a forum (vBulletin,
www.vbulletin.com) to a new server: a FreeBSD server. I installed the package
mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed
to work perfectly: installation complete, and phpM
riday, July 27, 2001 10:37 AM
Subject: Re: possible bug in sum() function
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> the query was:
>
> select sum(worktime),user from timecard where tcacct=project group by user;
>
> the answer was:
>
> 8.
Bruce Ferrell writes:
> I'm replying to the list because I got so many of these back:
>
>
>
> Ya know gang... some days it just doesn't pay to get outta bed.
>
> Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
>
> Sorry and to the guy who replied with no spam
Hehehehe.
- Original Message -
From: "Geoff Blake" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
> On Thu, 26 Jul 2001 [EMAIL PROTECTED]
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is ver
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> the query was:
>
> select sum(worktime),user from timecard where tcacct=project group by user;
>
> the answer was:
>
> 8.00user1
> 14.00 user2
> 160.00 user 3
>
> Now, where I went to school, this adds up to 184!
>
> Suggestions?
>
T
[EMAIL PROTECTED] writes:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who h
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
> select sum(worktime) from timecard where tcacct=project;
> The answer came back 182. Then I wa
[EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 5:31 AM
Subject: possible bug in sum() function
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who had spen
We keep a timecard database and I was just asked how much time had been charged to a
particular project code. No problem says I and did the following:
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had spent time on the project.
the qu
Hi!
One more question: does the query work if you remove
the ORDER BY? What does EXPLAIN say then?
Regards, Heikki
-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, July 03, 2001 9:44 PM
Subject: Re: Pos
I have the same problem with Mysql-3.23.39 compiled by myself
running in Linux box. However the problem goes away if I alter table
type from InnoDB to MyISAM. Therefore this problem is related with
InnoDB.
Here is the query which generates ERROR 1028: Sort aborted.
SELECT service.sowid,servdate,re
I would like to note that bug reports should only be sent out if you are
using the latest version, which now is 3.23.39.
--On Friday, June 15, 2001 17:37 -0600 Chris Bolt <[EMAIL PROTECTED]>
wrote:
>> After creating a new database, I ran:
>>
>> update user set password = 'SomeJunk' where user
Hello Simon.
On Fri, Jun 15, 2001 at 05:08:18PM -0400, [EMAIL PROTECTED] wrote:
> Could not find a bug report form. So I am telling y'll...
>
> Platform: FreeBSD 4.3 (I do not think it matters)
>
> After creating a new database, I ran:
>
> update user set password = 'SomeJunk' where user = '
> After creating a new database, I ran:
>
> update user set password = 'SomeJunk' where user = 'root';
>
> This inserts the string 'SomeJunk' literally into the database,
> unencrypted. This is SQL expected but the result is a database
> lockout (not to mention the security breach of having the c
PLEASE read the manual. you need to
set password = password('SomeJunk')
And the bug report form can be obtained by running mysqlbug, the instructions
for which are also found in the manual.
Thank you.
j- k-
On Friday 15 June 2001 13:08, Simon Shapiro wrote:
> Could not find a bug r
Could not find a bug report form. So I am telling y'll...
Platform: FreeBSD 4.3 (I do not think it matters)
After creating a new database, I ran:
update user set password = 'SomeJunk' where user = 'root';
This inserts the string 'SomeJunk' literally into the database,
unencrypted. This is S
I am running MySQL 3.23.37 compiled by myself on Linux platform.
Here is a repeatable example:
mysql> create table test (id int not null,
-> KEY id (id)) type=InnoDB;
mysql> SELECT id FROM test WHERE id<1;
ERROR 1032: Can't fi
ng
> a negative value in an autoincrement field is a Bad Thing
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 18, 2001 6:14 AM
> Subject: Possible bug in 3.23.32 or later
>
>
>>> Description:
As Far as I can remember it is explicitly said in the Manual that inserting
a negative value in an autoincrement field is a Bad Thing
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:14 AM
Subject: Possible bug in 3.23
>Description:
When i insert into a negative integer into primary key (id int) field, it
works fine.
However, the next insert i do without specifing the id explicitly and relying
on mysql to
generate the next number in the sequence (should be 1) will use the upper
bound (
gt;
>>From: Sasha Pachev <[EMAIL PROTECTED]>
>>To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
>>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>>Subject: Re: Problem - Possible Bug?
>>Date: Mon, 16 Apr 2001 08:25:26 -0600
>>MIME-Versio
as I said before I can give you root access on the machine which I believe
would be easier for you to disagnose the problem.
>From: Sasha Pachev <[EMAIL PROTECTED]>
>To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
>Subject: Re: Problem - Possible Bug?
>Date: Mon
On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote:
> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
> same problem, I upgraded to 3.23.36 today and it had the same problem. I
> have recompiled
Andrei Cojocaru writes:
> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
> same problem, I upgraded to 3.23.36 today and it had the same problem. I
> have recompiled mysql in full debug and done a
Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
same problem, I upgraded to 3.23.36 today and it had the same problem. I
have recompiled mysql in full debug and done a stack trace and it keeps on
cr
101 - 133 of 133 matches
Mail list logo
