Skip to Content.
Sympa Menu

perfsonar-user - [perfsonar-user] Failed perfSONAR upgrade

Subject: perfSONAR User Q&A and Other Discussion

List archive

[perfsonar-user] Failed perfSONAR upgrade


Chronological Thread 
    < Chronological >      < Thread >
  • From: Raul Lopes <>
  • To: "" <>
  • Subject: [perfsonar-user] Failed perfSONAR upgrade
  • Date: Tue, 16 May 2023 16:44:11 +0000
  • Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=jisc.ac.uk; dmarc=pass action=none header.from=jisc.ac.uk; dkim=pass header.d=jisc.ac.uk; arc=none
  • Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=AuSXiAJnCN04Hl53PBhlHK1F8imosPAtfgCEMfyZTrg=; b=MDW8SiZeT81OLH70E95otKDKz3e7drHYN+ozO08/tpx+3/sLIp5eNyoHT2hol8LboP2XmKGk5RUNuTaq0NR7LxvlyUwUfrNlDK8HwP7Q8n5BPAL1SbzHgwx0I/ucRxx2KuMzNDlbwN/ajchozloD7xUtnpcyENSodUC6jBt1FWCxYwivCnncc/ebpjXi8aMtmGuGYVwEOLQb4keY7QTzfz1LKIixNsv0qUJxHb7WKni40MZI6i9IPaFdzAQZHwTmyEdZT57zA0JyUXgRASDAlZAEH/r0/guYl/xMmJAZTeeYaori6/tVcIIMnMochXVSDz3g15ODetB59Ao6zgrfkA==
  • Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FV5ZflAOifzgFyIdieUpC0MxNqdJD/BsKuw7SXUkDADrSe2sYJYLaXRthxHDi+szfEgggNm8kfIuB2Fe3PtXuLmoYSqLHEqdot2y2q8XLY3ZKcydnbldN9kCSm2o8rxjfqcCyMTNHo87dYmgPC3YpkkgAl9Um+jIWzeqQAVkOCHl9CT3xiT7dqkFp3UDsAi7uCuMBGS5B5stAithVRM7AzQ0p565EQgwjwUpAVgQcxQTyRzS227dc9DyIt6zQ8fBFWF2/Ifd8tIvpHR8AvknYW3DReW+u2zPURdE2wad7nv8JqRaaRg99VvGMlbiLq2vlaXNmSjHTp3ZDHriIzUmgw==
  • Msip_labels:
Dear perfSONAR experts,

We have a failed perfSONAR upgrade with errors seemin g to indicate a DB error: see  [0].

Would you have advice on recovery?

Regards,
Raul


May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    Exception: psycopg2.ProgrammingError: function api_task_post(unknown, text[], unknown, integer, unknown, unknown, boolean, unknown) does not exist

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    LINE 1: SELECT uuid, participant_key FROM api_task_post('{"archives"...

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR                                              ^

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    Traceback (most recent call last):

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR      File "/usr/lib/python3.6/site-packages/flask/app.py", line 1950, in full_dispatch_request

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR        rv = self.dispatch_request()

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR      File "/usr/lib/python3.6/site-packages/flask/app.py", line 1936, in dispatch_request

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR        return self.view_functions[rule.endpoint](**req.view_args)

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR      File "/var/www/pscheduler-server/pschedulerapiserver/tasks.py", line 485, in tasks

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR        task.get("priority", None), diags], _onerow_=True)

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR      File "/var/www/pscheduler-server/pschedulerapiserver/dbcursor.py", line 112, in dbcursor_query

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR        raise ex

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR      File "/var/www/pscheduler-server/pschedulerapiserver/dbcursor.py", line 97, in dbcursor_query

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR        cursor.execute(query, args)

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    psycopg2.ProgrammingError: function api_task_post(unknown, text[], unknown, integer, unknown, unknown, boolean, unknown) does not exist

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    LINE 1: SELECT uuid, participant_key FROM api_task_post('{"archives"...

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR                                              ^

May 16 13:14:06 heplni019 pscheduler-api[3641] ERROR    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.



Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under company number. 05747339, VAT number GB 197 0632 86. Jisc’s registered office is: 4 Portwall Lane, Bristol, BS1 6NB. T 0203 697 5800.

Jisc Services Limited is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under company number 02881024, VAT number GB 197 0632 86. The registered office is: 4 Portwall Lane, Bristol, BS1 6NB. T 0203 697 5800.

Jisc Commercial Limited is a wholly owned Jisc subsidiary and a company limited by shares which is registered in England under company number 09316933, VAT number GB 197 0632 86. The registered office is: 4 Portwall Lane, Bristol, BS1 6NB. T 0203 697 5800.

For more details on how Jisc handles your data see our privacy notice here: https://www.jisc.ac.uk/website/privacy-notice


Archive powered by MHonArc 2.6.24.

Top of Page