FDO Causing MapGuide 2.0 to Crash MySQL based?

[Rothgar]

root@mapsrv:/home/mapguide/server/bin# ./mgserver.sh
/home/mapguide/server/bin /home/mapguide/server/bin
Running the server interactively as an application instead of as a service.

(3017729728) Server starting...
(3017729728) PROJ4 Coordinate System Library
(3017729728) Server started.
(2614819728) An exception occurred in FDO component.
RDBMS: Can't connect to MySQL server on '10.1.1.70' (113)
Exception occurred in method MgFdoConnectionManager.Open at line 858 in file FdoConnectionManager.cpp

*** glibc detected *** ./mgserver: double free or corruption (!prev): 0x0872d4d0 ***
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6[0xb4b0ed65]
/lib/tls/i686/cmov/libc.so.6(cfree+0x90)[0xb4b12800]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb4cd7d81]
/usr/lib/libstdc++.so.6(_ZNSbIwSt11char_traitsIwESaIwEE4_Rep10_M_destroyERKS1_+0x1d)[0xb4ccfa8d]
/home/mapguide/lib/libMgMapGuideCommon.so.7(_ZN17MgUserInformationD0Ev+0x188)[0xb6079de8]
/home/mapguide/lib/libMgMapGuideCommon.so.7(_ZN17MgUserInformation7DisposeEv+0x15)[0xb60347a5]
/home/mapguide/lib/libMgFoundation.so.7(_ZN17MgGuardDisposable7ReleaseEv+0x77)[0xb65c7ba7]
/home/mapguide/lib/libMgMapGuideCommon.so.7(_ZN17MgUserInformation18SetCurrentUserInfoEPS_+0x6a)[0xb60402ba]
/home/mapguide/server/lib/libMgServerBase.so.7(_ZN18MgServiceOperationD2Ev+0x50)[0xb5eb1d30]
/home/mapguide/server/lib/libMgServerResourceService.so.7(_ZN19MgResourceOperationD2Ev+0x3c)[0xb53261cc]
/home/mapguide/server/lib/libMgServerResourceService.so.7(_ZN15MgOpSetResourceD0Ev+0x2d)[0xb53263fd]
/home/mapguide/server/lib/libMgServerResourceService.so.7(_ZN24MgResourceServiceHandler16ProcessOperationEv+0x7f)[0xb54041df]
./mgserver[0x808c336]
./mgserver[0x808de13]
./mgserver[0x808f8b4]
/home/mapguide/lib/libACE.so.5.4.0(_ZN13ACE_Task_Base7svc_runEPv+0x56)[0xb7e37fa6]
/home/mapguide/lib/libACE.so.5.4.0(_ZN18ACE_Thread_Adapter8invoke_iEv+0x57)[0xb7db9797]
/home/mapguide/lib/libACE.so.5.4.0(_ZN18ACE_Thread_Adapter6invokeEv+0x66)[0xb7db9966]
/home/mapguide/lib/libACE.so.5.4.0(ace_thread_adapter+0x10)[0xb7d6dd70]
/lib/tls/i686/cmov/libpthread.so.0[0xb467e46b]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb4b7873e]
======= Memory map: ========
08048000-080eb000 r-xp 00000000 68:01 8044622    /home/mapguide/server/bin/mgserver
080eb000-080ec000 rw-p 000a3000 68:01 8044622    /home/mapguide/server/bin/mgserver
080ec000-087a5000 rw-p 080ec000 00:00 0          [heap]
8f3ba000-8f402000 r-xp 00000000 68:01 7586823    /usr/local/fdo-3.3.0/lib/libOGRProvider-3.3.0.so
8f402000-8f405000 rw-p 00048000 68:01 7586823    /usr/local/fdo-3.3.0/lib/libOGRProvider-3.3.0.so
8f405000-8f474000 r-xp 00000000 68:01 7586817    /usr/local/fdo-3.3.0/lib/libGRFPOverrides-3.3.0.so
8f474000-8f477000 rw-p 0006e000 68:01 7586817    /usr/local/fdo-3.3.0/lib/libGRFPOverrides-3.3.0.so
8f477000-8f487000 rw-p 8f477000 00:00 0 
8f487000-8f543000 r-xp 00000000 68:01 7586820    /usr/local/fdo-3.3.0/lib/libGRFPProvider-3.3.0.so
8f543000-8f548000 rw-p 000bb000 68:01 7586820    /usr/local/fdo-3.3.0/lib/libGRFPProvider-3.3.0.so
8f548000-8f558000 rw-p 8f548000 00:00 0 
8f558000-8f59f000 r-xp 00000000 68:01 7489886    /usr/lib/libmysqlclient.so.15.0.0
8f59f000-8f6ac000 rw-p 00046000 68:01 7489886    /usr/lib/libmysqlclient.so.15.0.0
8f6ac000-8f6ad000 rw-p 8f6ac000 00:00 0 
8f6ad000-8fdf3000 r-xp 00000000 68:01 7586832    /usr/local/fdo-3.3.0/lib/libFdoMySQL-3.3.0.so
8fdf3000-8fe20000 rw-p 00746000 68:01 7586832    /usr/local/fdo-3.3.0/lib/libFdoMySQL-3.3.0.so
8fe20000-8fe5f000 rw-p 8fe20000 00:00 0 
8fe5f000-8febc000 r-xp 00000000 68:01 7586811    /usr/local/fdo-3.3.0/lib/libWMSOverrides-3.3.0.so
8febc000-8febe000 rw-p 0005d000 68:01 7586811    /usr/local/fdo-3.3.0/lib/libWMSOverrides-3.3.0.so
8febe000-8fece000 rw-p 8febe000 00:00 0 
8fece000-8ff94000 r-xp 00000000 68:01 7586814    /usr/local/fdo-3.3.0/lib/libWMSProvider-3.3.0.so
8ff94000-8ff99000 rw-p 000c5000 68:01 7586814    /usr/local/fdo-3.3.0/lib/libWMSProvider-3.3.0.so
8ff99000-8ffa9000 rw-p 8ff99000 00:00 0 
8ffa9000-9026d000 r-xp 00000000 68:01 7586795    /usr/local/fdo-3.3.0/lib/libFdoOws-3.3.0.so
9026d000-90286000 rw-p 002c3000 68:01 7586795    /usr/local/fdo-3.3.0/lib/libFdoOws-3.3.0.so
90286000-9029a000 rw-p 90286000 00:00 0 
9029a000-90407000 r-xp 00000000 68:01 7586808    /usr/local/fdo-3.3.0/lib/libWFSProvider-3.3.0.so
90407000-90413000 rw-p 0016d000 68:01 7586808    /usr/local/fdo-3.3.0/lib/libWFSProvider-3.3.0.so
90413000-90423000 rw-p 90413000 00:00 0 
90423000-90583000 r-xp 00000000 68:01 7586805    /usr/local/fdo-3.3.0/lib/libSDFProvider-3.3.0.so
90583000-90589000 rw-p 0015f000 68:01 7586805    /usr/local/fdo-3.3.0/lib/libSDFProvider-3.3.0.so
90589000-90599000 rw-p 90589000 00:00 0 
90599000-9059a000 ---p 90599000 00:00 0 
9059a000-90d9a000 rwxp 9059a000 00:00 0 
90d9a000-90d9b000 ---p 90d9a000 00:00 0 
90d9b000-9159b000 rwxp 90d9b000 00:00 0 
9159b000-9159c000 ---p 9159b000 00:00 0 
9159c000-91d9c000 rwxp 9159c000 00:00 0 
91d9c000-91d9d000 ---p 91d9c000 00:00 0 
91d9d000-9259d000 rwxp 91d9d000 00:00 0 
9259d000-9259e000 ---p 9259d000 00:00 0 
9259e000-92d9e000 rwxp 9259e000 00:00 0 
92d9e000-92d9f000 ---p 92d9e000 00:00 0 
92d9f000-9359f000 rwxp 92d9f000 00:00 0 
9359f000-935a0000 ---p 9359f000 00:00 0 
935a0000-93da0000 rwxp 935a0000 00:00 0 
93da0000-93da1000 ---p 93da0000 00:00 0 
93da1000-945a1000 rwxp 93da1000 00:00 0 
945a1000-945a2000 ---p 945a1000 00:00 0 
945a2000-94da2000 rwxp 945a2000 00:00 0 
94da2000-94da3000 ---p 94da2000 00:00 0 
94da3000-955a3000 rwxp 94da3000 00:00 0 
955a3000-955a4000 ---p 955a3000 00:00 0 
955a4000-95da4000 rwxp 955a4000 00:00 0 
95da4000-95da5000 ---p 95da4000 00:00 0 
95da5000-965a5000 rwxp 95da5000 00:00 0 
965a5000-965a6000 ---p 965a5000 00:00 0 
965a6000-96da6000 rwxp 965a6000 00:00 0 
96da6000-96da7000 ---p 96da6000 00:00 0 
96da7000-975a7000 rwxp 96da7000 00:00 0 
975a7000-975a8000 ---p 975a7000 00:00 0 
975a8000-97da8000 rwxp 975a8000 00:00 0 
97da8000-97da9000 ---p 97da8000 00:00 0 
97da9000-985a9000 rwxp 97da9000 00:00 0 
985a9000-985aa000 ---p 985a9000 00:00 0 
985aa000-98daa000 rwxp 985aa000 00:00 0 
98daa000-98dab000 ---p 98daa000 00:00 0 
98dab000-995ab000 rwxp 98dab000 00:00 0 
995ab000-995ac000 ---p 995ab000 00:00 0 
995ac000-99dac000 rwxp 995ac000 00:00 0 
99dac000-99dad000 ---p 99dac000 00:00 0 
99dad000-9a5ad000 rwxp 99dad000 00:00 0 
9a5ad000-9a5ae000 ---p 9a5ad000 00:00 0 
9a5ae000-9adae000 rwxp 9a5ae000 00:00 0 
9adae000-9adaf000 ---p 9adae000 00:00 0 
9adaf000-9b5af000 rwxp 9adaf000 00:00 0 
9b5af000-9b5b0000 ---p 9b5af000 00:00 0 
9b5b0000-9bdb0000 rwxp 9b5b0000 00:00 0 
9bdb0000-9bdb1000 ---p 9bdb0000 00:00 0 
9bdb1000-9c5b1000 rwxp 9bdb1000 00:00 0 
9c5b1000-9c5b2000 ---p 9c5b1000 00:00 0 
9c5b2000-9cdb2000 rwxp 9c5b2000 00:00 0 
9cdb2000-9cdb3000 ---p 9cdb2000 00:00 0 
9cdb3000-9d5b3000 rwxp 9cdb3000 00:00 0 
9d5b3000-9d5b4000 ---p 9d5b3000 00:00 0 
9d5b4000-9ddb4000 rwxp 9d5b4000 00:00 0 
9ddb4000-9ddb5000 ---p 9ddb4000 00:00 0 
9ddb5000-9e5b5000 rwxp 9ddb5000 00:00 0 
9e5b5000-9e5b6000 ---p 9e5b5000 00:00 0 
9e5b6000-9edb6000 rwxp 9e5b6000 00:00 0 
9edb6000-9edb7000 ---p 9edb6000 00:00 0 
9edb7000-9f5b7000 rwxp 9edb7000 00:00 0 
9f5b7000-9f5b8000 ---p 9f5b7000 00:00 0 
9f5b8000-9fdb8000 rwxp 9f5b8000 00:00 0 
9fdb8000-9fdb9000 ---p 9fdb8000 00:00 0 
9fdb9000-a05b9000 rwxp 9fdb9000 00:00 0 
a05b9000-a05ba000 ---p a05b9000 00:00 0 
a05ba000-a0dba000 rwxp a05ba000 00:00 0 
a0dba000-a0dbb000 ---p a0dba000 00:00 0 
a0dbb000-a15bb000 rwxp a0dbb000 00:00 0 
a15bb000-a15bc000 ---p a15bb000 00:00 0 
a15bc000-a1dbc000 rwxp a15bc000 00:00 0 
a1dbc000-a1dbd000 ---p a1dbc000 00:00 0 
a1dbd000-a25bd000 rwxp a1dbd000 00:00 0 
a25bd000-a25be000 ---p a25bd000 00:00 0 
a25be000-a2dbe000 rwxp a25be000 00:00 0 
a2dbe000-a2dbf000 ---p a2dbe000 00:00 0 
a2dbf000-a35bf000 rwxp a2dbf000 00:00 0 
a35bf000-a35c0000 ---p a35bf000 00:00 0 
a35c0000-a3dc0000 rwxp a35c0000 00:00 0 
a3dc0000-a3dc1000 ---p a3dc0000 00:00 0 
a3dc1000-a45c1000 rwxp a3dc1000 00:00 0 
a45c1000-a45c2000 ---p a45c1000 00:00 0 
a45c2000-a4dc2000 rwxp a45c2000 00:00 0 
a4dc2000-a4dc3000 ---p a4dc2000 00:00 0 
a4dc3000-a55c3000 rwxp a4dc3000 00:00 0 
a55c3000-a55c4000 ---p a55c3000 00:00 0 
a55c4000-a5dc4000 rwxp a55c4000 00:00 0 
a5dc4000-a5dc5000 ---p a5dc4000 00:00 0 
a5dc5000-a65c5000 rwxp a5dc5000 00:00 0 
a65c5000-a65c6000 ---p a65c5000 00:00 0 
a65c6000-a6dc6000 rwxp a65c6000 00:00 0 
a6dc6000-a6dc7000 ---p a6dc6000 00:00 0 
a6dc7000-a75c7000 rwxp a6dc7000 00:00 0 
a75c7000-a7dd7000 rw-s 00000000 68:01 8192159    /home/mapguide/server/Repositories/Library/__db.004
a7dd7000-aa5d9000 rw-s 00000000 68:01 8192158    /home/mapguide/server/Repositories/Library/__db.003
aa5d9000-aa6e7000 rw-s 00000000 68:01 8192157    /home/mapguide/server/Repositories/Library/__db.002
aa6e7000-aa6f1000 rw-s 00000000 68:01 8192153    /home/mapguide/server/Repositories/Site/__db.006
aa6f1000-aa747000 rw-s 00000000 68:01 8192152    /home/mapguide/server/Repositories/Site/__db.005
aa747000-aaf57000 rw-s 00000000 68:01 8192151    /home/mapguide/server/Repositories/Site/__db.004
aaf57000-ad759000 rw-s 00000000 68:01 8192150    /home/mapguide/server/Repositories/Site/__db.003
ad759000-ad867000 rw-s 00000000 68:01 8192149    /home/mapguide/server/Repositories/Site/__db.002
ad867000-ae150000 rw-p ad867000 00:00 0 
ae168000-ae2e7000 r-xp 00000000 68:01 7586802    /usr/local/fdo-3.3.0/lib/libSHPProvider-3.3.0.so
ae2e7000-ae2f0000 rw-p 0017e000 68:01 7586802    /usr/local/fdo-3.3.0/lib/libSHPProvider-3.3.0.so
ae2f0000-ae321000 rw-p ae2f0000 00:00 0 
ae321000-ae400000 ---p ae321000 00:00 0 
ae409000-ae40e000 r-xp 00000000 68:01 8503448    /lib/tls/i686/cmov/libcrypt-2.6.1.so
ae40e000-ae410000 rw-p 00004000 68:01 8503448    /lib/tls/i686/cmov/libcrypt-2.6.1.so
ae410000-ae437000 rw-p ae410000 00:00 0 
ae43d000-ae447000 rw-s 00000000 68:01 8192161    /home/mapguide/server/Repositories/Library/__db.006
ae447000-ae49d000 rw-s 00000000 68:01 8192160    /home/mapguide/server/Repositories/Library/__db.005
ae49d000-ae4a3000 rw-s 00000000 68:01 8192156    /home/mapguide/server/Repositories/Library/__db.001
ae4a3000-ae4a4000 ---p ae4a3000 00:00 0 
ae4a4000-aeca4000 rwxp ae4a4000 00:00 0 
aeca4000-aeca5000 ---p aeca4000 00:00 0 
aeca5000-af4a5000 rwxp aeca5000 00:00 0 
af4a5000-af4a6000 ---p af4a5000 00:00 0 
af4a6000-afca6000 rwxp af4a6000 00:00 0 
afca6000-afca7000 ---p afca6000 00:00 0 
afca7000-b04a7000 rwxp afca7000 00:00 0 
b04a7000-b04a8000 ---p b04a7000 00:00 0 
b04a8000-b0ca8000 rwxp b04a8000 00:00 0 
b0ca8000-b0ca9000 ---p b0ca8000 00:00 0 
b0ca9000-b14a9000 rwxp b0ca9000 00:00 0 
b14a9000-b14aa000 ---p b14a9000 00:00 0 
b14aa000-b1caa000 rwxp b14aa000 00:00 0 
b1caa000-b1cab000 ---p b1caa000 00:00 0 
b1cab000-b24ab000 rwxp b1cab000 00:00 0 
b24ab000-b24ac000 ---p b24ab000 00:00 0 
b24ac000-b2cac000 rwxp b24ac000 00:00 0 
b2cac000-b2cad000 ---p b2cac000 00:00 0 
b2cad000-b34ad000 rwxp b2cad000 00:00 0 
b34ad000-b34b6000 r-xp 00000000 68:01 8503457    /lib/tls/i686/cmov/libnss_files-2.6.1.so
b34b6000-b34b8000 rw-p 00008000 68:01 8503457    /lib/tls/i686/cmov/libnss_files-2.6.1.so
b34b8000-b34be000 rw-s 00000000 68:01 8192148    /home/mapguide/server/Repositories/Site/__db.001
b34be000-b34bf000 ---p b34be000 00:00 0 
b34bf000-b3cbf000 rwxp b34bf000 00:00 0 
b3cbf000-b3cc3000 rw-p b3cbf000 00:00 0 
b3cc3000-b3d02000 r--p 00000000 68:01 7522273    /usr/lib/locale/en_AU.utf8/LC_CTYPE
b3d02000-b3d03000 r--p 00000000 68:01 7522274    /usr/lib/locale/en_AU.utf8/LC_NUMERIC
b3d03000-b3d04000 r--p 00000000 68:01 7522275    /usr/lib/locale/en_AU.utf8/LC_TIME
b3d04000-b3de4000 r--p 00000000 68:01 7522276    /usr/lib/locale/en_AU.utf8/LC_COLLATE
b3de4000-b3de5000 r--p 00000000 68:01 7522277    /usr/lib/locale/en_AU.utf8/LC_MONETARY
b3de5000-b3de6000 r--p 00000000 68:01 7522279    /usr/lib/locale/en_AU.utf8/LC_MESSAGES/SYS_LC_MESSAGES
b3de6000-b3de7000 r--p 00000000 68:01 7522280    /usr/lib/locale/en_AU.utf8/LC_PAPER
b3de7000-b3dee000 r--s 00000000 68:01 7489586    /usr/lib/gconv/gconv-modules.cache
b3dee000-b3df2000 rw-p b3dee000 00:00 0 
b3df2000-b3e01000 r-xp 00000000 68:01 8503463    /lib/tls/i686/cmov/libresolv-2.6.1.so
b3e01000-b3e03000 rw-p 0000f000 68:01 8503463    /lib/tls/i686/cmov/libresolv-2.6.1.so
b3e03000-b3e05000 rw-p b3e03000 00:00 0 
b3e05000-b3e06000 r-xp 00000000 68:01 8503530    /lib/libkeyutils-1.2.so
b3e06000./mgserver.sh: line 7:  9589 Aborted                 ./mgserver run
/home/mapguide/server/bin

