>Форум Mozilla Россия
   http://forum.mozilla-russia.org/index.php
>Firefox
   http://forum.mozilla-russia.org/viewforum.php?id=4
>Восстановление places.sqlite
   http://forum.mozilla-russia.org/viewtopic.php?id=70101

oopsididagainster > 12-06-2016 02:20:23

После переезда с Firefox 38 ESR на Firefox 45 ESR заметил что стала пропадать вся история, а в папке профиля появляется файл places.sqlite.corrupt. Восстанавливаю из бэкапа places.sqlite и всё равно через какой-то промежуток времени образуется places.sqlite.corrupt, закономерность появления которого выявить не получилось. В Firefox 38 ESR такого ни разу не происходило и не происходит.

Нагуглил способы решения от мозиловцев.

По ссылке приводится два способа:

1) автоматический с помощью расширения [url=https://addons.mozilla.org/ru/firefox/addon/places-maintenance/
]Places Maintenance[/url]
При анализе базы дополнение выводит "The database is corrupt.  I will try to generate a clean one".
Пытаюсь с помощью него восстановить, но получаю сообщение
"Generating new database...
Copying moz_places...OK
Copying moz_historyvisits...FAIL".

2) с помощью SQLite

Делаю всё по инструкции.

Команда PRAGMA integrity_check; выдаёт

скрытый текст
sqlite> PRAGMA integrity_check;
row 193951 missing from index moz_places_guid_uniqueindex
row 193951 missing from index moz_places_url_uniqueindex
row 193951 missing from index moz_places_lastvisitdateindex
row 193951 missing from index moz_places_frecencyindex
row 193951 missing from index moz_places_visitcount
row 193951 missing from index moz_places_hostindex
row 193951 missing from index moz_places_faviconindex
row 193952 missing from index moz_places_guid_uniqueindex
row 193952 missing from index moz_places_url_uniqueindex
row 193952 missing from index moz_places_lastvisitdateindex
row 193952 missing from index moz_places_frecencyindex
row 193952 missing from index moz_places_visitcount
row 193952 missing from index moz_places_hostindex
row 193952 missing from index moz_places_faviconindex
row 193953 missing from index moz_places_guid_uniqueindex
row 193953 missing from index moz_places_url_uniqueindex
row 193953 missing from index moz_places_lastvisitdateindex
row 193953 missing from index moz_places_frecencyindex
row 193953 missing from index moz_places_visitcount
row 193953 missing from index moz_places_hostindex
row 193953 missing from index moz_places_faviconindex
row 193954 missing from index moz_places_guid_uniqueindex
row 193954 missing from index moz_places_url_uniqueindex
row 193954 missing from index moz_places_lastvisitdateindex
row 193954 missing from index moz_places_frecencyindex
row 193954 missing from index moz_places_visitcount
row 193954 missing from index moz_places_hostindex
row 193954 missing from index moz_places_faviconindex
row 193955 missing from index moz_places_guid_uniqueindex
row 193955 missing from index moz_places_url_uniqueindex
row 193955 missing from index moz_places_lastvisitdateindex
row 193955 missing from index moz_places_frecencyindex
row 193955 missing from index moz_places_visitcount
row 193955 missing from index moz_places_hostindex
row 193955 missing from index moz_places_faviconindex
row 193956 missing from index moz_places_guid_uniqueindex
row 193956 missing from index moz_places_url_uniqueindex
row 193956 missing from index moz_places_lastvisitdateindex
row 193956 missing from index moz_places_frecencyindex
row 193956 missing from index moz_places_visitcount
row 193956 missing from index moz_places_hostindex
row 193956 missing from index moz_places_faviconindex
row 193957 missing from index moz_places_guid_uniqueindex
row 193957 missing from index moz_places_url_uniqueindex
row 193957 missing from index moz_places_lastvisitdateindex
row 193957 missing from index moz_places_frecencyindex
row 193957 missing from index moz_places_visitcount
row 193957 missing from index moz_places_hostindex
row 193957 missing from index moz_places_faviconindex
row 193958 missing from index moz_places_guid_uniqueindex
row 193958 missing from index moz_places_url_uniqueindex
row 193958 missing from index moz_places_lastvisitdateindex
row 193958 missing from index moz_places_frecencyindex
row 193958 missing from index moz_places_visitcount
row 193958 missing from index moz_places_hostindex
row 193958 missing from index moz_places_faviconindex
row 193959 missing from index moz_places_guid_uniqueindex
row 193959 missing from index moz_places_url_uniqueindex
row 193959 missing from index moz_places_lastvisitdateindex
row 193959 missing from index moz_places_frecencyindex
row 193959 missing from index moz_places_visitcount
row 193959 missing from index moz_places_hostindex
row 193959 missing from index moz_places_faviconindex
row 193960 missing from index moz_places_guid_uniqueindex
row 193960 missing from index moz_places_url_uniqueindex
row 193960 missing from index moz_places_lastvisitdateindex
row 193960 missing from index moz_places_frecencyindex
row 193960 missing from index moz_places_visitcount
row 193960 missing from index moz_places_hostindex
row 193960 missing from index moz_places_faviconindex
row 193961 missing from index moz_places_guid_uniqueindex
row 193961 missing from index moz_places_url_uniqueindex
row 193961 missing from index moz_places_lastvisitdateindex
row 193961 missing from index moz_places_frecencyindex
row 193961 missing from index moz_places_visitcount
row 193961 missing from index moz_places_hostindex
row 193961 missing from index moz_places_faviconindex
row 193962 missing from index moz_places_guid_uniqueindex
row 193962 missing from index moz_places_url_uniqueindex
row 193962 missing from index moz_places_lastvisitdateindex
row 193962 missing from index moz_places_frecencyindex
row 193962 missing from index moz_places_visitcount
row 193962 missing from index moz_places_hostindex
row 193962 missing from index moz_places_faviconindex
row 193963 missing from index moz_places_guid_uniqueindex
row 193963 missing from index moz_places_url_uniqueindex
row 193963 missing from index moz_places_lastvisitdateindex
row 193963 missing from index moz_places_frecencyindex
row 193963 missing from index moz_places_visitcount
row 193963 missing from index moz_places_hostindex
row 193963 missing from index moz_places_faviconindex
row 193964 missing from index moz_places_guid_uniqueindex
row 193964 missing from index moz_places_url_uniqueindex
row 193964 missing from index moz_places_lastvisitdateindex
row 193964 missing from index moz_places_frecencyindex
row 193964 missing from index moz_places_visitcount
row 193964 missing from index moz_places_hostindex
row 193964 missing from index moz_places_faviconindex
row 193965 missing from index moz_places_guid_uniqueindex
row 193965 missing from index moz_places_url_uniqueindex

При клонировании выводится
скрытый текст
sqlite> .clone places.new.sqlite
moz_places... done
moz_historyvisits... done
moz_inputhistory... done
moz_bookmarks... done
moz_bookmarks_roots... done
moz_keywords... done
sqlite_sequence... Error: object name reserved for internal use: sqlite_sequence

SQL: [CREATE TABLE sqlite_sequence(name,seq)]
done
moz_favicons... done
moz_annos... done
moz_anno_attributes... done
moz_items_annos... done
sqlite_stat1... Error: object name reserved for internal use: sqlite_stat1
SQL: [CREATE TABLE sqlite_stat1(tbl,idx,stat)]
Error 1: no such table: sqlite_stat1 on [SELECT * FROM "sqlite_stat1"]
done
moz_hosts... done
sqlite_autoindex_moz_inputhistory_1... done
sqlite_autoindex_moz_bookmarks_roots_1... done
sqlite_autoindex_moz_keywords_1... done
sqlite_autoindex_moz_favicons_1... done
sqlite_autoindex_moz_anno_attributes_1... done
sqlite_autoindex_moz_hosts_1... done
moz_places_faviconindex... done
moz_places_hostindex... done
moz_places_visitcount... done
moz_places_frecencyindex... done
moz_places_lastvisitdateindex... done
moz_historyvisits_placedateindex... done
moz_historyvisits_fromindex... done
moz_historyvisits_dateindex... done
moz_bookmarks_itemindex... done
moz_bookmarks_parentindex... done
moz_bookmarks_itemlastmodifiedindex... done
moz_places_url_uniqueindex... Error: UNIQUE constraint failed: moz_places.url
SQL: [CREATE UNIQUE INDEX moz_places_url_uniqueindex ON moz_places (url)]
done
moz_places_guid_uniqueindex... done
moz_bookmarks_guid_uniqueindex... done
moz_annos_placeattributeindex... done
moz_items_annos_itemattributeindex... done
moz_keywords_placepostdata_uniqueindex... done


После клонирования places.sqlite уменьшается с 120M до 86М и появляется: если я захожу в Журнал и начинаю прокручивать историю то браузер начинает лагать(и грузить процессор) и история прокручивается со скоростью одна страница в 3 секунды.



Если посмотреть с помощью расширения Places Maintenance статистику places.sqlite до и после клонирования, то в клонированном places.sqlite отсутствует индекс moz_places_url_uniqueindex.

Можно ли как-то восстановить places.sqlite ?

oopsididagainster > 15-06-2016 21:50:47

"Разобрался". К клонированному places.sqlite нужно применить команду

Выделить код

Код:

CREATE INDEX moz_places_url_uniqueindex ON moz_places (url);

Я точно не знаю правильно ли это, но мою проблему - лаги при просмотре истории и places.sqlite.corrupt - это решило.