DBG(1)[4691]> pkg initialized
DBG(1)[4691]> Setting env var: http_proxy
DBG(1)[4691]> PkgConfig: loading repositories in /etc/pkg/
DBG(1)[4691]> PKgConfig: loading /etc/pkg/FreeBSD.conf
DBG(1)[4691]> PkgConfig: parsing key 'FreeBSD'
DBG(1)[4691]> PkgConfig: parsing repository object FreeBSD
DBG(1)[4691]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/
DBG(1)[4691]> PKgConfig: loading /usr/local/etc/pkg/repos/bla.conf
DBG(1)[4691]> PkgConfig: parsing key 'bla'
DBG(1)[4691]> PkgConfig: parsing repository object bla
DBG(1)[4691]> PkgConfig: skipping disabled repo bla
DBG(1)[4691]> PkgRepo: verifying update for FreeBSD
DBG(1)[4691]> Pkgrepo, begin incremental update of '/var/db/pkg/repo-FreeBSD.sqlite'
DBG(1)[4691]> Fetch: fetching from: http://pkgmir.pkg.freebsd.org/freebsd:10:x86:64/latest/meta.txz
pkg: http://pkg.FreeBSD.org/freebsd:10:x86:64/latest/meta.txz: Not Found
pkg: repository FreeBSD has no meta file, using default settings
DBG(1)[4691]> Fetch: fetching from: http://pkgmir.pkg.freebsd.org/freebsd:10:x86:64/latest/digests.txz
DBG(4)[4691]> Pkgdb: running 'PRAGMA user_version;'
DBG(4)[4691]> Pkgdb: executing 'PRAGMA foreign_keys = ON;'
DBG(4)[4691]> Pkgdb: running 'SELECT count(name) FROM sqlite_master WHERE type='table' AND name='repodata';'
DBG(4)[4691]> Pkgdb: running 'select count(key) from repodata WHERE key = "packagesite" and value = 'pkg+http://pkg.FreeBSD.org/freebsd:10:x86:64/latest''
DBG(4)[4691]> Pkgdb: executing 'PRAGMA synchronous=default'
DBG(4)[4691]> Pkgdb: executing 'PRAGMA foreign_keys=on'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO mtree(content) VALUES(?1)'
DBG(4)[4691]> 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) VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, (SELECT id FROM mtree WHERE content = ?14), NOW(), ?15)'
DBG(4)[4691]> Pkgdb: preparing statement 'UPDATE deps SET name=?1, version=?2 WHERE origin=?3;'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO deps (origin, name, version, package_id) VALUES (?1, ?2, ?3, ?4)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR REPLACE INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO directories(path) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_directories(package_id, directory_id, try) VALUES (?1, (SELECT id FROM directories WHERE path = ?2), ?3)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO categories(name) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_categories(package_id, category_id) VALUES (?1, (SELECT id FROM categories WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO licenses(name) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_licenses(package_id, license_id) VALUES (?1, (SELECT id FROM licenses WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO users(name) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_users(package_id, user_id) VALUES (?1, (SELECT id FROM users WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO groups(name) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_groups(package_id, group_id) VALUES (?1, (SELECT id FROM groups WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO script(script) VALUES (?1)'
DBG(4)[4691]> 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)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO option (option) VALUES (?1)'
DBG(4)[4691]> 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)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO shlibs(name) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_shlibs_required(package_id, shlib_id) VALUES (?1, (SELECT id FROM shlibs WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_shlibs_provided(package_id, shlib_id) VALUES (?1, (SELECT id FROM shlibs WHERE name = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO annotation(annotation) VALUES (?1)'
DBG(4)[4691]> 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)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO pkg_annotation(package_id, tag_id, value_id) VALUES ( (SELECT id FROM packages WHERE name || '~' || origin = ?1 ), (SELECT annotation_id FROM annotation WHERE annotation = ?2), (SELECT annotation_id FROM annotation WHERE annotation = ?3))'
DBG(4)[4691]> Pkgdb: preparing statement 'DELETE FROM pkg_annotation WHERE package_id IN (SELECT id FROM packages WHERE name || '~' || origin = ?1) AND tag_id IN (SELECT annotation_id FROM annotation WHERE annotation = ?2)'
DBG(4)[4691]> 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)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_conflicts(package_id, conflict_id) VALUES (?1, (SELECT id FROM packages WHERE name || '~' || origin = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT INTO pkg_provides(package_id, provide_id) VALUES (?1, (SELECT id FROM provides WHERE provide = ?2))'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO provides(provide) VALUES(?1)'
DBG(4)[4691]> Pkgdb: preparing statement 'INSERT OR ROLLBACK INTO pkg_search(id, name, origin) VALUES (?1, ?2 || '-' || ?3, ?4);'
DBG(4)[4691]> Pkgdb: preparing statement 'UPDATE packages SET manifestdigest=?1 WHERE id=?2;'
DBG(1)[4691]> want to get an advisory lock on a database
DBG(4)[4691]> Pkgdb: running 'SELECT id, origin, name, name || '~' || origin as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest FROM packages AS p WHERE manifestdigest IS NULL OR manifestdigest=='' ORDER BY p.name;'
DBG(4)[4691]> Pkgdb: executing 'PRAGMA synchronous = OFF;PRAGMA journal_mode = MEMORY;BEGIN TRANSACTION;'
DBG(4)[4691]> Pkgdb: running 'SELECT id, origin, name, name || '~' || origin as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest FROM packages AS p WHERE name = SPLIT_UID('name', ?1) COLLATE NOCASE AND origin = SPLIT_UID('origin', ?1) COLLATE NOCASE ORDER BY p.name;'
DBG(4)[4691]> Pkgdb: running 'SELECT id, origin, name, name || '~' || origin as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest FROM packages AS p WHERE name = SPLIT_UID('name', ?1) COLLATE NOCASE AND origin = SPLIT_UID('origin', ?1) COLLATE NOCASE ORDER BY p.name;'
DBG(4)[4691]> Pkgdb: running 'SELECT id, origin, name, name || '~' || origin as uniqueid, version, comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD' AS dbname FROM packages WHERE name = ?1 COLLATE NOCASE OR (name = SPLIT_VERSION('name', ?1) COLLATE NOCASE AND  version = SPLIT_VERSION('version', ?1)) ORDER BY name;' query for pkgconf
DBG(4)[4691]> Pkgdb: running 'SELECT d.name, d.origin, d.version, 0 FROM main.deps AS d LEFT JOIN main.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)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb: running 'SELECT option, value FROM 'main'.option JOIN 'main'.pkg_option USING(option_id) WHERE package_id = ?1 ORDER BY option'
DBG(4)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb: running 'SELECT name FROM 'main'.pkg_shlibs_required, 'main'.shlibs AS s WHERE package_id = ?1 AND shlib_id = s.id ORDER by name DESC'
DBG(4)[4691]> Pkgdb: running 'SELECT name FROM 'main'.pkg_shlibs_provided, 'main'.shlibs AS s WHERE package_id = ?1 AND shlib_id = s.id ORDER by name DESC'
DBG(4)[4691]> Pkgdb: running 'SELECT k.annotation AS tag, v.annotation AS value  FROM 'main'.pkg_annotation p    JOIN 'main'.annotation k ON (p.tag_id = k.annotation_id)    JOIN 'main'.annotation v ON (p.value_id = v.annotation_id)  WHERE p.package_id = ?1  ORDER BY tag, value'
DBG(4)[4691]> Pkgdb: running 'SELECT packages.origin FROM 'main'.pkg_conflicts LEFT JOIN 'main'.packages ON packages.id = pkg_conflicts.conflict_id WHERE package_id = ?1'
DBG(4)[4691]> Pkgdb: running 'SELECT id, origin, name, name || '~' || origin as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest FROM packages AS p WHERE name = SPLIT_UID('name', ?1) COLLATE NOCASE AND origin = SPLIT_UID('origin', ?1) COLLATE NOCASE ORDER BY p.name;'
DBG(4)[4691]> Pkgdb: running 'SELECT d.name, d.origin, d.version, 0 FROM main.deps AS d LEFT JOIN main.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)[4691]> Pkgdb: running 'SELECT p.name, p.origin, p.version, 0 FROM main.packages AS p INNER JOIN main.deps AS d ON p.id = d.package_id WHERE d.name = SPLIT_UID('name', ?1) AND d.origin = SPLIT_UID('origin', ?1);'
DBG(4)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb: running 'SELECT option, value FROM 'main'.option JOIN 'main'.pkg_option USING(option_id) WHERE package_id = ?1 ORDER BY option'
DBG(4)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb> adding option
DBG(4)[4691]> Pkgdb: running 'SELECT name FROM 'main'.pkg_shlibs_required, 'main'.shlibs AS s WHERE package_id = ?1 AND shlib_id = s.id ORDER by name DESC'
DBG(4)[4691]> Pkgdb: running 'SELECT k.annotation AS tag, v.annotation AS value  FROM 'main'.pkg_annotation p    JOIN 'main'.annotation k ON (p.tag_id = k.annotation_id)    JOIN 'main'.annotation v ON (p.value_id = v.annotation_id)  WHERE p.package_id = ?1  ORDER BY tag, value'
DBG(4)[4691]> Pkgdb: running 'SELECT packages.origin FROM 'main'.pkg_conflicts LEFT JOIN 'main'.packages ON packages.id = pkg_conflicts.conflict_id WHERE package_id = ?1'
DBG(2)[4691]> universe: add new local pkg: pkgconf~devel/pkgconf, (pkgconf-0.9.6:1$0$taipyim7auxeq3xap6hgci39bu8h4p86o9uuinrqm7mr5k8npzib)
DBG(4)[4691]> solver: add variable from universe with uid pkgconf~devel/pkgconf
DBG(1)[4691]> problem has no requests
DBG(4)[4691]> Pkgdb: executing 'END TRANSACTION;PRAGMA synchronous = NORMAL;PRAGMA journal_mode = DELETE;'
DBG(4)[4691]> jobs: running 'UPDATE packages SET name=SPLIT_UID('name', ?1), origin=SPLIT_UID('origin', ?1) WHERE name=SPLIT_UID('name', ?2) AND origin=SPLIT_UID('origin', ?2);'
DBG(1)[4691]> release an advisory lock on a database