Thread:Project:Support desk/Not posting content/reply (7)

Done some logging. Maybe these results mean something. They're a bit cut-off, but general actions were kept.

First, following is the mySql log for an edit that went wrong (i.e. row in `text` table disappears). After the last command here the next DB activity was 2 seconds later by a different user (anon). The user having the problem doesn't appear for another 2 minutes or so in the logs, when he does his next edit.

I would like to note that it seems to happen to a specific user on a specific page, or a few specific pages. As far as we can tell, each user may have the pages where this error is met. Other users have complained of something similar for a short period of time, now only this one complains, and is able to recreate, as far as we know.

Note 2: All other queries besides INSERT INTO `text` went well. As a matter of fact, INSERT INTO `text` also worked, seeing as he received an old_id/rev_text_id for the next query and the auto increment of the table has advanced - the next entry skips a number. It's just that the row disappears later on with no explanation.

This is him editing my talk page:

---BAD--- COMMIT BEGIN INSERT INTO `text` INSERT INTO `revision` UPDATE `page` SET page_latest INSERT INTO `recentchanges` INSERT INTO `cu_changes` SELECT wl_user  FROM `watchlist` SELECT user_id  FROM `user` SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,user_email,user_touched,use SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,user_email,user_touched,use SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache` SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,user_email,user_touched,use SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` SELECT lc_value  FROM `l10n_cache` SELECT lc_value  FROM `l10n_cache`

Here is an edit of his to his own talk page (saying the previous edit didn't work), it goes through smoothly:

---GOOD--- COMMIT BEGIN INSERT INTO `text` INSERT INTO `revision` UPDATE `page` SET page_latest INSERT INTO `recentchanges` INSERT INTO `cu_changes` SELECT wl_user FROM `watchlist` COMMIT BEGIN UPDATE `watchlist` SET wl_notificationtimestamp COMMIT BEGIN SELECT user_id FROM `user` SELECT user_id,user_name,user_real_name,user_password,user_newpasswo SELECT ug_group FROM `user_groups` SELECT up_property,up_value FROM `user_properties` SELECT * FROM `user` SELECT up_property,up_value FROM `user_properties` INSERT INTO `logging` UPDATE `user` SET user_editcount=user_editcount+1 SELECT 1 FROM `user` UPDATE `user` SET user_touched = '20121227211743' COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN SELECT pl_namespace,pl_title FROM `pagelinks` SELECT il_to FROM `imagelinks` SELECT el_to FROM `externallinks` SELECT ll_lang,ll_title FROM `langlinks` SELECT iwl_prefix,iwl_title FROM `iwlinks` SELECT tl_namespace,tl_title FROM `templatelinks` SELECT cl_to,cl_sortkey_prefix FROM `categorylinks` SELECT pp_propname,pp_value FROM `page_props` SELECT page_namespace,page_title,page_id FROM SELECT wl_notificationtimestamp FROM `watchlist` COMMIT BEGIN UPDATE `site_stats` SET ss_total_edits=ss_total_edits+1" COMMIT

These are my edits to the same two pages, preceding the actions shown above, asking him to attempt to recreate the error:

--OTHER-- COMMIT BEGIN INSERT INTO `text` INSERT INTO `revision` UPDATE `page` SET page_latest INSERT INTO `recentchanges` INSERT INTO `cu_changes` SELECT wl_user  FROM `watchlist` SELECT user_id  FROM `user` SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,u SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` INSERT INTO `logging` UPDATE `user` SET user_editcount=user_editcount+1 SELECT 1  FROM `user` UPDATE `user` SET user_touched = '20121227110044' COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN SELECT pl_namespace,pl_title  FROM `pagelinks` SELECT il_to  FROM `imagelinks` SELECT el_to  FROM `externallinks` SELECT ll_lang,ll_title  FROM `langlinks` SELECT iwl_prefix,iwl_title  FROM `iwlinks` SELECT tl_namespace,tl_title  FROM `templatelinks` SELECT cl_to,cl_sortkey_prefix  FROM `categorylinks` SELECT pp_propname,pp_value  FROM `page_props` SELECT page_namespace,page_title,page_id  FROM `templatelinks`,`page SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,u SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` SELECT page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len  FROM `page` SELECT rev_id  FROM `revision` SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_ INSERT IGNORE INTO `user_newtalk` SELECT 1  FROM `user` UPDATE `user` SET user_touched = '20121227110044' SELECT wl_notificationtimestamp  FROM `watchlist` COMMIT BEGIN UPDATE `site_stats` SET ss_total_edits=ss_total_edits+1 COMMIT COMMIT BEGIN INSERT INTO `text` INSERT INTO `revision` UPDATE `page` SET page_latest INSERT INTO `recentchanges` INSERT INTO `cu_changes` SELECT wl_user  FROM `watchlist` SELECT user_id  FROM `user` SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,user_emai SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` INSERT INTO `logging` UPDATE `user` SET user_editcount=user_editcount+1 SELECT 1  FROM `user` UPDATE `user` SET user_touched COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN REPLACE INTO `objectcache` (keyname,value,exptime) VALUES COMMIT BEGIN SELECT pl_namespace,pl_title  FROM `pagelinks` SELECT il_to  FROM `imagelinks` SELECT el_to  FROM `externallinks` SELECT ll_lang,ll_title  FROM `langlinks` SELECT iwl_prefix,iwl_title  FROM `iwlinks` SELECT tl_namespace,tl_title  FROM `templatelinks` SELECT cl_to,cl_sortkey_prefix  FROM `categorylinks` SELECT pp_propname,pp_value  FROM `page_props` SELECT page_namespace,page_title,page_id  FROM `templatelinks`,`page` SELECT user_id,user_name,user_real_name,user_password,user_newpassword,user_newpass_time,user_emai SELECT ug_group  FROM `user_groups` SELECT up_property,up_value  FROM `user_properties` SELECT page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len  FROM `page`,`revision` SELECT rev_id  FROM `revision` SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_ed INSERT IGNORE INTO `user_newtalk` (user_id,user_last_timestamp) VALUES SELECT 1  FROM `user` UPDATE `user` SET user_touched SELECT wl_notificationtimestamp  FROM `watchlist` COMMIT BEGIN UPDATE `site_stats` SET ss_total_edits=ss_total_edits+1 COMMIT

Please help! (I acknowledge this is funny, but it is somewhat frustrating as well)