portal-db had issues where it was taking so long to initialize that it aborted halfway, leaving the DB files in a corrupted state. The quickest workaround is to delete the mysql directory under /dockerdata-nfs/dev-portal/ and then deleting the portal-db pod to allow it to redo the DB initialization.
The same issue can potentially occur for any of ONAP's mysql databases. Thanks, Gary From: onap-discuss@lists.onap.org [mailto:onap-discuss@lists.onap.org] On Behalf Of Krzysztof Kuzmicki Sent: Tuesday, October 30, 2018 7:32 AM To: onap-discuss@lists.onap.org Cc: Przybysz, Marcin (Nokia - PL/Wroclaw) <marcin.przyb...@nokia.com>; Pondel, Marek (Nokia - PL/Wroclaw) <marek.pon...@nokia.com>; Yunxia Chen <helen.c...@huawei.com> Subject: [onap-discuss] [integration][portal] Portal app is in infinite Waiting: PodInitializing state Hi I have installed newest OOM staging release for Casablanca and portal app is not working after several undeployments and deployments of whole dev-portal releas. I think that thi issue is cause by dev-portal-portal-db-config pod that doesn't finish successfully, After couple of retries, when it is able to connect to dev-portal-portal-db, executed script doesn't introduce any changes and all inserts finish with error similar to : ERROR 1046 (3D000) at line 363: No database selected As I checked in portal-db pod following databases are available: MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.006 sec) MariaDB [(none)]> Maybe there is some issue with portal-db initialization ? Has anybody observed similar issue? Maybe somebody has some WA for that. br, Krzysztof -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#13397): https://lists.onap.org/g/onap-discuss/message/13397 Mute This Topic: https://lists.onap.org/mt/27792647/21656 Group Owner: onap-discuss+ow...@lists.onap.org Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [arch...@mail-archive.com] -=-=-=-=-=-=-=-=-=-=-=-
