Page MenuHomeSoftware Heritage
Paste P145

(An Untitled Masterwork)
ActivePublic
Actions

Authored by seirl on Mar 14 2017, 3:00 PM.
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
About · Developer information · Legal