Re: InnoDB(=MySQL)エラー再び (A) KH Coder 旧掲示板
[ツリー表示] [留意事項] [ワード検索] [過去ログ]

  [No.3859] Re: InnoDB(=MySQL)エラー再び 投稿者:A  投稿日:2018/11/01(Thu) 19:56:34

樋口先生、こんばんは。
お返事が遅くなり、失礼いたしました。

再インストールを2度試してみました。
しかし、残念ながら、解決していません。

現在、KH-Coderは問題なく起動します。しかし、プロジェクトを作成できません。
参照先を指定して、プロジェクトを作成しようと「OK」ボタンを押下すると、
ボタンが押されたままの状態でフリーズし、数分して落ちます。

再インストールは、下記の手順で行いました。

(事前の準備:古いkhcoderを一度起動させ、何もせずに終了する)
1. 「ダウンロード」フォルダの「khcoder3」を削除、ゴミ箱を空にする。
2. 画面左上隅のリンゴマークからMacを再起動
3. セキュリティ系ソフト(eset)を一時的に無効にする
4. Macのファイアウォールをオフにする
5. 同期ソフトを全て終了させて同期をオフにする
6. KH Coderの自動設定ソフトウェアをダウンロード・解凍する
7. dep/mysql-5.6.17/khc.cnfをテキストエディタで開き,末尾に以下の3行
 を追加して上書き保存

default-storage-engine=MyISAM
default-tmp-storage-engine=MyISAM
skip-innodb

8. 「setup」「kh_coder」を順にクリックしてKH Coderの起動を確認
9. ターミナルにInnoDBエラーが出ていないことを確認
10. チュートリアルの「kokoro」を参照して、新規プロジェクト→OKボタン

ステップ10まで問題なく進みます。
その後、フリーズして落ちます。

気になる点としては、問題なく作動する他のMacで試した時と比べて起動が遅く、
「Checking MySQL connection...」が表示されたところで何分も止まってしまうことです。
この現象は繰り返し生じます。


以下に、コンソールの出力を貼付いたします。
あまり役立つ情報がなく申し訳ないです…。

