search

vince7lf / aerial_wildlife_detection

Tools for detecting wildlife in aerial images using active learning
MIT License
0 stars 0 forks source link

Export annotation fail; msg in docker output : WARNING/ForkPoolWorker-3] column "vascan_id" does not exist #44

Open vince7lf opened 2 years ago

vince7lf commented 2 years ago

Export annotation fail; msg in docker output : WARNING/ForkPoolWorker-3] column "vascan_id" does not exist

[2022-08-12 15:37:18,203: WARNING/ForkPoolWorker-3] column "vascan_id" does not exist aide_app_1 | LINE 25: ...name AS labelclass_name, idx AS labelclass_index, vascan_id,...

vince7lf commented 2 years ago

reason : project is old, it does not have the new columns

-[ RECORD 1 ]---+---------------------------------------------------------------------------
id              | 5d5f3dbc-136b-11ec-8e60-0242ac120002
name            | <C3><97>Duarctopoa labradorica
idx             | 1
timecreated     | 2021-09-12 02:47:22.075784+01
color           | #9fc0d0
labelclassgroup | 5d5f3aba-136b-11ec-8e60-0242ac120002
keystroke       |
hidden          | f
-[ RECORD 2 ]---+---------------------------------------------------------------------------

how-to check : 

(aide) ubuntu@tes2:/app/aerial_wildlife_detection/docker$ sudo docker exec -it docker_aide_app_1 /bin/bash
root@aide_app_host:/home/aide/app# sudo -u postgres psql -d ailabeltooldb
psql (10.22 (Ubuntu 10.22-1.pgdg18.04+1))
Type "help" for help.

ailabeltooldb=# \x
Expanded display is on.
ailabeltooldb=# select * from test_docker.labelclass;