Skip to content

Instantly share code, notes, and snippets.

@tiarebalbi
Created October 26, 2023 05:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tiarebalbi/4068250d99022b853b2e54d423a86463 to your computer and use it in GitHub Desktop.
Save tiarebalbi/4068250d99022b853b2e54d423a86463 to your computer and use it in GitHub Desktop.
2023-10-25T22:58:24.249-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.249-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.250-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.250-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.257-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.265-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,61ecc12dd694e1a5] 83428 --- [nio-8080-exec-7] org.hibernate.SQL : select u1_0.user_id,u1_0.active,u1_0.created_at,u1_0.email,u1_0.firstname,u1_0.lastname,u1_0.permission_id,u1_0.role,u1_0.senha,u1_0.updated_at from users u1_0 where upper(u1_0.email)=upper(?)
Hibernate: select u1_0.user_id,u1_0.active,u1_0.created_at,u1_0.email,u1_0.firstname,u1_0.lastname,u1_0.permission_id,u1_0.role,u1_0.senha,u1_0.updated_at from users u1_0 where upper(u1_0.email)=upper(?)
2023-10-25T22:58:24.267-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.268-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,b37798605cdc8338] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.273-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,3f6480353f57d8d1] 83428 --- [nio-8080-exec-8] o.s.web.servlet.DispatcherServlet : GET "/core/v1/pesquisa-popular?page=0&size=10", parameters={masked}
2023-10-25T22:58:24.273-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,3f6480353f57d8d1] 83428 --- [nio-8080-exec-8] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaPopularController#buscarPesquisas()
2023-10-25T22:58:24.280-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,61ecc12dd694e1a5] 83428 --- [nio-8080-exec-7] org.hibernate.SQL : select 1 from tokens t1_0 where t1_0.token=? and t1_0.revoked=? and t1_0.expired=? fetch first ? rows only
Hibernate: select 1 from tokens t1_0 where t1_0.token=? and t1_0.revoked=? and t1_0.expired=? fetch first ? rows only
2023-10-25T22:58:24.282-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,3f6480353f57d8d1] 83428 --- [nio-8080-exec-8] m.m.a.RequestResponseBodyMethodProcessor : Using 'application/json', given [application/json, text/plain, */*] and supported [application/json, application/*+json]
2023-10-25T22:58:24.282-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,3f6480353f57d8d1] 83428 --- [nio-8080-exec-8] m.m.a.RequestResponseBodyMethodProcessor : Writing [[PesquisaPopular(id=46, termo=conteúdo, quantidade=3), PesquisaPopular(id=47, termo=conteudo, quanti (truncated)...]
2023-10-25T22:58:24.283-07:00 DEBUG [mts-app,653a0000c1d736730123719932c3f6db,3f6480353f57d8d1] 83428 --- [nio-8080-exec-8] o.s.web.servlet.DispatcherServlet : Completed 200 OK
2023-10-25T22:58:24.284-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.285-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.286-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.286-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.286-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.286-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,017b907cfd27e920] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.287-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] o.s.web.servlet.DispatcherServlet : GET "/core/v1/pesquisa?page=0&size=10", parameters={masked}
2023-10-25T22:58:24.287-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to net.spaceinfinity.mts.app.pesquisas.controllers.PesquisaController#buscarPesquisas(Pageable)
2023-10-25T22:58:24.288-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] org.hibernate.SQL : SELECT DISTINCT ON (termo) * FROM pesquisas order by dataRegistro desc fetch first ? rows only
Hibernate: SELECT DISTINCT ON (termo) * FROM pesquisas order by dataRegistro desc fetch first ? rows only
2023-10-25T22:58:24.290-07:00 WARN [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42703
2023-10-25T22:58:24.291-07:00 ERROR [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: column "dataregistro" does not exist
Hint: Perhaps you meant to reference the column "pesquisas.data_registro".
Position: 54
2023-10-25T22:58:24.291-07:00 DEBUG [mts-app,653a00006683e010b8102aa428c0eaf3,a0774ec5dcbb7188] 83428 --- [nio-8080-exec-7] o.s.web.servlet.DispatcherServlet : Failed to complete request: org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [SELECT DISTINCT ON (termo) * FROM pesquisas order by dataRegistro desc fetch first ? rows only] [ERROR: column "dataregistro" does not exist
Hint: Perhaps you meant to reference the column "pesquisas.data_registro".
Position: 54] [n/a]; SQL [n/a]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment