Skip to content

Instantly share code, notes, and snippets.

@d3flex
Created November 24, 2025 12:57
Show Gist options
  • Select an option

  • Save d3flex/99b4a4721bec6ecf94e9a0957a92bd29 to your computer and use it in GitHub Desktop.

Select an option

Save d3flex/99b4a4721bec6ecf94e9a0957a92bd29 to your computer and use it in GitHub Desktop.

notes on 190977

[debug] [pid:563972] [DBIC] Took 0.00025800 seconds: SELECT me.id, me.result_dir, me.archived, me.state, me.priority, me.result, me.reason, me.clone_id, me.blocked_by_id, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.externally_skipped_module_count, me.scheduled_product_id, me.result_size, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): ‘5476097’

[debug] [pid:563972] [DBIC] Took 0.00607600 seconds: SELECT me.id, me.result_dir, me.archived, me.state, me.priority, me.result, me.reason, me.clone_id, me.blocked_by_id, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.externally_skipped_module_count, me.scheduled_product_id, me.result_size, me.t_created, me.t_updated FROM ( WITH allofjobs AS( SELECT me.* FROM jobs me WHERE me.state=? AND me.result NOT IN (?, ?, ?, ?, ?, ?) AND me.DISTRI=? AND me.VERSION=? AND me.FLAVOR=? AND me.ARCH=? AND me.TEST=? AND me.MACHINE=? ) (SELECT * FROM jobs WHERE DISTRI=? AND VERSION=? AND FLAVOR=? AND ARCH=? AND TEST=? AND MACHINE=? ORDER BY ID DESC LIMIT 1) UNION (SELECT * FROM allofjobs WHERE id > ? ORDER BY ID ASC LIMIT ?) UNION (SELECT * FROM allofjobs WHERE id < ? ORDER BY ID DESC LIMIT ?) UNION (SELECT * FROM jobs WHERE id = ?) ORDER BY ID DESC) me: ‘done’, ‘skipped’, ‘obsoleted’, ‘parallel_failed’, ‘parallel_restarted’, ‘user_cancelled’, ‘user_restarted’, ‘openqa’, ‘Tumbleweed’, ‘dev’, ‘x86_64’, ‘openqa_install+publish’, ‘uefi-4G’, ‘openqa’, ‘Tumbleweed’, ‘dev’, ‘x86_64’, ‘openqa_install+publish’, ‘uefi-4G’, ‘5476097’, ‘500’, ‘5476097’, ‘500’, ‘5476097’ [debug] [pid:563972] [DBIC] Took 0.02838100 seconds: SELECT me.name, me.job_id FROM job_modules me WHERE ( ( job_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND result = ? ) ) ORDER BY t_updated: ‘5476097’, ‘5475977’, ‘5475965’, ‘5475962’, ‘5475697’, ‘5475688’, ‘5475638’, ‘5475632’, ‘5475599’, ‘5475585’, ‘5475577’, ‘5475544’, ‘5475529’, ‘5475521’, ‘5475508’, ‘5475483’, ‘5475436’, ‘5474964’, ‘5474956’, ‘5474945’, ‘5474927’, ‘5474919’, ‘5474911’, ‘5474897’, ‘5474680’, ‘5474643’, ‘5474635’, ‘5474624’, ‘5474612’, ‘5474595’, ‘5474584’, ‘5474570’, ‘5474567’, ‘5474481’, ‘5474453’, ‘5474427’, ‘5473808’, ‘5473756’, ‘5473737’, ‘5473700’, ‘5473289’, ‘5473252’, ‘5473085’, ‘5472953’, ‘5472554’, ‘5472514’, ‘5472373’, ‘5472285’, ‘5472134’, ‘5471376’, ‘5471338’, ‘5471328’, ‘5471305’, ‘5471244’, ‘5471200’, ‘5471192’, ‘5471147’, ‘5471083’, ‘5471044’, ‘5471012’, ‘5471004’, ‘5470996’, ‘5470984’, ‘5470970’, ‘5470951’, ‘5470715’, ‘5470542’, ‘5470187’, ‘5470074’, ‘5469833’, ‘5469251’, ‘5469132’, ‘5468984’, ‘5468953’, ‘5468832’, ‘5468824’, ‘5468785’, ‘5468716’, ‘5468672’, ‘5468626’, ‘5468609’, ‘5468548’, ‘5468317’, ‘5467660’, ‘5467652’, ‘5467612’, ‘5467588’, ‘5467545’, ‘5467499’, ‘5467407’, ‘5467324’, ‘5467098’, ‘5466854’, ‘5466680’, ‘5465525’, ‘5465462’, ‘5465402’, ‘5465336’, ‘5465192’, ‘5465102’, ‘5465040’, ‘5464983’, ‘5464946’, ‘5464879’, ‘5464826’, ‘5464820’, ‘5464817’, ‘5464808’, ‘5464773’, ‘5464733’, ‘5464700’, ‘5464626’, ‘5464570’, ‘5464481’, ‘5464403’, ‘5464325’, ‘5464271’, ‘5464204’, ‘5464051’, ‘5463780’, ‘5463712’, ‘5463424’, ‘5463273’, ‘5463265’, ‘5463256’, ‘5463246’, ‘5463238’, ‘5463157’, ‘5463136’, ‘5463121’, ‘5463043’, ‘5462953’, ‘5462115’, ‘5461958’, ‘5461469’, ‘5461454’, ‘5461365’, ‘5460834’, ‘5460826’, ‘5460776’, ‘5460713’, ‘5460701’, ‘5460691’, ‘5460680’, ‘5460650’, ‘5460497’, ‘5460484’, ‘5460467’, ‘5460454’, ‘5460409’, ‘5460401’, ‘5460393’, ‘5460385’, ‘5460374’, ‘5460366’, ‘5460358’, ‘5460350’, ‘5460314’, ‘5460306’, ‘5460294’, ‘5460286’, ‘5460259’, ‘5460174’, ‘5460166’, ‘5460140’, ‘5460107’, ‘5460099’, ‘5460091’, ‘5460082’, ‘5459996’, ‘5459964’, ‘5459925’, ‘5459916’, ‘5459865’, ‘5459857’, ‘5459841’, ‘5459805’, ‘5459792’, ‘5459766’, ‘5459680’, ‘5459512’, ‘5459359’, ‘5458232’, ‘5458219’, ‘5458202’, ‘5458020’, ‘5457984’, ‘5457970’, ‘5457938’, ‘5457928’, ‘5457920’, ‘5457912’, ‘5457904’, ‘5457895’, ‘5457848’, ‘5457773’, ‘5457765’, ‘5457755’, ‘5457731’, ‘5457631’, ‘5457620’, ‘5457611’, ‘5457597’, ‘5457535’, ‘5457515’, ‘5457435’, ‘5457377’, ‘5457293’, ‘5455132’, ‘5455081’, ‘5454593’, ‘5454523’, ‘5454445’, ‘5454396’, ‘5454232’, ‘5454088’, ‘5453994’, ‘5453587’, ‘5452798’, ‘5452508’, ‘5452345’, ‘5452320’, ‘5452242’, ‘5452138’, ‘5452113’, ‘5452056’, ‘5452037’, ‘5452025’, ‘5451980’, ‘5451917’, ‘5451885’, ‘5451867’, ‘5451733’, ‘5451559’, ‘5451235’, ‘5451114’, ‘5450916’, ‘5450639’, ‘5450297’, ‘5449712’, ‘5449484’, ‘5449431’, ‘5449356’, ‘5449304’, ‘5449164’, ‘5449130’, ‘5449085’, ‘5448904’, ‘5448218’, ‘5448188’, ‘5448128’, ‘5448045’, ‘5448013’, ‘5447993’, ‘5447520’, ‘5447413’, ‘5447350’, ‘5447238’, ‘5447132’, ‘5445577’, ‘5444434’, ‘5444411’, ‘5444310’, ‘5444162’, ‘5444127’, ‘5444110’, ‘5444044’, ‘5443986’, ‘5443914’, ‘5443895’, ‘5443840’, ‘5443821’, ‘5443737’, ‘5443687’, ‘5443650’, ‘5443588’, ‘5443379’, ‘5442505’, ‘5442239’, ‘5441622’, ‘5441613’, ‘5441604’, ‘5441589’, ‘5441551’, ‘5441502’, ‘5441456’, ‘5441423’, ‘5441378’, ‘5441370’, ‘5441358’, ‘5441343’, ‘5441331’, ‘5441279’, ‘5441214’, ‘5441205’, ‘5441196’, ‘5441150’, ‘5441138’, ‘5441076’, ‘5440123’, ‘5440062’, ‘5439984’, ‘5439035’, ‘5438670’, ‘5437283’, ‘5435718’, ‘5432266’, ‘5431353’, ‘5431276’, ‘5431079’, ‘5430536’, ‘5430502’, ‘5430486’, ‘5430390’, ‘5430366’, ‘5430197’, ‘5430189’, ‘5430141’, ‘5430101’, ‘5430093’, ‘5430080’, ‘5430018’, ‘5429979’, ‘5429921’, ‘5429832’, ‘5429778’, ‘5429753’, ‘5429654’, ‘5429621’, ‘5429586’, ‘5429472’, ‘5429436’, ‘5429262’, ‘5429090’, ‘5429055’, ‘5428988’, ‘5428357’, ‘5428345’, ‘5428282’, ‘5428239’, ‘5428226’, ‘5428189’, ‘5426266’, ‘5424856’, ‘5424258’, ‘5420263’, ‘5418717’, ‘5416239’, ‘5415778’, ‘5411510’, ‘5410794’, ‘5410729’, ‘5410658’, ‘5410602’, ‘5410456’, ‘5410185’, ‘5409226’, ‘5408629’, ‘5408443’, ‘5408033’, ‘5407919’, ‘5407361’, ‘5407257’, ‘5407109’, ‘5407055’, ‘5406203’, ‘5405659’, ‘5405507’, ‘5405449’, ‘5405439’, ‘5405422’, ‘5405414’, ‘5405401’, ‘5405322’, ‘5405283’, ‘5405257’, ‘5405241’, ‘5404996’, ‘5404368’, ‘5404341’, ‘5404318’, ‘5404169’, ‘5404143’, ‘5403963’, ‘5403878’, ‘5403779’, ‘5403751’, ‘5403741’, ‘5403685’, ‘5403339’, ‘5403144’, ‘5402672’, ‘5402635’, ‘5402606’, ‘5402592’, ‘5402580’, ‘5402554’, ‘5402465’, ‘5402390’, ‘5401233’, ‘5401160’, ‘5401059’, ‘5401001’, ‘5400936’, ‘5400926’, ‘5400910’, ‘5400879’, ‘5400867’, ‘5400804’, ‘5400794’, ‘5400783’, ‘5400738’, ‘5400678’, ‘5400546’, ‘5400059’, ‘5400008’, ‘5399926’, ‘5399917’, ‘5399855’, ‘5398810’, ‘5398673’, ‘5398104’, ‘5397752’, ‘5397663’, ‘5397411’, ‘5396855’, ‘5396618’, ‘5396586’, ‘5396550’, ‘5396537’, ‘5396528’, ‘5396513’, ‘5396467’, ‘5396371’, ‘5396365’, ‘5396362’, ‘5396354’, ‘5396346’, ‘5396324’, ‘5396250’, ‘5396247’, ‘5396212’, ‘5396205’, ‘5396181’, ‘5396167’, ‘5396150’, ‘5396044’, ‘5395950’, ‘5395847’, ‘5395761’, ‘5395645’, ‘5394610’, ‘5394593’, ‘5394583’, ‘5394570’, ‘5394553’, ‘5394475’, ‘5394365’, ‘5394324’, ‘5394229’, ‘5393967’, ‘5393961’, ‘5393958’, ‘5393924’, ‘5393863’, ‘5393846’, ‘5393835’, ‘5393798’, ‘5393784’, ‘5393772’, ‘5393745’, ‘5393718’, ‘5393667’, ‘5393438’, ‘5392909’, ‘5392893’, ‘5392723’, ‘5392715’, ‘5392677’, ‘5392587’, ‘5392572’, ‘5392516’, ‘5392504’, ‘5392487’, ‘5392439’, ‘5392323’, ‘5392305’, ‘5392273’, ‘5391669’, ‘5391606’, ‘5391563’, ‘5391525’, ‘5391499’, ‘5391474’, ‘5391446’, ‘5391384’, ‘5391363’, ‘5391232’, ‘5391180’, ‘5391089’, ‘5390976’, ‘failed’

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment