Created
November 10, 2014 12:35
-
-
Save mariuz/2b4ab646092e907f2791 to your computer and use it in GitHub Desktop.
fbproxy.py log when running node-firebird test run.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
python fbproxy.py localhost:3050 localhost:3060 | |
140177644566272 <-- 1 op_connect | |
------------------------------------------------------- | |
0000 0000001300000002000000010000003b...............; | |
0010 2f686f6d652f6d617269757a2f776f72/home/mariuz/wor | |
0020 6b2f6e6f64652d66697265626972642fk/node-firebird/ | |
0030 746573742f746573742d313431353632test/test-141562 | |
0040 323439373839352e66646200000000012497895.fdb..... | |
0050 0000001901066d617269757a040d4c6f......mariuz..Lo | |
0060 726b73746174696f6e3634060017fb01rkstation64..... | |
0070 0000000a000000010000000200000003................ | |
0080 00000002 .... | |
------------------------------------------------------- | |
connect_version 2 | |
Architecture type 1 | |
Path</home/mariuz/work/node-firebird/test/test-1415622497895.fdb> | |
Protocol version understood count= 1 | |
uid=[ 01066d617269757a040d4c6f726b73746174696f6e36340600 ] | |
CNCT_user 6 mariuz | |
CNCT_host 13 Lorkstation64 | |
CNCT_user_verification 0 | |
specific_data= | |
Protocol version 10 | |
Protocol Architecture type 1 | |
Minimum type 2 | |
Maxiumum type 3 | |
Preference weight 2 | |
140177644566272 --> 3 op_accept | |
------------------------------------------------------- | |
0000 0000000a0000000100000003 ............ | |
------------------------------------------------------- | |
accept_version<0000000a>accept_architecture<1>accept_type<3> | |
140177644566272 <-- 19 op_attach | |
------------------------------------------------------- | |
0000 000000000000003b2f686f6d652f6d61.......;/home/ma | |
0010 7269757a2f776f726b2f6e6f64652d66riuz/work/node-f | |
0020 697265626972642f746573742f746573irebird/test/tes | |
0030 742d313431353632323439373839352et-1415622497895. | |
0040 666462370000001a013004555446381cfdb7.....0.UTF8. | |
0050 065359534442411d096d61737465726b.SYSDBA..masterk | |
0060 6579fb01 ey.. | |
------------------------------------------------------- | |
Path</home/mariuz/work/node-firebird/test/test-1415622497895.fdb> | |
1 isc_dpb_version1 | |
48 isc_dpb_lc_ctype[ UTF8 ] | |
28 isc_dpb_user_name[ SYSDBA ] | |
29 isc_dpb_password[ masterkey ] | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000011400001800000002000000046f70656e000000020000003b2f686f6d652f6d617269757a2f776f726b2f6e6f64652d66697265626972642f746573742f746573742d313431353632323439373839352e66646200000000011400019e00000005000000194e6f20737563682066696c65206f72206469726563746f727900000000000000 ] | |
[................open.......;/home/mariuz/work/node-firebird/test/test-1415622497895.fdb.................No such file or directory.......] | |
isc_arg_gds isc_io_error isc_arg_string < open > isc_arg_string < /home/mariuz/work/node-firebird/test/test-1415622497895.fdb > isc_arg_gds isc_io_open_err isc_arg_interpreted < No such file or directory > isc_arg_end | |
140177644566272 <-- 20 op_create | |
------------------------------------------------------- | |
0000 000000000000003b2f686f6d652f6d61.......;/home/ma | |
0010 7269757a2f776f726b2f6e6f64652d66riuz/work/node-f | |
0020 697265626972642f746573742f746573irebird/test/tes | |
0030 742d313431353632323439373839352et-1415622497895. | |
0040 666462370000002f0144045554463830fdb7.../.D.UTF80 | |
0050 04555446381c065359534442411d096d.UTF8..SYSDBA..m | |
0060 61737465726b65793f01031801013601asterkey?.....6. | |
0070 0104040000100000 ........ | |
------------------------------------------------------- | |
Path</home/mariuz/work/node-firebird/test/test-1415622497895.fdb> | |
1 isc_dpb_version1 | |
68 isc_dpb_set_db_charset[ UTF8 ] | |
48 isc_dpb_lc_ctype[ UTF8 ] | |
28 isc_dpb_user_name[ SYSDBA ] | |
29 isc_dpb_password[ masterkey ] | |
63 isc_dpb_sql_dialect 3 | |
24 isc_dpb_force_write 1 | |
54 isc_dpb_overwrite 1 | |
4 isc_dpb_page_size 1048576 | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 29 op_transaction | |
------------------------------------------------------- | |
0000 000000000000000403090602 ............ | |
------------------------------------------------------- | |
Database<0> [ 03090602 ]=[ isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_concurrency] | |
140177644566272 --> 9 op_response | |
handle< 00000001 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 62 op_allocate_statement | |
------------------------------------------------------- | |
0000 00000000 .... | |
------------------------------------------------------- | |
Database<0>140177644566272 --> 9 op_response | |
handle< 00000002 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 68 op_prepare_statement | |
------------------------------------------------------- | |
0000 0000000100000002000000030000004a...............J | |
0010 435245415445205441424c4520746573CREATE TABLE tes | |
0020 742028494420494e542c204e414d4520t (ID INT, NAME | |
0030 56415243484152283530292c2046494cVARCHAR(50), FIL | |
0040 4520424c4f422c204352454154454420E BLOB, CREATED | |
0050 54494d455354414d5029444200000014TIMESTAMP)DB.... | |
0060 150407090b0c0d0e101113080507090b................ | |
0070 0c0d0e080000ffff ........ | |
------------------------------------------------------- | |
Trans<1>Statement<2>dialect<3> | |
CREATE TABLE test (ID INT, NAME VARCHAR(50), FILE BLOB, CREATED TIMESTAMP) | |
[ 150407090b0c0d0e101113080507090b0c0d0e08 ]=[isc_info_sql_stmt_type,isc_info_sql_select,isc_info_sql_describe_vars,isc_info_sql_sqlda_seq,isc_info_sql_type,isc_info_sql_sub_type,isc_info_sql_scale,isc_info_sql_length,isc_info_sql_field,isc_info_sql_relation,isc_info_sql_alias,isc_info_sql_describe_end,isc_info_sql_bind,isc_info_sql_describe_vars,isc_info_sql_sqlda_seq,isc_info_sql_type,isc_info_sql_sub_type,isc_info_sql_scale,isc_info_sql_length,isc_info_sql_describe_end,] | |
buffer_len= 65535 | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=24 | |
------------------------------------------------------- | |
0000 15040005000000040704000000000005................ | |
0010 0704000000000001 ........ | |
------------------------------------------------------- | |
isc_info_sql_stmt_type isc_info_sql_stmt_ddl | |
<-------- start byte index = 9 | |
col_len= 0 | |
isc_info_sql_describe_vars Invalid item <07> ! i=16 | |
isc_info_sql_select Invalid item <04> ! i=17 | |
None Invalid item <00> ! i=18 | |
None Invalid item <00> ! i=19 | |
None Invalid item <00> ! i=20 | |
None Invalid item <00> ! i=21 | |
None Invalid item <00> ! i=22 | |
--------> | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 63 op_execute | |
------------------------------------------------------- | |
0000 00000002000000010000000000000000................ | |
0010 00000000 .... | |
------------------------------------------------------- | |
Statement<2>Trans<1> | |
param BLR[ ] | |
<0,0> | |
140177644566272 --> 9 op_response | |
handle< 00000001 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 67 op_free_statement | |
------------------------------------------------------- | |
0000 0000000200000002 ........ | |
------------------------------------------------------- | |
Statement<2>DSQL_drop | |
140177644566272 --> 9 op_response | |
handle< ffffffff >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 30 op_commit | |
------------------------------------------------------- | |
0000 00000001 .... | |
------------------------------------------------------- | |
Trans<1> | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 29 op_transaction | |
------------------------------------------------------- | |
0000 000000000000000403090602 ............ | |
------------------------------------------------------- | |
Database<0> [ 03090602 ]=[ isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_concurrency] | |
140177644566272 --> 9 op_response | |
handle< 00000001 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 62 op_allocate_statement | |
------------------------------------------------------- | |
0000 00000000 .... | |
------------------------------------------------------- | |
Database<0>140177644566272 --> 9 op_response | |
handle< 00000002 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 68 op_prepare_statement | |
------------------------------------------------------- | |
0000 00000001000000020000000300000019................ | |
0010 53454c45435420434f554e54282a2920SELECT COUNT(*) | |
0020 46524f4d207465737401031800000014FROM test....... | |
0030 150407090b0c0d0e101113080507090b................ | |
0040 0c0d0e080000ffff ........ | |
------------------------------------------------------- | |
Trans<1>Statement<2>dialect<3> | |
SELECT COUNT(*) FROM test | |
[ 150407090b0c0d0e101113080507090b0c0d0e08 ]=[isc_info_sql_stmt_type,isc_info_sql_select,isc_info_sql_describe_vars,isc_info_sql_sqlda_seq,isc_info_sql_type,isc_info_sql_sub_type,isc_info_sql_scale,isc_info_sql_length,isc_info_sql_field,isc_info_sql_relation,isc_info_sql_alias,isc_info_sql_describe_end,isc_info_sql_bind,isc_info_sql_describe_vars,isc_info_sql_sqlda_seq,isc_info_sql_type,isc_info_sql_sub_type,isc_info_sql_scale,isc_info_sql_length,isc_info_sql_describe_end,] | |
buffer_len= 65535 | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=79 | |
------------------------------------------------------- | |
0000 15040001000000040704000100000009................ | |
0010 0400010000000b0400440200000c0400.........D...... | |
0020 000000000d0400000000000e04000800................ | |
0030 0000100500434f554e54110000130500.....COUNT...... | |
0040 434f554e540805070400000000000100COUNT........... | |
------------------------------------------------------- | |
isc_info_sql_stmt_type isc_info_sql_stmt_select | |
<-------- start byte index = 9 | |
col_len= 1 | |
isc_info_sql_sqlda_seq 1 | |
isc_info_sql_type 580 dtype= 580 | |
isc_info_sql_sub_type 0 | |
isc_info_sql_scale 0 | |
isc_info_sql_length 8 | |
isc_info_sql_field COUNT | |
isc_info_sql_relation | |
isc_info_sql_alias COUNT | |
isc_info_sql_describe_end | |
isc_info_sql_describe_vars Invalid item <07> ! i=71 | |
isc_info_sql_select Invalid item <04> ! i=72 | |
None Invalid item <00> ! i=73 | |
None Invalid item <00> ! i=74 | |
None Invalid item <00> ! i=75 | |
None Invalid item <00> ! i=76 | |
None Invalid item <00> ! i=77 | |
--------> | |
more info index= 1 | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 63 op_execute | |
------------------------------------------------------- | |
0000 00000002000000010000000000000000................ | |
0010 00000000 .... | |
------------------------------------------------------- | |
Statement<2>Trans<1> | |
param BLR[ ] | |
<0,0> | |
140177644566272 --> 9 op_response | |
handle< 00000001 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 65 op_fetch | |
------------------------------------------------------- | |
0000 000000020000000c0502040002001000................ | |
0010 0700ff4c00000000000000c8 ...L........ | |
------------------------------------------------------- | |
Statement<2> | |
BLR[ 05020400020010000700ff4c ] | |
Message No.<0> size<200> | |
140177644566272 --> 66 op_fetch_response | |
------------------------------------------------------- | |
0000 0000000000000001 ........ | |
------------------------------------------------------- | |
Status<0> count=<1> | |
statement=<2> | |
[580,0,0,8,None,COUNT,,,COUNT] | |
[580,0,0,8,None,COUNT,,,COUNT]0000000000000000 | |
{ 66100,0 } | |
140177644566272 <-- 67 op_free_statement | |
------------------------------------------------------- | |
0000 0000000200000002 ........ | |
------------------------------------------------------- | |
Statement<2>DSQL_drop | |
140177644566272 --> 9 op_response | |
handle< ffffffff >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
140177644566272 <-- 30 op_commit | |
------------------------------------------------------- | |
0000 00000001 .... | |
------------------------------------------------------- | |
Trans<1> | |
140177644566272 --> 9 op_response | |
handle< 00000000 >id< 0000000000000000 >Data len=0 | |
------------------------------------------------------- | |
------------------------------------------------------- | |
Status vector[ 000000010000000000000000 ] | |
[............] | |
isc_arg_gds 0 isc_arg_end | |
Unhandled exception in thread started by <function process_wire at 0x7f7da8dbe5f0> | |
Traceback (most recent call last): | |
File "fbproxy.py", line 2115, in process_wire | |
op_req_code = unpacker.unpack_int() | |
File "/usr/lib/python2.7/xdrlib.py", line 158, in unpack_int | |
raise EOFError | |
EOFError |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment