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
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>
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs. On Thu, 23 May 2019 at 22:44, 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
-- Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which. On Thu, 23 May 2019 at 22:46, David Villasmil < david.villasmil.work@gmail.com> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, 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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
-- Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
I have same experience. Maybe it could be narrowed to version. This happens on little bit old version: 1.6.18 V V čet., 23. maj 2019 ob 23:49 je oseba David Villasmil < david.villasmil.work@gmail.com> napisala:
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which.
On Thu, 23 May 2019 at 22:46, David Villasmil < david.villasmil.work@gmail.com> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, 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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
-- 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
-- Gregor Nanger *CTO* t./f.: 00386 (0) 7 6000 308/309 • m:. 00386 (0)41 756485 • Infomedia d.o.o. • Jerebova 3, Novo mesto, Slovenia • www.infomedia.si
The version probably won't matter, its something I suspect elsewhere that we need to find, we've yet to find the smoking gun on this one. I suspect a quirk in the system lib of SQLite, maybe we start a google doc and everyone can report their revs, os and system lib versions? /b On Thu, May 23, 2019 at 4:56 PM Gregor Nanger <gregor@infomedia.si> wrote:
I have same experience. Maybe it could be narrowed to version. This happens on little bit old version: 1.6.18
V V čet., 23. maj 2019 ob 23:49 je oseba David Villasmil < david.villasmil.work@gmail.com> napisala:
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which.
On Thu, 23 May 2019 at 22:46, David Villasmil < david.villasmil.work@gmail.com> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, 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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
-- 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
-- Gregor Nanger
*CTO* t./f.: 00386 (0) 7 6000 308/309 • m:. 00386 (0)41 756485 • Infomedia d.o.o. • Jerebova 3, Novo mesto, Slovenia • www.infomedia.si _________________________________________________________________________
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>
Sounds like a plan. On Fri, 24 May 2019 at 00:23, Brian West <brian@freeswitch.com> wrote:
The version probably won't matter, its something I suspect elsewhere that we need to find, we've yet to find the smoking gun on this one.
I suspect a quirk in the system lib of SQLite, maybe we start a google doc and everyone can report their revs, os and system lib versions?
/b
On Thu, May 23, 2019 at 4:56 PM Gregor Nanger <gregor@infomedia.si> wrote:
I have same experience. Maybe it could be narrowed to version. This happens on little bit old version: 1.6.18
V V čet., 23. maj 2019 ob 23:49 je oseba David Villasmil < david.villasmil.work@gmail.com> napisala:
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which.
On Thu, 23 May 2019 at 22:46, David Villasmil < david.villasmil.work@gmail.com> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, 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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
-- 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
-- Gregor Nanger
*CTO* t./f.: 00386 (0) 7 6000 308/309 • m:. 00386 (0)41 756485 • Infomedia d.o.o. • Jerebova 3, Novo mesto, Slovenia <https://maps.google.com/?q=Jerebova+3,+Novo+mesto,+Slovenia&entry=gmail&source=g> • www.infomedia.si _________________________________________________________________________
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
Happens on 1.6.20 as well On Thu, 23 May 2019 at 23:22, Gregor Nanger <gregor@infomedia.si> wrote:
I have same experience. Maybe it could be narrowed to version. This happens on little bit old version: 1.6.18
V V čet., 23. maj 2019 ob 23:49 je oseba David Villasmil < david.villasmil.work@gmail.com> napisala:
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which.
On Thu, 23 May 2019 at 22:46, David Villasmil < david.villasmil.work@gmail.com> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, 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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
-- 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
-- Gregor Nanger
*CTO* t./f.: 00386 (0) 7 6000 308/309 • m:. 00386 (0)41 756485 • Infomedia d.o.o. • Jerebova 3, Novo mesto, Slovenia <https://maps.google.com/?q=Jerebova+3,+Novo+mesto,+Slovenia&entry=gmail&source=g> • www.infomedia.si _________________________________________________________________________
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
This happen to me too, solve it by change to postgresql, and it was the same it affected core.db and other dbs used from other modules or from lua scripts. In my case, i found out that it happens only when i have sip endpoints with wss enabled using sipml5 js client, i still have some errors with droped connection with postgres but it doesn't corrupt the system. On 24/05/2019 00:37, David Villasmil wrote:
Happens on 1.6.20 as well
On Thu, 23 May 2019 at 23:22, Gregor Nanger <gregor@infomedia.si <mailto:gregor@infomedia.si>> wrote:
I have same experience. Maybe it could be narrowed to version. This happens on little bit old version: 1.6.18
V V čet., 23. maj 2019 ob 23:49 je oseba David Villasmil <david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com>> napisala:
And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which.
On Thu, 23 May 2019 at 22:46, David Villasmil <david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com>> wrote:
This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs.
On Thu, 23 May 2019 at 22:44, Brian West <brian@freeswitch.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto:brian@freeswitch.com>
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
https://www.facebook.com/signalwireinc?src=email <https://www.facebook.com/freeswitch> 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 <mailto: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 <mailto: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 <mailto:david.villasmil.work@gmail.com> phone: +34669448337
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com <mailto: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 <mailto: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 <mailto: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
-- Gregor Nanger *CTO* t./f.: 00386 (0) 7 6000 308/309 • m:. 00386 (0)41 756485 • Infomedia d.o.o. • Jerebova 3, Novo mesto, Slovenia <https://maps.google.com/?q=Jerebova+3,+Novo+mesto,+Slovenia&entry=gmail&source=g>
• www.infomedia.si <http://www.infomedia.si>
_________________________________________________________________________
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 <mailto: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 <mailto: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 <mailto: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
-- Saludos / Regards / Cumprimentos António Silva
You should check your hard drive. Thanks, Moishe Grunstein Tornado Computer Systems, Inc. 212.400.7650 888.IPPBX.US Service Request Email: support@nysolutions.com<mailto:support@nysolutions.com> [cid:image001.jpg@01C72F94.9EE45D60]<http://www.nysolutions.com/> Computer Networking * Managed Services * IP Video Surveillance * Network Assessments * Web Solutions * Voice over IP * Disaster Recovery * Network Security * Site Surveys * CMS From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> On Behalf Of David Villasmil Sent: Thursday, May 23, 2019 5:49 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] Corrupted core.db And BTW doesn’t just happens on coredb, but on all the dB files. Random as to which. On Thu, 23 May 2019 at 22:46, David Villasmil <david.villasmil.work@gmail.com<mailto:david.villasmil.work@gmail.com>> wrote: This is pretty random, at least for me. I need to stop fs, remove the files and start again. This happens on _all_ of my production fs. Which are spun up on aws from AMIs. On Thu, 23 May 2019 at 22:44, Brian West <brian@freeswitch.com<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto:brian@freeswitch.com> Mobile: 918-424-9378 Website: https://www.FreeSWITCH.com<https://www.freeswitch.com/> [https://www.facebook.com/signalwireinc?src=email]<https://www.facebook.com/freeswitch>[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<mailto: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<mailto: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<mailto:david.villasmil.work@gmail.com> phone: +34669448337 -- Regards, David Villasmil email: david.villasmil.work@gmail.com<mailto:david.villasmil.work@gmail.com> phone: +34669448337
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
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
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>
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
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>
Have you been able to get a _small_ corrupted DB? if you can look at the low level content of what portion of the DB is corrupted, maybe it will shed light on which portions of it were being modified at the same time or what was going on. Seeing if problem occurs when running with that DB on a /dev/shm or other ramdisk might also be useful. -- Nathan ------------------------------------------------------------------------------------------------------------------------ *From:* Brian West <brian@freeswitch.com> *Sent:* Tue, Jul 16, 2019 2:58 PM CDT *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> *Subject:* [Freeswitch-users] Corrupted core.db
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 <mailto: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 <mailto: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
-- ------------------------------------------------------------ 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
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
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
111 is icmp unreachable, Sure the DB was up? On Mon, Jul 22, 2019 at 4:03 PM sanjeev dubey <sanjeevdb4@gmail.com> wrote:
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
_________________________________________________________________________
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>
Also 127.0.0.1 tries a TCP connection so check MySQL is listening on the network and not just a unix socket. On Tue, 23 Jul 2019 at 00:23, Brian West <brian@freeswitch.com> wrote:
111 is icmp unreachable, Sure the DB was up?
On Mon, Jul 22, 2019 at 4:03 PM sanjeev dubey <sanjeevdb4@gmail.com> wrote:
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
_________________________________________________________________________
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
participants (11)
-
António Silva
-
Brian West
-
David Villasmil
-
Gregor Nanger
-
Jai Rangi
-
Joseph Barrero
-
Mike Jerris
-
Moishe Grunstein
-
Nathan Neulinger
-
sanjeev dubey
-
Steven Ayre