Crash of the OleDB component and of the ODBC component !
am 05.01.2009 09:48:35 von Eric ChristHello
I use WindowsXP pro
I use postgres v 8.3.5-1 and the additional pack dowload by the installer.
I regularly crash Windows component By pgoledb against the pace of crash is
not fixed, 1d to 5d.=20
Hardware structur
=================3D
All computer have 2 network card
All computer are linked to another computer with the 2 network card
The booth network are connected
Ex:
Computer 1 : Server 1 with 2 network card
card A : 192.168.200.10
card B : 192.168.200.11
Computer 2 : Server 2 with 2 network card
card A : 192.168.200.12
card B : 192.168.200.13
Computer 3 : customer 1 with 2 network card
card A : 192.168.200.20
card B : 192.168.200.21
All network on card A are connected
All network on card B are connected
Network on card A and network on card B is interconnected with a switch
The selection of the active connexion is decided by windows
(I test both addresses and I use the first functioning)=20
Software structur
=================3D
I built a monitoring application for power generation=20
I work on Windows XP Pro last update
I have a C and D partition. Postgres is installed on D
My data structure is as follows:=20
Tablesapce : "EDF_SCAV"
CREATE TABLESPACE "EDF_SCAV" OWNER postgres LOCATION
'D:/EDF_SCAV/DATA_BASE/DATA';
DataBase : "EDF"
CREATE DATABASE "EDF_SCAV" WITH OWNER =3D postgres ENCODING =3D
'WIN1252';
Schema "public" with 2110 table
(8 configuration parameters, the rest are data table)
The application save measurment each second.
My client application is developed in LabVIEW 8.6 (from Nationnal
instrument). That oversight of energy production.=20
It is called "scav.exe"=20
Overall it appears to use the Microsoft ADO to connect to the base.=20
The definition of the connection is a file udl Here are contained:=20
[OLEDB]=20
; Everything after this line is an OLE DB initstring=20
Provider =3D PostgreSQL.1; Password =3D admin; User ID =3D postgres; Data S=
ource =3D
192.168.200.13; Location =3D EDF_SCAV; Extended Properties =3D ""=20
When I go to in the event windows explorer I find this:
*** BEGIN ***
Event type=A0: Error
Event source : Application Error
Event Category=A0: None
Event ID=A0: 1000
Date=A0: 05/12/2008
Hour=A0: 05:58:53
User=A0: N/A
Computer=A0: SRV_02
Description=A0:
Scav.exe Faulting application, version 1.0.0.0, faulting module pgoledb.dll,
version 1.0.0.20, fault address 0x00010f55.=20
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.=20
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 73 63 61 ure sca
0018: 76 2e 65 78 65 20 31 2e v.exe 1.
0020: 30 2e 30 2e 30 20 69 6e 0.0.0 in
0028: 20 70 67 6f 6c 65 64 62 pgoledb
0030: 2e 64 6c 6c 20 31 2e 30 .dll 1.0
0038: 2e 30 2e 32 30 20 61 74 .0.20 at
0040: 20 6f 66 66 73 65 74 20 offset=20
0048: 30 30 30 31 30 66 35 35 00010f55
0050: 0d 0a ..
Event type : Informations
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 13:58:17
User : N/A
Computer=A0: SRV_02
Description=A0:
En attente du d=E9marrage du serveur...
(waiting for server starting)
Event type : Informations
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 13:58:17
User : N/A
Computer=A0: SRV_02
Description=A0:
2008-12-11 13:58:17 CET LOG: biblioth=E8que =AB
$libdir/plugins/plugin_debugger.dll =BB charg=E9e
(2008-12-11 13:58:17 CET LOG: librari =AB $libdir/plugins/plugin_debugger.=
dll
=BB loaded)
Event type : Informations
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 13:58:17
User : N/A
Computer=A0: SRV_02
Description=A0:
2008-12-11 13:58:17 CET LOG: n'a pas pu se lier =E0 la socket IPv4 : No er=
ror
2008-12-11 13:58:17 CET ASTUCE : Un autre postmaster fonctionne-t'il d=E9j=
=E0
sur le port 5432 ?
Sinon, attendez quelques secondes et r=E9essayez.
(2008-12-11 13:58:17 CET LOG: don't can link IPv4 socket : No error)
(2008-12-11 13:58:17 CET TIPS : is another postmaster running on 5432 port
?)
( if, wait a few second and try again.)
Event type : Avertissement
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 13:58:17
User : N/A
Computer=A0: SRV_02
Description=A0:
2008-12-11 13:58:17 CET ATTENTION: n'a pas pu cr=E9er le socket d'=E9coute=
pour
=AB * =BB
(2008-12-11 13:58:17 CET WARNING: don't can create the listner socket for =
=AB
* =BB)
Event type : Erreur
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 13:58:17
User : N/A
Computer=A0: SRV_02
Description=A0:
2008-12-11 13:58:17 CET FATAL: n'a pas pu cr=E9er de socket TCP/IP
(2008-12-11 13:58:17 CET FATAL: don't can create the TCP/IP socket)
Event type : Informations
Event source : PostgreSQL
Event catergory : Aucun
Event ID : 0
Date=A0: 11/12/2008
Hour : 14:00:19
User : N/A
Computer=A0: SRV_02
Description=A0:
D=E9passement du d=E9lai pour le d=E9marrage du serveur
(timeout delay for server starting)
*** END ***
I have test the connexion with the oleDB driver AND the ODBC driver
The result is the same
For the ODBC driver i use the following parameters :=20
The statement by the ODBC connection is in Windows=20
In Adminsteur ODBC Data Source tab "Source of user data"=20
The parameters are:=20
"Data Source =3D" EDF_SCAV_1_A "=20
"Database" =3D "EDF_SCAV"=20
"Server" =3D "192.168.200.10"=20
"User Name" =3D "postgres"=20
"PassWorld" =3D "admin"=20
"SSL mode" disable =
"Port" =3D 5432=20
Driver: PostgresSQL Unicode
The UDL file contain :=20
[oledb]
; Everything after this line is an OLE DB initstring
Provider=3DMSDASQL.1;Password=3Dadmin;Persist Security Info=3DTrue;User
ID=3Dpostgres;Data Source=3DEDF_SCAV_1_A;Initial Catalog=3DEDF_SCAV
I do not know what to do to find out why the service crash.=20
One of you would have an idea?
=20
Best regard's
Eric Christ
Application Engineer
________________________________
SETRI
ZAC Sully
10 rue Costes et Bellonte
78200 Mantes-la-Jolie
FRANCE
Tel : (33) 1.34.76.56.21
Fax : (33) 1.34.76.56.96
E-mail : Eric.christ@setri.com
E-mail g=E9n=E9ral : courrier@setri.com
Web : www.setri.com
--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc