Koozali.org: home of the SME Server

Mysql

Offline dante5do

  • ****
  • 72
  • +0/-0
Mysql
« on: October 25, 2015, 06:08:36 PM »
Good morning , I have this error after upgrading the mysql php53 php55 asked me to update the mysql Segui also manually correcting the innodb without solution

151025 11:54:34 [Note] /usr/libexec/mysqld (mysqld 5.5.46) starting as process 35330 ...
@40000000562d09540ec58074 151025 11:54:34 InnoDB: The InnoDB memory heap is disabled
@40000000562d09540ec58074 151025 11:54:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
@40000000562d09540ec58074 151025 11:54:34 InnoDB: Compressed tables use zlib 1.2.3
@40000000562d09540ec5845c 151025 11:54:34 InnoDB: Using Linux native AIO
@40000000562d09540efb693c 151025 11:54:34 InnoDB: Initializing buffer pool, size = 16.0M
@40000000562d09540f0350ac 151025 11:54:34 InnoDB: Completed initialization of buffer pool
@40000000562d09540f247124 151025 11:54:34 InnoDB: highest supported file format is Barracuda.
@40000000562d09540f25f3dc InnoDB: No valid checkpoint found.
@40000000562d09540f25f3dc InnoDB: If this error appears when you are creating an InnoDB database,
@40000000562d09540f25f7c4 InnoDB: the problem may be that during an earlier attempt you managed
@40000000562d09540f25f7c4 InnoDB: to create the InnoDB data files, but log file creation failed.
@40000000562d09540f25f7c4 InnoDB: If that is the case, please refer to
@40000000562d09540f25f7c4 InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
@40000000562d09540f260f34 151025 11:54:34 [ERROR] Plugin 'InnoDB' init function returned error.
@40000000562d09540f26131c 151025 11:54:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
@40000000562d09540f27248c 151025 11:54:34 [ERROR] Unknown/unsupported storage engine: InnoDB
@40000000562d09540f272874 151025 11:54:34 [ERROR] Aborting
@40000000562d09540f272874
@40000000562d09540f2b992c 151025 11:54:34 [Note] /usr/libexec/mysqld: Shutdown complete

According to Google made ​​changes to my.cnf and LOG but nothing
We appreciate your support

Dante Aguirre

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Mysql
« Reply #1 on: October 25, 2015, 06:52:49 PM »
Before we can help you, you must tell us exactly what you did  and how you did it
Please be verbose

Offline dante5do

  • ****
  • 72
  • +0/-0
Re: Mysql
« Reply #2 on: October 25, 2015, 09:03:35 PM »
Thanks for the support, i have a SME9

http://wiki.contribs.org/Upgrade_php/mysql


guest22

Re: Mysql
« Reply #3 on: October 25, 2015, 09:56:32 PM »
Who asked you to upgrade to PHP version 5.5? I'm sure it was not SME Server. Pretty sure you broke your SME Server install by doing things manually for a web application asked you to do some things, and the web application did not ask you if you used SME Server...


Please follow up on Stefano's questions, and next to that, please read the admin manual before you do anything.


Linux is a hurd of animals and requires individual treatment per animal.




Offline dante5do

  • ****
  • 72
  • +0/-0
Re: Mysql
« Reply #4 on: October 25, 2015, 11:07:15 PM »
http://stackoverflow.com/questions/11772611/how-to-disable-innodb-in-mysql


ignore-builtin-innodb
and
default-storage-engine = myisam

Saludos
Dante

guest22

Re: Mysql
« Reply #5 on: October 26, 2015, 03:23:23 AM »
Thanks for the support, i have a SME9

http://wiki.contribs.org/Upgrade_php/mysql


dante5do,


the very first warning on that wiki page suggests that the how-to has a high risk of breaking your system and  you'd better use Software Collections....

guest22

Re: Mysql
« Reply #6 on: October 26, 2015, 03:26:12 AM »
http://stackoverflow.com/questions/11772611/how-to-disable-innodb-in-mysql


That's general Linux based, not SME Server. Our own wiki MySQL page, Useful Commands page and Software Collection page would have provided you what you need.

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Mysql
« Reply #7 on: October 26, 2015, 12:46:47 PM »
Thanks for the support, i have a SME9

http://wiki.contribs.org/Upgrade_php/mysql



well, this doesn't help us..

do you expect me or other people to setup a VM and test this procedure?

please, be verbose, as much as you can, thank you