Re: [Semediawiki-user] RuntimeException due to read-only when upgrading SMW

[James HK <jam...@gm...>]

Hi,

> change to SMW's Database.php. However, the refresh still breaks, referring
> to a missing t6 table, as shown in this gist

For some queries, SMW creates so called temporary tables to cache
pre-computed results (mainly for hierarchies, property chains etc.).
The 'en_wikidb_gw2.t6' is such temporary table and the question
remains as to why the table [0] is not reachable by the time the query
request is executed.

[0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/blob/master/includes/storage/SQLStore/SMW_SQLStore3_Queries.php#L977

Cheers

On 8/21/14, Justin Lloyd <jl...@gm...> wrote:
> Hi again,
>
> I'm still having trouble with upgrading SMW. Here
> <http://wikimedia.7.x6.nabble.com/RuntimeException-due-to-read-only-when-upgrading-SMW-td5032521.html.>
> is the original message I posted with a couple of replies to private
> responses I'd received.
>
> To recap: I've been running MW 1.20.8 and on my test environment I've now
> upgraded to 1.23.2, along with updating all of the extensions we use.
> Initially, though I did not upgrade SMW, leaving it at 1.8.0.5 (along with
> SRF, Maps, etc.). Then I upgraded SMW to 1.9.2 (upgrading related
> extensions as well) using Composer and then re-ran the MW update script
> followed by the SMW_refreshData.php script (with -d 50 -v, per the SMW
> upgrade docs). That leads again to the read-only error in the gist linked
> in the original email below. So I've now tried upgrading to SMW 2.0 for
> various reasons but since it does appear to incorporate the suggested
> change to SMW's Database.php. However, the refresh still breaks, referring
> to a missing t6 table, as shown in this gist
> <https://gist.github.com/Calygos/325e3f050b1bb22b2cec>.
>
> This is almost certainly all replication issues but I am not sure why I'm
> having such trouble with a replication configured I've used for over two
> years now. Any suggestions would be greatly appreciated and let me know
> what further information could help troubleshoot this problem.
>
> Thanks,
> Justin
>
>
> On Mon, Jul 21, 2014 at 4:34 PM, Justin Lloyd <jl...@gm...> wrote:
>
>> Hi all,
>>
>> I am trying to upgrade SMW from 1.8.0.5 to 1.9.2 (at the same time I'm
>> upgrading MW from 1.20.8 to 1.23.1). I first run the update.php script
>> and
>> then the refreshData.php script with -f, -d 50, and -v flags. However,
>> after about 30 seconds of processing, it errors out like so:
>> https://gist.github.com/Calygos/a9ae5e63d151796ef570
>>
>> The database server setup, which is how it's been since I created the
>> wiki, is a standard MySQL master-replica pair with $wgDBservers listing
>> the
>> master first with load = 0 and the replica second with load = 1.
>>
>> Any advice would be appreciated.
>>
>>
> ------------------------------------------------------------------------------
> Slashdot TV.
> Video for Nerds.  Stuff that matters.
> http://tv.slashdot.org/
> _______________________________________________
> Semediawiki-user mailing list
> Sem...@li...
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>