Today I discovered that our `ips_site_page` field is to small to store all page titles out there (eg. https://www.wikidata.org/wiki/Q6703647 is affected by that). The field is defined as `varbinary(255) NOT NULL` which would be enough for the page titles (page_title is varbinary(255) everywhere), but it's not large enough to hold the page titles plus their namespaces (that's how we store the titles, unlike the `page` table which has a separate int field for them).
To make that field fit for all pages on every Wikimedia wiki we should go for a length of at very least 300, as the longest page title I could find has 255 chars and the longest non-talk namespace has a length of 39 (The longest talk namespace has a length of 67!), also we need to store the colon. I'd suggest to go for a bit more than that, just to play it safe.