freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Problem with FreeTDS 0.91 and Sybase ASA 9
- From: Michael Koch <michael AT michsoft.de>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Problem with FreeTDS 0.91 and Sybase ASA 9
- Date: Mon, 15 Dec 2014 18:59:23 +0100
Hello List,
in addition to my last post I have made much more tests. At least under Gentoo with FreeTDS 0.91 und unixODBX 2.3.2-r1 I could confirm my problems with SQLPrepare.
I turned on trace logging for FreeTDS and unixODBC and take isql todo a simple SELECT-Query. isql tries to build the query with SQLPrepare and the Sybase ASA9 gives a error value back, that the procedur that it tries to create is already existing.
I've made the following log files. I hope anyone has an ideas?
Thanks in advance! Best regards
Michael
---------------------------------------------------------------------------------------------------------------------------------------------------------
[ODBC][27626][1418664265.425550][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/__handles.c][460]
Exit:[SQL_SUCCESS]
Environment = 0x60d830
[ODBC][27626][1418664265.425623][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x60d830
[ODBC][27626][1418664265.425664][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x60e130
[ODBC][27626][1418664265.425708][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][3727]
Entry:
Connection = 0x60e130
Server Name = [TTT][length = 3 (SQL_NTS)]
User Name = [dba][length = 3 (SQL_NTS)]
Authentication = [*********][length = 9 (SQL_NTS)]
UNICODE Using encoding ASCII 'UTF8' and UNICODE 'UTF16LE'
[ODBC][27626][1418664265.555692][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][4305]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664265.555758][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLGetFunctions.c][151]
Entry:
Connection = 0x60e130
Id = SQLMoreResults
Supported = 0x607210
[ODBC][27626][1418664265.555798][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLGetFunctions.c][186]
Exit:[SQL_SUCCESS]
Supported = 0x607210 -> 1
[ODBC][27626][1418664285.390773][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x60e130
[ODBC][27626][1418664285.391278][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][1081]
Exit:[SQL_SUCCESS]
Output Handle = 0x666f40
[ODBC][27626][1418664285.391351][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][196]
Entry:
Statement = 0x666f40
SQL = [SELECT * FROM michaelstest;][length = 27]
[ODBC][27626][1418664285.425662][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][371]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664285.425869][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][187]
Entry:
Statement = 0x666f40
[ODBC][27626][1418664285.461657][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][348]
Exit:[SQL_ERROR]
DIAG [52010] [FreeTDS][SQL Server]ASA Fehler -110: Element 'emub506000' ist bereits vorhanden
[ODBC][27626][1418664285.467520][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeStmt.c][144]
Entry:
Statement = 0x666f40
Option = 1
[ODBC][27626][1418664285.467571][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x666f40
[ODBC][27626][1418664285.500579][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664294.782804][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x60e130
[ODBC][27626][1418664294.783007][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][1081]
Exit:[SQL_SUCCESS]
Output Handle = 0x666f40
[ODBC][27626][1418664294.783051][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][196]
Entry:
Statement = 0x666f40
SQL = [SELECT MdNummer FROM michaelstest;][length = 34]
[ODBC][27626][1418664294.817761][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][371]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664294.817949][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][187]
Entry:
Statement = 0x666f40
[ODBC][27626][1418664294.850989][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][348]
Exit:[SQL_ERROR]
DIAG [52010] [FreeTDS][SQL Server]ASA Fehler -110: Element 'emub509000' ist bereits vorhanden
[ODBC][27626][1418664294.857425][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeStmt.c][144]
Entry:
Statement = 0x666f40
Option = 1
[ODBC][27626][1418664294.857513][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x666f40
[ODBC][27626][1418664294.901716][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664302.446326][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x60e130
[ODBC][27626][1418664302.446567][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][1081]
Exit:[SQL_SUCCESS]
Output Handle = 0x666f40
[ODBC][27626][1418664302.446616][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][196]
Entry:
Statement = 0x666f40
SQL = [SELECT MdNummer FROM dba.michaelstest;][length = 38]
[ODBC][27626][1418664302.480416][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLPrepare.c][371]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664302.480601][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][187]
Entry:
Statement = 0x666f40
[ODBC][27626][1418664302.517267][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLExecute.c][348]
Exit:[SQL_ERROR]
DIAG [52010] [FreeTDS][SQL Server]ASA Fehler -110: Element 'emub50c000' ist bereits vorhanden
[ODBC][27626][1418664302.523983][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeStmt.c][144]
Entry:
Statement = 0x666f40
Option = 1
[ODBC][27626][1418664302.524032][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x666f40
[ODBC][27626][1418664302.568442][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664304.734147][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLDisconnect.c][208]
Entry:
Connection = 0x60e130
[ODBC][27626][1418664304.734453][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLDisconnect.c][364]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664304.734536][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x60e130
[ODBC][27626][1418664304.734576][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][27626][1418664304.734614][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][219]
Entry:
Handle Type = 1
Input Handle = 0x60d830
---------------------------------------------------------------------------------------------------------------------------------------------------------
18:24:25.518958 27626 (net.c:609):Received packet
0000 04 01 00 59 00 00 00 00-e3 07 00 03 04 75 74 66 |...Y.... .....utf|
0010 38 00 ad 22 00 05 05 00-00 00 18 41 64 61 70 74 |8..".... ...Adapt|
0020 69 76 65 20 53 65 72 76-65 72 20 41 6e 79 77 68 |ive Serv er Anywh|
0030 65 72 65 09 00 00 00 e2-16 00 01 09 00 00 0e 61 |ere..... .......a|
0040 01 ff ff fe e6 02 09 01-fe 7f fe e6 68 00 00 0a |........ ....h...|
0050 fd 00 00 01 00 00 00 00-00 |........ .|
18:24:25.519008 27626 (token.c:337):looking for login token, got e3(ENVCHANGE)
18:24:25.519027 27626 (token.c:122):tds_process_default_tokens() marker is e3(ENVCHANGE)
18:24:25.519048 27626 (token.c:2493):server indicated charset change to "utf8"
18:24:25.519069 27626 (iconv.c:988):setting server single-byte charset to "UTF-8"
18:24:25.519083 27626 (token.c:337):looking for login token, got ad(LOGINACK)
18:24:25.519134 27626 (token.c:373):server reports TDS version 5.0.0.0
18:24:25.519147 27626 (token.c:375):Product name for 0x5000000 is unknown
18:24:25.519161 27626 (token.c:337):looking for login token, got e2(CAPABILITY)
18:24:25.519173 27626 (token.c:122):tds_process_default_tokens() marker is e2(CAPABILITY)
18:24:25.519186 27626 (token.c:337):looking for login token, got fd(DONE)
18:24:25.519198 27626 (token.c:122):tds_process_default_tokens() marker is fd(DONE)
18:24:25.519213 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:25.519227 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:25.519239 27626 (token.c:2370): rows_affected = 0
18:24:25.519251 27626 (token.c:438):tds_process_login_tokens() returning TDS_SUCCEED
18:24:25.519269 27626 (mem.c:615):tds_free_all_results()
18:24:25.519284 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:25.519298 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:25.519310 27626 (net.c:741):Sending packet
0000 0f 01 00 21 00 00 00 00-21 14 00 00 00 00 73 65 |...!.... !.....se|
0010 74 20 74 65 78 74 73 69-7a 65 20 36 34 35 31 32 |t textsi ze 64512|
0020 20 - | |
18:24:25.519476 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488b9148, 0x7fff488b914c, 0x100)
18:24:25.519505 27626 (util.c:156):Changed query state from PENDING to READING
18:24:25.555428 27626 (net.c:555):Received header
0000 04 01 00 11 00 00 00 00- |........|
18:24:25.555477 27626 (net.c:609):Received packet
0000 04 01 00 11 00 00 00 00-fd 00 00 01 00 00 00 00 |........ ........|
0010 00 - |.|
18:24:25.555498 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:25.555512 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:25.555525 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:25.555566 27626 (util.c:156):Changed query state from READING to IDLE
18:24:25.555580 27626 (token.c:2370): rows_affected = 0
18:24:25.555592 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:25.555605 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488b9148, 0x7fff488b914c, 0x100)
18:24:25.555617 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:24:25.555639 27626 (odbc.c:4916):SQLGetFunctions: fFunction is 999
18:24:45.390848 27626 (odbc.c:1716):SQLAllocStmt(0x628ff0, 0x667360)
18:24:45.390879 27626 (odbc.c:1615):_SQLAllocStmt(0x628ff0, 0x667360)
18:24:45.390902 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10010, 0x7fff488ba6f8, 8, (nil))
18:24:45.390922 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10011, 0x7fff488ba6f8, 8, (nil))
18:24:45.390941 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10012, 0x7fff488ba6f8, 8, (nil))
18:24:45.390955 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10013, 0x7fff488ba6f8, 8, (nil))
18:24:45.391382 27626 (odbc.c:4445):SQLPrepare(0x650aa0, SELECT * FROM michaelstest;, 27)
18:24:45.391410 27626 (odbc.c:4490):Creating prepared statement
18:24:45.391429 27626 (mem.c:615):tds_free_all_results()
18:24:45.391443 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:45.391458 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:45.391471 27626 (net.c:741):Sending packet
0000 0f 01 00 4f 00 00 00 00-e7 44 00 01 00 0a 65 6d |...O.... .D....em|
0010 75 62 35 30 36 30 30 30-35 00 63 72 65 61 74 65 |ub506000 5.create|
0020 20 70 72 6f 63 20 65 6d-75 62 35 30 36 30 30 30 | proc em ub506000|
0030 20 61 73 20 53 45 4c 45-43 54 20 2a 20 46 52 4f | as SELE CT * FRO|
0040 4d 20 6d 69 63 68 61 65-6c 73 74 65 73 74 3b |M michae lstest;|
18:24:45.391622 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:24:45.391645 27626 (util.c:156):Changed query state from PENDING to READING
18:24:45.425306 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:24:45.425366 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 36 30 30 30-fd 00 00 01 00 00 00 00 |ub506000 ........|
0020 00 - |.|
18:24:45.425401 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:45.425424 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:45.425443 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:45.425462 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:45.425480 27626 (util.c:156):Changed query state from READING to IDLE
18:24:45.425497 27626 (token.c:2370): rows_affected = 0
18:24:45.425542 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:45.425576 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:24:45.425619 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:24:45.425903 27626 (odbc.c:3496):SQLExecute(0x650aa0)
18:24:45.425923 27626 (prepare_query.c:203):parsing 0 parameters
18:24:45.425940 27626 (odbc.c:3211):_SQLExecute(0x650aa0)
18:24:45.425953 27626 (odbc.c:3216):_SQLExecute() starting with state 0
18:24:45.425966 27626 (odbc.c:3334):End prepare, execute
18:24:45.425978 27626 (query.c:1818):tds_submit_execute()
18:24:45.425990 27626 (mem.c:615):tds_free_all_results()
18:24:45.426002 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:45.426015 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:45.426027 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 02 00 0a 65 6d |........ ......em|
0010 75 62 35 30 36 30 30 30-00 00 |ub506000 ..|
18:24:45.426210 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x6914)
18:24:45.426239 27626 (util.c:156):Changed query state from PENDING to READING
18:24:45.461263 27626 (net.c:555):Received header
0000 04 01 00 74 00 00 00 00- |...t....|
18:24:45.461313 27626 (net.c:609):Received packet
0000 04 01 00 74 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...t.... ... ..em|
0010 75 62 35 30 36 30 30 30-e5 50 00 e6 2e 00 00 00 |ub506000 .P......|
0020 10 05 35 32 30 31 30 00-01 00 3b 00 41 53 41 20 |..52010. ..;.ASA |
0030 46 65 68 6c 65 72 20 2d-31 31 30 3a 20 45 6c 65 |Fehler - 110: Ele|
0040 6d 65 6e 74 20 27 65 6d-75 62 35 30 36 30 30 30 |ment 'em ub506000|
0050 27 20 69 73 74 20 62 65-72 65 69 74 73 20 76 6f |' ist be reits vo|
0060 72 68 61 6e 64 65 6e 00-00 00 00 fd 02 00 01 00 |rhanden. ........|
0070 00 00 00 00 - |....|
18:24:45.461365 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:45.461382 27626 (token.c:2588):tds_process_msg() reading message 12006 from server
18:24:45.461396 27626 (token.c:2661):tds_process_msg() calling client msg handler
18:24:45.461421 27626 (odbc.c:2270):msgno 12006 20003
18:24:45.461450 27626 (token.c:2674):tds_process_msg() returning TDS_SUCCEED
18:24:45.461494 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:45.461508 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
18:24:45.461521 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:45.461533 27626 (util.c:156):Changed query state from READING to IDLE
18:24:45.461545 27626 (token.c:2370): rows_affected = 0
18:24:45.461558 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:45.461570 27626 (odbc.c:3534):odbc_process_tokens: tds_process_tokens returned 1
18:24:45.461582 27626 (odbc.c:3535): result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=2
18:24:45.461595 27626 (odbc.c:3575):odbc_process_tokens: row_count=-1
18:24:45.461607 27626 (odbc.c:3374):_SQLExecute: odbc_process_tokens returned result_type 4052
18:24:45.461623 27626 (odbc.c:3519):SQLExecute returns SQL_ERROR
18:24:45.461694 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 1, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:24:45.461728 27626 (error.c:566):SQLGetDiagRec: "[FreeTDS][SQL Server]ASA Fehler -110: Element 'emub506000' ist bereits vorhanden"
18:24:45.461793 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 2, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:24:45.467599 27626 (odbc.c:3980):SQLFreeHandle(3, 0x650aa0)
18:24:45.467620 27626 (odbc.c:4075):_SQLFreeStmt(0x650aa0, 1, 0)
18:24:45.467633 27626 (query.c:1935):tds_submit_unprepare() emub506000
18:24:45.467646 27626 (mem.c:615):tds_free_all_results()
18:24:45.467658 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:45.467671 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:45.467683 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 04 00 0a 65 6d |........ ......em|
0010 75 62 35 30 36 30 30 30-00 00 |ub506000 ..|
18:24:45.467839 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:24:45.467869 27626 (util.c:156):Changed query state from PENDING to READING
18:24:45.500245 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:24:45.500311 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 36 30 30 30-fd 00 00 01 00 00 00 00 |ub506000 ........|
0020 00 - |.|
18:24:45.500349 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:45.500373 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:45.500394 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:45.500414 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:45.500432 27626 (util.c:156):Changed query state from READING to IDLE
18:24:45.500450 27626 (token.c:2370): rows_affected = 0
18:24:45.500468 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:45.500485 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:24:45.500502 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:24:54.782885 27626 (odbc.c:1716):SQLAllocStmt(0x628ff0, 0x667360)
18:24:54.782915 27626 (odbc.c:1615):_SQLAllocStmt(0x628ff0, 0x667360)
18:24:54.782933 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10010, 0x7fff488ba6f8, 8, (nil))
18:24:54.782949 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10011, 0x7fff488ba6f8, 8, (nil))
18:24:54.782963 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10012, 0x7fff488ba6f8, 8, (nil))
18:24:54.782976 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10013, 0x7fff488ba6f8, 8, (nil))
18:24:54.783078 27626 (odbc.c:4445):SQLPrepare(0x650aa0, SELECT MdNummer FROM michaelstest;, 34)
18:24:54.783099 27626 (odbc.c:4490):Creating prepared statement
18:24:54.783128 27626 (mem.c:615):tds_free_all_results()
18:24:54.783141 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:54.783155 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:54.783167 27626 (net.c:741):Sending packet
0000 0f 01 00 56 00 00 00 00-e7 4b 00 01 00 0a 65 6d |...V.... .K....em|
0010 75 62 35 30 39 30 30 30-3c 00 63 72 65 61 74 65 |ub509000 <.create|
0020 20 70 72 6f 63 20 65 6d-75 62 35 30 39 30 30 30 | proc em ub509000|
0030 20 61 73 20 53 45 4c 45-43 54 20 4d 64 4e 75 6d | as SELE CT MdNum|
0040 6d 65 72 20 46 52 4f 4d-20 6d 69 63 68 61 65 6c |mer FROM michael|
0050 73 74 65 73 74 3b - |stest;|
18:24:54.783280 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:24:54.783301 27626 (util.c:156):Changed query state from PENDING to READING
18:24:54.817466 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:24:54.817521 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 39 30 30 30-fd 00 00 01 00 00 00 00 |ub509000 ........|
0020 00 - |.|
18:24:54.817549 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:54.817566 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:54.817579 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:54.817592 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:54.817604 27626 (util.c:156):Changed query state from READING to IDLE
18:24:54.817617 27626 (token.c:2370): rows_affected = 0
18:24:54.817629 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:54.817642 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:24:54.817655 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:24:54.817984 27626 (odbc.c:3496):SQLExecute(0x650aa0)
18:24:54.818005 27626 (prepare_query.c:203):parsing 0 parameters
18:24:54.818018 27626 (odbc.c:3211):_SQLExecute(0x650aa0)
18:24:54.818030 27626 (odbc.c:3216):_SQLExecute() starting with state 0
18:24:54.818042 27626 (odbc.c:3334):End prepare, execute
18:24:54.818055 27626 (query.c:1818):tds_submit_execute()
18:24:54.818067 27626 (mem.c:615):tds_free_all_results()
18:24:54.818079 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:54.818092 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:54.818104 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 02 00 0a 65 6d |........ ......em|
0010 75 62 35 30 39 30 30 30-00 00 |ub509000 ..|
18:24:54.818256 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x6914)
18:24:54.818285 27626 (util.c:156):Changed query state from PENDING to READING
18:24:54.850534 27626 (net.c:555):Received header
0000 04 01 00 74 00 00 00 00- |...t....|
18:24:54.850577 27626 (net.c:609):Received packet
0000 04 01 00 74 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...t.... ... ..em|
0010 75 62 35 30 39 30 30 30-e5 50 00 e6 2e 00 00 00 |ub509000 .P......|
0020 10 05 35 32 30 31 30 00-01 00 3b 00 41 53 41 20 |..52010. ..;.ASA |
0030 46 65 68 6c 65 72 20 2d-31 31 30 3a 20 45 6c 65 |Fehler - 110: Ele|
0040 6d 65 6e 74 20 27 65 6d-75 62 35 30 39 30 30 30 |ment 'em ub509000|
0050 27 20 69 73 74 20 62 65-72 65 69 74 73 20 76 6f |' ist be reits vo|
0060 72 68 61 6e 64 65 6e 00-00 00 00 fd 02 00 01 00 |rhanden. ........|
0070 00 00 00 00 - |....|
18:24:54.850627 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:54.850644 27626 (token.c:2588):tds_process_msg() reading message 12006 from server
18:24:54.850659 27626 (token.c:2661):tds_process_msg() calling client msg handler
18:24:54.850672 27626 (odbc.c:2270):msgno 12006 20003
18:24:54.850689 27626 (token.c:2674):tds_process_msg() returning TDS_SUCCEED
18:24:54.850716 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:54.850729 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
18:24:54.850742 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:54.850754 27626 (util.c:156):Changed query state from READING to IDLE
18:24:54.850766 27626 (token.c:2370): rows_affected = 0
18:24:54.850769 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:54.850812 27626 (odbc.c:3534):odbc_process_tokens: tds_process_tokens returned 1
18:24:54.850825 27626 (odbc.c:3535): result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=2
18:24:54.850838 27626 (odbc.c:3575):odbc_process_tokens: row_count=-1
18:24:54.850851 27626 (odbc.c:3374):_SQLExecute: odbc_process_tokens returned result_type 4052
18:24:54.850864 27626 (odbc.c:3519):SQLExecute returns SQL_ERROR
18:24:54.851125 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 1, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:24:54.851159 27626 (error.c:566):SQLGetDiagRec: "[FreeTDS][SQL Server]ASA Fehler -110: Element 'emub509000' ist bereits vorhanden"
18:24:54.851220 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 2, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:24:54.857553 27626 (odbc.c:3980):SQLFreeHandle(3, 0x650aa0)
18:24:54.857574 27626 (odbc.c:4075):_SQLFreeStmt(0x650aa0, 1, 0)
18:24:54.857588 27626 (query.c:1935):tds_submit_unprepare() emub509000
18:24:54.857601 27626 (mem.c:615):tds_free_all_results()
18:24:54.857613 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:24:54.857626 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:24:54.857638 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 04 00 0a 65 6d |........ ......em|
0010 75 62 35 30 39 30 30 30-00 00 |ub509000 ..|
18:24:54.857794 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:24:54.857823 27626 (util.c:156):Changed query state from PENDING to READING
18:24:54.901500 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:24:54.901548 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 39 30 30 30-fd 00 00 01 00 00 00 00 |ub509000 ........|
0020 00 - |.|
18:24:54.901575 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:24:54.901590 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:24:54.901603 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:24:54.901616 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:24:54.901627 27626 (util.c:156):Changed query state from READING to IDLE
18:24:54.901640 27626 (token.c:2370): rows_affected = 0
18:24:54.901652 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:24:54.901664 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:24:54.901677 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:25:02.446402 27626 (odbc.c:1716):SQLAllocStmt(0x628ff0, 0x667360)
18:25:02.446436 27626 (odbc.c:1615):_SQLAllocStmt(0x628ff0, 0x667360)
18:25:02.446455 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10010, 0x7fff488ba6f8, 8, (nil))
18:25:02.446503 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10011, 0x7fff488ba6f8, 8, (nil))
18:25:02.446522 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10012, 0x7fff488ba6f8, 8, (nil))
18:25:02.446536 27626 (odbc.c:4388):SQLGetStmtAttr(0x650aa0, 10013, 0x7fff488ba6f8, 8, (nil))
18:25:02.446647 27626 (odbc.c:4445):SQLPrepare(0x650aa0, SELECT MdNummer FROM dba.michaelstest;, 38)
18:25:02.446669 27626 (odbc.c:4490):Creating prepared statement
18:25:02.446685 27626 (mem.c:615):tds_free_all_results()
18:25:02.446698 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:25:02.446729 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:25:02.446743 27626 (net.c:741):Sending packet
0000 0f 01 00 5a 00 00 00 00-e7 4f 00 01 00 0a 65 6d |...Z.... .O....em|
0010 75 62 35 30 63 30 30 30-40 00 63 72 65 61 74 65 |ub50c000 @.create|
0020 20 70 72 6f 63 20 65 6d-75 62 35 30 63 30 30 30 | proc em ub50c000|
0030 20 61 73 20 53 45 4c 45-43 54 20 4d 64 4e 75 6d | as SELE CT MdNum|
0040 6d 65 72 20 46 52 4f 4d-20 64 62 61 2e 6d 69 63 |mer FROM dba.mic|
0050 68 61 65 6c 73 74 65 73-74 3b |haelstes t;|
18:25:02.446893 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:25:02.446923 27626 (util.c:156):Changed query state from PENDING to READING
18:25:02.480110 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:25:02.480162 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 63 30 30 30-fd 00 00 01 00 00 00 00 |ub50c000 ........|
0020 00 - |.|
18:25:02.480190 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:25:02.480206 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:25:02.480219 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:25:02.480232 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:25:02.480244 27626 (util.c:156):Changed query state from READING to IDLE
18:25:02.480257 27626 (token.c:2370): rows_affected = 0
18:25:02.480302 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:25:02.480348 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba668, 0x7fff488ba66c, 0x104)
18:25:02.480368 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:25:02.480636 27626 (odbc.c:3496):SQLExecute(0x650aa0)
18:25:02.480656 27626 (prepare_query.c:203):parsing 0 parameters
18:25:02.480669 27626 (odbc.c:3211):_SQLExecute(0x650aa0)
18:25:02.480681 27626 (odbc.c:3216):_SQLExecute() starting with state 0
18:25:02.480693 27626 (odbc.c:3334):End prepare, execute
18:25:02.480706 27626 (query.c:1818):tds_submit_execute()
18:25:02.480718 27626 (mem.c:615):tds_free_all_results()
18:25:02.480730 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:25:02.480743 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:25:02.480755 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 02 00 0a 65 6d |........ ......em|
0010 75 62 35 30 63 30 30 30-00 00 |ub50c000 ..|
18:25:02.480948 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x6914)
18:25:02.480977 27626 (util.c:156):Changed query state from PENDING to READING
18:25:02.516938 27626 (net.c:555):Received header
0000 04 01 00 74 00 00 00 00- |...t....|
18:25:02.516979 27626 (net.c:609):Received packet
0000 04 01 00 74 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...t.... ... ..em|
0010 75 62 35 30 63 30 30 30-e5 50 00 e6 2e 00 00 00 |ub50c000 .P......|
0020 10 05 35 32 30 31 30 00-01 00 3b 00 41 53 41 20 |..52010. ..;.ASA |
0030 46 65 68 6c 65 72 20 2d-31 31 30 3a 20 45 6c 65 |Fehler - 110: Ele|
0040 6d 65 6e 74 20 27 65 6d-75 62 35 30 63 30 30 30 |ment 'em ub50c000|
0050 27 20 69 73 74 20 62 65-72 65 69 74 73 20 76 6f |' ist be reits vo|
0060 72 68 61 6e 64 65 6e 00-00 00 00 fd 02 00 01 00 |rhanden. ........|
0070 00 00 00 00 - |....|
18:25:02.517028 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:25:02.517044 27626 (token.c:2588):tds_process_msg() reading message 12006 from server
18:25:02.517059 27626 (token.c:2661):tds_process_msg() calling client msg handler
18:25:02.517071 27626 (odbc.c:2270):msgno 12006 20003
18:25:02.517089 27626 (token.c:2674):tds_process_msg() returning TDS_SUCCEED
18:25:02.517101 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:25:02.517126 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
18:25:02.517140 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:25:02.517152 27626 (util.c:156):Changed query state from READING to IDLE
18:25:02.517164 27626 (token.c:2370): rows_affected = 0
18:25:02.517176 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:25:02.517188 27626 (odbc.c:3534):odbc_process_tokens: tds_process_tokens returned 1
18:25:02.517200 27626 (odbc.c:3535): result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=2
18:25:02.517212 27626 (odbc.c:3575):odbc_process_tokens: row_count=-1
18:25:02.517224 27626 (odbc.c:3374):_SQLExecute: odbc_process_tokens returned result_type 4052
18:25:02.517237 27626 (odbc.c:3519):SQLExecute returns SQL_ERROR
18:25:02.517336 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 1, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:25:02.517360 27626 (error.c:566):SQLGetDiagRec: "[FreeTDS][SQL Server]ASA Fehler -110: Element 'emub50c000' ist bereits vorhanden"
18:25:02.517415 27626 (error.c:517):SQLGetDiagRec(3, 0x650aa0, 2, 0x7fff488ba220, 0x7fff488ba214, 0x7fff488ba230, 512, 0x7fff488ba218)
18:25:02.524060 27626 (odbc.c:3980):SQLFreeHandle(3, 0x650aa0)
18:25:02.524082 27626 (odbc.c:4075):_SQLFreeStmt(0x650aa0, 1, 0)
18:25:02.524095 27626 (query.c:1935):tds_submit_unprepare() emub50c000
18:25:02.524108 27626 (mem.c:615):tds_free_all_results()
18:25:02.524120 27626 (util.c:156):Changed query state from IDLE to QUERYING
18:25:02.524133 27626 (util.c:156):Changed query state from QUERYING to PENDING
18:25:02.524145 27626 (net.c:741):Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 04 00 0a 65 6d |........ ......em|
0010 75 62 35 30 63 30 30 30-00 00 |ub50c000 ..|
18:25:02.524292 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:25:02.524322 27626 (util.c:156):Changed query state from PENDING to READING
18:25:02.568188 27626 (net.c:555):Received header
0000 04 01 00 21 00 00 00 00- |...!....|
18:25:02.568240 27626 (net.c:609):Received packet
0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 65 6d |...!.... ... ..em|
0010 75 62 35 30 63 30 30 30-fd 00 00 01 00 00 00 00 |ub50c000 ........|
0020 00 - |.|
18:25:02.568266 27626 (token.c:555):processing result tokens. marker is e7(TDS5_DYNAMIC)
18:25:02.568311 27626 (token.c:555):processing result tokens. marker is fd(DONE)
18:25:02.568326 27626 (token.c:2339):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
18:25:02.568339 27626 (token.c:2355):tds_process_end() state set to TDS_IDLE
18:25:02.568351 27626 (util.c:156):Changed query state from READING to IDLE
18:25:02.568364 27626 (token.c:2370): rows_affected = 0
18:25:02.568376 27626 (util.c:104):logic error: cannot change query state from IDLE to PENDING
18:25:02.568388 27626 (token.c:540):tds_process_tokens(0x62a450, 0x7fff488ba5d8, 0x7fff488ba5dc, 0x100)
18:25:02.568401 27626 (token.c:543):tds_process_tokens() state is COMPLETED
18:25:04.734217 27626 (odbc.c:2240):SQLDisconnect(0x628ff0)
18:25:04.734247 27626 (mem.c:615):tds_free_all_results()
18:25:04.734343 27626 (util.c:156):Changed query state from IDLE to DEAD
18:25:04.734371 27626 (odbc.c:4040):SQLFreeConnect(0x628ff0)
18:25:04.734385 27626 (odbc.c:4006):_SQLFreeConnect(0x628ff0)
18:25:04.734400 27626 (odbc.c:4063):SQLFreeEnv(0x625470)
18:25:04.734413 27626 (odbc.c:4050):_SQLFreeEnv(0x625470)
- [freetds] Problem with FreeTDS 0.91 and Sybase ASA 9, Michael Koch, 12/15/2014
Archive powered by MHonArc 2.6.24.