WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_5pzm3tzkyg_wsm_monthWiseVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+05:30'),'%Y-%m') as recordMonth, COUNT(*) as visitors FROM wp_5pzm3tzkyg_wsm_logUniqueVisit GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+05:30'),'%Y-%m')

WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_5pzm3tzkyg_wsm_monthWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+05:30'),'%Y-%m') as recordMonth, COUNT(*) as bounce FROM wp_5pzm3tzkyg_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+05:30'),'%Y-%m-')