On Thu, Sep 14, 2017, at 05:27 PM, Bryant Zimmerman wrote:> This appears to be some kind of cache issue. > We have been doing caching with earlier versions of asterisk 13 on the > pjsip realtime, but now for some reason > The items only show up the first time we use pjsip list/show and then > they > are wiped. I see a new full cache option and that appears to make a > difference, but it is unclear what is going on. In effect it appears that > items loaded from a database for pjsip must be fully cached or you can't > look up any data. > > Why has a change of this magnitude been put into an LTS? > What is the best practices. I see in some of the wikis cache > suggestions. > What are others really seeing?There haven't been any changes made except for bug fixes to the sorcery memory cache, certainly no behavior changes. In fact the implementation is the same between 13 and 14 except for a single line addition. What is your sorcery.conf for both? -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org
Joshua That is the interesting part of it. We took our configs and database tables from our working 13.12.2 deployments and tried to use them with our new 13.17.1 deployments and we are having issues where the tables are not working. On the new server asterisk keeps saying it can't find the AORS entries when we purge the sorcery memory cache it starts finding the aors but then it says it cant find the auths. The wired thing is when it says it can't find the aors and auths entries it does not show it is looking for the values in the aors and auth fields from the endpoints tables. It keeps putting the value from the endpoints id field as the entries it can't find. One point of note the tables we used and created for pjsip back when we setup the 13.12.2 version are not what is currently being created when we run alembic now.. Also the contact table from alembic creation process does not work we get insert errors inside of asterisk when contact entry attempts are being crated. It shows a number of fields that are not there in the created tables. This is the foundation of my issues. I really have to resolve them in some manner so I can mover forward with getting these new systems into production. Any assistance is appreciated. Thanks Bryant ---------------------------------------- From: "Joshua Colp" <jcolp at digium.com> Sent: Thursday, September 14, 2017 4:34 PM To: asterisk-users at lists.digium.com Subject: Re: [asterisk-users] Realtime pjsip issues On Thu, Sep 14, 2017, at 05:27 PM, Bryant Zimmerman wrote:> This appears to be some kind of cache issue. > We have been doing caching with earlier versions of asterisk 13 on the > pjsip realtime, but now for some reason > The items only show up the first time we use pjsip list/show and then > they > are wiped. I see a new full cache option and that appears to make a > difference, but it is unclear what is going on. In effect it appearsthat> items loaded from a database for pjsip must be fully cached or you can't > look up any data. > > Why has a change of this magnitude been put into an LTS? > What is the best practices. I see in some of the wikis cache > suggestions. > What are others really seeing?There haven't been any changes made except for bug fixes to the sorcery memory cache, certainly no behavior changes. In fact the implementation is the same between 13 and 14 except for a single line addition. What is your sorcery.conf for both? -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170915/904aa93b/attachment.html>
On Fri, Sep 15, 2017, at 10:37 AM, Bryant Zimmerman wrote:> Joshua > > That is the interesting part of it. We took our configs and database > tables from our working 13.12.2 deployments and tried to use them with > our > new 13.17.1 deployments and we are having issues where the tables are not > working. On the new server asterisk keeps saying it can't find the AORS > entries when we purge the sorcery memory cache it starts finding the aors > but then it says it cant find the auths. > > The wired thing is when it says it can't find the aors and auths entries > it does not show it is looking for the values in the aors and auth fields > from the endpoints tables. It keeps putting the value from the endpoints > id > field as the entries it can't find. > > One point of note the tables we used and created for pjsip back when we > setup the 13.12.2 version are not what is currently being created when we > run alembic now.. Also the contact table from alembic creation process > does > not work we get insert errors inside of asterisk when contact entry > attempts are being crated. It shows a number of fields that are not there > in the created tables. > > This is the foundation of my issues. I really have to resolve them in > some > manner so I can mover forward with getting these new systems into > production. > Any assistance is appreciated.You're really throwing a lot of things in here. Please try to simplify this first and remove the caching. After that what exactly does it say it can't find when trying to add a contact? What database is in use? Did you create the tables fresh from alembic? Upgrade existing? If you enable debug (debug to console in logger.conf and core set debug 5) does it show it doing database queries? As it is right now things haven't been narrowed down enough for me to give any concrete answer or help. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org
Joshua We have completed more testing this morning and when we remove the realtime cache options from the sorcery file the endpoints complete registration, but we pjsip show/list does not offer any feed back at all, We also can't send any pjsip send notify commands as they say they don't have an endpoint there. Something has changed in the cache part of the system that is breaking the system in some manner for us with the current version and we are out of ideas. Thanks Bryant Joshua That is the interesting part of it. We took our configs and database tables from our working 13.12.2 deployments and tried to use them with our new 13.17.1 deployments and we are having issues where the tables are not working. On the new server asterisk keeps saying it can't find the AORS entries when we purge the sorcery memory cache it starts finding the aors but then it says it cant find the auths. The wired thing is when it says it can't find the aors and auths entries it does not show it is looking for the values in the aors and auth fields from the endpoints tables. It keeps putting the value from the endpoints id field as the entries it can't find. One point of note the tables we used and created for pjsip back when we setup the 13.12.2 version are not what is currently being created when we run alembic now.. Also the contact table from alembic creation process does not work we get insert errors inside of asterisk when contact entry attempts are being crated. It shows a number of fields that are not there in the created tables. This is the foundation of my issues. I really have to resolve them in some manner so I can mover forward with getting these new systems into production. Any assistance is appreciated. Thanks Bryant ---------------------------------------- From: "Joshua Colp" <jcolp at digium.com> Sent: Thursday, September 14, 2017 4:34 PM To: asterisk-users at lists.digium.com Subject: Re: [asterisk-users] Realtime pjsip issues On Thu, Sep 14, 2017, at 05:27 PM, Bryant Zimmerman wrote:> This appears to be some kind of cache issue. > We have been doing caching with earlier versions of asterisk 13 on the > pjsip realtime, but now for some reason > The items only show up the first time we use pjsip list/show and then > they > are wiped. I see a new full cache option and that appears to make a > difference, but it is unclear what is going on. In effect it appearsthat> items loaded from a database for pjsip must be fully cached or you can't > look up any data. > > Why has a change of this magnitude been put into an LTS? > What is the best practices. I see in some of the wikis cache > suggestions. > What are others really seeing?There haven't been any changes made except for bug fixes to the sorcery memory cache, certainly no behavior changes. In fact the implementation is the same between 13 and 14 except for a single line addition. What is your sorcery.conf for both? -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170915/f646c911/attachment.html>