Hello mflorell,
Thanks for your prompt reply. I am still getting the same error and cant login into admin / agent prompt.
***Here is the output of full process list :-
MariaDB [(none)]> show full processlist;
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
| 13 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 14 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 18 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 19 | cron | localhost | asterisk | Sleep | 178 | | NULL | 0.000 |
| 30 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 31 | cron | localhost | asterisk | Sleep | 14 | | NULL | 0.000 |
| 32 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 33 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 34 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 42 | root | localhost | NULL | Query | 0 | init | show full processlist | 0.000 |
| 44 | cron | localhost | asterisk | Sleep | 1 | | NULL | 0.000 |
| 47 | cron | localhost | asterisk | Sleep | 1 | | NULL | 0.000 |
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
12 rows in set (0.00 sec)
***Here is the output of slow query log :-
/usr/sbin/mysqld, Version: 10.1.25-MariaDB (openSUSE package). started with:
Tcp port: 3306 Unix socket: /var/run/mysql/mysql.sock
Time Id Command Argument
***Here is the output of mysql log :-
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: The InnoDB memory heap is disabled
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using Linux native AIO
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using SSE crc32 instructions
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Completed initialization of buffer pool
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: Waiting for purge to start
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: Percona XtraDB (
http://www.percona.com) 5.6.36-82.0 started; log sequence number 1617275
2018-07-28 14:46:55 139784997292288 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-28 14:46:55 139782067844864 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-07-28 14:46:56 139784997292288 [Note] Server socket created on IP: '::'.
2018-07-28 14:46:56 139784997292288 [Warning] 'user' entry 'root@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Warning] 'user' entry '@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Warning] 'proxies_priv' entry '@% root@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.25-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 openSUSE package
Looking for your expert views plz...
Thanks in Advance.
Roy