Error during migration from mariaDB to percona

Phinous · Mar 2nd 2015

Hi,

I want to change mariaDB to percona.

When I run "perl imscp-autoinstall -dar sql" I have these errors :

Code

Les paquets suivants seront ENLEVÉS :
mariadb-client-10.0* mariadb-client-core-10.0* mariadb-server-10.0*
mariadb-server-core-10.0*
Les NOUVEAUX paquets suivants seront installés :
percona-server-client-5.6 percona-server-server-5.6
Préconfiguration des paquets...
0 mis à jour, 2 nouvellement installés, 4 à enlever et 1 non mis à jour.
Il est nécessaire de prendre 0 o/37,9 Mo dans les archives.
Après cette opération, 1 943 ko d'espace disque supplémentaires seront utilisés.
(Lecture de la base de données... 49664 fichiers et répertoires déjà installés.)
Suppression de mariadb-server-10.0 ...
Stopping MariaDB database server: mysqld.
Purge des fichiers de configuration de mariadb-server-10.0 ...
Suppression de mariadb-client-10.0 ...
Purge des fichiers de configuration de mariadb-client-10.0 ...
Suppression de mariadb-client-core-10.0 ...
Suppression de mariadb-server-core-10.0 ...
Traitement des actions différées (« triggers ») pour « man-db »...
Sélection du paquet percona-server-client-5.6 précédemment désélectionné.
(Lecture de la base de données... 49440 fichiers et répertoires déjà installés.)
Dépaquetage de percona-server-client-5.6 (à partir de .../percona-server-client-5.6_5.6.22-72.0-738.wheezy_amd64.deb) ...
Dépaquetage de percona-server-server-5.6 (à partir de .../percona-server-server-5.6_5.6.22-72.0-738.wheezy_amd64.deb) ...
dpkg: erreur de traitement de /var/cache/apt/archives/percona-server-server-5.6_5.6.22-72.0-738.wheezy_amd64.deb (--unpack) :
tentative de remplacement de « /usr/lib/mysql/plugin/dialog.so », qui appartient aussi au paquet libmariadbclient18 10.0.17+maria-1~wheezy
dpkg-deb : erreur : le sous-processus coller a été tué par le signal (Relais brisé (pipe))
Traitement des actions différées (« triggers ») pour « man-db »...
Des erreurs ont été rencontrées pendant l'exécution :
/var/cache/apt/archives/percona-server-server-5.6_5.6.22-72.0-738.wheezy_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
autoinstaller::Functions::build: An error occured while performing build steps
[FATAL]
Exit code: 100

Display More

I don't want to break something, so I prefer to ask how to solve this problem...

**Nuxwin** · Mar 2nd 2015

Hello @Phinous

Try this:

Shell-Script

# aptitude purge libmariadbclient18
# perl imscp-autoinstall -dar sql

Then choose percona again.

If really needed, add my ssh key to your server and give me the IP.

Phinous · Mar 2nd 2015

Something going wrong :

Code

