Page 1 of 5

Rotation linked DB version mismatch

Posted: Sat Jul 12, 2014 9:59 pm
by gelius

Code: Select all

Rotation linked DB version mismatch (remote 50 while local 51) 
В адманке после обновления слейва до 51.
На морде куча ошибок.
Т.е. теперь обязатьельно мастер обновлять?

Re: Rotation linked DB version mismatch

Posted: Mon Jul 14, 2014 1:35 am
by admin
Да.
Мастер и слейв должны быть одинаковой версии.

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 12:49 am
by gelius
При обновлении мастера все наибнулось. Скачет нагрузка mysql, пропали все тумбы, побилась половина таблиц на сервере.
На мастере здоровая база в сильно запущенном варианте.
Ttl Main - 1271574
To Grab - 861319
Как бы все это подчистить и оптимизировать?
Желательно безопасно и не вручную.

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 8:48 am
by gelius
...

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 9:02 am
by gelius
...

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 9:35 am
by gelius
Все забито такими запросами:

Code: Select all

| 1435 | db | localhost | db | Query | 20 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1446 | db | localhost | db | Query | 23 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1470 | db | localhost | db | Query | 17 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1471 | db | localhost | db | Query | 22 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1491 | db | localhost | db | Query | 8 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1493 | db | localhost | db | Query | 8 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1498 | db | localhost | db | Query | 279 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1532 | db | localhost | db | Query | 15 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_templat |
| 1552 | db | localhost | db | Query | 253 | Locked | select g.rgroup as group_id, gi.*, g.*, gd.* from rot_galleries as g
Сервак валится нах.

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 11:15 am
by gelius

Code: Select all

| 63 | db | localhost | db | Query | 128 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as c |
| 73 | db | localhost | db | Query | 123 | Copying to tmp table | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |
| 83 | db | localhost | db | Query | 115 | Sorting for group | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |
| 87 | db | localhost | db | Query | 118 | Copying to tmp table | select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_ |
| 111 | db | localhost | db | Query | 56 | Sending data | select count(*) as count from rot_galleries where status = 1 |
| 123 | db | localhost | db | Query | 103 | Copying to tmp table | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |
| 158 | db | localhost | db | Query | 87 | Copying to tmp table | select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_ |
| 165 | db | localhost | db | Query | 85 | Copying to tmp table | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |
| 173 | db | localhost | db | Query | 84 | Sorting for group | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |
| 198 | db | localhost | db | Query | 75 | Copying to tmp table | SELECT g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total |

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 11:58 am
by admin
Остановите кроны для начала.

Удалить to grab можно нажав соотв линк в rotation - import.

Что именно упало в процессе обновления ? что писал апдейт ?

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 12:29 pm
by gelius
Кроны остановлены, но это не помогло.
Остановлена ротация.
Запросы выложенные выше грузят мускуль и все падает.
apach, nginx. Все домены начинают выдавать 502 Bad Gateway, или наворачиваются бд и приходится постоянно восстанавливать.
И я без понятия что вы имеете ввиду под "что писал апдейт ?".
Ничего не писал, нормально обновился как всегда.
Похоже тяжелые запросы к базе создают такие запросы к домену:

Code: Select all

Srv	PID	Acc	M	CPU 	SS	Req	Conn	Child	Slot	Client	VHost	Request
0-4	52347	0/6/25	W 	0.23	144	0	0.0	0.16	0.51 	189.29.246.205	domain.com	GET /category/young/ctr/1/ HTTP/1.0
1-4	51578	0/8/8	W 	0.98	305	0	0.0	0.00	0.00 	85.135.164.55	domain.com	GET /category/first%20Time%20/ctr/1/ HTTP/1.0
2-4	52042	0/24/39	W 	1.43	166	0	0.0	0.41	0.42 	86.111.146.27	domain.com	GET /category/italian/ctr/1/?images/4x59x34853 HTTP/1.0
3-4	52043	0/11/17	W 	0.15	278	0	0.0	0.10	0.10 	119.236.57.63	domain.com	GET /category/220/forced/ctr/1/ HTTP/1.0
4-4	51581	0/62/62	W 	2.77	144	0	0.0	1.07	1.07 	86.111.146.27	domain.com	GET /category/italian/ctr/1/?images/4x59x34853 HTTP/1.0
5-4	51622	0/10/10	W 	0.53	293	0	0.0	0.11	0.11 	85.135.164.55	domain.com	GET /category/teen/ctr/1/ HTTP/1.0
6-4	52423	0/3/30	W 	0.15	133	0	0.0	0.08	0.48 	58.179.110.245	domain.com	GET /category/teen/ctr/1/ HTTP/1.0
7-4	52177	0/9/25	W 	0.52	175	0	0.0	0.13	0.23 	69.61.110.143	domain.com	GET /category/czech/ctr/1/?images/4x2x33093 HTTP/1.0
8-4	52068	0/9/20	W 	0.33	242	0	0.0	0.18	0.18 	69.61.40.85	domain.com	GET /category/hentai/ctr/1/?images/4x5x37188 HTTP/1.0
9-4	52069	0/19/32	W 	0.32	248	0	0.0	0.17	0.36 	85.18.242.162	domain.com	GET /category/hidden%20Cams/ctr/1/?images/4x4x33105 HTTP/1.0
10-4	52070	0/38/42	W 	1.02	149	0	0.0	0.37	0.37 	66.249.67.254	domain.com	GET /gallery/asian-fucked-3/index.html?6x6x678968 HTTP/1.0
11-4	52071	0/34/47	W 	1.63	133	0	0.0	0.52	0.72 	58.179.110.245	domain.com	GET /category/teen/ctr/1/ HTTP/1.0
12-4	52432	0/18/56	W 	0.59	103	0	0.0	0.54	1.41 	176.14.188.16	domain.com	GET /category/113/asian/ctr/1/ HTTP/1.0
13-4	51701	0/7/7	W 	0.54	179	0	0.0	0.02	0.02 	58.179.110.245	domain.com	GET /category/young/ctr/1/ HTTP/1.0
14-4	52436	0/0/13	W 	1.13	132	0	0.0	0.00	0.21 	58.179.110.245	domain.com	GET /category/teen/ctr/1/ HTTP/1.0
15-4	52072	0/50/62	W 	2.14	123	0	0.0	0.78	0.88 	50.117.34.200	domain.com	GET /category/bus/ctr/1/?images/4x46x31621 HTTP/1.0
16-4	52073	0/83/87	W 	2.58	138	0	0.0	2.07	2.07 	183.171.163.10	domain.com	GET /category/216/18/ctr/1/ HTTP/1.0
17-4	51705	0/11/11	W 	0.44	275	0	0.0	0.04	0.04 	37.58.100.157	domain.com	GET /gallery/my-first-sex-teacher-3/index.html?6x1x493449 HTTP/
18-4	52120	0/0/8	W 	0.24	246	0	0.0	0.00	0.04 	69.61.28.92	domain.com	GET /category/hidden%20Cams/ctr/1/?images/4x4x33105 HTTP/1.0
19-4	52126	0/8/16	W 	0.54	190	0	0.0	0.00	0.02 	80.70.22.122	domain.com	GET /category/211/vintage/ctr/1/ HTTP/1.0
20-4	52437	0/16/50	W 	0.43	117	0	0.0	0.38	0.67 	58.179.110.245	domain.com	GET /category/young/ctr/1/ HTTP/1.0

Re: Rotation linked DB version mismatch

Posted: Tue Jul 15, 2014 12:32 pm
by gelius
Предусмотрен механизм отката на предыдущую версию?
Полных бекапов нету, только бекап бд который делает смарт автоматически.