Mysql Server startet nicht nach Upgrade

F

f.gruber

New Member
Hallo,
nach Upgrade von Suse 12.3 auf 13.1 kann ich den mysql Server nicht mehr starten. Offensichtlich gibt es ein Problem beim Upgrade auf die Version 5.6 des Pakets mysql-community-server. Was kann ich da jetzt machen? Das Lesen der Doku hat mich nicht weitergebracht.
Code: 
Jan 13 01:35:19 srv123 mysql[1839]: mysql.columns_priv                                 OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.db                                           OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.event                                        OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.func                                         OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.general_log                                  OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.help_category                                OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.help_keyword                                 OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.help_relation                                OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.help_topic                                   OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.host                                         OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.innodb_index_stats                           OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.innodb_table_stats                           OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.ndb_binlog_index                             OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.plugin                                       OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.proc                                         OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.procs_priv                                   OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.proxies_priv                                 OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.servers                                      OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.slave_master_info                            OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.slave_relay_log_info                         OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.slave_worker_info                            OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.slow_log                                     OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.tables_priv                                  OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.time_zone                                    OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.time_zone_leap_second                        OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.time_zone_name                               OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.time_zone_transition                         OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.time_zone_transition_type                    OK
Jan 13 01:35:19 srv123 mysql[1839]: mysql.user                                         OK
Jan 13 01:35:19 srv123 mysql[1839]: Running 'mysql_fix_privilege_tables'...
Jan 13 01:35:19 srv123 mysql[1839]: Running 'mysqlcheck' with connection arguments: '--socket=/var/tmp/mysql-protected.FnKlTz/mysql.sock'
Jan 13 01:35:19 srv123 mysql[1839]: ..failed
Jan 13 01:35:21 srv123 systemd[1]: mysql.service: control process exited, code=exited status=1
Jan 13 01:35:21 srv123 systemd[1]: Failed to start LSB: Start the MySQL database server.
Jan 13 01:35:21 srv123 systemd[1]: Unit mysql.service entered failed state.

Da ich nun schon stundenlang verschiedenes versuche, hoffe ich auf Hilfe in diesem Forum.

Danke für jeden Tipp.
Ferdinand
 
Hey,
my.cnf gründlich gecheckt?
Mehr Hilfe für die Helfenden: mysql starten und bitte /var/log/mysql (oder so ähnlich) posten.
emerge
 
emerge said:
Hey,
my.cnf gründlich gecheckt?
Click to expand...
Die "neue" my.cnf ist spartanisch:
Code: 
[client]
[mysqld]
innodb_file_format=Barracuda
innodb_file_per_table=ON
server-id       = 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
!includedir /etc/my.cnf.d
Habe es auch mit der "alten" my.cnf.rpmsave probiert.
Hat keine Änderung gebracht.

Hier die "alte" Datei:
Code: 
[client]
port            = 3306
socket          = /var/run/mysql/mysql.sock
[mysqld]
port            = 3306
socket          = /var/run/mysql/mysql.sock
datadir = /var/lib/mysql
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
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
[safe_mysqld]
log-error       = /var/log/mysql/mysqld.log
socket          = /var/run/mysql/mysql.sock
[mysqldump]
socket          = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
events
ignore-table=mysql.events 
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
Mehr Hilfe für die Helfenden: mysql starten
Click to expand...
Mysql kann ich eben nicht starten, das ist ja mein Problem :confused:
und bitte /var/log/mysql (oder so ähnlich) posten
Click to expand...
mysqld-upgrade.log:
Code: 
Running protected MySQL... 
Upgrading MySQL... 
   Looking for 'mysql' as: /usr/bin/mysql
   Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
   Running 'mysqlcheck' with connection arguments: '--socket=/var/tmp/mysql-protected.Q6blJs/mysql.sock' 
   Running 'mysqlcheck' with connection arguments: '--socket=/var/tmp/mysql-protected.Q6blJs/mysql.sock' 
   mysql.columns_priv                                 OK
   mysql.db                                           OK
   mysql.event                                        OK
   mysql.func                                         OK
   mysql.general_log                                  OK
   mysql.help_category                                OK
   mysql.help_keyword                                 OK
   mysql.help_relation                                OK
   mysql.help_topic                                   OK
   mysql.host                                         OK
   mysql.innodb_index_stats                           OK
   mysql.innodb_table_stats                           OK
   mysql.ndb_binlog_index                             OK
   mysql.plugin                                       OK
   mysql.proc                                         OK
   mysql.procs_priv                                   OK
   mysql.proxies_priv                                 OK
   mysql.servers                                      OK
   mysql.slave_master_info                            OK
   mysql.slave_relay_log_info                         OK
   mysql.slave_worker_info                            OK
   mysql.slow_log                                     OK
   mysql.tables_priv                                  OK
   mysql.time_zone                                    OK
   mysql.time_zone_leap_second                        OK
   mysql.time_zone_name                               OK
   mysql.time_zone_transition                         OK
   mysql.time_zone_transition_type                    OK
   mysql.user                                         OK
   Running 'mysql_fix_privilege_tables'...
   Running 'mysqlcheck' with connection arguments: '--socket=/var/tmp/mysql-protected.Q6blJs/mysql.sock'
