Unix Technical Forum

Page fault on connection

This is a discussion on Page fault on connection within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> I'm using Microsoft Visual FoxPro 9 SP1 in Windows 98 This problem occurs both in last stable release and ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 03:01 AM
Andrus
 
Posts: n/a
Default Page fault on connection

I'm using Microsoft Visual FoxPro 9 SP1 in Windows 98
This problem occurs both in last stable release and in development snapshot
of ODBC driver.

In one computer, VFP SQLSTRINGCONNECT() call

causes Windows error

MYAPP caused an invalid page fault in module KERNEL32.DLL at 0167:bff7a379

This occurs always in one Win 98 computer while connnecting to one server.
Connecting to other server using same exe in this computer works OK
This occurs if I supply wrong or bad password to server.

Driver log when error occurs (ip addresses changed)

[-1578905]globals.extra_systable_prefixes = 'dd_;'
[-1578905][[SQLAllocHandle]][-1578905]**** in PGAPI_AllocEnv **
[-1578905]** exit PGAPI_AllocEnv: phenv = 28970736 **
[-1578905][[SQLSetEnvAttr]] att=200,2
[-1578905][[SQLAllocHandle]][-1578905]PGAPI_AllocConnect: entering...
[-1578905]**** PGAPI_AllocConnect: henv = 28970736, conn = 27869760
[-1578905]EN_add_connection: self = 28970736, conn = 27869760
[-1578905] added at i =0, conn->henv = 28970736, conns[i]->henv = 28970736
[-1578905][SQLGetInfoW(30)][-1578905]PGAPI_GetInfo: entering...fInfoType=77
[-1578905]PGAPI_GetInfo: p='03.00', len=10, value=0, cbMax=12
[-1578905][SQLSetConnectAttrW][-1578905]PGAPI_SetConnectAttr 102
[-1578905]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1
[-1578905][SQLSetConnectAttrW][-1578905]PGAPI_SetConnectAttr 103
[-1578905]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[-1578905][SQLSetConnectAttrW][-1578905]PGAPI_SetConnectAttr 112
[-1578905]PGAPI_SetConnectOption: entering fOption = 112 vParam = 4096
[-1578905][SQLDriverConnectW][-1578905]PGAPI_DriverConnect: entering...
[-1578905]**** PGAPI_DriverConnect: fDriverCompletion=1,
connStrIn='DRIVER={PostgreSQL
Unicode};UID=eetasoft;DATABASE=eeva;SERVER=1.1.1.1 ;PORT=5432;B9=0;'
[-1578905]our_connect_string = 'DRIVER={PostgreSQL
Unicode};UID=eetasoft;DATABASE=eeva;SERVER=1.1.1.1 ;PORT=5432;B9=0;'
[-1578905]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
[-1578905]copyAttributes:
DSN='',server='',dbase='',user='',passwd='xxxxx',p ort='',sslmode='',onlyread='',conn_settings='',dis allow_premature=-1)
[-1578905]attribute = 'UID', value = 'eetasoft'
[-1578905]copyAttributes:
DSN='',server='',dbase='',user='eetasoft',passwd=' xxxxx',port='',sslmode='',onlyread='',conn_setting s='',disallow_premature=-1)
[-1578905]attribute = 'DATABASE', value = 'eeva'
[-1578905]copyAttributes:
DSN='',server='',dbase='eeva',user='eetasoft',pass wd='xxxxx',port='',sslmode='',onlyread='',conn_set tings='',disallow_premature=-1)
[-1578905]attribute = 'SERVER', value = '1.1.1.1'
[-1578905]copyAttributes:
DSN='',server='1.1.1.1',dbase='eeva',user='eetasof t',passwd='xxxxx',port='',sslmode='',onlyread='',c onn_settings='',disallow_premature=-1)
[-1578905]attribute = 'PORT', value = '5432'
[-1578905]copyAttributes:
DSN='',server='1.1.1.1',dbase='eeva',user='eetasof t',passwd='xxxxx',port='5432',sslmode='',onlyread= '',conn_settings='',disallow_premature=-1)
[-1578905]attribute = 'B9', value = '0'
[-1578905]copyAttributes:
DSN='',server='1.1.1.1',dbase='eeva',user='eetasof t',passwd='xxxxx',port='5432',sslmode='',onlyread= '',conn_settings='',disallow_premature=-1)
[-1578905]our_connect_string = 'DRIVER={PostgreSQL
Unicode};UID=eetasoft;DATABASE=eeva;SERVER=1.1.1.1 ;PORT=5432;B9=0;'
[-1578905]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1578905]attribute
= 'UID', value = 'eetasoft'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1578905]attribute
= 'DATABASE', value = 'eeva'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1578905]attribute
= 'SERVER', value = '1.1.1.1'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1578905]attribute
= 'PORT', value = '5432'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1578905]attribute
= 'B9', value = '0'
[-1578905]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=0;C0=0;C1=0;C2=dd_;[-1578905]CC_connect:
entering...
[-1578905]CC_connect(): DSN = '', server = '1.1.1.1', port = '5432', sslmode
= 'prefer', database = 'eeva', username = 'eetasoft', password='xxxxx'
[-1578905]connecting to the server
[-1578905]connecting to the database using 1.1.1.1 as the server
[-1578905]the size is 19
[-1578905]Could not establish connection to the database; LIBPQ returned ->
fe_sendauth: no password supplied

