Comments on: New and Noteworthy in openark kit https://shlomi-noach.github.io/blog/mysql/new-and-noteworthy-in-openark-kit Blog by Shlomi Noach Fri, 05 May 2017 14:10:00 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Stephen Efange https://shlomi-noach.github.io/blog/mysql/new-and-noteworthy-in-openark-kit/comment-page-1#comment-389636 Fri, 05 May 2017 14:10:00 +0000 https://shlomi-noach.github.io/blog/?p=853#comment-389636 [root@tpareldb opt]# oak-chunk-update -u root –ask-pass –socket=/var/lib/mysql/mysql.sock –database=clarity_production –execute=”update inquiry_tradelines it set it.tracking_id = (
> select st.tracking_id
> from supplier_tradelines st
> where st.id=it.supplier_tradeline_id
> ) where it.tracking_id is null AND OAK_CHUNK(clarity_production.inquiry_tradelines)” –chunk-size=5 –sleep=20000 –verbose
Password:

— ERROR: Failed chunk: (1054, “Unknown column ‘inquiry_tradelines.id’ in ‘where clause'”)

]]> By: Stephen Efange https://shlomi-noach.github.io/blog/mysql/new-and-noteworthy-in-openark-kit/comment-page-1#comment-389635 Fri, 05 May 2017 14:03:00 +0000 https://shlomi-noach.github.io/blog/?p=853#comment-389635 hello I am trying to run this update using Openark kit but I get an erorr:

update inquiry_tradelines it set it.tracking_id = (select st.tracking_id from supplier_tradelines st where st.id=it.supplier_tradeline_id) where it.tracking_id is null;

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/new-and-noteworthy-in-openark-kit/comment-page-1#comment-2899 Wed, 29 Jul 2009 12:29:34 +0000 https://shlomi-noach.github.io/blog/?p=853#comment-2899 Hi Lyz,

Take a look at the wiki page: OakOnlineAlterTableConcurrency to see why LOCK IN SHARED MODE is required.

Regards,
Shlomi

]]> By: lyz https://shlomi-noach.github.io/blog/mysql/new-and-noteworthy-in-openark-kit/comment-page-1#comment-2896 Wed, 29 Jul 2009 09:22:05 +0000 https://shlomi-noach.github.io/blog/?p=853#comment-2896 very good job!
i saw the source code, i’m not sure that ” if table_engine == “innodb” engine_flags = “LOCK IN SHARE MODE”” is useful,maybe,wo can play no locks,as the triger makes the gost table has most currend version, am i right?
looking forward your replay

]]>