[jacklee]

Which version of MySQL is used?

[Rothgar]

Hi Jacklee, 5.0

I don't know exactly which version though but it's not the latest because that wasn't working in MapGuide Studio? So we had to downgrade to I think it's 5.0.22 or something around that version.

[jacklee]

Hi,

Did you tried to connect to MySql server using the interactive command line shell mysql?

[Rothgar]

MySQL is working, MapGuide Server works for a while as well, then eventually usually within about 5 minutes it crashes.

While MapGuide is working it conencts to MySQL fine.

[Rothgar]

We are moving to Windows, will not be able to do any more testing.

[MaksimS]

This may be as well infamous MapGuide Server 1.2/2.0 instability - the very same thing happened to me as well, and I'm using: Microsoft SQL Server 2005 (managed datastore, MGE), Microsoft SQL Server 2000 (via ODBC, MGE), Oracle-based datastores (MGE), and MySQL Server (MGOS). I didn't had time to investigate whether it's up to the underlying FDO or MG itself, but both MGOS and MGE do crash here and there. It seems that MGOS stability improved in 2.0.1, so try getting a patch.

As for the MySQL Server 5.0.22 _and higher_, you need to have installed libmySQL.dll version 5.0.22 on your client machine, in FDO's bin folder (or your running app folder referencing FDO libraries) adding it's path to the PATH system variable. You can find libmySQL.dll v5.0.22 in previous MySQL Server binary packs.

[gregboone]

This looks like it is a MapGuide issue. This should be re-directed to that community and resolved there. If there is a underlying FDO issue that can be clearly identified, please feel free to add a valid use case/user scenario to this ticket and re-open.