[Koha] Unable to Access Koha # Critical

SATISH lis4satish at gmail.com
Tue Sep 3 18:42:35 NZST 2019


Hi,

With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with
MySQL -  mysql Ver 14.14 Distrib 5.5.57

I am not able to access to Koha Server. however, I can connect to System
(from SSH, putty).
I am unable to connect to mysql database. I am not sure about any reason,
because, it was running successfully and only during weekend (sunday),
system was not accessed.
but, when I tried to access Koha for Checkout and Checkin today, I am
facing problem
It is very critical for me to get this fixed, as it is  a busy day for
users and for me.
Kindly help to fix this error. I am looking forward to hearing from you.

 #Critical Problem #Priority 1

So for I tried to know the status of MySQL: (as 'root' user)

1) mysql login
------------------------
mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

2) Mysql Status
---------------------------
service mysql start
start: Job failed to start


3) System Log Verification
----------------------------
 tail -f syslog
Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin
Sep  3 11:07:42 gechlibrary kernel: [    0.000000] Linux version
3.13.0-91-generic (buildd at lgw01-35) (gcc version 4.8.4 (Ubuntu
4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016
(Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39)
Sep  3 11:07:42 gechlibrary kernel: [    0.000000] KERNEL supported cpus:
Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin
Sep  3 11:07:42 gechlibrary kernel: [    0.000000]   Intel GenuineIntel
Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer
plugin
Sep  3 11:07:42 gechlibrary kernel: [    0.000000]   AMD AuthenticAMD
Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example
plugin
Sep  3 11:07:42 gechlibrary kernel: [    0.000000]   NSC Geode by NSC
Sep  3 11:07:42 gechlibrary bluetoothd[786]: Bl

4) PID
ps aux | grep mysqld
root      3603  0.0  0.0   4688   832 pts/2    S+   11:19   0:00 grep
--color=auto mysqld

5) MySQL log
-----------------
/var/log/mysql/error.log
is empty


6) MySQL Status
------------------------------
# mysqld status
190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of
key_buffer_size is deprecated and will be removed in a future release.
Please use the full name instead.
190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and
will be removed in a future release. Please use
'--slow-query-log'/'--slow-query-log-file' instead.
190903 11:30:48 [Warning] Can't create test file
/var/lib/mysql/gechlibrary.lower-test
190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting
as process 4036 ...
190903 11:30:48 [Warning] Can't create test file
/var/lib/mysql/gechlibrary.lower-test
190903 11:30:48 [Warning] Can't create test file
/var/lib/mysql/gechlibrary.lower-test
190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead
of myisam-recover-options is deprecated and will be removed in a future
release. Please use the full name instead.
190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled.
190903 11:30:48 InnoDB: The InnoDB memory heap is disabled
190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8
190903 11:30:48 InnoDB: Using Linux native AIO
mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30)
190903 11:30:48  InnoDB: Error: unable to create temporary file; errno: 30
190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error.
190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
mysqld: Too many arguments (first extra is 'status').
Use --verbose --help to get a list of available options
190903 11:30:48 [ERROR] Aborting

190903 11:30:48 [Note] mysqld: Shutdown complete

-- 
*Satish MV*
Librarian - Govt. Engineering College
Opp. Dairy Circle, B.M.Road, Hassan 573 201
Karnataka, INDIA
Mobile: +91 9449765737
Personal Email: lis4satish at gmail.com
College Website: www.gechassan.ac.in
Library OPAC: http://library.gechassan.ac.in
Library Portal :  https://librarygechassan.wixsite.com/library


More information about the Koha mailing list