Diagnose database synchronization issue

Inaendelea Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua

$30-250 USD

Kulipwa wakati wa kujifungua

Inaendelea Kulipwa wakati wa kujifungua

We have a PHP script that handles synchronization between two databases. The script runs on a 30 minute schedule and has a random anamoloy that we need to diagnose.

Database 1 is our accounting software database (source database - Providex)

Database 2 is our warehouse management database (destination database - MySQL)

Our script uses hash values in the destination database to check for NEW, UPDATES or DELETED records in the source database.

For NEW rows in the source: the record is selected from the source database and replicated in the destination database.

For UPDATE rows in the source: the changes are selected from the source database and replicated in the matching row of the destination database.

For DELETED rows in the source: the matching row in the destination database is deleted

We are seeing an issue happen occasionally and randomly where our script thinks that some of the rows in our table have been deleted from the source database and therefore are removed from the destination database. However, those lines have not been deleted from the source table. The next time the script runs, it detects that those lines are still in the source database and recreates them in the destination table as if they are brand new. We see this happening in our sales order details data but suspect it may be happening for all synced tables. However, since the order details table is our main transnational table, this one impacts us the most.

This issue is not reproducible on demand. It happens rarely and randomly.

The only two things that come to mind:

Connectivity - Could this sort of behavior happen if there is a disruption in the network? How to diagnose from the script side if this is the case? some sort of logging possible to confirm connectivity when the sync runs?

Script Bug - Could there be an error in the code that allows for this behavior? This is less likely given the rare and random occurrence - but not impossible.

We need someone to suggest some options for diagnosing the root cause of the issue.

Sync files are attached for review.

PHP MySQL Kuprogramu Database SQL

Kitambulisho cha Mradi: #24055414

Kuhusu mradi

16 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya coolguyinus2004
coolguyinus2004

Since its happening randomly then the script has to be checked randomly too for issues. I dont think thsi is happening due to connectivity i guess there is something in the code which overrides the basic function of wh Zaidi

$400 USD kwa siku 2
(Maoni 356)
7.7

16 wafanyakazi huru wanazabuni wastani wa $167 kwa kazi hii

Picha ya Profaili ya OutsourceMan
OutsourceMan

Greetings Craig L., This is Raman. As you can check PHP is our core set of expertise. We have done more than twenty projects in past month alone. Trust me we are expert at Diagnose database synchronization iss Zaidi

$157 USD kwa siku 7
(Maoni 427)
8.4
Picha ya Profaili ya gopalvora
gopalvora

Hi i can Diagnose database synchronization issue i am expert at , PHP , SQL , MySQL , Database Programming So send me Private message at PMB so we can discuss more about it Thanks

$140 USD kwa siku 7
(Maoni 532)
8.4
Picha ya Profaili ya milosjovanovic88
milosjovanovic88

Hi, My name is Milos from Serbia who is specialized in Web Dev. I am familiar with PHP/SQL/MySQL and I have experience with similar projects. I will offer the best quality for your project based on your feedback. Feel Zaidi

$100 USD kwa siku 2
(Maoni 6)
5.4
Picha ya Profaili ya palindromeguy
palindromeguy

Hi, I represent Cidrec Technologies Pvt. Ltd. We are a closed group of dynamic and versatile young individuals of different skill sets to make a complete team. For this particular project I want to briefly describe abo Zaidi

$140 USD kwa siku 7
(Maoni 20)
5.4
Picha ya Profaili ya mtdevil369
mtdevil369

Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks

$120 USD kwa siku 2
(Maoni 41)
5.2
Picha ya Profaili ya purplemaestro
purplemaestro

Hi my name is Muhammad Hassan. I have high level expertise in Mysql. I can check whats wrong with your current and I might fix that issue too. Regards Muhammad Hassan

$50 USD kwa siku 3
(Maoni 42)
5.2
Picha ya Profaili ya bestflancer
bestflancer

Hi I am a senior software engineer. I can suggest the following options a) Instead of deleting the record, we keep some flag (is_deleted) for deletion b) We can reconfirm the record before deletion from the destinatio Zaidi

$250 USD kwa siku 7
(Maoni 13)
4.8
Picha ya Profaili ya matinict
matinict

Hi, I am 7 year+ Web Application Developer with LEMP/LAMP/Docker stack, Also Certified oracle database expert & Magento 2 . I am interested to work with you on this project, I would like to have a convenient time of yo Zaidi

$244 USD kwa siku 3
(Maoni 7)
3.2
Picha ya Profaili ya azam72
azam72

I have gone through the above-mentioned details very well. I have got plenty of experience in php, sql, mysql, database programming kinds of works and I can assure you that I can reach your satisfaction level by provid Zaidi

$117 USD kwa siku 7
(Maoni 2)
3.0
Picha ya Profaili ya AkramDumas
AkramDumas

Hi I saw your project details and interested in that. I am PHP and MySql expert. if you hire me then you will see successful result. thank you!!

$30 USD kwa siku 3
(Maoni 1)
0.8
Picha ya Profaili ya wajahatalii88
wajahatalii88

Hello I am interested in working with you on this project. Please let me know if we can meet up today or tomorrow on Skype to discuss this further. Thanks

$166 USD kwa siku 5
(Maoni 0)
0.0
Picha ya Profaili ya drita3010
drita3010

I am new comers .work hard Relevant Skills and Experience Medical field

$155 USD kwa siku 3
(Maoni 0)
0.0
Picha ya Profaili ya swapnilpj
swapnilpj

Hi, I am Oracle Certified DBA with 15 years of experience working with Oracle E-business Suite 11i, R12, R12.2 and Databases 9i, 10g, 11g, 12c. Expertise in supporting, installing, administering, upgrade and migrate O Zaidi

$250 USD kwa siku 15
(Maoni 0)
0.0
Tuma Mradi Kama huu