[fdo-users] Errors when using AutoCAD Map 2013/2014 and PostGIS/PostgreSQL (FDO 3.7.0/FDO 3.8.0)
Dietmar Fleischhauer (WhereGroup)
d.fleischhauer at wheregroup.com
Thu Oct 24 02:18:40 PDT 2013
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
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4279 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/fdo-users/attachments/20131024/ac8ed801/attachment.bin>
More information about the fdo-users
mailing list