Autor | Zpráva | ||
---|---|---|---|
mikii Profil * |
#1 · Zasláno: 1. 11. 2009, 11:32:02
zdravím, mám problém padá mi mysql a nevím proč jak infiltrovat problém ? :/
několik měsíců vše bylo vpohodě, poslední dobou mi celkem narostla databáze co se týče struktury (né dat) ale to mi nepříjde že by byl kámen úrazu .. netuším kliknu zobrazeni databáze v pma nebo vlezu do nějaké tabulky vše ok ale jakmile vlezu do jedné určité tabulky kterou jsem chtěl zeditovat (přidat pár sloupců) tak to spadne .. #2003 - Server neodpovídá díky moc za výpomoc :D |
||
Kajman_ Profil * |
#2 · Zasláno: 1. 11. 2009, 11:55:46
Zkuste check nebo repair table.
|
||
mikii Profil * |
#3 · Zasláno: 1. 11. 2009, 15:43:26
ehmm zkusil změnilo se to že se mi otevřela tabulka ale zahalsilo to tohle
SQL-dotaz: DokumentaceUpravit INSERT INTO `phpmyadmin`.`pma_history` ( `username` , `db` , `table` , `timevalue` , `sqlquery` ) VALUES ( 'root', 'abc_db', 'test_table', NOW( ) , 'SELECT * FROM `test_table`' ) MySQL hlásí: Dokumentace #2006 - MySQL server has gone away po překliknutí na něco v té tabulce to zase spadne #2003 - Server neodpovídá stímhle jsem se bikdy nesetkal :-( právě ted když je hodně práce :/ |
||
mikii Profil * |
#4 · Zasláno: 1. 11. 2009, 16:13:49
dal jsem reparir jna tabulku phpmyadmin`.`pma_history`
vše při starem ..MySQL hlásí: Dokumentace #2006 - MySQL server has gone away .. |
||
mikii Profil * |
#5 · Zasláno: 1. 11. 2009, 16:55:24
.. další poznatek :/ co stímhle?
phpmyadmin.pma_history check warning 2 clients are using or haven't closed the table pr... |
||
Kajman_ Profil * |
#6 · Zasláno: 1. 11. 2009, 19:41:10
Zkusil bych se mrknout na db přes mysql administrator z mysql qui tools
http://dev.mysql.com/downloads/gui-tools/5.0.html A neloučí se náhodou disk? |
||
Kajman_ Profil * |
#7 · Zasláno: 1. 11. 2009, 19:46:18
A příčiny havárie nejsou v logu?
|
||
mikii Profil * |
#8 · Zasláno: 1. 11. 2009, 21:31:00
v apache? nejsou v logu. mysql nema nějaky error log?
disk? to snad ne .. mam to na home notebooku noo každopadně dneska se stalo to že mi to nejede vubec:/ a nevim proč po restartu se na DB nepřipojím :/ dá se nějak vycucat ty struktura databáze? když se tam nemužu nijak lognout .. přes administrator gui mi to napíše .. Could not start service co stim jako je ? : / |
||
Kajman_ Profil * |
#9 · Zasláno: 2. 11. 2009, 09:21:25
Apache to mít v logu nebude, mrkněte do adřesáře s daty, jestli tam nemáte soubor nazevpocitace.err.
|
||
mikii Profil * |
#10 · Zasláno: 2. 11. 2009, 10:33:36
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist 091101 20:37:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 091101 20:37:19 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 091101 20:37:19 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 091101 20:37:20 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 091101 20:37:21 InnoDB: Started; log sequence number 0 0 091101 20:37:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist 091101 20:40:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: Log scan progressed past the checkpoint lsn 0 39548 091101 20:40:45 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 46409 091101 20:40:46 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 091101 20:40:48 InnoDB: Started; log sequence number 0 46409 091101 20:40:51 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist 091101 20:57:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 091101 20:57:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 091101 20:57:17 InnoDB: Started; log sequence number 0 46409 091101 20:57:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist 091101 21:03:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 091101 21:03:48 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 091101 21:03:48 InnoDB: Started; log sequence number 0 46409 091101 21:03:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist 091101 21:24:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 091101 21:24:32 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 091101 21:24:32 InnoDB: Started; log sequence number 0 46409 091101 21:24:32 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist |
||
nightfish Profil |
#11 · Zasláno: 2. 11. 2009, 10:50:46
mikii:
„Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist“ není problém v tomto? nepomohlo by spustit mysql_upgrade.exe? |
||
mikii Profil * |
#12 · Zasláno: 3. 11. 2009, 20:17:12
ehm nepomohlo po spuštění toho souboru z cmd Err 2003 a fatal error upgrade
ono ta db nejede už vubec :/ error log vypada stjjně |
||
Časová prodleva: 14 let
|
0