Dear All, I m getting below error after restarting the server, after that i have to reload the SIP profile manually. Need your help 2019-07-19 21:52:00.891950 [DEBUG] mod_event_socket.c:2961 Socket up listening on 127.0.0.1:8021 2019-07-19 21:52:00.894828 [ERR] switch_odbc.c:368 STATE: HY000 CODE 2003 ERROR: [unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) 2019-07-19 21:52:00.894851 [CRIT] switch_core_sqldb.c:508 Failure to connect to ODBC opencc! 2019-07-19 21:52:00.894858 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected. 2019-07-19 21:52:00.895086 [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/resources/functions/database/native.lua:27: assertion failed! stack traceback: [C]: in function 'assert' /usr/local/freeswitch/scripts/resources/functions/database/native.lua:27: in function 'new' /usr/local/freeswitch/scripts/resources/functions/database.lua:87: in function </usr/local/freeswitch/scripts/resources/functions/database.lua:86> (tail call): ? (tail call): ? /usr/local/freeswitch/scripts/app/xml_handler/resources/scripts/configuration/acl.conf.lua:33: in main chunk [C]: in function 'dofile' /usr/local/freeswitch/scripts/app/xml_handler/index.lua:77: in main chunk /usr/local/freeswitch/scripts/app.lua:30: in main chunk 2019-07-19 21:52:00.895112 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2019-07-19 21:52:00.896754 [INFO] switch_core.c:2447 FreeSWITCH Version 1.8.5~64bit ( 64bit) Thanks Sanjeev On Wed, Jul 17, 2019, 3:19 AM Mike Jerris <mike@freeswitch.com> wrote:
note to all, while we would like to sort this issue, please be aware that sqlite is inherently not as fault tolerant as real db servers, and for this reason we generally recommend using postgres for production deployments where fault tolerance is important.
On Tue, Jul 16, 2019 at 3:58 PM Brian West <brian@freeswitch.com> wrote:
I can get plenty of corrupt DBs, just no solid steps to replicate the issue.
On Tue, Jul 16, 2019 at 12:52 PM David Villasmil < david.villasmil.work@gmail.com> wrote:
I can get a corrupted file, no idea how to replicate.
On Tue, 16 Jul 2019 at 16:38, Brian West <brian@freeswitch.com> wrote:
Find a way to replicate it and we can fix it, this one is one I've been looking at for a while now.
/b
On Tue, Jul 16, 2019 at 9:38 AM Joseph Barrero <joe@expert.net> wrote:
Someone mentioned that they had this problem on AWS. Is anyone having this problem on a local block device rather than EBS?
On Tue, May 28, 2019 at 10:36 PM Nathan Neulinger <nneul@mst.edu> wrote:
It's probably infeasible to do so unless the DBs are super small - but might be useful to try to find at a low level what is corrupted - maybe the particular areas of corruption in the actual file might give some clue as to what was happening at the time.
-- Nathan
------------------------------ *From:* Jai Rangi [mailto:jprangi@gmail.com <jprangi@gmail.com>] *Sent:* Thursday, May 23, 2019, 4:58 PM *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> *Subject:* [Freeswitch-users] Corrupted core.db
My best assumption is it happens at startup. For me I restarted FS last night to free-up memory (trust me it has memory leak too, we use lots of LUA scripts if that makes a difference), this is first log I see (at-least in this case).
| \ \ /\ / /\ \ /\ / /\ \ /\ / / | | | | | | |/ _ \ | / _ \| '_ \ / __/ _ \| '_ ` _ \ | | \ V V / \ V V / \ V V / _ | |___| | |_| | __/ |__| (_) | | | | _ | (_| (_) | | | | | | | | \_/\_/ \_/\_/ \_/\_/ (_) \____|_|\__,_|\___|\____\___/|_| |_| (_) \___\___/|_| |_| |_| | | |
.=======================================================================================================. ^[[m
2019-05-22 23:44:33.327486 [INFO] switch_core.c:2435 FreeSWITCH Version 1.6.16+git~20170407T164913Z~3da6bd0108~64bit (git 3da6bd0 2017-04-07 16:49:13Z 64bit)
FreeSWITCH Started Max Sessions [2000] Session Rate [500] SQL [Enabled] 2019-05-22 23:44:33.605347 [ALERT] sofia_presence.c:2909 sofia_presence_sub_callback: endpt is internal 2019-05-22 23:44:34.305393 [DEBUG] switch_core_file.c:334 File /usr/local/freeswitch/share/freeswitch/sounds/music/8000/one_day_amplify_reduced.wav sample rate 44100 doesn't match requested rate 8000 2019-05-22 23:44:34.305393 [WARNING] switch_core_file.c:352 File has 2 channels, muxing to 1 channel will occur. 2019-05-22 23:44:34.665410 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
I might be corrupted during shutdown, (we have almost 1000 users on this machine, so lots of registration requests), but I only notice it right after restart. Will gather more incidents and share.
Best, -Jai
On Thu, May 23, 2019 at 2:24 PM Brian West <brian@freeswitch.com> wrote:
> You could help narrow down the cause, its a known problem we've been > tracking for a while now, but nobody has narrowed down the exact steps to > replicate it. > > /b > > > On Thu, May 23, 2019 at 4:19 PM Jai Rangi <jprangi@gmail.com> wrote: > >> We are getting this error >> When we do show registration >> >> switch_core_sqldb.c:1197 SQL ERR: [select * from registrations >> where hostname='freeswitch'] database disk image is malformed >> >> If there a way to fix this without restarting free-switch. >> >> Thank you >> -Jai >> >> >> >> _________________________________________________________________________ >> >> The FreeSWITCH project is sponsored by SignalWire >> https://signalwire.com >> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN >> services. >> Build your next product on our scalable cloud platform. >> >> Join our online community to chat in real time >> https://signalwire.community >> >> Professional FreeSWITCH Services >> sales@freeswitch.com >> https://freeswitch.com >> >> Official FreeSWITCH Sites >> https://freeswitch.com/oss >> https://freeswitch.org/confluence >> https://cluecon.com >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@lists.freeswitch.org >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users >> UNSUBSCRIBE: >> http://lists.freeswitch.org/mailman/options/freeswitch-users >> https://freeswitch.com > > > > -- > > Brian West | Co-founder and Developer > > Need Commercial support? email sales@freeswitch.com > > FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 > <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g> > > Email: brian@freeswitch.com > > Mobile: 918-424-9378 > > Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/> > > [image: https://www.facebook.com/signalwireinc?src=email] > <https://www.facebook.com/freeswitch> [image: > https://twitter.com/freeswitch] <https://twitter.com/freeswitch> > > _________________________________________________________________________ > > The FreeSWITCH project is sponsored by SignalWire > https://signalwire.com > Enhance your FreeSWITCH install with disruptive priced SMS and PSTN > services. > Build your next product on our scalable cloud platform. > > Join our online community to chat in real time > https://signalwire.community > > Professional FreeSWITCH Services > sales@freeswitch.com > https://freeswitch.com > > Official FreeSWITCH Sites > https://freeswitch.com/oss > https://freeswitch.org/confluence > https://cluecon.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE: > http://lists.freeswitch.org/mailman/options/freeswitch-users > https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Servicessales@freeswitch.comhttps://freeswitch.com
Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.c...
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://freeswit...
--
------------------------------------------------------------ Nathan Neulinger nneul@mst.edu Missouri S&T Information Technology (573) 341-6679 System Administrator - Architect (573) 612-1412 System and Desktop Infrastructure Team Manager
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
--
Brian West | Co-founder and Developer
Need Commercial support? email sales@freeswitch.com
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
Email: brian@freeswitch.com
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
[image: https://www.facebook.com/signalwireinc?src=email] <https://www.facebook.com/freeswitch> [image: https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
--
Brian West | Co-founder and Developer
Need Commercial support? email sales@freeswitch.com
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
Email: brian@freeswitch.com
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
[image: https://www.facebook.com/signalwireinc?src=email] <https://www.facebook.com/freeswitch> [image: https://twitter.com/freeswitch] <https://twitter.com/freeswitch> _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com