#archlinux32 | Logs for 2023-09-23
Back
[04:49:54] -!- titus_livius has joined #archlinux32
[04:50:15] -!- titus_livius has joined #archlinux32
[04:50:36] -!- titus_livius has joined #archlinux32
[10:25:39] -!- abaumann has joined #archlinux32
[10:25:39] <buildmaster> Hi abaumann!
[10:25:39] <buildmaster> !rq abaumann
[10:25:40] <phrik> buildmaster: <abaumann> backups is for loosers ;-)
[10:25:52] <abaumann> At least I get now an idea where get-package-updates is failing:
[10:25:53] <abaumann> I (buildmaster.archlinux32.org) could not complete a mysql query:
[10:25:54] <abaumann> mysql< -- called by ./get-package-updates
[10:25:54] <abaumann> mysql< INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`,`last_moved`,`is_to_be_deleted`) SELECT `binary_packages`.`id`,`d_r`.`id`,NOW(),1 FROM `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("YW55") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR
[10:26:00] <abaumann> `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND `package_sources`.`pkgbase`=from_base64("Z29sYW5nLWdpdGh1Yi1nb29nbGUtZ28tY21kdGVzdA==") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN
[10:26:06] <abaumann> `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id` AND `upstream_repositories`.`name` LIKE from_base64("ZXh0cmE=") JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND `repositories`.`stability` in (5,7) JOIN `architectures` AS `ba_a` ON `build_assignments`.`architecture`=`ba_a`.`id` JOIN `repositories` AS
[10:26:12] <abaumann> `d_r` ON (`d_r`.`architecture`=`ba_a`.`id` OR `ba_a`.`name`="any") AND `d_r`.`stability`=6;
[10:26:15] <abaumann> mysql< COMMIT;
[10:26:17] <abaumann> mysql< DELETE `binary_packages_in_repositories` FROM `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("YW55") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND
[10:26:23] <abaumann> `package_sources`.`pkgbase`=from_base64("Z29sYW5nLWdpdGh1Yi1nb29nbGUtZ28tY21kdGVzdA==") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id` AND
[10:26:29] <abaumann> `upstream_repositories`.`name` LIKE from_base64("ZXh0cmE=") JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND `repositories`.`stability` in (5,7);
[10:26:33] <abaumann> mysql< COMMIT;
[10:26:36] <abaumann> mysql< UPDATE `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("YW55") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND
[10:26:41] <abaumann> `package_sources`.`pkgbase`=from_base64("Z29sYW5nLWdpdGh1Yi1nb29nbGUtZ28tY21kdGVzdA==") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id` AND
[10:26:47] <abaumann> `upstream_repositories`.`name` LIKE from_base64("ZXh0cmE=") SET `binary_packages_in_repositories`.`is_to_be_deleted`=1;
[10:26:50] <abaumann> mysql>2 ERROR 1213 (40001) at line 4: Deadlock found when trying to get lock; try restarting transaction
[10:26:53] <abaumann> mysql>2 ERROR 1205 (HY000) at line 4: Lock wait timeout exceeded; try restarting transaction
[10:26:56] <abaumann> Lemme try to increase some timeouts..
[10:35:13] <abaumann> mmh. this seems to be rather a programming/deadlock issue.
[10:35:48] <abaumann> cleaned the buildmaster, but I dought anything useful happens ATM..
[10:35:50] -!- abaumann has quit [Quit: leaving]
[11:30:55] -!- zxrom has quit [Ping timeout: 264 seconds]
[12:16:26] -!- zxrom has joined #archlinux32
[17:13:37] -!- GNUtoo has quit [Ping timeout: 252 seconds]
[17:20:38] -!- GNUtoo has joined #archlinux32
[22:31:19] -!- abouvier has quit [Quit: kthxbye]
[22:31:50] -!- abouvier has joined #archlinux32
[22:57:07] -!- kiska3 has quit [Quit: The Lounge - https://thelounge.chat]
[23:00:48] -!- kiska3 has joined #archlinux32