Hi, Bill, It’s great know. I do not think you can delete that service. Let’s confirm with Sunder.
@Sunder, thank you ahead for your explanation. Do you have any insight on the issue I ran into with H release Portal. For details, please see the attached email. Thanks, Xin Miao Solution Engineering Fujitsu Network Communication (W)972-479-2263 (M)469-268-5226 2811 Telecom Drive Richardson, TX 75081, USA From: [email protected] [mailto:[email protected]] On Behalf Of William Parkhurst Sent: Thursday, May 13, 2021 11:56 AM To: Miao, Xin <[email protected]> Cc: [email protected] Subject: Re: [onap-discuss] Portal-load balancer pending Thanks Xin. I can access the portal but sometimes the browser switches to port 8989 instead of 30225 and fails. Not a show stopper, just annoying. Is it ok to delete this service? On May 13, 2021, at 11:49 AM, [email protected]<mailto:[email protected]> wrote: Hi, Bill, It is normal! My OOM-Guilin deployment at SB-00 is fine with exact the same status as shown below. Portal access is good. However, my local OOM-Honolulu deployment with the same Porta-app status does not work with Portal access ‘denied’ with response code 500 – internal service error. ------------------------------------------------------------------------------------------------------------------------------------- ubuntu@sb-00-rke-node:~$ kubectl get svc -n onap portal-app NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE portal-app LoadBalancer 10.43.89.252 <pending> 8443:30225/TCP 33d ubuntu@sb-00-rke-node:~$ kubectl describe svc -n onap portal-app Name: portal-app Namespace: onap Labels: app=portal-app chart=portal-app-7.0.0 heritage=Tiller release=dev Annotations: msb.onap.org/service-info:<http://msb.onap.org/service-info:> [ { "serviceName": "portal", "version": "v2", "url": "/", "protocol": "REST" "port": "8989", "visualRange":"1" } ] Selector: app=portal-app,release=dev Type: LoadBalancer IP: 10.43.89.252 Port: portal-app4 8443/TCP TargetPort: 8443/TCP NodePort: portal-app4 30225/TCP Endpoints: 10.42.0.47:8443 Session Affinity: None External Traffic Policy: Cluster Events: <none> Thanks, Xin Miao Solution Engineering Fujitsu Network Communication (W)972-479-2263 (M)469-268-5226 2811 Telecom Drive Richardson, TX 75081, USA From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of William Parkhurst Sent: Thursday, May 13, 2021 11:25 AM To: [email protected]<mailto:[email protected]> Subject: [onap-discuss] Portal-load balancer pending Deployed Guilin with OOM. Not sure what to do to resolve this. kubectl get pod -n onap | grep portal-app onap-portal-app-665c7b569b-qcnqr 2/2 Running 0 7d21h kubectl get svc -n onap portal-app NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE portal-app LoadBalancer 10.43.233.94 <pending> 8443:30225/TCP 7d21h user1@onap-control:~$ kubectl describe svc -n onap portal-app Name: portal-app Namespace: onap Labels: app=portal-app chart=portal-app-7.0.0 heritage=Tiller release=onap Annotations: msb.onap.org/service-info:<https://www.google.com/url?q=http://msb.onap.org/service-info:&source=gmail-imap&ust=1621529376000000&usg=AOvVaw2YUdtwZ58W51VlzIwZYbYT> [ { "serviceName": "portal", "version": "v2", "url": "/", "protocol": "REST" "port": "8989", "visualRange":"1" } ] Selector: app=portal-app,release=onap Type: LoadBalancer IP: 10.43.233.94 Port: portal-app4 8443/TCP TargetPort: 8443/TCP NodePort: portal-app4 30225/TCP Endpoints: 10.42.2.25:8443 Session Affinity: None External Traffic Policy: Cluster Events: <none> Regards, Bill Bill Parkhurst, PhD, CCIE, CCDE, CCAr | Chief Network Architect O: 913.485.7031 | E: [email protected]<mailto:[email protected]>| W: www.solielcom.com<https://www.google.com/url?q=http://www.solielcom.com&source=gmail-imap&ust=1621529376000000&usg=AOvVaw3dMxzcKkI4z90KC2zLWalC> Soliel, LLC | CMMI DEV & SVC L3 | ISO 9001, 20000, 27001 | SBA 8(a), WOSB | This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please do not read, copy or forward this message. Please notify the sender immediately by return email and delete the message and any attachments from your system. This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please do not read, copy or forward this message. Please notify the sender immediately by return email and delete the message and any attachments from your system. -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#23230): https://lists.onap.org/g/onap-discuss/message/23230 Mute This Topic: https://lists.onap.org/mt/82803509/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
--- Begin Message ---Hi, Sunder, I just deployed H release in my local environment with the up-to-date OOM-Honolulu. I ran into the following Portal Connection issue with response code 500 problem. I had this issue before with previous release pretty much when the DB got corrupted at the deployment. The issue usually went away after I redeployed Portal component. However, this time it does not work by redeploying Portal and the DB and portal are all coming up good. Any insight? Or, debug that I need to do? Thanks a lot! ... ... Root Cause java.sql.SQLSyntaxErrorException: No active connection found for master : Could not connect: Access denied for user 'portal'@'%' to database 'portal' org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139) org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101) org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91) org.mariadb.jdbc.Driver.connect(Driver.java:109) com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176) com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163) com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908) com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) Root Cause org.mariadb.jdbc.internal.util.dao.QueryException: No active connection found for master : Could not connect: Access denied for user 'portal'@'%' to database 'portal' org.mariadb.jdbc.internal.protocol.MasterProtocol.loop(MasterProtocol.java:144) org.mariadb.jdbc.internal.failover.impl.MastersFailoverListener.reconnectFailedConnection(MastersFailoverListener.java:214) org.mariadb.jdbc.internal.failover.impl.MastersFailoverListener.initializeConnection(MastersFailoverListener.java:99) org.mariadb.jdbc.internal.failover.FailoverProxy.<init>(FailoverProxy.java:96) org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:464) org.mariadb.jdbc.Driver.connect(Driver.java:104) com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) Thanks, Xin Miao Solution Engineering Fujitsu Network Communication (W)972-479-2263 (M)469-268-5226 2811 Telecom Drive Richardson, TX 75081, USA
--- End Message ---