Last login: Thu Nov 1 19:29:51 on ttys000
bash -c " cd "/Users/A/Downloads/khcoder3/";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Users/A/Downloads/khcoder3/deps/mysql-5.6.17/lib";./x_mac64"
AnoMacBook:~ A$ bash -c " cd "/Users/A/Downloads/khcoder3/";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Users/A/Downloads/khcoder3/deps/mysql-5.6.17/lib";./x_mac64"
Perl/Tk: 804.032
Resetting parameters...
Locale: ja_JP.UTF-8
This is KH Coder 3.Alpha.13g on darwin.
CWD: /Users/A/Downloads/khcoder3
Executing Mac OS X 64-bit Package
Checking MySQL connection...
Starting MySQL...
uim <-> XIM bridge. Supporting multiple locales.
Using full-synchronous XIM event flow
2018-11-01 19:31:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-01 19:31:15 722 [Warning] Setting lower_case_table_names=2 because file system for /Users/A/Downloads/khcoder3/deps/mysql-5.6.17/data/ is case insensitive
2018-11-01 19:31:15 722 [Note] Plugin 'FEDERATED' is disabled.
2018-11-01 19:31:15 722 [Note] Plugin 'InnoDB' is disabled.
2018-11-01 19:31:15 722 [Note] Server hostname (bind-address): '*'; port: 3309
2018-11-01 19:31:15 722 [Note] IPv6 is available.
2018-11-01 19:31:15 722 [Note] - '::' resolves to '::';
2018-11-01 19:31:15 722 [Note] Server socket created on IP: '::'.
2018-11-01 19:31:15 722 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2018-11-01 19:31:15 722 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2018-11-01 19:31:15 722 [Note] Event Scheduler: Loaded 0 events
2018-11-01 19:31:15 722 [Note] deps/MySQL-5.6.17/bin/mysqld: ready for connections.
Version: '5.6.17' socket: '/tmp/mysql.sock.khc3' port: 3309 MySQL Community Server (GPL)
Supported conversion engines:
direct (*)
yahoo-jp (ja)
baidu-olime-jp (ja)
google-cgiapi-jp (ja)
social-ime (ja)
ajax-ime (ja)
look ()
ipa-x-sampa ()
viqr (vi)
pinyin-big5 (zh_TW:zh_HK)
pyunihan (zh)
py (zh_CN)
wb86 (zh_CN:zh_TW:zh_HK)
zm (zh_CN:zh_TW:zh_HK)
m17n-am-sera (am)
m17n-ar-kbd (ar)
m17n-as-inscript (as)
m17n-as-itrans (as)
m17n-as-phonetic (as)
m17n-ath-phonetic (ath)
m17n-be-kbd (be)
m17n-bla-phonetic (bla)
m17n-bn-inscript (bn)
m17n-bn-itrans (bn)
m17n-bn-probhat (bn)
m17n-bn-unijoy (bn)
m17n-bo-ewts (bo)
m17n-bo-tcrc (bo)
m17n-bo-wylie (bo)
m17n-latn-post (*)
m17n-latn-pre (*)
m17n-rfc1345 (*)
m17n-syrc-phonetic (*)
m17n-unicode (*)
m17n-cmc-kbd (cmc)
m17n-cr-western (cr)
m17n-cs-kbd (cs)
m17n-da-post (da)
m17n-dv-phonetic (dv)
m17n-el-kbd (el)
m17n-eo-h-fundamente (eo)
m17n-eo-h-sistemo (eo)
m17n-eo-plena (eo)
m17n-eo-q-sistemo (eo)
m17n-eo-vi-sistemo (eo)
m17n-eo-x-sistemo (eo)
m17n-fa-isiri (fa)
m17n-fr-azerty (fr)
m17n-grc-mizuochi (grc)
m17n-gu-inscript (gu)
m17n-gu-itrans (gu)
m17n-gu-phonetic (gu)
m17n-he-kbd (he)
m17n-hi-inscript (hi)
m17n-hi-itrans (hi)
m17n-hi-phonetic (hi)
m17n-hi-remington (hi)
m17n-hi-typewriter (hi)
m17n-hi-vedmata (hi)
m17n-hr-kbd (hr)
m17n-hy-kbd (hy)
m17n-ii-phonetic (ii)
m17n-en-ispell (en)
m17n-iu-phonetic (iu)
m17n-ja-anthy (ja)
m17n-ja-tcode (ja)
m17n-ja-trycode (ja)
m17n-ka-kbd (ka)
m17n-kk-arabic (kk)
m17n-kk-kbd (kk)
m17n-km-yannis (km)
m17n-kn-inscript (kn)
m17n-kn-itrans (kn)
m17n-kn-kgp (kn)
m17n-ko-han2 (ko)
m17n-ko-romaja (ko)
m17n-ks-inscript (ks)
m17n-ks-kbd (ks)
m17n-lo-kbd (lo)
m17n-lo-lrt (lo)
m17n-ml-inscript (ml)
m17n-ml-itrans (ml)
m17n-ml-mozhi (ml)
m17n-ml-swanalekha (ml)
m17n-mr-inscript (mr)
m17n-mr-itrans (mr)
m17n-mr-phonetic (mr)
m17n-my-kbd (my)
m17n-ne-rom (ne)
m17n-ne-trad (ne)
m17n-nsk-phonetic (nsk)
m17n-oj-phonetic (oj)
m17n-or-inscript (or)
m17n-or-itrans (or)
m17n-or-phonetic (or)
m17n-pa-inscript (pa)
m17n-pa-itrans (pa)
m17n-pa-jhelum (pa)
m17n-pa-phonetic (pa)
m17n-ps-phonetic (ps)
m17n-ru-kbd (ru)
m17n-ru-phonetic (ru)
m17n-ru-translit (ru)
m17n-ru-yawerty (ru)
m17n-sa-harvard-kyoto (sa)
m17n-sa-IAST (sa)
m17n-sd-inscript (sd)
m17n-si-phonetic-dynamic (si)
m17n-si-samanala (si)
m17n-si-singlish (si)
m17n-si-sumihiri (si)
m17n-si-transliteration (si)
m17n-si-wijesekera (si)
m17n-sk-kbd (sk)
m17n-sr-kbd (sr)
m17n-sv-post (sv)
m17n-ta-inscript (ta)
m17n-ta-itrans (ta)
m17n-ta-lk-renganathan (ta)
m17n-ta-phonetic (ta)
m17n-ta-tamil99 (ta)
m17n-ta-typewriter (ta)
m17n-ta-vutam (ta)
m17n-tai-sonla-kbd (tai)
m17n-te-apple (te)
m17n-te-inscript (te)
m17n-te-itrans (te)
m17n-te-pothana (te)
m17n-te-rts (te)
m17n-th-kesmanee (th)
m17n-th-pattachote (th)
m17n-th-tis820 (th)
m17n-ua-kbd (ua)
m17n-ug-kbd (ug)
m17n-ur-phonetic (ur)
m17n-uz-kbd (uz)
m17n-vi-han (vi)
m17n-vi-nomvni (vi)
m17n-vi-nomtelex (vi)
m17n-vi-tcvn (vi)
m17n-vi-telex (vi)
m17n-vi-viqr (vi)
m17n-vi-vni (vi)
m17n-yi-yivo (yi)
m17n-zh-bopomofo (zh)
m17n-zh-cangjie (zh)
m17n-zh-pinyin-vi (zh)
m17n-zh-pinyin (zh)
m17n-zh-py-b5 (zh)
m17n-zh-py-gb (zh)
m17n-zh-py (zh)
m17n-zh-quick (zh)
m17n-zh-tonepy-b5 (zh)
m17n-zh-tonepy-gb (zh)
m17n-zh-tonepy (zh)
elatin ()
latin ()
byeoru (ko)
tutcode (ja)
skk (ja)
prime (ja)
anthy-utf8 (ja)
anthy (ja)
mozc (ja)
XMODIFIERS=@im=uim registered, selecting anthy (ja) as default conversion engine
R Version: 3.1, x86_64
Using un-threaded functions...
creating project list... ok
Conv:
1 wallclock secs ( 0.10 usr + 0.01 sys = 0.11 CPU)
x_mac64(711,0x7fffad602380) malloc: *** error for object 0x7ffeefbfdf50: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
bash: line 1: 711 Abort trap: 6 ./x_mac64