Restarting IMAP/POP3 mail server: dovecot.
Starting IMAP/POP3 mail server: dovecot.
Paramétrage de percona-server-client-5.6 (5.6.22-72.0-738.wheezy) ...
Paramétrage de libmysqlclient18 (5.5.35-rel33.0-611.wheezy) ...
Paramétrage de libdbd-mysql-perl (4.021-1+b1) ...
Paramétrage de percona-server-server-5.6 (5.6.22-72.0-738.wheezy) ...
Installation de la nouvelle version du fichier de configuration /etc/init.d/mysql ...
Installation de la nouvelle version du fichier de configuration /etc/mysql/debian-start ...
Le fichier de configuration « /etc/logcheck/ignore.d.paranoid/percona-server-server-5_6 » n'existe pas sur le système.
Installation d'un nouveau fichier de configuration comme demandé.
Le fichier de configuration « /etc/logcheck/ignore.d.workstation/percona-server-server-5_6 » n'existe pas sur le système.
Installation d'un nouveau fichier de configuration comme demandé.
Le fichier de configuration « /etc/logcheck/ignore.d.server/percona-server-server-5_6 » n'existe pas sur le système.
Installation d'un nouveau fichier de configuration comme demandé.
Stopping MySQL (Percona Server): mysqld.
2015-03-02 21:03:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-02 21:03:07 7735 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2015-03-02 21:03:07 7735 [Note] Plugin 'FEDERATED' is disabled.
2015-03-02 21:03:07 7735 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-02 21:03:07 7735 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-02 21:03:07 7735 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-02 21:03:07 7735 [Note] InnoDB: Memory barrier is not used
2015-03-02 21:03:07 7735 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-03-02 21:03:07 7735 [Note] InnoDB: Using Linux native AIO
2015-03-02 21:03:07 7735 [Note] InnoDB: Using CPU crc32 instructions
2015-03-02 21:03:07 7735 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2015-03-02 21:03:07 7735 [Note] InnoDB: Completed initialization of buffer pool
2015-03-02 21:03:07 7735 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-02 21:03:07 7735 [Note] InnoDB: The log sequence numbers 15108226233 and 15108226233 in ibdata files do not match the log sequence number 15113591479 in the ib_logfiles!
2015-03-02 21:03:07 7735 [Note] InnoDB: Database was not shutdown normally!
2015-03-02 21:03:07 7735 [Note] InnoDB: Starting crash recovery.
2015-03-02 21:03:07 7735 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-03-02 21:03:07 7735 [Note] InnoDB: Restoring possible half-written data pages
2015-03-02 21:03:07 7735 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 5753668, file name /var/log/mysql/mariadb-bin.000332
2015-03-02 21:03:08 7735 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-02 21:03:08 7735 [Note] InnoDB: Waiting for purge to start
2015-03-02 21:03:08 7735 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 15113591479
2015-03-02 21:03:08 7735 [Note] Recovering after a crash using /var/log/mysql/mariadb-bin
2015-03-02 21:03:08 7735 [ERROR] Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 39, event_type: -93
2015-03-02 21:03:08 7735 [Note] Starting crash recovery...
2015-03-02 21:03:08 7735 [Note] Crash recovery finished.
2015-03-02 21:03:08 7735 [Note] Crashed binlog file /var/log/mysql/mariadb-bin.000332 size is 5764847, but recovered up to 248. Binlog trimmed to 248 bytes.
2015-03-02 21:03:08 7735 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-03-02 21:03:08 7735 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-03-02 21:03:08 7735 [Note] Binlog end
2015-03-02 21:03:08 7735 [Note] InnoDB: FTS optimize thread exiting.
2015-03-02 21:03:08 7735 [Note] InnoDB: Starting shutdown...
2015-03-02 21:03:10 7735 [Note] InnoDB: Shutdown completed; log sequence number 15113595436
* Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
* Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
* See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details
Starting MySQL (Percona Server) database server: mysqld . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: erreur de traitement de percona-server-server-5.6 (--configure) :
le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1
Paramétrage de dovecot-mysql (1:2.2.13-11~bpo70+1) ...
Paramétrage de proftpd-mod-mysql (1.3.4a-5+deb7u2) ...
Paramétrage de libsasl2-modules-sql:amd64 (2.1.25.dfsg1-6+deb7u1) ...
Traitement des actions différées (« triggers ») pour « dovecot-core »...
Restarting IMAP/POP3 mail server: dovecot.
Starting IMAP/POP3 mail server: dovecot.
Des erreurs ont été rencontrées pendant l'exécution :
percona-server-server-5.6
E: Sub-process /usr/bin/dpkg returned an error code (1)
autoinstaller::Functions::build: An error occured while performing build steps
[FATAL]

Display More

You have the connexion info on your MP box

Error during migration from mariaDB to percona

Share

Daily visitors