Warning when I start mysqld

2003-04-04 Thread Santiago Alba 
Howdy all!!

I have installed a mysql server release 4.0.12-log on Linux i686. I used the source 
distribution. 

When I executed mysql_install_db for creating db appeared a error message which it 
said:

Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier 
on the command line

In spite of everything looks work OK. But now, when I start mysql server into file 
.err we can see the same message!!

Could anybody help me? Is it normal?

Thanks in advance.

RE: Mysql - Upgrading from 3.23.53 to 3.23.54

2002-12-17 Thread Santiago Alba 
Please, anybody could help me with this?

Anybody have upgraded its MySQL release from 3.23.53 to Mysql release
3.23.54... I need to upgrade for fixing a bug in 3.23.53 and  I would like
to know if it necesary to reinstall as the one solution.

Thanks a lot.

- Original Message -
From: Santiago Alba [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 16, 2002 3:24 PM
Subject: Mysql - Upgrading from 3.23.53 to 3.23.54


Hi,

I have installed  MySQL 2.23.53 release and I want to upgrade to MySQL
2.23.54... how can
I do this? Have i got to reinstall? Is there any script?

Any suggest?

Thanks in advance















-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Mysql - Upgrading from 3.23.53 to 3.23.54

2002-12-17 Thread Santiago Alba 
I installed binary version (source distribution)... not with rpm


- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:02 PM
Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54


On Monday 16 December 2002 16:24, Santiago Alba wrote:

 I have installed  MySQL 2.23.53 release and I want to upgrade to MySQL
 2.23.54... how can
 I do this? Have i got to reinstall? Is there any script?

As usual ;)

Seriously speaking - depends on the way have you installed it.



--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Mysql - Upgrading from 3.23.53 to 3.23.54

2002-12-17 Thread Santiago Alba 
Sorry, but I don´t understand you... I have no idea, if you don't mind you
could be more expecific...

Thanks a lot for your answer.

- Original Message -
From: Ireneusz Piasecki [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:20 PM
Subject: Re: Mysql - Upgrading from 3.23.53 to 3.23.54


Hi.

You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of
hours to discover, why source rpm 3.23.54a don't rebuild )
autoconf is 2.52
libtool is 1.4.3

Regards.



- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:02 PM
Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54


 On Monday 16 December 2002 16:24, Santiago Alba wrote:

  I have installed  MySQL 2.23.53 release and I want to upgrade to MySQL
  2.23.54... how can
  I do this? Have i got to reinstall? Is there any script?

 As usual ;)

 Seriously speaking - depends on the way have you installed it.



 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--r-e-k-l-a-m-a-

Masz dosc placenia prowizji bankowi ?
mBank - zaloz konto
http://epieniadze.onet.pl/mbank

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql - Upgrading from 3.23.53 to 3.23.54

2002-12-16 Thread Santiago Alba 
Hi,

I have installed  MySQL 2.23.53 release and I want to upgrade to MySQL
2.23.54... how can
I do this? Have i got to reinstall? Is there any script?

Any suggest?

Thanks in advance















-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Replication problems

2002-07-15 Thread Santiago Alba 

Thanks a lot. I've fixed my problems with this.

Best regards.

- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Santiago Alba [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 12, 2002 3:53 PM
Subject: Re: Replication problems


Did you copy the master.info file over too?


Santiago Alba wrote:

Hi All,

I had a system replication on Linux consisting of MASTER and only one
SLAVE.
I stopped replication, I did a backup on my slave and it recreated in
another machine so now I have two SLAVES connected to database MASTER.

But I found problems. I show you the output on my database MASTER and SLAVE
who is failed:

***

MASTER

mysql show master status;
+-+--+--+--+
| File| Position | Binlog_do_db | Binlog_ignore_db |
+-+--+--+--+
| log.101 | 54557|  |  |
+-+--+--+--+
1 row in set (0.00 sec)


SLAVE:

mysql show slave status;
+--+-+-+---+---
-
--+-+---+-+-+--
-
-++--+
| Master_Host  | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db |
Last_errno | Last_error | Skip_counter |
+--+-+-+---+---
-
--+-+---+-+-+--
-
-++--+
| spiderman.terravista.srv | replica | 3306| 60|
| 4   | Yes   | | | 0
|
| 0|
+--+-+-+---+---
-
--+-+---+-+-+--
-
-++--+
1 row in set (0.00 sec)


mysql show processlist;
++-+---+--+-+--+---
-
--+--+
| Id | User| Host  | db   | Command | Time | State
| Info |
++-+---+--+-+--+---
-
--+--+
|  1 | system user | none  | NULL | Connect | 7729 | Waiting to
reconnect after a failed read | NULL |
|  2 | root| localhost | NULL | Sleep   | 337  |
| NULL |
|  3 | root| localhost | NULL | Query   | 0| NULL
| show processlist |
++-+---+--+-+--+---
-
--+--+

In errors log:

020712 12:43:40  Error reading packet from server: Could not open log file
(server_errno=2)
020712 12:44:40  Slave: Failed reading log event, reconnecting to retry,
log
'FIRST' position 4
020712 12:44:40  Slave: reconnected to master
'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST'
at position 4
020712 12:44:40  Error reading packet from server: Could not open log file
(server_errno=2)
020712 12:45:40  Slave: Failed reading log event, reconnecting to retry,
log
'FIRST' position 4
020712 12:45:40  Slave: reconnected to master
'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST'
at position 4
020712 12:45:40  Error reading packet from server: Could not open log file
(server_errno=2)

my.cnf:

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=1M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
set-variable= myisam_sort_buffer_size=64M
#log-bin= /mysql/log/log.nnn
server-id   = 3

master-host = spiderman.terravista.srv
master-user = replica
master-password = x

***

Any suggestion?

Thanks in advance.

Santiago.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Replication problems

2002-07-15 Thread Santiago Alba 

Hi,

That wasn't the problem. The problem was in master.info file.

Thanks a lot.

- Original Message -
From: Ralf Narozny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 12, 2002 4:39 PM
Subject: Re: Replication problems


Hello!

You will get problems when you set the 2nd slaves server-id the same as
other one. server-ids MUST be unique...once made that mistake too...

Greetings
 Ralf

Gerald Clark wrote:

 Did you copy the master.info file over too?


 Santiago Alba wrote:

 Hi All,

 I had a system replication on Linux consisting of MASTER and only one
 SLAVE.
 I stopped replication, I did a backup on my slave and it recreated in
 another machine so now I have two SLAVES connected to database MASTER.

 But I found problems. I show you the output on my database MASTER and
 SLAVE
 who is failed:

 ***

 MASTER

 mysql show master status;
 +-+--+--+--+
 | File| Position | Binlog_do_db | Binlog_ignore_db |
 +-+--+--+--+
 | log.101 | 54557|  |  |
 +-+--+--+--+
 1 row in set (0.00 sec)


 SLAVE:

 mysql show slave status;

+--+-+-+---+

 --+-+---+-+-+
---

 -++--+
 | Master_Host  | Master_User | Master_Port | Connect_retry |
 Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db |
 Last_errno | Last_error | Skip_counter |

+--+-+-+---+

 --+-+---+-+-+
---

 -++--+
 | spiderman.terravista.srv | replica | 3306| 60|
 | 4   | Yes   | | |
 0  |
 | 0|

+--+-+-+---+

 --+-+---+-+-+
---

 -++--+
 1 row in set (0.00 sec)


 mysql show processlist;

++-+---+--+-+--+

 --+--+
 | Id | User| Host  | db   | Command | Time | State
 | Info |

++-+---+--+-+--+

 --+--+
 |  1 | system user | none  | NULL | Connect | 7729 | Waiting to
 reconnect after a failed read | NULL |
 |  2 | root| localhost | NULL | Sleep   | 337  |
 | NULL |
 |  3 | root| localhost | NULL | Query   | 0| NULL
 | show processlist |

++-+---+--+-+--+

 --+--+

 In errors log:

 020712 12:43:40  Error reading packet from server: Could not open log
 file
 (server_errno=2)
 020712 12:44:40  Slave: Failed reading log event, reconnecting to
 retry, log
 'FIRST' position 4
 020712 12:44:40  Slave: reconnected to master
 'replica#spiderman.terravista.srv:3306',replication resumed in log
 'FIRST'
 at position 4
 020712 12:44:40  Error reading packet from server: Could not open log
 file
 (server_errno=2)
 020712 12:45:40  Slave: Failed reading log event, reconnecting to
 retry, log
 'FIRST' position 4
 020712 12:45:40  Slave: reconnected to master
 'replica#spiderman.terravista.srv:3306',replication resumed in log
 'FIRST'
 at position 4
 020712 12:45:40  Error reading packet from server: Could not open log
 file
 (server_errno=2)

 my.cnf:

 # The MySQL server
 [mysqld]
 port= 3306
 socket  = /tmp/mysql.sock
 skip-locking
 set-variable= key_buffer=384M
 set-variable= max_allowed_packet=1M
 set-variable= table_cache=512
 set-variable= sort_buffer=2M
 set-variable= record_buffer=2M
 set-variable= thread_cache=8
 # Try number of CPU's*2 for thread_concurrency
 set-variable= thread_concurrency=8
 set-variable= myisam_sort_buffer_size=64M
 #log-bin= /mysql/log/log.nnn
 server-id   = 3

 master-host = spiderman.terravista.srv
 master-user = replica
 master-password = x

 ***

 Any suggestion?

 Thanks in advance.

 Santiago.



 -
 Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





 -
 Before posting, please

RE: Replication slave repeatedly gets error 1159 from master

2002-07-15 Thread Santiago Alba 

Yes, I have a cluster installed with 3.23.49 and I have any problem. Now, I
am installing a new cluster with 3.23.51 version and it's appearing these
problems.

Could anybody help us?

Thanks in advance.

Santiago.

- Original Message -
From: Pierre Baridon [EMAIL PROTECTED]
To: David Harper [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 4:29 PM
Subject: Re: Replication slave repeatedly gets error 1159 from master


i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51

Pierre


- Original Message -
From: David Harper [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 1:26 PM
Subject: Replication slave repeatedly gets error 1159 from master


 Description:
 Every 60 seconds, the replication slave gets an error 1159 from
 the master server. Thirty seconds later, it reconnects to the master.
 Then the cycle starts all over again. I have master-connect-retry=30 in
 the config file.

 Here is an extract of the replication slave's error log:

 020715 12:05:33  Error reading packet from server:  (server_errno=1159)
 020715 12:06:03  Slave: Failed reading log event, reconnecting to retry,
log 'mysql.001' position 73
 020715 12:06:03  Slave: reconnected to master
'slave@venus:24641',replication resumed in log 'mysql.001' at position 73
 020715 12:06:33  Error reading packet from server:  (server_errno=1159)
 020715 12:07:03  Slave: Failed reading log event, reconnecting to retry,
log 'mysql.001' position 73
 020715 12:07:03  Slave: reconnected to master
'slave@venus:24641',replication resumed in log 'mysql.001' at position 73

 In between disconnections, replication *appears* to be occurring
correctly,
 but it is rather disturbing that there seems to be some kind of
communication
 problem between the master and slave servers.

 This problem did not occur in version 3.23.49, by the way. It appeared
when
 we upgraded to 3.23.51.

 How-To-Repeat:
 Set up a master/slave replication pair of servers.
 Fix:
 Not known.

 Submitter-Id: submitter ID
 Originator: David Harper
 Organization:  Wellcome Trust Sanger Institute,  Hinxton,  Cambridge CB10
1SA,  England
 
 MySQL support: none
 Synopsis: Replication slave repeatedly gets error 1159 from master
 Severity: serious
 Priority: medium
 Category: mysql
 Class: sw-bug
 Release: mysql-3.23.51 (Official MySQL binary)
 Environment:

 System: OSF1 mars V5.1 732 alpha
 Machine: alpha
 Some paths:  /bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/bin/cc
 GCC: Reading specs from
/usr/local/lib/gcc-lib/alpha-dec-osf5.1/3.0.3/specs
 Configured with: ../configure
 Thread model: single
 gcc version 3.0.3
 Compilation info: CC='cc -pthread'
 CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all'
CXX='cxx -pthread'  CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate
all -noexceptions -nortti'  LDFLAGS=''
 LIBC:
 lrwxrwxrwx   1 root system17 Mar 30  2001 /lib/libc.a -
../ccs/lib/libc.a
 lrwxrwxrwx   1 root system17 Mar 30  2001 /usr/lib/libc.a -
../ccs/lib/libc.a
 Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL
binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-
safe-client --enable-local-infile --with-prefix=/usr/local/mysql --with-mysq
ld-ldflags=-all-static --disable-shared
'--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared
'CC=cc -pthread' 'CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline
speed -speculate all' 'CXXFLAGS=-O4 -ansi_alias -fast -inline
speed -speculate all -noexceptions -nortti' 'CXX=cxx -pthread'
 Perl: This is perl, version 5.005_03 built for alpha-dec_osf

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Replication problems

2002-07-12 Thread Santiago Alba 

Hi All,

I had a system replication on Linux consisting of MASTER and only one SLAVE.
I stopped replication, I did a backup on my slave and it recreated in
another machine so now I have two SLAVES connected to database MASTER.

But I found problems. I show you the output on my database MASTER and SLAVE
who is failed:

***

MASTER

mysql show master status;
+-+--+--+--+
| File| Position | Binlog_do_db | Binlog_ignore_db |
+-+--+--+--+
| log.101 | 54557|  |  |
+-+--+--+--+
1 row in set (0.00 sec)


SLAVE:

mysql show slave status;
+--+-+-+---+
--+-+---+-+-+---
-++--+
| Master_Host  | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db |
Last_errno | Last_error | Skip_counter |
+--+-+-+---+
--+-+---+-+-+---
-++--+
| spiderman.terravista.srv | replica | 3306| 60|
| 4   | Yes   | | | 0  |
| 0|
+--+-+-+---+
--+-+---+-+-+---
-++--+
1 row in set (0.00 sec)


mysql show processlist;
++-+---+--+-+--+
--+--+
| Id | User| Host  | db   | Command | Time | State
| Info |
++-+---+--+-+--+
--+--+
|  1 | system user | none  | NULL | Connect | 7729 | Waiting to
reconnect after a failed read | NULL |
|  2 | root| localhost | NULL | Sleep   | 337  |
| NULL |
|  3 | root| localhost | NULL | Query   | 0| NULL
| show processlist |
++-+---+--+-+--+
--+--+

In errors log:

020712 12:43:40  Error reading packet from server: Could not open log file
(server_errno=2)
020712 12:44:40  Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 4
020712 12:44:40  Slave: reconnected to master
'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST'
at position 4
020712 12:44:40  Error reading packet from server: Could not open log file
(server_errno=2)
020712 12:45:40  Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 4
020712 12:45:40  Slave: reconnected to master
'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST'
at position 4
020712 12:45:40  Error reading packet from server: Could not open log file
(server_errno=2)

my.cnf:

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=1M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
set-variable= myisam_sort_buffer_size=64M
#log-bin= /mysql/log/log.nnn
server-id   = 3

master-host = spiderman.terravista.srv
master-user = replica
master-password = x

***

Any suggestion?

Thanks in advance.

Santiago.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php