AnoMacBook:~ A$ /private/tmp/com.apple.launchd.7QRrdMiekc/org.macosforge.xquartz:0: X IO error.
uim-candwin-gtk: Fatal IO error 35 (Resource temporarily unavailable) on X server /private/tmp/com.apple.launchd.7QRrdMiekc/org.macosforge.xquartz:0.
=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Users/A/Downloads/khcoder3/deps/mysql-5.6.17/lib";./x_mac64 "
Perl/Tk: 804.032
Locale: ja_JP.UTF-8
This is KH Coder 3.Alpha.13g on darwin.
CWD: /Users/A/Downloads/khcoder3
Executing Mac OS X 64-bit Package
Checking MySQL connection...
Starting MySQL...
uim <-> XIM bridge. Supporting multiple locales.
Using full-synchronous XIM event flow
2018-11-01 19:35:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-01 19:35:57 925 [Warning] Setting lower_case_table_names=2 because file system for /Users/A/Downloads/khcoder3/deps/mysql-5.6.17/data/ is case insensitive
2018-11-01 19:35:57 925 [Note] Plugin 'FEDERATED' is disabled.
2018-11-01 19:35:57 925 [Note] Plugin 'InnoDB' is disabled.
2018-11-01 19:35:57 925 [Note] Server hostname (bind-address): '*'; port: 3309
2018-11-01 19:35:57 925 [Note] IPv6 is available.
2018-11-01 19:35:57 925 [Note] - '::' resolves to '::';
2018-11-01 19:35:57 925 [Note] Server socket created on IP: '::'.
2018-11-01 19:35:57 925 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2018-11-01 19:35:57 925 [ERROR] Do you already have another mysqld server running on port: 3309 ?
2018-11-01 19:35:57 925 [ERROR] Aborting

