[OmniOS-discuss] omniti/database/mysql-55 keeps on stopping

[Richard Skelton]

Hi,
I have installed the
pkg://ms.omniti.com/omniti/database/mysql-55@5.5.50-0.151014:20160722T162252Z
in a zone on my OmniOS v11 r151018 system
Which has stopped and I don't see any core file.
Looking in the .err log file I can see my restart but no message why it
crashed.

160913 22:19:58  InnoDB: Waiting for the background threads to start
160913 22:19:59 InnoDB: 5.5.50 started; log sequence number 0
160913 22:19:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160913 22:19:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160913 22:19:59 [Note] Server socket created on IP: '0.0.0.0'.
160913 22:19:59 [Note] Event Scheduler: Loaded 0 events
160913 22:19:59 [Note] /opt/mysql55/bin/mysqld: ready for connections.
Version: '5.5.50'  socket: '/tmp/mysql.sock'  port: 3306  MySQL
Community Server (GPL)
161003 20:48:44 mysqld_safe Starting mysqld daemon with databases from
/opt/mysql55/data
161003 20:48:44 [Note] /opt/mysql55/bin/mysqld (mysqld 5.5.50) starting
as process 4098 ...
161003 20:48:44 [Note] Plugin 'FEDERATED' is disabled.
161003 20:48:44 InnoDB: The InnoDB memory heap is disabled
161003 20:48:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161003 20:48:44 InnoDB: Compressed tables use zlib 1.2.3
161003 20:48:44 InnoDB: Initializing buffer pool, size = 128.0M
161003 20:48:44 InnoDB: Completed initialization of buffer pool
161003 20:48:44 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
161003 20:48:44  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
161003 20:48:44  InnoDB: Waiting for the background threads to start
161003 20:48:45 InnoDB: 5.5.50 started; log sequence number 1595675
161003 20:48:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
161003 20:48:45 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
161003 20:48:45 [Note] Server socket created on IP: '0.0.0.0'.
161003 20:48:45 [Note] Event Scheduler: Loaded 0 events
161003 20:48:45 [Note] /opt/mysql55/bin/mysqld: ready for connections.


Can I set more detailed logging ?

Cheers
Richard.