[-1578905]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from
CC_Connect', errnum=113, sqlstate=08001, errmsg='fe_sendauth: no password
supplied
'
[-1578905][SQLGetDiagRecW][-1578905]PGAPI_GetDiagRec entering
rec=1[-1578905]**** PGAPI_ConnectError: hdbc=27869760 <0>
[-1578905]enter CC_get_error
[-1578905]enter CC_create_errormsg
[-1578905]msg = 'fe_sendauth: no password supplied
'
[-1578905]exit CC_create_errormsg
[-1578905]exit CC_get_error
[-1578905]CC_get_error: status = 113, msg = #fe_sendauth: no password
supplied
#
[-1578905] szSqlState = '08001',len=34, szError='(null)'
[-1578905]PGAPI_GetDiagRec exiting 1
[-1578905][SQLGetDiagRecW][-1578905]PGAPI_GetDiagRec entering
rec=1[-1578905]**** PGAPI_ConnectError: hdbc=27869760 <36>
[-1578905]enter CC_get_error
[-1578905]exit CC_get_error
[-1578905]CC_get_error: status = 113, msg = #fe_sendauth: no password
supplied
#
[-1578905] szSqlState = '(null)',len=34, szError='fe_sendauth: no password
supplied
'
[-1578905]PGAPI_GetDiagRec exiting 0
[-1578905][[SQLGetDiagFieldW]] Handle=(2,1a94240) Rec=1 Id=8
[-1578905]PGAPI_GetDiagField entering rec=1, HandleType=2, DiagIdentifier=8
[-1578905]PGAPI_GetDiagField exiting 0

log file when calling other server where page fault does not occur is

[-1509485]globals.extra_systable_prefixes = 'dd_;'
[-1509485][[SQLAllocHandle]][-1509485]**** in PGAPI_AllocEnv **
[-1509485]** exit PGAPI_AllocEnv: phenv = 32050928 **
[-1509485][[SQLSetEnvAttr]] att=200,2
[-1509485][[SQLAllocHandle]][-1509485]PGAPI_AllocConnect: entering...
[-1509485]**** PGAPI_AllocConnect: henv = 32050928, conn = 30949952
[-1509485]EN_add_connection: self = 32050928, conn = 30949952
[-1509485] added at i =0, conn->henv = 32050928, conns[i]->henv =
32050928
[-1509485][SQLGetInfoW(30)][-1509485]PGAPI_GetInfo: entering...fInfoType=77
[-1509485]PGAPI_GetInfo: p='03.00', len=10, value=0, cbMax=12
[-1509485][SQLSetConnectAttrW][-1509485]PGAPI_SetConnectAttr 102
[-1509485]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1
[-1509485][SQLSetConnectAttrW][-1509485]PGAPI_SetConnectAttr 103
[-1509485]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[-1509485][SQLSetConnectAttrW][-1509485]PGAPI_SetConnectAttr 112
[-1509485]PGAPI_SetConnectOption: entering fOption = 112 vParam = 4096
[-1509485][SQLDriverConnectW][-1509485]PGAPI_DriverConnect: entering...
[-1509485]**** PGAPI_DriverConnect: fDriverCompletion=1,
connStrIn='DRIVER={PostgreSQL
Unicode};UID=eeta;DATABASE=eeva;SERVER=2.2.2.2;POR T=5432;B9=0;'
[-1509485]our_connect_string = 'DRIVER={PostgreSQL
Unicode};UID=eeta;DATABASE=eeva;SERVER=2.2.2.2;POR T=5432;B9=0;'
[-1509485]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
[-1509485]copyAttributes:
DSN='',server='',dbase='',user='',passwd='xxxxx',p ort='',sslmode='',onlyread='',conn_settings='',dis allow_premature=-1)
[-1509485]attribute = 'UID', value = 'eeta'
[-1509485]copyAttributes:
DSN='',server='',dbase='',user='eeta',passwd='xxxx x',port='',sslmode='',onlyread='',conn_settings='' ,disallow_premature=-1)
[-1509485]attribute = 'DATABASE', value = 'eeva'
[-1509485]copyAttributes:
DSN='',server='',dbase='eeva',user='eeta',passwd=' xxxxx',port='',sslmode='',onlyread='',conn_setting s='',disallow_premature=-1)
[-1509485]attribute = 'SERVER', value = '2.2.2.2'
[-1509485]copyAttributes:
DSN='',server='2.2.2.2',dbase='eeva',user='eeta',p asswd='xxxxx',port='',sslmode='',onlyread='',conn_ settings='',disallow_premature=-1)
[-1509485]attribute = 'PORT', value = '5432'
[-1509485]copyAttributes:
DSN='',server='2.2.2.2',dbase='eeva',user='eeta',p asswd='xxxxx',port='5432',sslmode='',onlyread='',c onn_settings='',disallow_premature=-1)
[-1509485]attribute = 'B9', value = '0'
[-1509485]copyAttributes:
DSN='',server='2.2.2.2',dbase='eeva',user='eeta',p asswd='xxxxx',port='5432',sslmode='',onlyread='',c onn_settings='',disallow_premature=-1)
[-1509485]our_connect_string = 'DRIVER={PostgreSQL
Unicode};UID=eeta;DATABASE=eeva;SERVER=2.2.2.2;POR T=5432;B9=0;'
[-1509485]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1509485]attribute
= 'UID', value = 'eeta'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1509485]attribute
= 'DATABASE', value = 'eeva'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1509485]attribute
= 'SERVER', value = '2.2.2.2'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1509485]attribute
= 'PORT', value = '5432'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[-1509485]attribute
= 'B9', value = '0'
[-1509485]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1; B5=1;B6=0;B7=1;B8=0;B9=0;C0=0;C1=0;C2=dd_;[-1509485]CC_connect:
entering...
[-1509485]CC_connect(): DSN = '', server = '2.2.2.2', port = '5432', sslmode
= 'prefer', database = 'eeva', username = 'eeta', password='xxxxx'
[-1509485]connecting to the server
[-1509485]connecting to the database using 2.2.2.2 as the server
[-1509485]the size is 22
[-1509485]Could not establish connection to the database; LIBPQ returned ->
fe_sendauth: no password supplied

