Skip to content

Instantly share code, notes, and snippets.

@mariuz
Created November 10, 2014 12:35
Show Gist options
  • Save mariuz/2b4ab646092e907f2791 to your computer and use it in GitHub Desktop.
Save mariuz/2b4ab646092e907f2791 to your computer and use it in GitHub Desktop.
fbproxy.py log when running node-firebird test run.js
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