[Eisfair] [E1] MySQL 2.5.0 - cannot start!
Fabian Törner
toerner at gmx.net
Mo Okt 5 20:07:17 CEST 2015
Hallo Holger,
Habe dann gleich mal 2.5.1 genommen :)
Am 05.10.2015 um 19:48 schrieb Holger Bruenjes:
>
> hmm, dann installier noch mal drueber
Package: MariaDB - Database Server
URL: http://www.pack-eis.de/dl.php?l=17106/mariadb.tar.bz2
Name: mariadb
Package: MariaDB - Database Server
Version: 2.5.1
Date: 2015-10-04
Space: 135 MB required
Author: the eisfair team, team(at)eisfair(dot)org
Status: testing
Section: database
Internal Program Version: MariaDB 5.5.45
The world's most popular open source database
MariaDB is a backward compatible, drop-in replacement branch of
the MySQL Database Server. It includes all major open source
storage engines, including the Maria storage engine.
http://www.mariab.org
Install (y=yes, n=no)? y
--2015-10-05 19:57:35--
http://www.pack-eis.de/dl.php?l=17106/mariadb.tar.bz2
Resolving www.pack-eis.de (www.pack-eis.de)... 217.197.80.132
Connecting to www.pack-eis.de (www.pack-eis.de)|217.197.80.132|:80...
connected.
HTTP request sent, awaiting response... 302 Found
Location:
http://download.eisfair.org/pack-eis/download/17106/mariadb.tar.bz2
[following]
--2015-10-05 19:57:35--
http://download.eisfair.org/pack-eis/download/17106/mariadb.tar.bz2
Resolving download.eisfair.org (download.eisfair.org)... 130.133.8.35
Connecting to download.eisfair.org
(download.eisfair.org)|130.133.8.35|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 29334541 (28M) [application/x-bzip2]
Saving to: 'mariadb.tar.bz2'
mariadb.tar.bz2
100%[==========================================================================================================================================>]
27.98M 4.06MB/s in 9.0s
2015-10-05 19:57:44 (3.12 MB/s) - 'mariadb.tar.bz2' saved
[29334541/29334541]
Please wait ...
* Stopping MariaDB/MySQL database server .
[ OK ]
_rm:_ cannot remove ‘/usr/share/mysql’: Is a directory
* Starting MariaDB/MySQL database server ....
[ OK ]
Check database ...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
MySQL upgrade detected
Phase 1/4: Fixing views from mysql
Processing databases
information_schema
menue
mysql
owncloud
roundcubemail
test
Phase 2/4: Fixing table and database names
Processing databases
information_schema
menue
mysql
owncloud
roundcubemail
test
Phase 3/4: Checking and upgrading tables
Processing databases
information_schema
menue
menue.gbook OK
menue.gbook_fabi OK
menue.gbook_oxi OK
menue.menu OK
menue.menu_fabi OK
menue.menu_oxi OK
menue.news OK
menue.rss OK
mysql
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.menu OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers 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
owncloud
owncloud.oc_activity OK
owncloud.oc_activity_mq OK
owncloud.oc_appconfig OK
owncloud.oc_clndr_calendars OK
owncloud.oc_clndr_objects OK
owncloud.oc_clndr_repeat OK
owncloud.oc_clndr_share_calendar OK
owncloud.oc_clndr_share_event OK
owncloud.oc_contacts_addressbooks OK
owncloud.oc_contacts_cards OK
owncloud.oc_contacts_cards_properties OK
owncloud.oc_documents_invite OK
owncloud.oc_documents_member OK
owncloud.oc_documents_op OK
owncloud.oc_documents_revisions OK
owncloud.oc_documents_session OK
owncloud.oc_file_map OK
owncloud.oc_filecache OK
owncloud.oc_files_trash OK
owncloud.oc_gallery_sharing OK
owncloud.oc_group_admin OK
owncloud.oc_group_user OK
owncloud.oc_groups OK
owncloud.oc_jobs OK
owncloud.oc_locks OK
owncloud.oc_lucene_status OK
owncloud.oc_mimetypes OK
owncloud.oc_mozilla_sync_collections OK
owncloud.oc_mozilla_sync_users OK
owncloud.oc_mozilla_sync_wbo OK
owncloud.oc_pictures_images_cache OK
owncloud.oc_preferences OK
owncloud.oc_privatedata OK
owncloud.oc_properties OK
owncloud.oc_roundcube OK
owncloud.oc_share OK
owncloud.oc_share_external OK
owncloud.oc_storages OK
owncloud.oc_users OK
owncloud.oc_vcategory OK
owncloud.oc_vcategory_to_object OK
roundcubemail
roundcubemail.cache OK
roundcubemail.cache_index OK
roundcubemail.cache_messages OK
roundcubemail.cache_shared OK
roundcubemail.cache_thread OK
roundcubemail.contactgroupmembers OK
roundcubemail.contactgroups OK
roundcubemail.contacts OK
roundcubemail.dictionary OK
roundcubemail.identities OK
roundcubemail.searches OK
roundcubemail.session OK
roundcubemail.system OK
roundcubemail.users OK
test
Phase 4/4: Running 'mysql_fix_privilege_tables'
OK
Press ENTER to continue
das sieht auf jeden Fall schon mal besser aus :)
aber laufen tut es danach immer noch nicht :(
eis # /var/install/bin/mariadb-tools-update-db
* Starting MariaDB/MySQL database server .........................
[ FAIL ]
MariaDB/MySQL ERROR: cannot start!
eis #
Auszug aus dem log:
151005 19:58:19 [ERROR] Missing system table mysql.proxies_priv; please
run mysql_upgrade to create it
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_current' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_history' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_history_long' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'setup_consumers' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'setup_instruments' has the wrong structure
151005 19:58:19 [ERROR] Native table 'performance_schema'.'setup_timers'
has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'performance_timers' has the wrong structure
151005 19:58:19 [ERROR] Native table 'performance_schema'.'threads' has
the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_summary_by_thread_by_event_name' has
the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_summary_by_instance' has the wrong
structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'events_waits_summary_global_by_event_name' has the
wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'file_summary_by_event_name' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'file_summary_by_instance' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'mutex_instances' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'rwlock_instances' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'cond_instances' has the wrong structure
151005 19:58:19 [ERROR] Native table
'performance_schema'.'file_instances' has the wrong structure
151005 19:58:19 [ERROR] Incorrect definition of table mysql.event:
expected column 'sql_mode' at position 14 to have type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY',
'NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABL
ES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'),
found type set('REAL_AS_
FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3
23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
151005 19:58:19 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
151005 19:58:19 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.5.45-MariaDB' socket: '/run/mysql/mysql.sock' port: 0
eisfair-1 build
151005 20:01:49 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
151005 20:01:49 [Note] /usr/bin/mysqld (mysqld 5.5.45-MariaDB) starting
as process 12211 ...
151005 20:01:49 [ERROR] mysqld: Can't lock aria control file
'/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will
retry for 30 seconds
151005 20:02:20 [ERROR] mysqld: Got error 'Could not get an exclusive
lock; file is probably in use by another process' when trying to use
aria control file '/var/lib/mysql/aria_log_control'
151005 20:02:20 [ERROR] Plugin 'Aria' init function returned error.
151005 20:02:20 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE
failed.
151005 20:02:20 InnoDB: The InnoDB memory heap is disabled
151005 20:02:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 20:02:20 InnoDB: Compressed tables use zlib 1.2.8
151005 20:02:20 InnoDB: Using Linux native AIO
151005 20:02:20 InnoDB: Initializing buffer pool, size = 128.0M
151005 20:02:20 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
151005 20:02:20 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
Dieser Eintrag kommt dann nun zig mal:
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
Soweit erstmal .... vielen Dank & viele Grüße
Fabian
Mehr Informationen über die Mailingliste Eisfair