Digital Transformation . API . Integration . IAM

Recently I have come across a situation where my WSO2 APIM GUI publisher portal was taking too long to load and it was not showing the APIs listing. I have checked the logs available at wso2carbon.log and found error related to JDBC connection. Below is the summary of the issue, cause and solution- Environment WSO2 APIM 3.0.0 DB- MySQL OS- Ubuntu 16.04 Issue [2020-04-23 10:33:18,496] ERROR {org.wso2.carbon.identity.oauth2.OAuth2Service} - Error occurred while issuing the access token for Client ID : CUskLST4RR0mzQumGw_nq6PRykUa, User ID null, Scope : [] and Grant Type : authorization_code org.wso2.carbon.identity.base.IdentityRuntimeException: org.apache.tomcat.jdbc.pool.PoolExhaustedException: [https-jsse-nio-9443-exec-27] Timeout: Pool empty. Unable to fetch a connection in 60 seconds, none available[size:50; busy:50; idle:0; lastwait:60000].at org.wso2.carbon.identity.base.IdentityRuntimeException.error(IdentityRuntimeException.java:71) ........................

One of my colleague has asked about one strange issue where he created a shell script to export data from mysql in *.csv format at specific location and encountered issue while writing the files. Below is the summary of the same- Problem Cannot output MySQL data to file root@srv1:/MySQLBackup# ./script1.sh  mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (28000) at line 1: Access denied for user 'user'@'%' (using password: YES) mv: cannot stat '/created_files/data.csv': No such file or directory sed: can't read /created_files/data2020-04-15.csv: No such file or directory End of the Script The MySQL server is running with the --secure-file-priv option so it cannot execute this statement mv: cannot stat '/created_files/data.csv': No such file or directory script1.sh script1.sh master_db_user=user1 master_db_passwd=user1Pwd master_db_port=3306 master_db_host=localhost master_db_name=use