2018-11-01 19:35:57 925 [Note] Binlog end
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'partition'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_METRICS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_CMP'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'INNODB_TRX'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'BLACKHOLE'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'ARCHIVE'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'MRG_MYISAM'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'MyISAM'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'MEMORY'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'CSV'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'sha256_password'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'mysql_old_password'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'mysql_native_password'
2018-11-01 19:35:57 925 [Note] Shutting down plugin 'binlog'
2018-11-01 19:35:57 925 [Note] deps/MySQL-5.6.17/bin/mysqld: Shutdown complete

sh: line 1: 898 Killed: 9 /Users/A/Downloads/khcoder3/deps/R-3.1.0/Resources/bin/R --slave --vanilla < start.r > output.log
Supported conversion engines:
direct (*)
yahoo-jp (ja)
baidu-olime-jp (ja)
google-cgiapi-jp (ja)
social-ime (ja)
ajax-ime (ja)
look ()
ipa-x-sampa ()
viqr (vi)
pinyin-big5 (zh_TW:zh_HK)
pyunihan (zh)
py (zh_CN)
wb86 (zh_CN:zh_TW:zh_HK)
zm (zh_CN:zh_TW:zh_HK)
m17n-am-sera (am)
m17n-ar-kbd (ar)
m17n-as-inscript (as)
m17n-as-itrans (as)
m17n-as-phonetic (as)
m17n-ath-phonetic (ath)
m17n-be-kbd (be)
m17n-bla-phonetic (bla)
m17n-bn-inscript (bn)
m17n-bn-itrans (bn)
m17n-bn-probhat (bn)
m17n-bn-unijoy (bn)
m17n-bo-ewts (bo)
m17n-bo-tcrc (bo)
m17n-bo-wylie (bo)
m17n-latn-post (*)
m17n-latn-pre (*)
m17n-rfc1345 (*)
m17n-syrc-phonetic (*)
m17n-unicode (*)
m17n-cmc-kbd (cmc)
m17n-cr-western (cr)
m17n-cs-kbd (cs)
m17n-da-post (da)
m17n-dv-phonetic (dv)
m17n-el-kbd (el)
m17n-eo-h-fundamente (eo)
m17n-eo-h-sistemo (eo)
m17n-eo-plena (eo)
m17n-eo-q-sistemo (eo)
m17n-eo-vi-sistemo (eo)
m17n-eo-x-sistemo (eo)
m17n-fa-isiri (fa)
m17n-fr-azerty (fr)
m17n-grc-mizuochi (grc)
m17n-gu-inscript (gu)
m17n-gu-itrans (gu)
m17n-gu-phonetic (gu)
m17n-he-kbd (he)
m17n-hi-inscript (hi)
m17n-hi-itrans (hi)
m17n-hi-phonetic (hi)
m17n-hi-remington (hi)
m17n-hi-typewriter (hi)
m17n-hi-vedmata (hi)
m17n-hr-kbd (hr)
m17n-hy-kbd (hy)
m17n-ii-phonetic (ii)
m17n-en-ispell (en)
m17n-iu-phonetic (iu)
m17n-ja-anthy (ja)
m17n-ja-tcode (ja)
m17n-ja-trycode (ja)
m17n-ka-kbd (ka)
m17n-kk-arabic (kk)
m17n-kk-kbd (kk)
m17n-km-yannis (km)
m17n-kn-inscript (kn)
m17n-kn-itrans (kn)
m17n-kn-kgp (kn)
m17n-ko-han2 (ko)
m17n-ko-romaja (ko)
m17n-ks-inscript (ks)
m17n-ks-kbd (ks)
m17n-lo-kbd (lo)
m17n-lo-lrt (lo)
m17n-ml-inscript (ml)
m17n-ml-itrans (ml)
m17n-ml-mozhi (ml)
m17n-ml-swanalekha (ml)
m17n-mr-inscript (mr)
m17n-mr-itrans (mr)
m17n-mr-phonetic (mr)
m17n-my-kbd (my)
m17n-ne-rom (ne)
m17n-ne-trad (ne)
m17n-nsk-phonetic (nsk)
m17n-oj-phonetic (oj)
m17n-or-inscript (or)
m17n-or-itrans (or)
m17n-or-phonetic (or)
m17n-pa-inscript (pa)
m17n-pa-itrans (pa)
m17n-pa-jhelum (pa)
m17n-pa-phonetic (pa)
m17n-ps-phonetic (ps)
m17n-ru-kbd (ru)
m17n-ru-phonetic (ru)
m17n-ru-translit (ru)
m17n-ru-yawerty (ru)
m17n-sa-harvard-kyoto (sa)
m17n-sa-IAST (sa)
m17n-sd-inscript (sd)
m17n-si-phonetic-dynamic (si)
m17n-si-samanala (si)
m17n-si-singlish (si)
m17n-si-sumihiri (si)
m17n-si-transliteration (si)
m17n-si-wijesekera (si)
m17n-sk-kbd (sk)
m17n-sr-kbd (sr)
m17n-sv-post (sv)
m17n-ta-inscript (ta)
m17n-ta-itrans (ta)
m17n-ta-lk-renganathan (ta)
m17n-ta-phonetic (ta)
m17n-ta-tamil99 (ta)
m17n-ta-typewriter (ta)
m17n-ta-vutam (ta)
m17n-tai-sonla-kbd (tai)
m17n-te-apple (te)
m17n-te-inscript (te)
m17n-te-itrans (te)
m17n-te-pothana (te)
m17n-te-rts (te)
m17n-th-kesmanee (th)
m17n-th-pattachote (th)
m17n-th-tis820 (th)
m17n-ua-kbd (ua)
m17n-ug-kbd (ug)
m17n-ur-phonetic (ur)
m17n-uz-kbd (uz)
m17n-vi-han (vi)
m17n-vi-nomvni (vi)
m17n-vi-nomtelex (vi)
m17n-vi-tcvn (vi)
m17n-vi-telex (vi)
m17n-vi-viqr (vi)
m17n-vi-vni (vi)
m17n-yi-yivo (yi)
m17n-zh-bopomofo (zh)
m17n-zh-cangjie (zh)
m17n-zh-pinyin-vi (zh)
m17n-zh-pinyin (zh)
m17n-zh-py-b5 (zh)
m17n-zh-py-gb (zh)
m17n-zh-py (zh)
m17n-zh-quick (zh)
m17n-zh-tonepy-b5 (zh)
m17n-zh-tonepy-gb (zh)
m17n-zh-tonepy (zh)
elatin ()
latin ()
byeoru (ko)
tutcode (ja)
skk (ja)
prime (ja)
anthy-utf8 (ja)
anthy (ja)
mozc (ja)
XMODIFIERS=@im=uim registered, selecting anthy (ja) as default conversion engine
R Version: 3.1, x86_64
Using un-threaded functions...
Conv:
0 wallclock secs ( 0.28 usr + 0.01 sys = 0.29 CPU)
x_mac64(911,0x7fffad602380) malloc: *** error for object 0x7ffeefbfdf50: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
bash: line 1: 911 Abort trap: 6 ./x_mac64
AnoMacBook:~ A$


- 関連一覧ツリー (■ をクリックするとツリー全体を一括表示します)