Database error on MSQL Server
There is a database that is configured through the MSQL server which operates through replication to another 4 points.
During the reprocessing of documents on the server for the past period, an error was issued
After that, a decision was made to restore the database on the server from a backup, the error of reprocessing documents remained, but was corrected by changing the Range from 80 to 100
After this, all documents were reprocessed, however, on the server now during the modification of documents an error occurs
on all other devices everything works properly and there is the ability to modify documents without errors.
As far as I understand, after restoring the database from the backup, some tables got corrupted and this error occurs on the server
If the same document is processed multiple times on the server, the key value changes, however, from the 3rd or 4th time it behaves without error
-
странно. это ошибка приложения, что пытается добавить "старую" запись? тогда попробовать перезапустить приложение, мож в "очереди" залипло. и просится простое, но опасное решение - удалить эту запись с этим ключем... риск нарушить структуру данных. залипательная задачка.
-
проблема вже більше місяця , але є запасний ноут з клієнтом де все працює і перепроводиться.
На другий третій раз коли нажимаєш провести все проводиться і змінюється Value key з кожним нажимом провести
-
ух ты. т.е. на тестовом все ок, а на проде лажа? попробуйте поднять еще один тестовый, а на проде основытельно почистить кеши и буферы на всех уровнях, начиная с odbc (еще тот вредина). я с mSQL ооочень давно танцевал, но удаление записи, особенно если возможность восстановить лапками взаимосвязанные данные, уже не кажется плохой идеей.
-
Current freelance projects in the category Software & Server Configuration
Need a system administrator
170 USD
We need an outsourced System Administrator. Responsibilities: • Configuration and support of the 1C server; • Migration of 1C (BAS) from a file system to a client-server (SQL); • Technical maintenance of office equipment and internet connections: - 2 printers - 1 scanner - 4-6… System & Network Administration, Software & Server Configuration ∙ 2 days 9 hours back ∙ 15 proposals |
Diagnosis and elimination of recurring WhatsApp Business blocksTask Description A specialist is required with experience in WhatsApp Business and Meta Business to analyze and resolve the reasons for the constant blocking of the WhatsApp Business account. Problem: When logging into the WhatsApp Business account, it is almost immediately… Cybersecurity & Data Protection, Software & Server Configuration ∙ 6 days 4 hours back ∙ 5 proposals |
Installation and configuration of the Listmonk platform (or an equivalent) on VPS Ubuntu 22.04 for email newsletters.
70 USD
Looking for a specialist to deploy and configure a self-hosted platform for HTML-CSS email newsletters. I have a VPS (Ubuntu 22.04 x64 1 GB RAM, 21 GB Disk) + a website on it, SMTP settings from the domain provider. Requirements: Install Listmonk (leaning towards it due to 1 GB… Web Programming, Software & Server Configuration ∙ 10 days 7 hours back ∙ 43 proposals |
Rovno