List:General Discussion« Previous MessageNext Message »
From:Sinisa Milivojevic Date:January 25 2002 10:32am
Subject:Re: mysql warnings when write locking compressed table
View as plain text  
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> Hi,
>   when I'm trying to lock multiple tables and some of the are Compressed,
> mysql warn's me only about the first-one being Compressed. It either
> reports the first Compressed table only from the list, or it checks
> only the first-one in the list of tables to be locked:
> 
> mysql> use Escherichia_coli_O157_H7_EDL933
> Database changed
> mysql> lock table blast_data write; write, blimps_data write, cogs_data write,
> coils_data write, contig_data write, funcat_data write, intragenome_data write,
> known3d_data write, nonglob_data write, orf_data write, pfam_data write, prd_data write,
> pros_data write, prot_data write, scop1_data write, scop2_data write, seg_data write,
> tmhmm_data write;
> ERROR 1036: Table 'blast_data' is read only
> mysql> 
> 
>   `myisamchk -f -d ' reports on those tables their status, and most of them were
> Compressed.
> I don't think it make's sense to paste the output here.
> 
>   I don't know if it's really `ERROR', because I'm locking the tables
> to FLUSH TABLES and then in the backgroung run `myisamchk --unpack *.MYI'.
> ;)[B
> 
> Linux 2.4.17,
> /usr/local/mysql/bin/mysqld  Ver 3.23.42 for pc-linux-gnu on i686
> -- 
> Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics <http://mips.gsf.de>
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3616 , fax: +49-89-3187 3585
> 

Please do not run myisamchk while the server is running.

Use CHECK TABLE to check tables ... 

-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

Thread
mysql warnings when write locking compressed tableMartin MOKREJŠ25 Jan
  • Re: mysql warnings when write locking compressed tableSinisa Milivojevic25 Jan
    • Re: mysql warnings when write locking compressed tableMartin MOKREJŠ25 Jan
      • Re: mysql warnings when write locking compressed tableSinisa Milivojevic25 Jan