search

ML-TANGO / TANGO

public repo for TANGO (Target Aware No-code neural network Generation and Operation framework)
Other
68 stars 20 forks source link

Can't create new project in TANGO UI #140

Closed HyunwooCho closed 4 months ago

HyunwooCho commented 4 months ago

I run into the problem when I create the new project in TANGO UI. I filled in the project name and description to create new project in TANGO UI (localhost:8085). But they say the error occurs and retry it. I don't know why.. prosgres version mismatch? or certain rule creating project?

I wrote 'yolov9p' as project name, and 'yolov9_test_project' as project description. and then pressed 'create' button. That's it but I received these log and error messages. Screenshot from 2024-03-14 10-36-47 Screenshot from 2024-03-14 10-37-14

postgresql_1       | 2024-03-14 01:22:58.361 UTC [73] WARNING:  database "postgres" has a collation version mismatch
postgresql_1       | 2024-03-14 01:22:58.361 UTC [73] DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
postgresql_1       | 2024-03-14 01:22:58.361 UTC [73] HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
postgresql_1       | 2024-03-14 01:23:06.748 UTC [74] WARNING:  database "postgres" has a collation version mismatch
postgresql_1       | 2024-03-14 01:23:06.748 UTC [74] DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
postgresql_1       | 2024-03-14 01:23:06.748 UTC [74] HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
project_manager_1  | WARNING:  database "postgres" has a collation version mismatch
project_manager_1  | DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
project_manager_1  | HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
postgresql_1       | 2024-03-14 01:23:06.750 UTC [74] ERROR:  column project.project_type does not exist at character 133
postgresql_1       | 2024-03-14 01:23:06.750 UTC [74] HINT:  Perhaps you meant to reference the column "project.project_name".
postgresql_1       | 2024-03-14 01:23:06.750 UTC [74] STATEMENT:  SELECT "project"."id", "project"."project_name", "project"."project_description", "project"."create_user", "project"."create_date", "project"."project_type", "project"."target", "project"."dataset", "project"."task_type", "project"."autonn_dataset_file", "project"."autonn_basemodel", "project"."nas_type", "project"."deploy_weight_level", "project"."deploy_precision_level", "project"."deploy_processing_lib", "project"."deploy_user_edit", "project"."deploy_input_method", "project"."deploy_input_data_path", "project"."deploy_output_method", "project"."deploy_input_source", "project"."container", "project"."container_status", "project"."last_logs_timestamp", "project"."last_log_container", "project"."current_log" FROM "project" WHERE ("project"."create_user" = 'tenace' AND "project"."project_name" = 'yolov9p') LIMIT 21
project_manager_1  | column project.project_type does not exist
project_manager_1  | LINE 1: ..."project"."create_user", "project"."create_date", "project"....
project_manager_1  |                                                              ^
project_manager_1  | HINT:  Perhaps you meant to reference the column "project.project_name".
project_manager_1  | 
postgresql_1       | 2024-03-14 01:23:06.751 UTC [74] ERROR:  column "project_type" of relation "project" does not exist at character 93
postgresql_1       | 2024-03-14 01:23:06.751 UTC [74] STATEMENT:  INSERT INTO "project" ("project_name", "project_description", "create_user", "create_date", "project_type", "target", "dataset", "task_type", "autonn_dataset_file", "autonn_basemodel", "nas_type", "deploy_weight_level", "deploy_precision_level", "deploy_processing_lib", "deploy_user_edit", "deploy_input_method", "deploy_input_data_path", "deploy_output_method", "deploy_input_source", "container", "container_status", "last_logs_timestamp", "last_log_container", "current_log") VALUES ('yolov9p', 'yolov9_test_project', 'tenace', '2024-03-14 10:23:06.750765', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.0, '', '') RETURNING "project"."id"
postgresql_1       | 2024-03-14 01:23:06.756 UTC [74] ERROR:  column project.project_type does not exist at character 133
postgresql_1       | 2024-03-14 01:23:06.756 UTC [74] HINT:  Perhaps you meant to reference the column "project.project_name".
postgresql_1       | 2024-03-14 01:23:06.756 UTC [74] STATEMENT:  SELECT "project"."id", "project"."project_name", "project"."project_description", "project"."create_user", "project"."create_date", "project"."project_type", "project"."target", "project"."dataset", "project"."task_type", "project"."autonn_dataset_file", "project"."autonn_basemodel", "project"."nas_type", "project"."deploy_weight_level", "project"."deploy_precision_level", "project"."deploy_processing_lib", "project"."deploy_user_edit", "project"."deploy_input_method", "project"."deploy_input_data_path", "project"."deploy_output_method", "project"."deploy_input_source", "project"."container", "project"."container_status", "project"."last_logs_timestamp", "project"."last_log_container", "project"."current_log" FROM "project" LIMIT 21
project_manager_1  | [14/Mar/2024 10:23:06] "POST /api/project_create HTTP/1.1" 500 145
ML-TANGO commented 4 months ago

From the log 

project_manager_1  | WARNING:  database "postgres" has a collation version mismatch
project_manager_1  | DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
project_manager_1  | HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

I think you might use older versioned postgreSQL created database. Please remove the volume related to the postgreSQL database and restart TANGO with docker-compose up -d.

You can check the volume related with postgreSQL database using following command 

$ docker volume ls | grep postgre
local     tango_postgreSQL

then use docker volume rm tango_postgreSQL to remove it.

HyunwooCho commented 4 months ago

Yes, thanks.

This is what I've done for future references.

[before]

$ docker volume ls | grep postgre
local     deepframe_postgreSQL
local     tango_2_postgreSQL
local     tango_new_postgreSQL
local     tango_postgreSQL
local     tango_temp_postgreSQL
local     tesla_tango_postgreSQL

Remove all images and volumes, and then rebuild

$ docker-compose down --rmi all --volume
$ docker-compose build --no-cache

[after removing all volumes and re-build & run TANGO]

$ docker volume ls
DRIVER    VOLUME NAME
local     5f3bbef6a2b1af37a792a456409909e093937acefef4759e03e5c358240d9f86
local     tango_postgreSQL
local     tango_registry_data
local     tango_shared

Run TANGO and access TANGO URL (http://localhost:8085)

$ docker-compose up

I will close this issue.

HyunwooCho commented 4 months ago

Next step to create new project...

How can I set or get COCO dataset? Screenshot from 2024-03-14 15-38-21