https://pastein.ru/t/_1S
Загрузка данных
dmitriev-aal@VDI-Dmitriev-A:~$ kubectl describe pod ms-certificate-registry-76c95b9686-4pkr5
Name: ms-certificate-registry-76c95b9686-4pkr5
Namespace: isys-ndbo-rc
Priority: 0
Priority Class Name: rumsk1
Service Account: default
Node: afs1asd-wl-215/10.21.182.17
Start Time: Tue, 06 Oct 2026 10:45:30 +0300
Labels: app=ms-certificate-registry
chart=base-1.15.3
fullname=ms-certificate-registry
heritage=Helm
isys=ndbo-rc
pod-template-hash=76c95b9686
psvc=ms-certificate-registry
release=ms-certificate-registry
security.istio.io/tlsMode=istio
service.istio.io/canonical-name=ms-certificate-registry
service.istio.io/canonical-revision=1.40.0-rc1
version=1.40.0-rc1
workload.topology.app.farm/zone=rumsk1
Annotations: checksum/configMapsEnv: a77678188691d10490266e6c20a2f8eb5d57063b4e31fdeee7e8b48f681afce4
checksum/secretEnv: 8a413b60cc752855dbb7a7aa897a30d29ea3021f7a719d8500edf7983ec8a9a5
cni.projectcalico.org/containerID: 6a86659be5ebca5d8dfc54555afa48d6970070855d15628c8ef16792de7d25eb
cni.projectcalico.org/podIP: 100.79.156.38/32
cni.projectcalico.org/podIPs: 100.79.156.38/32
inject.istio.io/templates: sidecar,custom
kubectl.kubernetes.io/default-container: app
kubectl.kubernetes.io/default-logs-container: app
kubectl.kubernetes.io/restartedAt: 2025-09-10T00:50:53+03:00
prometheus.io/path: /stats/prometheus
prometheus.io/port: 15020
prometheus.io/scrape: true
sidecar.istio.io/proxyCPU: 100m
sidecar.istio.io/proxyCPULimit: 400m
sidecar.istio.io/proxyMemory: 64Mi
sidecar.istio.io/proxyMemoryLimit: 412Mi
sidecar.istio.io/status:
{"initContainers":["istio-init"],"containers":["istio-proxy"],"volumes":["istio-certs","workload-socket","credential-socket","workload-cer...
sidecar.istio.io/userVolume: [{"name": "wasmfilters-dir","configMap": {"name": "ndbo-rc-envoy-filters"}}]
sidecar.istio.io/userVolumeMount: [{"mountPath":"/var/local/lib/wasm-filters","name":"wasmfilters-dir"}]
Status: Running
IP: 100.79.156.38
IPs:
IP: 100.79.156.38
Controlled By: ReplicaSet/ms-certificate-registry-76c95b9686
Init Containers:
istio-init:
Container ID: containerd://aaaeeffae7f3c765e70d81765e79b843de00277057cc49761162564d59500fa2
Image: registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0
Image ID: registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2@sha256:7b3ce834183d38c73388b93b9f2173957dba6da11f8bc17e8dfcd64415c41e4e
Port: <none>
Host Port: <none>
Args:
istio-iptables
-p
15001
-z
15006
-u
1337
-m
REDIRECT
-i
*
-x
-b
*
-d
15090,15021,15020
--log_output_level=default:info
State: Terminated
Reason: Completed
Exit Code: 0
Started: Tue, 06 Oct 2026 10:45:31 +0300
Finished: Tue, 06 Oct 2026 10:45:32 +0300
Ready: True
Restart Count: 0
Limits:
cpu: 400m
memory: 412Mi
Requests:
cpu: 100m
memory: 64Mi
Environment: <none>
Mounts: <none>
Containers:
istio-proxy:
Container ID: containerd://a7c532e2558d0fac5ec3cfdc02e4a410af99db1532cb49d14ad7850eee58705e
Image: registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0
Image ID: registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2@sha256:7b3ce834183d38c73388b93b9f2173957dba6da11f8bc17e8dfcd64415c41e4e
Port: 15090/TCP (http-envoy-prom)
Host Port: 0/TCP (http-envoy-prom)
Args:
proxy
sidecar
--domain
$(POD_NAMESPACE).svc.cluster.local
--proxyLogLevel=warning
--proxyComponentLogLevel=misc:error
--log_output_level=default:info
--concurrency
2
State: Running
Started: Tue, 06 Oct 2026 10:45:32 +0300
Ready: True
Restart Count: 0
Limits:
cpu: 400m
memory: 412Mi
Requests:
cpu: 100m
memory: 64Mi
Readiness: http-get http://:15021/healthz/ready delay=1s timeout=3s period=2s #success=1 #failure=30
Environment:
HTTP_LOG_FORWARDER_HOST: (v1:spec.nodeName)
HTTP_LOG_FORWARDER_PORT: 9000
HTTP_LOG_FORWARDER_ENDPOINT: /
OUTPUT_CERTS: /etc/istio-certs/
ISYS_NAME: (v1:metadata.labels['isys'])
PSVC_NAME: (v1:metadata.labels['psvc'])
WORKLOAD_ZONE_NAME: (v1:metadata.labels['workload.topology.app.farm/zone'])
JWT_POLICY: third-party-jwt
PILOT_CERT_PROVIDER: istiod
CA_ADDR: istiod.istio-system.svc:15012
POD_NAME: ms-certificate-registry-76c95b9686-4pkr5 (v1:metadata.name)
POD_NAMESPACE: isys-ndbo-rc (v1:metadata.namespace)
INSTANCE_IP: (v1:status.podIP)
SERVICE_ACCOUNT: (v1:spec.serviceAccountName)
HOST_IP: (v1:status.hostIP)
PROXY_CONFIG: {"tracing":{"zipkin":{"address":"jaeger-collector.istio-system:9411"},"customTags":{"workload.topology.app.farm/zone":{"environment":{"name":"WORKLOAD_ZONE_NAME"}}},"sampling":100}}
ISTIO_META_POD_PORTS: [
]
ISTIO_META_APP_CONTAINERS: app
ISTIO_META_CLUSTER_ID: Kubernetes
ISTIO_META_INTERCEPTION_MODE: REDIRECT
ISTIO_META_WORKLOAD_NAME: ms-certificate-registry
ISTIO_META_OWNER: kubernetes://apis/apps/v1/namespaces/isys-ndbo-rc/deployments/ms-certificate-registry
ISTIO_META_MESH_ID: cluster.local
TRUST_DOMAIN: cluster.local
ISTIO_PROMETHEUS_ANNOTATIONS: {"scrape":"true","path":"/metrics","port":"8080"}
ISTIO_KUBE_APP_PROBERS: {"/app-health/app/livez":{"httpGet":{"path":"/health/liveness","port":8080,"scheme":"HTTP"},"timeoutSeconds":1},"/app-health/app/readyz":{"httpGet":{"path":"/health/readiness","port":8080,"scheme":"HTTP"},"timeoutSeconds":1}}
Mounts:
/etc/istio-certs/ from istio-certs (rw)
/etc/istio/pod from istio-podinfo (rw)
/etc/istio/proxy from istio-envoy (rw)
/var/lib/istio/data from istio-data (rw)
/var/local/lib/wasm-filters from wasmfilters-dir (rw)
/var/run/secrets/credential-uds from credential-socket (rw)
/var/run/secrets/istio from istiod-ca-cert (rw)
/var/run/secrets/tokens from istio-token (rw)
/var/run/secrets/workload-spiffe-credentials from workload-certs (rw)
/var/run/secrets/workload-spiffe-uds from workload-socket (rw)
app:
Container ID: containerd://61a551273f12c8a777629573b4647c4b6b0c9bb07d715630fb0ebbc5ea239243
Image: registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1
Image ID: registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry@sha256:50d1ebcb9b1622c3e2c2e07346bb52041b0917e29dcc10b4b7cf831b82f8e07c
Port: <none>
Host Port: <none>
State: Waiting
Reason: CrashLoopBackOff
Last State: Terminated
Reason: Error
Exit Code: 1
Started: Tue, 06 Oct 2026 10:48:05 +0300
Finished: Tue, 06 Oct 2026 10:48:39 +0300
Ready: False
Restart Count: 3
Limits:
cpu: 800m
memory: 1Gi
Requests:
cpu: 500m
memory: 512Mi
Liveness: http-get http://:15020/app-health/app/livez delay=120s timeout=1s period=5s #success=1 #failure=5
Readiness: http-get http://:15020/app-health/app/readyz delay=120s timeout=1s period=5s #success=1 #failure=3
Environment Variables from:
ms-certificate-registry-app-cm-env ConfigMap Optional: false
ms-certificate-registry-app-secret-env Secret Optional: false
Environment: <none>
Mounts:
/secrets from app-vault-secrets (ro)
Conditions:
Type Status
Initialized True
Ready False
ContainersReady False
PodScheduled True
Volumes:
istio-certs:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium: Memory
SizeLimit: <unset>
workload-socket:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium:
SizeLimit: <unset>
credential-socket:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium:
SizeLimit: <unset>
workload-certs:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium:
SizeLimit: <unset>
istio-envoy:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium: Memory
SizeLimit: <unset>
istio-data:
Type: EmptyDir (a temporary directory that shares a pod's lifetime)
Medium:
SizeLimit: <unset>
istio-podinfo:
Type: DownwardAPI (a volume populated by information about the pod)
Items:
metadata.labels -> labels
metadata.annotations -> annotations
istio-token:
Type: Projected (a volume that contains injected data from multiple sources)
TokenExpirationSeconds: 43200
istiod-ca-cert:
Type: ConfigMap (a volume populated by a ConfigMap)
Name: istio-ca-root-cert
Optional: false
wasmfilters-dir:
Type: ConfigMap (a volume populated by a ConfigMap)
Name: ndbo-rc-envoy-filters
Optional: false
app-vault-secrets:
Type: CSI (a Container Storage Interface (CSI) volume source)
Driver: secrets-store.csi.k8s.io
FSType:
ReadOnly: true
VolumeAttributes: secretProviderClass=ms-certificate-registry-app-secret-provider
QoS Class: Burstable
Node-Selectors: workload.topology.app.farm/zone=rumsk1
Tolerations: node.kubernetes.io/not-ready:NoExecute op=Exists for 300s
node.kubernetes.io/unreachable:NoExecute op=Exists for 300s
workload.topology.app.farm/zone:NoSchedule op=Exists
Events:
Type Reason Age From Message
---- ------ ---- ---- -------
Normal Scheduled 3m29s default-scheduler Successfully assigned isys-ndbo-rc/ms-certificate-registry-76c95b9686-4pkr5 to afs1asd-wl-215
Normal Pulled 3m28s kubelet spec.initContainers{istio-init}: Container image "registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0" already present on machine
Normal Created 3m28s kubelet spec.initContainers{istio-init}: Created container istio-init
Normal Started 3m28s kubelet spec.initContainers{istio-init}: Started container istio-init
Normal Started 3m27s kubelet spec.containers{istio-proxy}: Started container istio-proxy
Normal Created 3m27s kubelet spec.containers{istio-proxy}: Created container istio-proxy
Normal Pulled 3m27s kubelet spec.containers{istio-proxy}: Container image "registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0" already present on machine
Normal Pulling 3m24s kubelet spec.containers{app}: Pulling image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1"
Normal Pulled 3m21s kubelet spec.containers{app}: Successfully pulled image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1" in 2.778996773s
Normal SecretRotationComplete 80s (x2 over 3m23s) csi-secrets-store-rotation successfully rotated K8s secret ms-certificate-registry-app-secret-env
Normal Created 54s (x4 over 3m21s) kubelet spec.containers{app}: Created container app
Normal Started 54s (x4 over 3m21s) kubelet spec.containers{app}: Started container app
Normal Pulled 54s (x3 over 2m46s) kubelet spec.containers{app}: Container image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1" already present on machine
Warning BackOff 19s (x6 over 2m12s) kubelet spec.containers{app}: Back-off restarting failed container
dmitriev-aal@VDI-Dmitriev-A:~$ kubectl logs ms-certificate-registry-76c95b9686-4pkr5
07:48:05.626 [main] INFO ru.rshbintech.crft.dboul.ndbo.backend.core.certreg.helpers.CryptoProJCP -- Set CryptoPro JCP work directory: /tmp
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.5)
{"@timestamp":"2026-10-06T07:48:09.503596071Z","@version":"1","message":"Starting Application using Java 21.0.9 with PID 1 (/app/ms-certificate-registry.jar started by app in /app)","logger_name":"ru.rshbintech.crft.dboul.ndbo.backend.core.certreg.Application","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:09.513855872Z","@version":"1","message":"The following 1 profile is active: \"rc\"","logger_name":"ru.rshbintech.crft.dboul.ndbo.backend.core.certreg.Application","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:15.707432102Z","@version":"1","message":"Tomcat initialized with port 8080 (http)","logger_name":"org.springframework.boot.web.embedded.tomcat.TomcatWebServer","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:15.718065594Z","@version":"1","message":"Initializing ProtocolHandler [\"http-nio-8080\"]","logger_name":"org.apache.coyote.http11.Http11NioProtocol","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:15.719700851Z","@version":"1","message":"Starting service [Tomcat]","logger_name":"org.apache.catalina.core.StandardService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:15.719940668Z","@version":"1","message":"Starting Servlet engine: [Apache Tomcat/10.1.44]","logger_name":"org.apache.catalina.core.StandardEngine","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:16.425343091Z","@version":"1","message":"Initializing Spring embedded WebApplicationContext","logger_name":"org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/]","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:16.426332861Z","@version":"1","message":"Root WebApplicationContext: initialization completed in 6875 ms","logger_name":"org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.473224059Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Running with 2 response threads, dynamic=true","logger_name":"com.hazelcast.client.impl.spi.ClientInvocationService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.519866824Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is STARTING","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.520679463Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is STARTED","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.551807736Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Trying to connect to cluster: rc","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.555371554Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Trying to connect to [10.21.49.31]:5703","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.594859723Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is CLIENT_CONNECTED","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.595294431Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Authenticated with server [10.21.49.31]:5703:349bde03-0e96-4cfc-a931-a5696af80cd1, server version: 5.1.1, local address: /100.79.156.38:48765","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.596525342Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Diagnostics disabled. To enable add -Dhazelcast.diagnostics.enabled=true to the JVM arguments.","logger_name":"com.hazelcast.internal.diagnostics.Diagnostics","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.616679495Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] \n\nMembers [3] {\n\tMember [10.21.49.31]:5701 - f8be4f31-edae-402e-9b4f-8a710629b1c3\n\tMember [10.21.49.31]:5702 - 63845486-4ab0-4128-818c-c65f55a01c08\n\tMember [10.21.49.31]:5703 - 349bde03-0e96-4cfc-a931-a5696af80cd1\n}\n","logger_name":"com.hazelcast.client.impl.spi.ClientClusterService","thread_name":"hz.client_1.event-2","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:19.705612087Z","@version":"1","message":"Client statistics is enabled with period 5 seconds.","logger_name":"com.hazelcast.client.impl.statistics.ClientStatisticsService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:20.611203204Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Authenticated with server [10.21.49.31]:5701:f8be4f31-edae-402e-9b4f-8a710629b1c3, server version: 5.1.1, local address: /100.79.156.38:53619","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"hz.client_1.internal-2","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:20.611948642Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Authenticated with server [10.21.49.31]:5702:63845486-4ab0-4128-818c-c65f55a01c08, server version: 5.1.1, local address: /100.79.156.38:56325","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"hz.client_1.internal-3","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:20.744308733Z","@version":"1","message":"WARNING: \n\nLiquibase detected the following invalid LIQUIBASE_* environment variables:\n\n- LIQUIBASE_ENABLED\n\nFind the list of valid environment variables at https://docs.liquibase.com/environment-variables\n","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:20.7444865Z","@version":"1","message":"\n\nLiquibase detected the following invalid LIQUIBASE_* environment variables:\n\n- LIQUIBASE_ENABLED\n\nFind the list of valid environment variables at https://docs.liquibase.com/environment-variables\n","logger_name":"liquibase.configuration","thread_name":"main","level":"WARN","level_value":30000}
{"@timestamp":"2026-10-06T07:48:22.631444456Z","@version":"1","message":"Reading from certreg.certreg_o_databasechangelog","logger_name":"liquibase.changelog","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:27.632089777Z","@version":"1","message":"Successfully acquired change log lock","logger_name":"liquibase.lockservice","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:27.634005354Z","@version":"1","message":"Using deploymentId: 1272900471","logger_name":"liquibase.command","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:27.638201677Z","@version":"1","message":"Reading from certreg.certreg_o_databasechangelog","logger_name":"liquibase.changelog","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.670271965Z","@version":"1","message":"Running Changeset: db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.700112439Z","@version":"1","message":"ChangeSet db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko encountered an exception.","logger_name":"liquibase.changelog","thread_name":"main","level":"ERROR","level_value":40000,"stack_trace":"liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:497)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:185)\n\tat liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)\n\tat liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:790)\n\tat liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:126)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:70)\n\tat liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:133)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:122)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.Scope.child(Scope.java:267)\n\tat liquibase.Scope.child(Scope.java:271)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:91)\n\tat liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)\n\tat liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:100)\n\tat liquibase.command.CommandScope.lambda$execute$6(CommandScope.java:253)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:186)\n\tat liquibase.command.CommandScope.execute(CommandScope.java:241)\n\tat liquibase.Liquibase.lambda$update$0(Liquibase.java:216)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.Liquibase.runInScope(Liquibase.java:1333)\n\tat liquibase.Liquibase.update(Liquibase.java:205)\n\tat liquibase.Liquibase.update(Liquibase.java:188)\n\tat liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:326)\n\tat liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:278)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:271)\n\tat org.springframework.boot.autoconfigure.liquibase.DataSourceClosingSpringLiquibase.afterPropertiesSet(DataSourceClosingSpringLiquibase.java:46)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1873)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1822)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)\n\tat org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)\n\tat org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)\n\tat org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)\n\tat org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)\n\tat org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:318)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1361)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1350)\n\tat ru.rshbintech.crft.dboul.ndbo.backend.core.certreg.Application.main(Application.java:16)\n\tat java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\n\tat org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)\n\tat org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)\n\tat org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)\nCaused by: org.postgresql.util.PSQLException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835\n\tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)\n\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)\n\tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)\n\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)\n\tat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341)\n\tat org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326)\n\tat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302)\n\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297)\n\tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:491)\n\t... 116 common frames omitted\n"}
{"@timestamp":"2026-10-06T07:48:28.712541655Z","@version":"1","message":"UPDATE SUMMARY","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.712736709Z","@version":"1","message":"Run: 0","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.71277314Z","@version":"1","message":"Previously run: 254","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.712809644Z","@version":"1","message":"Filtered out: 0","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.71287045Z","@version":"1","message":"-------------------------------","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.712918662Z","@version":"1","message":"Total change sets: 266","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.713677366Z","@version":"1","message":"Update summary generated","logger_name":"liquibase.util","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.715947483Z","@version":"1","message":"Update command encountered an exception.","logger_name":"liquibase.command","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.7249341Z","@version":"1","message":"Successfully released change log lock","logger_name":"liquibase.lockservice","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.728211524Z","@version":"1","message":"Logging exception.","logger_name":"liquibase.command","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.728407953Z","@version":"1","message":"ERROR: Exception Details","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.728460559Z","@version":"1","message":"ERROR: Exception Primary Class: PSQLException","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.728507601Z","@version":"1","message":"ERROR: Exception Primary Reason: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.728558952Z","@version":"1","message":"ERROR: Exception Primary Source: PostgreSQL 14.5","logger_name":"liquibase.ui","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:28.72889898Z","@version":"1","message":"Command execution complete","logger_name":"liquibase.command","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:29.617834773Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] \n\nClient Connectivity [3] {\n\tMember [10.21.49.31]:5701 - f8be4f31-edae-402e-9b4f-8a710629b1c3 - connected\n\tMember [10.21.49.31]:5702 - 63845486-4ab0-4128-818c-c65f55a01c08 - connected\n\tMember [10.21.49.31]:5703 - 349bde03-0e96-4cfc-a931-a5696af80cd1 - connected\n}\n","logger_name":"com.hazelcast.client.util.ClientConnectivityLogger","thread_name":"hz.client_1.internal-1","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.244317542Z","@version":"1","message":"Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'armController' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/controllers/ArmController.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'stateServiceImpl' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/services/state/StateServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'jdbcStateRepository' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/repositories/state/JdbcStateRepository.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]","logger_name":"org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext","thread_name":"main","level":"WARN","level_value":30000}
{"@timestamp":"2026-10-06T07:48:30.245376338Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is SHUTTING_DOWN","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.253444427Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Removed connection to endpoint: [10.21.49.31]:5702:63845486-4ab0-4128-818c-c65f55a01c08, connection: ClientConnection{alive=false, connectionId=3, channel=NioChannel{/100.79.156.38:56325->/10.21.49.31:5702}, remoteAddress=[10.21.49.31]:5702, remoteUuid=63845486-4ab0-4128-818c-c65f55a01c08, clusterUuid=dea45636-b072-4ca3-aaf3-b54936061737, lastReadTime=2026-10-06 07:48:29.553, lastWriteTime=2026-10-06 07:48:29.551, closedTime=2026-10-06 07:48:30.246}","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.253845208Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Removed connection to endpoint: [10.21.49.31]:5703:349bde03-0e96-4cfc-a931-a5696af80cd1, connection: ClientConnection{alive=false, connectionId=1, channel=NioChannel{/100.79.156.38:48765->/10.21.49.31:5703}, remoteAddress=[10.21.49.31]:5703, remoteUuid=349bde03-0e96-4cfc-a931-a5696af80cd1, clusterUuid=dea45636-b072-4ca3-aaf3-b54936061737, lastReadTime=2026-10-06 07:48:28.602, lastWriteTime=2026-10-06 07:48:25.407, closedTime=2026-10-06 07:48:30.253}","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.254160637Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] Removed connection to endpoint: [10.21.49.31]:5701:f8be4f31-edae-402e-9b4f-8a710629b1c3, connection: ClientConnection{alive=false, connectionId=2, channel=NioChannel{/100.79.156.38:53619->/10.21.49.31:5701}, remoteAddress=[10.21.49.31]:5701, remoteUuid=f8be4f31-edae-402e-9b4f-8a710629b1c3, clusterUuid=dea45636-b072-4ca3-aaf3-b54936061737, lastReadTime=2026-10-06 07:48:29.710, lastWriteTime=2026-10-06 07:48:29.710, closedTime=2026-10-06 07:48:30.253}","logger_name":"com.hazelcast.client.impl.connection.ClientConnectionManager","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.254238575Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is CLIENT_DISCONNECTED","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.255940639Z","@version":"1","message":"hz.client_1 [rc] [5.5.0] HazelcastClient 5.5.0 (20240725) is SHUTDOWN","logger_name":"com.hazelcast.core.LifecycleService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.259581834Z","@version":"1","message":"Stopping service [Tomcat]","logger_name":"org.apache.catalina.core.StandardService","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.273561218Z","@version":"1","message":"\n\nError starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.","logger_name":"org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLogger","thread_name":"main","level":"INFO","level_value":20000}
{"@timestamp":"2026-10-06T07:48:30.288700204Z","@version":"1","message":"Application run failed","logger_name":"org.springframework.boot.SpringApplication","thread_name":"main","level":"ERROR","level_value":40000,"stack_trace":"org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'armController' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/controllers/ArmController.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'stateServiceImpl' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/services/state/StateServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'jdbcStateRepository' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/repositories/state/JdbcStateRepository.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)\n\tat org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)\n\tat org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)\n\tat org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)\n\tat org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)\n\tat org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:318)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1361)\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1350)\n\tat ru.rshbintech.crft.dboul.ndbo.backend.core.certreg.Application.main(Application.java:16)\n\tat java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\n\tat org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)\n\tat org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)\n\tat org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)\nCaused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'stateServiceImpl' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/services/state/StateServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'jdbcStateRepository' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/repositories/state/JdbcStateRepository.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\t... 26 common frames omitted\nCaused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'jdbcStateRepository' defined in URL [jar:nested:/app/ms-certificate-registry.jar/!BOOT-INF/classes/!/ru/rshbintech/crft/dboul/ndbo/backend/core/certreg/repositories/state/JdbcStateRepository.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804)\n\tat org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\t... 40 common frames omitted\nCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1826)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)\n\tat org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)\n\tat org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n\tat org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1752)\n\tat org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1635)\n\tat org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)\n\tat org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)\n\t... 54 common frames omitted\nCaused by: liquibase.exception.LiquibaseException: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:288)\n\tat org.springframework.boot.autoconfigure.liquibase.DataSourceClosingSpringLiquibase.afterPropertiesSet(DataSourceClosingSpringLiquibase.java:46)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1873)\n\tat org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1822)\n\t... 67 common frames omitted\nCaused by: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.command.CommandScope.lambda$execute$6(CommandScope.java:300)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:186)\n\tat liquibase.command.CommandScope.execute(CommandScope.java:241)\n\tat liquibase.Liquibase.lambda$update$0(Liquibase.java:216)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.Liquibase.runInScope(Liquibase.java:1333)\n\tat liquibase.Liquibase.update(Liquibase.java:205)\n\tat liquibase.Liquibase.update(Liquibase.java:188)\n\tat liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:326)\n\tat liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:278)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:271)\n\t... 70 common frames omitted\nCaused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:155)\n\tat liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)\n\tat liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:100)\n\tat liquibase.command.CommandScope.lambda$execute$6(CommandScope.java:253)\n\t... 88 common frames omitted\nCaused by: liquibase.exception.MigrationFailedException: Migration failed for changeset db_changelog/v1.0.0/v_1.0.0_id_75.xml::v_1.0.0_id_75.4_module_module_ms-certificate-registry_task_ECO_OB_PERS-700_date_28072026.xml::Vladimir Marchenko:\n Reason: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:840)\n\tat liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:126)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:70)\n\tat liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:133)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:122)\n\tat liquibase.Scope.lambda$child$0(Scope.java:201)\n\tat liquibase.Scope.child(Scope.java:210)\n\tat liquibase.Scope.child(Scope.java:200)\n\tat liquibase.Scope.child(Scope.java:179)\n\tat liquibase.Scope.child(Scope.java:267)\n\tat liquibase.Scope.child(Scope.java:271)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:91)\n\t... 96 common frames omitted\nCaused by: liquibase.exception.DatabaseException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835 [Failed SQL: (0) INSERT INTO o_certreg_ukep_certificate\n (SELECT cert.serial as serial,\n cert.issuer as issuer,\n delegate.id as delegate_id,\n cert.data as data,\n cert.not_after as not_after,\n cert.not_before as not_before,\n cert.key_not_after as key_not_after,\n cert.key_not_before as key_not_before,\n cert.owner as owner,\n regexp_substr(issuer, 'O=([^,]+)', 1, 1, '', 1) as ca_organization,\n regexp_substr(owner, 'CN=([^,]+)', 1, 1, '', 1) as fio,\n cert.organization as organization,\n cert.state as state,\n cert.state_time as state_time,\n cert.authority_key_id as authority_key_id,\n cert.is_blocked as is_blocked,\n cert.block_time as block_time\n FROM certreg_o_cert as cert\n JOIN r_orgreg_org_extsys as extsys\n ON extsys.external_system_type_id = 'CFT' AND\n extsys.external_system_id = cert.client_abs_id\n JOIN r_brchreg_branch as branch\n ON branch.branch_code = cert.client_branch_abs_id\n JOIN r_orgreg_org as org\n ON org.id = extsys.org_id AND org.branch_ref_id = branch.id\n JOIN r_orgreg_delegate as delegate\n ON delegate.cio_id = cert.user_abs_id AND delegate.org_id = org.id\n WHERE cert.cert_type = 'UKEP')]\n\tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:497)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:185)\n\tat liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)\n\tat liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:790)\n\t... 111 common frames omitted\nCaused by: org.postgresql.util.PSQLException: ERROR: function regexp_substr(character varying, unknown, integer, integer, unknown, integer) does not exist\n Hint: No function matches the given name and argument types. You might need to add explicit type casts.\n Position: 835\n\tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)\n\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)\n\tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)\n\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)\n\tat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341)\n\tat org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326)\n\tat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302)\n\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297)\n\tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:491)\n\t... 116 common frames omitted\n"}
dmitriev-aal@VDI-Dmitriev-A:~$ kubectl get events | grep ms-certificate-registry-76c95b9686-4pkr5
3m38s Normal Scheduled pod/ms-certificate-registry-76c95b9686-4pkr5 Successfully assigned isys-ndbo-rc/ms-certificate-registry-76c95b9686-4pkr5 to afs1asd-wl-215
3m37s Normal Pulled pod/ms-certificate-registry-76c95b9686-4pkr5 Container image "registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0" already present on machine
3m37s Normal Created pod/ms-certificate-registry-76c95b9686-4pkr5 Created container istio-init
3m37s Normal Started pod/ms-certificate-registry-76c95b9686-4pkr5 Started container istio-init
3m36s Normal Pulled pod/ms-certificate-registry-76c95b9686-4pkr5 Container image "registry.rshbdev.ru/appfarm/infra/images/istio/proxyv2:1.15.1-rshb.0.4.0" already present on machine
3m36s Normal Created pod/ms-certificate-registry-76c95b9686-4pkr5 Created container istio-proxy
3m36s Normal Started pod/ms-certificate-registry-76c95b9686-4pkr5 Started container istio-proxy
3m33s Normal Pulling pod/ms-certificate-registry-76c95b9686-4pkr5 Pulling image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1"
89s Normal SecretRotationComplete pod/ms-certificate-registry-76c95b9686-4pkr5 successfully rotated K8s secret ms-certificate-registry-app-secret-env
3m30s Normal Pulled pod/ms-certificate-registry-76c95b9686-4pkr5 Successfully pulled image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1" in 2.778996773s
63s Normal Created pod/ms-certificate-registry-76c95b9686-4pkr5 Created container app
63s Normal Started pod/ms-certificate-registry-76c95b9686-4pkr5 Started container app
63s Normal Pulled pod/ms-certificate-registry-76c95b9686-4pkr5 Container image "registry.rshbdev.ru/rshbintech/crft/dboul/ndbo/backend/core/ms-certificate-registry:1.40.0-rc1" already present on machine
28s Warning BackOff pod/ms-certificate-registry-76c95b9686-4pkr5 Back-off restarting failed container
3m38s Normal SuccessfulCreate replicaset/ms-certificate-registry-76c95b9686 Created pod: ms-certificate-registry-76c95b9686-4pkr5
dmitriev-aal@VDI-Dmitriev-A:~$ 