René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"(HTTP 530, error code 4250) Failed to get listusersresponse on Cloudstack 4.17.2","articleBody":"\r\n##### ISSUE TYPE\r\nBug Report\r\n##### COMPONENT NAME\r\nAPI\r\n##### CLOUDSTACK VERSION\r\n4.17.2\r\n\r\n##### CONFIGURATION\r\n##### OS / ENVIRONMENT\r\nCentos 7\r\n\r\n##### SUMMARY\r\n\r\nI send an API request to the Cloudstack server 4.17.2 , but an empty response is returned, while the same request was working correctly on Cloudstack 4.13.1.\r\n\r\n\r\n\r\n##### STEPS TO REPRODUCE\r\n\r\n##### EXPECTED RESULTS\r\nThe expected output should be similar to below : \r\n\r\nINSERT INTO cloudstack_users (service_id, username, password, api_key, secret_key) VALUES : \r\n('3074','afra-246543-307554-mgmt',\r\n'defaultpass',\r\n'IVib7_WalyDw_z84p4M..........................................pYa4jWaNVi8Gw',\r\n'f1JLPqXkwT7tqF........................neXRSg8TAV-kEjA')\r\n\r\n\r\n##### ACTUAL RESULTS\r\nAPI request on browser : \r\n{\r\n\"listusersresponse\": {\r\n\"uuidList\": [],\r\n\"errorcode\": 530,\r\n\"cserrorcode\": 4250,\r\n\"errortext\": \"Caught: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_view.id, user_view.uuid, user_view.username, user_view.password, user_view.firstname, user_view.lastname, user_view.email, user_view.state, user_view.api_key, user_view.secret_key, user_view.created, user_view.removed, user_view.timezone, user_view.registration_token, user_view.is_registered, user_view.incorrect_login_attempts, user_view.account_id, user_view.account_uuid, user_view.account_name, user_view.account_type, user_view.account_role_id, user_view.domain_id, user_view.domain_uuid, user_view.domain_name, user_view.domain_path, user_view.job_id, user_view.job_uuid, user_view.job_status, user_view.default, user_view.source FROM user_view WHERE user_view.domain_id = 7  AND user_view.account_type != 5  AND user_view.id != 1  AND user_view.domain_id = 7  AND user_view.domain_path LIKE x'2F57484D43532F25'  AND  (user_view.username LIKE x'256D676D7425'  OR user_view.firstname LIKE x'256D676D7425'  OR user_view.lastname LIKE x'256D676D7425'  OR user_view.email LIKE x'256D676D7425'  OR user_view.state LIKE x'256D676D7425'  OR user_view.account_name LIKE x'256D676D7425'  OR user_view.account_type LIKE ** NOT SPECIFIED ** )  AND user_view.removed IS NULL  ORDER BY user_view.id ASC  LIMIT 0, 100\"\r\n}\r\n}\r\n\r\n\r\nmanagement server log : \r\n\r\n2023-08-26 08:02:12,972 ERROR [c.c.a.ApiServer] (qtp1750498848-7703:ctx-083569e0 ctx-e5bf4365) (logid:31fbfd6e) unhandled exception executing api command: [Ljava.lang.String;@15e7acae\r\ncom.cloud.utils.exception.CloudRuntimeException: Caught: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_view.id, user_view.uuid, user_view.username, user_view.password, user_view.firstname, user_view.lastname, user_view.email, user_view.state, user_view.api_key, user_view.secret_key, user_view.created, user_view.removed, user_view.timezone, user_view.registration_token, user_view.is_registered, user_view.incorrect_login_attempts, user_view.account_id, user_view.account_uuid, user_view.account_name, user_view.account_type, user_view.account_role_id, user_view.domain_id, user_view.domain_uuid, user_view.domain_name, user_view.domain_path, user_view.job_id, user_view.job_uuid, user_view.job_status, user_view.default, user_view.source FROM user_view WHERE user_view.domain_id = 7  AND user_view.account_type != 5  AND user_view.id != 1  AND user_view.domain_id = 7  AND user_view.domain_path LIKE x'2F57484D43532F25'  AND  (user_view.username LIKE x'256D676D7425'  OR user_view.firstname LIKE x'256D676D7425'  OR user_view.lastname LIKE x'256D676D7425'  OR user_view.email LIKE x'256D676D7425'  OR user_view.state LIKE x'256D676D7425'  OR user_view.account_name LIKE x'256D676D7425'  OR user_view.account_type LIKE ** NOT SPECIFIED ** )  AND user_view.removed IS NULL  ORDER BY user_view.id ASC  LIMIT 0, 100\r\n        at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:425)\r\n        at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:359)\r\n        at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:348)\r\n        at com.cloud.utils.db.GenericDaoBase.searchAndCount(GenericDaoBase.java:1325)\r\n        at jdk.internal.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n        at java.base/java.lang.reflect.Method.invoke(Method.java:566)\r\n        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n        at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)\r\n        at com.sun.proxy.$Proxy331.searchAndCount(Unknown Source)\r\n        at com.cloud.api.query.QueryManagerImpl.getUserListInternal(QueryManagerImpl.java:654)\r\n        at com.cloud.api.query.QueryManagerImpl.searchForUsersInternal(QueryManagerImpl.java:572)\r\n        at com.cloud.api.query.QueryManagerImpl.searchForUsers(QueryManagerImpl.java:507)\r\n        at org.apache.cloudstack.api.command.admin.user.ListUsersCmd.execute(ListUsersCmd.java:98)\r\n        at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:163)\r\n        at com.cloud.api.ApiServer.queueCommand(ApiServer.java:776)\r\n        at com.cloud.api.ApiServer.handleRequest(ApiServer.java:600)\r\n        at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:327)\r\n        at com.cloud.api.ApiServlet$1.run(ApiServlet.java:145)\r\n        at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55)\r\n        at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:102)\r\n        at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52)\r\n        at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:142)\r\n        at com.cloud.api.ApiServlet.doGet(ApiServlet.java:96)\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:645)\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)\r\n        at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450)\r\n        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)\r\n        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)\r\n        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600)\r\n        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)\r\n        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)\r\n        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)\r\n        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)\r\n        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)\r\n        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)\r\n        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\r\n        at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763)\r\n        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)\r\n        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)\r\n        at org.eclipse.jetty.server.Server.handle(Server.java:516)\r\n        at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400)\r\n        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645)\r\n        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392)\r\n        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)\r\n        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)\r\n        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)\r\n        at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555)\r\n        at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410)\r\n        at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164)\r\n        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)\r\n        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)\r\n        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)\r\n        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)\r\n        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)\r\n        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)\r\n        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)\r\n        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)\r\n        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)\r\n        at java.base/java.lang.Thread.run(Thread.java:829)\r\nCaused by: java.lang.ClassCastException\r\n","author":{"url":"https://github.com/meisammaleki","@type":"Person","name":"meisammaleki"},"datePublished":"2023-08-26T05:30:54.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/7914/cloudstack/issues/7914"}