System resource exceeded: Difference between revisions
Ttenbergen (talk | contribs) m →Current status of this problem: This section is now just noise, we have list of locations with this error and with work around in next section. |
Ttenbergen (talk | contribs) |
||
| Line 45: | Line 45: | ||
== Solution approach: Purging some old data from centralized == | == Solution approach: Purging some old data from centralized == | ||
I made a copy and deleted all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). This shrunk centralized from 1GB to 618MB. | I made a copy and deleted all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). This shrunk centralized from 1GB to 618MB. However, it did '''not''' solve the problem. | ||
== Solution approach: Query size limiting == | == Solution approach: Query size limiting == | ||