List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:January 17 2002 6:43pm
Subject:Re: Replication Problems
View as plain text  
chown -R mysql:mysql  /var/lib/mysql
( or whatever the data directory is ).

Henning Sprang wrote:

> Hy all,
> I just try to set up Replication with two mysql databases,
> i did everything like described in the Replication-Howto.
>
> Now i get the following errors when starting the slave:
>
> 020117 18:37:55  mysqld started
> Can't initialize InnoDB as 'innodb_data_file_path' is not set
> /usr/sbin/mysqld-max: ready for connections
> 020117 18:37:55  Slave: connected to master 'repl@stripped:3306', 
> replication started in log 'samba-bin.001' at position 536
> ERROR: 1017  Can't find file: './tropon_0000001/Tagesberichte.frm' 
> (errno: 13)
> 020117 18:37:55  Slave:  error running query 'CREATE TEMPORARY TABLE 
> TB_Tage TYPE=HEAP SELECT DISTINCT Datum FROM Tagesberichte AS TB WHERE 
> Besucher_ID=10021 '
> 020117 18:37:55  Error running query, slave aborted. Fix the problem, 
> and re-start the slave thread with "mysqladmin start-slave". We 
> stopped at log 'samba-bin.001' position 536
> 020117 18:37:55  Slave thread exiting, replication stopped in log 
> 'samba-bin.001' at position 536
>
>
> the file is actually there (in the data directory at least, i don't 
> know what is meant with the "./tropon..." directory exactly as it is a 
> relative path,
> and i checked if mysql recognizes the data directory by setting some 
> unimpoortant settings in a my.cnf file in there - the changes where 
> accepted correctly, i did make sure to remove that testing file again.
>
> When I connect to the database on the slave with mysql-client i get 
> the following:
>
> ...
> Didn't find any fields in table 'Statistiken'
> Didn't find any fields in table 'Tagesberichte'
> Database changed
>
>
> I see there are some tables which don't produce errors, but for all, 
> with or without errors, there are .frm files in the data directory,
> i see there are different file permissions for differenbt table files, 
> but again the failing tables don't have something of those in common.
>
>
> has anyone an idea what i can look for?
>
>
> henning
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread96601@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Replication ProblemsHenning Sprang17 Jan
  • Re: Replication Problems - solved!Henning Sprang17 Jan
  • Re: Replication ProblemsGerald Clark17 Jan