DBG(1)[3908]> PkgConfig: loading repositories in /etc/pkg/
DBG(1)[3908]> PKgConfig: loading /etc/pkg//FreeBSD.conf
DBG(1)[3908]> PkgConfig: parsing key 'FreeBSD'
DBG(1)[3908]> PkgConfig: parsing repository object FreeBSD
DBG(1)[3908]> PkgConfig: skipping disabled repo FreeBSD
DBG(1)[3908]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/
DBG(1)[3908]> PKgConfig: loading /usr/local/etc/pkg/repos//flo.conf
DBG(1)[3908]> PkgConfig: parsing key 'flo'
DBG(1)[3908]> PkgConfig: parsing repository object flo
Updating flo repository catalogue...
DBG(1)[3908]> PkgRepo: verifying update for flo
DBG(4)[3908]> Pkgdb: running 'SELECT count(name) FROM sqlite_master WHERE type='table' AND name='repodata';'
DBG(4)[3908]> Pkgdb: running 'select count(key) from repodata WHERE key = "packagesite" and value = 'https://packages.smeets.xyz/packages/head-smeets''
DBG(4)[3908]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, pkgsize, cksum, manifestdigest, path AS repopath, 'flo' AS dbname FROM packages AS p ORDER BY name;' query for all
DBG(1)[3908]> Pkgrepo, begin update of '/var/db/pkg/repo-flo.sqlite'
DBG(1)[3908]> Fetch: fetching from: https://packages.smeets.xyz/packages/head-smeets/meta.txz with opts "iv"
looking up packages.smeets.xyz
connecting to packages.smeets.xyz:443
SSL options: 83004bff
Peer verification enabled
Using CA cert file: /usr/local/etc/ssl/cert.pem
Verify hostname
TLSv1.2 connection established using ECDHE-RSA-AES256-GCM-SHA384
Certificate subject: /CN=lists.smeets.xyz
Certificate issuer: /C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X3
requesting https://packages.smeets.xyz/packages/head-smeets/meta.txz
If-Modified-Since: Sun, 19 Feb 2017 20:09:11 GMT
DBG(1)[3908]> Fetch: fetching from: https://packages.smeets.xyz/packages/head-smeets/packagesite.txz with opts "iv"
looking up packages.smeets.xyz
connecting to packages.smeets.xyz:443
SSL options: 83004bff
Peer verification enabled
Using CA cert file: /usr/local/etc/ssl/cert.pem
Verify hostname
TLSv1.2 connection established using ECDHE-RSA-AES256-GCM-SHA384
Certificate subject: /CN=lists.smeets.xyz
Certificate issuer: /C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X3
requesting https://packages.smeets.xyz/packages/head-smeets/packagesite.txz
If-Modified-Since: Sun, 19 Feb 2017 20:09:11 GMT
flo repository is up to date.
All repositories are up to date.
DBG(4)[3908]> Pkgdb: running 'PRAGMA user_version;'
DBG(4)[3908]> Pkgdb: executing 'PRAGMA foreign_keys = ON;'
pkg: Repository flo load error: access repo file(/var/db/pkg/repo-flo.sqlite) failed: No such file or directory
pkg: Repository flo cannot be opened. 'pkg update' required
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO mtree(content) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, mtree_id, time, manifestdigest, dep_formula, vital)VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, (SELECT id FROM mtree WHERE content = ?14), NOW(), ?15, ?16, ?17 )'
DBG(4)[3908]> Pkgdb: preparing statement 'UPDATE deps SET origin=?1, version=?2 WHERE name=?3;'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO deps (origin, name, version, package_id) VALUES (?1, ?2, ?3, ?4)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR REPLACE INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO directories(path) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_directories(package_id, directory_id, try) VALUES (?1, (SELECT id FROM directories WHERE path = ?2), ?3)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO categories(name) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_categories(package_id, category_id) VALUES (?1, (SELECT id FROM categories WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO licenses(name) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_licenses(package_id, license_id) VALUES (?1, (SELECT id FROM licenses WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO users(name) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_users(package_id, user_id) VALUES (?1, (SELECT id FROM users WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO groups(name) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_groups(package_id, group_id) VALUES (?1, (SELECT id FROM groups WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO script(script) VALUES (?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_script(script_id, package_id, type) VALUES ((SELECT script_id FROM script WHERE script = ?1), ?2, ?3)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO option (option) VALUES (?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_option(package_id, option_id, value) VALUES (?1, (SELECT option_id FROM option WHERE option = ?2),?3)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO shlibs(name) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO pkg_shlibs_required(package_id, shlib_id) VALUES (?1, (SELECT id FROM shlibs WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO pkg_shlibs_provided(package_id, shlib_id) VALUES (?1, (SELECT id FROM shlibs WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO annotation(annotation) VALUES (?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR ROLLBACK INTO pkg_annotation(package_id, tag_id, value_id) VALUES (?1, (SELECT annotation_id FROM annotation WHERE annotation = ?2), (SELECT annotation_id FROM annotation WHERE annotation = ?3))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO pkg_annotation(package_id, tag_id, value_id) VALUES ( (SELECT id FROM packages WHERE name = ?1 ), (SELECT annotation_id FROM annotation WHERE annotation = ?2), (SELECT annotation_id FROM annotation WHERE annotation = ?3))'
DBG(4)[3908]> Pkgdb: preparing statement 'DELETE FROM pkg_annotation WHERE package_id IN (SELECT id FROM packages WHERE name = ?1) AND tag_id IN (SELECT annotation_id FROM annotation WHERE annotation = ?2)'
DBG(4)[3908]> Pkgdb: preparing statement 'DELETE FROM annotation WHERE annotation_id NOT IN (SELECT tag_id FROM pkg_annotation) AND annotation_id NOT IN (SELECT value_id FROM pkg_annotation)'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_conflicts(package_id, conflict_id) VALUES (?1, (SELECT id FROM packages WHERE name = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_provides(package_id, provide_id) VALUES (?1, (SELECT id FROM provides WHERE provide = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO provides(provide) VALUES(?1)'
DBG(4)[3908]> Pkgdb: preparing statement 'UPDATE packages SET manifestdigest=?1 WHERE id=?2;'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO config_files(path, content, package_id) VALUES (?1, ?2, ?3);'
DBG(4)[3908]> Pkgdb: preparing statement 'UPDATE config_files SET content=?1 WHERE path=?2;'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT INTO pkg_requires(package_id, require_id) VALUES (?1, (SELECT id FROM requires WHERE require = ?2))'
DBG(4)[3908]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO requires(require) VALUES(?1)'
DBG(1)[3908]> want to get an advisory lock on a database
DBG(4)[3908]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p WHERE manifestdigest IS NULL OR manifestdigest=='' ORDER BY p.name;'
DBG(4)[3908]> Pkgdb: executing 'PRAGMA synchronous = OFF;PRAGMA journal_mode = MEMORY;BEGIN TRANSACTION;'
DBG(4)[3908]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p WHERE name = ?1 COLLATE NOCASE OR (name = SPLIT_VERSION('name', ?1) COLLATE NOCASE AND  version = SPLIT_VERSION('version', ?1)) ORDER BY p.name;'
DBG(4)[3908]> Pkgdb: running 'SELECT d.name, d.origin, d.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = ?1  ORDER BY d.origin DESC'
DBG(4)[3908]> Pkgdb: running 'SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = ?1'
DBG(4)[3908]> Pkgdb> adding option
DBG(4)[3908]> Pkgdb: running 'SELECT option, value  FROM option    JOIN pkg_option USING(option_id)  WHERE package_id = ?1  ORDER BY option'
DBG(4)[3908]> Pkgdb> adding option
DBG(4)[3908]> Pkgdb> adding option
DBG(4)[3908]> Pkgdb: running 'SELECT name  FROM pkg_shlibs_required, shlibs AS s  WHERE package_id = ?1    AND shlib_id = s.id  ORDER by name DESC'
DBG(4)[3908]> Pkgdb: running 'SELECT name  FROM pkg_shlibs_provided, shlibs AS s  WHERE package_id = ?1    AND shlib_id = s.id  ORDER by name DESC'
DBG(3)[3908]> added shlib provide libpkg.so.4 for pkg
DBG(4)[3908]> Pkgdb: running 'SELECT k.annotation AS tag, v.annotation AS value  FROM pkg_annotation p    JOIN annotation k ON (p.tag_id = k.annotation_id)    JOIN annotation v ON (p.value_id = v.annotation_id)  WHERE p.package_id = ?1  ORDER BY tag, value'
DBG(4)[3908]> Pkgdb: running 'SELECT packages.name  FROM pkg_conflicts    LEFT JOIN packages ON    (packages.id = pkg_conflicts.conflict_id)  WHERE package_id = ?1'
DBG(4)[3908]> Pkgdb: running 'SELECT provide  FROM pkg_provides, provides AS s  WHERE package_id = ?1    AND provide_id = s.id  ORDER by provide DESC'
DBG(4)[3908]> Pkgdb: running 'SELECT require  FROM pkg_requires, requires AS s  WHERE package_id = ?1    AND require_id = s.id  ORDER by require DESC'
DBG(4)[3908]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p WHERE name = ?1 COLLATE NOCASE OR (name = SPLIT_VERSION('name', ?1) COLLATE NOCASE AND  version = SPLIT_VERSION('version', ?1)) ORDER BY p.name;'
DBG(4)[3908]> Pkgdb: running 'SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = ?1'
DBG(2)[3908]> non-automatic package with pattern pkg has not been found in remote repo
DBG(2)[3908]> universe: add new local pkg: pkg, (pkg-1.10.99.1:2$2$icw3riqfx1swahz6ka1qkr74tx94zn56zwjk153mxa7ghqnkbij4w7pnqad7uswmfzw5a1zi54fwhn8tcrggkqz1dfqpccady9c19nn)
DBG(4)[3908]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p ORDER BY p.name;'
Checking for upgrades (0 candidates): . done
Processing candidates (0 candidates): . done
DBG(4)[3908]> solver: add variable from universe with uid pkg
DBG(1)[3908]> problem has no requests
DBG(2)[3908]> decided local pkg-2$2$icw3riqfx1swahz6ka1qkr74tx94zn56zwjk153mxa7ghqnkbij4w7pnqad7uswmfzw5a1zi54fwhn8tcrggkqz1dfqpccady9c19nn to install
DBG(4)[3908]> solver: check variable with uid pkg
DBG(2)[3908]> solver: ignoring package pkg(2$2$icw3riqfx1swahz6ka1qkr74tx94zn56zwjk153mxa7ghqnkbij4w7pnqad7uswmfzw5a1zi54fwhn8tcrggkqz1dfqpccady9c19nn) as its state has not been changed
DBG(4)[3908]> Pkgdb: executing 'END TRANSACTION;PRAGMA synchronous = NORMAL;PRAGMA journal_mode = DELETE;'
DBG(4)[3908]> jobs: running 'UPDATE packages SET name=?1  WHERE name=?2;'
Checking integrity...DBG(1)[3908]> check integrity for 0 items added
 done (0 conflicting)
Your packages are up to date.
DBG(1)[3908]> release an advisory lock on a database