WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_wsm_dateWisePageViews AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m-%d') as recordDate, SUM(totalViews) as pageViews FROM wp_wsm_pageViews GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m-%d')

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

WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_wsm_hourWisePageViews AS SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00')) as hour, SUM(totalViews) as pageViews FROM wp_wsm_pageViews WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+00:00') >= '2026-03-16 00:00:00' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'))

WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_wsm_hourWiseBounce AS SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00')) as hour, COUNT(*) as bounce FROM wp_wsm_bounceVisits WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+00:00') >= '2026-03-16 00:00:00' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'))

WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW wp_wsm_hourWiseVisitors AS SELECT HOUR(CONVERT_TZ(firstActionVisitTime,'+00:00','+00:00')) as hour, COUNT(*) as visitors FROM wp_wsm_logUniqueVisit WHERE CONVERT_TZ(firstActionVisitTime,'+00:00','+00:00') >= '2026-03-16 00:00:00' GROUP BY HOUR(CONVERT_TZ(firstActionVisitTime,'+00:00','+00:00'))