foodszhang / openarkkit

Automatically exported from code.google.com/p/openarkkit
0 stars 0 forks source link

Attempting to lock tables doesn't complete #31

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
When running the following, it never locks the tables. There isn't any activity 
in show full processlist from the oak process nor is there activity on the 
messages table. I've tried with the latest release version and the version 
attached to issue #30

oak-online-alter-table --database=captainu --table=messages --alter="ADD 
KEY(from_email, from_id, from_type)" --user=root --ask-pass 
--socket=/var/lib/mysql/mysql.sock --chunk-size=5000 --sleep=1000
-- Connecting to MySQL
Password: 
-- Table captainu.messages is of engine innodb
-- Checking for UNIQUE columns on captainu.messages, by which to chunk
-- Possible UNIQUE KEY column names in captainu.messages:
-- - id
-- Table captainu.__oak_messages has been created
-- Table captainu.__oak_messages has been altered
-- Checking for UNIQUE columns on captainu.__oak_messages, by which to chunk
-- Possible UNIQUE KEY column names in captainu.__oak_messages:
-- - id
-- Checking for UNIQUE columns on captainu.messages, by which to chunk
-- - Found following possible unique keys:
-- - id (int)
-- Chosen unique key is 'id'
-- Shared columns: body, created_at, to_email, reply_to_id, updated_at, 
login_token, subject, archived, from_type, from_email, to_id, to_type, token, 
flags, most_likely_college_team_id, athlete_id, id, bounced, message_id, from_id
-- Created AD trigger
-- Created AU trigger
-- Created AI trigger
-- Attempting to lock tables
-- ...
-- ...
-- ...
-- ...
-- ...

Original issue reported on code.google.com by michael....@gmail.com on 29 Jan 2013 at 5:38

GoogleCodeExporter commented 8 years ago
Sorry for responding late. Is this consistent?

Original comment by shlomi.n...@gmail.com on 6 May 2013 at 7:30

GoogleCodeExporter commented 8 years ago
At the time it was happening consistently. I've since used another method to 
update that table.

Original comment by michael....@gmail.com on 6 May 2013 at 4:57

GoogleCodeExporter commented 8 years ago
Thank you. I was not able to reproduce. Cheers

Original comment by shlomi.n...@gmail.com on 7 May 2013 at 5:51