• guilhem@mysql.com's avatar
    WL#1596 "make mysqldump --master-data --single-transaction able to do online... · 6cd218cc
    guilhem@mysql.com authored
    WL#1596 "make mysqldump --master-data --single-transaction able to do online dump of InnoDB AND report reliable
    binlog coordinates corresponding to the dump".
    The good news is that now mysqldump can be used to get an online backup of InnoDB *which works for
    point-in-time recovery and replication slave creation*. Formerly, mysqldump --master-data --single-transaction
    used to call in fact mysqldump --master-data, so the dump was not an online dump (took big lock all time of dump).
    The only lock which is now taken in this patch is at the beginning of the dump: mysqldump does:
    FLUSH TABLES WITH READ LOCK; START TRANSACTION WITH CONSISTENT SNAPSHOT; SHOW MASTER STATUS; UNLOCK TABLES;
    so the lock time is in fact the time FLUSH TABLES WITH READ LOCK takes to return (can be 0 or very long, if
    a table is undergoing a huge update).
    I have done some more minor changes listed in the paragraph of mysqldump.c.
    WL#2237 "WITH CONSISTENT SNAPSHOT clause for START TRANSACTION":
    it's a START TRANSACTION which additionally starts a consistent read on all
    capable storage engine (i.e. InnoDB). So, can serve as a replacement for
    BEGIN; SELECT * FROM some_innodb_table LIMIT 1; which starts a consistent read too. 
    6cd218cc
errmsg.txt 18.1 KB
/* Copyright (C) 2003 MySQL AB

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/*
   Modifikoval Petr -Bnajdr, snajdr@pvt.net, snajdr@cpress.cz v.0.01
	ISO LATIN-8852-2
   Dal-B verze Jan Pazdziora, adelton@fi.muni.cz
	Tue Nov 18 17:53:55 MET 1997
	Tue Dec  2 19:08:54 MET 1997		podle 3.21.15c
	Thu May  7 17:40:49 MET DST 1998	podle 3.21.29
	Thu Apr  1 20:49:57 CEST 1999		podle 3.22.20
	Mon Aug  9 13:30:09 MET DST 1999	podle 3.23.2
	Thu Nov 30 14:02:52 MET 2000		podle 3.23.28
*/

character-set=latin2

