[2026-04-06 01:18:15.102] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.688968ms | method: OPTIONS | path: /api/v1/roles/pages/tree | request_id: 4c4a7ec0-b16b-4d55-a07c-cc0f571072a5 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 01:18:15.123] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 10.162688ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 922120fe-4058-464b-a500-1f8046bb10f3 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 01:55:56.575] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 52.03307ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 04a07d41-82e1-4262-ae99-6a227c7fb7a9 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 01:59:56.397] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.472009ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 7bc0ff05-7094-4d47-bc36-fc57d91b4ee5 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:00:00.171] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.532588ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 0ad7d6ce-5c64-48f1-9e94-190fb7635118 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:00:03.773] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.278434ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 58c26899-d083-48bb-8e7a-aed5d9345134 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:06:41.350] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 11.296492ms | method: GET | path: /api/v1/roles/pages/tree | request_id: bcbbbf6a-c015-466a-85e7-b13a0e6d81ca | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:06:59.718] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.888373ms | method: POST | path: /api/v1/auth/login | request_id: 00c5f8d7-9855-486b-87eb-60a0707faece | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:07:15.779] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:07:15.781] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.823285ms | method: GET | path: /api/v1/roles/master | request_id: 28bbbb0e-21b4-48c3-8ed5-17e2c2269956 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:08:57.273] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:08:57.273] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:08:57.274] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:08:57.284] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:08:57.284] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:08:57.292] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:08:57.292] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:08:57.311] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:08:57.311] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:08:57.312] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:08:57.313] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:08:57.346] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:08:57.349] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:08:57.349] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:08:57.349] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:08:57.350] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:08:57.350] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:08:57.350] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:08:57.350] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:09:20.699] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:09:20.702] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.418415ms | method: GET | path: /api/v1/roles/master | request_id: bd6eaf7a-2a74-4657-95eb-21c361404793 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:13:09.101] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 31.06187ms | method: GET | path: /api/v1/roles/pages/tree | request_id: ea7fa1a6-127a-4a97-97aa-b12fa269ff44 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.464] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 73.187µs | method: OPTIONS | path: /api/v1/roles/pages/6 | request_id: 5a2c5f43-8056-4c39-9776-d0c141333ae3 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.476] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.892554ms | method: GET | path: /api/v1/roles/pages/6 | request_id: 12d71fff-dc26-4224-964c-a60034df5cb0 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.498] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 28.341µs | method: OPTIONS | path: /api/v1/roles/pages | query: filter= | request_id: c1789be4-098c-4561-be68-520525475338 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.504] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 50.477µs | method: OPTIONS | path: /api/v1/roles/pages | query: filter= | request_id: a192f110-02c8-4d85-8095-a6ed2ea51999 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.510] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.662742ms | method: GET | path: /api/v1/roles/pages | query: filter= | request_id: 6a998c7c-94e3-4548-b4da-c47f19d23ffe | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:13:49.515] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:0e43c0356c7b0edb8709d9e3a9ded96ebe4e2bf019fec58ab78fa4d402ccb287 | service: service-general
[2026-04-06 02:13:49.515] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 706.371µs | method: GET | path: /api/v1/roles/pages | query: filter= | request_id: c8032dab-b117-4ed9-8e70-b089497e89b1 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:14:08.485] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:14:08.494] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 10.297237ms | method: GET | path: /api/v1/roles/master | request_id: 5bd5b50c-fcab-4303-966c-688df14fa501 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:16:46.325] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:16:46.325] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:16:46.325] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:16:46.335] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:16:46.335] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:16:46.344] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:16:46.344] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:16:46.367] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:16:46.367] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:16:46.367] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:16:46.369] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:16:46.400] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:16:46.403] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:16:46.403] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:16:46.403] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:16:46.404] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:16:46.404] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:16:46.404] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:16:46.404] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:16:51.426] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:16:51.430] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.930971ms | method: GET | path: /api/v1/roles/master | request_id: e85fcc44-6e13-48be-9690-aa9ecac35fa5 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:16:59.502] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:0e43c0356c7b0edb8709d9e3a9ded96ebe4e2bf019fec58ab78fa4d402ccb287 | service: service-general
[2026-04-06 02:16:59.503] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.169614ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: d42cc9d1-f5dc-4e97-ad30-4a28f38d0c21 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:17:51.743] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:17:51.745] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.385147ms | method: GET | path: /api/v1/roles/master | request_id: a25dd8de-6410-4d6d-b984-e87c92b2c252 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:18:43.979] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 34.088406ms | method: GET | path: /api/v1/roles/pages/tree | request_id: dd5d7468-df48-4a71-90ea-fccf4096d25a | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:18:49.829] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.531364ms | method: GET | path: /api/v1/roles/pages/tree | request_id: c03bf5d3-4dae-4f95-9c5c-6009ed9eb3fd | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:19:54.853] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:19:54.853] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:19:54.853] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:19:54.862] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:19:54.862] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:19:54.871] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:19:54.871] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:19:54.890] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:19:54.891] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:19:54.891] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:19:54.892] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:19:54.923] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:19:54.925] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:19:54.925] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:19:54.925] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:19:54.926] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:19:54.926] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:19:54.926] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:19:54.926] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:08.538] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:20:08.538] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:20:08.539] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:08.546] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:08.546] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:08.555] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:08.555] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:08.576] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:08.576] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:08.576] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:20:08.578] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:20:08.607] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:20:08.609] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:20:08.609] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:20:08.609] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:20:08.610] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:20:08.610] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:20:08.610] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:20:08.610] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:20.808] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:20:20.809] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:20:20.809] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:20.819] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:20.819] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:20.827] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:20.827] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:20.850] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:20.850] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:20.850] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:20:20.851] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:20:20.853] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:20:20.853] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:20:20.853] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:20:20.854] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:20:20.854] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:20.854] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:20:20.854] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:20:30.298] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:20:30.299] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:20:30.299] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:30.317] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:30.317] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:30.327] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:30.327] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:30.334] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:30.334] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:30.335] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:20:30.336] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:20:30.337] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:20:30.338] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:20:30.338] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:20:30.338] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:20:30.338] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:20:30.338] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:30.338] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:20:42.352] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:20:42.352] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:20:42.352] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:42.360] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:42.360] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:42.367] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:42.367] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:42.386] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:42.386] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:42.386] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:20:42.388] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:20:42.416] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:20:42.418] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:20:42.418] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:20:42.419] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:20:42.419] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:20:42.419] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:20:42.419] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:42.419] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:20:54.240] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:20:54.240] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:20:54.240] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:54.248] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:54.248] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:54.257] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:54.257] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:54.327] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:20:54.328] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:20:54.328] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:20:54.329] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:20:54.357] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:20:54.360] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:20:54.361] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:20:54.361] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:20:54.361] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:20:54.361] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:20:54.361] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:20:54.362] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:20:54.789] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:20:54.792] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.776828ms | method: GET | path: /api/v1/roles/master | request_id: db8ff84c-3a9d-462d-83c6-91e509e19ea3 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:21:59.102] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:21:59.102] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:21:59.102] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:21:59.112] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:21:59.112] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:21:59.119] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:21:59.119] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:21:59.137] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:21:59.137] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:21:59.137] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:21:59.139] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:21:59.162] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:21:59.164] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:21:59.164] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:21:59.164] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:21:59.165] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:21:59.165] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:21:59.165] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:21:59.165] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:22:05.508] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:22:05.508] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:22:05.509] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:05.518] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:05.518] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:05.528] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:05.528] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:05.547] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:05.547] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:05.547] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:22:05.548] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:22:05.550] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:22:05.550] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:22:05.550] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:22:05.550] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:22:05.550] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:22:05.550] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:22:05.550] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:22:23.633] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:22:23.633] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:22:23.633] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:23.641] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:23.641] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:23.648] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:23.648] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:23.663] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:22:23.663] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:22:23.663] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:22:23.664] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:22:23.693] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:22:23.695] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:22:23.695] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:22:23.695] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:22:23.695] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:22:23.696] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:22:23.696] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:22:23.696] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:23:25.849] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:23:25.850] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:23:25.850] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:25.858] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:25.858] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:25.865] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:25.865] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:25.880] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:25.880] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:25.880] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:23:25.881] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:23:25.883] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:23:25.883] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:23:25.883] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:23:25.883] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:23:25.883] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:23:25.883] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:23:25.884] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:23:37.535] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 32.059728ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 5a6747e9-bc6c-4af0-b0be-253664480b06 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:23:41.431] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:23:41.431] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:23:41.431] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:41.439] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:41.439] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:41.446] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:41.446] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:41.467] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:23:41.467] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:23:41.467] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:23:41.469] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:23:41.497] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:23:41.498] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:23:41.499] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:23:41.499] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:23:41.499] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:23:41.499] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:23:41.499] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:23:41.499] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:24:08.929] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:24:08.929] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:24:08.930] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:08.938] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:08.938] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:08.947] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:08.948] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:08.966] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:08.966] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:08.967] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:24:08.968] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:24:08.994] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:24:08.996] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:24:08.996] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:24:08.996] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:24:08.996] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:24:08.996] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:24:08.996] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:24:08.997] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:24:20.227] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:24:20.227] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:24:20.227] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:20.239] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:20.239] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:20.246] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:20.246] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:20.265] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:24:20.265] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:24:20.266] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:24:20.267] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:24:20.297] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:24:20.300] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:24:20.301] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:24:20.301] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:24:20.301] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:24:20.301] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:24:20.301] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:24:20.302] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:24:20.375] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:24:20.379] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.589495ms | method: GET | path: /api/v1/roles/master | request_id: ad470a26-08e5-43f0-986a-fa89c6067855 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:26:28.622] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:26:28.622] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:26:28.622] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:26:28.632] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:26:28.632] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:26:28.639] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:26:28.640] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:26:28.659] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:26:28.659] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:26:28.660] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:26:28.662] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:26:28.693] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:26:28.695] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:26:28.696] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:26:28.696] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:26:28.697] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:26:28.697] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:26:28.697] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:26:28.697] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:26:32.394] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:26:32.397] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.183905ms | method: GET | path: /api/v1/roles/master | request_id: 2b704b60-80ec-46b5-9674-94cdb620d9e3 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:27:11.668] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:27:11.668] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:27:11.669] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:27:11.679] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:27:11.679] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:27:11.699] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:27:11.699] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:27:11.706] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:27:11.707] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:27:11.707] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:27:11.708] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:27:11.710] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:27:11.711] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:27:11.711] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:27:11.711] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:27:11.711] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:27:11.712] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:27:11.712] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:28:13.317] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 40.892719ms | method: GET | path: /api/v1/roles/pages/tree | request_id: ce21dc4a-ae0b-487d-92f1-99d3c756ab3c | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:28:19.382] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.500101ms | method: GET | path: /api/v1/roles/pages/tree | request_id: fb52fa33-12c1-4c79-aa50-0a03f8899fe4 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:29:11.001] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 830.917µs | method: GET | path: /api/v1/roles/pages/tree | request_id: d05339b4-d2db-40c7-bd2f-85ca2dbb0dbd | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:31:12.601] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:31:12.601] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:31:12.601] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:12.611] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:12.611] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:12.618] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:12.619] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:12.649] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:12.649] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:12.649] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:31:12.650] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 02:31:12.679] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 02:31:12.681] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:31:12.682] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:31:12.682] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:31:12.682] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:31:12.683] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:31:12.683] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:31:12.683] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:31:28.350] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 02:31:28.350] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 02:31:28.351] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:28.361] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:28.361] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:28.368] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:28.368] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:28.401] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 02:31:28.401] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 02:31:28.401] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 02:31:28.422] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 02:31:28.425] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 02:31:28.425] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 02:31:28.426] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 02:31:28.426] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 02:31:28.426] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 02:31:28.426] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 02:31:28.426] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 02:31:38.529] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.28436ms | method: GET | path: /api/v1/roles/pages/tree | request_id: edf99307-00fc-4c1f-b185-a4f07ea4a459 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:31:41.096] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:31:41.101] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 5.258335ms | method: GET | path: /api/v1/roles/master | request_id: bd18ca0e-8ae9-4a0f-baa6-5011e979cf38 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:33:13.400] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.618078ms | method: GET | path: /api/v1/roles/permissions | request_id: 0c181bc3-b9e2-4155-be82-63d8076e6b2c | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:33:50.472] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 2aec16c0-39b3-4e94-8bc7-a8c1c2abc5b9 | service: service-general | sorts: []
[2026-04-06 02:33:50.475] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.03373ms | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: 2aec16c0-39b3-4e94-8bc7-a8c1c2abc5b9 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:33:58.139] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:page] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: d3b8d494-efdb-45ad-af79-cc285320bce0 | service: service-general | sorts: []
[2026-04-06 02:33:58.141] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.712594ms | method: GET | path: /api/v1/roles/pages/search | query: name=page | request_id: d3b8d494-efdb-45ad-af79-cc285320bce0 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:34:03.191] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:coba] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 51eebff6-32a4-4429-a77b-17b790e5699a | service: service-general | sorts: []
[2026-04-06 02:34:03.194] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.817357ms | method: GET | path: /api/v1/roles/pages/search | query: name=coba | request_id: 51eebff6-32a4-4429-a77b-17b790e5699a | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:34:07.063] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:p] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 191c48fa-b3dd-47e9-b42a-1bd26ea53e59 | service: service-general | sorts: []
[2026-04-06 02:34:07.066] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.692515ms | method: GET | path: /api/v1/roles/pages/search | query: name=p | request_id: 191c48fa-b3dd-47e9-b42a-1bd26ea53e59 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:37:12.402] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 759µs | method: GET | path: /api/v1/roles/pages/tree | request_id: dc78dcff-2360-4237-adc0-57813d73e9c4 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:37:46.787] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 49.703964ms | method: POST | path: /api/v1/auth/refresh | request_id: c03cda79-a09a-4427-954d-214500591cdb | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:38:10.427] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 986.815µs | method: POST | path: /api/v1/auth/login | request_id: 01ffa1ed-cd01-40f5-bce6-a43806edf246 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:38:16.574] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 9.128925ms | method: POST | path: /api/v1/auth/refresh | request_id: e4967078-5a0d-4ef8-be96-1bd26912bcea | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:38:22.556] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 413.617µs | method: POST | path: /api/v1/auth/refresh | request_id: 3445fe79-fb66-4f7c-ade9-5c78fd8a83b3 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:38:29.876] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 369.304µs | method: POST | path: /api/v1/auth/login | request_id: edecfd08-fedf-4088-995f-d89d2287abcb | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:38:38.279] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 422.412µs | method: POST | path: /api/v1/auth/refresh | request_id: c6cbd17c-99e5-4935-aca4-9b7cd3f3ba56 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:41:44.322] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 642.297µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 5a88823c-6b5c-4797-adef-0b7646b8e4d2 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:41:44.336] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 31.477µs | method: OPTIONS | path: /api/v1/auth/refresh | request_id: 2f43a841-6fb1-4a1c-915e-251aeff6896d | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:41:44.347] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 444.27µs | method: POST | path: /api/v1/auth/refresh | request_id: 3a5f1369-ccbc-467b-a273-5998ea07542c | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:42:02.704] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 309.957µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 0749f609-3ada-4b02-868c-4a56c58b3c3d | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:43:37.399] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 567.627µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 6d250388-6b29-4747-b1ee-8d83a957b8e3 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:46:00.772] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:p] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 596e0ef3-0d1e-4af7-9faf-d96db6b42fb5 | service: service-general | sorts: []
[2026-04-06 02:46:00.786] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 14.880909ms | method: GET | path: /api/v1/roles/pages/search | query: name=p | request_id: 596e0ef3-0d1e-4af7-9faf-d96db6b42fb5 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:46:07.524] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:46:07.527] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.823915ms | method: GET | path: /api/v1/roles/master | request_id: 3785694d-12fd-4279-97e9-add867641f9e | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 02:46:37.961] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 444.92µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 42310875-da0a-43f8-81e3-15524d9b075b | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:53:28.011] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 25.332244ms | method: GET | path: /api/v1/roles/pages/tree | request_id: daf0f633-e6bf-4d6a-8e87-2cba41856233 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:53:35.044] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.978665ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 79b11943-d174-49d0-b90d-9230369f934c | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:55:41.698] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.002174ms | method: GET | path: /api/v1/roles/pages/tree | request_id: e82b9622-5009-438d-8b02-11135828cdcf | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:57:19.529] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.390897ms | method: GET | path: /api/v1/roles/pages/tree | request_id: c2c5f058-d1b2-4bd0-b63c-2ff70133ba24 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:58:31.373] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 751.121µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 96150183-f339-4068-a021-d5b85ad7ecc5 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:58:31.420] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 33.363034ms | method: POST | path: /api/v1/auth/refresh | request_id: 3f838c02-b928-4767-a0f8-46fe063e875d | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 02:59:12.502] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 02:59:12.514] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 13.153829ms | method: GET | path: /api/v1/roles/master | request_id: 751ceee5-cb3a-45d5-a215-8cae0bebbeb5 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:01:21.462] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 34.556839ms | method: POST | path: /api/v1/auth/refresh | request_id: ca31f90b-c611-4f85-b48e-3b0f88c5fe78 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:01:27.234] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 38.062781ms | method: POST | path: /api/v1/auth/refresh | request_id: 2244c55b-9017-4189-9f82-13ef16b12193 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:01:38.779] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 29.392184ms | method: POST | path: /api/v1/auth/refresh | request_id: 90b605dc-5d79-4d36-ae4b-de2887feeab5 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:01:56.638] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 472.904µs | method: POST | path: /api/v1/auth/login | request_id: 9b53998e-5b39-4dba-8463-e3d85ce7f694 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:01:58.957] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 395.359µs | method: POST | path: /api/v1/auth/refresh | request_id: 4bb73153-b27a-4d1a-95e2-b52e5b2137a1 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:02.742] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 29.42912ms | method: POST | path: /api/v1/auth/refresh | request_id: 0555a264-b727-4b43-803b-18c10b1f673b | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:04.020] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 22.895525ms | method: POST | path: /api/v1/auth/refresh | request_id: 11bb274c-d74a-488c-add6-4bd5b63be120 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:05.671] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 31.998695ms | method: POST | path: /api/v1/auth/refresh | request_id: f666472f-818d-4af2-9354-f1738066619f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:06.595] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 22.302177ms | method: POST | path: /api/v1/auth/refresh | request_id: 7765114a-90d9-4afa-919e-0d18d857e067 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:07.496] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 20.055173ms | method: POST | path: /api/v1/auth/refresh | request_id: eebb9b09-97f7-4165-a69b-f824bb632755 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:02:11.636] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:02:11.636] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:02:11.636] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:11.644] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:11.644] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:11.651] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:11.651] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:11.667] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:11.667] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:11.667] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:02:11.668] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 03:02:11.693] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 03:02:11.695] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:02:11.695] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:02:11.695] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:02:11.695] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:02:11.695] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:02:11.696] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:02:11.696] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:02:25.223] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:02:25.223] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:02:25.223] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:25.249] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:25.249] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:25.279] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:25.279] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:25.300] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:25.300] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:25.300] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:02:25.302] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 03:02:25.328] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 03:02:25.330] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:02:25.330] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:02:25.330] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:02:25.330] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:02:25.330] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:02:25.330] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:02:25.330] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:02:39.621] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:02:39.622] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:02:39.622] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:39.632] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:39.632] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:39.639] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:39.639] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:39.659] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:02:39.660] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:02:39.660] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:02:39.662] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 03:02:39.688] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 03:02:39.690] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:02:39.691] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:02:39.691] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:02:39.692] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:02:39.692] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:02:39.692] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:02:39.692] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:02:46.585] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 03:02:46.589] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 5.297874ms | method: GET | path: /api/v1/roles/master | request_id: 30ff6666-54f2-4326-bca1-c5714e3b76d3 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:03:41.333] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 44.296343ms | method: GET | path: /api/v1/roles/pages/tree | request_id: dcae65aa-628c-4be4-bc58-7494c8ee50c0 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:03:44.165] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.023624ms | method: GET | path: /api/v1/roles/permissions | request_id: 857419f8-2db0-4e49-9346-de1906764aba | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:04:16.231] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 21.799µs | method: OPTIONS | path: /api/v1/roles/pages/1 | request_id: a539d7f9-d105-4a81-bcb7-2bf075040e31 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:04:16.255] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 4.054312ms | method: GET | path: /api/v1/roles/pages/1 | request_id: 4b832fca-c608-4871-bf44-8f05084e66da | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:04:28.256] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.330299ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 40aab2fa-1df4-4c4d-84e1-b180cc0be5cc | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:05:12.818] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.689752ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 3797ca28-5dbc-4f71-90e1-1c63c6d435ff | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:05:50.461] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.912075ms | method: GET | path: /api/v1/roles/pages/tree | request_id: b1981443-d8f5-40ec-ba4f-fc758e58d64c | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:07:01.815] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 707.204µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 21f4e784-a5b6-420b-8a5d-684727cdad05 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:07:01.884] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 58.932529ms | method: POST | path: /api/v1/auth/refresh | request_id: 96544ec3-ee22-4be6-8bde-ec0bcab6cc84 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:07:30.314] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 323.61µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 4c34b4c2-0326-4fb9-bbdf-8cbe730cb37f | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:08:25.457] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 425.739µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 193892aa-cb29-47f4-b26a-176a6616b4ed | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:08:29.369] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 279.053µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 5f4533a0-06e6-4799-9de6-f3b369319fa6 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:09:34.854] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 13.401317ms | method: GET | path: /api/v1/roles/pages/tree | request_id: a9d09be4-ef18-485f-971b-9f834d2048cd | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:10:29.903] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 572.508µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 1337f050-7a5f-460c-a0d7-17cfd6090714 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:10:29.945] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 31.366858ms | method: POST | path: /api/v1/auth/refresh | request_id: a2a5e6de-11ff-460e-8143-bc993e967392 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:11:16.277] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 375.607µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 6a7b223c-8108-45d5-b5ca-8c0a98f9c468 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:11:45.411] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.33613ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 8eacfcc0-dc88-4a36-9f03-4fc07deeb180 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:12:04.831] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 476.383µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 6dc99d89-9a00-446f-92ec-d4906b1c9b33 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:12:04.986] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 128.707588ms | method: POST | path: /api/v1/auth/refresh | request_id: f359a428-34e1-4702-aa53-a86d9368c6cb | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:13:59.090] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:13:59.090] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:13:59.090] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:13:59.108] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:13:59.108] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:13:59.118] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:13:59.118] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:13:59.126] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:13:59.126] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:13:59.126] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:13:59.127] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-06 03:13:59.129] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:13:59.130] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:13:59.130] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:13:59.130] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:13:59.130] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:13:59.130] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:13:59.130] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:14:03.985] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.337691ms | method: GET | path: /api/v1/roles/permissions | request_id: f7ffd44a-841a-48d3-9072-35e29763967a | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:14:07.129] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 486.964µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 013602c8-7c5b-4abc-92cc-64b6481cb4eb | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:14:07.691] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.211208ms | method: POST | path: /api/v1/auth/login | request_id: 0ecd8355-73b5-4fc4-b58b-2990ce1f9843 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:14:12.819] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 8.573267ms | method: GET | path: /api/v1/roles/permissions | request_id: f4514a43-f313-46de-aa77-fc395b188209 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:14:25.220] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.486507ms | method: GET | path: /api/v1/roles/permissions/1 | request_id: 45898b15-e223-4172-b127-d506a655ddee | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:14:25.414] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 342.049µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 95d86f73-32eb-4742-b9f6-6272eec2c3f4 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:14:35.408] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.995948ms | method: GET | path: /api/v1/roles/permissions/role/superadmin | request_id: 658f693f-66c0-46fd-9d59-86b0f3b778b0 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:14:47.243] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 25.098045ms | method: GET | path: /api/v1/roles/permissions/role/1 | request_id: 05e294f2-2ede-4b0b-a9ef-d5aed3a985a8 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:15:01.594] [DEBUG] Cache hit for Role Permission GetList                   | 📍 service.go:67 | environment: debug | ⚙️ service/internal/master/role/permission.(*service).GetList | key: role_permission_list:page:1:size:10 | service: service-general
[2026-04-06 03:15:01.594] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 765.97µs | method: GET | path: /api/v1/roles/permissions | request_id: 0d0d6ac1-fbde-400d-93ae-40b9a97aa3ba | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:15:01.827] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 635.324µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 1855dce0-f6ca-4dff-9611-c8305b038456 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:15:01.884] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 40.653469ms | method: POST | path: /api/v1/auth/refresh | request_id: 8508df8c-fe11-44d2-a960-020192291f0f | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:15:53.707] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 24.534223ms | method: POST | path: /api/v1/auth/refresh | request_id: faf2e51e-34a1-4c7c-a88f-a90c1c2dd6c5 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:16:21.761] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 501.17µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 91bfdec5-914d-429b-82bc-d03f34cdf930 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:16:54.963] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 656.574µs | method: GET | path: /api/v1/roles/pages/tree | request_id: b6004887-acca-494a-b888-a0ceae4ef647 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:16:54.998] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 19.065014ms | method: POST | path: /api/v1/auth/refresh | request_id: 77331890-a1d7-467b-9ff4-1d802eb1be18 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:17:51.153] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 401.361µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 16bcb170-34cc-4544-8c3e-9c5fb56b234b | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:17:57.305] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 422.838µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 381ff740-6b59-491c-9a85-0eb086d7c8bf | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:14.288] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 10.704637ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 86a6448a-9c23-46c0-b25d-b88b22adc592 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:29.786] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 75.012µs | method: OPTIONS | path: /api/v1/roles/pages/tree | request_id: e2c7e9fd-782c-4ae4-b99c-cecaf0d8fd26 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:29.813] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 692.28µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 63eace30-bf7d-4729-9b6c-d8ca8a077c02 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:29.970] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 21.549138ms | method: POST | path: /api/v1/auth/refresh | request_id: 869768b5-6e7a-423f-b519-0019ccdf4076 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:30.279] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.618134ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 2fab4565-ba29-41c0-8dd3-e6efcc159928 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:18:54.002] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.408199ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 213b762d-e35c-4b0b-842c-22f3e0834391 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:19:01.214] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 13.040006ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 78c096c2-5dd6-406e-a6b5-667afb5e1dde | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:19:12.122] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.538057ms | method: GET | path: /api/v1/roles/pages/tree | request_id: f3b2933f-e0d9-4fd0-ab7e-80591e1f1db9 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:20:11.235] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.199977ms | method: GET | path: /api/v1/roles/pages/tree | request_id: d5a74d37-6e69-4dfb-9dd7-f37b59e4cac4 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:20:42.252] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:p] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 8a39a794-2ba3-4a04-a63a-3432d4888344 | service: service-general | sorts: []
[2026-04-06 03:20:42.257] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 5.626384ms | method: GET | path: /api/v1/roles/pages/search | query: name=p | request_id: 8a39a794-2ba3-4a04-a63a-3432d4888344 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:20:51.309] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: d330bf28-7adf-42e4-844d-e39c64e1ed3e | service: service-general | sorts: []
[2026-04-06 03:20:51.318] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 9.718909ms | method: GET | path: /api/v1/roles/pages/search | request_id: d330bf28-7adf-42e4-844d-e39c64e1ed3e | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:21:02.456] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.929309ms | method: GET | path: /api/v1/roles/pages/tree | request_id: f80767a8-38bd-42c4-8b55-3eb82ae1bc8a | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:21:14.481] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.742125ms | method: GET | path: /api/v1/roles/pages | query: filter= | request_id: 6b073d57-54ed-4f49-9c83-4ac5a720b6eb | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:21:20.276] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 25.602µs | method: OPTIONS | path: /api/v1/roles/pages | query: filter=tes | request_id: beca3136-e8cf-4f30-8542-842c143207ab | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:21:20.285] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:0e43c0356c7b0edb8709d9e3a9ded96ebe4e2bf019fec58ab78fa4d402ccb287 | service: service-general
[2026-04-06 03:21:20.286] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 745.455µs | method: GET | path: /api/v1/roles/pages | query: filter=tes | request_id: 9d22f51a-de39-4059-a59c-5014364934f1 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:21:22.020] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:0e43c0356c7b0edb8709d9e3a9ded96ebe4e2bf019fec58ab78fa4d402ccb287 | service: service-general
[2026-04-06 03:21:22.020] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 681.466µs | method: GET | path: /api/v1/roles/pages | query: filter= | request_id: 9d5bf4c6-f102-412e-b867-aeedcc3c4e69 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:21:28.831] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:21:28.831] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:21:28.831] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:21:28.840] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:21:28.840] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:21:28.862] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:21:28.862] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:21:28.870] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:21:28.870] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:21:28.870] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:21:28.871] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 03:21:28.873] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:21:28.874] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:21:28.874] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:21:28.874] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:21:28.875] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:21:28.875] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:21:28.875] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:21:48.917] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.560309ms | method: GET | path: /api/v1/roles/permissions | request_id: 0d4186db-9637-4745-9ce7-90f36efea6e2 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:22:19.519] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 114.238µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name= | request_id: 92d51259-96ff-41a8-b350-1d135340fe27 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:19.557] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: d111aec0-0fcc-4316-ad43-1afe47520837 | service: service-general | sorts: []
[2026-04-06 03:22:19.557] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 03:22:19.557] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 32.185196ms | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: d111aec0-0fcc-4316-ad43-1afe47520837 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:23.396] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 26.575µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name=das | request_id: 0e140ce7-1b7d-4253-a401-31dfbeb862c4 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:23.404] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:das] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 0d618400-7bb6-48fb-906d-cd51f5cf583f | service: service-general | sorts: []
[2026-04-06 03:22:23.409] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 6.350294ms | method: GET | path: /api/v1/roles/pages/search | query: name=das | request_id: 0d618400-7bb6-48fb-906d-cd51f5cf583f | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:26.086] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.228643ms | method: GET | path: /api/v1/roles/permissions | request_id: cc1d1b9b-7f66-4ee4-832b-c1620698ba24 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:22:26.170] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 41.676µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name=coba | request_id: 6b32aee9-6871-4ce5-866f-08af852bac85 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:26.179] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:coba] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: f09f331c-a2f0-4c0b-afe4-02bda424ba64 | service: service-general | sorts: []
[2026-04-06 03:22:26.181] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.808031ms | method: GET | path: /api/v1/roles/pages/search | query: name=coba | request_id: f09f331c-a2f0-4c0b-afe4-02bda424ba64 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:28.089] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 36df4c27-f1b5-461d-97a5-a7d93cad8905 | service: service-general | sorts: []
[2026-04-06 03:22:28.089] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 03:22:28.090] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 791.891µs | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: 36df4c27-f1b5-461d-97a5-a7d93cad8905 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:28.844] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 23.828µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name=inde | request_id: fbe8f261-15a2-4a06-a83f-0309ddc8f34c | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:28.851] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:inde] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: dc3289ac-1b4f-40cf-b850-45a945f30b98 | service: service-general | sorts: []
[2026-04-06 03:22:28.854] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.67668ms | method: GET | path: /api/v1/roles/pages/search | query: name=inde | request_id: dc3289ac-1b4f-40cf-b850-45a945f30b98 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:29.409] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 36.954µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name=index | request_id: 75efcbc8-62aa-4621-a1f5-45820d18d956 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:29.419] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:index] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 0657297e-efac-4de0-be54-2862dd26a225 | service: service-general | sorts: []
[2026-04-06 03:22:29.422] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.692296ms | method: GET | path: /api/v1/roles/pages/search | query: name=index | request_id: 0657297e-efac-4de0-be54-2862dd26a225 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:30.607] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: bf92b4e5-7ea1-4e6d-8ba5-f304c5f14c61 | service: service-general | sorts: []
[2026-04-06 03:22:30.607] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 03:22:30.608] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 963.395µs | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: bf92b4e5-7ea1-4e6d-8ba5-f304c5f14c61 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:22:48.835] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 03:22:48.838] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.323501ms | method: GET | path: /api/v1/roles/master | request_id: 2ad637cd-cf5f-4cfa-ad0b-250f4344583a | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:22:53.114] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.063402ms | method: GET | path: /api/v1/roles/permissions | request_id: f93d3db1-ef97-478b-8dce-792ee7086643 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:22:54.597] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.524727ms | method: GET | path: /api/v1/roles/pages/tree | request_id: a6e78d8f-5e45-4350-b426-1150a0c7ef08 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:02.698] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.205742ms | method: GET | path: /api/v1/roles/pages/tree | request_id: f2c31c35-cea2-435a-890e-768597fd6a7d | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:08.430] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.079504ms | method: GET | path: /api/v1/roles/permissions | request_id: 7657e8e0-3698-4c44-b297-c7def5044d1e | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:23:25.256] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 34.404µs | method: OPTIONS | path: /api/v1/roles/pages | request_id: e6673222-0ba8-42d2-a045-727b76e4b24e | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:25.283] [DEBUG] Database query executed                                 | 📍 database.go:174 | duration_ms: 3.97754ms | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Trace | request_id: cd7dde45-012d-4648-8a4f-ffd7d24abc50 | rows: 1 | service: service-general | sql: INSERT INTO "role_access"."rol_pages" ("name","icon","url","level","sort","parent","active","created_at","updated_at") VALUES ('Tes','database-bold','/tes',1,1,NULL,true,'2026-04-06 03:23:25.281','2026-04-06 03:23:25.281') RETURNING "id"
[2026-04-06 03:23:25.284] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 5.203897ms | method: POST | path: /api/v1/roles/pages | request_id: cd7dde45-012d-4648-8a4f-ffd7d24abc50 | service: service-general | status: 201 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:25.366] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.773024ms | method: GET | path: /api/v1/roles/pages/tree | request_id: ec9a81b4-5384-449d-b977-0601e580901e | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:28.053] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 40.475µs | method: OPTIONS | path: /api/v1/roles/pages/11 | request_id: eaa69d81-f747-45a5-b5cd-acdbbe3d21ca | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:28.089] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.297745ms | method: GET | path: /api/v1/roles/pages/11 | request_id: 471b5570-c1d4-4abf-9d08-524c13bdb8ed | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:23:41.571] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 872.781µs | method: GET | path: /api/v1/roles/permissions | request_id: e5d57b6c-1c7f-4bcd-abe3-0807b7822ea5 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:26:05.840] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 03:26:05.840] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 03:26:05.840] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:26:05.851] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:26:05.851] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:26:05.858] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:26:05.858] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:26:05.878] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 03:26:05.878] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 03:26:05.878] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 03:26:05.879] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 03:26:05.908] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 03:26:05.911] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 03:26:05.911] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 03:26:05.911] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 03:26:05.912] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 03:26:05.912] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 03:26:05.912] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 03:26:05.912] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 03:26:11.031] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.999049ms | method: GET | path: /api/v1/roles/permissions | request_id: 8b5d8631-f14e-4e2c-b235-1671b17c6de3 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:26:37.850] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.662068ms | method: GET | path: /api/v1/roles/pages/11 | request_id: b2434d6a-bb9f-4d2d-8557-2144439b731c | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:26:37.909] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 49.65132ms | method: POST | path: /api/v1/auth/refresh | request_id: db2fe985-9966-4179-8268-250a0df9a982 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:26:45.861] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 350.658µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 8d0bbbc0-7154-4e88-8274-b395a9ac7d10 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:27:46.502] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 704.268µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 79086a40-5113-4b8d-bbb8-d471e1614db3 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 03:40:33.625] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 840.22µs | method: GET | path: /api/v1/roles/master | request_id: a3412487-7493-4147-bde2-3dc956beb6b3 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:40:37.868] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 756.513µs | method: POST | path: /api/v1/auth/login | request_id: bb035990-5aab-4e4c-9ae2-a1529b9c3ec2 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:40:40.959] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 03:40:40.973] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 14.525289ms | method: GET | path: /api/v1/roles/master | request_id: 48b25fba-d062-4099-8490-f7079fb4d94b | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:41:09.323] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 03:41:09.325] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.317155ms | method: GET | path: /api/v1/roles/master | request_id: 0b46ba5b-e231-46b3-be4c-67d6d7a3328f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 03:41:24.719] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.183402ms | method: GET | path: /api/v1/roles/permissions | request_id: 1e1c73bf-ccb2-42c3-b8b2-1cdebc9c6dc0 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:00:42.817] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 452.215µs | method: GET | path: /api/v1/bpjs/vclaim/peserta/nik/3271021802050001 | request_id: b2e8aec8-b4bd-471e-998b-6331e849811f | service: service-general | status: 404 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:00:57.251] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 300.665µs | method: GET | path: /api/v1/satusehat/reference/auth/token | request_id: 60cfd5b3-c0f0-438d-aada-bef1c84872f2 | service: service-general | status: 404 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:01:04.532] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 541.119µs | method: GET | path: /api/v1/roles/master | request_id: fcbb7a72-e622-454f-8ccf-fe36a83788fb | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:01:16.003] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 434.14µs | method: POST | path: /api/v1/auth/login | request_id: a5c29a4a-cc3e-4355-9cb5-3d9667e3fc63 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:33:19.696] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 2.068924ms | method: GET | path: /api/v1/roles/permissions | request_id: 2dec8205-9932-4621-b382-b0d6ed8cd240 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:33:23.412] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 375.183µs | method: POST | path: /api/v1/auth/login | request_id: f1c90429-a21b-46bd-b413-039bfb571fe3 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:33:27.579] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 04:33:27.591] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 12.675303ms | method: GET | path: /api/v1/roles/master | request_id: b50be7e5-6565-4870-bfd1-a173e1a8f956 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:33:31.464] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.042816ms | method: GET | path: /api/v1/roles/permissions | request_id: d8c1c813-52b2-4bcc-b0b0-a9f70ba3e44f | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:33:53.519] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.216186ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: 42be5be7-35ad-4ee2-8abf-e7caea2638a8 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:34:24.296] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 32.419348ms | method: GET | path: /api/v1/roles/pages/tree | request_id: e9f952fe-4e91-49e0-952d-084c646a18fb | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:34:36.497] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.272268ms | method: GET | path: /api/v1/roles/pages/11 | request_id: b4172221-3891-4b48-84dc-863aa87d3a97 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:34:39.913] [DEBUG] Database query executed                                 | 📍 database.go:174 | duration_ms: 2.875545ms | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Trace | request_id: 5ff8939e-1ef6-4006-94d2-689f971f156f | rows: 1 | service: service-general | sql: UPDATE "role_access"."rol_pages" SET "name"='Tes',"icon"='database-bold',"url"='/tes',"level"=1,"sort"=1,"parent"=NULL,"active"=false,"created_at"='2026-04-06 03:23:25.281',"updated_at"='2026-04-06 04:34:39.911' WHERE "id" = 11
[2026-04-06 04:34:39.913] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 5.666133ms | method: PUT | path: /api/v1/roles/pages/11 | request_id: 5ff8939e-1ef6-4006-94d2-689f971f156f | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:34:39.968] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.635467ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 0730dfc6-4f77-409d-9fc3-9ca2475535cb | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:34:50.753] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.252362ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 4018fddd-0ace-4de5-a817-77dd00d1959b | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 04:45:14.943] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 804.74µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 6097f994-4264-4cd1-b87d-d867da292ea0 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:45:14.980] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 25.623848ms | method: POST | path: /api/v1/auth/refresh | request_id: 937c421d-1eaf-4daa-934a-ff3a7463b40f | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:45:15.076] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 946.037µs | method: GET | path: /api/v1/auth/info | request_id: b48a8182-da93-4cd3-af24-03621f0b0741 | service: service-general | status: 200 | user_agent: node
[2026-04-06 04:45:15.113] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 11.744371ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 7022b40c-ce55-484f-9399-fa44c82a1264 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 04:45:24.956] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.891451ms | method: GET | path: /api/v1/roles/pages/tree | request_id: f76b5e74-ec48-45a7-a8d1-dd9de49608fd | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 05:38:42.995] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 60.571µs | method: OPTIONS | path: /api/v1/roles/pages/tree | request_id: aa11ac40-67ba-40dd-ab72-3e1de0e4bafb | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 05:38:43.005] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.922442ms | method: GET | path: /api/v1/roles/pages/tree | request_id: c7d61913-b777-4880-ae4e-a8c32bc1f46b | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 05:38:43.029] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 11.050622ms | method: POST | path: /api/v1/auth/refresh | request_id: 3003f2fd-2925-494d-bca2-1ad19453df55 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:22:34.905] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.674703ms | method: GET | path: /api/v1/roles/master | request_id: fca90ce8-0d4b-4f1d-b8a3-d33c72f7fc35 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:22:37.749] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 435.687µs | method: POST | path: /api/v1/auth/login | request_id: 1d1d1c14-53b5-4320-9a01-9aa0562dfa51 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:22:41.910] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 8.799364ms | method: GET | path: /api/v1/roles/permissions | request_id: 939dfb08-12a0-4172-bfd3-b0d5d20633a0 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:30:11.991] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 540.791µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 79aeed36-aa4d-472b-abbe-59b39187bba0 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:21.307] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 290.059µs | method: GET | path: /api/v1/roles/pages/tree | request_id: a4cf25b6-7059-4e73-a20a-5c8d92843f6f | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:31.176] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 29.26095ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 1617e500-81ae-4c3a-875e-b2368c2e8505 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:34.150] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 24.844µs | method: OPTIONS | path: /api/v1/roles/pages/search | query: name= | request_id: 1db8d5c0-28ed-463e-836f-9b6e246dd4c4 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:34.158] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: dcb17708-ef7c-4870-b279-7a7995d219b9 | service: service-general | sorts: []
[2026-04-06 06:30:34.162] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 4.567976ms | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: dcb17708-ef7c-4870-b279-7a7995d219b9 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:37.620] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.690893ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 81a6ab86-1933-4d67-b913-ec159ae4fac8 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:41.170] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 34.558µs | method: OPTIONS | path: /api/v1/roles/pages/6 | request_id: 4bcc9b0e-00fc-415f-b46d-91a419f7a616 | service: service-general | status: 204 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:41.180] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.152763ms | method: GET | path: /api/v1/roles/pages/6 | request_id: 6fc07160-5f8b-4435-9882-875f1b0fa5e9 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:41.216] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: b7b014ae-cf96-4787-b24a-12fba288b5d4 | service: service-general | sorts: []
[2026-04-06 06:30:41.216] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 06:30:41.216] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 858.458µs | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: b7b014ae-cf96-4787-b24a-12fba288b5d4 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:41.221] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 9d3bad49-263f-4d5b-9d68-c13e1e76e29a | service: service-general | sorts: []
[2026-04-06 06:30:41.222] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 06:30:41.222] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 644.001µs | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: 9d3bad49-263f-4d5b-9d68-c13e1e76e29a | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:30:46.074] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 06:30:46.075] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 06:30:46.075] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:30:46.085] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:30:46.085] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:30:46.104] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:30:46.104] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:30:46.112] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:30:46.113] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:30:46.113] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 06:30:46.114] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 06:30:46.116] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 06:30:46.116] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 06:30:46.116] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 06:30:46.117] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 06:30:46.117] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 06:30:46.117] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 06:30:46.117] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 06:31:12.411] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 749.537µs | method: GET | path: /api/v1/roles/pages/tree | query: active=true | request_id: fe7e3ac1-cb53-468e-9a54-3d658166ac26 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:31:17.460] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 964.399µs | method: POST | path: /api/v1/auth/login | request_id: 768747fa-e48f-4c80-9664-46b9004b0a8d | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:31:21.771] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 6.736057ms | method: GET | path: /api/v1/roles/pages/tree | query: active=true | request_id: b45e232f-31ac-4217-afa2-502fa6623180 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:31:30.652] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.259771ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 3500bd8f-cafe-4a1d-9191-d7c9afb8295b | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:31:38.753] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 06:31:38.757] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 4.236154ms | method: GET | path: /api/v1/roles/master | request_id: e54ef031-ad7b-4ad1-aaf8-5c9b86eb4be2 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:32:55.081] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 30.358974ms | method: GET | path: /api/v1/roles/pages/tree | request_id: eeeeac3c-05a2-45c9-a528-0e33079350cc | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:33:10.213] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 3.397392ms | method: GET | path: /api/v1/roles/pages/tree | request_id: a58bb210-825d-4f93-af05-5557c4ffe4ad | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:33:27.462] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 34c3bf98-bb52-4be5-9537-0ca3329ada53 | service: service-general | sorts: []
[2026-04-06 06:33:27.462] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:18178c9cefd7c975d14dd9827c4d0ab51f503b2a86a8708920543f4a9c544ab4 | service: service-general
[2026-04-06 06:33:27.462] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.154237ms | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: 34c3bf98-bb52-4be5-9537-0ca3329ada53 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:33:43.637] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 06:33:43.646] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 9.026663ms | method: GET | path: /api/v1/roles/master | request_id: 3f1d1319-f6ab-4eec-9734-4f33473deb7b | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:37:49.427] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 06:37:49.427] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 06:37:49.427] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:37:49.437] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:37:49.437] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:37:49.457] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:37:49.457] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:37:49.466] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:37:49.467] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:37:49.467] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 06:37:49.468] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-06 06:37:49.471] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 06:37:49.471] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 06:37:49.471] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 06:37:49.472] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 06:37:49.472] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 06:37:49.472] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 06:37:49.472] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 06:37:53.784] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.454775ms | method: GET | path: /api/v1/roles/permissions | request_id: c0f36b38-5f5a-440a-96ee-76bb992597fb | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:37:56.576] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.072659ms | method: POST | path: /api/v1/auth/login | request_id: 529c3743-15a9-4629-88a9-6bb1cb1333ab | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:37:59.099] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 4.607057ms | method: GET | path: /api/v1/roles/permissions | request_id: 75c83868-d2e0-46af-bf38-46233bce0218 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:40:33.162] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 06:40:33.162] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 06:40:33.162] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:40:33.183] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:40:33.183] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:40:33.194] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:40:33.194] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:40:33.202] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:40:33.202] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:40:33.202] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 06:40:33.203] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-06 06:40:33.205] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 06:40:33.206] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 06:40:33.206] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 06:40:33.206] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 06:40:33.206] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 06:40:33.207] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 06:40:33.207] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 06:40:33.486] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 8.36675ms | method: GET | path: /api/v1/roles/permissions | request_id: 6fbb16a4-01b0-4ecc-b880-243f558da5f5 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:41:39.760] [DEBUG] Cache hit for Role Permission GetList                   | 📍 service.go:67 | environment: debug | ⚙️ service/internal/master/role/permission.(*service).GetList | key: role_permission_list:page:1:size:10 | service: service-general
[2026-04-06 06:41:39.760] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.194227ms | method: GET | path: /api/v1/roles/permissions | request_id: c896505e-57cf-4fd8-b5f7-81d3d87f3766 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:42:15.015] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 1.284205ms | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: dbc5dd4d-c801-4bfe-8798-d0ca1190ef43 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:42:15.071] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 47.040979ms | method: POST | path: /api/v1/auth/refresh | request_id: fd003bdb-9d9c-47f5-9a33-b3e8963a870c | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:42:15.222] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 11.472675ms | method: GET | path: /api/v1/auth/info | request_id: 1a16328f-f6df-4a9d-a27d-124c81f248de | service: service-general | status: 200 | user_agent: node
[2026-04-06 06:42:15.294] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[] | ⚙️ service/internal/infrastructure/transport/http/handlers/main/master/roles.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 03a2a95c-79b2-4bf6-b0e3-8aa0bd775659 | service: service-general | sorts: []
[2026-04-06 06:42:15.298] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 4.989443ms | method: GET | path: /api/v1/roles/pages/search | query: name= | request_id: 03a2a95c-79b2-4bf6-b0e3-8aa0bd775659 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:42:49.670] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 4.157622ms | method: GET | path: /api/v1/roles/pages/tree | request_id: a39f8d4b-3691-4596-9c97-427ec91155b5 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:43:40.618] [DEBUG] Cache hit for Role Permission GetList                   | 📍 service.go:67 | environment: debug | ⚙️ service/internal/master/role/permission.(*service).GetList | key: role_permission_list:page:1:size:10 | service: service-general
[2026-04-06 06:43:40.618] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 928.984µs | method: GET | path: /api/v1/roles/permissions | request_id: 7e4bb37b-f244-4390-a5c5-53880618fef2 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:44:19.838] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 3.253138ms | method: GET | path: /api/v1/roles/permissions/1 | request_id: c6580447-840e-45d2-b73d-10559d73e90e | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:45:34.730] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 14.371867ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 6a1ac94e-71dc-4030-98ae-87d09f55a241 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:48:24.966] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 750.353µs | method: GET | path: /api/v1/roles/pages/tree | request_id: 067b7471-43af-4821-b940-73a18ed549b8 | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:48:25.011] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 34.30851ms | method: POST | path: /api/v1/auth/refresh | request_id: c58be703-0340-46da-9742-15ac789d4bb2 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:48:25.030] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 787.348µs | method: GET | path: /api/v1/auth/info | request_id: e89c6fdf-5991-4075-9c08-df453ec3d117 | service: service-general | status: 200 | user_agent: node
[2026-04-06 06:48:25.046] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 2.485705ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 0a52135c-35d0-4a9d-8dfc-5561e94c200a | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:53:29.745] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 603.123µs | method: GET | path: /api/v1/roles/pages/tree | request_id: de9b126d-c23e-48e4-acef-da828a860b7b | service: service-general | status: 401 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:53:29.786] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 25.899539ms | method: POST | path: /api/v1/auth/refresh | request_id: a4b68c57-17bb-4e1e-ae28-7878804ef7b6 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:53:29.806] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 551.349µs | method: GET | path: /api/v1/auth/info | request_id: 91f5d7db-09c1-423c-8bb2-012ee3c2479c | service: service-general | status: 200 | user_agent: node
[2026-04-06 06:53:29.832] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 172.15.150.210 | latency: 11.244631ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 00fc11bf-18b0-4ddc-87a0-a404f3d95008 | service: service-general | status: 200 | user_agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36
[2026-04-06 06:53:37.549] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 06:53:37.549] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 06:53:37.549] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:53:37.570] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:53:37.570] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:53:37.580] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:53:37.580] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:53:37.587] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 06:53:37.587] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 06:53:37.587] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 06:53:37.588] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-06 06:53:37.591] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 06:53:37.591] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 06:53:37.591] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 06:53:37.592] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 06:53:37.592] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 06:53:37.592] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 06:53:37.592] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 06:53:42.589] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.098331ms | method: GET | path: /api/v1/roles/permissions/1 | request_id: c34277ad-a7cd-4c6c-810d-6e4d93cb5e29 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:53:45.891] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 937.187µs | method: POST | path: /api/v1/auth/login | request_id: 8c28d9dd-dddf-4914-a12b-e38beb6cb917 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:53:47.694] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 7.282922ms | method: GET | path: /api/v1/roles/permissions/role/1 | request_id: be4c3cd3-6d37-4ba0-8c48-9c757d878a14 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:53:51.176] [INFO ] Built search query                                      | 📍 repository.go:204 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-06 06:53:51.183] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 7.073414ms | method: GET | path: /api/v1/roles/master | request_id: 67f62a11-2b47-48e6-81cc-f4593b0a86af | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 06:53:53.827] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 5.581026ms | method: GET | path: /api/v1/roles/permissions | request_id: 97285e86-83a9-4560-a350-f5315e9d5074 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 07:13:15.052] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-06 07:13:15.052] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-06 07:13:15.052] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 07:13:15.063] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 07:13:15.063] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 07:13:15.070] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 07:13:15.070] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 07:13:15.096] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-06 07:13:15.097] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-06 07:13:15.097] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-06 07:13:15.098] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-06 07:13:15.127] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-06 07:13:15.130] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-06 07:13:15.131] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-06 07:13:15.131] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-06 07:13:15.131] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-06 07:13:15.131] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-06 07:13:15.132] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-06 07:13:15.132] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-06 07:13:17.169] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.14074ms | method: GET | path: /api/v1/roles/permissions | request_id: ade667b3-3a05-4888-81a9-f01b8c617727 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 07:35:34.362] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 609.66µs | method: GET | path: /api/v1/roles/permissions/role/1 | request_id: cfa4e0b8-6699-4b1c-8153-cb012ef4faa2 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 07:35:37.962] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 1.144628ms | method: POST | path: /api/v1/auth/login | request_id: 57022bba-bfc0-4324-9761-0c0891513880 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 07:35:40.846] [DEBUG] Cache hit for Role Permission Tree                      | 📍 service.go:702 | environment: debug | ⚙️ service/internal/master/role/permission.(*service).GetRolePermissionTreeRole | key: permission_tree:1:all | service: service-general
[2026-04-06 07:35:40.846] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 841.758µs | method: GET | path: /api/v1/roles/permissions/role/1 | request_id: 95e35efb-5e30-41c0-9fdb-b1cc4a5894a8 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 07:35:45.320] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 14.22232ms | method: GET | path: /api/v1/roles/permissions | request_id: 7522f075-4d7b-4f11-a50c-05a7454aea70 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-06 08:05:40.121] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.150.106 | latency: 655.729µs | method: GET | path: /api/v1/roles/permissions | request_id: fddc2383-041d-49f3-a742-f8cfe3dd4063 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
