{"id":51,"date":"2011-03-31T21:37:06","date_gmt":"2011-03-31T13:37:06","guid":{"rendered":"http:\/\/guoh.ai\/lifelog\/?p=51"},"modified":"2012-02-27T12:30:41","modified_gmt":"2012-02-27T04:30:41","slug":"issues","status":"publish","type":"post","link":"https:\/\/guoh.ai\/lifelog\/2011\/03\/issues\/","title":{"rendered":"\u95ee\u9898\u5217\u8868"},"content":{"rendered":"
<blockquote>\n<p style="text-align: left;"><strong>\u751f\u6d3b\u7684\u4e00\u534a\u662f\u9047\u5230\u95ee\u9898\uff0c\u53e6\u4e00\u534a\u662f\u89e3\u51b3\u95ee\u9898<\/strong><\/p>\n<\/blockquote>\n<p><strong>\u95ee\u9898\u4e5f\u8bb8\u5f88\u7b80\u5355\uff0c\u4f46\u95ee\u9898\u6bd5\u7adf\u662f\u95ee\u9898<\/strong><\/p>\n<p>1\u3001xNix\u4e0bApache 2.2\u542f\u52a8<br \/>\n<ins datetime="2011-03-31T13:10:19+00:00">guoh@KNIGHT:~\/apps\/volcano\/apache\/bin$ .\/apachectl -k start<br \/>\n(13)Permission denied: make_sock: could not bind to address 0.0.0.0:80<br \/>\nno listening sockets available, shutting down<br \/>\nUnable to open logs<\/ins><\/p>\n<p>\u53ea\u9700\u8981\u4ee5$sudo .\/apachectl -k start\u8fd0\u884c\u5373\u53ef\uff0c\u6ca1\u6709\u522b\u4eba\u5199\u7684\u90a3\u6837\u590d\u6742\uff0chttpd\u7684own\u548cgroup\u4e5f\u4e0d\u9700\u8981\u90fd\u4e3aroot\u7528\u6237<\/p>\n<p><a href="http:\/\/callaly.net\/blog\/archives\/94.html" target="_blank">http:\/\/callaly.net\/blog\/archives\/94.html<\/a><\/p>\n<p>2\u3001Perl\u7684DateTime\u6a21\u5757\u88c5\u4e0d\u4e0a<br \/>\n<ins datetime="2011-04-13T12:32:21+00:00">perl install-module.pl DateTime<br \/>\n CPAN.pm: Going to build D\/DR\/DROLSKY\/DateTime-0.66.tar.gz<br \/>\nCan’t locate Module\/Build.pm in @INC (@INC contains: \/home\/allcom\/volcano\/bugzilla-4.0\/lib\/i386-linux-thread-multi \/home\/allcom\/volcano\/bugzilla-4.0\/lib \/usr\/lib\/perl5\/site_perl\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/site_perl\/5.8.8 \/usr\/lib\/perl5\/site_perl \/usr\/lib\/perl5\/vendor_perl\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/vendor_perl\/5.8.8 \/usr\/lib\/perl5\/vendor_perl \/usr\/lib\/perl5\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/5.8.8 .) at Build.PL line 5.<br \/>\nBEGIN failed–compilation aborted at Build.PL line 5.<br \/>\nWarning: No success on command[\/usr\/bin\/perl Build.PL ]<br \/>\n DROLSKY\/DateTime-0.66.tar.gz<br \/>\n \/usr\/bin\/perl Build.PL — NOT OK<br \/>\nSkipping test because of notest pragma<br \/>\nRunning Build install<br \/>\n Make had some problems, won’t install<br \/>\nCould not read metadata file. Falling back to other methods to determine prerequisites<\/ins><\/p>\n<p>\u6211\u662f\u5728\u5b89\u88c5Bugzilla\u7684\u65f6\u5019\u78b0\u4e0a\u7684\uff0c\u89e3\u51b3\u529e\u6cd5\u662f\u5148\u88c5perl install-module.pl DateTime::Locale\u8fd9\u4e2a<\/p>\n<p>3\u3001<ins datetime="2011-04-13T12:32:21+00:00">Undefined subroutine &Math::Random::Secure::irand called at Bugzilla\/Util.pm line 577, <DATA> line 522.<\/ins><br \/>\n\u89e3\u51b3\u529e\u6cd5\u662frm -rf lib\/Math\/Random\/Secure*\uff0c\u8fd9\u4e2a\u76ee\u5f55\u662fBugzilla\u4e0b\u7684\u76ee\u5f55\uff0c\u8fd9\u4e2a\u662f\u4ece\u63a8\u7279\u4e0a\u770b\u6765\u7684<\/p>\n<p>4\u300164\u4f4dUbuntu\u5b89\u88c5Android SDK\u540e\u6267\u884cadb emulator\u4e4b\u7c7b\u7684\u547d\u4ee4\u65f6\u63d0\u793a<ins datetime="2011-04-20T11:58:05+00:00">\u201cNo such a file or directory\u201d\uff0c\u4e2d\u6587\u201c\u6ca1\u6709\u90a3\u4e2a\u6587\u4ef6\u6216\u76ee\u5f55\u201d<\/ins><br \/>\n\u6709\u53ef\u80fd\u662f\u6ca1\u6709\u5b89\u88c5ia32-libs\uff0c\u6240\u4ee5\u53ea\u9700\u8981sudo apt-get install ia32-libs\u5e94\u8be5\u5c31\u53ef\u4ee5<\/p>\n<p>5\u3001Can’t update table ‘tablek’ in stored function\/trigger because it is already used by statement which invoked this stored function\/trigger.<br \/>\n\u89e6\u53d1\u5668\u901a\u8fc7UPDATE\u8bed\u53e5\u66f4\u65b0\u672c\u8868\u521a\u521a\u63d2\u5165\u6216\u8005\u4fee\u6539\u7684\u6570\u636e\u4f1a\u9020\u6210\u5faa\u73af\u5f15\u7528<br \/>\n\u4e0b\u9762\u8fd9\u6837\u5199\u5c31\u53ef\u4ee5\uff0c\u76f8\u5f53\u4e8e\u4e00\u4e2a\u62e6\u622a\u5668\uff0cAOP\u4e4b\u7c7b\u7684\u601d\u60f3\u5427<\/p>\n<pre class="brush: sql; title: ; notranslate" title="">CREATE trigger insert_before_tablek\r\n before\r\n insert on tablek\r\n for each row\r\n begin\r\n set new.status = 25;\r\n end<\/pre>\n<p>6\u3001\/bin\/bash: AR@\uff1a\u627e\u4e0d\u5230\u547d\u4ee4<br \/>\n\u7f16\u8bd1\u5b89\u88c5SysBench-0.4.12<br \/>\nsudo .\/configure –prefix=SYSBENCH_INSTALLATION_HOME –with-mysql-includes=MYSQL_INSTALLATION_HOME\/include –with-mysql-libs=MYSQL_INSTALLATION_HOME\/lib<\/p>\n<p>sudo make<br \/>\n\u524d\u9762\u9047\u5230\u7684\u51e0\u4e2a\u5c0f\u95ee\u9898\u90fd\u89e3\u51b3\u4e86\uff0c\u4f46\u9047\u5230\u4e2a\u65b0\u7684\u95ee\u9898<\/p>\n<p>Making all in mysql<br \/>\nmake[3]: \u6b63\u5728\u8fdb\u5165\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers\/mysql’<br \/>\nrm -f libsbmysql.a<br \/>\n\/bin\/bash: AR@\uff1a\u627e\u4e0d\u5230\u547d\u4ee4<br \/>\nmake[3]: *** [libsbmysql.a] \u9519\u8bef 127<br \/>\nmake[3]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers\/mysql’<br \/>\nmake[2]: *** [all-recursive] \u9519\u8bef 1<br \/>\nmake[2]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers’<br \/>\nmake[1]: *** [all-recursive] \u9519\u8bef 1<br \/>\nmake[1]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench’<br \/>\nmake: *** [all-recursive] \u9519\u8bef 1<\/p>\n<p>AR@\u627e\u4e0d\u5230\u547d\u4ee4\uff0c\u8fd9\u4e2a\u611f\u89c9\u6709\u53ef\u80fd\u662fMake\u811a\u672c\u4e2d\u53c2\u6570\u6216\u4ec0\u4e48\u6ca1\u6709\u66ff\u6362\u5bf9\u4ec0\u4e48\u7684\uff0c\u4f46\u4e0d\u77e5\u9053\u600e\u4e48\u6539\uff0c\u770b\u4e0d\u61c2Makefile<br \/>\n\u673a\u5668\u4e2d\u76ee\u524dar\u547d\u4ee4\u662f\u5b58\u5728\u7684<br \/>\n\u76ee\u524d\u6ca1\u6709\u627e\u5230\u89e3\u51b3\u529e\u6cd5<\/p>\n<p>7\u3001MySQL\u7c7b\u4f3c\u8fd9\u79cd\u8bed\u53e5\u5199\u6cd5SELECT value FROM paras WHERE pkey = ‘freeze’ AND domain = domain;<\/p>\n<pre class="brush: sql; title: ; notranslate" title="">create table paras (value varchar(50), pkey varchar(50), domain varchar(50));<\/pre>\n<p>\u8fd9\u4e2a\u95ee\u9898\u6d6a\u8d39\u4e86\u6211\u5f88\u4e0d\u5c11\u65f6\u95f4\uff0c\u56e0\u4e3a\u5728Linux\u4e0b\u9762\uff0c\u53c8\u662f\u5728\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u5e76\u4e14\u662f\u5c01\u88c5\u4e86\u5f02\u5e38\u7684\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u5f02\u5e38\u4fe1\u606f\u88ab\u541e\u6389\u4e86<br \/>\n\u8c03\u8bd5\u5de5\u5177\u4e5f\u4e0d\u7ed9\u529b\uff0c\u6240\u4ee5\u57fa\u672c\u662f\u4eba\u5de5\u770b\u7684<\/p>\n<pre class="brush: sql; title: ; notranslate" title="">CREATE PROCEDURE tdemo(domain VARCHAR(50))\r\nBEGIN\r\n DECLARE v_value VARCHAR(50);\r\n SELECT value FROM paras WHERE pkey = 'freeze' AND domain = domain INTO v_value;\r\nEND<\/pre>\n<p>\u8fd9\u4e2a\u8fc7\u7a0b\u7f16\u8bd1\u901a\u8fc7\uff0c\u6267\u884c\u7684\u65f6\u5019\u62a5\u4e86\u4e0b\u9762\u7684\u9519\u8bef<\/p>\n<blockquote><p>ERROR 1172 (42000): Result consisted of more than one row<\/p><\/blockquote>\n<p>\u60f3\u60f3\u4e5f\u77e5\u9053\u662f\u8fd4\u56de\u4e86\u591a\u6761\u6570\u636e\u5230INTO\uff0c\u8fd9\u662f\u9519\u8bef\u7684<br \/>\n\u4f46\u4e3a\u4ec0\u4e48\u4f1a\u8fd4\u56de\u591a\u6761\u6570\u636e\u5462\uff1f\u660e\u660e\u540e\u9762\u9650\u5236\u4e86<br \/>\n\u95ee\u9898\u5c31\u5904\u5728\u5b58\u50a8\u8fc7\u7a0b\u7684\u90a3\u4e2a\u5165\u53c2domain\u4e0a\uff0c\u5b83\u548c\u8868\u7684\u4e00\u4e2a\u5b57\u6bb5\u540d\u4e00\u6a21\u4e00\u6837\u7684\u4e86<br \/>\n\u8fd9\u65f6\u5019MySQL\u5c31\u8ba4\u4e3a\u8fd9\u4e24\u4e2a\u59cb\u7ec8\u76f8\u540c\uff0c\u4e8e\u662f\u8bed\u53e5\u53d8\u6210\u4e86\u4e0b\u9762\u8fd9\u6837\u5b50<\/p>\n<pre class="brush: sql; title: ; notranslate" title="">SELECT value FROM paras WHERE pkey = 'freeze';<\/pre>\n<p>\u6240\u4ee5\u5c31\u9519\u4e86<\/p>\n<p>\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u53d8\u91cf\u547d\u540d\u4e5f\u662f\u503c\u5f97\u8003\u7a76\u7684\u4e00\u4e2a\u95ee\u9898\uff0c\u5f53\u5b58\u50a8\u8fc7\u7a0b\u592a\u957f\u4e86\u65f6\u5019\u662f\u4ef6\u5f88\u75db\u82e6\u7684\u4e8b\u60c5<br \/>\n\u6709\u4eba\u8fd9\u4e48\u505a<br \/>\n\u5165\u53c2\u53d8\u91cf\u52a0IN_\u524d\u7f00<br \/>\n\u51fa\u53c2\u53d8\u91cf\u52a0OUT_\u524d\u7f00<br \/>\n\u96f6\u65f6\u53d8\u91cf\u52a0TMP_\u524d\u7f00<br \/>\n\u6574\u5f62\u53d8\u91cf\u52a0I_\u524d\u7f00<br \/>\n\u5b57\u7b26\u4e32\u53d8\u91cf\u52a0S_\u524d\u7f00<br \/>\n\u65f6\u95f4\u65e5\u671f\u53d8\u91cf\u52a0D_\u524d\u7f00<\/p>\n<p>\u53e6\u5916\u4e3a\u4e86\u7b80\u5355\uff0c\u907f\u514d\u51fa\u9519\uff0c\u53c2\u6570\u4e0d\u8981\u548c\u5b57\u6bb5\u4e00\u6a21\u4e00\u6837<\/p>\n<p>8\u3001Java\u8fde\u63a5SQLServer\uff0c\u4e0d\u8bf4\u4e86\uff0c\u76f4\u63a5\u4e0a\u6700\u65b0\u9a71\u52a8<br \/>\n\u65f6\u9694\u591a\u5e74\u4e0d\u78b0SQLServer\uff0c\u7a81\u7136\u8981\u5076\u5f04SQLServer\u5b58\u50a8\u8fc7\u7a0b\uff0c\u8fd8\u7ed9\u4e86\u5076\u4e09\u4e2a\u6700\u8001\u7684JAR\u5305<br \/>\n\u8fde\u63a5\u6c60\u4e00\u4e0a\uff0c\u9519\u8bef\u8b66\u544a\u767e\u51fa\uff0c\u5751\u7239\u554a<br \/>\n\u76f4\u63a5\u4e0b\u8f7d\u65b0\u7248\u9a71\u52a8<br \/>\nhttp:\/\/msdn.microsoft.com\/zh-cn\/data\/aa937724.aspx<br \/>\n\u7136\u540e\u8bbe\u7f6e\uff0c\u65b0\u9a71\u52a8\u7684\u8fde\u63a5\u4e32\u4e0d\u4e00\u6837<br \/>\nhttp:\/\/blogs.msdn.com\/b\/jdbcteam\/archive\/2007\/06\/15\/java-lang-classnotfoundexception-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx<br \/>\n\u8c8c\u4f3c\u9a71\u52a8\u8fd8\u6709\u4e2d\u82f1\u6587\u7684\u533a\u5206\uff0c\u6211\u4e2d\u6587\u6570\u636e\u5e93\u968f\u4fbf\u7528\u4e86\u4e2a\u82f1\u6587\u7684\u597d\u50cf\u4e5f\u53ef\u4ee5<br \/>\n\u5982\u4e0b\u5217\u4e3e\u7684\u662f\u53ef\u80fd\u51fa\u73b0\u7684\u95ee\u9898\uff1a<br \/>\ncom.microsoft.jdbc.sqlserver.SQLServerConnection@9980d5 threw an Error when we tried to check its default holdability. This is probably due to a bug in your JDBC driver that c3p0 can harmlessly work around (reported for some DB2 drivers). Please verify that the error stack trace is consistentwith the getHoldability() method not being properly implemented, and is not due to some deeper problem. This message will not be repeated for Connections of type com.microsoft.jdbc.sqlserver.SQLServerConnection that provoke errors of type java.lang.AbstractMethodError when getHoldability() is called.<br \/>\n\u548cC3P0\u4e00\u8d77\u7528\u7684\u65f6\u5019<\/p>\n<p>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).<\/p>\n<p>\u8fd8\u6709\u8bf8\u5982\u4ec0\u4e48\u5207\u6362\u8bed\u8a00\u4e4b\u7c7b\u7684\u8b66\u544a<\/p>\n<p>9\u3001\u5728Ubuntu\u4f7f\u7528Wireshark\u65f6\uff0cInterface\u4e3a\u7a7a\u7684\uff0c\u4ec0\u4e48\u90fd\u6ca1\u6709<br \/>\ndumpcap: There are no interfaces on which a capture can be done<br \/>\n\u9700\u8981\u7528root\u6743\u9650\u5f00\u542f\u8fd9\u4e2a\u8f6f\u4ef6\u5c31\u597d\uff0c\u5373sudo<br \/>\n\u5176\u4ed6Linux\u5e94\u8be5\u4e5f\u5982\u6b64<\/p>\n<\/div>
\n

\u751f\u6d3b\u7684\u4e00\u534a\u662f\u9047\u5230\u95ee\u9898\uff0c\u53e6\u4e00\u534a\u662f\u89e3\u51b3\u95ee\u9898<\/strong><\/p>\n<\/blockquote>\n

\u95ee\u9898\u4e5f\u8bb8\u5f88\u7b80\u5355\uff0c\u4f46\u95ee\u9898\u6bd5\u7adf\u662f\u95ee\u9898<\/strong><\/p>\n

1\u3001xNix\u4e0bApache 2.2\u542f\u52a8
\nguoh@KNIGHT:~\/apps\/volcano\/apache\/bin$ .\/apachectl -k start
\n(13)Permission denied: make_sock: could not bind to address 0.0.0.0:80
\nno listening sockets available, shutting down
\nUnable to open logs<\/ins><\/p>\n

\u53ea\u9700\u8981\u4ee5$sudo .\/apachectl -k start\u8fd0\u884c\u5373\u53ef\uff0c\u6ca1\u6709\u522b\u4eba\u5199\u7684\u90a3\u6837\u590d\u6742\uff0chttpd\u7684own\u548cgroup\u4e5f\u4e0d\u9700\u8981\u90fd\u4e3aroot\u7528\u6237<\/p>\n

http:\/\/callaly.net\/blog\/archives\/94.html<\/a><\/p>\n

2\u3001Perl\u7684DateTime\u6a21\u5757\u88c5\u4e0d\u4e0a
\nperl install-module.pl DateTime
\n CPAN.pm: Going to build D\/DR\/DROLSKY\/DateTime-0.66.tar.gz
\nCan’t locate Module\/Build.pm in @INC (@INC contains: \/home\/allcom\/volcano\/bugzilla-4.0\/lib\/i386-linux-thread-multi \/home\/allcom\/volcano\/bugzilla-4.0\/lib \/usr\/lib\/perl5\/site_perl\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/site_perl\/5.8.8 \/usr\/lib\/perl5\/site_perl \/usr\/lib\/perl5\/vendor_perl\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/vendor_perl\/5.8.8 \/usr\/lib\/perl5\/vendor_perl \/usr\/lib\/perl5\/5.8.8\/i386-linux-thread-multi \/usr\/lib\/perl5\/5.8.8 .) at Build.PL line 5.
\nBEGIN failed–compilation aborted at Build.PL line 5.
\nWarning: No success on command[\/usr\/bin\/perl Build.PL ]
\n DROLSKY\/DateTime-0.66.tar.gz
\n \/usr\/bin\/perl Build.PL — NOT OK
\nSkipping test because of notest pragma
\nRunning Build install
\n Make had some problems, won’t install
\nCould not read metadata file. Falling back to other methods to determine prerequisites<\/ins><\/p>\n

\u6211\u662f\u5728\u5b89\u88c5Bugzilla\u7684\u65f6\u5019\u78b0\u4e0a\u7684\uff0c\u89e3\u51b3\u529e\u6cd5\u662f\u5148\u88c5perl install-module.pl DateTime::Locale\u8fd9\u4e2a<\/p>\n

3\u3001Undefined subroutine &Math::Random::Secure::irand called at Bugzilla\/Util.pm line 577, line 522.<\/ins>
\n\u89e3\u51b3\u529e\u6cd5\u662frm -rf lib\/Math\/Random\/Secure*\uff0c\u8fd9\u4e2a\u76ee\u5f55\u662fBugzilla\u4e0b\u7684\u76ee\u5f55\uff0c\u8fd9\u4e2a\u662f\u4ece\u63a8\u7279\u4e0a\u770b\u6765\u7684<\/p>\n

4\u300164\u4f4dUbuntu\u5b89\u88c5Android SDK\u540e\u6267\u884cadb emulator\u4e4b\u7c7b\u7684\u547d\u4ee4\u65f6\u63d0\u793a\u201cNo such a file or directory\u201d\uff0c\u4e2d\u6587\u201c\u6ca1\u6709\u90a3\u4e2a\u6587\u4ef6\u6216\u76ee\u5f55\u201d<\/ins>
\n\u6709\u53ef\u80fd\u662f\u6ca1\u6709\u5b89\u88c5ia32-libs\uff0c\u6240\u4ee5\u53ea\u9700\u8981sudo apt-get install ia32-libs\u5e94\u8be5\u5c31\u53ef\u4ee5<\/p>\n

5\u3001Can’t update table ‘tablek’ in stored function\/trigger because it is already used by statement which invoked this stored function\/trigger.
\n\u89e6\u53d1\u5668\u901a\u8fc7UPDATE\u8bed\u53e5\u66f4\u65b0\u672c\u8868\u521a\u521a\u63d2\u5165\u6216\u8005\u4fee\u6539\u7684\u6570\u636e\u4f1a\u9020\u6210\u5faa\u73af\u5f15\u7528
\n\u4e0b\u9762\u8fd9\u6837\u5199\u5c31\u53ef\u4ee5\uff0c\u76f8\u5f53\u4e8e\u4e00\u4e2a\u62e6\u622a\u5668\uff0cAOP\u4e4b\u7c7b\u7684\u601d\u60f3\u5427<\/p>\n

CREATE trigger insert_before_tablek\r\n    before\r\n        insert on tablek\r\n    for each row\r\n        begin\r\n            set new.status = 25;\r\n        end<\/pre>\n
6\u3001\/bin\/bash: AR@\uff1a\u627e\u4e0d\u5230\u547d\u4ee4
\n\u7f16\u8bd1\u5b89\u88c5SysBench-0.4.12
\nsudo .\/configure –prefix=SYSBENCH_INSTALLATION_HOME –with-mysql-includes=MYSQL_INSTALLATION_HOME\/include –with-mysql-libs=MYSQL_INSTALLATION_HOME\/lib<\/p>\n
sudo make
\n\u524d\u9762\u9047\u5230\u7684\u51e0\u4e2a\u5c0f\u95ee\u9898\u90fd\u89e3\u51b3\u4e86\uff0c\u4f46\u9047\u5230\u4e2a\u65b0\u7684\u95ee\u9898<\/p>\n
Making all in mysql
\nmake[3]: \u6b63\u5728\u8fdb\u5165\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers\/mysql’
\nrm -f libsbmysql.a
\n\/bin\/bash: AR@\uff1a\u627e\u4e0d\u5230\u547d\u4ee4
\nmake[3]: *** [libsbmysql.a] \u9519\u8bef 127
\nmake[3]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers\/mysql’
\nmake[2]: *** [all-recursive] \u9519\u8bef 1
\nmake[2]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench\/drivers’
\nmake[1]: *** [all-recursive] \u9519\u8bef 1
\nmake[1]:\u6b63\u5728\u79bb\u5f00\u76ee\u5f55 `\/home\/aristel\/sysbench-0.4.12\/sysbench’
\nmake: *** [all-recursive] \u9519\u8bef 1<\/p>\n
AR@\u627e\u4e0d\u5230\u547d\u4ee4\uff0c\u8fd9\u4e2a\u611f\u89c9\u6709\u53ef\u80fd\u662fMake\u811a\u672c\u4e2d\u53c2\u6570\u6216\u4ec0\u4e48\u6ca1\u6709\u66ff\u6362\u5bf9\u4ec0\u4e48\u7684\uff0c\u4f46\u4e0d\u77e5\u9053\u600e\u4e48\u6539\uff0c\u770b\u4e0d\u61c2Makefile
\n\u673a\u5668\u4e2d\u76ee\u524dar\u547d\u4ee4\u662f\u5b58\u5728\u7684
\n\u76ee\u524d\u6ca1\u6709\u627e\u5230\u89e3\u51b3\u529e\u6cd5<\/p>\n
7\u3001MySQL\u7c7b\u4f3c\u8fd9\u79cd\u8bed\u53e5\u5199\u6cd5SELECT value FROM paras WHERE pkey = ‘freeze’ AND domain = domain;<\/p>\n
create table paras (value varchar(50), pkey varchar(50), domain varchar(50));<\/pre>\n
\u8fd9\u4e2a\u95ee\u9898\u6d6a\u8d39\u4e86\u6211\u5f88\u4e0d\u5c11\u65f6\u95f4\uff0c\u56e0\u4e3a\u5728Linux\u4e0b\u9762\uff0c\u53c8\u662f\u5728\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u5e76\u4e14\u662f\u5c01\u88c5\u4e86\u5f02\u5e38\u7684\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u5f02\u5e38\u4fe1\u606f\u88ab\u541e\u6389\u4e86
\n\u8c03\u8bd5\u5de5\u5177\u4e5f\u4e0d\u7ed9\u529b\uff0c\u6240\u4ee5\u57fa\u672c\u662f\u4eba\u5de5\u770b\u7684<\/p>\n
CREATE PROCEDURE tdemo(domain VARCHAR(50))\r\nBEGIN\r\n    DECLARE v_value VARCHAR(50);\r\n    SELECT value FROM paras WHERE pkey = 'freeze' AND domain = domain INTO v_value;\r\nEND<\/pre>\n
\u8fd9\u4e2a\u8fc7\u7a0b\u7f16\u8bd1\u901a\u8fc7\uff0c\u6267\u884c\u7684\u65f6\u5019\u62a5\u4e86\u4e0b\u9762\u7684\u9519\u8bef<\/p>\n
ERROR 1172 (42000): Result consisted of more than one row<\/p><\/blockquote>\n
\u60f3\u60f3\u4e5f\u77e5\u9053\u662f\u8fd4\u56de\u4e86\u591a\u6761\u6570\u636e\u5230INTO\uff0c\u8fd9\u662f\u9519\u8bef\u7684
\n\u4f46\u4e3a\u4ec0\u4e48\u4f1a\u8fd4\u56de\u591a\u6761\u6570\u636e\u5462\uff1f\u660e\u660e\u540e\u9762\u9650\u5236\u4e86
\n\u95ee\u9898\u5c31\u5904\u5728\u5b58\u50a8\u8fc7\u7a0b\u7684\u90a3\u4e2a\u5165\u53c2domain\u4e0a\uff0c\u5b83\u548c\u8868\u7684\u4e00\u4e2a\u5b57\u6bb5\u540d\u4e00\u6a21\u4e00\u6837\u7684\u4e86
\n\u8fd9\u65f6\u5019MySQL\u5c31\u8ba4\u4e3a\u8fd9\u4e24\u4e2a\u59cb\u7ec8\u76f8\u540c\uff0c\u4e8e\u662f\u8bed\u53e5\u53d8\u6210\u4e86\u4e0b\u9762\u8fd9\u6837\u5b50<\/p>\n
SELECT value FROM paras WHERE pkey = 'freeze';<\/pre>\n
\u6240\u4ee5\u5c31\u9519\u4e86<\/p>\n
\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u53d8\u91cf\u547d\u540d\u4e5f\u662f\u503c\u5f97\u8003\u7a76\u7684\u4e00\u4e2a\u95ee\u9898\uff0c\u5f53\u5b58\u50a8\u8fc7\u7a0b\u592a\u957f\u4e86\u65f6\u5019\u662f\u4ef6\u5f88\u75db\u82e6\u7684\u4e8b\u60c5
\n\u6709\u4eba\u8fd9\u4e48\u505a
\n\u5165\u53c2\u53d8\u91cf\u52a0IN_\u524d\u7f00
\n\u51fa\u53c2\u53d8\u91cf\u52a0OUT_\u524d\u7f00
\n\u96f6\u65f6\u53d8\u91cf\u52a0TMP_\u524d\u7f00
\n\u6574\u5f62\u53d8\u91cf\u52a0I_\u524d\u7f00
\n\u5b57\u7b26\u4e32\u53d8\u91cf\u52a0S_\u524d\u7f00
\n\u65f6\u95f4\u65e5\u671f\u53d8\u91cf\u52a0D_\u524d\u7f00<\/p>\n
\u53e6\u5916\u4e3a\u4e86\u7b80\u5355\uff0c\u907f\u514d\u51fa\u9519\uff0c\u53c2\u6570\u4e0d\u8981\u548c\u5b57\u6bb5\u4e00\u6a21\u4e00\u6837<\/p>\n
8\u3001Java\u8fde\u63a5SQLServer\uff0c\u4e0d\u8bf4\u4e86\uff0c\u76f4\u63a5\u4e0a\u6700\u65b0\u9a71\u52a8
\n\u65f6\u9694\u591a\u5e74\u4e0d\u78b0SQLServer\uff0c\u7a81\u7136\u8981\u5076\u5f04SQLServer\u5b58\u50a8\u8fc7\u7a0b\uff0c\u8fd8\u7ed9\u4e86\u5076\u4e09\u4e2a\u6700\u8001\u7684JAR\u5305
\n\u8fde\u63a5\u6c60\u4e00\u4e0a\uff0c\u9519\u8bef\u8b66\u544a\u767e\u51fa\uff0c\u5751\u7239\u554a
\n\u76f4\u63a5\u4e0b\u8f7d\u65b0\u7248\u9a71\u52a8
\nhttp:\/\/msdn.microsoft.com\/zh-cn\/data\/aa937724.aspx
\n\u7136\u540e\u8bbe\u7f6e\uff0c\u65b0\u9a71\u52a8\u7684\u8fde\u63a5\u4e32\u4e0d\u4e00\u6837
\nhttp:\/\/blogs.msdn.com\/b\/jdbcteam\/archive\/2007\/06\/15\/java-lang-classnotfoundexception-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx
\n\u8c8c\u4f3c\u9a71\u52a8\u8fd8\u6709\u4e2d\u82f1\u6587\u7684\u533a\u5206\uff0c\u6211\u4e2d\u6587\u6570\u636e\u5e93\u968f\u4fbf\u7528\u4e86\u4e2a\u82f1\u6587\u7684\u597d\u50cf\u4e5f\u53ef\u4ee5
\n\u5982\u4e0b\u5217\u4e3e\u7684\u662f\u53ef\u80fd\u51fa\u73b0\u7684\u95ee\u9898\uff1a
\ncom.microsoft.jdbc.sqlserver.SQLServerConnection@9980d5 threw an Error when we tried to check its default holdability. This is probably due to a bug in your JDBC driver that c3p0 can harmlessly work around (reported for some DB2 drivers). Please verify that the error stack trace is consistentwith the getHoldability() method not being properly implemented, and is not due to some deeper problem. This message will not be repeated for Connections of type com.microsoft.jdbc.sqlserver.SQLServerConnection that provoke errors of type java.lang.AbstractMethodError when getHoldability() is called.
\n\u548cC3P0\u4e00\u8d77\u7528\u7684\u65f6\u5019<\/p>\n
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).<\/p>\n
\u8fd8\u6709\u8bf8\u5982\u4ec0\u4e48\u5207\u6362\u8bed\u8a00\u4e4b\u7c7b\u7684\u8b66\u544a<\/p>\n
9\u3001\u5728Ubuntu\u4f7f\u7528Wireshark\u65f6\uff0cInterface\u4e3a\u7a7a\u7684\uff0c\u4ec0\u4e48\u90fd\u6ca1\u6709
\ndumpcap: There are no interfaces on which a capture can be done
\n\u9700\u8981\u7528root\u6743\u9650\u5f00\u542f\u8fd9\u4e2a\u8f6f\u4ef6\u5c31\u597d\uff0c\u5373sudo
\n\u5176\u4ed6Linux\u5e94\u8be5\u4e5f\u5982\u6b64<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"
<blockquote> <p style="text-align: left;"><strong>\u751f\u6d3b\u7684\u4e00\u534a\u662f\u9047\u5230\u95ee\u9898\uff0c\u53e6\u4e00\u534a\u662f\u89e3\u51b3\u95ee\u9898<\/strong><\/p> <\/blockquote> <p><strong>\u95ee\u9898\u4e5f\u8bb8\u5f88\u7b80\u5355\uff0c\u4f46\u95ee\u9898\u6bd5\u7adf\u662f\u95ee\u9898<\/strong><\/p> <p>1\u3001xNix\u4e0bApache 2.2\u542f\u52a8<br \/> <ins datetime="2011-03-31T13:10:19+00:00">guoh@KNIGHT:~\/apps\/volcano\/apache\/bin$ .\/apachectl -k start<br \/> (13)Permission denied: make_sock: could not bind to address 0.0.0.0:80<br \/> no listening sockets available, shutting down<br \/> Unable to open logs<\/ins><\/p> <p>\u53ea\u9700\u8981\u4ee5$sudo .\/apachectl -k start\u8fd0\u884c\u5373\u53ef\uff0c\u6ca1\u6709\u522b\u4eba\u5199\u7684\u90a3\u6837\u590d\u6742\uff0chttpd\u7684own\u548cgroup\u4e5f\u4e0d\u9700\u8981\u90fd\u4e3aroot\u7528\u6237<\/p> <p><a href="http:\/\/callaly.net\/blog\/archives\/94.html" target="_blank">http:\/\/callaly.net\/blog\/archives\/94.html<\/a><\/p> <p>2\u3001Perl\u7684DateTime\u6a21\u5757\u88c5\u4e0d\u4e0a<br \/> <ins datetime="2011-04-13T12:32:21+00:00">perl install-module.pl DateTime<br \/> CPAN.pm: Going to build D\/DR\/DROLSKY\/DateTime-0.66.tar.gz<br … Continue reading \u95ee\u9898\u5217\u8868<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_gfmr_meta_descriptions":[],"_gfmr_multilingual_taxonomy_terms":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-misc"],"_links":{"self":[{"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/comments?post=51"}],"version-history":[{"count":30,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":391,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/posts\/51\/revisions\/391"}],"wp:attachment":[{"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/media?parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/categories?post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guoh.ai\/lifelog\/wp-json\/wp\/v2\/tags?post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}