Crash MariaDB

jan10001
Anbieter
Posts: 720
Joined: 2004-01-02 12:17

Crash MariaDB

Post by jan10001 »

Hallo,
mariadb ist gecrasht und irgendwie blicke ich nicht mehr durch, ist hier eine lib defekt oder die ganze DB?

Code: Select all

170707 10:58:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170707 10:58:17 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 15130 ...
170707 10:58:17 InnoDB: The InnoDB memory heap is disabled
170707 10:58:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170707 10:58:17 InnoDB: Compressed tables use zlib 1.2.7
170707 10:58:17 InnoDB: Using Linux native AIO
170707 10:58:17 InnoDB: Initializing buffer pool, size = 128.0M
170707 10:58:17 InnoDB: Completed initialization of buffer pool
170707 10:58:17 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 904297965
170707 10:58:17  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 904318173
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 5102.
InnoDB: You may have to recover from a backup.
170707 10:58:17  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex d1819f9c000013ee00000000000000000000000035e39adb000200000000000000000000000000022dcc2df1ffffffff0000ffffffff000000022d120000000000001c76003200000001000013ee002c000013ee002c000000000087ffbb000000000087ffbc000001100000000000000000000001320000000013ee0154ffffffff0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001321c00826e00000087f70de0450000162011200400000029011b04000006eb01100000000000880759000000000088075a000001ec00000000000000000000020e0056000013ee0230000013ee00780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020e1c00848a00000087fc2ae0780000160d25580400000006011b0400000e8501ec0000000000881be90000000000881bea000002c800000000000000000000030e0132000013ee0330000013ee01540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030e1c00808300000087d196e07b000013c302021d6261636b75705f617665726167655f64625f73697a655f64756d70656401030f3730303639332e343136363636363602c800000000008820a100000000008820a2000003c80000000000000000000003ed020e000013ee040f000013ee0230000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003ed1c006b00000087dc67e0570000161e18ac040000001509626f785f75736167650003c800000000008822ec00000000008822ed000104a70000000000000000000004c8030e000013ee04ea000013ee0330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004c80e003200000087de55cc0000162b120e0400000012000800040000001204a7000000000088240c000000000088240d000105820000000000000000000005c303ed000013ee05e5000013ee040f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005c30d0032200000882409e0390000162e11070400000009030308000000000784d0000808000000000339b0000b0800000000030660000008000400000009058200000000008836f100000000008836f20001067d0000000000000000000009c604c8000013ee09e8000013ee04ea000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009c60c008e170000008836d3e0200000147f14a31a346e35706a3032396e3166633765737137766d33746b6e6c6b3102050a313439393037323937360682d86a6f6f6d6c617c733a3731323a22547a6f794e446f69536d39766257786858464a6c5a326c7a64484a3558464a6c5a326c7a64484a35496a6f7a4f6e747a4f6a63364967417141475268644745694f3038364f446f696333526b5132786863334d694f6a453665334d364f546f695831396b5a575a6864577830496a74504f6a6736496e4e305a454e7359584e7a496a6f7a4f6e747a4f6a6336496e4e6c63334e70623234694f3038364f446f696333526b5132786863334d694f6a4d3665334d364e7a6f6959323931626e526c6369493761546f794f334d364e546f6964476c745a5849694f3038364f446f696333526b5132786863334d694f6a4d3665334d364e546f6963335268636e51694f326b364d5451354f5441334d6a59324e6a747a4f6a5136496d7868633351694f326b364d5451354f5441334d6a59324e6a747a4f6a4d36496d35766479493761546f784e446b354d4463794f5463324f33317a4f6a5536496e527661325675496a747a4f6a4d794f694a476146645a4e334577646a4e75596c4e30656d564b4d306c69526b4e4e4e476b334f47644653464e466169493766584d364f446f69636d566e61584e30636e6b694f3038364d6a5136496b707662323173595678535a57647063335279655678535a57647063335279655349364d7a7037637a6f334f6949414b67426b59585268496a74504f6a6736496e4e305a454e7359584e7a496a6f774f6e7439637a6f784e446f6941436f416157357064476c6862476c365a5751694f3249364d44747a4f6a6b36496e4e6c634746795958527663694937637a6f784f694975496a7439637a6f304f694a3163325679496a74504f6a5536496b705663325679496a6f784f6e747a4f6a4936496d6c6b496a74704f6a413766583139637a6f784e446f6941436f416157357064476c6862476c365a5751694f3249364d44747a4f6a6b36496e4e6c634746795958527663694937637a6f784f694975496a7439223b0030001a346e35706a3032396e3166633765737137766d33746b6e6c6b31050a31343939303732393736070480000000067d0000000000883931000000000088393200010a80000000000000000000000f0905c3000013ee0f2b000013ee05e500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ae00e008df4000000883758dd000013c211841a3267767138706e61326534336a6d6d32683971327438397162700030001a3267767138706e61326534336a6d6d3268397132743839716270050a313439393037333731360704800000000a800b410e018df4000000883888e025000013f208d91a38643536376465736e33636c71306171633731756466696b66310030001a38643536376465736e33636c71306171633731756466696b6631050a313439393037343235370704800000000ae00ba20e028df400000088381ee04a0000163e11641a63333834706b6a7164326e756639396b38343174706939676d320030001a63333834706b6a7164326e756639396b38343174706939676d32050a313439393037343235370704800000000b410c030e038df4000000883858e07c0000159429061a63667466666c6b7630303930356269623832356d7473653273330030001a63667466666c6b7630303930356269623832356d747365327333050a313439393037343235370704800000000ba20c640e048df400000088384de073000013c60bea1a636e6d6d39693875683772696e6530756e7434697461386472360030001a636e6d6d39693875683772696e6530756e743469746138647236050a313439393037343235370704800000000c030cc50e058df4000000883880e02100001492060e1a66636275656735726e67746976356d76746d36366e306d6239330030001a66636275656735726e67746976356d76746d36366e306d623933050a313439393037343235370704800000000c640d260e068df4000000883845e06c000013e90a401a6768326267616d74336a337372383276623361673031653567360030001a6768326267616d74336a33737238327662336167303165356736050a313439393037343235370704800000000cc50d870e078df4000000883771e033000013f306c61a696a3038306d70636735363372643566706569317131386972330030001a696a3038306d7063673536337264356670656931713138697233050a313439393037343235360704800000000d260de80e088df400000088384fe074000016702d611a6b726e73686a377669756d666376676567676672716c316175300030001a6b726e73686a377669756d666376676567676672716c31617530050a313439393037343235370704800000000d870e490e098df4000000883883e022000013ce0b2f1a6d6a6b617470617530616e6272636965346830313332646f76330030001a6d6a6b617470617530616e6272636965346830313332646f7633050a313439393037343235370704800000000de80ea90e0a8df40000008838f7c4000016321fcd1a6f626434697662393172703833706c376333726c6131666e32730030001a6f626434697662393172703833706c376333726c6131666e3273050a313439393037353137320704800000000e490f090e0b8df400000088387edf000013d710341a706f6a6a33366d34716375656937703972636c6c726b6d3931320030001a706f6a6a33366d34716375656937703972636c6c726b6d393132050a313439393037343235370704800000000ea90000000000883d000000000000883d0100000fc3000000000000000000000fe509c6000013ee1007000013ee09e800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000fe51c00826e000000883614e06f000013d80d1d040000002f011b040000049e0fc3000000000088405600000000008840570001109f0000000000000000000013ec0f09000013ee140e000013ee0f2b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013ec0c008df4000000884040e027000013ec05781a6a7134626436733963306173666935327065686834636138686802050a313439393039373531380682dc6a6f6f6d6c617c733a3731363a22547a6f794e446f69536d39766257786858464a6c5a326c7a64484a3558464a6c5a326c7a64484a35496a6f7a4f6e747a4f6a63364967417141475268644745694f3038364f446f696333526b5132786863334d694f6a453665334d364f546f695831396b5a575a6864577830496a74504f6a6736496e4e305a454e7359584e7a496a6f7a4f6e747a4f6a6336496e4e6c63334e70623234694f3038364f446f696333526b5132786863334d694f6a4d3665334d364e7a6f6959323931626e526c6369493761546f784d44747a4f6a5536496e527062575679496a74504f6a6736496e4e305a454e7359584e7a496a6f7a4f6e747a4f6a5536496e4e3059584a30496a74704f6a45304f546b774f54637a4d546337637a6f304f694a7359584e30496a74704f6a45304f546b774f5463314d545137637a6f7a4f694a75623363694f326b364d5451354f5441354e7a55784f447439637a6f314f694a306232746c62694937637a6f7a4d6a6f694d486c36625670365757525a5a475934566d553063325a3554446b79613151305248645054484a79624459694f33317a4f6a6736496e4a6c5a326c7a64484a35496a74504f6a49304f694a4b6232397462474663556d566e61584e30636e6c63556d566e61584e30636e6b694f6a4d3665334d364e7a6f6941436f415a47463059534937547a6f344f694a7a644752446247467a637949364d44703766584d364d5451364967417141476c756158527059577870656d566b496a74694f6a4137637a6f354f694a7a5a584268636d4630623349694f334d364d546f694c69493766584d364e446f6964584e6c63694937547a6f314f694a4b56584e6c636949364d547037637a6f794f694a705a43493761546f774f33313966584d364d5451364967417141476c756158527059577870656d566b496a74694f6a4137637a6f354f694a7a5a584268636d4630623349694f334d364d546f694c69493766513d3d223b0030001a6a71346264367339633061736669353270656868346361386868050a31343939303937353138070480000000109f00000000008841f700000000008841f8000014a60000000000000000000014c10fe5000013ee14e3000013ee1007000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014c11c002000000088419ee0680000161822e404000000010014a6000000000088453400000000008845350001157b0000000000000000000015ef13ec000013ee1611000013ee140e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000015ef0c008e1700000088451be0a30000136201101a717136686766733474636f656e6974643368716b386d63336b3002050a3134393931323133383406f0ffffffff0030001a717136686766733474636f656e6974643368716b386d63336b30050a31343939313231333834070480000000157b0000000000885cc20000000000885cc3000016a90000000000000000000016e614c1000013ee1708000013ee14e3000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016e61c008092000000882057c6000013d409b304000000010e6d6f64756c6553657474696e67730673796e63656401050a3134393930343634333716a900000000008867d100000000008867d2000117a00000000000000000000017fe15ef000013ee1820000013ee1611000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000017fe0e0080b4000000882221e08100001c53011020303032663134646634306330343738313835333630306536396535623036393700002600203030326631346466343063303437383138353336303065363965356230363937010017a000000000008868e600000000008868e7000118b800000000000000000000190b16e6000013ee192d000013ee17080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000190b0c002a000000882d59e051000016101c61040000001f03061431343939303436373034302e31383630383230300901030bf0ffffffff001900040000001f0706646f6d61696e08040000000809010318b800000000008873160000000000887317000019c50000000000000000000019fd17fe000013ee1a1f000013ee1820000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000019fd1c008df4000000887313e0b8000018f701101a356c666d7365336939746d35736b6667756b6a6264316f766e620106f0ffffffff19c50000000000887a1d0000000000887a1e00001ab7000000000000000000001ad2190b000013ee1af4000013ee192d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001ad21c0020000000887920e055000013f10d910400000001001ab70000000000887f000000000000887f0100001b8c000000000000000000001bc419fd000013ee1be6000013ee1a1f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001bc41c008df4000000887ef2e0ae0000016301101a66327238336a356236646d3966757574356a75747037367438370106f0ffffffff1b8c00000000008883d200000000008883d300001c7e000000000000000000001cb61ad2000013ee1cd8000013ee1af400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001cb61c008e170000008883c2e0ab0000016001101a6e74697037637238307168326b31716c72676572736b6b6b61350106f0ffffffff1c7e0000000000889c030000000000889c0400001d70000000000000000000001d951bc4000013ee1db7000013ee1be600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001d951c006b000000885d1ce0780000138d0202040000001c09626f785f7573616765001d70000000000088ab26000000000088ab2700001e4f000000000000000000001e691cb6000013ee1e8b000013ee1cd800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e691c002000000088aaf3cb000013cd20540400000001001e4f000000000088ac3e000000000088ac3f00001f23000000000000000000001f5b1d95000013ee1f7d000013ee1db700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001f5b1c008df400000088ac3be0b8000018f701101a746a7465686d39386771763172673169617564737363713365380106f0ffffffff1f23000000000088b727000000000088b728000020150000000000000000000020311e69000013ee2053000013ee1e8b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020311c008e1900000059b375e063000013fb2d9a04800000c9002015000000000088bd24000000000088bd25000020eb0000000000000000000021061f5b000013ee2128000013ee1f7d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021061c008d2f0000005dd71ed20000175c08cd04800000db0020eb000000000088bf21000000000088bf22000021c00000000000000000000021e22031000013ee2204000013ee2053000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021e21c008c4f00000088bf12e0300000079b092e04800000060106048000000121c0000000000088c342000000000088c3430000229c0000000000000000000022b82106000013ee22da000013ee2128000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022b81c008d2f00000088bd72e06f000013d822cd048000019900229c000000000088c8e9000000000088c8ea0000237200000000000000000000238d21e2000013ee23af000013ee22040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000238d1c002000000088c8e2e035000016382d500400000001002372000000000088d10d000000000088d10e0000244700000000000000000000247f22b8000013ee24a1000013ee22da0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000247f1c008df400000088d0fee0ac00001dc101101a7134686a696163766b363776343835346d676b6c7463717268710106f0ffffffff24470000000000890129000000000089012a0000253900000000000000000000255b238d000013ee257d000013ee23af0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000255b1c00826e00000088fc36e031000013ef1edd040000002f011b04000004a6253900000000008902d000000000008902d10000261500000000000000000000264d247f000013ee266f000013ee24a10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000264d1c008df40000008902c9e0b500001bfb01101a6f697232666f307563366335706d6a37683938756261756933370106f0ffffffff26150000000000890844000000000089084500002707000000000000000000002723255b000013ee2745000013ee257d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000027231c008df60000005f0ee3e06e00000a692f99048000001c00270700000000008909c100000000008909c2000027dd0000000000000000000027f9264d000013ee281b000013ee266f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000027f91c008df60000005f1060e06e00000a69306f04800027190027dd00000000008918930000000000891894000028b30000000000000000000028eb2723000013ee290d000013ee2745000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028eb1c008e17000000891875e09d0000015201101a71663539746673756c34386170317175707272346567657174300106f0ffffffff28b30000000000891c600000000000891c61000129a5000000000000000000002d1227f9000013ee2d34000013ee281b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002d120c008e17000000891c44e0210000149229821a6d67696665336431713537356e763476703664383663756c753602050a313439393337323633390682fc6a6f6f6d6c617c733a3734383a22547a6f794e446f69536d39766257786858464a6c5a326c7a64484a3558464a6c5a326c7a64484a35496a6f7a4f6e747a4f6a63364967417141475268644745694f3038364f446f696333526b5132786863334d694f6a453665334d364f546f695831396b5a575a6864577830496a74504f6a6736496e4e305a454e7359584e7a496a6f304f6e747a4f6a6336496e4e6c63334e70623234694f3038364f446f696333526b5132786863334d694f6a493665334d364e7a6f6959323931626e526c6369493761546f7a4f334d364e546f6964476c745a5849694f3038364f446f696333526b5132786863334d694f6a4d3665334d364e546f6963335268636e51694f326b364d5451354f544d334d6a45344d44747a4f6a5136496d7868633351694f326b364d5451354f544d334d6a55344d54747a4f6a4d36496d35766479493761546f784e446b354d7a63794e6a4d354f333139637a6f344f694a795a5764706333527965534937547a6f794e446f69536d39766257786858464a6c5a326c7a64484a3558464a6c5a326c7a64484a35496a6f7a4f6e747a4f6a63364967417141475268644745694f3038364f446f696333526b5132786863334d694f6a41366533317a4f6a45304f6949414b674270626d6c30615746736158706c5a434937596a6f774f334d364f546f696332567759584a6864473979496a747a4f6a4536496934694f33317a4f6a5136496e567a5a5849694f3038364e546f69536c567a5a5849694f6a453665334d364d6a6f69615751694f326b364d447439637a6f794e546f696347786e58334e356333526c625639735957356e6457466e5a575a706248526c63694937547a6f344f694a7a644752446247467a637949364d547037637a6f344f694a735957356e6457466e5a534937637a6f314f694a6b5a5331455253493766583139637a6f784e446f6941436f416157357064476c6862476c365a5751694f3249364d44747a4f6a6b36496e4e6c634746795958527663694937637a6f784f694975496a7439223b0030001a6d67696665336431713537356e763476703664383663756c7536050a3134393933373236333907048000000029a500000000008937c300000000008937c400002dcc00000000000000000000000028ebffffffff0000000013ee290d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002df11c006b00000088e8c4e05f0000086c0110040000003909626f785f7573616765002dcc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080d4862935e39adb; asc                     5                   - -               -        v 2         ,     ,                               2       T                                                                                                                                                   2   n       E          )                Y       Z                 V     0     x                                                                                                                                                       * x    %X                                               2     0     T                                                                                                                                                         {       backup_average_db_size_dumped   700693.41666666                                               0                                                                                                                                                k     g W            box_usage         "       "                              0                                                                                                                                                2     U    +                       $       $                                                                                                                                                                               2    $  9   .                         9          `                 6       6    }                                                                                                                                                                                6          4n5pj029n1fc7esq7vm3tknlk1   1499072976   joomla|s:712:"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjozOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToyO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ5OTA3MjY2NjtzOjQ6Imxhc3QiO2k6MTQ5OTA3MjY2NjtzOjM6Im5vdyI7aToxNDk5MDcyOTc2O31zOjU6InRva2VuIjtzOjMyOiJGaFdZN3EwdjNuYlN0emVKM0liRkNNNGk3OGdFSFNFaiI7fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjU6IkpVc2VyIjoxOntzOjI6ImlkIjtpOjA7fX19czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9"; 0  4n5pj029n1fc7esq7vm3tknlk1  1499072976       }      91      92                       +                                                                                                                                                            7X        2gvq8pna2e43jmm2h9q2t89qbp 0  2gvq8pna2e43jmm2h9q2t89qbp  1499073716         A        8  %       8d567desn3clq0aqc71udfikf1 0  8d567desn3clq0aqc71udfikf1  1499074257                  8  J   > d c384pkjqd2nuf99k841tpi9gm2 0  c384pkjqd2nuf99k841tpi9gm2  1499074257       A          8X |    )  cftfflkv00905bib825mtse2s3 0  cftfflkv00905bib825mtse2s3  1499074257         d        8M s       cnmm9i8uh7rine0unt4ita8dr6 0  cnmm9i8uh7rine0unt4ita8dr6  1499074257                  8  !       fcbueg5rngtiv5mvtm66n0mb93 0  fcbueg5rngtiv5mvtm66n0mb93  1499074257       d &        8E l     @ gh2bgamt3j3sr82vb3ag01e5g6 0  gh2bgamt3j3sr82vb3ag01e5g6  1499074257                  7q 3       ij080mpcg563rd5fpei1q18ir3 0  ij080mpcg563rd5fpei1q18ir3  1499074256       &          8O t   p-a krnshj7viumfcvgeggfrql1au0 0  krnshj7viumfcvgeggfrql1au0  1499074257         I        8  "     / mjkatpau0anbrcie4h0132dov3 0  mjkatpau0anbrcie4h0132dov3  1499074257                  8     2   obd4ivb91rp83pl7c3rla1fn2s 0  obd4ivb91rp83pl7c3rla1fn2s  1499075172       I          8~      4 pojj36m4qcuei7p9rcllrkm912 0  pojj36m4qcuei7p9rcllrkm912  1499074257              =       =                                                                                                                                                                                n    6  o          /               @V      @W                             +                                                                                                                                                      @@ '     x jq4bd6s9c0asfi52pehh4ca8hh   1499097518   joomla|s:716:"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjozOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxMDtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE0OTkwOTczMTc7czo0OiJsYXN0IjtpOjE0OTkwOTc1MTQ7czozOiJub3ciO2k6MTQ5OTA5NzUxODt9czo1OiJ0b2tlbiI7czozMjoiMHl6bVp6WWRZZGY4VmU0c2Z5TDkya1Q0RHdPTHJybDYiO31zOjg6InJlZ2lzdHJ5IjtPOjI0OiJKb29tbGFcUmVnaXN0cnlcUmVnaXN0cnkiOjM6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czo5OiJzZXBhcmF0b3IiO3M6MToiLiI7fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MTp7czoyOiJpZCI7aTowO319fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czo5OiJzZXBhcmF0b3IiO3M6MToiLiI7fQ=="; 0  jq4bd6s9c0asfi52pehh4ca8hh  1499097518              A       A                                                                                                                                                                                    A  h    "               E4      E5   {                                                                                                                                                                                E      b   qq6hgfs4tcoenitd3hqk8mc3k0   1499121384       0  qq6hgfs4tcoenitd3hqk8mc3k0  1499121384       {      \       \                                                                                                                                                                                      W             moduleSettings synced   1499046437        g       g                                                                                                                                                                                     "!     S   002f14df40c04781853600e69e5b0697  &  002f14df40c04781853600e69e5b0697          h       h                        -                                                                                                                                                      *    -Y Q     a        14990467040.18608200                   domain                 s       s                                                                                                                                                                                     s          5lfmse3i9tm5skfgukjbd1ovnb               z       z                              -                                                                                                                                                     y  U                                                                                                                                                                                                                  ~      c   f2r83j5b6dm9fuut5jutp76t87                            ~                                                                                                                                                                                       `   ntip7cr80qh2k1qlrgerskkka5        ~                   p                                                                                                                                                                          k    ]  x            box_usage  p       &       '   O           i                                                                                                                                                           i               T       O       >       ?   #           [       }                                                                                                                                                   [         ;         tjtehm98gqv1rg1iaudsscq3e8        #       '       (               1 i     S                                                                                                                                                   1       Y u c    -                $       %              !  [    !(     }                                                                                                                                            !    /   ]      \                 !       "  !           !  1    "      S                                                                                                                                            !    O       0     .            !        B       C  "           " !     "     !(                                                                                                                                            "    /     r o    "       "                   #r          # !     #     "                                                                                                                                             #           5   8-P      #r                  $G          $ "     $     "                                                                                                                                             $                    q4hjiacvk67v4854mgkltcqrhq       $G       )       *  %9          %[#     %}    #                                                                                                                                             %[   n     6 1          /       %9                  &           &M$     &o    $                                                                                                                                             &M                   oir2fo0uc6c5pmj7h98ubaui37       &        D       E  '           '#%[    'E    %}                                                                                                                                            '#       _   n   i/       '                   '           ' &M    (     &o                                                                                                                                            '        _ ` n   i0o   '  '                   (           ( '#    )     'E                                                                                                                                            (          u     R   qf59tfsul48ap1quprr4egeqt0       (        `       a  )           - '     -4    (                                                                                                                                             -          D !    )  mgife3d1q575nv4vp6d86culu6   1499372639   joomla|s:748:"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjo0OntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjI6e3M6NzoiY291bnRlciI7aTozO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ5OTM3MjE4MDtzOjQ6Imxhc3QiO2k6MTQ5OTM3MjU4MTtzOjM6Im5vdyI7aToxNDk5MzcyNjM5O319czo4OiJyZWdpc3RyeSI7TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e31zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO31zOjQ6InVzZXIiO086NToiSlVzZXIiOjE6e3M6MjoiaWQiO2k6MDt9czoyNToicGxnX3N5c3RlbV9sYW5ndWFnZWZpbHRlciI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJsYW5ndWFnZSI7czo1OiJkZS1ERSI7fX19czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9"; 0  mgife3d1q575nv4vp6d86culu6  1499372639      )       7       7   -             (           )                                                                                                                                             -   k       _   l      9 box_usage -                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           )5   ;
InnoDB: End of page dump
170707 10:58:17  InnoDB: Page checksum 3514933148 (32bit_calc: 364579720), prior-to-4.0.14-form checksum 2194966057
InnoDB: stored checksum 3514933148, prior-to-4.0.14-form stored checksum 2161411625
InnoDB: Page lsn 0 904108763, low 4 bytes of lsn at page end 904108763
InnoDB: Page number (if stored to page already) 5102,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an update undo log page
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 5102.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
170707 10:58:17  InnoDB: Assertion failure in thread 139813836433472 in file buf0buf.c line 4036
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.
170707 10:58:17 [ERROR] 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.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

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.

Server version: 5.5.52-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466712 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0
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 = 0x0 thread_stack 0x48000
/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x7f28f29852dd]
/usr/libexec/mysqld(handle_fatal_signal+0x515)[0x7f28f259a8d5]
/lib64/libpthread.so.0(+0xf370)[0x7f28f1cca370]
/lib64/libc.so.6(gsignal+0x37)[0x7f28f04791d7]
/lib64/libc.so.6(abort+0x148)[0x7f28f047a8c8]
/usr/libexec/mysqld(+0x690845)[0x7f28f278a845]
/usr/libexec/mysqld(+0x6a2027)[0x7f28f279c027]
/usr/libexec/mysqld(+0x68b187)[0x7f28f2785187]
/usr/libexec/mysqld(+0x65c83a)[0x7f28f275683a]
/usr/libexec/mysqld(+0x64f643)[0x7f28f2749643]
/usr/libexec/mysqld(+0x6504ac)[0x7f28f274a4ac]
/usr/libexec/mysqld(+0x652c0e)[0x7f28f274cc0e]
/usr/libexec/mysqld(+0x63bf65)[0x7f28f2735f65]
/usr/libexec/mysqld(+0x5f7944)[0x7f28f26f1944]
/usr/libexec/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x7f28f259c958]
/usr/libexec/mysqld(+0x37cbc5)[0x7f28f2476bc5]
/usr/libexec/mysqld(_Z11plugin_initPiPPci+0x551)[0x7f28f247c531]
/usr/libexec/mysqld(+0x2eea6a)[0x7f28f23e8a6a]
/usr/libexec/mysqld(_Z11mysqld_mainiPPc+0x546)[0x7f28f23ebb86]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f28f0465b35]
/usr/libexec/mysqld(+0x2e8c0d)[0x7f28f23e2c0d]
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.
170707 10:58:17 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Top

