Satish, Just a hunch... Pls check free diskspace
Regards -indranil On Tue 3 Sep, 2019, 12:12 PM SATISH, <[email protected]> wrote: > 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@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: [email protected] > College Website: www.gechassan.ac.in > Library OPAC: http://library.gechassan.ac.in > Library Portal : https://librarygechassan.wixsite.com/library > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha

