Uploaded image for project: 'mod-users'
  1. mod-users
  2. MODUSERS-90

user info can't update when username's value is '59956'

    XMLWordPrintable

Details

    • 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

            Activity

              People

                kurt Kurt Nordstrom
                Jayce Jayce
                Kurt Nordstrom Kurt Nordstrom
                Julian Ladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases