[Dachs-support] trouble on upgrade
Pierre Le Sidaner
pierre.lesidaner at obspm.fr
Tue Oct 17 16:09:41 CEST 2017
Hi Markus
On one of the servers, the upgrade seem to gernerate trouble
root at voparis-spaceinn:/home/lesidaner-adm# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up gavodachs-server (1.0-22) ...
If this step fails, run gavo upgrade yourself
and read the error messages. If that doesn't help,
please notify to dachs-support at g-vo.org .
*X*X* Uncaught exception at toplevel
*** Error: Oops. Unhandled exception ProgrammingError.
Exception payload: column "creationtime" of relation "datalinkjobs"
already exists
dpkg: error processing package gavodachs-server (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
gavodachs-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root at voparis-spaceinn:/home/lesidaner-adm# Exception payload: column
"creationtime" of relation "datalinkjobs"
bash: Exception: command not found
root at voparis-spaceinn:/home/lesidaner-adm# already exists
root at voparis-spaceinn:/home/lesidaner-adm# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up gavodachs-server (1.0-22) ...
If this step fails, run gavo upgrade yourself
and read the error messages. If that doesn't help,
please notify to dachs-support at g-vo.org .
*X*X* Uncaught exception at toplevel
*** Error: Oops. Unhandled exception ProgrammingError.
Exception payload: column "creationtime" of relation "datalinkjobs"
already exists
dpkg: error processing package gavodachs-server (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
gavodachs-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root at voparis-spaceinn:/home/lesidaner-adm# gavo val -tc ALL
** WARNING: Somwhere near /var/gavo/inputs/ssi/q.rd, (24, 59): Column
origin may be null but has no explicit null value.
** WARNING: Somwhere near /var/gavo/inputs/ssi/q.rd, (27, 37): Column
star_id may be null but has no explicit null value.
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column h_env_value:
u'ppm2/uHz'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column h_env_prec:
u'ppm2/uHz'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column p_gran_value:
u'ppm2/uHz'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column p_gran_precP:
u'ppm2/uHz'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column p_gran_precN:
u'ppm2/uHz'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column
sigma2_gran_value: u'ppm2'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column
sigma2_gran_precP: u'ppm2'
[ERROR] ssi/q: Bad unit in table ssi.ssi_database, column
sigma2_gran_precN: u'ppm2'
[ERROR] ssi/q: Table ssi.ssi_database: type mismatch in column star_id
(numeric is not compatible with an integer column)
[ERROR] __system__/datalink: Table dc.datalinkjobs: mismatching name of
creationTime (DB: pid); mismatching name of pid (DB: creationtime)
** WARNING: RD __system__/run: resource directory
'/var/gavo/inputs/__tests' does not exist
** WARNING: RD __system__/tests: resource directory
'/var/gavo/inputs/__tests' does not exist
** WARNING: Somwhere near /var/gavo/inputs/ssi/q.rd, (24, 59): Column
origin may be null but has no explicit null value.
** WARNING: Somwhere near /var/gavo/inputs/ssi/q.rd, (27, 37): Column
star_id may be null but has no explicit null value.
[ERROR] __system__/tap: Invalid registry record for service run:
<string>:51:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['ivoa.emptyobscore'] in unique identity-constraint
'CatalogService-tableName'.
<string>:52:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['ivoa.obscore'] in unique identity-constraint
'CatalogService-tableName'.
<string>:57:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['ssi.ssi_database'] in unique identity-constraint
'CatalogService-tableName'.
<string>:61:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.schemas'] in unique identity-constraint
'CatalogService-tableName'.
<string>:61:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.tables'] in unique identity-constraint
'CatalogService-tableName'.
<string>:61:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.columns'] in unique identity-constraint
'CatalogService-tableName'.
<string>:61:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.keys'] in unique identity-constraint
'CatalogService-tableName'.
<string>:61:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.key_columns'] in unique identity-constraint
'CatalogService-tableName'.
<string>:62:0:ERROR:SCHEMASV:SCHEMAV_CVC_IDC: Element 'table': Duplicate
key-sequence ['tap_schema.groups'] in unique identity-constraint
'CatalogService-tableName'.
Running regression tests
....................E...E.EEE.
5 of 30 bad. avg 1.44, min 0.03, max 3.19. 4.9/s, par 7.1
The following tests failed:
From __system__/tests:
FAIL Update of non-existing data is a no-op (may fail on state)
FAIL Insert of non-existing data touches one record.
FAIL Duplicate insertion of data yields error
FAIL Updates of existing data modify db
FAIL Reset of uploads table seems to work
then
root at voparis-spaceinn:/home/lesidaner-adm# gavo upgrade
*X*X* Uncaught exception at toplevel
*** Error: Oops. Unhandled exception ProgrammingError.
Exception payload: column "creationtime" of relation "datalinkjobs"
already exists
Do you have any advise ?
I don't have time to dig inside
regards
Pierre
--
-------------------------------------------------------------------------
Pierre Le Sidaner
Observatoire de Paris
Directeur Adjoint
Direction Informatique de l'Observatoire
Directeur technique
Paris Astronomical Data Centre 01 40 51 20 82
61, avenue de l'Observatoire 75014 Paris
mailto:pierre.lesidaner at obspm.fr
http://padc.obspm.fr
--------------------------------------------------------------------------
More information about the Dachs-support
mailing list