[2026-04-04 00:02:15.668] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-04 00:02:15.668] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-04 00:02:15.668] [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-04 00:02:15.678] [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-04 00:02:15.678] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:15.686] [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-04 00:02:15.686] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:15.686] [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-04 00:02:15.686] [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-04 00:02:15.706] [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-04 00:02:15.706] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:15.706] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-04 00:02:15.707] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-04 00:02:15.733] [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-04 00:02:15.736] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-04 00:02:15.736] [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-04 00:02:15.737] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-04 00:02:15.737] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-04 00:02:15.737] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-04 00:02:15.737] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-04 00:02:15.737] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-04 00:02:19.486] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-04 00:02:19.486] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-04 00:02:19.486] [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-04 00:02:19.494] [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-04 00:02:19.494] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:19.501] [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-04 00:02:19.501] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:19.502] [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-04 00:02:19.502] [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-04 00:02:19.524] [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-04 00:02:19.524] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:19.524] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-04 00:02:19.525] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-04 00:02:19.548] [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-04 00:02:19.550] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-04 00:02:19.551] [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-04 00:02:19.551] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-04 00:02:19.551] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-04 00:02:19.551] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-04 00:02:19.552] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-04 00:02:19.552] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-04 00:02:21.322] [INFO ] Application starting                                    | 📍 main.go:62 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-04 00:02:21.322] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:77 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-04 00:02:21.322] [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-04 00:02:21.332] [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-04 00:02:21.332] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:21.339] [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-04 00:02:21.339] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:21.340] [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-04 00:02:21.340] [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-04 00:02:21.359] [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-04 00:02:21.359] [INFO ] Successfully connected to database                      | 📍 database.go:198 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-04 00:02:21.360] [INFO ] Found migration files to execute                        | 📍 database.go:527 | count: 3 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-04 00:02:21.361] [DEBUG] Migrations table already exists                         | 📍 database.go:1366 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-04 00:02:21.385] [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-04 00:02:21.388] [INFO ] Cache initialized                                       | 📍 main.go:118 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-04 00:02:21.388] [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-04 00:02:21.388] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-04 00:02:21.389] [INFO ] REST API running                                        | 📍 main.go:184 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-04 00:02:21.389] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-04 00:02:21.389] [INFO ] Application started successfully                        | 📍 main.go:246 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-04 00:02:21.389] [INFO ] gRPC Server running                                     | 📍 main.go:212 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-04 00:02:28.051] [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-04 00:02:28.057] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 7.283691ms | method: GET | path: /api/v1/roles/pages/6 | request_id: 8ad6636c-463c-41ee-a5a9-91c4ee5c5554 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-04 00:02:32.726] [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-04 00:02:32.727] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 559.139µs | method: GET | path: /api/v1/auth/info | request_id: 08bd12d1-bcfb-40b7-b102-10b05ed882a7 | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
