-
Notifications
You must be signed in to change notification settings - Fork 10
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
Populate Sample Data issue #23
Comments
Similar issue with Sample Data / Sample Value Sets 3.3.2, it seems the tables are not being created following the instructions of the deployment guide. -->docker ps | grep vss-db Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use vss; |
Can you try restarting the service containers? The table should have been created by flyway scripts, maybe it is a timing issue? Any errors on the service container logs? Try you also try to check the schema_version flyway table to see the state of database migration. |
Background: After a full restart on both the db server and app server (service restart, compose down, compose up) After waiting 10 minutes: |
1 server setup would be easier way to go with less complications if you are just trying to build a sandbox. if you are using 2 separate docker-compose files on the same host, I think it MAY be isolating the docker network by default, so I would recommend 1 server setup for your first time setup, testing and sandbox. |
Ok, I started with a single server setup, which I will describe below: Here are the steps I followed: note 3 cores stay 100% active for quite some time … I let them run for over 1 hour, still busy, DB test still fails (tables not created) Here's what's running: Here are my "ERRORS": Any suggestions would be appreciated. |
I believe you need to go to copied |
Still not having any luck. Tried c2s_app_env.sh ENV_APP_PROFILE=application-default,docker
The versions all seem to be related to the code branch... I didn't change anything from default install. I did notice that the functions say c2sRl3.4.0 not 3.5.0, but I assume it's ok. Just never seem to have tables created (even after several hours, in case of a timing issue). I looked at issue #22, and saw bhits/vss#1
Not sure if that is related or anything should be changed there... it contains what was distributed. |
are you using 2 separate |
Yes, I had tried joining the docker-compose-db, -app.yml's into 1, same results, no tables created. |
These two enviroment variables should be your VM IP address not localhost(localhost actually refer to container itself). Can you keep the DB container up, and change the config and restart the app container? If table still not created, please share app container logs. |
CS2_*_HOST were already set to 127.0.0.1.
Went ahead and restarted the app containers, still no tables.
|
I am setting up a test instance with 3.5.0, using C2S v3 deployment guide.
Got thru 3.1.1 *Configure DB Server" & 3.1.2 "Configure App Server" without issue.
I skipped the "edge-server security" step since, if I am reading correctly - https://github.com/bhits/consent2share#ssl - this is not needed for testing environments.
Got thru 3.1.5, .6 (docker-compose steps) without issue.
ERRORS found following the Populate Sample Data 3.3.1 instructions:
-->docker ps | grep pls-db
04d28eade981 mysql:5.7 "docker-entrypoint.s…" 19 hours ago Up 21 minutes 33060/tcp, 0.0.0.0:3308->3306/tcp java_pls-db.c2s.com_1
-->docker exec -it 04d28eade981 bash
root@04d28eade981:/# cd /java/C2S_PROPS/pls
root@04d28eade981:/java/C2S_PROPS/pls# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use pls;
Database changed
mysql> source insert_state_code_lookup_data.sql;
Database changed
ERROR 1146 (42S02): Table 'pls.state_code' doesn't exist
mysql> source pls_db_sample.sql;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Database changed
ERROR 1146 (42S02): Table 'pls.provider' doesn't exist
ERROR 1146 (42S02): Table 'pls.provider' doesn't exist
ERROR 1146 (42S02): Table 'pls.provider' doesn't exist
ERROR 1146 (42S02): Table 'pls.provider' doesn't exist
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
The text was updated successfully, but these errors were encountered: