maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

on machines mysqld mysqld regulary for backup reasons i observe over 
months now *randomly* starting mysqld fails because exit-code 1 leading 
in systemd stop the service and start it again while the is no single 
indication on the mysqld error-log

anybody else?
________________________________________________________________________________

Aug 26 01:45:02 buildserver systemd: Stopping MariaDB Database...
Aug 26 01:45:03 buildserver systemd: Stopped MariaDB Database.
Aug 26 01:45:10 buildserver systemd: Starting MariaDB Database...
Aug 26 01:45:10 buildserver mysqld: 150826  1:45:10 [Note] 
/usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31936 ...
Aug 26 01:45:10 buildserver systemd: mysqld.service: control process 
exited, code=exited status=1
Aug 26 01:45:12 buildserver systemd: Failed to start MariaDB Database.
Aug 26 01:45:12 buildserver systemd: Unit mysqld.service entered failed 
state.
Aug 26 01:45:12 buildserver systemd: mysqld.service failed.
Aug 26 01:45:13 buildserver systemd: mysqld.service holdoff time over, 
scheduling restart.
Aug 26 01:45:14 buildserver systemd: Stopping MariaDB Database...
Aug 26 01:45:14 buildserver systemd: Starting MariaDB Database...
Aug 26 01:45:14 buildserver mysqld: 150826  1:45:14 [Note] 
/usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31988 ...
Aug 26 01:45:14 buildserver systemd: Started MariaDB Database.
________________________________________________________________________________

150826  1:45:02 [Note] /usr/libexec/mysqld: Normal shutdown
150826  1:45:02 [Note] Event Scheduler: Purging the queue. 0 events
150826  1:45:02 [Note] InnoDB: FTS optimize thread exiting.
150826  1:45:02 [Note] InnoDB: Starting shutdown...
150826  1:45:03 [Note] InnoDB: Shutdown completed; log sequence number 
17271831
150826  1:45:03 [Note] /usr/libexec/mysqld: Shutdown complete
150826  1:45:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150826  1:45:10 [Note] InnoDB: The InnoDB memory heap is disabled
150826  1:45:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150826  1:45:10 [Note] InnoDB: Memory barrier is not used
150826  1:45:10 [Note] InnoDB: Compressed tables use zlib 1.2.8
150826  1:45:10 [Note] InnoDB: Using Linux native AIO
150826  1:45:10 [Note] InnoDB: Using CPU crc32 instructions
150826  1:45:10 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150826  1:45:10 [Note] InnoDB: Completed initialization of buffer pool
150826  1:45:10 [Note] InnoDB: Highest supported file format is Barracuda.
150826  1:45:10 [Note] InnoDB: 128 rollback segment(s) are active.
150826  1:45:10 [Note] InnoDB: Waiting for purge to start
150826  1:45:10 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 
5.6.25-73.1 started; log sequence number 17271831
150826  1:45:10 [Note] Plugin 'FEEDBACK' is disabled.
150826  1:45:10 [Note] Server socket created on IP: '127.0.0.1'.
150826  1:45:10 [Note] /usr/libexec/mysqld: Normal shutdown
150826  1:45:10 [Note] Event Scheduler: Loaded 0 events
150826  1:45:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 
3306  thelounge
150826  1:45:10 [Note] Event Scheduler: Purging the queue. 0 events
150826  1:45:10 [Note] InnoDB: FTS optimize thread exiting.
150826  1:45:10 [Note] InnoDB: Starting shutdown...
150826  1:45:12 [Note] InnoDB: Shutdown completed; log sequence number 
17271841
150826  1:45:12 [Note] /usr/libexec/mysqld: Shutdown complete
150826  1:45:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150826  1:45:14 [Note] InnoDB: The InnoDB memory heap is disabled
150826  1:45:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150826  1:45:14 [Note] InnoDB: Memory barrier is not used
150826  1:45:14 [Note] InnoDB: Compressed tables use zlib 1.2.8
150826  1:45:14 [Note] InnoDB: Using Linux native AIO
150826  1:45:14 [Note] InnoDB: Using CPU crc32 instructions
150826  1:45:14 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150826  1:45:14 [Note] InnoDB: Completed initialization of buffer pool
150826  1:45:14 [Note] InnoDB: Highest supported file format is Barracuda.
150826  1:45:14 [Note] InnoDB: 128 rollback segment(s) are active.
150826  1:45:14 [Note] InnoDB: Waiting for purge to start
150826  1:45:14 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 
5.6.25-73.1 started; log sequence number 17271841
150826  1:45:14 [Note] Plugin 'FEEDBACK' is disabled.
150826  1:45:14 [Note] Server socket created on IP: '127.0.0.1'.
150826  1:45:14 [Note] Event Scheduler: Loaded 0 events
150826  1:45:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 
3306  thelounge

Attachment: signature.asc
Description: OpenPGP digital signature