2017-10-13 15:12:15   info   : (25545) [qc_sqlite] Parsing the query failed, cannot report query type: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '1'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '7'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '2'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '8'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('2946','3292','3331','3338','5497','6493','8450','8455','8460','8465','16160','16185','16200','16205','16290','22390','22526','22561','22591','29389','29399','29424','29459','31886','37380','37425','37450','38162','38213','45901','45971','55117','55157','55367','55377','55502','55547','55592','87300','87310','87535','137456','137711','137721','137851','137896','137941','151324','151338','152333','152350','152577','167730','167775','167790','167868','167878','167898','168258','168338','168348','169738','170554','170579','170929','170979','226723','226758','226903','226913','226923','227536','249321','251391','292281','295941','295956','295961','295991','295996','296541','296626','296631','296701','296711')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '3'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('3001','3331','6493','6941','8450','8455','8460','8465','9015','11916','16160','16185','16200','16205','16290','17902','17920','22390','22526','22561','22591','28587','29389','29399','29424','29459','31886','37380','37425','37450','38157','38162','38213','45901','45921','45971','47748','47753','48277','55117','55157','55377','55502','55547','55592','70414','86064','87300','87310','87535','137456','137711','137721','137851','137896','137941','147064','209127','233339')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '5'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )ORDER BY capability
2017-10-13 15:12:15   info   : (25545) [qc_sqlite] Parsing the query failed, cannot report query operation: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '1'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '7'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '2'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '8'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('2946','3292','3331','3338','5497','6493','8450','8455','8460','8465','16160','16185','16200','16205','16290','22390','22526','22561','22591','29389','29399','29424','29459','31886','37380','37425','37450','38162','38213','45901','45971','55117','55157','55367','55377','55502','55547','55592','87300','87310','87535','137456','137711','137721','137851','137896','137941','151324','151338','152333','152350','152577','167730','167775','167790','167868','167878','167898','168258','168338','168348','169738','170554','170579','170929','170979','226723','226758','226903','226913','226923','227536','249321','251391','292281','295941','295956','295961','295991','295996','296541','296626','296631','296701','296711')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '3'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('3001','3331','6493','6941','8450','8455','8460','8465','9015','11916','16160','16185','16200','16205','16290','17902','17920','22390','22526','22561','22591','28587','29389','29399','29424','29459','31886','37380','37425','37450','38157','38162','38213','45901','45921','45971','47748','47753','48277','55117','55157','55377','55502','55547','55592','70414','86064','87300','87310','87535','137456','137711','137721','137851','137896','137941','147064','209127','233339')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '5'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )ORDER BY capability
2017-10-13 15:12:15   info   : (25545) [qc_sqlite] Parsing the query failed, cannot report query operation: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '1'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '7'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '2'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '8'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('2946','3292','3331','3338','5497','6493','8450','8455','8460','8465','16160','16185','16200','16205','16290','22390','22526','22561','22591','29389','29399','29424','29459','31886','37380','37425','37450','38162','38213','45901','45971','55117','55157','55367','55377','55502','55547','55592','87300','87310','87535','137456','137711','137721','137851','137896','137941','151324','151338','152333','152350','152577','167730','167775','167790','167868','167878','167898','168258','168338','168348','169738','170554','170579','170929','170979','226723','226758','226903','226913','226923','227536','249321','251391','292281','295941','295956','295961','295991','295996','296541','296626','296631','296701','296711')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '3'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('3001','3331','6493','6941','8450','8455','8460','8465','9015','11916','16160','16185','16200','16205','16290','17902','17920','22390','22526','22561','22591','28587','29389','29399','29424','29459','31886','37380','37425','37450','38157','38162','38213','45901','45921','45971','47748','47753','48277','55117','55157','55377','55502','55547','55592','70414','86064','87300','87310','87535','137456','137711','137721','137851','137896','137941','147064','209127','233339')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '5'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )ORDER BY capability
2017-10-13 15:12:15   info   : (25545) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: , stmt: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '1'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '7'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id = '2'	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '8'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('2946','3292','3331','3338','5497','6493','8450','8455','8460','8465','16160','16185','16200','16205','16290','22390','22526','22561','22591','29389','29399','29424','29459','31886','37380','37425','37450','38162','38213','45901','45971','55117','55157','55367','55377','55502','55547','55592','87300','87310','87535','137456','137711','137721','137851','137896','137941','151324','151338','152333','152350','152577','167730','167775','167790','167868','167878','167898','168258','168338','168348','169738','170554','170579','170929','170979','226723','226758','226903','226913','226923','227536','249321','251391','292281','295941','295956','295961','295991','295996','296541','296626','296631','296701','296711')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '3'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )		 ctx.path, rc.roleid, rc.capability, rc.permission	             FROM m20_role_capabilities rc	             JOIN m20_context ctx	                  ON (ctx.id = rc.contextid)	             JOIN m20_context pctx	                  ON (pctx.id IN ('3001','3331','6493','6941','8450','8455','8460','8465','9015','11916','16160','16185','16200','16205','16290','17902','17920','22390','22526','22561','22591','28587','29389','29399','29424','29459','31886','37380','37425','37450','38157','38162','38213','45901','45921','45971','47748','47753','48277','55117','55157','55377','55502','55547','55592','70414','86064','87300','87310','87535','137456','137711','137721','137851','137896','137941','147064','209127','233339')	                      AND (ctx.id = pctx.id	                           OR ctx.path LIKE CONCAT(pctx.path, '/%')	                           OR pctx.path LIKE CONCAT(ctx.path, '/%')))	        LEFT JOIN m20_block_instances bi	                  ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)	        LEFT JOIN m20_context bpctx	                  ON (bpctx.id = bi.parentcontextid)	            WHERE rc.roleid = '5'	                  AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)	           )ORDER BY capability 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: select 1 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_BEGIN_TRX|QUERY_TYPE_DISABLE_AUTOCOMMIT, stmt: SET autocommit=0 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Session write, routing to all servers.
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.33]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.34]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Slave 'vmdbc02' responded before master to a session command. Result: 0
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Server 'vmdbc05' responded to a session command, sending the response to the client.
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: delete from StorageRecords where expires<=1507900475872 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: SHOW WARNINGS 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_COMMIT, stmt: commit 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Session write, routing to all servers.
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.33]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to slave 	[10.14.22.34]:3306 
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Slave 'vmdbc04' responded before master to a session command. Result: 0
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Slave 'vmdbc02' responded before master to a session command. Result: 0
2017-10-13 15:14:35   info   : (15132) [readwritesplit] Server 'vmdbc05' responded to a session command, sending the response to the client.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_BEGIN_TRX|QUERY_TYPE_DISABLE_AUTOCOMMIT, stmt: SET autocommit=0 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Session write, routing to all servers.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.33]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.34]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Slave 'vmdbc02' responded before master to a session command. Result: 0
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Slave 'vmdbc04' responded before master to a session command. Result: 0
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Server 'vmdbc05' responded to a session command, sending the response to the client.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Session write, routing to all servers.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.33]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Backend [10.14.22.33]:3306 already executing sescmd.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to slave 	[10.14.22.34]:3306 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Server 'vmdbc05' responded to a session command, sending the response to the client.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT * FROM shibpid WHERE localEntity= 'https://idp.school.de/idp/shibboleth' AND peerEntity= 'https://bildung365.de/shibboleth' AND localId= 'surname.name@stud.school.de' AND (deactivationDate IS NULL OR deactivationDate = (SELECT MAX(deactivationDate) FROM shibpid WHERE localEntity= 'https://idp.school.de/idp/shibboleth' AND peerEntity= 'https://bildung365.de/shibboleth' AND localId= 'surname.name@stud.school.de')) ORDER BY creationDate DESC 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Backend [10.14.22.33]:3306 processed reply and starts to execute active cursor.
2017-10-13 15:16:11   info   : (14789) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: INSERT INTO shibpid (localEntity, peerEntity, persistentId, principalName, localId, peerProvidedId, creationDate, deactivationDate) VALUES ('https://idp.school.de/idp/shibboleth', 'https://bildung365.de/shibboleth', 'uJ29gedsaMnjsadD29wW6dtvy5E=', 'surname.name@stud.school.de', 'surname.name@stud.school.de', null, '2017-10-13 15:15:19', null) 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:11   info   : (14789) [readwritesplit] > Autocommit: [disabled], trx is [open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_COMMIT, stmt: commit 
2017-10-13 15:16:11   info   : (14789) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:52   info   : (26840) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync	          FROM m20_files f	     LEFT JOIN m20_files_reference r	               ON f.referencefileid = r.id	         WHERE f.pathnamehash = '9ecbe799a978e05a73cc33bbcabfde5faec52e3f' 
2017-10-13 15:16:52   info   : (26840) [readwritesplit] Route query to slave 	[10.14.22.34]:3306 <
2017-10-13 15:16:54   info   : (25448) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT ra.*, ctx.path	          FROM m20_role_assignments ra	          JOIN m20_context ctx ON ra.contextid = ctx.id	         WHERE ra.userid = '5339' AND (ctx.id IN ('9717','8201','1') OR ctx.path LIKE '/1/8201/9717/%') 
2017-10-13 15:16:55   info   : (26926) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: UPDATE m20_cache_flags SET flagtype = 'userpreferenceschanged',name = '56022',timemodified = '1507900615',value = '1',expiry = '1507907815' WHERE id='11843372' 
2017-10-13 15:16:55   info   : (26926) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:55   info   : (26929) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: UPDATE m20_sessions SET timemodified = '1507900615' WHERE id='10497552' 
2017-10-13 15:16:55   info   : (26929) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:56   info   : (26934) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT * FROM m20_course WHERE category = '0' 
2017-10-13 15:16:56   info   : (26934) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 <
2017-10-13 15:16:56   info   : [readwritesplit] Servers and router connection counts:
2017-10-13 15:16:56   info   : [readwritesplit] current operations : 0 in 	[10.14.22.32]:3306 RUNNING SLAVE
2017-10-13 15:16:56   info   : [readwritesplit] current operations : 0 in 	[10.14.22.33]:3306 RUNNING SLAVE
2017-10-13 15:16:56   info   : [readwritesplit] current operations : 0 in 	[10.14.22.34]:3306 RUNNING SLAVE
2017-10-13 15:16:56   info   : [readwritesplit] current operations : 3 in 	[10.14.22.35]:3306 RUNNING MASTER
2017-10-13 15:16:56   info   : [readwritesplit] Selected RUNNING SLAVE in 	[10.14.22.32]:3306
2017-10-13 15:16:56   info   : [readwritesplit] Selected RUNNING SLAVE in 	[10.14.22.33]:3306
2017-10-13 15:16:56   info   : [readwritesplit] Selected RUNNING SLAVE in 	[10.14.22.34]:3306
2017-10-13 15:16:56   info   : [readwritesplit] Selected RUNNING MASTER in 	[10.14.22.35]:3306
2017-10-13 15:16:57   info   : (26282) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_WRITE, stmt: UPDATE m20_lock_db            SET                expires = '1507987017',                owner = '7e3b4b8d-30d3-4100-baf5-61fd89a1188d'          WHERE                resourcekey = 'adhoc_109162' AND                (owner IS NULL OR expires < '1507900617') 
2017-10-13 15:16:57   info   : (26282) [readwritesplit] Route query to master 	[10.14.22.35]:3306 <
2017-10-13 15:16:57   info   : (26282) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT COUNT('x') FROM m20_lock_db WHERE owner = '7e3b4b8d-30d3-4100-baf5-61fd89a1188d' AND resourcekey = 'adhoc_109162' 
2017-10-13 15:16:57   info   : (26282) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 <
2017-10-13 15:16:57   error  : Failed to execute query on server 'vmdbc05' ([10.14.22.35]:3306): Lost connection to MySQL server during query
2017-10-13 15:16:57   notice : Server changed state: vmdbc04[10.14.22.34:3306]: new_master. [Slave, Synced, Running] -> [Master, Synced, Running]
2017-10-13 15:16:57   notice : Server changed state: vmdbc05[10.14.22.35:3306]: lost_master. [Master, Synced, Running] -> [Running]
2017-10-13 15:16:57   info   : (26282) [readwritesplit] > Autocommit: [enabled], trx is [not open], cmd: (0x03) MYSQL_COM_QUERY, type: QUERY_TYPE_READ, stmt: SELECT 'x' FROM m20_lock_db WHERE resourcekey = 'adhoc_109167' LIMIT 0, 1 
2017-10-13 15:16:57   info   : (26282) [readwritesplit] Route query to slave 	[10.14.22.32]:3306 <
2017-10-13 15:16:57   error  : (26282) [readwritesplit] Server [10.14.22.35]:3306 lost the master status. Readwritesplit service can't locate the master. Client sessions will be closed.
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [26282]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [26926]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [26934]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [26929]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [14789]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [15132]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [25448]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [26840]
2017-10-13 15:16:57   info   : Stopped Splitter Service client session [13519]
2017-10-13 15:16:57   info   : [readwritesplit] Servers and router connection counts:
2017-10-13 15:16:57   info   : [readwritesplit] current operations : 0 in 	[10.14.22.32]:3306 RUNNING SLAVE
2017-10-13 15:16:57   info   : [readwritesplit] current operations : 0 in 	[10.14.22.33]:3306 RUNNING SLAVE
2017-10-13 15:16:57   info   : [readwritesplit] current operations : 0 in 	[10.14.22.34]:3306 RUNNING MASTER
2017-10-13 15:16:57   info   : [readwritesplit] current operations : 0 in 	[10.14.22.35]:3306 RUNNING (only)
2017-10-13 15:16:57   info   : [readwritesplit] Couldn't connect to maximum number of slaves. Connected successfully to 2 slaves of 2 of them.
2017-10-13 15:16:57   info   : [readwritesplit] Selected RUNNING SLAVE in 	[10.14.22.32]:3306
2017-10-13 15:16:57   info   : [readwritesplit] Selected RUNNING SLAVE in 	[10.14.22.33]:3306
2017-10-13 15:16:57   info   : [readwritesplit] Selected RUNNING MASTER in 	[10.14.22.34]:3306