Errors when using AutoCAD Map 2013/2014 and PostGIS/PostgreSQL (FDO 3.7.0/FDO 3.8.0)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Errors when using AutoCAD Map 2013/2014 and PostGIS/PostgreSQL (FDO 3.7.0/FDO 3.8.0)

Martin Mohring

Hi,

 

The scenario:

First we create a new DWG-file and establish a new FDO-connection to the PostGIS. Everthing works fine. All data will be queried and shown in AutoCAD.

Next, the file will be closed, the local „MapCache“ delete and the DWG reopened. It’s the same as opening the file on a second workstation.

During the startup/opening the FDO-connection will be automatic recreated. At this point AutoCAD Map freeze/crash.

If we don’t save the password for the FDO-connection, the DWG opens fine because the FDO-connection keeps closed. Only when the connection to the Postgis will be recreated AutoCAD freezes again.

 

Sometimes the connection can be reconnect without errors. But later if we refresh the PostGIS layer in Autocad Map it crashes again.

 

The error can be reproduced on different Systems:

AutoCAD Map 2013 or 2014

and

PostGIS 2.0 (PostgreSQL 9.1 on Ubuntu 12.04)

PostGIS 2.0 (PostgreSQL 9.1 on Windows Server 2008 R2)

PostGIS 2.2 (PostgreSQL 9.3 on Windows Server 2008 R2)

 

We logged the database and the user system.

It seems that during an FDO-transaction (between “Begin Transaction” and “Commit”) the connection gets closed and immediately reconnected. But the usersystem (FDO-client site) will not be notified.

 

Here’s a simplified schema from the database log:

-          Begin Transaction

-          duration: 0.574 ms  parse <unnamed>: DECLARE fdo12 CURSOR FOR […]

-          LOG:  duration: 1.071 ms  statement: FETCH 512 FROM fdo12

-          LOG:  duration: 0.483 ms  statement: FETCH 512 FROM fdo13

-          LOG:  unexpected EOF on client connection

-          LOG:  connection received: host=127.0.0.1 port=61421

-          LOG:  connection authorized: user=autocad database=foo

-          ERROR:  prepared statement "fdo19" does not exist

-          STATEMENT:  DEALLOCATE fdo19Commit

-         

 

Network errors can be excluded. We testet on different networks, direct connections an local installations.

 

Is there any solution/workaround for this strange behavior?

 

Kind regards,

Martin


_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Reply | Threaded
Open this post in threaded view
|

Re: Errors when using AutoCAD Map 2013/2014 and PostGIS/PostgreSQL (FDO 3.7.0/FDO 3.8.0)

Dietmar Fleischhauer
Hi Martin,

one addition: On Monday there has also been a test with PostGIS 1.5 /
PostgreSQL 9.0 / AutoCAD 2014 at the customer's site with the same
results. At the moment I'm trying to reproduce the scenario in our
vmware environment.

Best regards,
Dietmar

Am 24.10.2013 10:34, schrieb Martin Mohring:

> Hi,
>
>  
>
> The scenario:
>
> First we create a new DWG-file and establish a new FDO-connection to the
> PostGIS. Everthing works fine. All data will be queried and shown in
> AutoCAD.
>
> Next, the file will be closed, the local „MapCache“ delete and the DWG
> reopened. It’s the same as opening the file on a second workstation.
>
> During the startup/opening the FDO-connection will be automatic
> recreated. At this point AutoCAD Map freeze/crash.
>
> If we don’t save the password for the FDO-connection, the DWG opens fine
> because the FDO-connection keeps closed. Only when the connection to the
> Postgis will be recreated AutoCAD freezes again.
>
>  
>
> Sometimes the connection can be reconnect without errors. But later if
> we refresh the PostGIS layer in Autocad Map it crashes again.
>
>  
>
> The error can be reproduced on different Systems:
>
> AutoCAD Map 2013 or 2014
>
> and
>
> PostGIS 2.0 (PostgreSQL 9.1 on Ubuntu 12.04)
>
> PostGIS 2.0 (PostgreSQL 9.1 on Windows Server 2008 R2)
>
> PostGIS 2.2 (PostgreSQL 9.3 on Windows Server 2008 R2)
>
>  
>
> We logged the database and the user system.
>
> It seems that during an FDO-transaction (between “Begin Transaction” and
> “Commit”) the connection gets closed and immediately reconnected. But
> the usersystem (FDO-client site) will not be notified.
>
>  
>
> Here’s a simplified schema from the database log:
>
> -          Begin Transaction
>
> -          duration: 0.574 ms  parse <unnamed>: DECLARE fdo12 CURSOR FOR […]
>
> -          LOG:  duration: 1.071 ms  statement: FETCH 512 FROM fdo12
>
> -          LOG:  duration: 0.483 ms  statement: FETCH 512 FROM fdo13
>
> -          LOG:  unexpected EOF on client connection
>
> -          LOG:  connection received: host=127.0.0.1 port=61421
>
> -          LOG:  connection authorized: user=autocad database=foo
>
> -          ERROR:  prepared statement "fdo19" does not exist
>
> -          STATEMENT:  DEALLOCATE fdo19Commit
>
> -          …
>
>  
>
> Network errors can be excluded. We testet on different networks, direct
> connections an local installations.
>
>  
>
> Is there any solution/workaround for this strange behavior?
>
>  
>
> Kind regards,
>
> Martin
>
>
>
> _______________________________________________
> fdo-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>

_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

smime.p7s (5K) Download Attachment