Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mapping Errors #11

Open
sgoggins opened this issue Sep 25, 2020 · 5 comments
Open

Mapping Errors #11

sgoggins opened this issue Sep 25, 2020 · 5 comments
Assignees
@Nebrethar
Labels
bug Something isn't working help wanted Extra attention is needed

Comments

@sgoggins
Copy link
Member 

(augur-spdx) sean@facetrust:~/github/augur-spdx$ cat spdx-howison.log
.....
<subprocess.Popen object at 0x7f0d77a5a4f0>
RECORD CREATED
('github.com/', 25446, 25155, 'thomasfmiller')
****************
25446
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/', 25455, 25155, 'lapps')
****************
25455
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/', 25498, 25155, 'BiG-CZ')
****************
25498
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/PRUNERS/', 25464, 25155, 'archer')
****************
25464
****************
github.com/PRUNERS/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer' = repo_path;
ALL CHECKS PASSED
Creating Record for 25464
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113783, null, ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e, null, 101, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113783, null, ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e, null, 101, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e\', \'copyright_text\': None, \'package_id\': 101, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a220>
RECORD CREATED
('github.com/GOMC-WSU/', 25466, 25155, 'GOMC')
****************
25466
****************
github.com/GOMC-WSU/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/GOMC-WSU/GOMC
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/GOMC-WSU/GOMC']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/GOMC-WSU/GOMC
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/GOMC-WSU/GOMC' = repo_path;
ALL CHECKS PASSED
Creating Record for 25466
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/GOMC-WSU/GOMC
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113784, null, 2117590c0180bbab978cc870f2e1e9da75c1d82dcb95926943ebd53d8797c02e, null, 102, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113784, null, 2117590c0180bbab978cc870f2e1e9da75c1d82dcb95926943ebd53d8797c02e, null, 102, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'2117590c0180bbab978cc870f2e1e9da75c1d82dcb95926943ebd53d8797c02e\', \'copyright_text\': None, \'package_id\': 102, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a430>
RECORD CREATED
('github.com/mosdef-hub/', 25431, 25155, 'mbuild')
****************
25431
****************
github.com/mosdef-hub/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/mosdef-hub/mbuild
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/mosdef-hub/mbuild']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/mosdef-hub/mbuild
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/mosdef-hub/mbuild' = repo_path;
ALL CHECKS PASSED
Creating Record for 25431
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/mosdef-hub/mbuild
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113785, null, 1dd5218a578e8d620e10790de47bbd221e5842c2de4cb0d7fa03588a472e977d, null, 103, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113785, null, 1dd5218a578e8d620e10790de47bbd221e5842c2de4cb0d7fa03588a472e977d, null, 103, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'1dd5218a578e8d620e10790de47bbd221e5842c2de4cb0d7fa03588a472e977d\', \'copyright_text\': None, \'package_id\': 103, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2e0>
RECORD CREATED
('github.com/Paradigm4/', 25432, 25155, 'SciDB')
****************
25432
****************
github.com/Paradigm4/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/Paradigm4/SciDB
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/Paradigm4/SciDB']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/Paradigm4/SciDB
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/Paradigm4/SciDB' = repo_path;
ALL CHECKS PASSED
Creating Record for 25432
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/Paradigm4/SciDB
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113786, null, 7b7468242a470b463292ab01ba4ec1b03a0d110d24609f5f83b64291ed13875b, null, 104, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113786, null, 7b7468242a470b463292ab01ba4ec1b03a0d110d24609f5f83b64291ed13875b, null, 104, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'7b7468242a470b463292ab01ba4ec1b03a0d110d24609f5f83b64291ed13875b\', \'copyright_text\': None, \'package_id\': 104, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a130>
RECORD CREATED
('github.com/SimVascular/', 25521, 25155, 'SimVascular')
****************
25521
****************
github.com/SimVascular/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/SimVascular
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/SimVascular']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/SimVascular
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/SimVascular' = repo_path;
ALL CHECKS PASSED
Creating Record for 25521
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/SimVascular
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113787, null, 987d158c2b331ba29e684b36693e5dbbb410ea1cca2ac815b90724359750cacb, null, 105, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113787, null, 987d158c2b331ba29e684b36693e5dbbb410ea1cca2ac815b90724359750cacb, null, 105, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'987d158c2b331ba29e684b36693e5dbbb410ea1cca2ac815b90724359750cacb\', \'copyright_text\': None, \'package_id\': 105, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a250>
RECORD CREATED
('icl.cs.utk.edu/svn/scalapack-dev/scalapack/', 25495, 25155, 'trunk')
****************
25495
****************
icl.cs.utk.edu/svn/scalapack-dev/scalapack/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/', 25515, 25155, 'diana-hep')
****************
25515
****************
github.com/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/diana-hep
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/diana-hep']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/diana-hep
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/diana-hep' = repo_path;
ALL CHECKS PASSED
Creating Record for 25515
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/diana-hep
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113788, null, 0a0621b57ddd77bf6847c1fff001a8f995a50b9af46f4021add6fc297018e74b, null, 106, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113788, null, 0a0621b57ddd77bf6847c1fff001a8f995a50b9af46f4021add6fc297018e74b, null, 106, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'0a0621b57ddd77bf6847c1fff001a8f995a50b9af46f4021add6fc297018e74b\', \'copyright_text\': None, \'package_id\': 106, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a610>
RECORD CREATED
('github.com/Geof23/', 25465, 25155, 'Gklee')
****************
25465
****************
github.com/Geof23/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee' = repo_path;
ALL CHECKS PASSED
Creating Record for 25465
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113789, null, 9ded1d035e08a5fef412d627f5760e76c028d442b346659c5d6973d1584cd15e, null, 107, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113789, null, 9ded1d035e08a5fef412d627f5760e76c028d442b346659c5d6973d1584cd15e, null, 107, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'9ded1d035e08a5fef412d627f5760e76c028d442b346659c5d6973d1584cd15e\', \'copyright_text\': None, \'package_id\': 107, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a460>
RECORD CREATED
('github.com/CrawfordGroup/', 25453, 25155, 'panache')
****************
25453
****************
github.com/CrawfordGroup/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/CrawfordGroup/panache
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/CrawfordGroup/panache']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/CrawfordGroup/panache
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/CrawfordGroup/panache' = repo_path;
ALL CHECKS PASSED
Creating Record for 25453
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/CrawfordGroup/panache
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113790, null, c85f41a09ff5a89fb05e9a1d9128aaa9c140474a5864824227fb55a04be01724, null, 108, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113790, null, c85f41a09ff5a89fb05e9a1d9128aaa9c140474a5864824227fb55a04be01724, null, 108, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c85f41a09ff5a89fb05e9a1d9128aaa9c140474a5864824227fb55a04be01724\', \'copyright_text\': None, \'package_id\': 108, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2b0>
RECORD CREATED
('github.com/wkbjerry/', 25452, 25155, 'ulcc')
****************
25452
****************
github.com/wkbjerry/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc' = repo_path;
ALL CHECKS PASSED
Creating Record for 25452
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113791, null, c361c07fa929c1d448b7eaf7f06cba77fc3e8a0e27612328a074ff04e748c8bb, null, 109, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113791, null, c361c07fa929c1d448b7eaf7f06cba77fc3e8a0e27612328a074ff04e748c8bb, null, 109, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c361c07fa929c1d448b7eaf7f06cba77fc3e8a0e27612328a074ff04e748c8bb\', \'copyright_text\': None, \'package_id\': 109, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a580>
RECORD CREATED
('github.com/pegasus-isi/', 25483, 25155, 'pegasus')
****************
25483
****************
github.com/pegasus-isi/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus' = repo_path;
ALL CHECKS PASSED
Creating Record for 25483
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113792, null, a2b529d463a04aaef925dd2f3a04cf023223674fa7e34737b45d23ec86fb5c9a, null, 110, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113792, null, a2b529d463a04aaef925dd2f3a04cf023223674fa7e34737b45d23ec86fb5c9a, null, 110, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'a2b529d463a04aaef925dd2f3a04cf023223674fa7e34737b45d23ec86fb5c9a\', \'copyright_text\': None, \'package_id\': 110, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a1f0>
RECORD CREATED
('github.com/ornladios/', 25486, 25155, 'ADIOS')
****************
25486
****************
github.com/ornladios/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS' = repo_path;
ALL CHECKS PASSED
Creating Record for 25486
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113793, null, 79774c8904fc161277d8d66e67b217a312af7cff8a42eef3a3af5ba7d01d6c82, null, 111, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113793, null, 79774c8904fc161277d8d66e67b217a312af7cff8a42eef3a3af5ba7d01d6c82, null, 111, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'79774c8904fc161277d8d66e67b217a312af7cff8a42eef3a3af5ba7d01d6c82\', \'copyright_text\': None, \'package_id\': 111, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a430>
RECORD CREATED
('charm.cs.illinois.edu/gerrit/', 25496, 25155, 'gitweb?p=openatom')
****************
25496
****************
charm.cs.illinois.edu/gerrit/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('bitbucket.org/yt_analysis/', 25519, 25155, 'yt')
****************
25519
****************
bitbucket.org/yt_analysis/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/yt-project/yt
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/yt-project/yt']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/yt-project/yt
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/yt-project/yt' = repo_path;
ALL CHECKS PASSED
Creating Record for 25519
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/yt-project/yt
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113794, null, 8f9fb5fe9ff531329f387fefd91f12e400450aa73140bb3fb30cd27b963808a3, null, 112, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113794, null, 8f9fb5fe9ff531329f387fefd91f12e400450aa73140bb3fb30cd27b963808a3, null, 112, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'8f9fb5fe9ff531329f387fefd91f12e400450aa73140bb3fb30cd27b963808a3\', \'copyright_text\': None, \'package_id\': 112, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a340>
RECORD CREATED
('sourceforge.net/projects/', 25499, 25155, 'benchlab')
****************
25499
****************
sourceforge.net/projects/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('git-wip-us.apache.org/repos/', 25501, 25155, 'asf?p=airavata')
****************
25501
****************
git-wip-us.apache.org/repos/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/dealii/', 25457, 25155, 'dealii')
****************
25457
****************
github.com/dealii/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/dealii
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/dealii']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/dealii
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/dealii' = repo_path;
ALL CHECKS PASSED
Creating Record for 25457
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/dealii
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113795, null, c54c97021ddab19f368a71af202e937055d6d0e7ecb56ab04fa5a6b02efc8750, null, 113, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113795, null, c54c97021ddab19f368a71af202e937055d6d0e7ecb56ab04fa5a6b02efc8750, null, 113, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c54c97021ddab19f368a71af202e937055d6d0e7ecb56ab04fa5a6b02efc8750\', \'copyright_text\': None, \'package_id\': 113, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a250>
RECORD CREATED
('github.com/hpgeoc/', 25478, 25155, 'awp-odc-os')
****************
25478
****************
github.com/hpgeoc/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/hpgeoc/awp-odc-os
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/hpgeoc/awp-odc-os']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/hpgeoc/awp-odc-os
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/hpgeoc/awp-odc-os' = repo_path;
ALL CHECKS PASSED
Creating Record for 25478
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/hpgeoc/awp-odc-os
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113796, null, a31f558cfa827aa3f670f27651307427b3bd1cac961db9d0f9bbd5797e757703, null, 114, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113796, null, a31f558cfa827aa3f670f27651307427b3bd1cac961db9d0f9bbd5797e757703, null, 114, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'a31f558cfa827aa3f670f27651307427b3bd1cac961db9d0f9bbd5797e757703\', \'copyright_text\': None, \'package_id\': 114, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a490>
RECORD CREATED
('github.com/PRUNERS/', 25462, 25155, 'FLiT')
****************
25462
****************
github.com/PRUNERS/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/FLiT
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/PRUNERS/FLiT']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/FLiT
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/PRUNERS/FLiT' = repo_path;
ALL CHECKS PASSED
Creating Record for 25462
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/PRUNERS/FLiT
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113797, null, 24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a, null, 115, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113797, null, 24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a, null, 115, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a\', \'copyright_text\': None, \'package_id\': 115, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a4f0>
RECORD CREATED
('github.com/', 25449, 25155, 'LabAdvComp')
****************
25449
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/', 25514, 25155, 'scikit-hep')
****************
25514
****************
github.com/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/scikit-hep
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/scikit-hep']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/scikit-hep
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/scikit-hep' = repo_path;
ALL CHECKS PASSED
Creating Record for 25514
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/scikit-hep
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113798, null, d7a52d1b0b4a7fc98ffd623bec9d4e2fd31e5a5d9d53f627c78b0ecda15087f6, null, 116, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113798, null, d7a52d1b0b4a7fc98ffd623bec9d4e2fd31e5a5d9d53f627c78b0ecda15087f6, null, 116, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'d7a52d1b0b4a7fc98ffd623bec9d4e2fd31e5a5d9d53f627c78b0ecda15087f6\', \'copyright_text\': None, \'package_id\': 116, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a3d0>
RECORD CREATED
('github.com/', 25490, 25155, 'ipop-project')
****************
25490
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/PRUNERS/', 25460, 25155, 'archer-1')
****************
25460
****************
github.com/PRUNERS/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer-1
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer-1']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer-1
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer-1' = repo_path;
ALL CHECKS PASSED
Creating Record for 25460
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/PRUNERS/archer-1
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113799, null, ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e, null, 117, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113799, null, ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e, null, 117, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e\', \'copyright_text\': None, \'package_id\': 117, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a130>
RECORD CREATED
('github.com/melt-umn/', 25437, 25155, 'silver')
****************
25437
****************
github.com/melt-umn/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1/grammars/silver
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/melt-umn/silver
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1/grammars/silver', '/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1/grammars/silver
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1/grammars/silver' = repo_path;
ALL CHECKS PASSED
Creating Record for 25437
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1/grammars/silver
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113800, null, 1bb77d9b40ca465de44ee39ee1ab1bc16c04ac5b9bf093434682aafd7b671f17, null, 118, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113800, null, 1bb77d9b40ca465de44ee39ee1ab1bc16c04ac5b9bf093434682aafd7b671f17, null, 118, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'1bb77d9b40ca465de44ee39ee1ab1bc16c04ac5b9bf093434682aafd7b671f17\', \'copyright_text\': None, \'package_id\': 118, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a250>
RECORD CREATED
('github.com/melt-umn/', 25436, 25155, 'silver-1')
****************
25436
****************
github.com/melt-umn/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1' = repo_path;
ALL CHECKS PASSED
Creating Record for 25436
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/melt-umn/silver-1
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113801, null, ee1d033930b5d0b743241925075cdc680918df5552eac219c070dad77678a66f, null, 119, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113801, null, ee1d033930b5d0b743241925075cdc680918df5552eac219c070dad77678a66f, null, 119, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'ee1d033930b5d0b743241925075cdc680918df5552eac219c070dad77678a66f\', \'copyright_text\': None, \'package_id\': 119, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a4c0>
RECORD CREATED
('github.com/wilseypa/', 25507, 25155, 'rphash-java')
****************
25507
****************
github.com/wilseypa/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-java
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-java']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-java
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-java' = repo_path;
ALL CHECKS PASSED
Creating Record for 25507
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-java
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113802, null, 4e931498889a3c4917011fc5d6f293481d3a67e0905951fdf6e3626554b179ba, null, 120, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113802, null, 4e931498889a3c4917011fc5d6f293481d3a67e0905951fdf6e3626554b179ba, null, 120, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'4e931498889a3c4917011fc5d6f293481d3a67e0905951fdf6e3626554b179ba\', \'copyright_text\': None, \'package_id\': 120, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a580>
RECORD CREATED
('github.com/wilseypa/', 25508, 25155, 'rphash-spark')
****************
25508
****************
github.com/wilseypa/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-spark
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-spark']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-spark
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-spark' = repo_path;
ALL CHECKS PASSED
Creating Record for 25508
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-spark
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113803, null, fbf7e7c2c75c1ce2f1b556ac28cd8073ff1dff9ed6d66897c40d821c2610cff6, null, 121, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113803, null, fbf7e7c2c75c1ce2f1b556ac28cd8073ff1dff9ed6d66897c40d821c2610cff6, null, 121, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'fbf7e7c2c75c1ce2f1b556ac28cd8073ff1dff9ed6d66897c40d821c2610cff6\', \'copyright_text\': None, \'package_id\': 121, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a520>
RECORD CREATED
('github.com/iModels/', 25517, 25155, 'ffci')
****************
25517
****************
github.com/iModels/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/iModels/ffci
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/iModels/ffci']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/iModels/ffci
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/iModels/ffci' = repo_path;
ALL CHECKS PASSED
Creating Record for 25517
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/iModels/ffci
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113804, null, cf6aef69a449a9d561d41315a61543d57ed5fa6604a12b24a978cb88378c3134, null, 122, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113804, null, cf6aef69a449a9d561d41315a61543d57ed5fa6604a12b24a978cb88378c3134, null, 122, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'cf6aef69a449a9d561d41315a61543d57ed5fa6604a12b24a978cb88378c3134\', \'copyright_text\': None, \'package_id\': 122, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a5e0>
RECORD CREATED
('github.com/yt-project/', 25520, 25155, 'yt')
****************
25520
****************
github.com/yt-project/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/yt-project/yt
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/yt-project/yt']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/yt-project/yt
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/yt-project/yt' = repo_path;
RECORD EXISTS IN MAP TABLE
('github.com/psi4/', 25454, 25155, 'psi4')
****************
25454
****************
github.com/psi4/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/psi4
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/psi4']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/psi4
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/psi4' = repo_path;
ALL CHECKS PASSED
Creating Record for 25454
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/psi4
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113805, null, c564ef5c2511b14c88dce0d217db9642eef4661a304e258ff74d7e71702029b8, null, 123, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113805, null, c564ef5c2511b14c88dce0d217db9642eef4661a304e258ff74d7e71702029b8, null, 123, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c564ef5c2511b14c88dce0d217db9642eef4661a304e258ff74d7e71702029b8\', \'copyright_text\': None, \'package_id\': 123, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2e0>
RECORD CREATED
('github.com/lattice/', 25447, 25155, 'quda')
****************
25447
****************
github.com/lattice/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/lattice/quda
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/lattice/quda']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/lattice/quda
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/lattice/quda' = repo_path;
ALL CHECKS PASSED
Creating Record for 25447
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/lattice/quda
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113806, null, 85477d93243065e14ef7cd4ddab1c93300ae974da74fd0c8a171608ded00d63b, null, 124, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113806, null, 85477d93243065e14ef7cd4ddab1c93300ae974da74fd0c8a171608ded00d63b, null, 124, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'85477d93243065e14ef7cd4ddab1c93300ae974da74fd0c8a171608ded00d63b\', \'copyright_text\': None, \'package_id\': 124, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2b0>
RECORD CREATED
('github.com/sagemath/', 25450, 25155, 'sage')
****************
25450
****************
github.com/sagemath/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/sagemath/sage
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/sagemath/sage']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/sagemath/sage
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/sagemath/sage' = repo_path;
ALL CHECKS PASSED
Creating Record for 25450
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/sagemath/sage
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113807, null, 96024d81e491e909803199bf604f629f9c1af5f26ed8fc572f17dc2efeab0f31, null, 125, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113807, null, 96024d81e491e909803199bf604f629f9c1af5f26ed8fc572f17dc2efeab0f31, null, 125, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'96024d81e491e909803199bf604f629f9c1af5f26ed8fc572f17dc2efeab0f31\', \'copyright_text\': None, \'package_id\': 125, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a460>
RECORD CREATED
('github.com/landlab/', 25451, 25155, 'landlab')
****************
25451
****************
github.com/landlab/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/landlab
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/landlab']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/landlab
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/landlab' = repo_path;
ALL CHECKS PASSED
Creating Record for 25451
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/landlab
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113808, null, c2b98ae4a07046b0f41fadbdd560f543e90834447a707df2875a827149dd7cd7, null, 126, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113808, null, c2b98ae4a07046b0f41fadbdd560f543e90834447a707df2875a827149dd7cd7, null, 126, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c2b98ae4a07046b0f41fadbdd560f543e90834447a707df2875a827149dd7cd7\', \'copyright_text\': None, \'package_id\': 126, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a550>
RECORD CREATED
('github.com/rocksclusters/', 25476, 25155, 'FingerPrint')
****************
25476
****************
github.com/rocksclusters/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/rocksclusters/FingerPrint
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/rocksclusters/FingerPrint']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/rocksclusters/FingerPrint
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/rocksclusters/FingerPrint' = repo_path;
ALL CHECKS PASSED
Creating Record for 25476
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/rocksclusters/FingerPrint
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113809, null, 6546e5d9700f889ee56a0eb7be1c850954468ec25fafcc34478b5728479d4c9a, null, 127, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113809, null, 6546e5d9700f889ee56a0eb7be1c850954468ec25fafcc34478b5728479d4c9a, null, 127, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'6546e5d9700f889ee56a0eb7be1c850954468ec25fafcc34478b5728479d4c9a\', \'copyright_text\': None, \'package_id\': 127, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a430>
RECORD CREATED
('github.com/oracle/', 25438, 25155, 'fastr')
****************
25438
****************
github.com/oracle/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/oracle/fastr
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/oracle/fastr']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/oracle/fastr
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/oracle/fastr' = repo_path;
ALL CHECKS PASSED
Creating Record for 25438
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/oracle/fastr
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113810, null, 4fa5ed65c18fc4519dd04471ab53678bba2e5e7fce8107bfc2f9f162d1525ebb, null, 128, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113810, null, 4fa5ed65c18fc4519dd04471ab53678bba2e5e7fce8107bfc2f9f162d1525ebb, null, 128, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'4fa5ed65c18fc4519dd04471ab53678bba2e5e7fce8107bfc2f9f162d1525ebb\', \'copyright_text\': None, \'package_id\': 128, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2e0>
RECORD CREATED
('git.eclipse.org/c/ptp/', 25435, 25155, 'org.eclipse.ptp')
****************
25435
****************
git.eclipse.org/c/ptp/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/cp2k/cp2k/', 25488, 25155, 'releases')
****************
25488
****************
github.com/cp2k/cp2k/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('r.cs.purdue.edu/', 25443, 25155, 'hg-1')
****************
25443
****************
r.cs.purdue.edu/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('github.com/ZimpleX/', 25491, 25155, 'cnn_auto_gen')
****************
25491
****************
github.com/ZimpleX/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/ZimpleX/cnn_auto_gen
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/ZimpleX/cnn_auto_gen']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/ZimpleX/cnn_auto_gen
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/ZimpleX/cnn_auto_gen' = repo_path;
ALL CHECKS PASSED
Creating Record for 25491
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/ZimpleX/cnn_auto_gen
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113811, null, 2ef287de744a887708822392ee6dab01472ffcf66a57dcf3d12c281b2ddeb9eb, null, 129, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113811, null, 2ef287de744a887708822392ee6dab01472ffcf66a57dcf3d12c281b2ddeb9eb, null, 129, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'2ef287de744a887708822392ee6dab01472ffcf66a57dcf3d12c281b2ddeb9eb\', \'copyright_text\': None, \'package_id\': 129, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a610>
RECORD CREATED
('github.com/wilseypa/', 25506, 25155, 'rphash-golang')
****************
25506
****************
github.com/wilseypa/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-golang
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-golang']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-golang
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-golang' = repo_path;
ALL CHECKS PASSED
Creating Record for 25506
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/wilseypa/rphash-golang
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113812, null, e4261f97f305d6bf733f0e6ecf715a8fa5a604b0cb4b8d271c03de46fdb1e4d9, null, 130, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113812, null, e4261f97f305d6bf733f0e6ecf715a8fa5a604b0cb4b8d271c03de46fdb1e4d9, null, 130, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'e4261f97f305d6bf733f0e6ecf715a8fa5a604b0cb4b8d271c03de46fdb1e4d9\', \'copyright_text\': None, \'package_id\': 130, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a5b0>
RECORD CREATED
('github.com/henniggroup/', 25509, 25155, 'gasp')
****************
25509
****************
github.com/henniggroup/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/henniggroup/gasp
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/henniggroup/gasp']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/henniggroup/gasp
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/henniggroup/gasp' = repo_path;
ALL CHECKS PASSED
Creating Record for 25509
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/henniggroup/gasp
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113813, null, e740ead73655c0dab62384195d792d6fd0bba82aacfe197ea891ff649d958f9c, null, 131, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113813, null, e740ead73655c0dab62384195d792d6fd0bba82aacfe197ea891ff649d958f9c, null, 131, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'e740ead73655c0dab62384195d792d6fd0bba82aacfe197ea891ff649d958f9c\', \'copyright_text\': None, \'package_id\': 131, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a250>
RECORD CREATED
('github.com/cplusplus/', 25475, 25155, 'concepts-ts')
****************
25475
****************
github.com/cplusplus/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/cplusplus/concepts-ts
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/cplusplus/concepts-ts']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/cplusplus/concepts-ts
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/cplusplus/concepts-ts' = repo_path;
ALL CHECKS PASSED
Creating Record for 25475
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/cplusplus/concepts-ts
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113814, null, 725af895ef4e89eb439bd4c7bd58d714b71e14b8f0245adf20659a8bab42a301, null, 132, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113814, null, 725af895ef4e89eb439bd4c7bd58d714b71e14b8f0245adf20659a8bab42a301, null, 132, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'725af895ef4e89eb439bd4c7bd58d714b71e14b8f0245adf20659a8bab42a301\', \'copyright_text\': None, \'package_id\': 132, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a280>
RECORD CREATED
('github.com/linyufly/', 25445, 25155, 'CUDATracer')
****************
25445
****************
github.com/linyufly/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/linyufly/CUDATracer
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/linyufly/CUDATracer']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/linyufly/CUDATracer
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/linyufly/CUDATracer' = repo_path;
ALL CHECKS PASSED
Creating Record for 25445
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/linyufly/CUDATracer
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113815, null, 26227eff76818e109e5658fa6124a896820cefb8a4f428d883690cce35e211f7, null, 133, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113815, null, 26227eff76818e109e5658fa6124a896820cefb8a4f428d883690cce35e211f7, null, 133, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'26227eff76818e109e5658fa6124a896820cefb8a4f428d883690cce35e211f7\', \'copyright_text\': None, \'package_id\': 133, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a2e0>
RECORD CREATED
('bitbucket.org/OSDT/', 25473, 25155, 'open-source-dataturbine')
****************
25473
****************
bitbucket.org/OSDT/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('source.usc.edu/svn/', 25477, 25155, 'awp-odc')
****************
25477
****************
source.usc.edu/svn/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
('bitbucket.org/extasy-project/extasy-workflows/src/master/', 25489, 25155, 'doc')
****************
25489
****************
bitbucket.org/extasy-project/extasy-workflows/src/master/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/dealii/dealii/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/lattice/quda/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/cooperative-computing-lab/cctools/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/SCECcode/bbp/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/TITAN2D/titan2d/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/BOINC/boinc/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/BOINC/boinc-1/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/sagemath/sage/src/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/psi4/psi4/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/CMU-Quake/hercules/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/allr/timeR/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/trilinos/Trilinos/cmake/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/trilinos/Trilinos/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/UCLA-Plasma-Simulation-Group/OSHUN/1d2d_cpp/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/yt-project/yt/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/TACC/GraviT/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/RMGDFT/rmgdft/dftd3/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/RMGDFT/rmgdft/spglib/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/geodynamics/aspect/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc/doc
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee/doc
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/dealii/dealii/doc', '/home/sean/repos/augur-howison/25155/github.com/lattice/quda/doc', '/home/sean/repos/augur-howison/25155/github.com/cooperative-computing-lab/cctools/doc', '/home/sean/repos/augur-howison/25155/github.com/ornladios/ADIOS/doc', '/home/sean/repos/augur-howison/25155/github.com/SCECcode/bbp/doc', '/home/sean/repos/augur-howison/25155/github.com/pegasus-isi/pegasus/doc', '/home/sean/repos/augur-howison/25155/github.com/TITAN2D/titan2d/doc', '/home/sean/repos/augur-howison/25155/github.com/BOINC/boinc/doc', '/home/sean/repos/augur-howison/25155/github.com/BOINC/boinc-1/doc', '/home/sean/repos/augur-howison/25155/github.com/sagemath/sage/src/doc', '/home/sean/repos/augur-howison/25155/github.com/psi4/psi4/doc', '/home/sean/repos/augur-howison/25155/github.com/CMU-Quake/hercules/doc', '/home/sean/repos/augur-howison/25155/github.com/allr/timeR/doc', '/home/sean/repos/augur-howison/25155/github.com/trilinos/Trilinos/cmake/doc', '/home/sean/repos/augur-howison/25155/github.com/trilinos/Trilinos/doc', '/home/sean/repos/augur-howison/25155/github.com/UCLA-Plasma-Simulation-Group/OSHUN/1d2d_cpp/doc', '/home/sean/repos/augur-howison/25155/github.com/yt-project/yt/doc', '/home/sean/repos/augur-howison/25155/github.com/wkbjerry/ulcc/doc', '/home/sean/repos/augur-howison/25155/github.com/TACC/GraviT/doc', '/home/sean/repos/augur-howison/25155/github.com/RMGDFT/rmgdft/dftd3/doc', '/home/sean/repos/augur-howison/25155/github.com/RMGDFT/rmgdft/spglib/doc', '/home/sean/repos/augur-howison/25155/github.com/geodynamics/aspect/doc', '/home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc/doc', '/home/sean/repos/augur-howison/25155/github.com/Geof23/Gklee/doc']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/dealii/dealii/doc
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/dealii/dealii/doc' = repo_path;
ALL CHECKS PASSED
Creating Record for 25489
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/dealii/dealii/doc
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113816, null, bb29ee05030e56b3369435d32f19c74507b0a99113e6879ce85182feafeb5196, null, 134, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113816, null, bb29ee05030e56b3369435d32f19c74507b0a99113e6879ce85182feafeb5196, null, 134, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'bb29ee05030e56b3369435d32f19c74507b0a99113e6879ce85182feafeb5196\', \'copyright_text\': None, \'package_id\': 134, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a430>
RECORD CREATED
('bitbucket.org/chemora/', 25487, 25155, 'chemoracode')
****************
25487
****************
bitbucket.org/chemora/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/bitbucket.org/chemora/chemoracode
INSIDE: ['/home/sean/repos/augur-howison/25155/bitbucket.org/chemora/chemoracode']
---------------
PATH: /home/sean/repos/augur-howison/25155/bitbucket.org/chemora/chemoracode
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/bitbucket.org/chemora/chemoracode' = repo_path;
ALL CHECKS PASSED
Creating Record for 25487
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/bitbucket.org/chemora/chemoracode
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113817, null, eaf57fb2bcc23882edbacce662b968ccde369465e470dfe44753844613e49578, null, 135, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113817, null, eaf57fb2bcc23882edbacce662b968ccde369465e470dfe44753844613e49578, null, 135, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'eaf57fb2bcc23882edbacce662b968ccde369465e470dfe44753844613e49578\', \'copyright_text\': None, \'package_id\': 135, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a5b0>
RECORD CREATED
('github.com/BOINC/', 25484, 25155, 'boinc')
****************
25484
****************
github.com/BOINC/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/BOINC/boinc
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/BOINC/boinc']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/BOINC/boinc
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/BOINC/boinc' = repo_path;
ALL CHECKS PASSED
Creating Record for 25484
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/BOINC/boinc
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113818, null, 29c03b9efc50a7bb33dbfa7d665bc7ae4e3e3d3d278dc82a44e5dbba645d183f, null, 136, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113818, null, 29c03b9efc50a7bb33dbfa7d665bc7ae4e3e3d3d278dc82a44e5dbba645d183f, null, 136, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'29c03b9efc50a7bb33dbfa7d665bc7ae4e3e3d3d278dc82a44e5dbba645d183f\', \'copyright_text\': None, \'package_id\': 136, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a3a0>
RECORD CREATED
('github.com/SCECcode/', 25481, 25155, 'UCVMC')
****************
25481
****************
github.com/SCECcode/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/SCECcode/UCVMC
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/SCECcode/UCVMC']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/SCECcode/UCVMC
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/SCECcode/UCVMC' = repo_path;
ALL CHECKS PASSED
Creating Record for 25481
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/SCECcode/UCVMC
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113819, null, 4e058efe048fbc8286e96febb8b7271bcfe67d82fb4b958b1946272d368531de, null, 137, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113819, null, 4e058efe048fbc8286e96febb8b7271bcfe67d82fb4b958b1946272d368531de, null, 137, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'4e058efe048fbc8286e96febb8b7271bcfe67d82fb4b958b1946272d368531de\', \'copyright_text\': None, \'package_id\': 137, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a610>
RECORD CREATED
('github.com/phys-tools/', 25482, 25155, 'pi-qmc')
****************
25482
****************
github.com/phys-tools/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc' = repo_path;
ALL CHECKS PASSED
Creating Record for 25482
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/phys-tools/pi-qmc
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113820, null, c6e786112288b93dfa9fed611ca2ce3cfda113244467bf255ff97a3ec884e915, null, 138, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113820, null, c6e786112288b93dfa9fed611ca2ce3cfda113244467bf255ff97a3ec884e915, null, 138, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'c6e786112288b93dfa9fed611ca2ce3cfda113244467bf255ff97a3ec884e915\', \'copyright_text\': None, \'package_id\': 138, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a580>
RECORD CREATED
('github.com/', 25461, 25155, 'PRUNERS')
****************
25461
****************
github.com/
---------------
FOLDER FOUND: /home/sean/repos/augur-howison/25155/github.com/PRUNERS
INSIDE: ['/home/sean/repos/augur-howison/25155/github.com/PRUNERS']
---------------
PATH: /home/sean/repos/augur-howison/25155/github.com/PRUNERS
SELECT repo_path FROM spdx.augur_repo_map WHERE '/home/sean/repos/augur-howison/25155/github.com/PRUNERS' = repo_path;
ALL CHECKS PASSED
Creating Record for 25461
CREATING NEW DOSOCS DOCUMENT
/home/sean/repos/augur-howison/25155/github.com/PRUNERS
(b'sqlite\n', b'Traceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113821, null, 24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a, null, 139, , ).\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File "/home/sean/github/virtualenvs/augur-spdx/bin/dosocs2", line 8, in <module>\n    sys.exit(main())\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 312, in main\n    do_scan(**kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/dosocs2.py", line 127, in do_scan\n    package = spdxdb.register_package(conn, **kwargs)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 143, in register_package\n    fileobj = register_file(conn, file_path,  package[\'package_id\'], known_sha256=file_sha256)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 79, in register_file\n    file[\'file_id\'] = insert(conn, db.files, file)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/dosocs2/spdxdb.py", line 31, in insert\n    result = conn.execute(query)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute\n    return meth(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement\n    ret = self._execute_context(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context\n    self._handle_dbapi_exception(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception\n    util.raise_(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_\n    raise exception\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context\n    self.dialect.do_execute(\n  File "/home/sean/github/virtualenvs/augur-spdx/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute\n    cursor.execute(statement, parameters)\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "file_type_id" violates not-null constraint\nDETAIL:  Failing row contains (113821, null, 24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a, null, 139, , ).\n\n[SQL: INSERT INTO files (file_type_id, sha256, copyright_text, package_id, comment, notice) VALUES (%(file_type_id)s, %(sha256)s, %(copyright_text)s, %(package_id)s, %(comment)s, %(notice)s) RETURNING files.file_id]\n[parameters: {\'file_type_id\': None, \'sha256\': \'24793dae6b06932afe17a6220b47c8bd9bab10c29982bc47c394ba59030fda7a\', \'copyright_text\': None, \'package_id\': 139, \'comment\': \'\', \'notice\': \'\'}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)\n')
####################
<subprocess.Popen object at 0x7f0d77a5a550>
RECORD CREATED
('github.com/', 25463, 25155, 'PRUNERS-1')
****************
25463
****************
github.com/
---------------
INSIDE: []
---------------
NO DIRECTORY, SKIPPING
------------------
SBOM SCANS RUNNING
------------------
********************
('github.com/BOINC/', 25448, 25155, 'boinc-1')
****************
25448
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/allr/', 25441, 25155, 'timeR')
****************
25441
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/UCLA-Plasma-Simulation-Group/', 25504, 25155, 'QuickPIC-OpenSource')
****************
25504
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('r.cs.purdue.edu/', 25440, 25155, 'hg')
****************
25440
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/SCIInstitute/', 25467, 25155, 'SCI-Solver_FEM')
****************
25467
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/flame/', 25459, 25155, 'libflame')
****************
25459
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/mosdef-hub/', 25518, 25155, 'foyer-1')
****************
25518
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/trilinos/', 25458, 25155, 'Trilinos')
****************
25458
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/cycronix/', 25472, 25155, 'dataturbine')
****************
25472
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/cooperative-computing-lab/', 25468, 25155, 'cctools')
****************
25468
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/swift-lang/', 25470, 25155, 'swift-k')
****************
25470
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/OpenMP/', 25456, 25155, 'sources')
****************
25456
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/SCECcode/', 25479, 25155, 'bbp')
****************
25479
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/CMU-Quake/', 25480, 25155, 'hercules')
****************
25480
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/TITAN2D/', 25493, 25155, 'titan2d')
****************
25493
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/Reference-LAPACK/', 25494, 25155, 'lapack')
****************
25494
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/RMGDFT/', 25500, 25155, 'rmgdft')
****************
25500
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/TACC/', 25502, 25155, 'GraviT')
****************
25502
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/UCLA-Plasma-Simulation-Group/', 25503, 25155, 'OSHUN')
****************
25503
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/wilseypa/', 25505, 25155, 'rphash')
****************
25505
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/SRI-CSL/', 25510, 25155, 'OCCAM')
****************
25510
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/geodynamics/', 25511, 25155, 'aspect')
****************
25511
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/diana-hep/', 25512, 25155, 'carl')
****************
25512
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/cplusplus/', 25474, 25155, 'draft')
****************
25474
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('r.cs.purdue.edu/', 25442, 25155, 'hg-1')
****************
25442
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/mosdef-hub/', 25430, 25155, 'foyer')
****************
25430
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/allr/', 25444, 25155, 'tracer')
****************
25444
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/allr/', 25439, 25155, 'purdue-fastr')
****************
25439
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/scifio/', 25469, 25155, 'scifio')
****************
25469
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/sanshar/', 25485, 25155, 'Block')
****************
25485
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/diana-hep/', 25513, 25155, 'oamap')
****************
25513
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/scikit-hep/', 25516, 25155, 'uproot')
****************
25516
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25471, 25155, 'hydroshare')
****************
25471
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25433, 25155, 'Paradigm4')
****************
25433
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25434, 25155, 'paradigm4')
****************
25434
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/geoscience-community-codes/', 25492, 25155, 'tephra2')
****************
25492
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/open-mpi/', 25497, 25155, 'ompi')
****************
25497
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25446, 25155, 'thomasfmiller')
****************
25446
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25455, 25155, 'lapps')
****************
25455
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25498, 25155, 'BiG-CZ')
****************
25498
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/PRUNERS/', 25464, 25155, 'archer')
****************
25464
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/GOMC-WSU/', 25466, 25155, 'GOMC')
****************
25466
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/mosdef-hub/', 25431, 25155, 'mbuild')
****************
25431
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/Paradigm4/', 25432, 25155, 'SciDB')
****************
25432
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/SimVascular/', 25521, 25155, 'SimVascular')
****************
25521
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('icl.cs.utk.edu/svn/scalapack-dev/scalapack/', 25495, 25155, 'trunk')
****************
25495
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25515, 25155, 'diana-hep')
****************
25515
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/Geof23/', 25465, 25155, 'Gklee')
****************
25465
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/CrawfordGroup/', 25453, 25155, 'panache')
****************
25453
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/wkbjerry/', 25452, 25155, 'ulcc')
****************
25452
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/pegasus-isi/', 25483, 25155, 'pegasus')
****************
25483
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/ornladios/', 25486, 25155, 'ADIOS')
****************
25486
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('charm.cs.illinois.edu/gerrit/', 25496, 25155, 'gitweb?p=openatom')
****************
25496
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('bitbucket.org/yt_analysis/', 25519, 25155, 'yt')
****************
25519
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('sourceforge.net/projects/', 25499, 25155, 'benchlab')
****************
25499
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('git-wip-us.apache.org/repos/', 25501, 25155, 'asf?p=airavata')
****************
25501
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/dealii/', 25457, 25155, 'dealii')
****************
25457
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/hpgeoc/', 25478, 25155, 'awp-odc-os')
****************
25478
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/PRUNERS/', 25462, 25155, 'FLiT')
****************
25462
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25449, 25155, 'LabAdvComp')
****************
25449
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25514, 25155, 'scikit-hep')
****************
25514
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25490, 25155, 'ipop-project')
****************
25490
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/PRUNERS/', 25460, 25155, 'archer-1')
****************
25460
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/melt-umn/', 25437, 25155, 'silver')
****************
25437
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/melt-umn/', 25436, 25155, 'silver-1')
****************
25436
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/wilseypa/', 25507, 25155, 'rphash-java')
****************
25507
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/wilseypa/', 25508, 25155, 'rphash-spark')
****************
25508
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/iModels/', 25517, 25155, 'ffci')
****************
25517
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/yt-project/', 25520, 25155, 'yt')
****************
25520
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/psi4/', 25454, 25155, 'psi4')
****************
25454
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/lattice/', 25447, 25155, 'quda')
****************
25447
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/sagemath/', 25450, 25155, 'sage')
****************
25450
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/landlab/', 25451, 25155, 'landlab')
****************
25451
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/rocksclusters/', 25476, 25155, 'FingerPrint')
****************
25476
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/oracle/', 25438, 25155, 'fastr')
****************
25438
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('git.eclipse.org/c/ptp/', 25435, 25155, 'org.eclipse.ptp')
****************
25435
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/cp2k/cp2k/', 25488, 25155, 'releases')
****************
25488
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('r.cs.purdue.edu/', 25443, 25155, 'hg-1')
****************
25443
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/ZimpleX/', 25491, 25155, 'cnn_auto_gen')
****************
25491
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/wilseypa/', 25506, 25155, 'rphash-golang')
****************
25506
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/henniggroup/', 25509, 25155, 'gasp')
****************
25509
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/cplusplus/', 25475, 25155, 'concepts-ts')
****************
25475
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/linyufly/', 25445, 25155, 'CUDATracer')
****************
25445
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('bitbucket.org/OSDT/', 25473, 25155, 'open-source-dataturbine')
****************
25473
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('source.usc.edu/svn/', 25477, 25155, 'awp-odc')
****************
25477
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('bitbucket.org/extasy-project/extasy-workflows/src/master/', 25489, 25155, 'doc')
****************
25489
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('bitbucket.org/chemora/', 25487, 25155, 'chemoracode')
****************
25487
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/BOINC/', 25484, 25155, 'boinc')
****************
25484
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/SCECcode/', 25481, 25155, 'UCVMC')
****************
25481
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/phys-tools/', 25482, 25155, 'pi-qmc')
****************
25482
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25461, 25155, 'PRUNERS')
****************
25461
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
('github.com/', 25463, 25155, 'PRUNERS-1')
****************
25463
****************
ERROR: RECORD DOES NOT EXIST IN MAPPING TABLE
@sgoggins sgoggins added bug Something isn't working help wanted Extra attention is needed labels Sep 25, 2020
@Nebrethar
Copy link
Contributor

