ERROR:root:null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22022, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM Traceback (most recent call last): File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/home/seirl/swh-environment/swh-storage/swh/storage/api/server.py", line 189, in release_add return encode_data(g.storage.release_add(**decode_request(request))) File "/home/seirl/swh-environment/swh-storage/swh/storage/storage.py", line 767, in release_add db.release_add_from_temp(cur) File "/home/seirl/swh-environment/swh-storage/swh/storage/db.py", line 36, in _meth self._cursor(cur).execute('SELECT %s()' % stored_proc) psycopg2.IntegrityError: null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22022, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM 127.0.0.1 - - [14/Mar/2017 14:34:14] "POST /release/add HTTP/1.1" 400 - INFO:werkzeug:127.0.0.1 - - [14/Mar/2017 14:34:14] "POST /release/add HTTP/1.1" 400 - ERROR:root:null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22023, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM Traceback (most recent call last): File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/home/seirl/swh-environment/swh-storage/swh/storage/api/server.py", line 189, in release_add return encode_data(g.storage.release_add(**decode_request(request))) File "/home/seirl/swh-environment/swh-storage/swh/storage/storage.py", line 767, in release_add db.release_add_from_temp(cur) File "/home/seirl/swh-environment/swh-storage/swh/storage/db.py", line 36, in _meth self._cursor(cur).execute('SELECT %s()' % stored_proc) psycopg2.IntegrityError: null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22023, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM 127.0.0.1 - - [14/Mar/2017 14:34:14] "POST /release/add HTTP/1.1" 400 - INFO:werkzeug:127.0.0.1 - - [14/Mar/2017 14:34:14] "POST /release/add HTTP/1.1" 400 - ERROR:root:null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22024, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM Traceback (most recent call last): File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/home/seirl/swh-environment/.venv/lib/python3.5/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/home/seirl/swh-environment/swh-storage/swh/storage/api/server.py", line 189, in release_add return encode_data(g.storage.release_add(**decode_request(request))) File "/home/seirl/swh-environment/swh-storage/swh/storage/storage.py", line 767, in release_add db.release_add_from_temp(cur) File "/home/seirl/swh-environment/swh-storage/swh/storage/db.py", line 36, in _meth self._cursor(cur).execute('SELECT %s()' % stored_proc) psycopg2.IntegrityError: null value in column "fullname" violates not-null constraint DETAIL: Failing row contains (22024, null, null, null). CONTEXT: SQL statement "with t as ( select distinct author_fullname as fullname, author_name as name, author_email as email from tmp_release ) insert into person (fullname, name, email) select fullname, name, email from t where not exists ( select 1 from person p where t.fullname = p.fullname )" PL/pgSQL function swh_person_add_from_release() line 3 at SQL statement SQL statement "SELECT swh_person_add_from_release()" PL/pgSQL function swh_release_add() line 3 at PERFORM