Amilton 0 Denunciar mensagem Publicado 5 de Junho de 2017 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/ /**************************************************************************************************************************************************************************************/ Partilhar esta mensagem Ligação para a mensagem Partilhar noutros sites
HappyHippyHippo 1177 Denunciar mensagem Publicado 5 de Junho de 2017 parece que tens ai um problema na tua tabela (esta manhosa) ... ve aqui como corrigires isso > https://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html (ps, esta no meio desse texto todo) IRC : sim, é algo que ainda existe >> #p@p Portugol Plus Partilhar esta mensagem Ligação para a mensagem Partilhar noutros sites
jacreis 8 Denunciar mensagem Publicado 5 de Junho de 2017 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 --- Partilhar esta mensagem Ligação para a mensagem Partilhar noutros sites
