Our server seems to think it is a slave. It has a slave thread rnning, whose only action is to complain once a minute about not being able to connect to master "". This just started one day, when we took the server down and brought it right back up.
I'd like to get rid of the slave thread, but I don't know where to start. Any ideas appreciated. Info. that could be of use follows We're running on Red Hat 7.2, using 3.23.49-max-log. (We're replicating from a 4.0.1 on Win 2000) Here's the slave status. (In fact, the server is on port 3307; there is another MySQL running on port 3306. There's no user named "test") 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 | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | | test | 3306 | 60 | | 4 | Yes | | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ 1 row in set (0.00 sec) Here's the processlist. Id=1 is the zombie. Id=3 is the legitimate connection over the net from a slave. mysql> show processlist; +----+-------------+--------------------+----------+-------------+-------+-- -------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+--------------------+----------+-------------+-------+-- -------------------------------------------+------------------+ | 1 | system user | none | NULL | Connect | 50846 | connecting to master | NULL | | 3 | repl | id144.megapipe.net | NULL | Binlog Dump | 50771 | Slave connection: waiting for binlog update | NULL | | 93 | root | localhost | RCAP_SVR | Query | 0 | NULL | show processlist | +----+-------------+--------------------+----------+-------------+-------+-- -------------------------------------------+------------------+ 3 rows in set (0.00 sec) Here's a fragment of the error log when this appears to have started: 020726 02:02:39 mysqld started 020726 6:02:40 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020805 11:28:15 /usr/local/mysql/libexec/mysqld: Normal shutdown 020805 11:28:15 InnoDB: Starting shutdown... 020805 11:28:26 InnoDB: Shutdown completed 020805 11:28:26 /usr/local/mysql/libexec/mysqld: Shutdown Complete 020805 07:28:26 mysqld ended 020805 07:28:45 mysqld started 020805 11:28:45 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020805 11:28:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:29:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:30:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:31:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:32:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:33:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:34:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:35:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:36:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:37:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:38:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:39:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:40:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:41:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:42:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:43:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:44:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:45:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec I tried killing the thread; it kills mysqld: 020813 11:52:50 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:53:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:54:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:55:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:56:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:57:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020813 11:58:37 /usr/local/mysql/libexec/mysqld: Normal shutdown 020813 11:58:37 Slave thread killed while connecting to master 020813 11:58:37 Slave thread exiting, replication stopped in log 'FIRST' at position 4 020813 11:58:38 InnoDB: Starting shutdown... 020813 11:58:41 InnoDB: Shutdown completed 020813 11:58:41 /usr/local/mysql/libexec/mysqld: Shutdown Complete 020813 07:58:41 mysqld ended Here's the [mysqld] portion of the configuration file: # The MySQL server [mysqld] #port = 3306 port = 3307 #socket = /tmp/mysql.sock socket = /tmp/dcsmysql.sock skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 #log-bin log-bin = rcapdcs server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=100000 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:1000M #innodb_data_home_dir = /usr/local/mysql/var/ #innodb_log_group_home_dir = /usr/local/mysql/var/ #innodb_log_arch_dir = /usr/local/mysql/var/ innodb_data_file_path = ibdata2:1000M innodb_data_home_dir = /usr/local/dcsmysql/var/ innodb_log_group_home_dir = /usr/local/dcsmysql/var/ innodb_log_arch_dir = /usr/local/dcsmysql/var/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname --------------------------------------------------------------------- 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
