• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Mysqli prepare error: MySQL server has gone away....

#1
Help!
How to fix it?

Code:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /var/www/antheya.club/htdocs/library/Zend/Db/Statement/Mysqli.php on line 77

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 808
Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Template/Public.php at line 130
XenForo_Template_Public->_getTemplatesFromDataSource() in XenForo/Template/Abstract.php at line 572
XenForo_Template_Abstract->_loadTemplates() in XenForo/Template/Abstract.php at line 556
XenForo_Template_Abstract->_loadTemplate() in XenForo/Template/Abstract.php at line 180
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /var/www/antheya.club/htdocs/index.php at line 13
 
#4
That error is caused by one of these MySQL settings being exceeded:

wait_timeout
max_allowed_packet
I made changes ( wait timeout = 28800 а max_allowed_packet = 48M ), but the error still appears...

Code:
160414 17:33:34 [Note] InnoDB: The InnoDB memory heap is disabled
160414 17:33:34 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160414 17:33:34 [Note] InnoDB: Memory barrier is not used
160414 17:33:34 [Note] InnoDB: Compressed tables use zlib 1.2.8
160414 17:33:34 [Note] InnoDB: Using Linux native AIO
160414 17:33:34 [Note] InnoDB: Using CPU crc32 instructions
160414 17:33:34 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160414 17:33:34 [Note] InnoDB: Completed initialization of buffer pool
160414 17:33:34 [Note] InnoDB: Highest supported file format is Barracuda.
160414 17:33:34 [Note] InnoDB: The log sequence numbers 4941151705 and 4941151705 in ibdata files do not match the log sequence number 4962713554 in the ib_logfiles!
160414 17:33:34 [Note] InnoDB: Database was not shutdown normally!
160414 17:33:34 [Note] InnoDB: Starting crash recovery.
160414 17:33:34 [Note] InnoDB: Reading tablespace information from the .ibd files...
160414 17:33:36 [Note] InnoDB: Restoring possible half-written data pages
160414 17:33:36 [Note] InnoDB: from the doublewrite buffer...
160414 17:33:37 [Note] InnoDB: 128 rollback segment(s) are active.
160414 17:33:37 [Note] InnoDB: Waiting for purge to start
160414 17:33:37 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 4962713554
160414 17:33:37 [Note] Plugin 'FEEDBACK' is disabled.
160414 17:33:37 [Note] Server socket created on IP: '0.0.0.0'.
160414 17:33:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.23-MariaDB-1~trusty-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
160414 17:33:40 [ERROR] mysqld: Table './xenforo/xf_search_index' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforo/xf_search_index'
160414 17:33:40 [ERROR] mysqld: Table './xenforo/xf_session' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforo/xf_session'
160414 17:33:40 [ERROR] mysqld: Table './xenforo/xf_session_admin' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforo/xf_session_admin'
160414 17:33:40 [ERROR] mysqld: Table './xenforotest/xf_search_index' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforotest/xf_search_index'
160414 17:33:40 [ERROR] mysqld: Table './xenforotest/xf_session' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforotest/xf_session'
160414 17:33:40 [ERROR] mysqld: Table './xenforotest/xf_session_admin' is marked as crashed and should be repaired
160414 17:33:40 [Warning] Checking table:   './xenforotest/xf_session_admin'
 

Brogan

XenForo moderator
Staff member
#5
You seem to have several crashed tables: xf_search_index, xf_session, xf_session_admin.

You will need to repair them or truncate them and in the case of the search index, rebuild it.
 
#6
You will need to repair them or truncate them and in the case of the search index, rebuild it.

Did not help...

