Устранение Ошибки Postgre SQL
Цена договорная
Аварийно выключился компьютер с СУБД Postgres 11 pro и 1С.
В результате база данных 1с повредилась в логах Postgre
2024-05-03 17:12:00.833 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:00.833 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt1, 279699) already exists.
2024-05-03 17:12:00.833 MSK [39280] STATEMENT: drop table if exists tt1 cascade;create temporary table tt1 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:00.835 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:02.912 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:02.912 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt2, 279699) already exists.
2024-05-03 17:12:02.912 MSK [39280] STATEMENT: drop table if exists tt2 cascade;create temporary table tt2 (_Q_000_F_000 timestamp, _Q_000_F_001 timestamp, _Q_000_F_002RRef bytea, _Q_000_F_003_TYPE bytea, _Q_000_F_003_RTRef bytea, _Q_000_F_003_RRRef bytea, _Q_000_F_004_TYPE bytea, _Q_000_F_004_RTRef bytea, _Q_000_F_004_RRRef bytea, _Q_000_F_005RRef bytea, _Q_000_F_006_TYPE bytea, _Q_000_F_006_RTRef bytea, _Q_000_F_006_RRRef bytea, _Q_000_F_007_TYPE bytea, _Q_000_F_007_RTRef bytea, _Q_000_F_007_RRRef bytea, _Q_000_F_008 boolean ) without oids
2024-05-03 17:12:02.915 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:02.942 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:02.942 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt3, 279699) already exists.
2024-05-03 17:12:02.942 MSK [39280] STATEMENT: drop table if exists tt3 cascade;create temporary table tt3 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:02.945 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:12.553 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:12.553 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt1, 327468) already exists.
2024-05-03 17:12:12.553 MSK [39012] STATEMENT: drop table if exists tt1 cascade;create temporary table tt1 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:12.555 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:12:16.417 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:16.417 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt2, 327468) already exists.
2024-05-03 17:12:16.417 MSK [39012] STATEMENT: drop table if exists tt2 cascade;create temporary table tt2 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:16.419 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:12:22.563 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:22.563 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt3, 327468) already exists.
2024-05-03 17:12:22.563 MSK [39012] STATEMENT: drop table if exists tt3 cascade;create temporary table tt3 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:22.564 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:26:11.018 MSK [40776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.
В результате база данных 1с повредилась в логах Postgre
2024-05-03 17:12:00.833 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:00.833 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt1, 279699) already exists.
2024-05-03 17:12:00.833 MSK [39280] STATEMENT: drop table if exists tt1 cascade;create temporary table tt1 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:00.835 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:02.912 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:02.912 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt2, 279699) already exists.
2024-05-03 17:12:02.912 MSK [39280] STATEMENT: drop table if exists tt2 cascade;create temporary table tt2 (_Q_000_F_000 timestamp, _Q_000_F_001 timestamp, _Q_000_F_002RRef bytea, _Q_000_F_003_TYPE bytea, _Q_000_F_003_RTRef bytea, _Q_000_F_003_RRRef bytea, _Q_000_F_004_TYPE bytea, _Q_000_F_004_RTRef bytea, _Q_000_F_004_RRRef bytea, _Q_000_F_005RRef bytea, _Q_000_F_006_TYPE bytea, _Q_000_F_006_RTRef bytea, _Q_000_F_006_RRRef bytea, _Q_000_F_007_TYPE bytea, _Q_000_F_007_RTRef bytea, _Q_000_F_007_RRRef bytea, _Q_000_F_008 boolean ) without oids
2024-05-03 17:12:02.915 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:02.942 MSK [39280] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:02.942 MSK [39280] DETAIL: Key (typname, typnamespace)=(tt3, 279699) already exists.
2024-05-03 17:12:02.942 MSK [39280] STATEMENT: drop table if exists tt3 cascade;create temporary table tt3 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:02.945 MSK [39280] WARNING: there is no transaction in progress
2024-05-03 17:12:12.553 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:12.553 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt1, 327468) already exists.
2024-05-03 17:12:12.553 MSK [39012] STATEMENT: drop table if exists tt1 cascade;create temporary table tt1 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:12.555 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:12:16.417 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:16.417 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt2, 327468) already exists.
2024-05-03 17:12:16.417 MSK [39012] STATEMENT: drop table if exists tt2 cascade;create temporary table tt2 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:16.419 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:12:22.563 MSK [39012] ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2024-05-03 17:12:22.563 MSK [39012] DETAIL: Key (typname, typnamespace)=(tt3, 327468) already exists.
2024-05-03 17:12:22.563 MSK [39012] STATEMENT: drop table if exists tt3 cascade;create temporary table tt3 (_C_1 bytea, _C_2 mvarchar(100), _C_3 mvarchar(100), _C_4 mvarchar(100), _C_5 mvarchar(100), _C_6 mvarchar(100), _C_7 mvarchar(2), _C_8 numeric(5, 0), _C_9 boolean, _TTC_1 bytea, SDBL_IDENTITY serial4 ) without oids
2024-05-03 17:12:22.564 MSK [39012] WARNING: there is no transaction in progress
2024-05-03 17:26:11.018 MSK [40776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.
В заказе есть исполнитель
При переводе заказа из архивного в актуальный, текущий исполнитель будет снят с задачи.
Выберите тип сделки
С безопасной сделкой вы всегда сможете вернуть средства, если что-то пойдет не так. С простой сделкой вы самостоятельно договариваетесь с исполнителем об оплате и берете на себя решение конфликтов.