User avatar
Joe User
Project Manager
Project Manager
Posts: 11519
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Crash MariaDB

Post by Joe User »

Da ist die Datenbank kaputt, mit sehr viel Glück lässt sie sich recovern.
Ich hoffe Du hast ein aktuelles Backup :(
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Top

jan10001
Anbieter
Posts: 720
Joined: 2004-01-02 12:17

Re: Crash MariaDB

Post by jan10001 »

Hallo Joe, ja Backups sind vorhanden ob die Dumps allerdings die Rechte Verwaltung der DB enthalten weiß ich nicht. Ich hinke bei MySQL/MariaDB etwas hinterher, mußte mich seit Jahren nicht mehr damit intensiv befassen und habe eine Menge vergessen. (Anders als bei Oracle und MSSQL.) Wenn ich die Datenbank nicht wieder hinbekomme müßte ich alles neuaufsetzen und per Hand aus den Backups alles hochladen, Daten wären keine verlorren aber der Zeitaufwand ..... .
Was müßte ich nun mit /var/lib/mysql anstellen damit MariaDB starten kann, welche Dateien/Ordner aus dem Verzeichniss müßten weg?
Top

User avatar
Joe User
Project Manager
Project Manager
Posts: 11519
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Crash MariaDB

Post by Joe User »

Recovery musste ich zuletzt vor über 10 Jahren (MySQL 4.x) durchführen, daher kann ich Dich leider nur auf die Doku verweisen:
https://dev.mysql.com/doc/refman/5.5/en ... overy.html
Du benötigst vermutlich den Abschnitt "InnoDB Crash Recovery".

Hoffe es hilft und funktioniert.
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Top

jan10001
Anbieter
Posts: 720
Joined: 2004-01-02 12:17

Re: Crash MariaDB

Post by jan10001 »

Dank dir Joe, das hilft mir schon mal weiter.
Top

jan10001
Anbieter
Posts: 720
Joined: 2004-01-02 12:17

Re: Crash MariaDB

Post by jan10001 »

So, DB wiederhergestellt, jetzt heißt es Fehlerursache suchen, warum kam es zum Crash damit es nicht nochmal passiert.
Top