pkg: sqlite error while executing CREATE TABLE licenses

hjfeng1988

在看Restoring the Package Database，没注意到restore字眼。

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

复制代码

提示我：No such file or directory，我就自己touch了空文件。再次restore，然后pkg就坏了。之前没有备份

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

复制代码

hjfeng1988

我把/var/db/pkg/local.sqlite删除了，目录重建。
之前安装的软件还可以用，只是pkg info已找不到条目。跑的虚拟机测试环境，线上服务请勿参考

lsstarboy

pkg数据库还是少动为妙，否则就会莫名奇妙。