bin/bootstrap-mysql: only packages with known commit_time may enter package_blobs

1 files changed, 2 insertions, 0 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index f851ba3..c73b1e5 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -63,6 +63,8 @@ fi
   printf ' FROM `package_sources` AS `a_ps`'
   printf ' JOIN `package_sources` AS `b_ps`'
   printf ' ON UNIX_TIMESTAMP(`a_ps`.`commit_time`) - UNIX_TIMESTAMP(`b_ps`.`commit_time`) BETWEEN -10 AND 10'
+  printf ' AND `a_ps`.`commit_time`!="0000-00-00 00:00:00"'
+  printf ' AND `b_ps`.`commit_time`!="0000-00-00 00:00:00"'
   mysql_join_package_sources_build_assignments 'a_ps' 'a_ba'
   mysql_join_package_sources_build_assignments 'b_ps' 'b_ba'
   mysql_join_build_assignments_binary_packages 'a_ba' 'a_bp'