"hashchk",
"isamchk",
"NE",
"ANO",
"Nemohu vytvo-Bit soubor '%-.64s' (chybov kd: %d)",
"Nemohu vytvo-Bit tabulku '%-.64s' (chybov kd: %d)",
"Nemohu vytvo-Bit databzi '%-.64s' (chybov kd: %d)",
"Nemohu vytvo-Bit databzi '%-.64s'; databze ji existuje",
"Nemohu zru-Bit databzi '%-.64s', databze neexistuje",
"Chyba p-Bi ruen databze (nemohu vymazat '%-.64s', chyba %d)",
"Chyba p-Bi ruen databze (nemohu vymazat adres '%-.64s', chyba %d)",
"Chyba p-Bi vmazu '%-.64s' (chybov kd: %d)",
"Nemohu -Bst zznam v systmov tabulce",
"Nemohu z-Bskat stav '%-.64s' (chybov kd: %d)",
"Chyba p-Bi zjiovn pracovn adres (chybov kd: %d)",
"Nemohu uzamknout soubor (chybov-B kd: %d)",
"Nemohu otev-Bt soubor '%-.64s' (chybov kd: %d)",
"Nemohu naj-Bt soubor '%-.64s' (chybov kd: %d)",
"Nemohu -Bst adres '%-.64s' (chybov kd: %d)",
"Nemohu zm-Bnit adres na '%-.64s' (chybov kd: %d)",
"Z-Bznam byl zmnn od poslednho ten v tabulce '%-.64s'",
"Disk je pln-B (%s), ekm na uvolnn njakho msta ...",
"Nemohu zapsat, zdvojen-B kl v tabulce '%-.64s'",
"Chyba p-Bi zavrn '%-.64s' (chybov kd: %d)",
"Chyba p-Bi ten souboru '%-.64s' (chybov kd: %d)",
"Chyba p-Bi pejmenovn '%-.64s' na '%-.64s' (chybov kd: %d)",
"Chyba p-Bi zpisu do souboru '%-.64s' (chybov kd: %d)",
"'%-.64s' je zam-Ben proti zmnm",
"T-Bdn perueno",
"Pohled '%-.64s' pro '%-.64s' neexistuje",
"Obsluha tabulky vr-Btila chybu %d",
"Obsluha tabulky '%-.64s' nem-B tento parametr",
"Nemohu naj-Bt zznam v '%-.64s'",
"Nespr-Bvn informace v souboru '%-.64s'",
"Nespr-Bvn kl pro tabulku '%-.64s'; pokuste se ho opravit",
"Star-B klov soubor pro '%-.64s'; opravte ho.",
"'%-.64s' je jen pro -Bten",
"M-Blo pamti. Pestartujte daemona a zkuste znovu (je poteba %d byt)",
"M-Blo pamti pro tdn. Zvyte velikost tdcho bufferu",
"Neo-Bekvan konec souboru pi ten '%-.64s' (chybov kd: %d)",
"P-Bli mnoho spojen",
"M-Blo prostoru/pamti pro thread",
"Nemohu zjistit jm-Bno stroje pro Vai adresu",
"Chyba p-Bi ustavovn spojen",
"P-Bstup pro uivatele '%-.32s'@'%-.64s' k databzi '%-.64s' nen povolen",
"P-Bstup pro uivatele '%-.32s'@'%-.64s' (s heslem %s)",
"Nebyla vybr-Bna dn databze",
"Nezn-Bm pkaz",
"Sloupec '%-.64s' nem-Be bt null",
"Nezn-Bm databze '%-.64s'",
"Tabulka '%-.64s' ji-B existuje",
"Nezn-Bm tabulka '%-.64s'",
"Sloupec '%-.64s' v %s nen-B zcela jasn",
"Prob-Bh ukonovn prce serveru",
"Nezn-Bm sloupec '%-.64s' v %s",
"Pou-Bit '%-.64s' nebylo v group by",
"Nemohu pou-Bt group na '%-.64s'",
"P-Bkaz obsahuje zrove funkci sum a sloupce",
"Po-Bet sloupc neodpovd zadan hodnot",
"Jm-Bno identifiktoru '%-.64s' je pli dlouh",
"Zdvojen-B jmno sloupce '%-.64s'",
"Zdvojen-B jmno kle '%-.64s'",
"Zvojen-B kl '%-.64s' (slo kle %d)",
"Chybn-B specifikace sloupce '%-.64s'",
"%s bl-Bzko '%-.64s' na dku %d",
"V-Bsledek dotazu je przdn",
"Nejednozna-Bn tabulka/alias: '%-.64s'",
"Chybn-B defaultn hodnota pro '%-.64s'",
"Definov-Bno vce primrnch kl",
"Zad-Bno pli mnoho kl, je povoleno nejvce %d kl",
"Zad-Bno pli mnoho st kl, je povoleno nejvce %d st",
"Zadan-B kl byl pli dlouh, nejvt dlka kle je %d",
"Kl-Bov sloupec '%-.64s' v tabulce neexistuje",
"Blob sloupec '%-.64s' nem-Be bt pouit jako kl",
"P-Bli velk dlka sloupce '%-.64s' (nejvce %d). Pouijte BLOB",
"M-Bete mt pouze jedno AUTO pole a to mus bt definovno jako kl",
"%s: p-Bipraven na spojen",
"%s: norm-Bln ukonen\n",
"%s: p-Bijat signal %d, konm\n",
"%s: ukon-Ben prce hotovo\n",
"%s: n-Bsiln uzaven threadu %ld uivatele '%-.64s'\n",
"Nemohu vytvo-Bit IP socket",
"Tabulka '%-.64s' nem-B index odpovdajc CREATE INDEX. Vytvote tabulku znovu",
"Argument separ-Btoru poloek nebyl oekvn. Pette si manul",
"Nen-B mon pout pevn rowlength s BLOBem. Pouijte 'fields terminated by'.",
"Soubor '%-.64s' mus-B bt v adresi databze nebo iteln pro vechny",
"Soubor '%-.64s' ji-B existuje",
"Z-Bznam: %ld  Vymazno: %ld  Peskoeno: %ld  Varovn: %ld",
"Z-Bznam: %ld  Zdvojench: %ld",
"Chybn-B podst kle -- nen to etzec nebo je del ne dlka sti kle",
"Nen-B mon vymazat vechny poloky s ALTER TABLE. Pouijte DROP TABLE",
"Nemohu zru-Bit '%-.64s' (provst DROP). Zkontrolujte, zda neexistuj zznamy/kle",
"Z-Bznam: %ld  Zdvojench: %ld  Varovn: %ld",
"You can't specify target table '%-.64s' for update in FROM clause",
"Nezn-Bm identifikace threadu: %lu",
"Nejste vlastn-Bkem threadu %lu",
"Nejsou pou-Bity dn tabulky",
"P-Bli mnoho etzc pro sloupec %s a SET",
"Nemohu vytvo-Bit jednoznan jmno logovacho souboru %s.(1-999)\n",
"Tabulka '%-.64s' byla zam-Bena s READ a neme bt zmnna",
"Tabulka '%-.64s' nebyla zam-Bena s LOCK TABLES",
"Blob polo-Bka '%-.64s' neme mt defaultn hodnotu",
"Nep-Bpustn jmno databze '%-.64s'",
"Nep-Bpustn jmno tabulky '%-.64s'",
"Zadan-B SELECT by prochzel pli mnoho zznam a trval velmi dlouho. Zkontrolujte tvar WHERE a je-li SELECT v podku, pouijte SET SQL_BIG_SELECTS=1",
"Nezn-Bm chyba",
"Nezn-Bm procedura %s",
"Chybn-B poet parametr procedury %s",
"Chybn-B parametry procedury %s",
"Nezn-Bm tabulka '%-.64s' v %s",
"Polo-Bka '%-.64s' je zadna dvakrt",
"Nespr-Bvn pouit funkce group",
"Tabulka '%-.64s' pou-Bv rozen, kter v tto verzi MySQL nen",
"Tabulka mus-B mt alespo jeden sloupec",
"Tabulka '%-.64s' je pln-B",
"Nezn-Bm znakov sada: '%-.64s'",
"P-Bli mnoho tabulek, MySQL jich me mt v joinu jen %d",
"P-Bli mnoho poloek",
"-Bdek je pli velk. Maximln velikost dku, nepotaje poloky blob, je %d. Muste zmnit nkter poloky na blob",
"P-Beteen zsobnku threadu: pouito %ld z %ld. Pouijte 'mysqld -O thread_stack=#' k zadn vtho zsobnku",
"V OUTER JOIN byl nalezen k-Bov odkaz. Provte ON podmnky",
"Sloupec '%-.32s' je pou-Bit s UNIQUE nebo INDEX, ale nen definovn jako NOT NULL",
"Nemohu na-Bst funkci '%-.64s'",
"Nemohu inicializovat funkci '%-.64s'; %-.80s",
"Pro sd-Blenou knihovnu nejsou povoleny cesty",
"Funkce '%-.64s' ji-B existuje",
"Nemohu otev-Bt sdlenou knihovnu '%-.64s' (errno: %d %s)",
"Nemohu naj-Bt funkci '%-.64s' v knihovn'",
"Funkce '%-.64s' nen-B definovna",
"Stroj '%-.64s' je zablokov-Bn kvli mnoha chybm pi pipojovn. Odblokujete pouitm 'mysqladmin flush-hosts'",
"Stroj '%-.64s' nem-B povoleno se k tomuto MySQL serveru pipojit",
"Pou-Bvte MySQL jako anonymn uivatel a anonymn uivatel nemaj povoleno mnit hesla",
"Na zm-Bnu hesel ostatnm muste mt prvo provst update tabulek v databzi mysql",
"V tabulce user nen-B dn odpovdajc dek",
"Nalezen-Bch dk: %ld  Zmnno: %ld  Varovn: %ld",
"Nemohu vytvo-Bit nov thread (errno %d). Pokud je jet njak voln pam, podvejte se do manulu na st o chybch specifickch pro jednotliv operan systmy",
"Po-Bet sloupc neodpovd potu hodnot na dku %ld",
"Nemohu znovuotev-Bt tabulku: '%-.64s",
"Neplatn-B uit hodnoty NULL",
"Regul-Brn vraz vrtil chybu '%-.64s'",
"Pokud nen-B dn GROUP BY klauzule, nen dovoleno souasn pouit GROUP poloek (MIN(),MAX(),COUNT()...) s ne GROUP polokami",
"Neexistuje odpov-Bdajc grant pro uivatele '%-.32s' na stroji '%-.64s'",
"%-.16s p-Bkaz nepstupn pro uivatele: '%-.32s'@'%-.64s' pro tabulku '%-.64s'",
"%-.16s p-Bkaz nepstupn pro uivatele: '%-.32s'@'%-.64s' pro sloupec '%-.64s' v tabulce '%-.64s'",
"Neplatn-B pkaz GRANT/REVOKE. Prosm, pette si v manulu, jak privilegia je mon pout.",
"Argument p-Bkazu GRANT uivatel nebo stroj je pli dlouh",
"Tabulka '%-.64s.%s' neexistuje",
"Neexistuje odpov-Bdajc grant pro uivatele '%-.32s' na stroji '%-.64s' pro tabulku '%-.64s'",
"Pou-Bit pkaz nen v tto verzi MySQL povolen",
"Va-Be syntaxe je njak divn",
"Zpo-Bdn insert threadu nebyl schopen zskat poadovan zmek pro tabulku %-.64s",
"P-Bli mnoho zpodnch thread",
"Zru-Beno spojen %ld do databze: '%-.64s' uivatel: '%-.64s' (%s)",
"Zji-Btn pchoz packet del ne 'max_allowed_packet'",
"Zji-Btna chyba pi ten z roury spojen",
"Zji-Btna chyba fcntl()",
"P-Bchoz packety v chybnm poad",
"Nemohu rozkomprimovat komunika-Bn packet",
"Zji-Btna chyba pi ten komunikanho packetu",
"Zji-Btn timeout pi ten komunikanho packetu",
"Zji-Btna chyba pi zpisu komunikanho packetu",
"Zji-Btn timeout pi zpisu komunikanho packetu",
"V-Bsledn etzec je del ne 'max_allowed_packet'",
"Typ pou-Bit tabulky nepodporuje BLOB/TEXT sloupce",
"Typ pou-Bit tabulky nepodporuje AUTO_INCREMENT sloupce",
"INSERT DELAYED nen-B mono s tabulkou '%-.64s' pout, protoe je zamen pomoc LOCK TABLES",
"Nespr-Bvn jmno sloupce '%-.100s'",
"Handler pou-Bit tabulky neum indexovat sloupce '%-.64s'",
"V-Bechny tabulky v MERGE tabulce nejsou definovny stejn",
"Kv-Bli unique constraintu nemozu zapsat do tabulky '%-.64s'",
"BLOB sloupec '%-.64s' je pou-Bit ve specifikaci kle bez dlky",
"V-Bechny sti primrnho kle musej bt NOT NULL; pokud potebujete NULL, pouijte UNIQUE",
"V-Bsledek obsahuje vce ne jeden dek",
"Tento typ tabulky vy-Baduje primrn kl",
"Tato verze MySQL nen-B zkompilovna s podporou RAID",
"Update tabulky bez WHERE s kl-Bem nen v mdu bezpench update dovoleno",
"Kl-B '%-.64s' v tabulce '%-.64s' neexistuje",
"Nemohu otev-Bt tabulku",
"Handler tabulky nepodporuje %s",
"Proveden-B tohoto pkazu nen v transakci dovoleno",
"Chyba %d p-Bi COMMIT",
"Chyba %d p-Bi ROLLBACK",
"Chyba %d p-Bi FLUSH_LOGS",
"Chyba %d p-Bi CHECKPOINT",
"Spojen-B %ld do databze: '%-.64s' uivatel: '%-.32s' stroj: `%-.64s' (%-.64s) bylo perueno",
"Handler tabulky nepodporuje bin-Brn dump",
"Binlog uzav-Ben pi pokusu o FLUSH MASTER",
"P-Bebudovn indexu dumpnut tabulky '%-.64s' nebylo spn",
"Chyba masteru: '%-.64s'",
"S-Bov chyba pi ten z masteru",
"S-Bov chyba pi zpisu na master",
"-Bdn sloupec nem vytvoen fulltextov index",
"Nemohu prov-Bst zadan pkaz, protoe existuj aktivn zamen tabulky nebo aktivn transakce",
"Nezn-Bm systmov promnn '%-.64s'",
"Tabulka '%-.64s' je ozna-Bena jako poruen a mla by bt opravena",
"Tabulka '%-.64s' je ozna-Bena jako poruen a posledn (automatick?) oprava se nezdaila",
"Some non-transactional changed tables couldn't be rolled back",
"Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again",
"This operation cannot be performed with a running slave; run STOP SLAVE first",
"This operation requires a running slave; configure slave and do START SLAVE",
"The server is not configured as slave; fix in config file or with CHANGE MASTER TO",
"Could not initialize master info structure; more error messages can be found in the MySQL error log",
"Could not create slave thread; check system resources",
"User %-.64s has already more than 'max_user_connections' active connections",
"You may only use constant expressions with SET",
"Lock wait timeout exceeded; try restarting transaction",
"The total number of locks exceeds the lock table size",
"Update locks cannot be acquired during a READ UNCOMMITTED transaction",
"DROP DATABASE not allowed while thread is holding global read lock",
"CREATE DATABASE not allowed while thread is holding global read lock",
"Incorrect arguments to %s",
"'%-.32s'@'%-.64s' is not allowed to create new users",
"Incorrect table definition; all MERGE tables must be in the same database",
"Deadlock found when trying to get lock; try restarting transaction",
"The used table type doesn't support FULLTEXT indexes",
"Cannot add foreign key constraint",
"Cannot add a child row: a foreign key constraint fails",
"Cannot delete a parent row: a foreign key constraint fails",
"Error connecting to master: %-.128s",
"Error running query on master: %-.128s",
"Error when executing command %s: %-.128s",
"Incorrect usage of %s and %s",
"The used SELECT statements have a different number of columns",
"Can't execute the query because you have a conflicting read lock",
"Mixing of transactional and non-transactional tables is disabled",
"Option '%s' used twice in statement",
"User '%-.64s' has exceeded the '%s' resource (current value: %ld)",
"Access denied; you need the %-.128s privilege for this operation",
"Variable '%-.64s' is a SESSION variable and can't be used with SET GLOBAL",
"Variable '%-.64s' is a GLOBAL variable and should be set with SET GLOBAL",
"Variable '%-.64s' doesn't have a default value",
"Variable '%-.64s' can't be set to the value of '%-.64s'",
"Incorrect argument type to variable '%-.64s'",
"Variable '%-.64s' can only be set, not read",
"Incorrect usage/placement of '%s'",
"This version of MySQL doesn't yet support '%s'",
"Got fatal error %d: '%-.128s' from master when reading data from binary log",
"Slave SQL thread ignored the query because of replicate-*-table rules",
"Variable '%-.64s' is a %s variable",
"Incorrect foreign key definition for '%-.64s': %s",
"Key reference and table reference don't match",
"Operand should contain %d column(s)",
"Subquery returns more than 1 row",
"Unknown prepared statement handler (%.*s) given to %s",
"Help database is corrupt or does not exist",
"Cyclic reference on subqueries",
"Converting column '%s' from %s to %s",
"Reference '%-.64s' not supported (%s)",
"Every derived table must have its own alias",
"Select %u was reduced during optimization",
"Table '%-.64s' from one of the SELECTs cannot be used in %-.32s",
"Client does not support authentication protocol requested by server; consider upgrading MySQL client",
"All parts of a SPATIAL index must be NOT NULL",
"COLLATION '%s' is not valid for CHARACTER SET '%s'",
"Slave is already running",
"Slave has already been stopped",
"Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)",
"ZLIB: Not enough memory",
"ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)",
"ZLIB: Input data corrupted",
"%d line(s) were cut by GROUP_CONCAT()",
"Row %ld doesn't contain data for all columns",
"Row %ld was truncated; it contained more data than there were input columns",
"Data truncated; NULL supplied to NOT NULL column '%s' at row %ld",
"Data truncated; out of range for column '%s' at row %ld",
"Data truncated for column '%s' at row %ld",
"Using storage engine %s for table '%s'",
"Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'",
"Can't drop one or more of the requested users",
"Can't revoke all privileges, grant for one or more of the requested users",
"Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'",
"Illegal mix of collations for operation '%s'",
"Variable '%-.64s' is not a variable component (can't be used as XXXX.variable_name)",
"Unknown collation: '%-.64s'",
"SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started",
"Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format",
"Field or reference '%-.64s%s%-.64s%s%-.64s' of SELECT #%d was resolved in SELECT #%d",
"Incorrect parameter or combination of parameters for START SLAVE UNTIL",
"It is recommended to run with --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you are not safe in case of unexpected slave's mysqld restart",
"SQL thread is not to be started so UNTIL options are ignored",
"Incorrect index name '%-.100s'",
"Incorrect catalog name '%-.100s'",
"Query cache failed to set size %lu, new query cache size is %lu",
"Column '%-.64s' cannot be part of FULLTEXT index",
"Unknown key cache '%-.100s'",
"MySQL is started in --skip-name-resolve mode. You need to restart it without this switch for this grant to work",
"Unknown table engine '%s'",
"'%s' is deprecated, use '%s' instead",
"The target table %-.100s of the %s is not updatable",
"The '%s' feature was disabled; you need MySQL built with '%s' to have it working",
"The MySQL server is running with the %s option so it cannot execute this statement",
"Column '%-.100s' has duplicated value '%-.64s' in %s"
"Truncated wrong %-.32s value: '%-.128s'"
"Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"
"Invalid ON UPDATE clause for '%-.64s' column",
"This command is not supported in the prepared statement protocol yet",
"Got error %d '%-.100s' from %s",
"Got temporary error %d '%-.100s' from %s",
"Unknown or incorrect time zone: '%-.64s'",
"Invalid TIMESTAMP value in column '%s' at row %ld",
"Invalid %s character string: '%.64s'",
"Result of %s() was larger than max_allowed_packet (%ld) - truncated"
"Conflicting declarations: '%s%s' and '%s%s'"
"This MySQL server does not support any consistent-read capable storage engine"