Nebrethar commented Sep 25, 2020 •
edited
Loading

This is what I see in your traceback:

npsycopg2.errors.NotNullViolation: null value in column "file_type_id" violates not-null constraint
DETAIL: Failing row contains
(113783, null, ce7484e98cf345f1a755d49827bda7878a72a9008ff8d5928e52c601663aa97e, null, 101, , ).

I don't know why, but this error started popping up because the database stopped accepting null values for the file_type_id. I don't know why it started happening, but thankfully we don't ever need the file_type_id for our use case, so I changed the schema to allow null values for that item.

Running the following command should fix the schema and get the database ready for a new set of scans:

dosocs2 dbinit -f /path/to/augur-spdx/dosocs2.conf

It will reset the spdx schema of the targeted database, as the schema changes normally do
Please ensure that you have the correct database by reviewing the URI it provides for you at runtime.

@sgoggins
Copy link
Member Author

sgoggins commented Oct 6, 2020

@Nebrethar : I want to make sure Augur controls the schema definition. So, if I reverse engineer the change you made in augur-howison are we good? How do I get the "mapping table" populated when it fails for some reason?

@Nebrethar
Copy link
Contributor

Just to be sure, I'm talking about the augur-spdx schema that is initialized when you install augur-spdx, or reinitialize the spdx schema.

I'm not sure what augur-howison is. I'm pretty sure I didn't make any changes there 🤣 For some reason, I thought you were working with another database that had an empty spdx schema.

That dbinit command is all you will need to adjust the schema.

@sgoggins
Copy link
Member Author

@Nebrethar : Got another, similar error.

Same database as before, and it looks like it failed on the same repo. There seems to be an issue when it encounters a bitbucket repository.

sean.log

sean.err.log

@Nebrethar
Copy link
Contributor

It fails on more than BitBucket. Here is the full list of URL formats it fails on:

bitbucket.org/OSDT/
r.cs.purdue.edu/
github.com/
r.cs.purdue.edu/
source.usc.edu/svn/
git.eclipse.org/c/ptp/
sourceforge.net/projects/
git-wip-us.apache.org/repos/
github.com/cp2k/cp2k/
icl.cs.utk.edu/svn/scalapack-dev/scalapack/
charm.cs.illinois.edu/gerrit/

This leads me to believe that augur-spdx only works on standard format github.com/owner/repo URLs. Though I can't quite remember why.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Nebrethar Nebrethar

Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@sgoggins @Nebrethar