Jump to content
Amilton

Problema com Mysql

Recommended Posts

Amilton

Apos executar uma query para apagar algumas linhas de uma tabela do meu banco de dados, o mysql simplesmente parou de funcionar.

Quando executo o comando: service mysql start  ele me retorna: start: Job failed to start

Ja tentei executar: service mysql restart e tambem não funcionou

O mysql não está em execução e simplesmente não inicia. Servidor linux.

Não consigo acessar o mysql de nenhuma maneira. Antes ele estava funcionando normalmente e agora não está.

 

/*****************************************************************/var/log/mysql/error.log********************************************************************************/

170605  9:49:12 [Note] Plugin 'FEDERATED' is disabled.
170605  9:49:12 InnoDB: The InnoDB memory heap is disabled
170605  9:49:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170605  9:49:12 InnoDB: Compressed tables use zlib 1.2.3.4
170605  9:49:12 InnoDB: Initializing buffer pool, size = 128.0M
170605  9:49:12 InnoDB: Completed initialization of buffer pool
170605  9:49:12 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 97859737067
170605  9:49:12  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 97860968674
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 1C0C5A00
170605  9:49:12  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 InnoDB: Next record offset is nonsensical 17408 in record at offset 1031
InnoDB: rec address 0x7f544ac98407, space id 0, page 550323
170605  9:49:12  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 63d0c555000865b30007a7690005240500000016c8f4162045bf000000000000000000000000003c3629010b000000003623000500000109000000001c0bc2990000ffffffff00000000ffffffff000000074160 7c004a0000000000000000080100000331156961 6e66696d756d000908000803000073757072656d756d002824190905040000100d00bd00000000000007554400010101010f000e80088603000480003032343739353939363034800129782824190905040000180d00f100000062 00000007554400020101010f000e80088603000480003032343739353836363236800152ce2824190905040000200d012500000000000007554400030101010f000e8008860300048000303263 34373838383936363880016c18282419090504050064 280d015900000000000007554400040101010f000e8008860300048000303234373838333836373280016f142824190905040000300d018d00000000000007554400050101010f000e800886030004800030323437383631373636388001e3d82824190905040000380d01c100000000000007554400060101010f000e800886030004800030323438303137303633328001ef142824190905040000400d01f500000000000007554400070101010f000e800886030004800030323438303337343633378001fbea2824190905040400480d022900000000000007554400080101010f000e8008860300048000303234373933343638323080023aef2824190905040000500d025d00000000000007554400090101010f000e8008860300048000303234383033363636313880023c342824190905040000580d0291000000000000075544000a0101010f000e80088603000480003032343737393830363130800241b52824190905040000600d02c5000000000000075544000b0101010f000e800886030004800030323437393639393636388002640d2824190905040400680d02f9000000000000075544000c0101010f000e800886030004800030323437393434303638308002b7d32824190905040000700d032d000000000000075544000d0101010f000e80088603000480003032343738313936363230800359332824190905040000780d0361000000000000075544000e0101010f000e80088603000480003032343739393733313538800364d52824190905040000800d0395000000000000075544000f0101010f000e800886030004800030323437393433383630308003b7c42824190905040400880d03c900000000000007554400100101010f000e800886030004800030323438303330373630338003b7eb2824190905040000900d03fd00000000000007554400110101010f000e800886030004800030323437383634313631358003debd2824190905040000980d043100000000000007554400120101010f000e8008860300048000303234373935343336353080043f2d2824190905040000a00d046500000000000007554400130101010f000e80088603000480003032343830343039363030800459892824190905040400a80d049900000000000007554400140101010f000e8008860300048000303234373933353436383780045a6e2824190905040000b00d04cd00000000000007554400150101010f000e8008860300048000303234373930313036373880045b562824190905040000b80d050100000000000007554400160101010f000e80088603000480003032343830333630363837800478622824190905040000c00e053500000000000007554400170101010f000e800886030004800030323437383737333630308004789f2824190905040400c80d056900000000000007554400180101010f000e80088603000480003032343739343335363837800478d82824190905040000d00d059d00000000000007554400190101010f000e80088603000480003032343830303030363330800478dd2824190905040000d80d05d1000000000000075544001a0101010f000e80088603000480003032343739343433363034800479022824190905040000e00d0605000000000000075544001b0101010f000e80088603000480003032343830343235363439800479032824190905040400e80d0639000000000000075544001c0101010f000e80088603000480003032343739323439363230800479152824190905040000f00d066d000000000000075544001d0101010f000e80088603000480003032343830343530363738800465 793c2824190905040000f80d06a1000000000000075544001e0101010f000e80088603000480003066 32343738363834363931800479b02824190905040001000d06d5000000000067 00075544001f0101010f000e80088603000480003032343738363834363931800479b32824190905040401080d070900000000000007554400200101010f000e8008860300048000303234373931393236383780047a002824190905040001100d0768 3d00000000000007554400210101010f000e800869 860300048000303234373931303936313580047a4c2824190905040001180d077100000000000007554400220101010f000e8008860300048000303234383030363936373280047a4d2824190905040001200d07a500000000000007554400230101010f000e8008860300048000303234373934303036323080047af82824190905040401280d07d90000000000000755440070 240101010f000e80088603000480003032343738363971 3236303080047b0d2824190905040001300d080d00000000000007554400250101010f000e80088603000472 8000303234383031373436323080047b292824190905040001380d084100000000000007554400260101010f000e8008860300048000303234373938373736303480047b302824190905040001400d087500000000000007554400270101010f000e8008860300048000303234373937363136343980047b412824190905040401480d08a900000000000007554473 00280101010f000e800886030074 048000303234373934313936343980047b772824190905040001500d08dd00000000000007554400290101010f000e800886030004800030323475 383030353036353380047bbf2824190905040001580d0911000000000000075544002a0101010f000e8008860300048000303234373838303336313580047bef2824190905040001600d0945000000000000075544002b0101010f000e8008860300048000303234373934313936343980047bf22824190905040401680d0979000000000000075544002c0101010f000e8008860300048000303234373833313536353380047c282824190905040001700d09ad000000000000075544002d0101010f000e8008860300048000303234373935333236313580047c622824190905040001780d09e1000000000000075544002e0101010f000e8008860300048000303234373931323536353380047cc72824190905040001800d0a15000000000000075544002f0101010f000e8008860300048000303234373932363536363880047cf42824190905040401880d0a4900000000000007554400300101010f000e8008860300048000303234373930303136383780047cfc2824190905040001900d0a7d00000000000007554400310101010f000e8008860300048000303234383033363036383780047d882824190905040001980d0ab100000000000007554400320101010f000e80088603000480003032343739383639363837800491332824190905040001a00d0ae500000000000007554400330101010f000e80088603000480003032343830343039363030800491362824190905040401a80d0b1900000000000007554400340101010f000e800886030004800030323437393138343636388004917d2824190905040001b00d0b4d00000000000007554400350101010f000e80088603000480003032343738333636363439800491fc2824190905040001b80d0b8100000000000007554400360101010f000e80088603000480003032343830343137363230800492022824190905040001c00d0bb500000000000007554400370101010f000e80088603000480003032343739393832363533800492412824190905040401c80d0be900000000000007554400380101010f000e800886030004800030323437383333313639318004924d2824190905040001d00d0c1d00000000000007554400390101010f000e80088603000480003032343830333630363837800492642824190905040001d80d0c51000000000000075544003a0101010f000e80088603000480003032343739323635363638800492c52824190905040001e00d0c85000000000000075544003b0101010f000e800886030004800030323437383635303630368004946b2824190905040401e80d0cb9000000000000075544003c0101010f000e800886030004800030323437393236353636388004a90e2824190905040001f00d0ced000000000000075544003d0101010f000e800886030004800030323437383132393630348004b3d32824190905040001f80d0d21000000000000075544003e0101010f000e800886030004800030323438303138323634398004b4522824190905040002000d0d55000000000000075544003f0101010f000e800886030004800030323438303338373631358004b45b2824190905040402080d0d8900000000000007554400400101010f000e800886030004800030323437393434333630348004ba3b2824190905040002100d0dbd00000000000007554400410101010f000e800886030004800030323437383138383630308004d87d2824190905040002180d0df100000000000007554400420101010f000e800886030004800030323437373935353639318004d94c2824190905040002200d0e2500000000000007554400430101010f000e800886030004800030323437383134353633348004d94d2824190905040402280d0e5900000000000007554400440101010f000e800886030004800030323437393537353639318004d94e2824190905040002300d0e8d00000000000007554400450101010f000e80088603000480003032343738323376 343635338004d99a2824190905040002380d0ec100000000000007554400460101010f000e800886030004800030323437383431323639318004d9c82824190905040002400d77 0ef500000000000007554400470101010f000e800886030004800030323438303232373638358004daa72824190905040402480d0f2900000000000007554400480101010f000e800886030004800030323437393734353630308004e3b62824190905040002500d0f5d00000000000007554400490101010f000e800886030004800030323437383230303637388004e4342824190905040002580d0f91000000000000075544004a0101010f000e800886030004800030323437383133373631358004e4652824190905040002600d0fc5000000000000075544004b0101010f000e800886030004800030323437383430343637328004e5e12824190905040402680d0ff9000000000000075544004c0101010f000e800886030004800030323437393938323635338004e6372824190905040002700d102d000000000000075544004d0101010f000e800886030004800030323437393636343630308004f1982824190905040002780d1061000000000000075544004e0101010f000e800886030004800030323437393437383635338004f46a2824190905040002800d1095000000000000075544004f0101010f000e800886030004800030323437383531323634358004f5fd2824190905040402880d10c900000000000007554400500101010f000e800886030004800030323437383134353633348005092b2824190905040002900d10fd00000000000007554400510101010f000e80088603000480003032343738333832363837800516162824190905040002980d113100000000000007554400520101010f000e800886030004800030323437373932303633348005163f2824190905040002a00d116500000000000007554400530101010f000e80088603000480003032343737393230363334800517da2824190905040402a80d119900000000000007554400540101010f000e80088603000480003032343737393339363533800518612824190905040002b00d11cd00000000000007554400550101010f000e8008860300048000303234373834353536363880051a422824190905040002b80d120100000000000007554400560101010f000e80088603000480003032343739303935363439800524dc2824190905040002c00d123500000000000007554400570101010f000e80088603000480003032343738353031363030800524fe2824190905040402c80d126900000000000007554400580101010f000e80088603000480003032343830333138363438800529612824190905040002d00d129d00000000000007554400590101010f000e8008860300048000303234383034313637333980052ea52824190905040002d80d12d1000000000000075544005a0101010f000e80088603000480003032343738343535303732800531ff2824190905040002e00d1305000000000000075544005b0101010f000e80088603000480003032343830343638363135800541f62824190905040402e80d1339000000000000075544005c0101010f000e80088603000480003032343738353238363439800541fd2824190905040002f00d136d000000000000075544005d0101010f000e80088603000480003032343738353031363030800542ff2824190905040002f80d13a1000000000000075544005e0101010f000e80088603000480003032343738323334363533800544812824190905040003000d13d5000000000000075544005f0101010f000e80088603000480003032343738313838363030800544d22824190905040403080d140900000000000007554400600101010f000e80088603000480003032343738313838363030800545782824190905040003100d143d00000000000007554400610101010f000e8008860300048000303234373935383336303080054769282419090578 040003180d147100000000000007554400620101010f000e800886030004800030323437393130303636398005b7452824190905040003200d14a50000000000000755440063010179 010f000e800886030004800030323437383230313732308005cb6a2824190905040403280d14d900000000000007554400640101010f000e80088603000480003032343739313632363939800629c52824190905040003300d150d00000000000007554400650101010f000e8008860300048000303234373931363336363080062d392824190905040003380d154100000000000007554400660101010f000e80088603000480003032343738313736383636800637d92824190905040003400d157500000000000007554400670101010f000e8008860300048000303234373835303936393580063b2b2824190905040403480d15a900000000000007554400680101010f000e80088603000480003032343830343133313238800660652824190905040003500d15dd00000000000007554400690101010f000e80088603000480003032343738343232363534800676ea2824190905040003580d1611000000000000075544006a0101010f000e8008860300048000303234373936383037323080068aa82824190905040003600d1645000000000000075544006b0101010f000e8008860300048000303234383032323836353780068e802824190905040403680d1679000000000000075544006c0101010f000e8008860300048000303234373835313136373380068f712824190905040003700d16ad000000000000075544006d0101010f000e800886030004800030323437393130303636398006cc132824190905040003780d16e1000000000000075544006e0101010f000e800886030004800030323437393134363635308006e9e52824190905040003800d1715000000000000075544006f0101010f000e800886030004800030323437383532363630338006ef052824190905040403880d174900000000000007554400700101010f000e80088603000480003032343739323933313036800743852824190905040003900d177d00000000000007554500000101010f000e8008860300048000303034303137353336373080006a582824190905040003980d17b100000000000007554500010101010f000e8008860300048000303034303137323736373080007f8c2824190905040003a00d17e500000000000007554500020101010f000e80088603000480003030343031373339363836800081de2824190905040403a80d181900000000000007554500030101010f000e80088603000480003030343031373436363233800083872824190905040003b00d184d00000000000007554500040101010f000e800886030004800030303430313733333634358000b8b12824190905040003b80d188100000000000007554500050101010f000e80088603000480003030343031373337363332800100692824190905040003c00d18b500000000000007554500060101010f000e800886030004800030303430313334323631318001819e2824190905040403c80d18e900000000000007554500070101010f000e80088603000480003030343031373739363337800215d72824190905040003d00d191d00000000000007554500080101010f000e8008860300048000303034303137363636353980028f282824190905040003d80d195100000000000007554500090101010f000e80088603000480003030343032303234363133800301ac2824190905040003e00d1985000000000000075545000a0101010f000e8008860300048000303034303232333436393380040e262824190905040403e80d19b9000000000000075545000b0101010f000e80088603000480003030343031383835363636800423f32824190905040003f00d19ed000000000000075545000c01010180 0f000e80088603000480003030343031353630363030800518912824190905040003f80d1a21000000000000075545000d0101010f000e8008860381 0004800030303430323337303630308005189a2824190905040004000d1a55000000000000075545000e0101010f000e80088603000480003030343031383534363034800519be2824190905040404080d3149000000000000075545000f0101010f000e80088603000480003030343031373232363030800524262824190905040004100d317d00000000000007554500100101010f000e80088603000480003030343031373232363030800542322824190905040004180d31b100000000000007554500110101010f000e80088603000480003030343031373831363135800542332824190905040004200d31e500000000000007554500120101010f000e80088603000480003030343032303031363732800547282824190905040804280d321900000000000007554500130101010f000e80088603000480003030343031393237363837800547482824190905040004300d324d00000000000007554500140101010f000e80088603000480003030343032313235363439800548102824190905040004380d328100000000000007554500150101010f000e80088603000480003030343032303336363230800548282824190905040004400d32b500000000000007554500160101010f000e80088603000480003030343032353234363931800548382824190905040804480d32e900000000000007554500170101010f000e80088603000480003030343031363932363034800549712824190905040004500d331d00000000000007554500180101010f000e80088603000480003030343032303238363030800549722824190905040004580d335100000000000007554500190101010f000e80088603000480003030343032313932363732800549a42824190905040004600d3385000000000000075545001a0101010f000e8008860300048000303034303135383736343980054a062824190905040804680d33b9000000000000075545001b0101010f000e8008860300048000303034303230373936303480054abe2824190905040004700d33ed000000000000075545001c0101010f000e8008860300048000303034303138333836363880054adc2824190905040004780d3421000000000000075545001d0101010f000e80088603000480003030343032333131363034800569e52824190905040004800d3455000000000000075545001e0101010f000e8008860300048000303034303230333636323080056a3c2824190905040804880d3489000000000000075545001f0101010f000e8008860300048000303034303139313936363880056ba92824190905040004900d34bd00000000000007554500200101010f000e8008860300048000303034303235333236303080056bc72824190905040004980d34f100000000000007554500210101010f000e8008860300048000303034303138303336303080056c802824190905040004a00d352500000000000007554500220101010f000e80088603000480003030343032343738363439800581572824190905040804a80d355900000000000007554500230101010f000e80088603000480003030343032313431363837800583e62824190905040004b00d358d00000000000007554500240101010f000e80088603000480003030343031353031363034800583ff2824190905040004b80d35bb00000000000007554500250101010f000e80088603000480003030343031383937363732800584882824190935f00004c00d1f3500000000000007554500260101010f000e800886030004800030303430323032383630308005a33e2824190905362304c80d1f6900000000000007554500270101010f000e800886030004800030303430323335343637328005a34e2824190905040004d00d1f9d00000000000007554500280101010f000e8008860300048000303034303230363082 3638378005a3f92824190905040004d80d1fd100000000000007554500290101010f000e800886030004800030303430323139323637328005a4592824190905040004e00d2005000000000000075545002a0101010f000e800886030004800030303430313837303633348005a9e72824190905040404e80d2039000000000000075545002b0101010f000e800886030004800030303430323238313639318005dfe12824190905040004f00d206d000000000000075545002c0101010f000e800886030004800030303430323434333639318005e04f2824190905040004f80d20a1000000000000075545002d0101010f000e800886030004800030303430313937383637328005e4e52824190905040005000d20d5000000000000075545002e0101010f000e80088603000480003030343032313235363439800603c82824190905040405080d2109000000000000075545002f0101010f000e800886030004800030303430313932373638378006044b2824190905040005100d213d00000000000007554500300101010f000e80088603000480003030343032343139363334800606202824190905040005180d217100000000000007554500310101010f000e80088603000480003030343032323036363439800606302824190905040005200d21a500000000000007554500320101010f000e80088603000480003030343032313736363334800608552824190905040405280d21d900000000000007554500330101010f000e8008860300048000303034303139313936363880060a3e2824190905040005300d220d00000000000007554500340101010f000e800886030004800030303430313435303737358006e8592824190905040005380d224100000000000007554500350101010f000e800886030004800030303430313935303636328006fbe32824190905040005400d227500000000000007554500360101010f000e8008860300048000303034303138363336393780073c252824190905040405480d22a900000000000007554500370101010f000e80088603000480003030343032343032363639800774a32824190905040005500d22dd00000000000007554500380101010f000e800886030004800030303430323436323634358007957c2824190905040005580d231100000000000007554500390101010f000e80088603000480003030343032333533363039800798232824190905040005600d2345000000000000075545003a0101010f000e80088603000480003030343032333535363434800798282824190905040405680d2379000000000000075545003b0101010f000e80088603000480003030343032333539363331800798902824190905040005700d23ad000000000000075545003c0101010f000e8008860300048000303034303234303736323880079ce72824190905040005780d23e100000000000007554800000101010f000e8008860300048000303031353534303636393880007f142824190905040005800d241500000000000007554800010101010f000e800886030004800030303135353331383634308000816b2824190905040405880d244900000000000007554800020101010f000e80088603000480003030313535323734363836800085a52824190905040005900d247d00000000000007554800030101010f000e8008860300048000303031353533373236393680008fea2824190905040005980d24b100000000000007554800040101010f000e800886030004800030303135353335383630308000a2422824190905040005a00d24e500000000000007554800050101010f000e800886030004800030303135353334343634318000a4192824190905040405a80d251900000000000007554800060101010f000e800886030004800030303135353331393631328000a6dc2824190905040005b00d254d00000000000007554800070101010f000e800886030004800030303135353338383639308000a9622824190905040005b80d258100000000000007554800080101010f000e800886030004800030303135353237353635388000b9c82824190905040005c00d25b500000000000007554800090101010f000e800886030004800030303135353236313630368000c8af2824190905040405c80d25e9000000000000075548000a0101010f000e800886030004800030303135353339323631318000e1392824190905040005d00d261d000000000000075548000b0101010f000e800886030004800030303135353235363630328000e4502824190905040005d80d2651000000000000075548000c0101010f000e800886030004800030303135353330303630318000e8482824190905040005e00d2685000000000000075548000d0101010f000e800886030004800030303135353237323633328001017d2824190905040405e80d26b9000000000000075548000e0101010f000e80088603000480003030313535323835363130800106112824190905040005f00d26ed000000000000075548000f0101010f000e8008860300048000303031353533333236333580011de42824190905040005f80d272100000000000007554800100101010f000e8008860300048000303031353533303836383880012ae62824190905040006000d275500000000000007554800110101010f000e800886030004800030303135343732333631348001374b2824190905040406080d278900000000000007554800120101010f000e80088603000480003030313535323938363037800144152824190905040006100d27bd00000000000007554800130101010f000e80088603000480003030313535363136313533800151822824190905040006180d27f100000000000007554800140101010f000e800886030004800030303135343637333638348001d5fa2824190905040006200d282500000000000007554800150101010f000e800886030004800030303135343636333631318001f4cf2824190905040406280d285900000000000007554800160101010f000e800886030004800030303135343632363638368001f8f02824190905040006300d288d00000000000007554800170101010f000e8008860300048000303031353436313736393580020f182824190905040006380d28c100000000000007554800180101010f000e8008860300048000303031353436373136333080021c492824190905040006400d28f500000000000007554800190101010f000e80088603000480003030313534363338363932800224222824190905040406480d2929000000000000075548001a0101010f000e8008860300048000303031353436393636323580022f2a2824190905040006500d295d000000000000075548001b0101010f000e80088603000480003030313534363234363332800231072824190905040006580d2991000000000000075548001c0101010f000e80088603000480003030313534373234363936800249612824190905040006600d29c5000000000000075548001d0101010f000e8008860300048000303031353436313736393580024b222824190905040406680d29f9000000000000075548001e0101010f000e800886030004800030303135343631383636378002697f2824190905040006700d2a2d000000000000075548001f0101010f000e800886030004800030303135353138343639358002822d2824190905040006780d2a6100000000000007554800200101010f000e80088603000480003030313534363137363935800296da2824190905040006800d2a9500000000000007554800210101010f000e800886030004800030303135353139313633328002c1ea2824190905040406880d2ac900000000000007554800220101010f000e800886030004800030303135343633343630338002f00f2824190905040006900d2afd00000000000007554800230101010f000e800886030004800030303135343638343631398002f4842824190905040006980d2b3100000000000007554800240101010f000e8008860300048000303031353437313336353180032ec02824190905040006a00d2b6500000000000007554800250101010f000e800886030004800030303135343631363631338003cdb02824190905040406a80d2b9900000000000007554800260101010f000e80088603000480003030313534363736363038800452342824190905040006b00d2bcd00000000000007554800270101010f000e80088603000480003030313534363637363039800460742824190905040006b80d2c0100000000000007554800280101010f000e8008860300048000303031353539303936383180046e5a2824190905040006c00d2c3500000000000007554800290101010f000e8008860300048000303031353537383736333280048b902824190905040406c80d2c69000000000000075548002a0101010f000e800886030004800030303135353139313633328004d2c12824190905040006d00d2c9d000000000000075548002b0101010f000e800886030004800030303135343634333639368004eb4e2824190905040006d80d2cd1000000000000075548002c0101010f000e80088603000480003030313534323735363033800563aa2824190905040006e00d2d05000000000000075548002d0101010f000e80088603000480003030313534333237363937800612ea2824190905040406e80d2d39000000000000075548002e0101010f000e80088603000480003030313534323531363930800623822824190905040006f00d2d6d000000000000075548002f0101010f000e80088603000480003030313534323833363232800635f22824190905040006f80d2da100000000000007554800300101010f000e800886030004800030303135343836353136388006aa482824190905040007000d2dd500000000000007554800310101010f000e800886030004800030303135353232343636328006d7832824190905040407080d2e0900000000000007554800320101010f000e800886030004800030303135353233323638318006db132824190905040007100d2e3d00000000000007554800330101010f000e800886030004800030303135353137373634388006dcb72824190905040007180d2e7100000000000007554800340101010f000e800886030004800030303135353230363638308006fcc22824190905040007200d2ea500000000000007554800350101010f000e80088603000480003030313535343939363838800700e62824190905040407280d2ed900000000000007554800360101010f000e80088603000480003030313535323031363131800701a92824190905040007300d2f0d00000000000007554800370101010f000e80088603000480003030313535323138363937800702d92824190905040007380d2f4100000000000007554800380101010f000e800886030004800030303135353532333635318007040e2824190905040007400d2f7500000000000007554800390101010f000e800886030004800030303135353139363630308007044d2824190905040407480d2fa9000000000000075548003a0101010f000e80088603000480003030313534373136363737800720932824190905040007500d2fdd000000000000075548003b0101010f000e80088603000480003030313534323733363630800731752824190905040007580d3011000000000000075548003c0101010f000e80088603000480003030313535343838363433800735f72824190905040007600d3045000000000000075548003d0101010f000e8008860300048000303031353535303336323680073e762824190905040007680d30790000000083 0000075548003e0101010f000e80088603000480003030313534323637363934800741242824190905040007700d30ad000000000000075548003f0101010f000e8008860300048000303031353535363336303280075e682824190905040007780d30e100000000000007554800400101010f000e8008860300048000303031353535353736333780075ee42824190905040007800d007400000000000007554800410101010f000e800886030004800030303135353534353632308007956d2824190905040007880d008900000000000007533600150101010f000e8008860300048000323330343131303236363880068ca22824190905040007900d1a8900000000000007554500160101010f000e80088603000480003233303432363536363931800773c72824190905040007980d1abd00000000000007553700000101010f000e80088603000480003433323530303530363434800012bf2824190905040007a00d1af100000000000007554500010101010f000e800886030004800034333234393431383636388000d47d2824190905040007a80d1b2500000000000007554500020101010f000e800886030004800034333235303331393630308000f6b62824190905040007b00d1b5900000000000007554500030101010f000e800886030004800034333236303232353636388001b5c42824190905040007b80d1b8d00000000000007554500040101010f000e800886030004800034333236303036333636388001fe132824190905040007c00d1bc100000000000007554500050101010f000e80088603000480003433323530303431363533800231ed2824190905040007c80d1bf500000000000007554500060101010f000e8008860300048000343332353939393536363880024e042824190905040007d00d1c2900000000000007554500070101010f000e80088603000480003433323535333435363334800273dc2824190905040007d80d1c5d00000000000007554500080101010f000e8008860300048000343332343931333236393180027e5a2824190905040007e00d1c9100000000000007554500090101010f000e8008860300048000343332353434303336343980029b9b2824190905040007e80d1cc5000000000000075545000a0101010f000e800886030004800034333235303331393630308002ab462824190905040007f00d1cf9000000000000075545000b0101010f000e800886030004800034333235313734393430348002f2d72824190905040007f80d1d2d000000000000075545000c0101010f000e800886030004800034333235373439363136388003db892824190905040008000d1d61000000000000075545000d0101010f000e80088603000480003433323439323939363334800438332824190905040008080d1d95000000000000075545000e0101010f000e8008860300048000343332353633363836323080048cb22824190905040008100d1dc9000000000000075545000f0101010f000e800886030004800034333236303437303632308004ff802824190905040008180d1dfd00000000000007554500100101010f000e80088603000480003433323439383932363533800638592824190905040008200d1e3100000000000007554500110101010f000e8008860300048000343332353937313536343980063ed32824190905040008280d1e6500000000000007554500120101010f000e800886030004800034333234393438353639318006d2fa2824190905040008300d1e9900000000000007554500130101010f000e8008860300048000343332353837303031363880074964221e190905040008380d1ecd00000000000007540d00000101010f003280088603000480004152434f538000ab962925190905040008400d1f0100000000000007542900000101010f003280088603000480004e4f56412053455252414e41800159e12d29190905040008480d050400000000000007543700000101010f0032800886030004800053414e54414e4120444f20414c464945800153ff2008500104070000c94a547f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000084 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000742f752ea52dd52d052c352b652a9529c528f528252755268525b524e524152345227521a520d520051f351e651d951cc51bf51b251a55198518b517e517151645157514a513d513051235116510950fc50ef50e250d550c850bb50ae50a150945087507a506d5060505350465039502c501f50125006500000016c8f41620; asc c  U  e    i  $         E              <6)      6#                                A| J             1 infimum        supremum ($                 UD                02479599604  )x($                 UD                02479586626  R ($         %       UD                02478889668  l ($      (  Y       UD                02478838672  o ($      0          UD                02478617668    ($      8          UD                02480170632    ($      @          UD                02480374637    ($      H  )       UD                02479346820  : ($      P  ]       UD                02480366618  <4($      X          UD                02477980610  A ($      `          UD                02479699668  d ($      h          UD                02479440680    ($      p  -       UD                02478196620  Y3($      x  a       UD                02479973158  d ($                 UD                02479438600    ($                 UD                02480307603    ($                 UD                02478641615    ($         1       UD                02479543650  ?-($         e       UD                02480409600  Y ($                 UD                02479354687  Zn($                 UD                02479010678  [V($                 UD                02480360687  xb($         5       UD                02478773600  x ($         i       UD                02479435687  x ($                 UD                02480000630  x ($                 UD                02479443604  y ($                 UD                02480425649  y ($         9       UD                02479249620  y ($         m       UD                02480450678  y<($                 UD                02478684691  y ($                 UD                02478684691  y ($                 UD                02479192687  z ($         =       UD !              02479109615  zL($         q       UD "              02480069672  zM($                 UD #              02479400620  z ($      (          UD $              02478692600  { ($      0          UD %              02480174620  {)($      8  A       UD &              02479877604  {0($      @  u       UD '              02479761649  {A($      H          UD (              02479419649  {w($      P          UD )              02480050653  { ($      X          UD *              02478803615  { ($      `  E       UD +              02479419649  { ($      h  y       UD ,              02478315653  |(($      p          UD -              02479532615  |b($      x          UD .              02479125653  | ($                 UD /              02479265668  | ($         I       UD 0              02479001687  | ($         }       UD 1              02480360687  } ($                 UD 2              02479869687   3($                 UD 3              02480409600   6($                 UD 4              02479184668   }($         M       UD 5              02478366649    ($                 UD 6              02480417620    ($                 UD 7              02479982653   A($                 UD 8              02478331691   M($                 UD 9              02480360687   d($         Q       UD :              02479265668    ($                 UD ;              02478650606   k($                 UD <              02479265668    ($                 UD =              02478129604    ($         !       UD >              02480182649   R($         U       UD ?              02480387615   [($                 UD @              02479443604   ;($                 UD A              02478188600   }($                 UD B              02477955691   L($         %       UD C              02478145634   M($      (  Y       UD D              02479575691   N($      0          UD E              02478234653    ($      8          UD F              02478412691    ($      @          UD G              02480227685    ($      H  )       UD H              02479745600    ($      P  ]       UD I              02478200678   4($      X          UD J              02478137615   e($      `          UD K              02478404672    ($      h          UD L              02479982653   7($      p  -       UD M              02479664600    ($      x  a       UD N              02479478653   j($                 UD O              02478512645    ($                 UD P              02478145634   +($                 UD Q              02478382687    ($         1       UD R              02477920634   ?($         e       UD S              02477920634    ($                 UD T              02477939653   a($                 UD U              02478455668   B($                 UD V              02479095649  $ ($         5       UD W              02478501600  $ ($         i       UD X              02480318648  )a($                 UD Y              02480416739  . ($                 UD Z              02478455072  1 ($                 UD [              02480468615  A ($         9       UD \              02478528649  A ($         m       UD ]              02478501600  B ($                 UD ^              02478234653  D ($                 UD _              02478188600  D ($                 UD `              02478188600  Ex($         =       UD a              02479583600  Gi($         q       UD b              02479100669   E($                 UD c              02478201720   j($      (          UD d              02479162699  ) ($      0          UD e              02479163660  -9($      8  A       UD f              02478176866  7 ($      @  u       UD g              02478509695  ;+($      H          UD h              02480413128  `e($      P          UD i              02478422654  v ($      X          UD j              02479680720    ($      `  E       UD k              02480228657    ($      h  y       UD l              02478511673   q($      p          UD m              02479100669    ($      x          UD n              02479146650    ($                 UD o              02478526603    ($         I       UD p              02479293106  C ($         }       UE                00401753670  jX($                 UE                00401727670    ($                 UE                00401739686    ($                 UE                00401746623    ($         M       UE                00401733645    ($                 UE                00401737632   i($                 UE                00401342611    ($                 UE                00401779637    ($                 UE                00401766659   (($         Q       UE                00402024613    ($                 UE                00402234693   &($                 UE                00401885666  # ($                 UE                00401560600    ($         !       UE                00402370600    ($         U       UE                00401854604    ($        1I       UE                00401722600  $&($        1}       UE                00401722600  B2($        1        UE                00401781615  B3($        1        UE                00402001672  G(($      ( 2        UE                00401927687  GH($      0 2M       UE                00402125649  H ($      8 2        UE                00402036620  H(($      @ 2        UE                00402524691  H8($      H 2        UE                00401692604  Iq($      P 3        UE                00402028600  Ir($      X 3Q       UE                00402192672  I ($      ` 3        UE                00401587649  J ($      h 3        UE                00402079604  J ($      p 3        UE                00401838668  J ($      x 4!       UE                00402311604  i ($        4U       UE                00402036620  j<($        4        UE                00401919668  k ($        4        UE                00402532600  k ($        4        UE !              00401803600  l ($        5%       UE "              00402478649   W($        5Y       UE #              00402141687    ($        5        UE $              00401501604    ($        5        UE %              00401897672    ($  5      5       UE &              00402028600   >($   6#    i       UE '              00402354672   N($                 UE (              00402060687    ($                 UE )              00402192672   Y($                 UE *              00401870634    ($         9       UE +              00402281691    ($         m       UE ,              00402443691   O($                 UE -              00401978672    ($                 UE .              00402125649    ($        !        UE /              00401927687   K($        !=       UE 0              00402419634    ($        !q       UE 1              00402206649   0($        !        UE 2              00402176634   U($      ( !        UE 3              00401919668   >($      0 "        UE 4              00401450775   Y($      8 "A       UE 5              00401950662    ($      @ "u       UE 6              00401863697  <%($      H "        UE 7              00402402669  t ($      P "        UE 8              00402462645   |($      X #        UE 9              00402353609   #($      ` #E       UE :              00402355644   (($      h #y       UE ;              00402359631    ($      p #        UE <              00402407628    ($      x #        UH                00155406698    ($        $        UH                00155318640   k($        $I       UH                00155274686    ($        $}       UH                00155372696    ($        $        UH                00155358600   B($        $        UH                00155344641    ($        %        UH                00155319612    ($        %M       UH                00155388690   b($        %        UH                00155275658    ($        %        UH                00155261606    ($        %        UH                00155392611   9($        &        UH                00155256602   P($        &Q       UH                00155300601   H($        &        UH                00155272632   }($        &        UH                00155285610    ($        &        UH                00155332635    ($        '!       UH                00155308688  * ($        'U       UH                00154723614  7K($        '        UH                00155298607  D ($        '        UH                00155616153  Q ($        '        UH                00154673684    ($        (%       UH                00154663611    ($      ( (Y       UH                00154626686    ($      0 (        UH                00154617695    ($      8 (        UH                00154671630   I($      @ (        UH                00154638692  $"($      H ))       UH                00154696625  /*($      P )]       UH                00154624632  1 ($      X )        UH                00154724696  Ia($      ` )        UH                00154617695  K"($      h )        UH                00154618667  i ($      p *-       UH                00155184695   -($      x *a       UH                00154617695    ($        *        UH !              00155191632    ($        *        UH "              00154634603    ($        *        UH #              00154684619    ($        +1       UH $              00154713651  . ($        +e       UH %              00154616613    ($        +        UH &              00154676608  R4($        +        UH '              00154667609  `t($        ,        UH (              00155909681  nZ($        ,5       UH )              00155787632    ($        ,i       UH *              00155191632    ($        ,        UH +              00154643696   N($        ,        UH ,              00154275603  c ($        -        UH -              00154327697    ($        -9       UH .              00154251690  # ($        -m       UH /              00154283622  5 ($        -        UH 0              00154865168   H($        -        UH 1              00155224662    ($        .        UH 2              00155232681    ($        .=       UH 3              00155177648    ($        .q       UH 4              00155206680    ($        .        UH 5              00155499688    ($      ( .        UH 6              00155201611    ($      0 /        UH 7              00155218697    ($      8 /A       UH 8              00155523651    ($      @ /u       UH 9              00155196600   M($      H /        UH :              00154716677    ($      P /        UH ;              00154273660  1u($      X 0        UH <              00155488643  5 ($      ` 0E       UH =              00155503626  >v($      h 0y       UH >              00154267694  A$($      p 0        UH ?              00155563602  ^h($      x 0        UH @              00155557637  ^ ($         t       UH A              00155545620   m($                 S6                23041102668    ($                 UE                23042656691  s ($                 U7                43250050644    ($                 UE                43249418668   }($         %       UE                43250319600    ($         Y       UE                43260225668    ($                 UE                43260063668    ($                 UE                43250041653  1 ($                 UE                43259995668  N ($         )       UE                43255345634  s ($         ]       UE                43249132691  ~Z($                 UE                43254403649    ($                 UE                43250319600   F($                 UE                43251749404    ($         -       UE                43257496168    ($         a       UE                43249299634  83($                 UE                43256368620    ($                 UE                43260470620    ($                 UE                43249892653  8Y($         1       UE                43259715649  > ($      (  e       UE                43249485691    ($      0          UE                43258700168  Id"       8          T        2        ARCOS    )%      @          T)       2        NOVA SERRANA  Y -)      H          T7       2        SANTANA DO ALFIE  S   P      JT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         t/u. - - ,5+e* ) ( (%'U& % $ $ #E"u!      5 e       % U         E u       5 e       % U         E u       5 e       % e        ;
InnoDB: End of page dump
170605  9:49:12  InnoDB: Page checksum 1396794065, prior-to-4.0.14-form checksum 3446355896
InnoDB: stored checksum 1674626389, prior-to-4.0.14-form stored checksum 22
InnoDB: Page lsn 22 3371439648, low 4 bytes of lsn at page end 3371439648
InnoDB: Page number (if stored to page already) 550323,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an index page where index id is 18446744069414584320
InnoDB: (index "CLUST_IND" of table "SYS_IBUF_TABLE")
170605  9:49:12  InnoDB: Assertion failure in thread 140000241952512 in file page0page.ic line 745
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
12:49:12 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346700 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f545acf7719]
/usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f545abbcae3]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f5459906cb0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f5458f71425]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x17b)[0x7f5458f74b8b]
/usr/sbin/mysqld(+0x6b91d1)[0x7f545ae571d1]
/usr/sbin/mysqld(+0x6ba3f6)[0x7f545ae583f6]
/usr/sbin/mysqld(+0x6a82c0)[0x7f545ae462c0]
/usr/sbin/mysqld(+0x6a9b51)[0x7f545ae47b51]
/usr/sbin/mysqld(+0x64925b)[0x7f545ade725b]
/usr/sbin/mysqld(+0x6779d9)[0x7f545ae159d9]
/usr/sbin/mysqld(+0x6037b0)[0x7f545ada17b0]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7f54598fee9a]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f545902f3fd]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

