Portál AbcLinuxu, 24. dubna 2024 21:19


Dotaz: mysql nelze spustit

11.12.2011 14:02 jozka | skóre: 19 | blog: jozkovo
mysql nelze spustit
Přečteno: 355×
Odpovědět | Admin
Ahoj, po ugradu na opensuse 12.1 64bit mam problem s nemoznosti spustit mysql:
linux-hvl1:/home/jozka # /etc/init.d/mysql start
redirecting to systemctl
Job failed. See system logs and 'systemctl status' for details.
log mysql mlci, ve /var/log/messages je toto:
Dec 11 13:54:00 linux-hvl1 systemd[1]: mysql.service: control process exited, code=exited status=1
Dec 11 13:54:00 linux-hvl1 systemd[1]: Unit mysql.service entered failed state.
Zatim jsem nenasel ani naznak spravneho reseni, nemate s tim nekdo zkusenost?
Nástroje: Začni sledovat (0) ?Zašle upozornění na váš email při vložení nového komentáře.

Odpovědi

11.12.2011 15:05 Petr Šobáň | skóre: 80 | blog: soban | Olomouc
Rozbalit Rozbalit vše Re: mysql nelze spustit
Odpovědět | | Sbalit | Link | Blokovat | Admin
Co takhle si zjistit co vypíše "systemctl status" ?

A povolit startování tam ? A /etc/init.d/mysql smazat ?

11.12.2011 16:21 jozka | skóre: 19 | blog: jozkovo
Rozbalit Rozbalit vše Re: mysql nelze spustit
A jaj, zmena a me se nic nerekne :-) Kazdopadne:
linux-hvl1:/etc/systemd # systemctl status mysqld.service
mysqld.service
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
linux-hvl1:/etc/systemd # systemctl enable mysqld.service
Failed to issue method call: No such file or directory
A jsem tam, kde jsem byl... Rozumim tomu dobre, ze si system po upgrade neudelal mysql.service ja mu to musim nadatlovat rucne?
11.11.2012 12:24 jozka | skóre: 19 | blog: jozkovo
Rozbalit Rozbalit vše Re: mysql nelze spustit
Odpovědět | | Sbalit | Link | Blokovat | Admin
Rok se s rokem sesel a problem je zpet, po upgrade na 12.2 nemuzu spustit na lokale MySQL. Ad delam, co delam, vzdy skoncim takto: 
systemctl status mysqld.service
mysqld.service - MySQL Server
          Loaded: loaded (/lib/systemd/system/mysqld.service; enabled)
          Active: failed (Result: exit-code) since Sun, 11 Nov 2012 12:22:19 +0100; 2s ago
         Process: 18229 ExecStart=/usr/bin/mysql --defaults-file=/etc/my.cnf --datadir=/var/lib/mysql --socket=/var/run/mysql/mysql.sock (code=exited, status=7)
          CGroup: name=systemd:/system/mysqld.service

Nov 11 12:22:19 ip-89-103-212-175 mysql[18229]: /usr/bin/mysql: unknown variable 'datadir=/var/lib/mysql'
Nevite nekdo, jak 100hoven?
18.11.2012 12:27 jozka | skóre: 19 | blog: jozkovo
Rozbalit Rozbalit vše Re: mysql nelze spustit
Odpovědět | | Sbalit | Link | Blokovat | Admin
Vypada to, ze mi mysql na lokale neni souzeno: 
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: /usr/sbin/mysqld: Unknown error 1146
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: The InnoDB memory heap is disabled
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: Compressed tables use zlib 1.2.5
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: CPU does not support crc32 instructions
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: Initializing buffer pool, size = 128.0M
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: Completed initialization of buffer pool
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: highest supported file format is Barracuda.
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: 128 rollback segment(s) are active.
Nov 18 12:05:45 ip-89-103-212-175 mysqld[18585]: 121118 12:05:45 InnoDB: Waiting for the background threads to start
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 InnoDB: 1.2.4 started; log sequence number 1595735
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [ERROR] Aborting
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Binlog end
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'partition'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_DELETED'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_METRICS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_CMPMEM'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_CMP_RESET'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_CMP'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_LOCKS'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'INNODB_TRX'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46 [Note] Shutting down plugin 'InnoDB'
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46  InnoDB: FTS optimize thread exiting.
Nov 18 12:05:46 ip-89-103-212-175 mysqld[18585]: 121118 12:05:46  InnoDB: Starting shutdown...
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 InnoDB: Shutdown completed; log sequence number 1595745
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'MyISAM'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'CSV'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'MRG_MYISAM'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'MEMORY'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'mysql_old_password'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'mysql_native_password'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note] Shutting down plugin 'binlog'
Nov 18 12:05:47 ip-89-103-212-175 mysqld[18585]: 121118 12:05:47 [Note]
Nov 18 12:05:47 ip-89-103-212-175 systemd[1]: mysqld.service: main process exited, code=exited, status=1
Nov 18 12:05:47 ip-89-103-212-175 systemd[1]: Unit mysqld.service entered failed state.
opensuse 12.2 64bit mysql z repo opensuse... na netu jsem k tomu par postrehu nasel, ale zadny z nich mi nesel...

Založit nové vlákno • Nahoru

Tiskni Sdílej: Linkuj Jaggni to Vybrali.sme.sk Google Del.icio.us Facebook

ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.