I also moved this to https://jira.onap.org/browse/VID-14
Thanks, Daniel Rose ECOMP / ONAP com.att.ecomp 732-420-7308 From: [email protected] [mailto:[email protected]] On Behalf Of Josef Reisinger Sent: Wednesday, June 07, 2017 11:20 AM To: OBRIEN, FRANK MICHAEL <[email protected]> Cc: [email protected] Subject: Re: [onap-discuss] 20170606 Rackspace deployment has VID issue with stopped MariaDB container Michael, for older versions, that looks like the script /docker-entrypoint-initdb.d/vid-pre-init.sql has not run. you may try $ docker exec -it vid-mariadb bash #> mysql -uroot -pLF+tp_1WqgSY </docker-entrypoint-initdb.d/vid-pre-init.sql maybe you need to restart vis-server after that. Mit freundlichen Grüßen / Kind regards Josef Reisinger From: "Michael O'Brien" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: 07.06.2017 17:01 Subject: [onap-discuss] 20170606 Rackspace deployment has VID issue with stopped MariaDB container Sent by: [email protected]<mailto:[email protected]> ________________________________ VID team, Hi, did a clean rackspace install twice using the 1700 20170606 and 0700 EDT 20170607 codebase on our secondary tenant (trying to get the vFW demo past TG config - was an old nexus repo URL in the 1.0.0 ZIP template) Having issues getting a pre-populated VID DB container to restart - raised https://jira.onap.org/browse/UCA-22<https://urldefense.proofpoint.com/v2/url?u=https-3A__jira.onap.org_browse_UCA-2D22&d=DwMFAw&c=LFYZ-o9_HUMeMTSQicvjIg&r=2wwdGZ3YcpSivQ2Kio028A&m=MSPlnO2wLbNf_6Q7lrvFS-7skk7Quorw5OroGRBD38M&s=lNYNaugP3EynxyiyO8uhJ6Gkn6wnfv4CJlwtPM_uWqo&e=> The demo.sh init fails with a 500 on a missing SYD DC - but this is secondary. (thanks for the log viewing procedure - Andrew Fenner) - there is nothing wrong with the init/preload demo scripts as they worked fine previously root@vm1-robot:/opt# vi authorization # test:test root@vm1-robot:/opt# docker cp authorization openecompete_container:/etc/lighttpd/authorization root@vm1-robot:/opt# docker exec -it openecompete_container bash root@99521eebd8b7:/# cp -r /share/logs/demo/InitDemo/ /var/opt/OpenECOMP_ETE/html Arguments: [ ${cloud_owner}='Rackspace' | ${cloud_region_id}='SYD' | ${cloud_type}='SharedNode' | ${owner_defined_type}='OwnerType' | ${cloud_region_version}='v1' | ${cloud_zone}='CloudZone' | ${tenant_id}='1035199' | ${tenant_name}='1035199' ] Turns out that the MariaDB container on the VID VM failed to start - as a result the Tomcat container on VID failed startup. Any calls to VID return a 500 on a resulting "No route to host" getting the hibernate connection. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceMap' defined in class path resource java.net.NoRouteToHostException: No route to host (Host unreachable) Tried to fix it by starting the maria db container, waiting, restarting the tomcat container - but now it looks like schema re-population is required. root@vm1-vid:~# docker start vid-mariadb vid-mariadb root@vm1-vid:~# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f01603ad520f nexus3.onap.org:10001/openecomp/vid:1.0-STAGING-latest "/tmp/vid/localize.sh" 3 hours ago Up 3 hours 0.0.0.0:8080->8080/tcp vid-server c4a3fd8ccf7e mariadb:10 "docker-entrypoint..." 3 hours ago Up 4 seconds 3306/tcp vid-mariadb wait root@vm1-vid:~# docker stop vid-server vid-server root@vm1-vid:~# docker start vid-server vid-server root@vm1-vid:~# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f01603ad520f nexus3.onap.org:10001/openecomp/vid:1.0-STAGING-latest "/tmp/vid/localize.sh" 3 hours ago Up 14 seconds 0.0.0.0:8080->8080/tcp vid-server c4a3fd8ccf7e mariadb:10 "docker-entrypoint..." 3 hours ago Up About a minute 3306/tcp vid-mariadb root@vm1-vid:~# docker exec -it vid-server bash root@f01603ad520f:/usr/local/tomcat# cat logs/localhost.2017-06-07.log 07-Jun-2017 14:34:59.550 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.loadOnStartup Servlet [dispatcher] in web application [/vid] threw load() exception com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'vid_openecomp_epsdk.schema_info' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at https://www.amdocs.com/about/email-disclaimer<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwMFAw&c=LFYZ-o9_HUMeMTSQicvjIg&r=2wwdGZ3YcpSivQ2Kio028A&m=MSPlnO2wLbNf_6Q7lrvFS-7skk7Quorw5OroGRBD38M&s=mwWBb6EFLXViPTvjD-ChFz5IN-wD3Nzl16bMCy0fnTM&e=>_______________________________________________ onap-discuss mailing list [email protected]<mailto:[email protected]> https://lists.onap.org/mailman/listinfo/onap-discuss<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.onap.org_mailman_listinfo_onap-2Ddiscuss&d=DwMFAw&c=LFYZ-o9_HUMeMTSQicvjIg&r=2wwdGZ3YcpSivQ2Kio028A&m=MSPlnO2wLbNf_6Q7lrvFS-7skk7Quorw5OroGRBD38M&s=8NOEkkX0PPFvK8Jx8gYsg8SYOl5teNf-clTSa9jQDvQ&e=>
_______________________________________________ onap-discuss mailing list [email protected] https://lists.onap.org/mailman/listinfo/onap-discuss
