pkg: sqlite error while executing CREATE TABLE licenses

hjfeng1988

在看Restoring the Package Database，沒(méi)注意到restore字眼。

1. pkg backup -r /path/to/pkg.sql

復(fù)制代碼

提示我：No such file or directory，我就自己touch了空文件。再次restore，然后pkg就壞了。之前沒(méi)有備份

1. root@host102:~ # pkg info
   
2. pkg: sqlite error while executing CREATE TABLE licenses (id INTEGER PRIMARY KEY, license TEXT NOT NULL UNIQUE );CREATE TABLE pkg_licenses_assoc (package_id INTEGER REFERENCES packages(id) ON DELETE CASCADE ON UPDATE CASCADE, license_id INTEGER REFERENCES licenses(id) ON DELETE RESTRICT ON UPDATE RESTRICT, PRIMARY KEY (package_id, license_id));CREATE VIEW pkg_licenses AS SELECT origin, license FROM packages INNER JOIN pkg_licenses_assoc ON packages.id = pkg_licenses_assoc.package_id INNER JOIN licenses ON pkg_licenses_assoc.license_id = licenses.id;CREATE TRIGGER license_insert INSTEAD OF INSERT ON pkg_licenses FOR EACH ROW BEGIN INSERT OR IGNORE INTO licenses(license) values (NEW.license);INSERT INTO pkg_licenses_assoc(package_id, license_id) VALUES ((SELECT id FROM packages where origin = NEW.origin), (SELECT id FROM categories WHERE name = NEW.name));END; in file pkgdb.c:2333: no such table: main.packages

復(fù)制代碼

hjfeng1988

我把/var/db/pkg/local.sqlite刪除了，目錄重建。
之前安裝的軟件還可以用，只是pkg info已找不到條目。跑的虛擬機(jī)測(cè)試環(huán)境，線上服務(wù)請(qǐng)勿參考

lsstarboy

pkg數(shù)據(jù)庫(kù)還是少動(dòng)為妙，否則就會(huì)莫名奇妙。