Hi
analytics-store tmp space filled up today with many large temporary tables (it was ~32G) from many slow research queries. Those had to be killed, the database process restarted, and tmp space expanded.
It's back up now.
Sean
Thanks Sean!
On Thu, Apr 30, 2015 at 1:21 AM, Sean Pringle springle@wikimedia.org wrote:
Hi
analytics-store tmp space filled up today with many large temporary tables (it was ~32G) from many slow research queries. Those had to be killed, the database process restarted, and tmp space expanded.
It's back up now.
Sean
DBA @ WMF
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Some weird replication behavior is occurring after last week's issue. S7 shard is not replicating data, even though configuration has not changed and no errors are being logged. The affected wikis are:
arwiki cawiki eswiki fawiki frwiktionary hewiki huwiki kowiki metawiki rowiki ukwiki viwiki
Also the centralauth db.
The other shards seem ok with recent and correct data.
More info to follow.
On Fri, May 1, 2015 at 2:59 AM, Marcel Ruiz Forns mforns@wikimedia.org wrote:
Thanks Sean!
On Thu, Apr 30, 2015 at 1:21 AM, Sean Pringle springle@wikimedia.org wrote:
Hi
analytics-store tmp space filled up today with many large temporary tables (it was ~32G) from many slow research queries. Those had to be killed, the database process restarted, and tmp space expanded.
It's back up now.
Sean
DBA @ WMF
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Thanks much for the heads up, Sean.
On Thu, May 7, 2015 at 12:15 PM, Sean Pringle springle@wikimedia.org wrote:
Some weird replication behavior is occurring after last week's issue. S7 shard is not replicating data, even though configuration has not changed and no errors are being logged. The affected wikis are:
arwiki cawiki eswiki fawiki frwiktionary hewiki huwiki kowiki metawiki rowiki ukwiki viwiki
Also the centralauth db.
The other shards seem ok with recent and correct data.
More info to follow.
On Fri, May 1, 2015 at 2:59 AM, Marcel Ruiz Forns mforns@wikimedia.org wrote:
Thanks Sean!
On Thu, Apr 30, 2015 at 1:21 AM, Sean Pringle springle@wikimedia.org wrote:
Hi
analytics-store tmp space filled up today with many large temporary tables (it was ~32G) from many slow research queries. Those had to be killed, the database process restarted, and tmp space expanded.
It's back up now.
Sean
DBA @ WMF
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- DBA @ WMF
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics