MySQL Will not start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL Will not start

Postby RSLCS007 » 26. October 2018 21:03

Have been using XAMPP for sometime now and started working on a website using it as localhosting

all week have been fine until today I cannot get MySQL to start: I receive the following in LOG file,

"2018-10-26 11:28:15 12120 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 11:28:15 12120 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 11:28:15 12120 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 11:28:15 12120 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 11:28:15 12120 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 11:28:15 12120 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 11:28:15 12120 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 11:28:15 12120 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 11:28:15 12120 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 11:28:15 12120 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 13299428 in the ib_logfiles!
2018-10-26 11:28:15 12120 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-10-26 11:28:16 12120 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 11:28:16 12120 [Note] InnoDB: Waiting for purge to start
2018-10-26 11:28:16 12120 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 13299428
2018-10-26 11:28:16 5580 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-10-26 11:28:16 12120 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 11:28:16 12120 [Note] Server socket created on IP: '::'.
2018-10-26 11:28:16 12120 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2018-10-26 12:53:24 23a8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:53:24 9128 [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-10-26 12:53:24 2c9c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:53:24 11420 [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-10-26 12:53:24 2cf4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:53:24 11508 [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-10-26 12:53:24 32dc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:53:24 13020 [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-10-26 12:53:24 2d1c InnoDB: Warning: Using innodb_additional_mem_poo2l0_s1i8z-e1 0i-s2 6D E1P2R:E5C3A:T2E4D .3 T0h9ics IonpntoiDoBn: mWay abren irnemoved in future releasegs:, U stinog gienntohdebr_ awdidtiht thieon optiaoln_ mienmn_opdobo_lu_ssei_zsey s_imsa lDloc anEdP RwEiCtAhT EtDhe Inn.o DTBh'is si notpetrinoanl mmaeym ory albleo crator.
2018e-m1o0v-e2d6 i1n2 :f5u3t:u2r4e 1r1e5l4e8a s[eN2so0,t1 e8t]-o 1gI0e-t26h e1r2 :53:24w i9t128 [Note]h Itnhneo DoBp:t iUsoinn gi nmnuteoxdebs_ utsoe _rnseyfs c_omuannltol DobBc: ainndnuofdfbe_re mpwpoitotylh_ fptrahegeee_sl
ist_algorithm has be eInn ncohDaBn'gesd itnot elrengaalc ym ebmeocaruys ea lolfo cs2am0ta1ol8rl-. 1
b0u-f2f26e0 r11 82p-:o15o3l: 20s4-i 2z9e61. 2 18I n[2 N:oortdee]r Itnon ouDsB: The Inno5D3B: e2m 4ebmaocrkyo fhfe,a pi nicsr edaissea bbl ue1fd2f
4e4r4 poo[lN at least up to 20MB.
o
te] InnoDB: innodb_empty_2f0r1e8e-_1l0i-s2t6_ a1l2g:o5r3i:t2h4m 9h1a2s8 b[eNeont ec]h aInngneodD Bt:o lMeugtaecxeys baencda urswe_ loofc kssm aulsle bufWfienrd owpso oiln tseirzleo.c kIend ofrudnecrt toi ounsse
backoff, increase buffer pool at least up to 20MB.

2018-10-26 12:53:24 9128 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 12:53:24 22018-10-26 12:53:24 9128 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:53:24 9128 [Note] InnoDB: Using generic crc32 instructions
d18 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, toget2h0e1r8 -w1i0t-h2 6t h1e2 :o5p3t:ion inno2d4b _9u1s2e8_ s[ys_malloNco taen]d IwnintohD Bt:h eI nIintnioaDlBi'zsi nign tbeurfnfaelr mpeomoolr,y sailzleo c=a t1o6r..0
M
20182-1001-82-61 122:05138:-2014-0 2-1621 651 4214:2 5:[35N:3o2:t42e 4]1 31I01n24n02o0D B[:N oit ne[n]No odIbtn_en]o DeIBmn:pn toUyDs_Bif:nr geU em_ultiesxte_sasil ngtgo ref ocmrouiuttnehtmx ebhusaf sft eobr e repenof o clch aopnaggueendst
tbou flfee22r0 01p1g8o8a-o-c1l1y0 0 -p-b2a2e6g6c e a1s1u2
2s:e5 3o::f5234: 2941 2181 4[2N0o t[eN]o tIen]n oIDnBn:o DCBo:m pTlheet eIdn nionDiBt imaelmiozrayt ihsoemnaa plo lfi sbb uudffiffseearrb lpeodo
l size. In order to use backoff, increas2e b0u1f8f-ep1ro2 o0pl1o
8o0-l1 0a-t2 6l e1a-2s:2t56 3 u:1p22 4:t 5o13 1:242024M0 B 1.[3
N0
o2te] InnoDB: Mutexes and 0r w[_lNooctkes] useI Windows interlocked funncntoiDoBn:s
The InnoDB memory heap is disabled2
018-10-26 12:53:24 11420 [Note] InnoDB: _mm_lfence() and _m2m0_1s8f-e1n0c-e2(6) 1a2r:e5 3u:s2e4d 1f1o5r0 82m e[mNoortye ]b aIrnrnio0De1Br8:
- 21U020s10-i812n86-g- 1 110m02--u2:2t566e3 x:11e222s4:: 55t13o32: :24r24e4442f 011[c131No805ou-24tn108et0 ] -[[ b2NNIu6oonf ttnf1eeoe2]]D:r B5 II:3pnn :onUn2ooso4lDiD BnB1p:g:1a gU4mMes2uus0it
tne[egxNx eoemssut tetae]onx deIr sner nfwto _DoclB o:oru cenCkftos m cbpuoursufeenfs2 tes0W re1ib d8nup -dfot1ofoa0welb-sr l2 pe6ipas nog 1toeu2els:r
5p3a:ge2sl4eso
1z1l5i0c8bk e[1dN. o2ft.ue]n3c
t iIonnnsoDB: The
InnoDB memory heap is disabled
2018-21001-82-61 01-22:65 31:22:45 31:242444 1[1N5o4t8e ][ NIontneo]D BI:n nTohDeB :I nTnhoeD BI nmneomDoBr 2ym0 e1hm8eo-ar1py02 -0ih21se68 a -dp11i 20si-:a2s5b6 3l d:e1i2d2s
4:a 5b13l3:e02d2
0 [4N o1t1e5]0 8I n[nNooDtBe:] _Imnmn_olDfBe:n cMeu(t)e xeasn da n_dm mr_ws_fleoncckes( )u saer eW iunsdeodw sf oirn tmeermloorcyk ebda rfruinecrt
ions
2018-10-26 12:53:24 11548 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
22018-10-26 12:53:24 11508 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
018-10-26 12:53:24 11420 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:53:24 11548 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for mem2ory b0a1r8r-i1e0r-
26 12:53:24 11508 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-262 01182-:1503-:2264 11320:250 [N3o:t2e4] InnoDB :1 2C24o04m1p8r-e1s0s-e2d6 t41a 2b[:lN5eo3st: e2u]4s eI1 n1zn5o4D8B :[ NMouttee]x eIsnl niaobnD dB1 :.r 2wC._o3lm
presseodc ktsa bulsees Wuisned ozwlsi bi 1.n2t.e3r
locked functions
2018-102-02168 -1120:-5236: 12:53:24 11548 [Note]2 4I n1n3o0D2B0: [Using gen2eN0ro1itce ]c rIcn3n2o DiBn:s tUrsuicntgi generic crons
c32 instructions
2018-10-26 12:53:24 12444 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
8-10-26 12:53:24 11508 [Note] InnoDB: Using gene2r0i1c8 -cr1c03-22 6i n1s2t:r5u3c:t2i4o n1s2
444 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:53:24 12444 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:53:24 11544 [Note] InnoDB2018-10-26 12:53:24 11548 [Note] InnoDB: Initializing buffer pool, size := U1sing mutexes6 .t0oM
r2e0f1 8c-o1u0n-t2 6b u1f2f:e5r3 :p2o4o l1 3p02a0g e[sN
ote] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:53:24 11544 [Note] InnoDB: The InnoDB mem2ory heap is disabled
2018-10-26 12:53:24 11508 [No2t0e1]8 -2I210n001n1-8o82-D-61B1 0:01- -22I2:6n65 i 31t1:2i2022:a:1405l58 1i3-318z:1:3-i20201n4-420g 20- 162 b11 6[u151 Nf4421of24:te20 5er: [3] 5[N: p3No2Io:ot4no2te nl4e]1o, ] 1D 1 I5Bs2In4:i4nn8 z4no Ce4oD[o DBNm=[B:op N: t1ol Me6teIu].etnt ]ei0eI dtMxnI i
enniasonnl DoiiaBDtzn:Biid :an C lgroIi wnmzb_ipaultltfoieifcatoeklenrsid z opuiifosnn oegibl u,Wtb2f iiu0fsanf1eildf8rzioe- ezwrp1 as o0=t po- iiol21ono
66ntl . e,10or2M fl:
o5bc3uk:fe2fd4e rf1 u1pn5oc0ot8li
o[nNssoi
tze] eI n=n o1DB6:. 0CMo
mpleted initialization of buffer pool
2018-10-26 12:53:24 11544 [Note] InnoDB: _mm_lfe2n018-10-c2e6( )1 2a:n5d3 :_2m4m _9s1f2e8n c[eN(o)t ea]r eI nunsoeDdB :f oHri gmheemsotr ys ubpaprorriteerd
file format is Barracuda.
2018-10-26 12:53:24 11420 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 12:53:24 132002108-10- 2[6E R1R2O:R5]3 :I24 11n5noDB: C:\X4a8m p[ERROR] InnopD\Bm:y sCq:l\\Xamppd\amtyas\qilb\ddaattaa1\ icbadna'tta 1b ec aonp'etn ebde ionp erneeadd -iwnr irteea dm-ode
write mode
2018-10-26 12:5230:124 811-51408- 2[6E RROR] InnoDB: The system tablesp1a2ce mu:st5 3b:e2 4w r1i3t0a2b0l e[!E
RROR] InnoDB: T201h8e- 1s0-26 y1s2:53t:e2m4 t1a2b4l4e4s p[aNcoet em]u sItn nboeD Bw:r iCtoampl2e0t1e8d- 1i0n-i2t6i a1l2i:z5a3t:ib2o4n 1lo1ef5! 4
b8u f[fEeRROR] rP lpuogoiln
'InnoDB' init function returned error.
2018-10-26 12:5230:1284- 1901-2286 [1N2o:t5e3]: 2I4nnoDB: 1T3h0e2 0l og2 [s0Ee1Rq8Ru-Oe1n0cRe-] 2 n6u m1b2e:r5 31:8234P5 l01317u5 g4ii8nn [i'EbIRdnRanOtoRa] fPillueg iDdnBo ' ' nIiontn nomiDaBt'c hr etghtie s ftlroagtioun nsacesq a tuSieTonOncR eAr GenEtu umErNbneGrI eN1dE4 9ef7ra0rio7l3e7d .i
n ther i.b
_logfiles!
2018-10-26 12:53:24 11508 [ERROR] InnoDB: C:\Xampp\mysql\data\ibdata1 can't be opened in read-write mode
2018-12018-10-26 01-22:65 31:22:45 31:32042 01 1[5E44R R[ONRo]t eP]l uIgninno D'BI:n nCoompDrBe's sreed tables useg izsltirba t1i.o2n. 3a
s a STORAGE ENGINE failed.
2018-10-26 12:53:24 11420 [ERROR] InnoDB: C:\Xampp\mysql\data\ibdata1 can't be opened in read-write mode
2018-10-22061 81-210-:265 312::2543 :24 1121454444 [[ENote] InnoDB: UsinRgR OgRe]n eIrninco DcBr:c 3C2: \iXnastmrpupc\tmiyosnsq
l\data\ibdata1 can't be opened in read-write mode
2018-10-26 12:53:24 11420 [ERROR] InnoDB: The system tablespace must be writable!
2018-10-26 12:53:24 12444 [ERROR] InnoDB: The system tablespace must be writable!
2018-10-26 12:53:24 12444 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-26 12:53:24 12444 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:24 11508 [ERROR] InnoDB: The system tablespace must be writable!
2018-10-26 12:53:24 11508 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-26 12:53:24 11508 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:24 11544 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:53:24 11420 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-26 12:53:24 11544 [Note] InnoDB: Complet2e0d initialization of buffer pool
18-10-26 12:53:24 11420 [ERROR] 2018-10-26 12:53:24 11548 [Note] PlugPilnu g'iFnE E'DIBACK' is disabled.
nnoDB' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:24 11548 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 11548 [ERROR] Aborting

2018-10-26 12:53:24 12444 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:24 12444 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 12444 [ERROR] Aborting

2018-10-26 12:53:24 13020 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:24 13020 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 13020 [ERROR] Aborting

2018-10-26 12:53:24 11544 [ERROR] InnoDB: C:\Xampp\mysql\data\ibdata1 can't be opened in read-write mode
2018-10-26 12:53:24 11544 [ERROR] InnoDB: The system tablespace must be writable!
2018-10-26 12:53:24 11544 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-26 12:53:24 11544 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:24 11508 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:24 11508 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 11508 [ERROR] Aborting

2018-10-26 12:53:24 11420 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:24 11420 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 11420 [ERROR] Aborting

2018-10-26 12:53:24 11544 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:24 11544 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-10-26 12:53:24 11544 [ERROR] Aborting

2018-10-26 12:53:25 9128 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-10-26 12:53:25 9128 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 12:53:25 9128 [Note] InnoDB: Waiting for purge to start
2018-10-26 12:53:25 9128 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970737
2018-10-26 12:53:25 11092 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 12:53:25 9128 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 12:53:25 9128 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 12:53:25 9128 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:25 9128 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:25 9128 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 12:53:25 9128 [ERROR] Aborting

2018-10-26 12:53:37 3380 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:53:37 13184 [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-10-26 12:53:37 13184 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 12:53:37 13184 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 12:53:37 13184 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 12:53:37 13184 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 12:53:37 13184 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:53:37 13184 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:53:37 13184 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:53:37 13184 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 12:53:37 13184 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 12:53:37 13184 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 14970747 in the ib_logfiles!
2018-10-26 12:53:37 13184 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-10-26 12:53:38 13184 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 12:53:38 13184 [Note] InnoDB: Waiting for purge to start
2018-10-26 12:53:38 13184 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970747
2018-10-26 12:53:38 8588 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 12:53:38 13184 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 12:53:38 13184 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 12:53:38 13184 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 12:53:38 13184 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:53:38 13184 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 12:53:38 13184 [ERROR] Aborting

2018-10-26 12:56:57 3e4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:56:57 996 [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-10-26 12:56:57 996 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 12:56:57 996 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 12:56:57 996 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 12:56:57 996 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 12:56:57 996 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:56:57 996 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:56:57 996 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:56:57 996 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 12:56:57 996 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 12:56:57 996 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 12:56:57 996 [Note] InnoDB: Waiting for purge to start
2018-10-26 12:56:57 996 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970757
2018-10-26 12:56:57 11784 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 12:56:57 996 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 12:56:57 996 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 12:56:57 996 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 12:56:57 996 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:56:57 996 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 12:56:57 996 [ERROR] Aborting

2018-10-26 12:57:15 258c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:57:15 9612 [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-10-26 12:59:03 1c30 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:59:03 7216 [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-10-26 12:59:03 7216 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 12:59:03 7216 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 12:59:03 7216 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 12:59:03 7216 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 12:59:03 7216 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:59:03 7216 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:59:04 7216 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:59:04 7216 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 12:59:04 7216 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 12:59:04 7216 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 12:59:04 7216 [Note] InnoDB: Waiting for purge to start
2018-10-26 12:59:04 7216 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970767
2018-10-26 12:59:04 11920 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 12:59:04 7216 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 12:59:04 7216 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 12:59:04 7216 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 12:59:04 7216 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:59:04 7216 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 12:59:04 7216 [ERROR] Aborting

2018-10-26 12:59:59 250c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 12:59:59 9484 [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-10-26 12:59:59 9484 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 12:59:59 9484 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 12:59:59 9484 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 12:59:59 9484 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 12:59:59 9484 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 12:59:59 9484 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 12:59:59 9484 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 12:59:59 9484 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 12:59:59 9484 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 12:59:59 9484 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 12:59:59 9484 [Note] InnoDB: Waiting for purge to start
2018-10-26 12:59:59 9484 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970777
2018-10-26 12:59:59 3476 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 12:59:59 9484 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 12:59:59 9484 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 12:59:59 9484 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 12:59:59 9484 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 12:59:59 9484 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 12:59:59 9484 [ERROR] Aborting

2018-10-26 13:04:53 18fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 13:04:53 6396 [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-10-26 13:04:53 6396 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 13:04:53 6396 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 13:04:53 6396 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 13:04:53 6396 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 13:04:53 6396 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 13:04:53 6396 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 13:04:53 6396 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 13:04:53 6396 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 13:04:53 6396 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 13:04:53 6396 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 13:04:53 6396 [Note] InnoDB: Waiting for purge to start
2018-10-26 13:04:53 6396 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970787
2018-10-26 13:04:53 1588 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 13:04:53 6396 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 13:04:53 6396 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 13:04:53 6396 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 13:04:53 6396 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 13:04:53 6396 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 13:04:53 6396 [ERROR] Aborting

2018-10-26 14:59:25 3378 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 14:59:25 13176 [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-10-26 14:59:25 13176 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 14:59:25 13176 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 14:59:25 13176 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 14:59:25 13176 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 14:59:25 13176 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 14:59:25 13176 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 14:59:25 13176 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 14:59:25 13176 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 14:59:25 13176 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 14:59:26 13176 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 14:59:26 13176 [Note] InnoDB: Waiting for purge to start
2018-10-26 14:59:26 13176 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970797
2018-10-26 14:59:26 13648 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 14:59:26 13176 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 14:59:26 13176 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 14:59:26 13176 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-10-26 14:59:26 13176 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-26 14:59:26 13176 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2018-10-26 14:59:26 13176 [ERROR] Aborting

2018-10-26 15:41:28 2650 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-26 15:41:28 9808 [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-10-26 15:41:28 9808 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-26 15:41:28 9808 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-26 15:41:28 9808 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-26 15:41:28 9808 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-26 15:41:28 9808 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-26 15:41:28 9808 [Note] InnoDB: Using generic crc32 instructions
2018-10-26 15:41:28 9808 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-10-26 15:41:28 9808 [Note] InnoDB: Completed initialization of buffer pool
2018-10-26 15:41:28 9808 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-26 15:41:28 9808 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-26 15:41:28 9808 [Note] InnoDB: Waiting for purge to start
2018-10-26 15:41:28 9808 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 14970807
2018-10-26 15:41:28 1092 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-10-26 15:41:28 9808 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-10-26 15:41:28 9808 [ERROR] Plugin 'Aria' init function returned error.
2018-10-26 15:41:28 9808 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.




I don't know a lot about XAMPP could someone help me correct this error- I don't want to have to start over on the website- I do have a full backup two days ago but made many changes last couple days
RSLCS007
 
Posts: 1
Joined: 26. October 2018 20:52
XAMPP version: 3.2.2
Operating System: Windows 10 64 Bit

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests