Can't open privilege tables

2005-07-10 Thread Tim Johnson
Using 4.0.20 on Slack 10.0 New setup. mysql_install_db was run. On startup, the error log shows the following error message: """ Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) """ It would appear the paths are not being set.

Re: Innodb crash on failed read disk

2005-07-10 Thread Per Andreas Buer
Ady Wicaksono <[EMAIL PROTECTED]> writes: > Dear All > > I use RedHat 9 with 2,5 Gbyte RAM, Intel(R) Xeon(TM) CPU 2.80GHz > (Hyperthread), > filesystem ext3 standar linux journaling filesystem. > > Today my DB is crash :(, here is the log. Could it be that our stacks and your heaps might have m

Re: innodb crashes during heavy usage with exceeded memory error

2005-07-10 Thread Per Andreas Buer
Kasthuri Ilankamban <[EMAIL PROTECTED]> writes: > Hi, We are running mysql version 4.1.7 with innodb on i686 running > 2.4.26 linux kernal with 8G memory. Mysql crashes consistently during > heavy usage with fatal innodb error. We are running a high volume front > end application which inserts

Re: MyISAM vs InnoDB ----- Incorrect key file for table error

2005-07-10 Thread Per Andreas Buer
"Praveen KS" <[EMAIL PROTECTED]> writes: > In a table of 20,000 records I am frequented with this error: > > Error 1034: > Incorrect key file for table: ''; try to repair it > > Frequency of this error: Three or four times a week. > I am logging the data it was trying to insert or update. Af

Re: Issue with AS and sub queries

2005-07-10 Thread Gleb Paharenko
Hello. Please can you send the complete query and table definition, because I was unable to reproduce this weird behavior. What version of MySQL do you use? What client do you use to execute queries? We can see below, that there is no period before total_bandwidth: mysql> select (SELECT S

Re: how i can log client connections?

2005-07-10 Thread Gleb Paharenko
Hello. This issue has been raised in the list already before, however I don't remember that good solution was found. And without queries which was executed these log records don't give any useful information in most production environments. Francesco Dalla Ca' <[EMAIL PROTECTED]> wr

problem with LEFT JOIN

2005-07-10 Thread Juan Pablo Espino
Hello all! I have two tables in my database: results(20 000 rows) and data_lab1(3 000 rows) Both are related by a sample number (sample_id.) I need to find the samples of data_lab1 table that they are not in results table. I think the following query is the solution: SELECT data_lab1.sample_id,

Re: possible BUG in 'between' comparisons

2005-07-10 Thread Lester Hightower
I have confirmed that this problem exhibits itself on the Mysql AB compiled binaries that are compiled with gcc, both Standard and Max, but does _not_ exhibit itself on the Mysql AB binary built with the Intel C++ Compiler 8.1 (mysql-standard-4.1.12-pc-linux-gnu-i686-icc-glibc23.tar.gz). I have al

Re: MyISAM vs InnoDB ----- Incorrect key file for table error

2005-07-10 Thread Gleb Paharenko
Hello. >mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686) You have an old MySQL version which contains lots of bugs (it's an alpha!). I strongly recommend you to upgrade to the latest release (4.1.12 now) and use official binaries. >Hi, > > >In a table of 20,000 records I a

Calculating a running balance

2005-07-10 Thread doug
I am using MySQL 4.0.22 and have a question about an efficient way to calculate a running balance as part of the select. The natural way to do this would seem (to me) to be something like: set @balance:=0; select payid,Custid,Paid,@balance:[EMAIL PROTECTED] from payments; This does indeed see

Report

2005-07-10 Thread heidi16
The original message was received at Thu, 7 Jul 2005 09:34:11 +0200 from 35.120.172.60 - The following addresses had permanent fatal errors - - Transcript of session follows - ... while talking to server 92.244.150.42: 554 5.0.0 Service unavailable; [129.158.164.155] blocked usi