[Spce-user] InnoDB registration as a STORAGE ENGINE failed

Skyler skchopperguy at gmail.com
Sat Apr 21 19:40:20 EDT 2012


Hi Andreas,

On Sat, Apr 21, 2012 at 4:11 PM, Andreas Granig <agranig at sipwise.com> wrote:

> Hi,
>
> On 04/21/2012 11:31 PM, Skyler wrote:
> >  Can anyone suggest how I can overcome this now? It is a production box
> > in pre-deployment still so I can remove/re-install/restore databases
> > etc. but I'd like to avoid wiping/re-install of OS.
>
> Check with "dpkg -l|grep mysql" if you really have the right versions
> installed. Another thing could be that it fails to allocate the innodb
> buffer pool size because of too little memory, try lowering
> bufferpoolsize in config.yml just to make sure it's (not) that.
>
> Andreas
>
>
>
 Thank you for the quick reply, very appreciated. Here is what I have:

root at prod1:~# dpkg -l | grep mysql
ii  kamailio-mysql-modules                     3.1.5+sipwise3
MySQL database connectivity module for Kamailio
ii  libclass-dbi-mysql-perl                    1.00-3
extensions to Class::DBI for MySQL
ii  libdbd-mysql-perl                          4.016-1
 Perl5 database interface to the MySQL database
ii  libmysql++3                                3.0.9-1+b1
MySQL C++ library bindings (runtime)
hi  libmysqlclient16                           5.1.57-rel12.8-233.squeeze
Percona Server database client library
iU  libmysqlclient16-dev                       5.1.61-rel13.2-430.squeeze
Percona Server database development files
ii  ngcp-templates-ce-mysql                    2.4.4
 Configuration templates for mysql configuration in NGCP platforms
ii  percona-server-common-5.1                  5.1.61-rel13.2-430.squeeze
Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii  php5-mysql                                 5.3.3-7+squeeze8
MySQL module for php5
ii  rsyslog-mysql                              4.6.4-2
 MySQL output plugin for rsyslog

root at prod1:~# dpkg -l | grep kamailio
ii  kamailio                                   3.1.5+sipwise3
very fast and configurable SIP proxy
ii  kamailio-mysql-modules                     3.1.5+sipwise3
MySQL database connectivity module for Kamailio
ii  kamailio-tls-modules                       3.1.5+sipwise3
contains the TLS kamailio transport module
ii  kamailio-xml-modules                       3.1.5+sipwise3
XML based extensions for Kamailio's Management Interface
ii  ngcp-templates-ce-kamailio                 2.4.4
 Configuration templates for Kamailio configuration in NGCP platforms


 Is this correct mysql version? The bufferpoolsize is set to 128M, I did
have it set to 1024M but lowered it after reading a suggestion via google.


 Here is the latest in the log file:

120421 16:38:04 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
120421 16:38:04 [Warning] '--default-character-set' is deprecated and will
be removed in a future release. Please use '--character-set-server' instead.
120421 16:38:04 [Warning] '--default-collation' is deprecated and will be
removed in a future release. Please use '--collation-server' instead.
120421 16:38:04 [Warning] '--log_slow_queries' is deprecated and will be
removed in a future release. Please use
''--slow_query_log'/'--slow_query_log_file'' instead.
120421 16:38:04 [Warning] '--log-long-format' is deprecated and will be
removed in a future release. Please use '--log-short-format' instead.
120421 16:38:04 [Note] Flashcache bypass: disabled
120421 16:38:04 [Note] Flashcache setup error is : ioctl failed

120421 16:38:04 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3.4
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibCzWCcB' (Errcode: 13)
120421 16:38:04  InnoDB: Error: unable to create temporary file; errno: 13
120421 16:38:04 [ERROR] Plugin 'InnoDB' init function returned error.
120421 16:38:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
120421 16:38:04 [Warning] 'user' entry 'root at gvrd01' ignored in
--skip-name-resolve mode.
120421 16:38:04 [Warning] 'user' entry 'replicator at sp1' ignored in
--skip-name-resolve mode.
120421 16:38:04 [Warning] 'user' entry 'replicator at sp2' ignored in
--skip-name-resolve mode.
120421 16:38:04 [Warning] 'user' entry 'nagios at sp1' ignored in
--skip-name-resolve mode.
120421 16:38:04 [Warning] 'user' entry 'nagios at sp2' ignored in
--skip-name-resolve mode.
120421 16:38:04 [Note] Event Scheduler: Loaded 0 events
120421 16:38:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.61-rel13.2-log'  socket: '/var/run/mysqld/mysqld.sock'  port:
3306  (Percona Server (GPL), 13.2, Revision 430)

....And show engines....

mysql> show engines \G
*************************** 1. row ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 2. row ***************************
      Engine: MyISAM
     Support: DEFAULT
     Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: BLACKHOLE
     Support: YES
     Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 4. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 6. row ***************************
      Engine: FEDERATED
     Support: NO
     Comment: Federated MySQL storage engine
Transactions: NULL
          XA: NULL
  Savepoints: NULL
*************************** 7. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
7 rows in set (0.00 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120421/9995ad0d/attachment-0001.html>


More information about the Spce-user mailing list