Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 8000012e; asc .;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 8000025a; asc Z;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 8000012e; asc .;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 8000025b; asc [;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 8000012e; asc .;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 8000025a; asc Z;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 8000012e; asc .;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 8000025b; asc [;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 80000718; asc ;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 80004a78; asc Jx;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 80000718; asc ;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 80004a78; asc Jx;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 80000734; asc 4;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 80004bf8; asc K ;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:54 server5 mysqld[30807]: 2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 80000734; asc 4;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 80004bf8; asc K ;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:54 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:54 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:54 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:54 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:54 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:54 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:54 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:54 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:55 server5 mysqld[30807]: 2019-11-19 9:13:55 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:55 server5 mysqld[30807]: 0: len 4; hex 80000786; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 1: len 4; hex 80005024; asc P$;; Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 52; compact format; info bits 0 Nov 19 09:13:55 server5 mysqld[30807]: 0: len 4; hex 80002eb8; asc . ;; Nov 19 09:13:55 server5 mysqld[30807]: 1: len 6; hex 000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 2: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 3: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 4: len 4; hex 8000333f; asc 3?;; Nov 19 09:13:55 server5 mysqld[30807]: 5: len 10; hex 80000000000000002c50; asc ,P;; Nov 19 09:13:55 server5 mysqld[30807]: 6: len 10; hex 80000000000000000860; asc `;; Nov 19 09:13:55 server5 mysqld[30807]: 7: len 10; hex 80000000000000001400; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 8: len 10; hex 8000000000000000354c; asc 5L;; Nov 19 09:13:55 server5 mysqld[30807]: 9: len 1; hex 01; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 10: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 11: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 12: len 7; hex 8000000000000b; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 13: len 7; hex 80000000000015; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 14: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 15: len 8; hex 4c616e646c6f7264; asc Landlord;; Nov 19 09:13:55 server5 mysqld[30807]: 16: len 30; hex 4d616e6167656d656e7420436f6d6d697373696f6e206f6e2072656e7420; asc Management Commission on rent ; (total 88 bytes); Nov 19 09:13:55 server5 mysqld[30807]: 17: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 18: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 19: len 7; hex 8000000001a86a; asc j;; Nov 19 09:13:55 server5 mysqld[30807]: 20: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 21: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 22: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 23: len 1; hex 01; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 24: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 25: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 26: len 4; hex 80000002; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 27: len 0; hex ; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 28: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 29: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 30: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 31: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 32: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 33: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 34: len 5; hex 96da420000; asc B ;; Nov 19 09:13:55 server5 mysqld[30807]: 35: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 36: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 37: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 38: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 39: len 0; hex ; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 40: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 41: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 42: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 43: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 44: len 5; hex 99a2a8f92e; asc .;; Nov 19 09:13:55 server5 mysqld[30807]: 45: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 46: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 47: len 5; hex 999a1e0000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 48: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 49: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 50: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 51: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 1 sec starting index read Nov 19 09:13:55 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:55 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:55 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:55 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:55 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:55 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:55 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:55 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:55 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:55 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:55 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:55 server5 mysqld[30807]: 2019-11-19 9:13:55 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:55 server5 mysqld[30807]: 0: len 4; hex 80000786; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 1: len 4; hex 80005024; asc P$;; Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 52; compact format; info bits 0 Nov 19 09:13:55 server5 mysqld[30807]: 0: len 4; hex 80002eb8; asc . ;; Nov 19 09:13:55 server5 mysqld[30807]: 1: len 6; hex 000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 2: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 3: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 4: len 4; hex 8000333f; asc 3?;; Nov 19 09:13:55 server5 mysqld[30807]: 5: len 10; hex 80000000000000002c50; asc ,P;; Nov 19 09:13:55 server5 mysqld[30807]: 6: len 10; hex 80000000000000000860; asc `;; Nov 19 09:13:55 server5 mysqld[30807]: 7: len 10; hex 80000000000000001400; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 8: len 10; hex 8000000000000000354c; asc 5L;; Nov 19 09:13:55 server5 mysqld[30807]: 9: len 1; hex 01; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 10: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 11: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 12: len 7; hex 8000000000000b; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 13: len 7; hex 80000000000015; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 14: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 15: len 8; hex 4c616e646c6f7264; asc Landlord;; Nov 19 09:13:55 server5 mysqld[30807]: 16: len 30; hex 4d616e6167656d656e7420436f6d6d697373696f6e206f6e2072656e7420; asc Management Commission on rent ; (total 88 bytes); Nov 19 09:13:55 server5 mysqld[30807]: 17: len 7; hex 80000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 18: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 19: len 7; hex 8000000001a86a; asc j;; Nov 19 09:13:55 server5 mysqld[30807]: 20: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 21: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 22: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 23: len 1; hex 01; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 24: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 25: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 26: len 4; hex 80000002; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 27: len 0; hex ; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 28: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 29: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 30: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 31: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 32: len 3; hex 8fc10f; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 33: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 34: len 5; hex 96da420000; asc B ;; Nov 19 09:13:55 server5 mysqld[30807]: 35: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 36: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 37: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 38: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 39: len 0; hex ; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 40: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 41: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 42: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 43: len 1; hex 00; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 44: len 5; hex 99a2a8f92e; asc .;; Nov 19 09:13:55 server5 mysqld[30807]: 45: len 3; hex 8e1021; asc !;; Nov 19 09:13:55 server5 mysqld[30807]: 46: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 47: len 5; hex 999a1e0000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 48: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 49: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 50: len 10; hex 80000000000000000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: 51: len 4; hex 80000000; asc ;; Nov 19 09:13:55 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 1 sec starting index read Nov 19 09:13:55 server5 mysqld[30807]: mysql tables in use 4, locked 0 Nov 19 09:13:55 server5 mysqld[30807]: 0 lock struct(s), heap size 1136, 0 row lock(s) Nov 19 09:13:55 server5 mysqld[30807]: MySQL thread id 99, OS thread handle 140562364991232, query id 140116 81.149.181.174 absoluteesta5HV1 Sending data Nov 19 09:13:55 server5 mysqld[30807]: SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, Nov 19 09:13:55 server5 mysqld[30807]: #011(SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, Nov 19 09:13:55 server5 mysqld[30807]: #011(SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, Nov 19 09:13:55 server5 mysqld[30807]: #011deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, Nov 19 09:13:55 server5 mysqld[30807]: #011deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ Nov 19 09:13:55 server5 mysqld[30807]: #011FROM deal Nov 19 09:13:55 server5 mysqld[30807]: #011INNER JOIN rental ON rental.propref = deal.propref Nov 19 09:13:55 server5 mysqld[30807]: #011WHERE deal.cancelled = 0 Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:55 server5 mysqld[30807]: 2019-11-19 09:13:55 0x7fd739d58700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.3.11/storage/innobase/rem/rem0rec.cc line 820 Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: We intentionally generate a memory trap. Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: If you get repeated assertion failures or crashes, even Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: immediately after the mysqld startup, there may be Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: corruption in the InnoDB tablespace. Please refer to Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/ Nov 19 09:13:55 server5 mysqld[30807]: InnoDB: about forcing recovery. Nov 19 09:13:55 server5 mysqld[30807]: 191119 9:13:55 [ERROR] mysqld got signal 6 ; Nov 19 09:13:55 server5 mysqld[30807]: This could be because you hit a bug. It is also possible that this binary Nov 19 09:13:55 server5 mysqld[30807]: or one of the libraries it was linked against is corrupt, improperly built, Nov 19 09:13:55 server5 mysqld[30807]: or misconfigured. This error can also be caused by malfunctioning hardware. Nov 19 09:13:55 server5 mysqld[30807]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Nov 19 09:13:55 server5 mysqld[30807]: We will try our best to scrape up some info that will hopefully help Nov 19 09:13:55 server5 mysqld[30807]: diagnose the problem, but since we have already crashed, Nov 19 09:13:55 server5 mysqld[30807]: something is definitely wrong and this may fail. Nov 19 09:13:55 server5 mysqld[30807]: Server version: 10.3.11-MariaDB-1:10.3.11+maria~cosmic-log Nov 19 09:13:55 server5 mysqld[30807]: key_buffer_size=134217728 Nov 19 09:13:55 server5 mysqld[30807]: read_buffer_size=2097152 Nov 19 09:13:55 server5 mysqld[30807]: max_used_connections=60 Nov 19 09:13:55 server5 mysqld[30807]: max_threads=502 Nov 19 09:13:55 server5 mysqld[30807]: thread_count=67 Nov 19 09:13:55 server5 mysqld[30807]: It is possible that mysqld could use up to Nov 19 09:13:55 server5 mysqld[30807]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3226530 K bytes of memory Nov 19 09:13:55 server5 mysqld[30807]: Hope that's ok; if not, decrease some variables in the equation. Nov 19 09:13:55 server5 mysqld[30807]: Thread pointer: 0x7fd7242a8df8 Nov 19 09:13:55 server5 mysqld[30807]: Attempting backtrace. You can use the following information to find out Nov 19 09:13:55 server5 mysqld[30807]: where mysqld died. If you see no messages after this, something went Nov 19 09:13:55 server5 mysqld[30807]: terribly wrong... Nov 19 09:13:55 server5 mysqld[30807]: stack_bottom = 0x7fd739d57dd8 thread_stack 0x49000 Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5606afee0c7e] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(handle_fatal_signal+0x505)[0x5606afa05575] Nov 19 09:13:55 server5 mysqld[30807]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x12dd0)[0x7fd797324dd0] Nov 19 09:13:55 server5 mysqld[30807]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7fd796e4f077] Nov 19 09:13:55 server5 mysqld[30807]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x121)[0x7fd796e30535] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x4c0aec)[0x5606af742aec] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x4aa3bb)[0x5606af72c3bb] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x9677c2)[0x5606afbe97c2] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0xa41ea1)[0x5606afcc3ea1] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x9cc5de)[0x5606afc4e5de] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x9033f1)[0x5606afb853f1] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x178)[0x5606afa0a858] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5f5058)[0x5606af877058] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x18e)[0x5606af86697e] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb02)[0x5606af888be2] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x5606af888e23] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN30subselect_single_select_engine4execEv+0x145)[0x5606afa9ca75] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN14Item_subselect4execEv+0x4d)[0x5606afa9c35d] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN24Item_singlerow_subselect11val_decimalEP10my_decimal+0x36)[0x5606afa9da36] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN18Item_cache_decimal11cache_valueEv+0x37)[0x5606afa15227] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN18Item_cache_wrapper7val_strEP6String+0x7f)[0x5606afa2a40f] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZNK12Type_handler13Item_send_strEP4ItemP8ProtocolP8st_value+0x1c)[0x5606af96a99c] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xa3)[0x5606af78ba93] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0x5b)[0x5606af7f019b] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5f6be5)[0x5606af878be5] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5da446)[0x5606af85c446] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1a7)[0x5606af866997] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5da446)[0x5606af85c446] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x20f)[0x5606af8669ff] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb02)[0x5606af888be2] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x5606af888e23] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xef)[0x5606af888f6f] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x14d)[0x5606af88986d] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5a61fc)[0x5606af8281fc] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x662d)[0x5606af83524d] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x5606af7a64b5] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x90)[0x5606af7ad030] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x647)[0x5606af7adae7] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7fc)[0x5606af7a93cc] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x973)[0x5606af7aa7e3] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5a5fe9)[0x5606af827fe9] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x425a)[0x5606af832e7a] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x41e)[0x5606af84b05e] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9a)[0x5606af84b24a] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(+0x5ca24d)[0x5606af84c24d] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x25)[0x5606af84c2e5] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1a92)[0x5606af839c02] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x170)[0x5606af83ac80] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x242)[0x5606af90eeb2] Nov 19 09:13:55 server5 mysqld[30807]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5606af90f05d] Nov 19 09:13:55 server5 mysqld[30807]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8164)[0x7fd79731a164] Nov 19 09:13:55 server5 mysqld[30807]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fd796f28def] Nov 19 09:13:55 server5 mysqld[30807]: Trying to get some variables. Nov 19 09:13:55 server5 mysqld[30807]: Some pointers may be invalid and cause the dump to abort. Nov 19 09:13:55 server5 mysqld[30807]: Query (0x7fd7247d9dc0): SELECT rental.propref, deal.dealnum AS deal,rental.displayaddress as address,deal.dealid, (SELECT SUM(TERM) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' and term > 0 ) AS paidsofar,deal.TERM, (SELECT SUM(TERMdays) FROM invoices WHERE dealid = deal.dealid AND who != 'Tenant' ) AS termdays, deal.startdate AS duedate,rental.building AS building,deal.account AS invoice,deal.startdate, deal.dealnames AS tenant,deal.dealid-deal.dealid as offerid,enddate,actualend,deal.FLWONNOTREQ FROM deal INNER JOIN rental ON rental.propref = deal.propref WHERE deal.cancelled = 0 AND deal.shortlet = 0 AND deal.commrate > 0 and account >= 0 Nov 19 09:13:55 server5 mysqld[30807]: Connection ID (thread ID): 99 Nov 19 09:13:55 server5 mysqld[30807]: Status: NOT_KILLED Nov 19 09:13:55 server5 mysqld[30807]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on Nov 19 09:13:55 server5 mysqld[30807]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Nov 19 09:13:55 server5 mysqld[30807]: information that should help you find out what is causing the crash. Nov 19 09:13:55 server5 systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT Nov 19 09:13:55 server5 systemd[1]: mariadb.service: Failed with result 'core-dump'. Nov 19 09:14:01 server5 systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart. Nov 19 09:14:01 server5 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1. Nov 19 09:14:01 server5 systemd[1]: Stopped MariaDB 10.3.11 database server. Nov 19 09:14:01 server5 systemd[1]: Starting MariaDB 10.3.11 database server... Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] /usr/sbin/mysqld (mysqld 10.3.11-MariaDB-1:10.3.11+maria~cosmic-log) starting as process 31234 ... Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Using Linux native AIO Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Uses event mutexes Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Number of pools: 1 Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Using SSE2 crc32 instructions Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Completed initialization of buffer pool Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Nov 19 09:14:01 server5 mysqld[31234]: 2019-11-19 9:14:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=910163525428 Nov 19 09:14:02 server5 mysqld[31234]: 2019-11-19 9:14:02 0 [Note] InnoDB: Transaction 183505003 was in the XA prepared state. Nov 19 09:14:02 server5 mysqld[31234]: 2019-11-19 9:14:02 0 [Note] InnoDB: Transaction 183505010 was in the XA prepared state. Nov 19 09:14:02 server5 mysqld[31234]: 2019-11-19 9:14:02 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo Nov 19 09:14:02 server5 mysqld[31234]: 2019-11-19 9:14:02 0 [Note] InnoDB: Trx id counter is 183505011 Nov 19 09:14:02 server5 mysqld[31234]: 2019-11-19 9:14:02 0 [Note] InnoDB: Starting final batch to recover 1668 pages from redo log.