Code:
Apr 15 10:41:14 antheya kernel: [5954495.809499] redis-server invoked oom-killer: gfp_mask=0x201da, order=0, oom_score_adj=0
Apr 15 10:41:14 antheya kernel: [5954495.809505] redis-server cpuset=/ mems_allowed=0
Apr 15 10:41:14 antheya kernel: [5954495.809512] CPU: 0 PID: 817 Comm: redis-server Not tainted 4.2.0-22-generic #27~14.04.1-Ubuntu
Apr 15 10:41:14 antheya kernel: [5954495.809514] Hardware name: Hetzner vServer, BIOS 1.8.2 04/01/2014
Apr 15 10:41:14 antheya kernel: [5954495.809517]  0000000000000000 ffff880078e13968 ffffffff817b3723 0000000000000000
Apr 15 10:41:14 antheya kernel: [5954495.809520]  ffff88000007a940 ffff880078e13a18 ffffffff817ae1d2 0000000000000000
Apr 15 10:41:14 antheya kernel: [5954495.809522]  0000000000000000 00000000285f670c 001527afd44a547c ffff880078e139a8
Apr 15 10:41:14 antheya kernel: [5954495.809525] Call Trace:
Apr 15 10:41:14 antheya kernel: [5954495.809535]  [<ffffffff817b3723>] dump_stack+0x45/0x57
Apr 15 10:41:14 antheya kernel: [5954495.809539]  [<ffffffff817ae1d2>] dump_header+0x81/0x202
Apr 15 10:41:14 antheya kernel: [5954495.809546]  [<ffffffff8105d00e>] ? kvm_clock_get_cycles+0x1e/0x20
Apr 15 10:41:14 antheya kernel: [5954495.809551]  [<ffffffff810e6b6e>] ? ktime_get+0x3e/0xa0
Apr 15 10:41:14 antheya kernel: [5954495.809555]  [<ffffffff81477c0a>] ? virtballoon_oom_notify+0x2a/0x70
Apr 15 10:41:14 antheya kernel: [5954495.809561]  [<ffffffff811798d0>] oom_kill_process+0x1c0/0x390
Apr 15 10:41:14 antheya kernel: [5954495.809566]  [<ffffffff8107fdce>] ? has_capability_noaudit+0x1e/0x30
Apr 15 10:41:14 antheya kernel: [5954495.809569]  [<ffffffff81179fb1>] out_of_memory+0x4b1/0x4f0
Apr 15 10:41:14 antheya kernel: [5954495.809572]  [<ffffffff8117f6cb>] __alloc_pages_nodemask+0x96b/0x990
Apr 15 10:41:14 antheya kernel: [5954495.809577]  [<ffffffff811c3231>] alloc_pages_current+0x91/0x100
Apr 15 10:41:14 antheya kernel: [5954495.809580]  [<ffffffff81176134>] __page_cache_alloc+0xa4/0xc0
Apr 15 10:41:14 antheya kernel: [5954495.809583]  [<ffffffff81178453>] filemap_fault+0x193/0x400
Apr 15 10:41:14 antheya kernel: [5954495.809588]  [<ffffffff811a144d>] __do_fault+0x3d/0xa0
Apr 15 10:41:14 antheya kernel: [5954495.809591]  [<ffffffff811a5b91>] handle_mm_fault+0xe51/0x1840
Apr 15 10:41:14 antheya kernel: [5954495.809594]  [<ffffffff817b9f56>] ? schedule_hrtimeout_range_clock+0xa6/0x130
Apr 15 10:41:14 antheya kernel: [5954495.809599]  [<ffffffff81063d79>] __do_page_fault+0x199/0x430
Apr 15 10:41:14 antheya kernel: [5954495.809603]  [<ffffffff810a0760>] ? wake_up_q+0x80/0x80
Apr 15 10:41:14 antheya kernel: [5954495.809605]  [<ffffffff81064077>] trace_do_page_fault+0x37/0xa0
Apr 15 10:41:14 antheya kernel: [5954495.809608]  [<ffffffff8105cb29>] do_async_page_fault+0x19/0x80
Apr 15 10:41:14 antheya kernel: [5954495.809612]  [<ffffffff817bca38>] async_page_fault+0x28/0x30
Apr 15 10:41:14 antheya kernel: [5954495.809614] Mem-Info:
Apr 15 10:41:14 antheya kernel: [5954495.809619] active_anon:480405 inactive_anon:8595 isolated_anon:0
Apr 15 10:41:14 antheya kernel: [5954495.809619]  active_file:184 inactive_file:209 isolated_file:0
Apr 15 10:41:14 antheya kernel: [5954495.809619]  unevictable:0 dirty:0 writeback:4 unstable:0
Apr 15 10:41:14 antheya kernel: [5954495.809619]  slab_reclaimable:4595 slab_unreclaimable:4433
Apr 15 10:41:14 antheya kernel: [5954495.809619]  mapped:21366 shmem:25692 pagetables:5102 bounce:0
Apr 15 10:41:14 antheya kernel: [5954495.809619]  free:3361 free_pcp:171 free_cma:0
Apr 15 10:41:14 antheya kernel: [5954495.809623] Node 0 DMA free:7972kB min:40kB low:48kB high:60kB active_anon:6520kB inactive_anon:320kB active_file:0kB inactive_file:0kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15992kB managed:15908kB mlocked:0kB dirty:0kB writeback:0kB mapped:408kB shmem:416kB slab_reclaimable:136kB slab_unreclaimable:180kB kernel_stack:16kB pagetables:356kB unstable:0kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB writeback_tmp:0kB pages_scanned:0 all_unreclaimable? yes
Apr 15 10:41:14 antheya kernel: [5954495.809630] lowmem_reserve[]: 0 1983 1983 1983
Apr 15 10:41:14 antheya kernel: [5954495.809633] Node 0 DMA32 free:5472kB min:5580kB low:6972kB high:8368kB active_anon:1915100kB inactive_anon:34060kB active_file:736kB inactive_file:836kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:2080640kB managed:2032992kB mlocked:0kB dirty:0kB writeback:16kB mapped:85056kB shmem:102352kB slab_reclaimable:18244kB slab_unreclaimable:17552kB kernel_stack:3824kB pagetables:20052kB unstable:0kB bounce:0kB free_pcp:684kB local_pcp:564kB free_cma:0kB writeback_tmp:0kB pages_scanned:9548 all_unreclaimable? yes
Apr 15 10:41:14 antheya kernel: [5954495.809637] lowmem_reserve[]: 0 0 0 0
Apr 15 10:41:14 antheya kernel: [5954495.809640] Node 0 DMA: 43*4kB (UEM) 21*8kB (UEM) 63*16kB (UEM) 19*32kB (EM) 8*64kB (UEM) 5*128kB (UEM) 3*256kB (UM) 2*512kB (UE) 3*1024kB (UEM) 0*2048kB 0*4096kB = 7972kB
Apr 15 10:41:14 antheya kernel: [5954495.809651] Node 0 DMA32: 322*4kB (UEM) 404*8kB (UEM) 56*16kB (U) 0*32kB 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 5416kB
Apr 15 10:41:14 antheya kernel: [5954495.809669] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB
Apr 15 10:41:14 antheya kernel: [5954495.809670] 26104 total pagecache pages
Apr 15 10:41:14 antheya kernel: [5954495.809672] 0 pages in swap cache
Apr 15 10:41:14 antheya kernel: [5954495.809673] Swap cache stats: add 0, delete 0, find 0/0
Apr 15 10:41:14 antheya kernel: [5954495.809674] Free swap  = 0kB
Apr 15 10:41:14 antheya kernel: [5954495.809675] Total swap = 0kB
Apr 15 10:41:14 antheya kernel: [5954495.809677] 524158 pages RAM
Apr 15 10:41:14 antheya kernel: [5954495.809677] 0 pages HighMem/MovableOnly
Apr 15 10:41:14 antheya kernel: [5954495.809678] 11933 pages reserved
Apr 15 10:41:14 antheya kernel: [5954495.809679] 0 pages cma reserved
Apr 15 10:41:14 antheya kernel: [5954495.809680] 0 pages hwpoisoned
 
#7
Next...

Code:
Apr 15 10:41:14 antheya kernel: [5954495.809681] [ pid ]   uid  tgid total_vm      rss nr_ptes nr_pmds swapents oom_score_adj name
Apr 15 10:41:14 antheya kernel: [5954495.809687] [  306]     0   306     4902       79      13       3        0             0 upstart-udev-br
Apr 15 10:41:14 antheya kernel: [5954495.809695] [  314]     0   314    12902      169      29       3        0         -1000 systemd-udevd
Apr 15 10:41:14 antheya kernel: [5954495.809697] [  368]     0   368     3820       61      12       3        0             0 upstart-file-br
Apr 15 10:41:14 antheya kernel: [5954495.809699] [  384]   101   384    64155     7733      41       3        0             0 rsyslogd
Apr 15 10:41:14 antheya kernel: [5954495.809738] [  386]   102   386     9809       96      23       3        0             0 dbus-daemon
Apr 15 10:41:14 antheya kernel: [5954495.809740] [  401]     0   401    10864       90      27       4        0             0 systemd-logind
Apr 15 10:41:14 antheya kernel: [5954495.809742] [  687]     0   687     3882      119      14       3        0             0 upstart-socket-
Apr 15 10:41:14 antheya kernel: [5954495.809744] [  765]     0   765     1092       24       8       3        0             0 runsvdir
Apr 15 10:41:14 antheya kernel: [5954495.809746] [  771]     0   771     4016       39      13       4        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809748] [  778]     0   778     4016       39      12       3        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809750] [  783]     0   783     4016       39      12       3        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809752] [  784]     0   784     1054       21       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809754] [  785]     0   785     1054       20       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809756] [  786]     0   786     1054       20       7       3..
Apr 15 10:41:14 antheya kernel: [5954495.809756] [  786]     0   786     1054       20       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809758] [  787]     0   787     1054       20       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809760] [  788]     0   788     1054       21       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809762] [  789]     0   789     1054       20       6       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809764] [  790]     0   790     1054       21       7       3        0             0 runsv
Apr 15 10:41:14 antheya kernel: [5954495.809765] [  791]     0   791     4016       40      13       3        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809768] [  794]     0   794     4016       39      13       3        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809776] [  804]     0   804     1090       22       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809778] [  805]     0   805     1090       25       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809780] [  806]     0   806     1090       25       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809782] [  807]     0   807     1090       22       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809788] [  808]     0   808     1090       24       7       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809795] [  809]     0   809     1090       25       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809799] [  810]     0   810     1090       24       8       3        0             0 svlogd
Apr 15 10:41:14 antheya kernel: [5954495.809804] [  813]     0   813     7807      158      20       3        0             0 nginx
Apr 15 10:41:14 antheya kernel: [5954495.809810] [  817]   997   817     9824     1691      13       3        0             0 redis-server
Apr 15 10:41:14 antheya kernel: [5954495.809815] [  818]   996   818   144343     8582      37       4        0             0 postgres
 
#8
Next...

Code:
Apr 15 10:41:14 antheya kernel: [5954495.809824] [  833]   998   833    58673     1536      25       6        0             0 gitlab-workhors
Apr 15 10:41:14 antheya kernel: [5954495.809827] [  846]     0   846     4799       59      14       3        0             0 irqbalance
Apr 15 10:41:14 antheya kernel: [5954495.809837] [  855]     0   855     5915       65      17       3        0             0 cron
Apr 15 10:41:14 antheya kernel: [5954495.809849] [  923]     0   923     2370      784      10       3        0             0 haveged
Apr 15 10:41:14 antheya kernel: [5954495.809858] [  925]   999   925     8937     1326      21       3        0             0 nginx
Apr 15 10:41:14 antheya kernel: [5954495.809865] [  926]   999   926     8938     1327      21       3        0             0 nginx
Apr 15 10:41:14 antheya kernel: [5954495.809872] [  936]     0   936     1093       38       8       3        0             0 acpid
Apr 15 10:41:14 antheya kernel: [5954495.809882] [ 1022]     0  1022    15344      170      35       3        0         -1000 sshd
Apr 15 10:41:14 antheya kernel: [5954495.809887] [ 1114]     0  1114     6337       80      17       3        0             0 master
Apr 15 10:41:14 antheya kernel: [5954495.809893] [ 1117]   106  1117     6894       88      18       4        0             0 qmgr
Apr 15 10:41:14 antheya kernel: [5954495.809900] [ 1163]   996  1163   144406      511      24       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809906] [ 1164]   996  1164   144406      417      22       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809915] [ 1165]   996  1165   144406      146      19       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809921] [ 1166]   996  1166   144609      338      24       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809958] [ 1167]   996  1167     6850      164      17       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809965] [ 1221]   104  1221     7864      151      21       3        0             0 ntpd
Apr 15 10:41:14 antheya kernel: [5954495.809972] [ 1381]     0  1381     4016       41      13       3        0             0 getty
Apr 15 10:41:14 antheya kernel: [5954495.809975] [ 8558]   106  8558    10078      157      23       3        0             0 tlsmgr
Apr 15 10:41:14 antheya kernel: [5954495.809983] [21709]   998 21709     4509       80      14       3        0             0 gitlab-unicorn-
Apr 15 10:41:14 antheya kernel: [5954495.809985] [21826]   998 21826   128037    62045     219       3        0             0 ruby
Apr 15 10:41:14 antheya kernel: [5954495.809987] [21836]   998 21836   113750    63073     218       3        0             0 ruby
Apr 15 10:41:14 antheya kernel: [5954495.809989] [25526]   996 25526   147759      833      33       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.809991] [26882]   107 26882     1112       19       8       3        0             0 sh
Apr 15 10:41:14 antheya kernel: [5954495.809993] [26884]   107 26884   172740    15448      78      37        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.809995] [26888]   107 26888   174276    16916      83      43        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.809997] [26890]   107 26890   174264    16727      83      43        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.809999] [26891]   107 26891   219320    22691     108      52        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.810000] [26893]   107 26893   219879    22903     112      55        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.810002] [26895]   107 26895   174537    17126      85      43        0             0 nodejs
Apr 15 10:41:14 antheya kernel: [5954495.810004] [18177]   998 18177   131997    64363     223       3        0             0 ruby
Apr 15 10:41:14 antheya kernel: [5954495.810006] [18183]   996 18183   148192     1675      36       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.810008] [ 5891]   998  5891   130489    64478     219       3        0             0 ruby
Apr 15 10:41:14 antheya kernel: [5954495.810011] [17268]   996 17268   147757     1295      32       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.810013] [27142]     0 27142    93963     3597     138       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810015] [21485]     0 21485     9447      146      18       3        0             0 pure-ftpd-mysql
Apr 15 10:41:14 antheya kernel: [5954495.810017] [ 7639]     0  7639     1112       27       8       3        0             0 gitlab-logrotat
Apr 15 10:41:14 antheya kernel: [5954495.810019] [ 8321]     0  8321     1087       20       8       3        0             0 sleep
Apr 15 10:41:14 antheya kernel: [5954495.810021] [ 9367]   106  9367     6853       69      18       3        0             0 pickup
Apr 15 10:41:14 antheya kernel: [5954495.810023] [ 9495]     0  9495    26411      270      56       3        0             0 sshd
Apr 15 10:41:14 antheya kernel: [5954495.810025] [ 9544]  2002  9544    26411      268      54       3        0             0 sshd
Apr 15 10:41:14 antheya kernel: [5954495.810027] [ 9545]  2002  9545     5681      456      17       3        0             0 bash
Apr 15 10:41:14 antheya kernel: [5954495.810029] [ 9563]     0  9563    16357      153      37       3        0             0 sudo
Apr 15 10:41:14 antheya kernel: [5954495.810031] [ 9568]     0  9568     5345      144      15       3        0             0..
Apr 15 10:41:14 antheya kernel: [5954495.810033] [ 9593]     0  9593    26411      243      55       3        0             0 sshd
Apr 15 10:41:14 antheya kernel: [5954495.810035] [ 9613]     0  9613     3207       42      12       3        0             0 sftp-server
Apr 15 10:41:14 antheya kernel: [5954495.810036] [10179]    33 10179    99777    17758     173       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810039] [11055]    33 11055   114030    10016     162       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810041] [11226]   998 11226   366264    64483     251       4        0             0 ruby
Apr 15 10:41:14 antheya kernel: [5954495.810043] [11245]   105 11245   193159    69576     213       4        0             0 mysqld
Apr 15 10:41:14 antheya kernel: [5954495.810045] [11395]   996 11395   147707     1085      32       4        0             0 postgres
Apr 15 10:41:14 antheya kernel: [5954495.810047] [11459]    33 11459   101091    14752     167       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810049] [11463]    33 11463   114088     9480     161       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810051] [11585]    33 11585   114046     8439     163       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810053] [11725]    33 11725    94680     6092     151       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810055] [11739]    33 11739    94600     6855     153       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810057] [11744]    33 11744    94733     4334     146       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810059] [11787]    33 11787    95185     7097     152       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810061] [11912]    33 11912   100807    13219     163       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810063] [12041]    33 12041    93971     2257     126       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810065] [12048]    33 12048    93971     2257     126       4        0             0 apache2
Apr 15 10:41:14 antheya kernel: [5954495.810066] [12054]   998 12054       92        1       5       3        0             0 sleep
Apr 15 10:41:14 antheya kernel: [5954495.810068] Out of memory: Kill process 11245 (mysqld) score 136 or sacrifice child
Apr 15 10:41:14 antheya kernel: [5954495.810542] Killed process 11245 (mysqld) total-vm:772636kB, anon-rss:278304kB, file-rss:0kB
Apr 15 10:41:14 antheya kernel: [5954495.934885] init: mysql main process (11245) killed by KILL signal
Apr 15 10:41:14 antheya kernel: [5954495.934943] init: mysql main process ended, respawning
Apr 15 10:41:18 antheya /etc/mysql/debian-start[12127]: Upgrading MySQL tables if necessary.
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12131]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12131]: Looking for 'mysql' as: /usr/bin/mysql
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12131]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12131]: This installation of MySQL is already upgraded to 10.0.23-MariaDB, use --force if you still need to run mysql_upgrade
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12138]: Checking for insecure root accounts.
Apr 15 10:41:19 antheya /etc/mysql/debian-start[12142]: Triggering myisam-recover for all MyISAM tables
 

Mike

XenForo developer
Staff member
#10
I'm not sure what you're specifically trying to show with those kernel (/var/log/messages) logs, but it clearly shows MySQL is being killed because your server is out of memory. At the least, you'll need to tweak various settings regarding to memory usage by various programs. Alternatively, you may need more memory. (There's always swap space, though that might just create performance issues in a situation like this.)

If MySQL is killed without going through the normal shutdown process, corruption is very possible.