SQL Error when I try to reindex Magento 2 The Next CEO of Stack OverflowError when trying to reindex Product PricesDatabase error - reindexError when try to get data from custom databaseReindex error magento 1.9.X.XSQL error when i try to search in frontendSQL error when trying to save productMagento Frontend suddenly very slow (Backend fast) issue MySQL relatedREİNDEX SYMFONY ERROR SCREENSHOTProblem with SQLSTATE[42S22]: Column not foundError SQL[HY000] Error 1205 with import_products
Is it safe to use c_str() on a temporary string?
Apart from "berlinern", do any other German dialects have a corresponding verb?
Horror movie/show or scene where a horse creature opens its mouth really wide and devours a man in a stables
Customer Requests (Sometimes) Drive Me Bonkers!
How should I support this large drywall patch?
Which organization defines CJK Unified Ideographs?
Does it take more energy to get to Venus or to Mars?
Need some help with wall behind rangetop
Why does standard notation not preserve intervals (visually)
Text adventure game code
What does "Its cash flow is deeply negative" mean?
Why here is plural "We went to the movies last night."
How long to clear the 'suck zone' of a turbofan after start is initiated?
Natural language into sentence logic
Science fiction (dystopian) short story set after WWIII
Why didn't Khan get resurrected in the Genesis Explosion?
Failed to fetch jessie backports repository
How can I quit an app using Terminal?
What does this shorthand mean?
Why does C# sound extremely flat when saxophone is tuned to G?
How does practicing restraint and performing actions of merit purify the mind?
Inappropriate reference requests from Journal reviewers
Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?
Rotate a column
SQL Error when I try to reindex Magento 2
The Next CEO of Stack OverflowError when trying to reindex Product PricesDatabase error - reindexError when try to get data from custom databaseReindex error magento 1.9.X.XSQL error when i try to search in frontendSQL error when trying to save productMagento Frontend suddenly very slow (Backend fast) issue MySQL relatedREİNDEX SYMFONY ERROR SCREENSHOTProblem with SQLSTATE[42S22]: Column not foundError SQL[HY000] Error 1205 with import_products
2
I have an issue in Magento 2.2.7 where my site has the message
"One or more indexers are invalid." and looking at the indexers I see the following:
However when I try to run php bin/magento indexer:reindex in the command line I get the following error:
Catalog Search indexer process unknown error:
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_41e5_3.MYI'; try to repair it, query was: SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_int` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (93, 151, 180, 222, 128, 83, 226, 224, 256, 227, 223, 219, 97, 99)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (154, 109, 130, 73, 129, 110, 111)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_text` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (152, 75, 153, 225, 220, 85, 221, 76)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_decimal` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (77, 233)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017))
Looking at the error it would seem that one of my tables is corrupt/broken but I'm unsure how to resolve the issue. If someone could suggest a way to resolve this I would appreciate it.
magento2 database error sql reindex
asked Mar 13 at 12:31
CJNottsCJNotts
14812
add a comment |
2
I have an issue in Magento 2.2.7 where my site has the message
"One or more indexers are invalid." and looking at the indexers I see the following:
However when I try to run php bin/magento indexer:reindex in the command line I get the following error:
Catalog Search indexer process unknown error:
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_41e5_3.MYI'; try to repair it, query was: SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_int` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (93, 151, 180, 222, 128, 83, 226, 224, 256, 227, 223, 219, 97, 99)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (154, 109, 130, 73, 129, 110, 111)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_text` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (152, 75, 153, 225, 220, 85, 221, 76)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_decimal` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (77, 233)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017))
Looking at the error it would seem that one of my tables is corrupt/broken but I'm unsure how to resolve the issue. If someone could suggest a way to resolve this I would appreciate it.
magento2 database error sql reindex
asked Mar 13 at 12:31
CJNottsCJNotts
14812
1
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
1
should follow the link above
– magefms
Mar 13 at 12:52
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
1
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
1
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00
add a comment |
2
2
2
I have an issue in Magento 2.2.7 where my site has the message
"One or more indexers are invalid." and looking at the indexers I see the following:
However when I try to run php bin/magento indexer:reindex in the command line I get the following error:
Catalog Search indexer process unknown error:
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_41e5_3.MYI'; try to repair it, query was: SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_int` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (93, 151, 180, 222, 128, 83, 226, 224, 256, 227, 223, 219, 97, 99)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (154, 109, 130, 73, 129, 110, 111)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_text` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (152, 75, 153, 225, 220, 85, 221, 76)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_decimal` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (77, 233)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017))
Looking at the error it would seem that one of my tables is corrupt/broken but I'm unsure how to resolve the issue. If someone could suggest a way to resolve this I would appreciate it.
magento2 database error sql reindex
asked Mar 13 at 12:31
CJNottsCJNotts
14812
I have an issue in Magento 2.2.7 where my site has the message
"One or more indexers are invalid." and looking at the indexers I see the following:
However when I try to run php bin/magento indexer:reindex in the command line I get the following error:
Catalog Search indexer process unknown error:
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_41e5_3.MYI'; try to repair it, query was: SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_int` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (93, 151, 180, 222, 128, 83, 226, 224, 256, 227, 223, 219, 97, 99)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (154, 109, 130, 73, 129, 110, 111)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_text` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (152, 75, 153, 225, 220, 85, 221, 76)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017)) UNION ALL SELECT DISTINCT `t`.`entity_id`, `t`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t.entity_id=t_store.entity_id AND t.attribute_id=t_store.attribute_id AND t_store.store_id = 1
LEFT JOIN `catalog_product_entity_decimal` AS `t_default` ON t.entity_id=t_default.entity_id AND t.attribute_id=t_default.attribute_id AND t_default.store_id = 0 WHERE (t.attribute_id IN (77, 233)) AND (t.entity_id IN (59, 60, 61, 64, 65, 69, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 91, 92, 94, 97, 100, 104, 106, 107, 109, 113, 114, 115, 116, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 133, 134, 135, 136, 137, 138, 139, 141, 145, 146, 149, 151, 154, 158, 161, 162, 163, 164, 165, 166, 168, 169, 170, 171, 172, 174, 176, 177, 182, 189, 190, 206, 207, 211, 212, 213, 214, 215, 216, 219, 220, 228, 229, 230, 232, 235, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 252, 256, 258, 259, 260, 264, 265, 270, 271, 272, 273, 275, 283, 284, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 313, 314, 315, 316, 317, 324, 326, 327, 335, 336, 337, 338, 339, 342, 343, 344, 345, 346, 348, 350, 354, 355, 356, 358, 359, 360, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 381, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 413, 414, 419, 420, 421, 422, 423, 425, 426, 427, 428, 429, 430, 431, 434, 435, 437, 441, 442, 443, 444, 448, 449, 454, 456, 457, 458, 464, 467, 468, 469, 472, 473, 474, 475, 476, 477, 478, 482, 483, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 510, 834, 835, 1061, 1062, 1264, 1265, 1266, 1267, 1506, 1507, 1508, 1509, 1510, 1511, 1569, 2014, 2015, 2017))
Looking at the error it would seem that one of my tables is corrupt/broken but I'm unsure how to resolve the issue. If someone could suggest a way to resolve this I would appreciate it.
magento2 database error sql reindex
magento2 database error sql reindex
asked Mar 13 at 12:31
CJNottsCJNotts
14812
asked Mar 13 at 12:31
CJNottsCJNotts
14812
asked Mar 13 at 12:31
CJNottsCJNotts
14812
asked Mar 13 at 12:31
CJNottsCJNotts
14812
asked Mar 13 at 12:31
CJNottsCJNotts
14812
14812
1
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
1
should follow the link above
– magefms
Mar 13 at 12:52
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
1
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
1
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00
add a comment |
1
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
1
should follow the link above
– magefms
Mar 13 at 12:52
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
1
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
1
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00
1
1
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
1
1
should follow the link above
– magefms
Mar 13 at 12:52
should follow the link above
– magefms
Mar 13 at 12:52
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
1
1
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
1
1
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00
add a comment |
2 Answers
2
active
oldest
votes
1
Try resetting indexers and then reindexing again ;
php bin/magento indexer:reset
php bin/magento indexer:reindex
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
add a comment |
0
Many thanks to Vivek Kumar and magefms for their advice. As it turns out this was indeed a storage issue on my hosting server.
I have contacted my hosting provider and we have transferred to a new server with greater resources. The issue now seems to be resolved.
Running the commands
php bin/magento indexer:reset
php bin/magento indexer:reindex
Reindexes the site as usual
answered yesterday
CJNottsCJNotts
14812
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f265707%2fsql-error-when-i-try-to-reindex-magento-2%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Try resetting indexers and then reindexing again ;
php bin/magento indexer:reset
php bin/magento indexer:reindex
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
add a comment |
1
Try resetting indexers and then reindexing again ;
php bin/magento indexer:reset
php bin/magento indexer:reindex
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
add a comment |
1
1
1
Try resetting indexers and then reindexing again ;
php bin/magento indexer:reset
php bin/magento indexer:reindex
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
Try resetting indexers and then reindexing again ;
php bin/magento indexer:reset
php bin/magento indexer:reindex
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
answered Mar 13 at 13:08
Vivek KumarVivek Kumar
2,5662729
2,5662729
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
add a comment |
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
Hi. Thank you but I'm afraid I tried that already. Just got the same error unfortunately.
– CJNotts
Mar 13 at 13:14
1
1
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Please do check that you're not out of storage in your hosting.
– Vivek Kumar
Mar 13 at 13:22
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
Thanks, I'll check with my hosting provider. We have been having some storage space issues lately so it could be related.
– CJNotts
Mar 13 at 13:23
add a comment |
0
Many thanks to Vivek Kumar and magefms for their advice. As it turns out this was indeed a storage issue on my hosting server.
I have contacted my hosting provider and we have transferred to a new server with greater resources. The issue now seems to be resolved.
Running the commands
php bin/magento indexer:reset
php bin/magento indexer:reindex
Reindexes the site as usual
answered yesterday
CJNottsCJNotts
14812
add a comment |
0
Many thanks to Vivek Kumar and magefms for their advice. As it turns out this was indeed a storage issue on my hosting server.
I have contacted my hosting provider and we have transferred to a new server with greater resources. The issue now seems to be resolved.
Running the commands
php bin/magento indexer:reset
php bin/magento indexer:reindex
Reindexes the site as usual
answered yesterday
CJNottsCJNotts
14812
add a comment |
0
0
0
Many thanks to Vivek Kumar and magefms for their advice. As it turns out this was indeed a storage issue on my hosting server.
I have contacted my hosting provider and we have transferred to a new server with greater resources. The issue now seems to be resolved.
Running the commands
php bin/magento indexer:reset
php bin/magento indexer:reindex
Reindexes the site as usual
answered yesterday
CJNottsCJNotts
14812
Many thanks to Vivek Kumar and magefms for their advice. As it turns out this was indeed a storage issue on my hosting server.
I have contacted my hosting provider and we have transferred to a new server with greater resources. The issue now seems to be resolved.
Running the commands
php bin/magento indexer:reset
php bin/magento indexer:reindex
Reindexes the site as usual
answered yesterday
CJNottsCJNotts
14812
answered yesterday
CJNottsCJNotts
14812
answered yesterday
CJNottsCJNotts
14812
answered yesterday
CJNottsCJNotts
14812
14812
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f265707%2fsql-error-when-i-try-to-reindex-magento-2%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
stackoverflow.com/questions/11805793/…
– magefms
Mar 13 at 12:52
1
should follow the link above
– magefms
Mar 13 at 12:52
Thank you. As I'm on using a hosted server can I perform the steps mentioned in the stackoverflow post or do I need to get my hosting provider to perform them for me?
– CJNotts
Mar 13 at 12:55
1
you can ask your hosting provider to do it
– magefms
Mar 13 at 12:58
1
Much obliged. I'll do that now.
– CJNotts
Mar 13 at 13:00