Diskuze: MySQL chyba

Neaktivní uživatel

Člen

Neaktivní uživatel:6.6.2015 20:12

Zdravím,
před nedávnem jsem si stáhnul a nainstaloval UwAmp, Apache server běží v pohodě, ale MySQL server se pokaždé sotva nahodí a po ca. 10 vteřinách spadne. Už si s tím opravdu nevím rady, blokuje mi to veškerou moji práci, a ani Google mi moc nepomohl. Ví někdo co s tím? Dole je kompletní Mysql log.
Předem díky za rady

2015-06-06 20:05:11 5100 [Note] Plugin 'FEDERATED' is disabled.
2015-06-06 20:05:11 5100 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 20:05:11 5100 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 20:05:11 5100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-06 20:05:11 5100 [Note] InnoDB: Memory barrier is not used
2015-06-06 20:05:11 5100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-06 20:05:11 5100 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-06 20:05:11 5100 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-06-06 20:05:11 5100 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 20:05:11 5100 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2015-06-06 20:05:14 5100 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2015-06-06 20:05:16 5100 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2015-06-06 20:05:16 5100 [Warning] InnoDB: New log files created, LSN=1600887
2015-06-06 20:05:16 5100 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 20:05:16 5100 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 20:05:16 5100 [Note] InnoDB: Waiting for purge to start
2015-06-06 20:05:16 5100 [Note] InnoDB: 5.6.20 started; log sequence number 1601036
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2015-06-06 20:05:16 5100 [Note] Event Scheduler: Loaded 0 events
2015-06-06 20:05:16 5100 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: ready for connections.
Version: '5.6.20-log'  socket: ''  port: 0  MySQL Community Server (GPL)
2015-06-06 20:05:16 5100 [ERROR] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
2015-06-06 20:05:16 5100 [ERROR] Aborting

2015-06-06 20:05:16 5100 [Note] Binlog end
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'partition'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_METRICS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_TRX'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'InnoDB'
2015-06-06 20:05:16 5100 [Note] InnoDB: FTS optimize thread exiting.
2015-06-06 20:05:16 5100 [Note] InnoDB: Starting shutdown...
2015-06-06 20:05:18 5100 [Note] InnoDB: Shutdown completed; log sequence number 1601046
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'BLACKHOLE'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'ARCHIVE'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MRG_MYISAM'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MyISAM'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MEMORY'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'CSV'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'sha256_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'mysql_old_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'mysql_native_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'binlog'
2015-06-06 20:05:18 5100 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: Shutdown complete

Editováno 6.6.2015 20:13

Odpovědět

6.6.2015 20:12

Neaktivní uživatelský účet

Richard

Člen

Richard:6.6.2015 20:18

V my.cnf zakomentovat skip-networking a enable-named-pipe

Nahoru Odpovědět

6.6.2015 20:18

$action = $_GET['Life']; | Když dáš mínus, napiš proč!

Jan Lupčík

Tvůrce

Jan Lupčík:6.6.2015 20:31

A co ten <a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html">odkaz, kam tě to furt odkazuje</a>?

Nahoru Odpovědět

6.6.2015 20:31

TruckersMP vývojář

Neaktivní uživatel

Člen

Neaktivní uživatel:6.6.2015 20:34

S toho jsem taky nebyl moc chytrej

Nahoru Odpovědět

6.6.2015 20:34

Neaktivní uživatelský účet

Neaktivní uživatel

Člen

Neaktivní uživatel:6.6.2015 22:03

Díky za odpověď,
našel jsem, že my.cnf je na windowsech my.ini (snad je to dobře), zakomentoval jsem skip networking, ale enable named pipe jsem v tom souboru našel jen v "okecávacích" komentech, takže pořád nefacha. Port 3306 jsem ve firewallu odblokoval a port 90 je taky volnej. Přikládám soubor a v komentech jsem označil problematická místa.
Díky za jakékoliv (správné) další rady.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

[mysqld]
default-storage-engine = myisam
port            = 3306
socket          = /tmp/mysql.sock
datadir         = "C:/UwAmp/bin/database/mysql-5.6.20/data"
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
explicit_defaults_for_timestamp = TRUE

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless! <-tohle...
#
# skip-networking  <- ...a tohle mi dělá vrásky na čele

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#

# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\\mysql\\data\\
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\\mysql\\data\\
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Nahoru Odpovědět

6.6.2015 22:03

Neaktivní uživatelský účet

Richard

Člen

Richard:7.6.2015 1:50

Popravdě úplně si to už nepamatuju, zkus pod definici portu hodit:
skip-networking
enable-named-pipe

Editováno 7.6.2015 1:50

Nahoru Odpovědět

7.6.2015 1:50

$action = $_GET['Life']; | Když dáš mínus, napiš proč!

Neaktivní uživatel

Člen

Neaktivní uživatel:7.6.2015 14:07

Po přidání už nepadá, ale pro změnu vůbec nereaguje, nejde vypnout/zapnout a k databázi se pořád nedá připojit :-/

Nahoru Odpovědět

7.6.2015 14:07

Neaktivní uživatelský účet

mkub

Tvůrce

mkub:9.6.2015 8:23

a tentoraz, co sa hodilo do logu?

Nahoru Odpovědět

9.6.2015 8:23

Neaktivní uživatel

Člen

Neaktivní uživatel:9.6.2015 16:37

trošku jsem to mezitím předělal, my.ini teď vypadá takhle:

[client]
port = 3306
socket=/tmp/mysql.sock

[mysql]
default-character-set = utf8

[mysqld]
port = 3306
basedir="C:/UwAmp/bin/database/mysql-5.6.20/"
datadir="C:/UwAmp/bin/database/mysql-5.6.20/data"
character-set-server = utf8
default-storage-engine = INNODB
socket=/tmp/mysql.sock
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
explicit_defaults_for_timestamp
max_connections = 341
query_cache_size = 9M
tmp_table_size = 16M
bind-address = 0.0.0.0
thread_cache_size = 17
myisam_max_sort_file_size = 100G
myisam_sort_buffer_size = 8M
key_buffer_size = 16M
read_buffer_size = 64K
read_rnd_buffer_size = 256K
sort_buffer_size = 208K
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 1M
innodb_buffer_pool_size = 256M
innodb_log_file_size = 10M
innodb_thread_concurrency = 10
skip-networking
enable-named-pipe

a log takhle

2015-06-09 16:35:52 5668 [Note] Plugin 'FEDERATED' is disabled.
2015-06-09 16:35:52 5668 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-09 16:35:52 5668 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-09 16:35:52 5668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-09 16:35:52 5668 [Note] InnoDB: Memory barrier is not used
2015-06-09 16:35:52 5668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-09 16:35:52 5668 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-09 16:35:52 5668 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2015-06-09 16:35:52 5668 [Note] InnoDB: Completed initialization of buffer pool
2015-06-09 16:35:53 5668 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-09 16:35:53 5668 [Note] InnoDB: The log sequence numbers 1602582 and 1602582 in ibdata files do not match the log sequence number 1603104 in the ib_logfiles!
2015-06-09 16:35:53 5668 [Note] InnoDB: Database was not shutdown normally!
2015-06-09 16:35:53 5668 [Note] InnoDB: Starting crash recovery.
2015-06-09 16:35:53 5668 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-06-09 16:35:53 5668 [Note] InnoDB: Restoring possible half-written data pages
2015-06-09 16:35:53 5668 [Note] InnoDB: from the doublewrite buffer...
2015-06-09 16:35:56 5668 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-09 16:35:56 5668 [Note] InnoDB: Waiting for purge to start
2015-06-09 16:35:56 5668 [Note] InnoDB: 5.6.20 started; log sequence number 1603104
2015-06-09 16:35:57 5668 [Note] Event Scheduler: Loaded 0 events
2015-06-09 16:35:57 5668 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: ready for connections.
Version: '5.6.20'  socket: ''  port: 0  MySQL Community Server (GPL)

díky za rady/připomínky/poznámky/cokoliv

Nahoru Odpovědět

9.6.2015 16:37

Neaktivní uživatelský účet

Neaktivní uživatel

Člen

Neaktivní uživatel:11.6.2015 17:46

ok, vyřešeno. Prostě jsem místo Uwampu stáhnul XAMPP, tam to fachá na první nástřel

Akceptované řešení
+5 Zkušeností

Nahoru Odpovědět

11.6.2015 17:46

Neaktivní uživatelský účet

Nejčastěji vyhledáváné

Diskuze: MySQL chyba