mysqld-upgrade-run.log
Code: 
140113 12:11:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-01-13 12:11:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-01-13 12:11:38 14490 [Note] Plugin 'FEDERATED' is disabled.
2014-01-13 12:11:38 14490 [Note] InnoDB: The InnoDB memory heap is disabled
2014-01-13 12:11:38 14490 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-01-13 12:11:38 14490 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-01-13 12:11:38 14490 [Note] InnoDB: Using Linux native AIO
2014-01-13 12:11:38 14490 [Note] InnoDB: Using CPU crc32 instructions
2014-01-13 12:11:38 14490 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-01-13 12:11:38 14490 [Note] InnoDB: Completed initialization of buffer pool
2014-01-13 12:11:38 14490 [Note] InnoDB: Highest supported file format is Barracuda.
2014-01-13 12:11:38 14490 [Note] InnoDB: 128 rollback segment(s) are active.
2014-01-13 12:11:38 14490 [Note] InnoDB: Waiting for purge to start
2014-01-13 12:11:38 14490 [Note] InnoDB: 5.6.12 started; log sequence number 817974946
2014-01-13 12:11:38 14490 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-01-13 12:11:38 14490 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-01-13 12:11:38 14490 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.12-log'  socket: '/var/tmp/mysql-protected.Q6blJs/mysql.sock'  port: 0  openSUSE package
2014-01-13 12:11:46 14490 [Note] /usr/sbin/mysqld: Normal shutdown

2014-01-13 12:11:46 14490 [Note] Giving 0 client threads a chance to die gracefully
2014-01-13 12:11:46 14490 [Note] Shutting down slave threads
2014-01-13 12:11:46 14490 [Note] Forcefully disconnecting 0 remaining clients
2014-01-13 12:11:46 14490 [Note] Binlog end
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'partition'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_METRICS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_CMP'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'INNODB_TRX'
2014-01-13 12:11:46 14490 [Note] Shutting down plugin 'InnoDB'
2014-01-13 12:11:46 14490 [Note] InnoDB: FTS optimize thread exiting.
2014-01-13 12:11:46 14490 [Note] InnoDB: Starting shutdown...
2014-01-13 12:11:47 14490 [Note] InnoDB: Shutdown completed; log sequence number 817974956
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'ARCHIVE'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'BLACKHOLE'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'CSV'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'MEMORY'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'MRG_MYISAM'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'MyISAM'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'sha256_password'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'mysql_old_password'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'mysql_native_password'
2014-01-13 12:11:47 14490 [Note] Shutting down plugin 'binlog'
2014-01-13 12:11:47 14490 [Note] /usr/sbin/mysqld: Shutdown complete

140113 12:11:47 mysqld_safe mysqld from pid file /var/tmp/mysql-protected.Q6blJs/mysqld.pid ended
mysqld.log posten hat wohl keinen Sinn, weil der Server ja nicht läuft.
Danke für jeden weiteren Tipp
Ferdinand
 
[gelöst] Mysql Server startet nicht nach Upgrade

emerge said:
... my.cnf gründlich gecheckt? ...
Click to expand...
Ich habe die vorhandene my.cnf.rpmsave mit der neuen my.cnf abgeglichen und zwei Dateien in /var/lib/mysql gelöscht.
Code: 
rm .force_upgrade 
rm .run-mysql_upgrade

Gruß
Ferdinand
 
You must log in or register to reply here.
Back
Top