fmcquillan99 commented on issue #466: DL: Modify multi-fit warm start to accept non-matching mst&model tables URL: https://github.com/apache/madlib/pull/466#issuecomment-571377290 The warm start logic seems OK in limited testing so far, but during autoML runs, I cannot query the `_info` table after it has been created because it has an `AccessExclusiveLock`. I can however query the `_summary` table. Not sure why it would have this lock? I re-started the database and tried again but same thing: ``` madlib=# select t.relname,l.locktype,page,virtualtransaction,pid,mode,granted from pg_locks l, pg_stat_all_tables t where l.relation=t.relid order by relation asc; relname | locktype | page | virtualtransaction | pid | mode | granted ---------------------------------+----------+------+--------------------+-------+---------------------+--------- train_mnist_packed | relation | | 4/122 | 28078 | AccessShareLock | t train_mnist_packed | relation | | 1/164 | 28091 | AccessShareLock | t train_mnist_packed | relation | | 1/164 | 28092 | AccessShareLock | t train_mnist_packed_summary | relation | | 4/122 | 28078 | AccessShareLock | t train_mnist_packed_summary | relation | | 1/164 | 28091 | AccessShareLock | t train_mnist_packed_summary | relation | | 1/164 | 28092 | AccessShareLock | t test_mnist_packed | relation | | 1/164 | 28091 | AccessShareLock | t test_mnist_packed | relation | | 1/164 | 28092 | AccessShareLock | t test_mnist_packed | relation | | 4/122 | 28078 | AccessShareLock | t model_arch_table_mnist | relation | | 4/122 | 28078 | AccessShareLock | t model_arch_table_mnist | relation | | 1/164 | 28091 | AccessShareLock | t mst_diag_table_hb_mnist | relation | | 1/164 | 28092 | AccessShareLock | t mst_diag_table_hb_mnist | relation | | 1/164 | 28091 | AccessShareLock | t mst_diag_table_hb_mnist | relation | | 4/122 | 28078 | AccessShareLock | t mst_diag_table_hb_mnist_summary | relation | | 1/164 | 28092 | AccessShareLock | t mst_diag_table_hb_mnist_summary | relation | | 1/164 | 28091 | AccessShareLock | t mst_diag_table_hb_mnist_summary | relation | | 4/122 | 28078 | AccessShareLock | t mnist_multi_model | relation | | 4/122 | 28078 | ExclusiveLock | t mnist_multi_model | relation | | 4/122 | 28078 | RowExclusiveLock | t mnist_multi_model | relation | | 4/122 | 28078 | AccessShareLock | t mnist_multi_model | relation | | 1/164 | 28092 | RowExclusiveLock | t mnist_multi_model | relation | | 1/164 | 28091 | AccessShareLock | t mnist_multi_model | relation | | 1/164 | 28091 | RowExclusiveLock | t mnist_multi_model | relation | | 1/164 | 28092 | AccessShareLock | t mnist_multi_model_info | relation | | 1/164 | 28092 | AccessExclusiveLock | t mnist_multi_model_info | relation | | 1/164 | 28092 | AccessShareLock | t mnist_multi_model_info | relation | | 4/122 | 28078 | AccessShareLock | t mnist_multi_model_info | relation | | 1/164 | 28091 | AccessExclusiveLock | t mnist_multi_model_info | relation | | 1/164 | 28091 | AccessShareLock | t mnist_multi_model_info | relation | | 4/122 | 28078 | AccessExclusiveLock | t mnist_multi_model_summary | relation | | 4/122 | 28078 | AccessShareLock | t mnist_multi_model_summary | relation | | 1/164 | 28091 | AccessShareLock | t mnist_multi_model_summary | relation | | 1/164 | 28092 | AccessShareLock | t ``` I am not sure this is actually a problem, however, but wanted to note it here.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
