Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
15.2.0
-
-
Prokopovych
-
Very Small (VS) < 1day
-
High
Description
exception info :
ERROR PostgresClient ErrorMessage(fields=Map(Line -> 5499, Where -> SQL statement "with counter as (select null FROM testlib_mod_users.users WHERE (jsonb->>'username')::numeric = 59956 LIMIT 20000 ), count_on as ( SELECT count(*) as count from counter ) SELECT count FROM count_on" PL/pgSQL function count_estimate_smart(text) line 2 at EXECUTE, File -> numeric.c, SQLSTATE -> 22P02, Routine -> set_var_from_str, V -> ERROR, Message -> invalid input syntax for type numeric: "admin", Severity -> ERROR)) com.github.mauricio.async.db.postgresql.exceptions.GenericDatabaseException: ErrorMessage(fields=Map(Line -> 5499, Where -> SQL statement "with counter as (select null FROM testlib_mod_users.users WHERE (jsonb->>'username')::numeric = 59956 LIMIT 20000 ), count_on as ( SELECT count(*) as count from counter ) SELECT count FROM count_on" PL/pgSQL function count_estimate_smart(text) line 2 at EXECUTE, File -> numeric.c, SQLSTATE -> 22P02, Routine -> set_var_from_str, V -> ERROR, Message -> invalid input syntax for type numeric: "admin", Severity -> ERROR)) at com.github.mauricio.async.db.postgresql.PostgreSQLConnection.onError(PostgreSQLConnection.scala:175) at com.github.mauricio.async.db.postgresql.codec.PostgreSQLConnectionHandler.channelRead0(PostgreSQLConnectionHandler.scala:206) at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:297) at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:413) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:265) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1359) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:935) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:141) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:886) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.lang.Thread.run(Thread.java:748)
updated's userinfo
{ "id":"sz59956", "username":"59956", "active":true, "externalSystemId":"59956" }
TestRail: Results
Attachments
Issue Links
- relates to
-
MODUSERS-108 PUT new User returns 204
-
- Closed
-
-
MODUSERS-93 Fix CQL field name validation: RMB 22.0.1, CQL2PG 3.0.1
-
- Closed
-