Subscribed unsubscribe Subscribe Subscribe

ふり返る暇なんて無いね

日々のメモ書きをつらつらと

2013-01-21日誌

レプリケーションエラーの件

percona 5.5のレプリケーションがいまいち、調子悪いので。

Slave I/O: The slave I/O thread stops because SET @master_heartbeat_period on master failed. Error: , Error_code: 1593

はこの件と同じっぽい。回答が無い。

Error: 1593 SQLSTATE: HY000 (ER_SLAVE_FATAL_ERROR)
Message: Fatal error: %s

http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_slave_fatal_error
Slave I/O: The slave I/O thread stops because a fatal error is encountered when it try to get the value of SERVER_ID variable from master. Error: , Error_code: 1159

はこの件と同じっぽい。

Error: 1159 SQLSTATE: 08S01 (ER_NET_READ_INTERRUPTED)
Message: Got timeout reading communication packets

http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_net_read_interrupted

SoftwareDesign シェルの記事のメモ

$? ステータスコード

正常終了が0、1-255がエラー

zshの場合$pipstatusにパイプした各コマンドのステータスコードが格納される

% echo 'foo bar' > hoge
% grep foo hoge | grep -v hoge | grep aaa
% echo $pipestatus
0 0 1

plenv

とりあえず、インストールだけ。

https://github.com/tokuhirom/plenv

git clone git://github.com/tokuhirom/plenv.git ~/.plenv/
echo 'PATH=~/.plenv/bin/:~/.plenv/shims/:$PATH' >> ~/.zshrc
PATH=~/.plenv/bin/:~/.plenv/shims/:$PATH
GREP_OPTIONS= plenv install 5.16.2
% perl -v

This is perl, v5.10.0 built for i486-linux-gnu-thread-multi

Copyright 1987-2007, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

% plenv local 5.16.2
% perl -v

This is perl 5, version 16, subversion 2 (v5.16.2) built for i686-linux

Copyright 1987-2012, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

% plenv local system
% perl -v

This is perl, v5.10.0 built for i486-linux-gnu-thread-multi

Copyright 1987-2007, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.