Skip to content

Instantly share code, notes, and snippets.

@imanilchaudhari
Created May 28, 2019 05:01
Show Gist options
  • Save imanilchaudhari/24358504bf0c01a455977d0eb096c5d1 to your computer and use it in GitHub Desktop.
Save imanilchaudhari/24358504bf0c01a455977d0eb096c5d1 to your computer and use it in GitHub Desktop.
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
The SQL being executed was: UPDATE merchant_products_master SET india_ban = 1, uae_ban = 1 WHERE LOWER(Title) LIKE "%bit axe%" AND category_id IN (2105000001, 2105150001, 2105161501, 2105162125, 2105162750, 2105163375, 2105164000, 2105164625, 2105165250, 2105165875, 2105166500, 2105173001, 2105173625, 2105174250, 2105174875, 2105175500, 2105184501, 2105185125, 2105185750, 2105186375, 2105196001, 2105196625, 2105197250, 2105197875, 2105207501, 2105208125, 2105208750, 2105300001, 2105311500, 2105323000, 2105450001, 2105461501, 2105462125, 2105462750, 2105463375, 2105464000, 2105464625, 2105465250, 2105473000, 2105484500, 2105496001, 2105496626, 2105496685, 2105496745, 2105497250, 2105497875, 2105498500, 2105499125, 2105499750, 2105500376, 2105500435, 2105500495, 2105507500, 2105600001, 2105611500, 2105623000, 2105634500, 2105750000, 2105900000, 2106050000, 2106200000, 2106350001, 2106361500, 2106373000, 2106500000, 2106650000, 2106800000, 2110000001, 2110150000, 2110300001, 2110311500, 2110323001, 2110323625, 2110324250, 2110450000, 2110600000, 2110750001, 2110761500, 2110773000, 2110784501, 2110785125, 2110785751, 2110785810, 2110785870, 2110900000, 2111050000, 2115000001, 2115150000, 2115300000, 2115450000, 2115600000, 2115750000, 2120000001, 2120150000, 2120300000, 2120450001, 2120461501, 2120462125, 2120462750, 2120473001, 2120473625, 2120474250, 2120474875, 2120475500, 2120476125, 2120476750, 2120484501, 2120485125, 2120485750, 2120496001, 2120496625, 2120497250, 2120497875, 2120507501, 2120508125, 2120508750, 2120519001, 2120519625, 2120520250, 2120520875, 2120521500, 2120522125, 2120530501, 2120531125, 2120531750, 2120542001, 2120542626, 2120542685, 2120542746, 2120542748, 2120542751, 2120542805, 2120542865, 2120542925, 2120542985, 2120543250, 2120543875, 2120553501, 2120554125, 2120554750, 2120565001, 2120565625, 2120566250, 2120566875, 2120576501, 2120577125, 2120577750, 2120588001, 2120588626, 2120588685, 2120588745, 2120588805, 2120589250, 2120589875, 2120590500, 2120591125, 2120591750, 2120592375, 2120593000, 2120593625, 2120594251, 2120594310, 2120594370, 2120600001, 2120611500, 2120623000, 2120750000, 2120900001, 2120911500, 2120923001, 2120923625, 2120924250, 2120924875, 2120934500, 2120946000, 2120957501, 2120958125, 2120958750, 2120959375, 2120960000, 2120969001, 2120969625, 2120970250, 2120980500, 2120992000, 2121003500, 2121015000, 2121026500, 2121038001, 2121038625, 2121039250, 2121049500, 2121050001, 2121061500, 2121073000, 2121200000, 2121350001, 2121361500, 2121373000, 2121384500, 2121396001, 2121396625, 2121397250, 2121397875, 2121398500, 2121399125, 2121407500, 2121419000, 2121430500, 2121442000, 2121500000, 2121650000, 2121800001, 2121811500, 2121823000, 2121834500, 2121846000, 2121857500, 2121869000, 2121950001, 2121961500, 2121973000, 2121984500, 2121996000, 2122100001, 2122111500, 2122123000, 2122250000, 2122400000, 2122550000, 2122700000, 2122850000, 2123000001, 2123011500, 2123023000, 2123034500, 2123046000, 2123150000, 2123300000, 2125000001, 2125150000, 2125300000, 2125450000, 2125600000, 2125750000, 2125900000, 2126050000, 2126200001, 2126211500, 2126223001, 2126223625, 2126224250, 2126234500, 2126350000, 2130000001, 2130150000, 2130300000, 2130450000, 2130600000, 2130750000, 2130900000, 2131050000, 2135000001, 2135150000, 2135300000, 2135450001, 2135461500, 2135473000, 2135484500, 2135600000, 2135750000, 2135900000, 2136050000, 2136200000, 2136350001, 2136361500, 2136373000, 2136500000, 2136650000, 2136800001, 2136811500, 2136823000, 2136950000, 2137100001, 2137111500, 2137123000, 2137134500, 2137250000, 2140000001, 2140150001, 2140161500, 2140173000, 2140300000, 2140450000, 2140600000, 2140750000, 2140900000, 2141050000, 2141200001, 2141211500, 2141223000, 2141350000, 2141500001, 2141511500, 2141523000, 2141650000, 2141800000, 2141950000, 2142100000, 2142250000, 2142400000, 2142550000, 2142700000, 2142850000, 2143000000, 2143150000, 2143300000, 2143450001, 2143461500, 2143473000, 2143600001, 2143611500, 2143623000, 2143634500, 2143646000, 2143750001, 2143761500, 2143773000, 2145000001, 2145150000, 2145300000, 2145450001, 2145461500, 2145473000, 2145484500, 2145496000, 2145507500, 2145519000, 2145530500, 2145542000, 2145553500, 2145565000, 2145576500, 2145588000, 2145599500, 2145611000, 2145622501, 2145623125, 2145623750, 2145634000, 2145600001, 2145611500, 2145623001, 2145623625, 2145624250, 2145634500, 2145750001, 2145761500, 2145773000, 2145784500, 2145796000, 2145807500, 2145900001, 2145911500, 2145923000, 2146050000, 2146200000, 2146350000, 2146500000, 2146650000, 2146800000, 2146950000, 2147100001, 2147111500, 2147123000, 2147250000, 2147400000, 2150000001, 2150150001, 2150161500, 2150300001, 2150311500, 2150323000, 2150450001, 2150461501, 2150462126, 2150462185, 2150462245, 2150462750, 2150463375, 2150473001, 2150473625, 2150474250, 2150474875, 2150475500, 2150476125, 2150476750, 2150484500, 2150496000, 2150507501, 2150508125, 2150508750, 2150509376, 2150509435, 2150509495, 2150519001, 2150519625, 2150520250, 2150520875, 2150521500, 2150522125, 2150522750, 2150600001, 2150611500, 2150623000, 2150634500, 2150646000, 2150750000, 2150900001, 2150911500, 2150923001, 2150923625, 2150924250, 2150934501, 2150935125, 2150935750, 2150946000, 2150957500, 2150969000, 2150980500, 2150992000, 2151003500, 2151015001, 2151015625, 2151016250, 2151026500, 2151038001, 2151038625, 2151039250, 2151039875, 2151040500, 2151041125, 2151041750, 2151042375, 2151043000, 2151049500, 2151061000, 2151072501, 2151073125, 2151073750, 2151074375, 2151084001, 2151084625, 2151085250, 2151050001, 2151061500, 2151073001, 2151073625, 2151074250, 2151074875, 2151075500, 2151076125, 2151084501, 2151085125, 2151096001, 2151096625, 2151107501, 2151108125, 2151108750, 2151109375, 2151110000, 2151110625, 2151111250, 2151111875, 2151119001, 2151119625, 2151130500, 2151142001, 2151142625, 2151143250, 2151143875, 2151144500, 2151145125, 2151153501, 2151154125, 2151154750, 2151155375, 2151156000, 2151165000, 2151176500, 2151200001, 2151211500, 2151223000, 2151234500, 2155000001, 2155150000, 2155300000, 2155450001, 2155461500, 2155473000, 2155484501, 2155485125, 2155485750, 2155600000, 2155750000, 2155900000, 2156050001, 2156061500, 2156073000, 2156200001, 2156211500, 2156223000, 2156350001, 2156361500, 2156373000, 2156384500, 2156396000, 2156407500, 2156419000, 2156500000, 2156650000, 2156800000, 2156950001, 2156961500, 2156973000, 2160000001, 2160150001, 2160161500, 2160173001, 2160173625, 2160174251, 2160174310, 2160174370, 2160174430, 2160174876, 2160174935, 2160174995, 2160175055, 2160175115, 2160175175, 2160175235, 2160175295, 2160175355, 2160175415, 2160175475, 2160184500, 2160196001, 2160196625, 2160197250, 2160197875, 2160198500, 2160199125, 2160199750, 2160200375, 2160201001, 2160201060, 2160201120, 2160201625, 2160202251, 2160202310, 2160202370, 2160300000, 2160450001, 2160461500, 2160473001, 2160473625, 2160474250, 2160484500, 2160496000, 2160507500, 2160519000, 2160600001, 2160611500, 2160623000, 2160634500, 2160646000, 2160750001, 2160761501, 2160762125, 2160762750, 2160763375, 2160764000, 2160764625, 2160765250, 2160765875, 2160766500, 2160773001, 2160773626, 2160773685, 2160773745, 2160773805, 2160773865, 2160773925, 2160773985, 2160774045, 2160774251, 2160774310, 2160774370, 2160774430, 2160774490, 2160774550, 2160774610, 2160774670, 2160774730, 2160774876, 2160774935, 2160774995, 2160775055, 2160775115, 2160775175, 2160775235, 2160775295, 2160775355, 2160775500, 2160776126, 2160776185, 2160776245, 2160776305, 2160776365, 2160776425, 2160776485, 2160776751, 2160776811, 2160776813, 2160776816, 2160776819, 2160776822, 2160776871, 2160776873, 2160776876, 2160776879, 2160776882, 2160776885, 2160776888, 2160776891, 2160776930, 2160776990, 2160777050, 2160777110, 2160777171, 2160777173, 2160777176, 2160777179, 2160777182, 2160777185, 2160777188, 2160777191, 2160777230, 2160777290, 2160777351, 2160777353, 2160777356, 2160777359, 2160777362, 2160777365, 2160777368, 2160777371, 2160777374, 2160777377, 2160777380, 2160777383, 2160777386, 2160777389, 2160777392, 2160777395, 2160777410, 2160777470, 2160777530, 2160777375, 2160778000, 2160778625, 2160779250, 2160784500, 2160796000, 2160807500, 2160900000, 2161050001, 2161061501, 2161062126, 2161062185, 2161062750, 2161063375, 2161064000, 2161064625, 2161065250, 2161065875, 2161066500, 2161067125, 2161073001, 2161073625, 2161074250, 2161074875, 2161075500, 2161076125, 2161076750, 2161077375, 2161078000, 2161078625, 2161084500, 2161200001, 2161211500, 2161223000, 2161234500, 2161246000, 2161257500, 2161269000, 2161280500, 2161350001, 2161361500, 2161373000, 2161500001, 2161511500, 2161523000, 2161534500, 2165000001, 2165150000, 2165300001, 2165311500, 2165323000, 2165334501, 2165335125, 2165335750, 2165346001, 2165346625, 2165347250, 2165347875, 2165357500, 2165369001, 2165369625, 2165370250, 2165370875, 2165450000, 2165600000, 2165750000, 2165900000, 2166050001, 2166061500, 2166073000, 2166084500, 2166096000, 2166107500, 2166119000, 2166130500, 2166142000, 2166153500, 2166165000, 2166176501, 2166177126, 2166177185, 2166177245, 2166177751, 2166177810, 2166177870, 2166188000, 2166200000, 2166350001, 2166361500, 2166373000, 2166500000, 2166650000, 2166800000, 2166950000, 2167100000, 2167250000, 2170000001, 2170150000, 2170300001, 2170311500, 2170323000, 2170334501, 2170335125, 2170335750, 2170346000, 2170357500, 2170369000, 2170380501, 2170381125, 2170381750, 2170382375, 2170383000, 2170383626, 2170383685, 2170383745, 2170384250, 2170392001, 2170392625, 2170393250, 2170393876, 2170393935, 2170393995, 2170403501, 2170404125, 2170404750, 2170405375, 2170415000, 2170450000, 2170600000, 2170750000, 2170900000, 2171050001, 2171061500, 2171073000, 2171084500, 2171096000, 2171107500, 2171119000, 2171130500, 2171142000, 2171153500, 2171165000, 2171200000, 2175000001, 2175150000, 2175300000, 2175450000, 2175600001, 2175611500, 2175623000, 2175750001, 2175761500, 2175773000, 2175784500, 2180000001, 2180150000, 2180300000, 2180450000, 2180600001, 2180611500, 2180623000, 2180634500, 2185000001, 2185150000, 2185300000, 2185450000, 2185600000, 2185750000, 2185900000, 2186050000, 2186200001, 2186211500, 2186223000, 2186350000, 2186500000, 2186650000, 2186800000, 2186950000, 2187100000, 2187250000, 2187400000, 2187550000, 2187700000, 2187850001, 2187861500, 2187873000, 2188000000, 2188150000, 2188300000, 2188450000, 2190000001, 2190150001, 2190161501, 2190162125, 2190173000, 2190300001, 2190311500, 2190323000, 2190450001, 2190461500, 2190473000, 2190600001, 2190611501, 2190612125, 2190612750, 2190623000) in /var/www/v2.cart2india.com/vendor/yiisoft/yii2/db/Schema.php:664
Deadlock found when trying to get lock; try restarting transaction
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment