Error Final: mysql.prd.otpusk.com Deadlock found when trying to get lock; try restarting transaction [ REPLACE INTO `hotelSimilar` (`hotelId`, `similarId`, `distance`, `index_radius`, `hotel_stars`, `similar_stars`, `index_stars`, `hotel_price`, `similar_price`, `percent`, `index_price`, `hotel_rating`, `similar_rating`, `index_rating`, `hotel_services`, `hotel_services_stat`, `similar_services`, `similar_services_stat`, `count_services`, `sum_services`, `index_services`, `hotel_area`, `similar_area`, `index_area`, `cats`, `index_cat`, `forms`, `index_form`, `rate`) VALUES (87183, 34204, 0.090000, 1, '4,3', '3,3', 5, 0.000000, 29215.000000, 100.000000, -2, 0.000000, 7.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '16,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.987742), (87183, 80961, 0.840000, 1, '4,3', '3,3', 5, 0.000000, 964.380000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '18,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.987742), (87183, 81876, 1.050000, 0.980000, '4,3', '4,4', 5, 0.000000, 644.830000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '20,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.967742), (87183, 43671, 1.070000, 0.980000, '4,3', '3,3', 5, 0.000000, 31694.000000, 100.000000, -2, 0.000000, 2.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '13,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.967742), (87183, 84472, 1.170000, 0.980000, '4,3', '3,3', 5, 0.000000, 32262.000000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '14,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.967742), (87183, 86798, 1.240000, 0.980000, '4,3', '3,4', 5, 0.000000, 879.650000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '15,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.967742), (87183, 18109, 1.820000, 0.960000, '4,3', '3,4', 5, 0.000000, 33399.000000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '18,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.947742), (87183, 90983, 1.890000, 0.960000, '4,3', '3,3', 5, 0.000000, 29215.000000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '14,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.947742), (87183, 57296, 2.060000, 0.960000, '4,3', '3,3', 5, 0.000000, 616.000000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '16,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.947742), (87183, 89207, 2.180000, 0.960000, '4,3', '4,3', 5, 0.000000, 31126.000000, 100.000000, -2, 0.000000, 0.000000, 0, 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '17,3', 'restaurant,wifi,sauna\n[outdoor_pool,indoor_pool,dock,adults,large_area,childpool,playground,nursery,childmenu,aquapark,ski_slopes,spa,tennis_court,golf,fitness,diving,discotheque,casino,animation,one_line_beach,two_line_beach,own,town,sandy,sandy_pebble,pebble,cay,pontoon]', '16,3', 31, 3, 0.967742, '0', '0', 0, 'city=city', 0.010000, 'hotel=hotel', 0.010000, 4.947742) ]