 | |
Sybase DB connect issue - Unresolved from 2005
sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Sybase DB connect issue - Unresolved from 2005 -
04-06-2006
, 03:22 PM
|
16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it |
Dave Foulkes <dave.foulkes (AT) NO (DOT) SPAM.tesco.net>
Date: 5 Jul 2005 08:06:11 -0700
Newsgroups: sybase.public.sqlanywhere.general
Message ID: <42caa1e3@forums-1-dub>
References: <42c95463$1@forums-2-dub> <42ca914e$1@forums-1-dub>
Subject: Re: Communication error/problem
Thank you for your response - your analysis is spot on. I've just
discovered
that an external function called by the login procedure is silently killing
the server - no error message, nothing. Quite why this is happening I have
no idea - yet. I'll report back when I know more.
Dave.
D:\Test.txt contains the following:-
I. 07/05 15:57:07. Adaptive Server Anywhere Database Engine Version
9.0.2.3137
I. 07/05 15:57:07.
I. 07/05 15:57:07. Copyright © 1989-2004 Sybase, Inc.
I. 07/05 15:57:07. Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 07/05 15:57:07. All rights reserved. All unpublished rights reserved.
I. 07/05 15:57:07.
I. 07/05 15:57:07. This software contains confidential and trade secret
information of
I. 07/05 15:57:07. iAnywhere Solutions, Inc.
I. 07/05 15:57:07. Use, duplication or disclosure of the software and
documentation
I. 07/05 15:57:07. by the U.S. Government is subject to restrictions set
forth in a license
I. 07/05 15:57:07. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 07/05 15:57:07. other written agreement specifying the Government's
rights to use the
I. 07/05 15:57:07. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 07/05 15:57:07.
I. 07/05 15:57:07. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 07/05 15:57:07. Adaptive Server Anywhere Developer Edition
I. 07/05 15:57:07.
I. 07/05 15:57:07. 1 physical processor(s) detected.
I. 07/05 15:57:07. Running on Windows XP Build 2600 Service Pack 2
I. 07/05 15:57:07. Note: A cache size of 262144K exceeds the available
physical memory of 197908K. A performance penalty may result.
I. 07/05 15:57:07. 262144K of memory used for caching
I. 07/05 15:57:07. Minimum cache size: 262144K, maximum cache size: 262144K
I. 07/05 15:57:07. Using a maximum page size of 4096 bytes
I. 07/05 15:57:07. Database server started at Tue Jul 05 2005 15:57
I. 07/05 15:57:07. Trying to start SharedMemory link ...
I. 07/05 15:57:07. SharedMemory link started successfully
I. 07/05 15:57:07. Now accepting requests
I. 07/05 15:57:08. Starting database "Test" (D:\Test.db) at Tue Jul 05 2005
15:57
I. 07/05 15:57:08. Database recovery in progress
I. 07/05 15:57:08. Last checkpoint at Tue Jul 05 2005 15:54
I. 07/05 15:57:08. Checkpoint log...
I. 07/05 15:57:08. Performance warning: Database file "D:\Test.db" consists
of 30 disk fragments
I. 07/05 15:57:08. Transaction log: Test.log...
I. 07/05 15:57:08. Rollback log...
I. 07/05 15:57:08. Checkpointing...
I. 07/05 15:57:08. Starting checkpoint of "Test" (Test.db) at Tue Jul 05
2005 15:57
I. 07/05 15:57:08. Finished checkpoint of "Test" (Test.db) at Tue Jul 05
2005 15:57
I. 07/05 15:57:08. Recovery complete
I. 07/05 15:57:08. Database "Test" (Test.db) started at Tue Jul 05 2005
15:57
----- Original Message -----
From: "Ian McHardy" <mchardy_no (AT) spam_ianywhere (DOT) com>
Newsgroups: sybase.public.sqlanywhere.general
Sent: Tuesday, July 05, 2005 2:55 PM
Subject: Re: Communication error/problem
Quote:
|
The "Communication function ..." lines are a result of the "Disconnecting shared memory client, process id not found" It appears that the client has found the server, connected to the server (but not the database yet), and then the server stopped running while the client was attempting to connect to the database. I don't see anything obvious wrong in your connection string or start line. What does d:\test.txt have in it? -- Ian McHardy (iAnywhere Solutions) Please reply only to the newsgroup. Whitepapers, TechDocs, bug fixes are all available through the iAnywhere Developer Community at http://www.ianywhere.com/developer "Dave Foulkes" <dave.foulkes (AT) NO (DOT) SPAM.tesco.net> wrote in message news:42c95463$1 (AT) forums-2-dub (DOT) .. I'm attempting to connect to a database created with ASA 9.0.2.3137 using dbisqlc, but failing. From the error log (below) I suspect that there's a clue in this snippet:- 16:18:32 Disconnecting shared memory client, process id not found 16:18:32 Communication function i_cs_HandleSQLPresError code 6 16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it Does anyone have any suggestions as to what I may be doing wrong? Many thanks, Dave. Mon Jul 04 2005 16:18:31 16:18:31 Application information: 16:18:31 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:31 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:31 Attempting to connect to a running server... 16:18:31 Trying to start SharedMemory link ... 16:18:31 SharedMemory link started successfully 16:18:31 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:31 Failed to connect over SharedMemory 16:18:31 No server found, attempting to run START line... 16:18:31 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:31 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:31 Connected to server over SharedMemory 16:18:31 Connected to ASA Engine version 9.0.2.3137 16:18:31 Connected to the server, attempting to connect to a running database... 16:18:32 Disconnecting shared memory client, process id not found 16:18:32 Communication function i_cs_HandleSQLPresError code 6 16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it 16:18:32 Application information: 16:18:32 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:32 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:32 Attempting to connect to a running server... 16:18:32 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:32 Failed to connect over SharedMemory 16:18:32 No server found, attempting to run START line... 16:18:32 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:32 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:32 Connected to server over SharedMemory 16:18:32 Connected to ASA Engine version 9.0.2.3137 16:18:32 Connected to the server, attempting to connect to a running database... 16:18:33 Disconnecting shared memory client, process id not found 16:18:33 Communication function i_cs_HandleSQLPresError code 6 16:18:33 Communication function StrmGetInd code 8 16:18:33 Database is running, but could not connect to it 16:18:33 Application information: 16:18:33 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:33 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:33 Attempting to connect to a running server... 16:18:33 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:33 Failed to connect over SharedMemory 16:18:33 No server found, attempting to run START line... 16:18:34 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:34 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:34 Connected to server over SharedMemory 16:18:34 Connected to ASA Engine version 9.0.2.3137 16:18:34 Connected to the server, attempting to connect to a running database... 16:18:35 Disconnecting shared memory client, process id not found 16:18:35 Communication function i_cs_HandleSQLPresError code 6 16:18:35 Communication function StrmGetInd code 8 16:18:35 Database is running, but could not connect to it |
#2
| |||
| |||
|
|
anyone know if there was an outcome from the following communication error/problem reported in July 2005: I am getting the same issue - specifically the lines 16:18:32 Communication function i_cs_HandleSQLPresError code 6 16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it Dave Foulkes <dave.foulkes (AT) NO (DOT) SPAM.tesco.net Date: 5 Jul 2005 08:06:11 -0700 Newsgroups: sybase.public.sqlanywhere.general Message ID: <42caa1e3@forums-1-dub References: <42c95463$1@forums-2-dub> <42ca914e$1@forums-1-dub Subject: Re: Communication error/problem Thank you for your response - your analysis is spot on. I've just discovered that an external function called by the login procedure is silently killing the server - no error message, nothing. Quite why this is happening I have no idea - yet. I'll report back when I know more. Dave. D:\Test.txt contains the following:- I. 07/05 15:57:07. Adaptive Server Anywhere Database Engine Version 9.0.2.3137 I. 07/05 15:57:07. I. 07/05 15:57:07. Copyright © 1989-2004 Sybase, Inc. I. 07/05 15:57:07. Portions Copyright © 2002-2004, iAnywhere Solutions, Inc. I. 07/05 15:57:07. All rights reserved. All unpublished rights reserved. I. 07/05 15:57:07. I. 07/05 15:57:07. This software contains confidential and trade secret information of I. 07/05 15:57:07. iAnywhere Solutions, Inc. I. 07/05 15:57:07. Use, duplication or disclosure of the software and documentation I. 07/05 15:57:07. by the U.S. Government is subject to restrictions set forth in a license I. 07/05 15:57:07. agreement between the Government and iAnywhere Solutions, Inc. or I. 07/05 15:57:07. other written agreement specifying the Government's rights to use the I. 07/05 15:57:07. software and any applicable FAR provisions, for example, FAR 52.227-19. I. 07/05 15:57:07. I. 07/05 15:57:07. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA I. 07/05 15:57:07. Adaptive Server Anywhere Developer Edition I. 07/05 15:57:07. I. 07/05 15:57:07. 1 physical processor(s) detected. I. 07/05 15:57:07. Running on Windows XP Build 2600 Service Pack 2 I. 07/05 15:57:07. Note: A cache size of 262144K exceeds the available physical memory of 197908K. A performance penalty may result. I. 07/05 15:57:07. 262144K of memory used for caching I. 07/05 15:57:07. Minimum cache size: 262144K, maximum cache size: 262144K I. 07/05 15:57:07. Using a maximum page size of 4096 bytes I. 07/05 15:57:07. Database server started at Tue Jul 05 2005 15:57 I. 07/05 15:57:07. Trying to start SharedMemory link ... I. 07/05 15:57:07. SharedMemory link started successfully I. 07/05 15:57:07. Now accepting requests I. 07/05 15:57:08. Starting database "Test" (D:\Test.db) at Tue Jul 05 2005 15:57 I. 07/05 15:57:08. Database recovery in progress I. 07/05 15:57:08. Last checkpoint at Tue Jul 05 2005 15:54 I. 07/05 15:57:08. Checkpoint log... I. 07/05 15:57:08. Performance warning: Database file "D:\Test.db" consists of 30 disk fragments I. 07/05 15:57:08. Transaction log: Test.log... I. 07/05 15:57:08. Rollback log... I. 07/05 15:57:08. Checkpointing... I. 07/05 15:57:08. Starting checkpoint of "Test" (Test.db) at Tue Jul 05 2005 15:57 I. 07/05 15:57:08. Finished checkpoint of "Test" (Test.db) at Tue Jul 05 2005 15:57 I. 07/05 15:57:08. Recovery complete I. 07/05 15:57:08. Database "Test" (Test.db) started at Tue Jul 05 2005 15:57 ----- Original Message ----- From: "Ian McHardy" <mchardy_no (AT) spam_ianywhere (DOT) com Newsgroups: sybase.public.sqlanywhere.general Sent: Tuesday, July 05, 2005 2:55 PM Subject: Re: Communication error/problem The "Communication function ..." lines are a result of the "Disconnecting shared memory client, process id not found" It appears that the client has found the server, connected to the server (but not the database yet), and then the server stopped running while the client was attempting to connect to the database. I don't see anything obvious wrong in your connection string or start line. What does d:\test.txt have in it? -- Ian McHardy (iAnywhere Solutions) Please reply only to the newsgroup. Whitepapers, TechDocs, bug fixes are all available through the iAnywhere Developer Community at http://www.ianywhere.com/developer "Dave Foulkes" <dave.foulkes (AT) NO (DOT) SPAM.tesco.net> wrote in message news:42c95463$1 (AT) forums-2-dub (DOT) .. I'm attempting to connect to a database created with ASA 9.0.2.3137 using dbisqlc, but failing. From the error log (below) I suspect that there's a clue in this snippet:- 16:18:32 Disconnecting shared memory client, process id not found 16:18:32 Communication function i_cs_HandleSQLPresError code 6 16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it Does anyone have any suggestions as to what I may be doing wrong? Many thanks, Dave. Mon Jul 04 2005 16:18:31 16:18:31 Application information: 16:18:31 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:31 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:31 Attempting to connect to a running server... 16:18:31 Trying to start SharedMemory link ... 16:18:31 SharedMemory link started successfully 16:18:31 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:31 Failed to connect over SharedMemory 16:18:31 No server found, attempting to run START line... 16:18:31 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:31 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:31 Connected to server over SharedMemory 16:18:31 Connected to ASA Engine version 9.0.2.3137 16:18:31 Connected to the server, attempting to connect to a running database... 16:18:32 Disconnecting shared memory client, process id not found 16:18:32 Communication function i_cs_HandleSQLPresError code 6 16:18:32 Communication function StrmGetInd code 8 16:18:32 Database is running, but could not connect to it 16:18:32 Application information: 16:18:32 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:32 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:32 Attempting to connect to a running server... 16:18:32 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:32 Failed to connect over SharedMemory 16:18:32 No server found, attempting to run START line... 16:18:32 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:32 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:32 Connected to server over SharedMemory 16:18:32 Connected to ASA Engine version 9.0.2.3137 16:18:32 Connected to the server, attempting to connect to a running database... 16:18:33 Disconnecting shared memory client, process id not found 16:18:33 Communication function i_cs_HandleSQLPresError code 6 16:18:33 Communication function StrmGetInd code 8 16:18:33 Database is running, but could not connect to it 16:18:33 Application information: 16:18:33 "HOST=C38R30J;OS=Windows XP Build 2600 Service Pack 2;PID=0x924;THREAD=0x7c0;EXE=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.2.3137;API=DBLIB;T IMEZONEADJUSTMENT=60;APPINFO=ISQL" 16:18:33 Attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:33 Attempting to connect to a running server... 16:18:33 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:33 Failed to connect over SharedMemory 16:18:33 No server found, attempting to run START line... 16:18:34 Autostarted server, attempting to connect using: UID=bpw;PWD=********;DBF=D:\Test.db;ENG=ASA9;START =dbeng9 -ca 0 -c 256m -gp 4096 -m -o D:\Test.txt -x none;CON=David;LOG=D:\Test.err;APP=ISQL 16:18:34 Attempting SharedMemory connection (no asasrv.ini cached address) 16:18:34 Connected to server over SharedMemory 16:18:34 Connected to ASA Engine version 9.0.2.3137 16:18:34 Connected to the server, attempting to connect to a running database... 16:18:35 Disconnecting shared memory client, process id not found 16:18:35 Communication function i_cs_HandleSQLPresError code 6 16:18:35 Communication function StrmGetInd code 8 16:18:35 Database is running, but could not connect to it |
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.