Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

no database found for wsd #6

Open
dengke-li opened this issue Jan 25, 2018 · 1 comment
Open

no database found for wsd #6

dengke-li opened this issue Jan 25, 2018 · 1 comment

Comments

@dengke-li
Copy link

Hello,

I am trying to install the WSD project(https://github.com/uhh-lt/wsd)
When I execute the command './wsd model:donwload' and command './wsd web-app:start', everything seems fine, and the three containers started, but when I enter into the shell of the postgresql, I find there are three databases(postgres, template0,template1),but i find no tables in each of tables. and when I execute sudo ./wsd web-app:test, then there is following bug:

[ERROR] API responded with status code '500'.

For more details run:
curl 'http://localhost:9000/predictSense' -H 'content-type: application/json' -d '{"word":"python","context":"Pyhthon is a programming language.","model":"cos_traditional_self"}'

and my docker-compose.yml is like following:
version: '3'
services:
db:
image: postgres:9.5.5
volumes:
# Assumes you downloaded postgres data to the folder ./pgdata
- ./pgdata/data:/var/lib/postgresql/data
environment:
- POSTGRES_USER=postgres
- POSTGRES_PASSWORD=p0stgres
api:
build:
context: api/target/docker/stage
environment:
- APPLICATION_SECRET=change_me
- WSP_DB_SERVER_URL=jdbc:postgresql://db
- WSP_FLICKR_API_KEY=change_me
- WSP_BING_API_KEY=change_me
- WSP_IMAGE_SEARCH_ENGINE=bing
- WSP_API_PUBLIC_URL=set_me
- WSP_API_BING_IMAGE_FOLDER=/imgdata/bing
volumes:
- ./imgdata/bing:/imgdata/bing
depends_on:
- db
restart: always
web:
build:
context: web
args:
public_url: "" # Run the web application on the root namespace
api_host: "set_me"
external_api_endpoint: "http://ltmaggie.informatik.uni-hamburg.de/wsd-server/predictWordSense"
image_api_name: "bing"
depends_on:
- api

urgent for your help

@fmarten
Copy link
Collaborator

fmarten commented Jan 28, 2018

Hi linuslukia,

it seems to me that the download of the DB image did not succeed!

There would be a forth database called wsp_default:

$ docker-compose exec db psql -U postgres -c '\l'
                                   List of databases
    Name     |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-------------+----------+----------+-------------+-------------+-----------------------
 postgres    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
 template1   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
 wsp_default | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
(4 rows)

Note the database images size is currently at 135 GB.

$ sudo du -hcs pgdata/data
135G	pgdata/data
135G	total

Does this help?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants