[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/mailman/private/spce-user_lists.sipwise.com/attachments/20120421/9995ad0d/attachment.html>
More information about the Spce-user
mailing list