Mysql Error On all Sites After Upgrading and Tuning Mysql

Post all bugs here
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Site 1 : Mysql errors

2013-06-19 21:58:23 : Mysql error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN current_clicks + 1 WHEN thumb_id = 28674 THEN current_clicks + 1 WHEN thu' at line 1) in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 26809 THEN current_clicks + 1 WHEN thumb_id = 22431 THEN current_clicks + 2 WHEN thumb_id = 24850 THEN current_clicks + 1 WHEN thumb_id = 28160 THEN current_clicks + 2 WHEN thumb_id = 18742 THEN current_clicks + 2 WHEN thumb_id = 28878 THEN current_clicks + 1 WHEN thumb_id = 9952 THEN current_clicks + 1 WHEN thumb_id = 13837 THEN current_clicks + 2 WHEN thumb_id = 24703 THEN current_clicks + 1 WHEN thumb_id = 13585 THEN current_clicks + 1 WHEN thumb_id = 9174 THEN current_clicks + 1 WHEN thumb_id = 7233 THEN current_clicks + 1 WHEN thumb_id = 24835- THEN current_clicks + 1 WHEN thumb_id = 28674 THEN current_clicks + 1 WHEN thumb_id = 23628 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 26809 THEN current_points + 1000 WHEN thumb_id = 22431 THEN current_points + 2000 WHEN thumb_id = 24850 THEN current_points + 1000 WHEN thumb_id = 28160 THEN current_points + 2000 WHEN thumb_id = 18742 THEN current_points + 2000 WHEN thumb_id = 28878 THEN current_points + 1000 WHEN thumb_id = 9952 THEN current_points + 1000 WHEN thumb_id = 13837 THEN current_points + 2000 WHEN thumb_id = 24703 THEN current_points + 1000 WHEN thumb_id = 13585 THEN current_points + 1000 WHEN thumb_id = 9174 THEN current_points + 1000 WHEN thumb_id = 7233 THEN current_points + 1000 WHEN thumb_id = 24835- THEN current_points + 1000 WHEN thumb_id = 28674 THEN current_points + 1000 WHEN thumb_id = 23628 THEN current_points + 1000 END WHERE thumb_id IN (26809,22431,24850,28160,18742,28878,9952,13837,24703,13585,9174,7233,24835-,28674,23628)
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

2013-06-19 21:58:23 : Mysql error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6) in query UPDATE LOW_PRIORITY rot_gallery_stats SET total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9, total_clicks = current_clicks + clicks0 + clicks1 + clicks2 + clicks3 + clicks4 + clicks5 + clicks6 + clicks7 + clicks8 + clicks9,total_points = current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9,total_ctr = (current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9)/(current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9)/1000
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

WHERE thumb_id IN (28481,29184,23628,20957,4465,8809,29122,13837,9174,21538,5316,13585,18742,7233,9952,12885,27854,24835,23496,21222,22320,24007,28429,20230,14976,27255,11729,12935,23741,23722,22719,24543,23293,20747,26778,28674,28419,23490,13056,29173,28647,26877,18792,26767,20944,20189,6799,12878,28099,24459,23540,28891,18769,27362,24926,22335,25590,25718,24353,9839,4565,27761,23743,24759,27896,22600,26922,28503,7467,22431,28279,4555,24850,27308,26809,5352,26604,7508,25006,24703,26133,4500,27202,25286,10044,25287,28204,6608,29169,4302,23974,29185,8748,12342,7394,18759,9439,25695,26611,13082,26771,13548,23919,25155,4378,5868,22770,20690,18367,13052,13083,8583,5110,29098,28333,13544,24383,6142,24570,29135,28878,24164,4940,22019,28802,20933,28823,23260,25707,6462,19675,6577,21490,9317,7851,20695,26614,24516,27602,23249,29156,8486,7990,20313,7250,21532,22689,21568,7950,7850,26828,28958,8630,6054,23677,7270,4680,13015,27100,8566,8154,19395,13153,5339,13766,5946,13725,16453,7289,24775,20677,9925,7971,7126,28160,24835-)
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Site 2:

2013-06-18 07:26:16 : Mysql error: 1054 (Unknown column '5398htt' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 27305 THEN current_clicks + 1 WHEN thumb_id = 23712 THEN current_clicks + 2 WHEN thumb_id = 12036 THEN current_clicks + 1 WHEN thumb_id = 29251 THEN current_clicks + 4 WHEN thumb_id = 31365 THEN current_clicks + 1 WHEN thumb_id = 18348 THEN current_clicks + 1 WHEN thumb_id = 26746 THEN current_clicks + 1 WHEN thumb_id = 5398htt THEN current_clicks + 2 WHEN thumb_id = 30307 THEN current_clicks + 1 WHEN thumb_id = 30133 THEN current_clicks + 1 WHEN thumb_id = 26537 THEN current_clicks + 1 WHEN thumb_id = 31722 THEN current_clicks + 1 WHEN thumb_id = 14136 THEN current_clicks + 1 WHEN thumb_id = 17009 THEN current_clicks + 2 WHEN thumb_id = 10956 THEN current_clicks + 1 WHEN thumb_id = 23619 THEN current_clicks + 1 WHEN thumb_id = 28510 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 27305 THEN current_points + 1000 WHEN thumb_id = 23712 THEN current_points + 2000 WHEN thumb_id = 12036 THEN current_points + 1000 WHEN thumb_id = 29251 THEN current_points + 4000 WHEN thumb_id = 31365 THEN current_points + 1000 WHEN thumb_id = 18348 THEN current_points + 1000 WHEN thumb_id = 26746 THEN current_points + 1000 WHEN thumb_id = 5398htt THEN current_points + 2000 WHEN thumb_id = 30307 THEN current_points + 1000 WHEN thumb_id = 30133 THEN current_points + 1000 WHEN thumb_id = 26537 THEN current_points + 1000 WHEN thumb_id = 31722 THEN current_points + 1000 WHEN thumb_id = 14136 THEN current_points + 1000 WHEN thumb_id = 17009 THEN current_points + 2000 WHEN thumb_id = 10956 THEN current_points + 1000 WHEN thumb_id = 23619 THEN current_points + 1000 WHEN thumb_id = 28510 THEN current_points + 1000 END WHERE thumb_id IN
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

(27305,23712,12036,29251,31365,18348,26746,5398htt,30307,30133,26537,31722,14136,17009,10956,23619,28510)

Site 3 :

2013-06-19 01:12:47 : Mysql error: 1054 (Unknown column '15633f8f95' in 'where clause') in query select id, rgroup from rot_galleries where id IN
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

(48284,16040,15991,42758,43140,46711,43180,48839,39024,22445,42978,16482,15633,40171,16258,49208,17345,11293,33055,16074,15860,15842,41281,16149,33338,12317,12861,40358,49059,11440,16875,16813,17140,16827,41928,23658,10479,36420,49151,48197,23971,11128,22500,15815,48373,49223,49228,16823,22466,16426,43145,26442,31894,15879,43973,15626,47482,15821,16079,18168,224
61,39204,16585,16380,48939,49203,48748,49188,42918,22432,16343,17469,23341,41934,40613,15737,13161,11370,16964,43640,35595,31265,16709,571,48251,13179,38876,49198,16807,16473,48232,25042,49193,16770,22902,16579,26319,15836,16583,17321,44591,341,2944,15604,15609,16393,21299,48969,9612,46069,45417,17030,41020,23164,40409,44427,16580,33868,11042,43049,41874,43011,2
3675,15706,22928,24549,48586,44858,22672,32678,16177,18787,23956,48779,49218,47425,49054,22444,41111
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

,15784,39544,24245,12406,12251,12397,15974,22952,19322,48246,19127,22564,45455,47487,16860,46074,41900,47670,22415,1106,26204,15633f8f95)

Hi,
Have pasted some of the mysql error logs for 3 sites.Yes these seem to be happening everyday, after cleaning logs and upgrading it took 24 hours for these errors to show up.Please let me know how to proceed with fixing these invalid queries.

Regards,
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
Still waiting to hear on how to fix these sql queries.

Regards,
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by admin »

What build do you use now ?
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
Am using Build 201306190206 now.Even with upgrading 2 times these mysql errors are not going.They show everyday in logs.How do I fix this? Need urgent help to resolve this.

Regards,
Post Reply