Maha : Elgg.org

Maha

- Maha@mahalucky
Maha added a new discussion topic Elgg (2.3.4) - Duplicate entries in meta data table in the group Professional Services 2015 days ago

Hi, Sometimes (when traffic is high), the entries in metadata table are duplicated on updating / creating. Is there any solution for this? This issue is really breaking our system.
- Norman Foster@Dev_321
  
  Norman Foster 2006 days ago
  Dear Maha,
  Greetings!
  
  I have studied your requirement and according to my understanding there is something which probably causing the insert script to run more than once. It either may be due to wrong sql query, hitting the insert script many times, or may be the button at which the script run is clicked many times.
  
  I can resolve this issue by debugging the code or I can apply a sql transaction to insert one entry at a time or no entry at all and we can also disable the button at first click till transaction completes so that the script doesn't run more than once.
  
  I will estimate the required time to resolve this issue only after testing the web application and it's complexity, So please answer some of my queries:-
  
  1. Please provide the same url of page where issue is occurring.
  2. Also please provide db details to check the data duplication entry.
  
  Please do share your email address & Skype ID if possbile so that we can communicate better.
  
  Looking forward to your response.
  
  Warm Regards,
  Norman F.
  S.K.Y.P.E ID: live:norman_2445
- Norman Foster@Dev_321
  
  Norman Foster 2004 days ago
  Dear Maha,
  Greetings!
  
  I hope you checked my recent message.
  
  Please share your views regarding the same.
  
  Thanks,
  Norman F.
- Maha@mahalucky
Maha joined the group Professional Services 2015 days ago
- Maha@mahalucky
Maha added a new discussion topic Elgg (2.3.4) - Duplicate entries in meta data table in the group Elgg Technical Support 2015 days ago

Hi, Sometimes (when traffic is high), the entries in metadata table are duplicated on updating / creating. Is there any solution for this? This issue is really breaking our system.
- Maha@mahalucky
Maha added a new discussion topic Elgg 2.x Server - Seeing duplicate entries in metadata table in the group Elgg Technical Support 2217 days ago

In metadata table, duplicate entries for the combination - entity_guid, name_id, value_id, value_type, owner_guid, access_id, enabled. Some times, the time_created is also same. I am not able to get hold of what is causing this duplicate...
- Maha@mahalucky
Maha joined the group Elgg Technical Support 2217 days ago

Maha

Send private message

Friends

Group membership

Elgg Technical Support

Professional Services

Activity

Navigation

Contact

Legal