[2026-04-03 14:03:54.584] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 14:03:54.585] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 14:03:54.585] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 14:03:54.585] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 14:03:54.585] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 14:03:54.608] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 14:03:54.608] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 14:03:54.622] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 14:03:54.622] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 14:03:54.631] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 14:03:54.631] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 14:03:54.631] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 14:03:54.632] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 14:03:54.636] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 14:03:54.637] [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-03 14:03:54.637] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 14:03:54.637] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 14:03:54.637] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 14:03:54.637] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 14:03:54.638] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 15:19:31.719] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 15:19:31.719] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 15:19:31.720] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 15:19:31.735] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 15:19:31.735] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 15:19:31.735] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 15:19:31.736] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 15:19:31.758] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 15:19:31.758] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 15:19:31.766] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 15:19:31.766] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 15:19:31.766] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 15:19:31.768] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 15:19:31.773] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 15:19:31.774] [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-03 15:19:31.774] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 15:19:31.775] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 15:19:31.775] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 15:19:31.776] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 15:19:31.776] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 22:07:54.608] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 22:07:54.609] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 22:07:54.609] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:07:54.625] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:07:54.625] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:07:54.633] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:07:54.633] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:07:54.634] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 22:07:54.634] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 22:07:54.657] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:07:54.657] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:07:54.657] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 22:07:54.659] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 22:07:54.699] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 22:07:54.702] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 22:07:54.702] [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-03 22:07:54.703] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 22:07:54.703] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 22:07:54.703] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 22:07:54.703] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 22:07:54.703] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 22:09:18.017] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 22:09:18.017] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 22:09:18.017] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:09:18.017] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 22:09:18.017] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 22:09:18.038] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:09:18.038] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:09:18.049] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:09:18.049] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:09:18.057] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 22:09:18.057] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 22:09:18.057] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 22:09:18.059] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 22:09:18.081] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 22:09:18.084] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 22:09:18.084] [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-03 22:09:18.085] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 22:09:18.085] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 22:09:18.085] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 22:09:18.085] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 22:09:18.085] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 22:26:18.781] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.576273ms | method: GET | path: /health | request_id: 125ea2d9-9a40-47f2-9995-9cebd10b3f41 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 22:28:06.795] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.168906ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: 42b80e64-273f-4909-ad1c-f685b6651775 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 22:28:11.437] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.397646ms | method: POST | path: /api/v1/auth/login | request_id: 033e727b-1f3f-4203-8249-4c38fde8231f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 22:28:13.738] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 22:28:13.751] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 13.914107ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: c878dc03-fea2-457c-a6ce-646eda0016ea | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 22:30:59.086] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 22:30:59.086] [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-03 22:30:59.086] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.121127ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: 56a18575-7448-4d01-b4a1-faa9998a2256 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 22:31:06.550] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 22:31:06.550] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[Name:Coba] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: affbd782-3ec9-41aa-bba8-3df74b336f8c | service: service-general | sorts: []
[2026-04-03 22:31:06.554] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 4.564387ms | method: GET | path: /api/v1/roles/pages/search | query: Name=Coba | request_id: affbd782-3ec9-41aa-bba8-3df74b336f8c | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:07:07.915] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:07:07.915] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[Name:Coba] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: ee42e26e-a8ac-4b7e-b9ea-bc683b80ef52 | service: service-general | sorts: []
[2026-04-03 23:07:07.928] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 14.549086ms | method: GET | path: /api/v1/roles/pages/search | query: Name=Coba | request_id: ee42e26e-a8ac-4b7e-b9ea-bc683b80ef52 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:10:45.680] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:10:45.680] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:10:45.680] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:10:45.690] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:10:45.690] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:10:45.698] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:10:45.698] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:10:45.698] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:10:45.698] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:10:45.718] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:10:45.718] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:10:45.718] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:10:45.720] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 23:10:45.745] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:10:45.747] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:10:45.748] [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-03 23:10:45.748] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:10:45.748] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:10:45.748] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:10:45.749] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:10:45.749] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:11:10.404] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:11:10.404] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:11:10.404] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:11:10.414] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:11:10.414] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:11:10.414] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:11:10.414] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:11:10.434] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:11:10.434] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:11:10.442] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:11:10.442] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:11:10.442] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:11:10.443] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:11:10.446] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:11:10.446] [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-03 23:11:10.446] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:11:10.447] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:11:10.447] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:11:10.447] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:11:10.447] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:11:14.488] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:11:14.488] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[name:Coba] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: e19e878c-99b6-4ecd-99d4-e2d0fcd965d0 | service: service-general | sorts: []
[2026-04-03 23:11:14.490] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 2.297603ms | method: GET | path: /api/v1/roles/pages/search | query: name=Coba | request_id: e19e878c-99b6-4ecd-99d4-e2d0fcd965d0 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:14:31.609] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:14:31.610] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:14:31.610] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:14:31.619] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:14:31.619] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:14:31.627] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:14:31.627] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:14:31.628] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:14:31.628] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:14:31.647] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:14:31.648] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:14:31.648] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:14:31.649] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 23:14:31.674] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:14:31.676] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:14:31.676] [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-03 23:14:31.677] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:14:31.677] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:14:31.677] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:14:31.677] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:14:31.677] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:14:32.296] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:14:32.296] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[name:Coba] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: e83d9bdc-84ea-4046-8410-289359e15363 | service: service-general | sorts: []
[2026-04-03 23:14:32.302] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 7.195202ms | method: GET | path: /api/v1/roles/pages/search | query: name=Coba | request_id: e83d9bdc-84ea-4046-8410-289359e15363 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:14:40.717] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:14:40.717] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[name:page] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: ece63bbb-78c0-47d6-b770-5906e97a9fba | service: service-general | sorts: []
[2026-04-03 23:14:40.720] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.935696ms | method: GET | path: /api/v1/roles/pages/search | query: name=page | request_id: ece63bbb-78c0-47d6-b770-5906e97a9fba | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:14:48.823] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:14:48.824] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 9655c15e-9931-41c9-a81d-c81dcddba65f | service: service-general | sorts: []
[2026-04-03 23:14:48.826] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 2.575486ms | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: 9655c15e-9931-41c9-a81d-c81dcddba65f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:15:01.600] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:15:01.600] [INFO ] Search request                                          | 📍 rol_pages_handler.go:116 | environment: debug | filters: map[level:2 name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 8e87ff2c-dcd9-46fc-a673-9aab5fc53ebc | service: service-general | sorts: []
[2026-04-03 23:15:01.602] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 2.157553ms | method: GET | path: /api/v1/roles/pages/search | query: name=login&level=2 | request_id: 8e87ff2c-dcd9-46fc-a673-9aab5fc53ebc | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:16:42.015] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:16:42.016] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:16:42.016] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:16:42.016] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:16:42.016] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:16:42.036] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:16:42.036] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:16:42.045] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:16:42.045] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:16:42.052] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:16:42.052] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:16:42.052] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:16:42.054] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:16:42.056] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:16:42.057] [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-03 23:16:42.057] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:16:42.057] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:16:42.057] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:16:42.057] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:16:42.058] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:16:51.834] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:16:51.835] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:2 name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: bca3e2a1-37a0-4919-8688-a9f5bb5830ed | service: service-general | sorts: []
[2026-04-03 23:16:51.841] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 7.611136ms | method: GET | path: /api/v1/roles/pages/search | query: name=login&level=2 | request_id: bca3e2a1-37a0-4919-8688-a9f5bb5830ed | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:16:58.081] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:16:58.081] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:2] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 9c82d926-13f0-4371-9f36-65c378e6e397 | service: service-general | sorts: []
[2026-04-03 23:16:58.085] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 4.119287ms | method: GET | path: /api/v1/roles/pages/search | query: level=2 | request_id: 9c82d926-13f0-4371-9f36-65c378e6e397 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:17:06.317] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:17:06.318] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:1] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 1154c825-b5e0-4f14-9d2a-abcc273224de | service: service-general | sorts: []
[2026-04-03 23:17:06.320] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 2.856662ms | method: GET | path: /api/v1/roles/pages/search | query: level=1 | request_id: 1154c825-b5e0-4f14-9d2a-abcc273224de | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:17:12.891] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:17:12.891] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:3] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 14487cd0-f3c1-4d89-85f2-75abf485eb2f | service: service-general | sorts: []
[2026-04-03 23:17:12.893] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 2.249283ms | method: GET | path: /api/v1/roles/pages/search | query: level=3 | request_id: 14487cd0-f3c1-4d89-85f2-75abf485eb2f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:17:26.749] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:17:26.750] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:3 name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 23200ba6-0f3f-4a83-9c3b-b9e160d9103a | service: service-general | sorts: []
[2026-04-03 23:17:26.813] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 64.078466ms | method: GET | path: /api/v1/roles/pages/search | query: name=login&level=3 | request_id: 23200ba6-0f3f-4a83-9c3b-b9e160d9103a | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:17:32.140] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:17:32.140] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[level:3 name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 555c81b4-a606-49de-9e5a-40c0327856f7 | service: service-general | sorts: []
[2026-04-03 23:17:32.141] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:cec284b3278175080179d3a0641ae06982edc994059e5803fcdaf9a6dd4c5531 | service: service-general
[2026-04-03 23:17:32.141] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 851.559µs | method: GET | path: /api/v1/roles/pages/search | query: name=login&level=3 | request_id: 555c81b4-a606-49de-9e5a-40c0327856f7 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:17:35.748] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:17:35.748] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: 3dc3f149-5677-4734-91a7-27593ac9863f | service: service-general | sorts: []
[2026-04-03 23:17:35.748] [DEBUG] Cache hit for Role Pages Search                         | 📍 service.go:97 | environment: debug | ⚙️ service/internal/master/role/pages.(*service).Search | key: role_pages_search:98e87cb9ba7d3f5f1614ea7e7ae5d8c52713d6bb7cf60779409eceb4ea5eb56c | service: service-general
[2026-04-03 23:17:35.748] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 715.236µs | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: 3dc3f149-5677-4734-91a7-27593ac9863f | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:19:27.613] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:19:27.614] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:19:27.614] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:19:27.623] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:19:27.624] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:19:27.631] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:19:27.631] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:19:27.631] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:19:27.631] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:19:27.653] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:19:27.653] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:19:27.653] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:19:27.654] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 23:19:27.685] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:19:27.687] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:19:27.687] [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-03 23:19:27.687] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:19:27.688] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:19:27.688] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:19:27.688] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:19:27.688] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:30:02.382] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.150719ms | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: a6576fbd-9d25-40fa-81ea-abdcbdb85686 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:43:30.269] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:43:30.269] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:43:30.270] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:30.279] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:30.279] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:30.286] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:30.287] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:30.287] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:43:30.287] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:43:30.303] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:30.303] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:30.303] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:43:30.304] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 23:43:30.330] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:43:30.332] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:43:30.333] [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-03 23:43:30.333] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:43:30.334] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:43:30.334] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:43:30.334] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:43:30.334] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:43:32.781] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-03 23:43:32.781] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-03 23:43:32.782] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:187 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:32.790] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:32.790] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:32.798] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:32.798] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:32.798] [INFO ] replacing callback `gorm:create` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:43:32.798] [INFO ] replacing callback `gorm:update` from /app/internal/infrastructure/database/database.go:453
 | 📍 database.go:134 | environment: debug | ⚙️ service/internal/infrastructure/database.(*gormLoggerAdapter).Info | service: service-general
[2026-04-03 23:43:32.819] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:379 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-03 23:43:32.819] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-03 23:43:32.819] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-03 23:43:32.820] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-03 23:43:32.848] [WARNI] Database migration completed with issues                | 📍 main.go:93 | 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-03 23:43:32.850] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-03 23:43:32.850] [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-03 23:43:32.850] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-03 23:43:32.851] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-03 23:43:32.851] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-03 23:43:32.851] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-03 23:43:32.852] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-03 23:43:44.037] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 960.489µs | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: 2a7157a5-35ce-49e7-aef2-654aa363d543 | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:43:47.123] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 971.881µs | method: POST | path: /api/v1/auth/login | request_id: 02477feb-4a2f-4edd-aefe-def347cd7f51 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:43:49.365] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:43:49.365] [INFO ] Search request                                          | 📍 rol_pages_handler.go:118 | environment: debug | filters: map[name:login] | ⚙️ service/internal/infrastructure/transport/http/handlers.(*RolPagesHandler).Search | limit: 10 | page: 1 | request_id: f692856c-9baa-4d7d-9ca7-8dbe054b678d | service: service-general | sorts: []
[2026-04-03 23:43:49.371] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 6.746188ms | method: GET | path: /api/v1/roles/pages/search | query: name=login | request_id: f692856c-9baa-4d7d-9ca7-8dbe054b678d | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:44:40.792] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:44:40.795] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.001336ms | method: GET | path: /api/v1/roles/pages | query: filter | request_id: 89b52283-2428-493b-88b1-25679e8b7d74 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:44:43.406] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:44:43.409] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.488125ms | method: GET | path: /api/v1/roles/pages/tree | request_id: 7562e51e-8611-4583-9761-605e9712b0ea | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-03 23:44:59.492] [WARNI] Unexpected signing method                               | alg: HS256 | 📍 provider.go:239 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*KeycloakAuthProvider).ValidateToken.func1 | service: service-general
[2026-04-03 23:44:59.495] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.45836ms | method: GET | path: /api/v1/roles/pages/6 | request_id: b381228e-c8af-4503-829f-dd057066fc34 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
