Pilna pomoc! Baza 1C nie uruchamia się

Можете добавити логи помилок ? 

Pavel V. 30 czerwca 2025

З радістю, але не знаю де це дивитись.

Спробую дістати інформацію 

Pavel V. 30 czerwca 2025

Можливо це воно

< 2025-06-30 09:17:42.360 MSK >ERROR:  deadlock detected

< 2025-06-30 09:17:42.360 MSK >DETAIL:  Process 18528 waits for ExclusiveLock on advisory lock [320617,0,12130896,1]; blocked by process 16740.

    Process 16740 waits for ShareLock on advisory lock [320617,0,25666957,1]; blocked by process 18528.

    Process 18528: SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_documentjournal5452'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

    Process 16740: SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126'));

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2044'));

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2066'));

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2074'));

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2087'));

    SELECT pg_advisory_xact_lock_shared((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt7217'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 09:17:42.360 MSK >HINT:  See server log for query details.

< 2025-06-30 09:17:42.360 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_documentjournal5452'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 09:17:42.365 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 14:37:27.370 MSK >ERROR:  canceling statement due to lock timeout

< 2025-06-30 14:37:27.370 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2044'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2066'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2074'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2087'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt7217'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 14:37:27.374 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 14:37:33.434 MSK >ERROR:  canceling statement due to lock timeout

< 2025-06-30 14:37:33.434 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_inforg5787'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 14:37:33.436 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 14:37:41.246 MSK >ERROR:  canceling statement due to lock timeout

< 2025-06-30 14:37:41.246 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_reference9180'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_reference9180_vt9227'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_reference9180_vt9236'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 14:37:41.248 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 14:37:55.529 MSK >ERROR:  canceling statement due to lock timeout

< 2025-06-30 14:37:55.529 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_inforg5787'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 14:37:55.530 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 14:38:04.983 MSK >ERROR:  canceling statement due to lock timeout

< 2025-06-30 14:38:04.983 MSK >STATEMENT:  SET STATEMENT_TIMEOUT TO 20000;

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2044'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2066'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2074'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt2087'));

    SELECT pg_advisory_xact_lock((SELECT oid::bigint FROM pg_class WHERE relname = '_document126_vt7217'));

    SET STATEMENT_TIMEOUT TO DEFAULT;

    

< 2025-06-30 14:38:04.986 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 15:05:23.710 MSK >ERROR:  canceling statement due to user request

