[2026-04-05 02:25:13.040] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:25:13.040] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:25:13.041] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:25:13.051] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:25:13.051] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:25:13.074] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:25:13.074] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:25:13.082] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:25:13.083] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:25:13.083] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:25:13.084] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:25:13.088] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:25:13.088] [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-05 02:25:13.088] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:25:13.088] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:25:13.088] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:25:13.088] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:25:13.089] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:31:59.244] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:31:59.244] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:31:59.244] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:31:59.253] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:31:59.253] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:31:59.261] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:31:59.261] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:31:59.281] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:31:59.281] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:31:59.281] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:31:59.282] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:31:59.315] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:31:59.317] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:31:59.317] [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-05 02:31:59.317] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:31:59.318] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:31:59.318] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:31:59.318] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:31:59.318] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:32:32.251] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:32:32.252] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:32:32.252] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:32.259] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:32.259] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:32.266] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:32.266] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:32.287] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:32.287] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:32.287] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:32:32.289] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:32:32.318] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:32:32.320] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:32:32.320] [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-05 02:32:32.320] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:32:32.321] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:32:32.321] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:32:32.321] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:32:32.321] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:32:39.926] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:32:39.926] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:32:39.926] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:39.934] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:39.934] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:39.941] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:39.941] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:39.959] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:39.960] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:39.960] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:32:39.961] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:32:39.991] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:32:39.992] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:32:39.993] [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-05 02:32:39.993] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:32:39.993] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:32:39.993] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:32:39.993] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:32:39.993] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:32:43.280] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:32:43.280] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:32:43.281] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:43.289] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:43.289] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:43.296] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:43.296] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:43.316] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:32:43.316] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:32:43.316] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:32:43.317] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:32:43.345] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:32:43.346] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:32:43.347] [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-05 02:32:43.347] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:32:43.347] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:32:43.347] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:32:43.347] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:32:43.347] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:34:24.890] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:34:24.891] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:34:24.891] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:34:24.899] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:34:24.899] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:34:24.918] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:34:24.918] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:34:24.926] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:34:24.926] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:34:24.926] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:34:24.927] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:34:24.928] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:34:24.928] [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-05 02:34:24.928] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:34:24.929] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:34:24.929] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:34:24.929] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:34:24.929] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:41:41.128] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:41:41.128] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:41:41.128] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:41:41.137] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:41:41.137] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:41:41.145] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:41:41.145] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:41:41.168] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:41:41.169] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:41:41.169] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:41:41.170] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:41:41.199] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:41:41.201] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:41:41.201] [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-05 02:41:41.202] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:41:41.202] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:41:41.202] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:41:41.202] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:41:41.203] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:48:56.099] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:48:56.100] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:48:56.100] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:48:56.110] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:48:56.110] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:48:56.118] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:48:56.118] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:48:56.142] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:48:56.142] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:48:56.142] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:48:56.143] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:48:56.171] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:48:56.173] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:48:56.173] [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-05 02:48:56.173] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:48:56.174] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:48:56.174] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:48:56.174] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:48:56.174] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:49:52.317] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:49:52.317] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:49:52.317] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:49:52.325] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:49:52.325] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:49:52.332] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:49:52.332] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:49:52.351] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:49:52.351] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:49:52.351] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:49:52.353] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 02:49:52.383] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:49:52.384] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:49:52.385] [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-05 02:49:52.385] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:49:52.386] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:49:52.386] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:49:52.386] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:49:52.386] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 02:55:43.886] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 02:55:43.886] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 02:55:43.886] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:55:43.894] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:55:43.894] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:55:43.901] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:55:43.901] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:55:43.921] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 02:55:43.921] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 02:55:43.922] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 02:55:43.922] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 02:55:43.924] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 02:55:43.924] [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-05 02:55:43.924] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 02:55:43.924] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 02:55:43.924] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 02:55:43.925] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 02:55:43.925] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:02:06.095] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:02:06.095] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:02:06.095] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:02:06.114] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:02:06.114] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:02:06.124] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:02:06.124] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:02:06.131] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:02:06.131] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:02:06.131] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:02:06.132] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:02:06.134] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:02:06.134] [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-05 03:02:06.134] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:02:06.134] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:02:06.135] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:02:06.135] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:02:06.135] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:09:44.485] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:09:44.485] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:09:44.485] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:09:44.503] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:09:44.504] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:09:44.513] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:09:44.513] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:09:44.521] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:09:44.521] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:09:44.521] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:09:44.522] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:09:44.523] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:09:44.523] [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-05 03:09:44.523] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:09:44.524] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:09:44.524] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:09:44.524] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:09:44.524] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:15:07.826] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:15:07.826] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:15:07.826] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:15:07.838] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:15:07.838] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:15:07.849] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:15:07.849] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:15:07.873] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:15:07.873] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:15:07.873] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:15:07.874] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:15:07.900] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:15:07.902] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:15:07.902] [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-05 03:15:07.902] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:15:07.903] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:15:07.903] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:15:07.903] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:15:07.903] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:16:02.142] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:16:02.142] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:16:02.142] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:16:02.150] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:16:02.150] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:16:02.157] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:16:02.157] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:16:02.177] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:16:02.177] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:16:02.177] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:16:02.179] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:16:02.207] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:16:02.209] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:16:02.209] [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-05 03:16:02.209] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:16:02.209] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:16:02.209] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:16:02.210] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:16:02.210] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:34:33.486] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:34:33.486] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:34:33.486] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:34:33.497] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:34:33.497] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:34:33.504] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:34:33.504] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:34:33.527] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:34:33.527] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:34:33.527] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:34:33.529] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:34:33.531] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:34:33.532] [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-05 03:34:33.532] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:34:33.533] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:34:33.533] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:34:33.533] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:34:33.533] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:38:00.613] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:38:00.613] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:38:00.613] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:00.621] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:00.621] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:00.641] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:00.641] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:00.649] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:00.649] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:00.649] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:38:00.650] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:38:00.652] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:38:00.652] [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-05 03:38:00.652] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:38:00.653] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:38:00.653] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:38:00.653] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:38:00.653] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:38:02.772] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:38:02.772] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:38:02.772] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:02.791] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:02.791] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:02.799] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:02.799] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:02.807] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:02.807] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:02.807] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:38:02.808] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:38:02.809] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:38:02.810] [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-05 03:38:02.810] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:38:02.810] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:38:02.810] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:38:02.811] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:38:02.811] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:38:44.519] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:38:44.520] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:38:44.520] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:44.530] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:44.530] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:44.537] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:44.537] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:44.561] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:38:44.561] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:38:44.561] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:38:44.562] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:38:44.563] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:38:44.564] [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-05 03:38:44.564] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:38:44.564] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:38:44.564] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:38:44.564] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:38:44.564] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:41:43.681] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:41:43.681] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:41:43.681] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:43.689] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:43.689] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:43.696] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:43.697] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:43.710] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:43.710] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:43.711] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:41:43.712] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:41:43.742] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:41:43.744] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:41:43.744] [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-05 03:41:43.744] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:41:43.745] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:41:43.745] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:41:43.745] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:41:43.745] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:41:48.948] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:41:48.948] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:41:48.949] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:48.958] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:48.958] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:48.965] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:48.965] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:48.984] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:41:48.984] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:41:48.984] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:41:48.986] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:41:49.013] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:41:49.014] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:41:49.014] [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-05 03:41:49.014] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:41:49.015] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:41:49.015] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:41:49.015] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:41:49.015] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:43:19.877] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:43:19.877] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:43:19.877] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:19.885] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:19.885] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:19.907] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:19.907] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:19.916] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:19.916] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:19.916] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:43:19.917] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:43:19.919] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:43:19.920] [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-05 03:43:19.920] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:43:19.920] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:43:19.921] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:43:19.921] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:43:19.921] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:43:26.343] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:43:26.343] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:43:26.343] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:26.351] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:26.351] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:26.358] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:26.358] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:26.377] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:26.377] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:26.378] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:43:26.379] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:43:26.406] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:43:26.407] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:43:26.408] [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-05 03:43:26.408] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:43:26.408] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:43:26.408] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:43:26.408] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:43:26.409] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:43:56.705] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:43:56.706] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:43:56.706] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:56.713] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:56.713] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:56.722] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:56.722] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:56.741] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:43:56.741] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:43:56.741] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:43:56.742] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:43:56.768] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:43:56.769] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:43:56.770] [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-05 03:43:56.770] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:43:56.770] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:43:56.770] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:43:56.770] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:43:56.771] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:44:11.465] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:44:11.465] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:44:11.465] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:11.474] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:11.474] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:11.482] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:11.482] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:11.501] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:11.502] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:11.502] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:44:11.503] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:44:11.531] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:44:11.533] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:44:11.533] [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-05 03:44:11.533] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:44:11.534] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:44:11.534] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:44:11.534] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:44:11.534] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:44:18.038] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:44:18.039] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:44:18.039] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:18.048] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:18.048] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:18.073] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:18.073] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:18.080] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:44:18.080] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:44:18.081] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:44:18.082] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:44:18.083] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:44: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-05 03:44:18.084] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:44:18.084] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:44:18.084] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:44:18.085] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:44:18.085] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:45:03.086] [INFO ] Application starting                                    | 📍 main.go:74 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:45:03.087] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:89 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:45:03.087] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:45:03.094] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:45:03.094] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:45:03.102] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:45:03.102] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:45:03.165] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:45:03.165] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:45:03.165] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:45:03.166] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:45:03.191] [WARNI] Database migration completed with issues                | 📍 main.go:105 | 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-05 03:45:03.192] [INFO ] Cache initialized                                       | 📍 main.go:130 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:45:03.192] [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-05 03:45:03.192] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:45:03.193] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:39 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:45:03.193] [INFO ] Application started successfully                        | 📍 main.go:321 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:45:03.193] [INFO ] gRPC Server running                                     | 📍 main.go:287 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:45:03.193] [INFO ] REST API running                                        | 📍 main.go:259 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:47:35.206] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:47:35.206] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:47:35.206] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:47:35.218] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:47:35.218] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:47:35.225] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:47:35.225] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:47:35.247] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:47:35.247] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:47:35.247] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:47:35.249] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:47:35.278] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:47:35.280] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:47:35.281] [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-05 03:47:35.281] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:47:35.282] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:47:35.282] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:47:35.282] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:47:35.282] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:49:13.396] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:49:13.396] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:49:13.396] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:13.415] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:13.415] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:13.423] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:13.423] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:13.431] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:13.431] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:13.431] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:49:13.432] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 03:49:13.434] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:49:13.434] [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-05 03:49:13.434] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:49:13.435] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:49:13.435] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:49:13.435] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:49:13.435] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:49:53.124] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:49:53.124] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:49:53.124] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:53.150] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:53.150] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:53.159] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:53.159] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:53.168] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:49:53.168] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:49:53.168] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:49:53.169] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 03:49:53.172] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:49:53.172] [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-05 03:49:53.172] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:49:53.173] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:49:53.173] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:49:53.173] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:49:53.174] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:50:39.810] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:50:39.810] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:50:39.810] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:39.819] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:39.819] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:39.827] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:39.827] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:39.847] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:39.847] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:39.847] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:50:39.849] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:50:39.877] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:50:39.879] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:50:39.879] [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-05 03:50:39.879] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:50:39.879] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:50:39.879] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:50:39.879] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:50:39.880] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:50:57.682] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:50:57.682] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:50:57.682] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:57.690] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:57.690] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:57.698] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:57.698] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:57.720] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:50:57.720] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:50:57.720] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:50:57.721] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:50:57.749] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:50:57.751] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:50:57.751] [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-05 03:50:57.751] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:50:57.751] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:50:57.751] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:50:57.751] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:50:57.752] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:51:07.934] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:51:07.934] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:51:07.934] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:07.945] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:07.945] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:07.954] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:07.954] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:07.977] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:07.977] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:07.977] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:51:07.979] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:51:08.008] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:51:08.011] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:51:08.012] [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-05 03:51:08.012] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:51:08.013] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:51:08.013] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:51:08.013] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:51:08.013] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:51:39.355] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:51:39.356] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:51:39.356] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:39.377] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:39.377] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:39.389] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:39.390] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:39.399] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:51:39.399] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:51:39.399] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:51:39.400] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 03:51:39.403] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:51:39.403] [INFO ] Creating authentication providers                       | auth_type: hybrid | 📍 provider.go:69 | environment: debug | fallback_to: jwt | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | keycloak_enabled: true | keycloak_issuer: https://auth.rssa.top/realms/sandbox | service: service-general | static_tokens_len: 4
[2026-04-05 03:51:39.403] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:51:39.404] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:51:39.404] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:51:39.404] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:51:39.404] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:56:58.591] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:56:58.591] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:56:58.592] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:56:58.600] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:56:58.601] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:56:58.608] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:56:58.608] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:56:58.627] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:56:58.627] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:56:58.627] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:56:58.628] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:56:58.652] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:56:58.653] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:56:58.654] [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-05 03:56:58.654] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:56:58.654] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:56:58.654] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:56:58.654] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:56:58.654] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:57:32.266] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:57:32.267] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:57:32.267] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:57:32.274] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:57:32.274] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:57:32.283] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:57:32.283] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:57:32.304] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:57:32.304] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:57:32.305] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:57:32.306] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:57:32.335] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:57:32.337] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:57:32.337] [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-05 03:57:32.337] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:57:32.338] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:57:32.338] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:57:32.338] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:57:32.338] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:58:10.238] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:58:10.238] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:58:10.238] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:10.246] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:10.246] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:10.265] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:10.265] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:10.272] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:10.272] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:10.273] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:58:10.274] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 03:58:10.275] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:58:10.275] [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-05 03:58:10.275] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:58:10.276] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:58:10.276] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:58:10.276] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:58:10.276] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:58:28.076] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:58:28.076] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:58:28.076] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:28.085] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:28.085] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:28.107] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:28.107] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:28.115] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:58:28.115] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:58:28.115] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:58:28.116] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 03:58:28.118] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:58:28.118] [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-05 03:58:28.118] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:58:28.118] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:58:28.118] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:58:28.118] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 03:58:28.119] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:59:09.499] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 03:59:09.500] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 03:59:09.500] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:59:09.508] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:59:09.508] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:59:09.515] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:59:09.515] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:59:09.534] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 03:59:09.534] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 03:59:09.534] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 03:59:09.535] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 03:59:09.563] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 03:59:09.564] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 03:59:09.565] [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-05 03:59:09.565] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 03:59:09.565] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 03:59:09.565] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 03:59:09.565] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 03:59:09.565] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:02:03.949] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:02:03.949] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:02:03.949] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:03.957] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:03.957] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:03.966] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:03.966] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:03.988] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:03.988] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:03.988] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:02:03.990] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 04:02:03.991] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:02:03.992] [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-05 04:02:03.992] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:02:03.992] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:02:03.992] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:02:03.992] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:02:03.992] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:02:37.387] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:02:37.388] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:02:37.388] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:37.411] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:37.411] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:37.422] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:37.422] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:37.430] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:02:37.430] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:02:37.430] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:02:37.431] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 04:02:37.434] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:02:37.434] [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-05 04:02:37.434] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:02:37.435] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:02:37.435] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:02:37.435] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:02:37.435] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:03:02.412] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:03:02.412] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:03:02.412] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:02.422] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:02.422] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:02.443] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:02.444] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:02.451] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:02.451] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:02.451] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:03:02.452] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:03:02.478] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:03:02.481] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:03:02.482] [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-05 04:03:02.482] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:03:02.482] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:03:02.482] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:03:02.482] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:03:02.483] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:03:06.666] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:03:06.667] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:03:06.667] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:06.676] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:06.676] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:06.684] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:06.684] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:06.704] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:06.704] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:06.704] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:03:06.705] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 04:03:06.707] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:03:06.708] [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-05 04:03:06.708] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:03:06.708] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:03:06.708] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:03:06.708] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:03:06.708] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:03:51.854] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:03:51.854] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:03:51.854] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:51.864] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:51.864] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:51.872] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:51.872] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:51.893] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:03:51.893] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:03:51.893] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:03:51.895] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:03:51.923] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:03:51.925] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:03:51.926] [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-05 04:03:51.926] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:03:51.926] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:03:51.926] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:03:51.926] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:03:51.926] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:05:01.934] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:05:01.934] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:05:01.934] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:05:01.941] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:05:01.941] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:05:01.949] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:05:01.949] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:05:01.969] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:05:01.969] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:05:01.969] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:05:01.970] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:05:01.999] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:05:02.001] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:05:02.001] [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-05 04:05:02.001] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:05:02.001] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:05:02.002] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:05:02.002] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:05:02.002] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:06:40.219] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:06:40.220] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:06:40.220] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:06:40.229] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:06:40.229] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:06:40.250] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:06:40.250] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:06:40.257] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:06:40.257] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:06:40.257] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:06:40.258] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:06:40.286] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:06:40.289] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:06:40.290] [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-05 04:06:40.290] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:06:40.290] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:06:40.290] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:06:40.290] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:06:40.290] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:08:39.983] [WARNI] HTTP Request                                            | 📍 middleware.go:175 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.831577ms | method: GET | path: /api/v1/roles/master | request_id: 1c155032-8e19-4cb2-962f-a5276bde349f | service: service-general | status: 401 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:08:49.370] [INFO ] HTTP Request                                            | 📍 middleware.go:177 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 987.47µs | method: POST | path: /api/v1/auth/login | request_id: 609b5fbe-c8c9-4cd3-a89d-c200dcf1cfba | service: service-general | status: 200 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:08:54.406] [INFO ] Built search query                                      | 📍 repository.go:207 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[{Column:DeletedAt Operator:_null Value:<nil> Options:map[]}] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:CreatedAt Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:08:54.406] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 994.242µs | method: GET | path: /api/v1/roles/master | request_id: 2c7c1815-64d4-43c9-8757-df72e09de224 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:11:12.682] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:11:12.682] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:11:12.682] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:12.695] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:12.695] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:12.716] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:12.716] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:12.723] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:12.723] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:12.723] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:11:12.725] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 04:11:12.727] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:11:12.728] [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-05 04:11:12.728] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:11:12.728] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:11:12.728] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:11:12.728] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:11:12.728] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:11:13.332] [INFO ] Built search query                                      | 📍 repository.go:207 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[{Column:CreatedAt Operator:_null Value:<nil> Options:map[]}] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:CreatedAt Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:11:13.334] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.572843ms | method: GET | path: /api/v1/roles/master | request_id: fabd4f0e-c3a3-469f-88b0-a1af0a692a65 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:11:36.720] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:11:36.720] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:11:36.720] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:36.730] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:36.730] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:36.739] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:36.739] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:36.759] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:11:36.759] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:11:36.759] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:11:36.760] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 04:11:36.763] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:11:36.763] [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-05 04:11:36.763] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:11:36.764] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:11:36.764] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:11:36.764] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:11:36.764] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:11:37.126] [INFO ] Built search query                                      | 📍 repository.go:207 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:CreatedAt Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:11:37.129] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.014142ms | method: GET | path: /api/v1/roles/master | request_id: a552c70e-c3b0-4f00-80bf-ae04aa5cb65d | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:12:03.042] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:12:03.042] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:12:03.042] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:03.052] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:03.052] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:03.071] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:03.071] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:03.079] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:03.079] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:03.079] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:12:03.081] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for default: failed to ensure migration table: failed to create migrations table: ERROR: no schema has been selected to create in (SQLSTATE 3F000) | ⚙️ main.main | service: service-general
[2026-04-05 04:12:03.082] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:12:03.082] [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-05 04:12:03.082] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:12:03.082] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:12:03.082] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:12:03.083] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:12:03.083] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:12:43.826] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:12:43.826] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:12:43.826] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:43.836] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:43.836] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:43.844] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:43.844] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:43.865] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:12:43.865] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:12:43.865] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:12:43.866] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:12:43.896] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:12:43.898] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:12:43.899] [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-05 04:12:43.899] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:12:43.899] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:12:43.899] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:12:43.900] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:12:43.900] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:12:44.347] [INFO ] Built search query                                      | 📍 repository.go:207 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[{Column:created_at Operator:_null Value:<nil> Options:map[]}] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:12:44.347] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 1.46534ms | method: GET | path: /api/v1/roles/master | request_id: 0e8cb601-9a32-49e7-8d84-f10dd5f8763a | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:14:29.892] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:14:29.893] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:14:29.893] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:29.912] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:29.913] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:29.921] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:29.921] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:29.928] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:29.928] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:29.928] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:14:29.929] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:14:29.956] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:14:29.958] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:14:29.959] [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-05 04:14:29.959] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:14:29.959] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:14:29.959] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:14:29.959] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:14:29.959] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:14:36.198] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:CreatedAt Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:14:36.201] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 4.298507ms | method: GET | path: /api/v1/roles/master | request_id: 599fcad7-b9b2-4057-9f66-088932c756c5 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:14:58.963] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:14:58.964] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:14:58.964] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:58.973] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:58.973] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:58.980] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:58.980] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:59.001] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:14:59.001] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:14:59.001] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:14:59.002] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:14:59.029] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:14:59.031] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:14:59.032] [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-05 04:14:59.032] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:14:59.033] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:14:59.033] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:14:59.033] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:14:59.033] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:14:59.066] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:CreatedAt Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:14:59.069] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 3.101737ms | method: GET | path: /api/v1/roles/master | request_id: a032ba69-ac5c-410e-81a9-86db06b1bb24 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
[2026-04-05 04:15:55.421] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:15:55.422] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:15:55.422] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:15:55.431] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:15:55.431] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:15:55.452] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:15:55.452] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:15:55.460] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:15:55.460] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:15:55.460] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:15:55.461] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 04:15:55.463] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:15:55.464] [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-05 04:15:55.464] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:15:55.465] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:15:55.465] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:15:55.465] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:15:55.465] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:16:01.329] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:16:01.330] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:16:01.330] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:01.350] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:01.350] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:01.359] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:01.359] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:01.366] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:01.366] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:01.366] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:16:01.367] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 04:16:01.369] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:16:01.370] [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-05 04:16:01.370] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:16:01.370] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:16:01.371] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:16:01.371] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:16:01.371] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:16:04.356] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:16:04.356] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:16:04.356] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:04.366] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:04.366] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:04.386] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:04.386] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:04.393] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:04.393] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:04.393] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:16:04.394] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for farmasi: failed to ensure migration table: failed to create migrations table: mssql: Incorrect syntax near 'Migrations'. | ⚙️ main.main | service: service-general
[2026-04-05 04:16:04.396] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:16:04.397] [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-05 04:16:04.397] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:16:04.397] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:16:04.398] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:16:04.398] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:16:04.398] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:16:10.640] [INFO ] Application starting                                    | 📍 main.go:75 | environment: debug | ⚙️ main.main | log_level: debug | service: service-general
[2026-04-05 04:16:10.641] [DEBUG] Config loaded                                           | cache_enabled: true | 📍 main.go:90 | database_count: 3 | environment: debug | ⚙️ main.main | server_mode: debug | service: service-general
[2026-04-05 04:16:10.641] [INFO ] Initializing database service with GORM as primary abstraction... | 📍 database.go:192 | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:10.650] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:10.650] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: simrs | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:10.658] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:10.658] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: default | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:10.679] [INFO ] Successfully connected and configured GORM for database | 📍 database.go:384 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).addDatabase | service: service-general
[2026-04-05 04:16:10.679] [INFO ] Successfully connected to database                      | 📍 database.go:203 | db_name: farmasi | environment: debug | ⚙️ service/internal/infrastructure/database.New.func1 | service: service-general
[2026-04-05 04:16:10.679] [INFO ] Found migration files to execute                        | 📍 database.go:532 | count: 4 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).runSQLMigrationsForDB | service: service-general
[2026-04-05 04:16:10.681] [DEBUG] Migrations table already exists                         | 📍 database.go:1371 | environment: debug | ⚙️ service/internal/infrastructure/database.(*service).ensureMigrationTable | service: service-general
[2026-04-05 04:16:10.709] [WARNI] Database migration completed with issues                | 📍 main.go:106 | environment: debug | ❌ ERROR: sql migration failed for simrs: migration failed at file internal/infrastructure/database/sql/00001_role_pages.sql: failed to execute SQL command: -- Trigger untuk update updated_at
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP, error: ERROR: syntax error at or near "$" (SQLSTATE 42601) | ⚙️ main.main | service: service-general
[2026-04-05 04:16:10.711] [INFO ] Cache initialized                                       | 📍 main.go:131 | environment: debug | ⚙️ main.main | host: redis | port: 6379 | service: service-general
[2026-04-05 04:16:10.712] [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-05 04:16:10.712] [INFO ] Keycloak provider added for hybrid                      | 📍 provider.go:97 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/middleware.(*ProviderFactory).CreateProviders | service: service-general
[2026-04-05 04:16:10.713] [INFO ] Registered RolPermission gRPC service                   | 📍 server.go:35 | environment: debug | ⚙️ service/internal/infrastructure/transport/grpc/servers.NewGRPCServer | service: service-general
[2026-04-05 04:16:10.713] [INFO ] Application started successfully                        | 📍 main.go:327 | environment: debug | ⚙️ main.main | service: service-general
[2026-04-05 04:16:10.713] [INFO ] gRPC Server running                                     | 📍 main.go:293 | environment: debug | ⚙️ main.main.func2 | port: 8095 | service: service-general
[2026-04-05 04:16:10.713] [INFO ] REST API running                                        | 📍 main.go:266 | environment: debug | ⚙️ main.main.func1 | port: 8094 | service: service-general
[2026-04-05 04:16:11.225] [INFO ] Built search query                                      | 📍 repository.go:201 | environment: debug | ⚙️ service/internal/master/role/master.(*repository).Search | request: {Fields:[{Expression:* Alias: WindowFunction:<nil>}] From:role_access.rol_master Aliases: Joins:[] Filters:[{Filters:[] LogicOp:}] GroupBy:[] Having:[] Unions:[] CTEs:[] Sort:[{Column:created_at Order:DESC}] Limit:10 Offset:0 WindowFunctions:[] JsonOperations:[]} | service: service-general
[2026-04-05 04:16:11.228] [ERROR] HTTP Request                                            | 📍 middleware.go:173 | environment: debug | ⚙️ service/internal/infrastructure/transport/http/servers.NewHTTPServer.LoggingMiddleware.func3 | ip: 10.10.123.84 | latency: 4.49506ms | method: GET | path: /api/v1/roles/master | request_id: 68fd4587-b5d7-49ba-91d7-a9f9a1238d74 | service: service-general | status: 500 | user_agent: Apidog/1.0.0 (https://apidog.com)