[-1509485]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from
CC_Connect', errnum=113, sqlstate=08001, errmsg='fe_sendauth: no password
supplied
'
[-1509485][SQLGetDiagRecW][-1509485]PGAPI_GetDiagRec entering
rec=1[-1509485]**** PGAPI_ConnectError: hdbc=30949952 <0>
[-1509485]enter CC_get_error
[-1509485]enter CC_create_errormsg
[-1509485]msg = 'fe_sendauth: no password supplied
'
[-1509485]exit CC_create_errormsg
[-1509485]exit CC_get_error
[-1509485]CC_get_error: status = 113, msg = #fe_sendauth: no password
supplied
#
[-1509485] szSqlState = '08001',len=34, szError='(null)'
[-1509485]PGAPI_GetDiagRec exiting 1
[-1509485][SQLGetDiagRecW][-1509485]PGAPI_GetDiagRec entering
rec=1[-1509485]**** PGAPI_ConnectError: hdbc=30949952 <36>
[-1509485]enter CC_get_error
[-1509485]exit CC_get_error
[-1509485]CC_get_error: status = 113, msg = #fe_sendauth: no password
supplied
#
[-1509485] szSqlState = '(null)',len=34, szError='fe_sendauth: no
password supplied
'
[-1509485]PGAPI_GetDiagRec exiting 0
[-1509485][[SQLGetDiagFieldW]] Handle=(2,1d84240) Rec=1 Id=8
[-1509485]PGAPI_GetDiagField entering rec=1, HandleType=2, DiagIdentifier=8
[-1509485]PGAPI_GetDiagField exiting 0
[-1509485][[SQLGetDiagFieldW]] Handle=(2,1d84240) Rec=1 Id=9
[-1509485]PGAPI_GetDiagField entering rec=1, HandleType=2, DiagIdentifier=9
[-1509485]PGAPI_GetDiagField exiting 0
[-1509485][[SQLGetDiagFieldW]] Handle=(2,1d84240) Rec=1 Id=10
[-1509485]PGAPI_GetDiagField entering rec=1, HandleType=2, DiagIdentifier=10
[-1509485]PGAPI_GetDiagField exiting 0
[-1509485][[SQLGetDiagFieldW]] Handle=(2,1d84240) Rec=1 Id=11
[-1509485]PGAPI_GetDiagField entering rec=1, HandleType=2, DiagIdentifier=11
[-1509485]PGAPI_GetDiagField exiting 0
[-1509485][SQLGetDiagRecW][-1509485]PGAPI_GetDiagRec entering
rec=2[-1509485]**** PGAPI_ConnectError: hdbc=30949952 <0>
[-1509485]PGAPI_GetDiagRec exiting 100
[-1509485][[SQLFreeHandle]][-1509485]PGAPI_FreeConnect: entering...
[-1509485]**** in PGAPI_FreeConnect: hdbc=30949952
[-1509485]enter CC_Destructor, self=30949952
[-1509485]in CC_Cleanup, self=30949952
[-1509485]after LIBPQ destructor
[-1509485]exit CC_Cleanup
[-1509485]after CC_Cleanup
[-1509485]after free statement holders
[-1509485]exit CC_Destructor
[-1509485]PGAPI_FreeConnect: returning...
[-1509485][[SQLFreeHandle]][-1509485]**** in PGAPI_FreeEnv: env = 32050928
**
[-1509485]in EN_Destructor, self=32050928
[-1509485]exit EN_Destructor: rv = 1
[-1509485] ok

Any idea how to fix it ?

Andrus.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:25 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com