Also, this appears to be the same as this issue: https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/2532
----- On Jan 23, 2020, at 9:59 PM, Mark A. Hershberger m...@everybody.org wrote: > "[[kgh]]" <mediaw...@kghoffmeyer.de> writes: > >> I guess always helps revealing what environment you use, e.g. PHP, >> MariaDB, MW, SMW, etc. Cheers, Karsten > > You're right, but in the meantime, I found a fix for my problem. > > In any case here are the specs: > > - PHP: 5.6.40 > - DB: Percona cluster with 3 servers. 5.7.23 > - MW 1.2.3 > - SMW: 2.5.7 (55b550a) > > So, this afternoon, i gained some understanding of why my code didn't > work. The table "{$wgDBprefix}t3" is supposed to exist -- it a temporary > table that is created in HierarchyTempTableBuilder -- and it was > created, but it is an in-memory temporary table that SMW knew was the > replica db. In-memory temporary tables, at least in my configuration, > are not replicated. > > So, when the query I sent was run, the temp table existed on the replica > but not on the master. And the query I sent was run against the master. > > I think this is a bug which I'll report tomorrow, but I've worked around > it in the meantime with the following in my LocalSettings.php: > > $smwgLocalConnectionConf = [ > 'mw.db' => [ > 'read' => DB_MASTER, > 'write' => DB_MASTER > ], > 'mw.db.queryengine' => [ > 'read' => DB_MASTER, > 'write' => DB_MASTER > ] > ]; > > Thanks for your indulgence, > > Mark. > > > _______________________________________________ > Semediawiki-devel mailing list > Semediawiki-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/semediawiki-devel _______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel