2017年8月

Mysqld_multi Stop Bug

最近在做mysqld_multi管理多实例的时候,发现stop不了节点
这是什么原因呢?
多实例相关配置如下:

[mysqld_multi]  
mysqld     = /usr/local/mysql/bin/mysqld_safe  
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/mysqld_multi.log
user       = root
password   = shunzi

[mysqld3306]  
socket     = /data/mysql3306/tmp/mysql3306.sock
port       = 3306  
user       = mysql

pid-file   = /data/mysql3306/mysql3306.pid  
datadir    = /data/mysql3306/data
tmpdir     = /data/mysql3306/tmp

[mysqld3307]  
socket     = /data/mysql3307/tmp/mysql3307.sock
port       = 3307  
user       = mysql

pid-file   = /data/mysql3307/mysql3307.pid  
datadir    = /data/mysql3307/data
tmpdir     = /data/mysql3307/tmp

- 阅读剩余部分 -

EXP-00091:Exporting questionable statistics

今天在oracle上做exp导出的时候报exp-00091;
查了下是服务端跟客户端的字符集不一致导致的

服务端字符集查询SQL:

select userenv('language') from dual;

执行过程如下:

E:\data>exp userid=mig/mig tables=T_CUSTOMER,T_PHONE,T_CUSTOMER_PHONE
 file=e:\data\pub.dump  log=e:\data\pub.log buffer=40960000 grants=n indexes=n t
riggers=n constraints=n

Export: Release 11.2.0.4.0 - Production on Tue Aug 29 15:50:24 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                   T_CUSTOMER    1320672 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      T_PHONE    1869331 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table             T_CUSTOMER_PHONE    1869331 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

E:\data>echo $NLS_LANG
$NLS_LANG

E:\data>echo %NLS_LANG%
AMERICAN_AMERICA.UTF8

E:\data>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

E:\data>exp userid=mig/mig tables=T_CUSTOMER,T_PHONE,T_CUSTOMER_PHONE
 file=e:\data\pub.dump  log=e:\data\pub.log buffer=40960000 grants=n indexes=n t
riggers=n constraints=n

Export: Release 11.2.0.4.0 - Production on Tue Aug 29 15:55:25 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and UTF8 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                   T_CUSTOMER    1320672 rows exported
. . exporting table                      T_PHONE    1869331 rows exported
. . exporting table             T_CUSTOMER_PHONE    1869331 rows exported
Export terminated successfully without warnings.

E:\data>

最后提一下,utf8跟al32utf8字符集是不一样的,好吧,mark一下!

极路由3刷openwrt固件

以前用极路由的原因是因为能够安装很多插件,其中做常用的是端口转发功能。
最近升级最新版后,发现端口转发功能不能用了,这样我就不能访问家里的开发环境了
然后果断放弃原固件,开始折腾openwrt

申请极路由开发者模式

登录极路由的云插件里申请,具体步骤请自行google

首先刷新万能不死uboot(breed)

这里用的是breed-mt7620-hiwifi-hc5761.bin(作者:hackpascal)

  • 下载bred软件,用winscp上传的路由器
  • ssh 连接路由器后,执行命令刷入

- 阅读剩余部分 -

Python3.5 install failed on windows 8.1

最近学习python爬虫,在windows8.1上安装python3.5版本报错,错误日志如下:

[1340:1D98][2017-08-05T19:15:44]i370: Session begin, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{337a726e-c616-4aa6-928d-ffc870664791}, options: 0x7, disable resume: No
[1340:1D98][2017-08-05T19:15:44]i000: Caching bundle from: 'C:\Users\Grionio\AppData\Local\Temp\{337a726e-c616-4aa6-928d-ffc870664791}\.be\python-3.5.0rc3-amd64.exe' to: 'C:\Users\Grionio\AppData\Local\Package Cache\{337a726e-c616-4aa6-928d-ffc870664791}\python-3.5.0rc3-amd64.exe'
[1340:1D98][2017-08-05T19:15:44]i320: Registering bundle dependency provider: {337a726e-c616-4aa6-928d-ffc870664791}, version: 3.5.123.0
[1340:1D98][2017-08-05T19:15:44]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{337a726e-c616-4aa6-928d-ffc870664791}, resume: Active, restart initiated: No, disable resume: No
[0AFC:163C][2017-08-05T19:15:44]i305: Verified acquired payload: crt_14.0_v6.3_x64 at path: C:\ProgramData\Package Cache\.unverified\crt_14.0_v6.3_x64, moving to: C:\ProgramData\Package Cache\FC6260C33678BB17FB8B88536C476B4015B7C5E9\Windows8.1-KB2999226-x64.msu.
[0AFC:1DF8][2017-08-05T19:15:44]i301: Applying execute package: crt_14.0_v6.3_x64, action: Install, path: C:\ProgramData\Package Cache\FC6260C33678BB17FB8B88536C476B4015B7C5E9\Windows8.1-KB2999226-x64.msu, arguments: '"C:\WINDOWS\SysNative\wusa.exe" "C:\ProgramData\Package Cache\FC6260C33678BB17FB8B88536C476B4015B7C5E9\Windows8.1-KB2999226-x64.msu" /quiet /norestart'
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: core_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\core_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{C34FF2D3-5190-4860-BF18-B0E17E7B88A5}v3.5.123.0\core.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: dev_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\dev_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{19801392-7899-4908-9F96-96C90954A5CA}v3.5.123.0\dev.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: exe_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\exe_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{4387444A-3419-4BC1-866F-1F3CAF5F8CFE}v3.5.123.0\exe.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: lib_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\lib_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{889E37CB-A7B7-4F73-A83F-BDCCCB224AD3}v3.5.123.0\lib.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: test_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\test_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{8C12CBDD-68E5-4999-88E5-4090CF195B2C}v3.5.123.0\test.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: doc_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\doc_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{97F8472D-58DB-4C4D-BA14-803E11082BE1}v3.5.123.0\doc.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: tools_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\tools_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{EFB01748-5CA4-4DF7-86E0-713CDBFED26B}v3.5.123.0\tools.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: tcltk_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\tcltk_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{894D289D-B197-4F20-9BBC-B9136AA52B9F}v3.5.123.0\tcltk.msi.
[0AFC:163C][2017-08-05T19:15:44]i305: Verified acquired payload: launcher_AllUsers at path: C:\ProgramData\Package Cache\.unverified\launcher_AllUsers, moving to: C:\ProgramData\Package Cache\{A8EDE40E-5C01-468F-B510-441E545511AE}v3.5.122.0\launcher.msi.
[1340:1E70][2017-08-05T19:15:44]i305: Verified acquired payload: pip_JustForMe at path: C:\Users\Grionio\AppData\Local\Package Cache\.unverified\pip_JustForMe, moving to: C:\Users\Grionio\AppData\Local\Package Cache\{07DBDDAA-E3B2-4B8A-9613-995E62AAECFD}v3.5.123.0\pip.msi.
[0AFC:1DF8][2017-08-05T19:15:45]e000: Error 0x80240017: Failed to execute MSU package.
[1340:1D98][2017-08-05T19:15:45]e000: Error 0x80240017: Failed to configure per-machine MSU package.
[1340:1D98][2017-08-05T19:15:45]i319: Applied execute package: crt_14.0_v6.3_x64, result: 0x80240017, restart: None
[1340:1D98][2017-08-05T19:15:45]e000: Error 0x80240017: Failed to execute MSU package.
[0AFC:1DF8][2017-08-05T19:15:45]i351: Removing cached package: crt_14.0_v6.3_x64, from path: C:\ProgramData\Package Cache\FC6260C33678BB17FB8B88536C476B4015B7C5E9\
[1340:1D98][2017-08-05T19:15:45]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{337a726e-c616-4aa6-928d-ffc870664791}, resume: None, restart: None, disable resume: No
[1340:1D98][2017-08-05T19:15:45]i330: Removed bundle dependency provider: {337a726e-c616-4aa6-928d-ffc870664791}
[1340:1D98][2017-08-05T19:15:45]i352: Removing cached bundle: {337a726e-c616-4aa6-928d-ffc870664791}, from path: C:\Users\Grionio\AppData\Local\Package Cache\{337a726e-c616-4aa6-928d-ffc870664791}\
[1340:1D98][2017-08-05T19:15:45]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{337a726e-c616-4aa6-928d-ffc870664791}, resume: None, restart initiated: No, disable resume: No
[1340:1D98][2017-08-05T19:15:46]i399: Apply complete, result: 0x80240017, restart: None, ba requested restart:  No

- 阅读剩余部分 -

Title - Artist
0:00