< 2025-06-30 15:05:23.710 MSK >STATEMENT:  SELECT

    T1._IDRRef,

    T1._Fld917

    FROM _Reference72 T1

    WHERE ((T1._ParentIDRRef IN

    (SELECT

    T2._REFFIELDRRef AS REFFIELDRRef

    FROM pg_temp.tt23 T2)) OR (T1._IDRRef IN ('\\276''\\030\\251\\005\\271\\305\\237\\021\\347\\340\\346\\311\\216V\\001'::bytea, '\\254\\020\\030\\251\\005\\271\\305\\237\\021\\350\\011\\2612\\201\\203\\236'::bytea, '\\200\\330<\\354\\357#&\\211\\021\\357\\275b\\207 \\332\\314'::bytea, '\\264a\\030\\251\\005\\271\\305\\237\\021\\347\\237\\247l3\\306L'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502i^2\\014\\012'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224\\023\\030\\251\\005\\271\\305\\237\\021\\3526\\003\\241\\234\\034\\321'::bytea, '\\260\\017\\030\\251\\005\\271\\305\\237\\021\\351F0_l\\222\\374'::bytea, '\\243X\\0224Vx\\221#\\021\\347\\225\\376m\\007\\214}'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352#m\\266\\260\\241Y'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352(\\217\\243\\326\\375\\371'::bytea, '\\200\\344\\366\\350/\\362\\3648\\021\\352V\\334\\223\\325E\\321'::bytea, '\\201\\001\\366\\350/\\362\\3648\\021\\352\\356\\006sk\\025\\020'::bytea, '\\271\\342\\030\\251\\005\\271\\305\\237\\021\\350j\\\\\\242\\323EC'::bytea, '\\275\\267\\030\\251\\005\\271\\305\\237\\021\\3506L\\330Udr'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502\\304\\217\\2445*'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea))) AND (T1._Marked = FALSE) AND (T1._Folder) = TRUE AND (T1._Fld917 <> ''::mvarchar)

< 2025-06-30 15:05:23.716 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 15:05:24.291 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:05:24.291 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:05:24.291 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:05:24.291 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:05:24.292 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:05:57.954 MSK >ERROR:  canceling statement due to user request

< 2025-06-30 15:05:57.954 MSK >STATEMENT:  SELECT

    T1._IDRRef,

    T1._Fld917

    FROM _Reference72 T1

    WHERE ((T1._ParentIDRRef IN

    (SELECT

    T2._REFFIELDRRef AS REFFIELDRRef

    FROM pg_temp.tt2 T2)) OR (T1._IDRRef IN ('\\276''\\030\\251\\005\\271\\305\\237\\021\\347\\340\\346\\311\\216V\\001'::bytea, '\\254\\020\\030\\251\\005\\271\\305\\237\\021\\350\\011\\2612\\201\\203\\236'::bytea, '\\200\\330<\\354\\357#&\\211\\021\\357\\275b\\207 \\332\\314'::bytea, '\\264a\\030\\251\\005\\271\\305\\237\\021\\347\\237\\247l3\\306L'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502i^2\\014\\012'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224\\023\\030\\251\\005\\271\\305\\237\\021\\3526\\003\\241\\234\\034\\321'::bytea, '\\260\\017\\030\\251\\005\\271\\305\\237\\021\\351F0_l\\222\\374'::bytea, '\\243X\\0224Vx\\221#\\021\\347\\225\\376m\\007\\214}'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352#m\\266\\260\\241Y'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352(\\217\\243\\326\\375\\371'::bytea, '\\200\\344\\366\\350/\\362\\3648\\021\\352V\\334\\223\\325E\\321'::bytea, '\\201\\001\\366\\350/\\362\\3648\\021\\352\\356\\006sk\\025\\020'::bytea, '\\271\\342\\030\\251\\005\\271\\305\\237\\021\\350j\\\\\\242\\323EC'::bytea, '\\275\\267\\030\\251\\005\\271\\305\\237\\021\\3506L\\330Udr'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502\\304\\217\\2445*'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea))) AND (T1._Marked = FALSE) AND (T1._Folder) = TRUE AND (T1._Fld917 <> ''::mvarchar)

< 2025-06-30 15:05:57.956 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 15:06:08.033 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:06:08.034 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:06:08.034 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:18.864 MSK >ERROR:  canceling statement due to user request

< 2025-06-30 15:11:18.864 MSK >STATEMENT:  SELECT

    T1._IDRRef,

    T1._Fld917

    FROM _Reference72 T1

    WHERE ((T1._ParentIDRRef IN

    (SELECT

    T2._REFFIELDRRef AS REFFIELDRRef

    FROM pg_temp.tt13 T2)) OR (T1._IDRRef IN ('\\276''\\030\\251\\005\\271\\305\\237\\021\\347\\340\\346\\311\\216V\\001'::bytea, '\\254\\020\\030\\251\\005\\271\\305\\237\\021\\350\\011\\2612\\201\\203\\236'::bytea, '\\200\\330<\\354\\357#&\\211\\021\\357\\275b\\207 \\332\\314'::bytea, '\\264a\\030\\251\\005\\271\\305\\237\\021\\347\\237\\247l3\\306L'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502i^2\\014\\012'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224\\023\\030\\251\\005\\271\\305\\237\\021\\3526\\003\\241\\234\\034\\321'::bytea, '\\260\\017\\030\\251\\005\\271\\305\\237\\021\\351F0_l\\222\\374'::bytea, '\\243X\\0224Vx\\221#\\021\\347\\225\\376m\\007\\214}'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352#m\\266\\260\\241Y'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352(\\217\\243\\326\\375\\371'::bytea, '\\200\\344\\366\\350/\\362\\3648\\021\\352V\\334\\223\\325E\\321'::bytea, '\\201\\001\\366\\350/\\362\\3648\\021\\352\\356\\006sk\\025\\020'::bytea, '\\271\\342\\030\\251\\005\\271\\305\\237\\021\\350j\\\\\\242\\323EC'::bytea, '\\275\\267\\030\\251\\005\\271\\305\\237\\021\\3506L\\330Udr'::bytea, '\\254\\036\\030\\251\\005\\271\\305\\237\\021\\350\\353o\\315\\202\\025\\022'::bytea, '\\224w\\030\\251\\005\\271\\305\\237\\021\\3502\\304\\217\\2445*'::bytea, '\\237Q\\030\\251\\005\\271\\305\\237\\021\\352''\\253\\210+\\251\\214'::bytea))) AND (T1._Marked = FALSE) AND (T1._Folder) = TRUE AND (T1._Fld917 <> ''::mvarchar)

< 2025-06-30 15:11:18.868 MSK >WARNING:  there is no transaction in progress

< 2025-06-30 15:11:19.230 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.232 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.232 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.232 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.232 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.233 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.233 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.233 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.234 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:11:19.234 MSK >LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    

< 2025-06-30 15:27:35.227 MSK >LOG:  received fast shutdown request

< 2025-06-30 15:27:35.239 MSK >LOG:  aborting any active transactions

< 2025-06-30 15:27:35.259 MSK >LOG:  worker process: logical replication launcher (PID 2360) exited with exit code 1

< 2025-06-30 15:27:35.279 MSK >LOG:  shutting down

< 2025-06-30 15:27:35.448 MSK >LOG:  database system is shut down

< 2025-06-30 15:27:43.938 MSK >LOG:  database system was shut down at 2025-06-30 15:27:35 MSK

< 2025-06-30 15:27:43.980 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 15:40:17.549 MSK >LOG:  received fast shutdown request

< 2025-06-30 15:40:17.553 MSK >LOG:  aborting any active transactions

< 2025-06-30 15:40:17.568 MSK >LOG:  worker process: logical replication launcher (PID 22080) exited with exit code 1

< 2025-06-30 15:40:17.586 MSK >LOG:  shutting down

< 2025-06-30 15:40:17.655 MSK >LOG:  database system is shut down

< 2025-06-30 15:40:19.062 MSK >LOG:  database system was shut down at 2025-06-30 15:40:17 MSK

< 2025-06-30 15:40:19.095 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 15:43:43.316 MSK >LOG:  database system was interrupted; last known up at 2025-06-30 15:40:19 MSK

< 2025-06-30 15:43:52.312 MSK >LOG:  database system was not properly shut down; automatic recovery in progress

< 2025-06-30 15:43:52.320 MSK >LOG:  redo starts at 269/8274E560

< 2025-06-30 15:43:52.320 MSK >LOG:  invalid record length at 269/8274E598: wanted 24, got 0

< 2025-06-30 15:43:52.320 MSK >LOG:  redo done at 269/8274E560

< 2025-06-30 15:43:52.368 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 15:53:51.840 MSK >FATAL:  password authentication failed for user "postgres"

< 2025-06-30 15:53:51.840 MSK >DETAIL:  Password does not match for user "postgres".

    Connection matched pg_hba.conf line 83: "host    all             all             ::1/128                 md5"

< 2025-06-30 15:55:15.003 MSK >LOG:  received fast shutdown request

< 2025-06-30 15:55:15.009 MSK >LOG:  aborting any active transactions

< 2025-06-30 15:55:15.009 MSK >FATAL:  terminating connection due to administrator command

< 2025-06-30 15:55:15.027 MSK >LOG:  worker process: logical replication launcher (PID 2392) exited with exit code 1

< 2025-06-30 15:55:15.028 MSK >LOG:  shutting down

< 2025-06-30 15:55:15.110 MSK >LOG:  database system is shut down

< 2025-06-30 15:55:22.376 MSK >LOG:  database system was shut down at 2025-06-30 15:55:15 MSK

< 2025-06-30 15:55:22.405 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 16:05:22.392 MSK >LOG:  received SIGHUP, reloading configuration files

< 2025-06-30 16:05:51.683 MSK >LOG:  received SIGHUP, reloading configuration files

< 2025-06-30 16:06:09.824 MSK >LOG:  received fast shutdown request

< 2025-06-30 16:06:09.828 MSK >LOG:  aborting any active transactions

< 2025-06-30 16:06:09.848 MSK >LOG:  worker process: logical replication launcher (PID 3024) exited with exit code 1

< 2025-06-30 16:06:09.849 MSK >LOG:  shutting down

< 2025-06-30 16:06:09.932 MSK >LOG:  database system is shut down

< 2025-06-30 16:06:12.324 MSK >LOG:  database system was shut down at 2025-06-30 16:06:09 MSK

< 2025-06-30 16:06:12.358 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 16:56:03.000 MSK >LOG:  received fast shutdown request

< 2025-06-30 16:56:03.006 MSK >LOG:  aborting any active transactions

< 2025-06-30 16:56:03.035 MSK >LOG:  worker process: logical replication launcher (PID 5716) exited with exit code 1

< 2025-06-30 16:56:03.037 MSK >LOG:  shutting down

< 2025-06-30 16:56:03.111 MSK >LOG:  database system is shut down

< 2025-06-30 16:56:07.086 MSK >LOG:  database system was shut down at 2025-06-30 16:56:03 MSK

< 2025-06-30 16:56:07.123 MSK >LOG:  database system is ready to accept connections

< 2025-06-30 17:46:46.549 MSK >LOG:  received SIGHUP, reloading configuration files

< 2025-06-30 17:47:12.352 MSK >LOG:  received fast shutdown request

< 2025-06-30 17:47:12.359 MSK >LOG:  aborting any active transactions

< 2025-06-30 17:47:12.389 MSK >LOG:  worker process: logical replication launcher (PID 4048) exited with exit code 1

< 2025-06-30 17:47:12.390 MSK >LOG:  shutting down

< 2025-06-30 17:47:12.466 MSK >LOG:  database system is shut down

< 2025-06-30 17:47:18.354 MSK >LOG:  database system was shut down at 2025-06-30 17:47:12 MSK

< 2025-06-30 17:47:18.388 MSK >LOG:  database system is ready to accept connections

Завдання з розряду - "машина зламалася, треба відремонтувати".😁

І дівчина робить ставку з повідомленням: "Я знаю, як відремонтувати, звертайтеся!" 😂😂😂