/*******************************************************************************************************************************************************************/

/***********************************************************************/var/log/syslog************************************************************************/

Jun  5 09:48:08 cpro20767 amavis[1017]: Module DBD::mysql          4.020
Jun  5 09:48:55 cpro20767 authdaemond: modules="authmysql", daemons=5
Jun  5 09:48:55 cpro20767 authdaemond: Installing libauthmysql
Jun  5 09:48:55 cpro20767 authdaemond: Installation complete: authmysql
Jun  5 09:48:59 cpro20767 amavis[1022]: (01022-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Can't connect to MySQL server on '127.0.0.1' (111)
Jun  5 09:48:59 cpro20767 postfix/smtp[1726]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Jun  5 09:48:59 cpro20767 postfix/smtp[1726]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jun  5 09:49:09 cpro20767 kernel: [   74.313844] type=1400 audit(1496666949.929:16): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=2058 comm="apparmor_parser"
Jun  5 09:49:10 cpro20767 kernel: [   75.111077] init: mysql main process (2070) terminated with status 1
Jun  5 09:49:10 cpro20767 kernel: [   75.111142] init: mysql main process ended, respawning
Jun  5 09:49:11 cpro20767 kernel: [   75.495518] init: mysql post-start process (2071) terminated with status 1
Jun  5 09:49:11 cpro20767 kernel: [   75.521115] type=1400 audit(1496666951.137:17): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=2105 comm="apparmor_parser"
Jun  5 09:49:11 cpro20767 kernel: [   75.931255] init: mysql main process (2117) terminated with status 1
Jun  5 09:49:11 cpro20767 kernel: [   75.931331] init: mysql main process ended, respawning
Jun  5 09:49:12 cpro20767 kernel: [   76.607014] init: mysql post-start process (2118) terminated with status 1
Jun  5 09:49:12 cpro20767 kernel: [   76.629533] type=1400 audit(1496666952.245:18): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=2151 comm="apparmor_parser"
Jun  5 09:49:13 cpro20767 kernel: [   77.381404] init: mysql main process (2163) terminated with status 1
Jun  5 09:49:13 cpro20767 kernel: [   77.381469] init: mysql respawning too fast, stopped
 

/*******************************************************************************************************************************************************************/

/************************************************************************my.cnf************************************************************************/

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.

# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port        = 3306
socket        = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket        = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
port        = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address        = 177.106.152.3
#
# * Fine Tuning
#
key_buffer_size        = 16M
max_allowed_packet    = 16M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit    = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries    = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id        = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size         = 100M
#binlog_do_db        = include_database_name
#binlog_ignore_db    = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet    = 16M

[mysql]
#no-auto-rehash    # faster start of mysql but no tab completition

[isamchk]
key_buffer        = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
/**************************************************************************************************************************************************************************************/

 

 

Share this post


Link to post
Share on other sites
jacreis
10 horas atrás, Amilton disse:

InnoDB: Page may be an index page where index id is 18446744069414584320
InnoDB: (index "CLUST_IND" of table "SYS_IBUF_TABLE")
170605  9:49:12  InnoDB: Assertion failure in thread 140000241952512 in file page0page.ic line 745
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

Só como referencia, o log tem a info necessaria


---
 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site you accept our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.