| 00:00.36 | *** part/#asterisk-dev mjordan (~mjordan@nat/digium/x-yjzxbsqkfwjvvmdu) |
| 00:34.47 | *** join/#asterisk-dev suneye (~atcmmi@119.139.60.110) |
| 01:14.36 | *** join/#asterisk-dev tenspeed705 (~keiths@sud-cable-66-186-66-120.vianet.ca) |
| 01:36.43 | tenspeed705 | anyone around here tonight? |
| 01:47.50 | snuff-work | depends.. on what your after |
| 01:58.36 | alecdavis | its sunny outside?? |
| 02:04.12 | *** part/#asterisk-dev alecdavis (~alecdavis@202.36.76.21) |
| 02:13.48 | suneye | yes,it's a fine day. |
| 03:06.49 | *** join/#asterisk-dev drmessano (~nonya@pdpc/supporter/active/drmessano) |
| 03:57.24 | *** join/#asterisk-dev coreyf1513 (~cfarrell@2001:4830:117f:3:ac1d:201b:3b1d:b6d5) |
| 04:46.26 | *** join/#asterisk-dev oej (~Adium@2001:16d8:cc57:1000::42:100a) |
| 04:46.27 | *** mode/#asterisk-dev [+o oej] by ChanServ |
| 05:35.38 | *** join/#asterisk-dev oej (~Adium@2001:16d8:cc57:1000::42:100a) |
| 05:35.38 | *** mode/#asterisk-dev [+o oej] by ChanServ |
| 06:06.15 | *** join/#asterisk-dev suneye (~atcmmi@116.7.102.68) |
| 07:20.44 | *** join/#asterisk-dev oej (~Adium@h87-96-134-129.dynamic.se.alltele.net) |
| 07:20.45 | *** mode/#asterisk-dev [+o oej] by ChanServ |
| 09:27.26 | *** join/#asterisk-dev Tim_Toady (~fuzzy@snf-34999.vm.okeanos.grnet.gr) |
| 10:02.54 | *** join/#asterisk-dev bulkorok (~chatzilla@85.183.36.36) |
| 10:38.17 | *** join/#asterisk-dev Greenlight (~email@cpc1-dund9-0-0-cust142.16-4.cable.virginmedia.com) |
| 11:22.39 | *** join/#asterisk-dev italorossi (~italoross@187.60.66.11) |
| 11:46.59 | Kobaz | so, with an uptime of 8 hours on asterisk 11, i started getting: [2013-05-07 07:27:52] WARNING[6725]: db.c:329 ast_db_put: Couldn't execute statment 'INSERT OR REPLACE INTO astdb (key, value) VALUES (?, ?)' -- data: (SIP/Reg \ istry,/SIP/Registry/6282) -- Error: database is locked |
| 11:47.51 | seanbright | asterisk 11 from svn? |
| 11:48.23 | Kobaz | mm svn 11 branch |
| 11:48.29 | seanbright | rev? |
| 11:49.03 | Kobaz | Revision: 386530 |
| 11:50.48 | Kobaz | it's not consistent |
| 11:50.57 | Kobaz | it's been running all week and it just happened today |
| 11:51.03 | Kobaz | i restart nightly though |
| 11:57.02 | *** join/#asterisk-dev Tim_Toady (~fuzzy@snf-33276.vm.okeanos.grnet.gr) |
| 11:57.40 | seanbright | Kobaz: not sure. code looks straight forward. |
| 11:57.50 | seanbright | might want to open a bug report |
| 11:58.22 | Kobaz | that's a sqlite error that's passed through to the ast driver |
| 11:58.30 | seanbright | correct |
| 12:04.13 | pabelanger | Kobaz, wow, that is bad |
| 12:55.51 | *** join/#asterisk-dev serafie (~erin@nat/digium/x-umpjbgaezbgrlzaq) |
| 13:07.27 | *** join/#asterisk-dev sruffell (~sruffell@asterisk/the-kernel-guy/sruffell) |
| 13:07.27 | *** mode/#asterisk-dev [+o sruffell] by ChanServ |
| 13:07.48 | Kobaz | yeah that's really bad because pretty much everything will stop working |
| 13:07.52 | Kobaz | had to restart |
| 13:13.52 | Kobaz | looks like after logger rotate, sqlite became locked |
| 13:28.21 | Kobaz | oh wait, hmm it was actually locked before that |
| 13:28.30 | Kobaz | it's just that more calls were going on afterwards so there's more locked errors |
| 13:37.59 | Kobaz | found it |
| 13:38.02 | Kobaz | it was locked on bootup |
| 13:38.14 | Kobaz | asterisk startup |
| 13:41.26 | *** join/#asterisk-dev mjordan (~mjordan@nat/digium/x-vraguwspkabtvcwm) |
| 13:41.26 | *** mode/#asterisk-dev [+o mjordan] by ChanServ |
| 13:43.35 | snuff-home | mjordan: hopefully tomorrow this time a update will be for res_sip doco.. been massaging to make it more uniform.. filling in some blanks.. |
| 13:44.19 | snuff-home | having 1 1/2 hrs trapped on a train each way helps not to get too distracted |
| 13:44.58 | file | snuff-home, re: diagram - contacts aren't associated with endpoints directly |
| 13:45.20 | snuff-home | mm didn't think so.. they are via AoRs right? |
| 13:45.23 | file | yes |
| 13:46.18 | snuff-home | k.. i will update in a few.. with some extra bits also.. |
| 13:49.59 | snuff-home | another question.. 'domain alias / nat hook / endpoint_identifer_[ip/username]' |
| 13:50.37 | snuff-home | should any of those be 'exposed' |
| 13:50.44 | file | domain aliases yes |
| 13:50.46 | file | nat hook no |
| 13:51.17 | snuff-home | i see that 'endpoint' has a 'method' which can be username and/or ip |
| 13:52.18 | snuff-home | also how does the 'registration' type tie in atm.. i was looking around couldn't see obvious link.. |
| 13:52.42 | file | it's for outbound registration |
| 13:53.00 | file | ie: Asterisk registering as a client to a remote SIP server |
| 13:53.17 | snuff-home | i know its for 'outbound reg'.. but its completely separate from an 'endpoint' correct? |
| 13:53.25 | file | yes |
| 13:53.58 | snuff-home | sip_acl.. applies only to endpoints.. right? |
| 13:54.22 | snuff-home | tomorrow someone will have a fun job of properly reviewing much more res_sip doco :) |
| 13:54.36 | snuff-home | see if i'm not off my tree in my 'ideas' |
| 13:54.44 | *** join/#asterisk-dev tzafrir (~tzafrir@local.xorcom.com) |
| 13:54.44 | *** mode/#asterisk-dev [+o tzafrir] by ChanServ |
| 13:56.30 | file | acl I dunno... |
| 13:57.44 | snuff-home | it 'seems' that way |
| 13:58.38 | file | ACLs from res_sip_acl are standalone and apply at the message level, they don't care about endpoints |
| 14:06.45 | *** join/#asterisk-dev kharwell (~kharwell@nat/digium/x-stxnfywipudgczah) |
| 14:11.23 | snuff-home | mm.. k adapting diagram |
| 14:13.05 | *** join/#asterisk-dev putnopvut (~putnopvut@asterisk/master-of-queues/mmichelson) |
| 14:13.05 | *** mode/#asterisk-dev [+o putnopvut] by ChanServ |
| 14:17.08 | Kobaz | i wonder if there is an option in sqlite to force open of the database |
| 14:17.24 | Kobaz | i've seen that happen before actually, where asterisk starts up and can't get a lock on the sqlite db |
| 14:18.03 | Kobaz | but i thought it was my own doing because i ran ast2sqlite3 manually and asterisk had problems using it |
| 14:18.57 | snuff-home | file: http://picpaste.com/res_sip-6jzz9sYm.png |
| 14:19.21 | file | nods |
| 14:19.39 | snuff-home | accepting last comments before i goto bed.. (i will at least fix the alignment of the text on AoR/contact |
| 14:21.19 | snuff-home | i think ppl having this diagram.. will give ppl an 'idea' of how it works before getting lost initially |
| 14:22.27 | snuff-home | only other thing i haven't put on.. is those 'endpoint_ip / endpoint_user' related to the 'method' of an endpoint |
| 14:23.27 | leedm777 | mjordan: the JSON API always steals references, even if the operation fails. Otherwise the API becomes really cumbersome to work with. |
| 14:24.31 | leedm777 | mjordan: It's designed to be NULL safe and reference stealing, so you can safely chain calls together without a zillion intermediate variables and lots of cleanup logic. |
| 14:24.56 | Kobaz | we should sqlite3_open with file:/data.db?vfs=unix-nolock |
| 14:25.04 | Kobaz | or something like that |
| 14:29.22 | Kobaz | gotta play with the open/write stuff to see what causes a lock |
| 15:01.51 | *** join/#asterisk-dev coreyf1513 (~cfarrell@2001:4830:117f:3:81dd:8784:caa7:1e18) |
| 15:05.06 | Kobaz | you know |
| 15:05.08 | Kobaz | heh |
| 15:05.18 | Kobaz | now that asterisk 11 has sqlite |
| 15:05.32 | Kobaz | it seems like a better alternative would be the sqlite api interface around berkley db |
| 15:05.51 | Kobaz | same nice sql interface, high concurrency, and row-level locking |
| 15:06.07 | Kobaz | http://www.oracle.com/technetwork/database/berkeleydb/overview/sql-160887.html3 |
| 15:06.13 | Kobaz | http://www.oracle.com/technetwork/database/berkeleydb/overview/sql-160887.html |
| 15:06.46 | Kobaz | This version of Berkeley DB provides a drop-in compatible version of the SQLite lightweight relational database library, modified to use the Berkeley DB data storage engine. The resulting combined product has the familiar feel of SQLite and the robust, scalable, concurrent storage features of Berkeley DB. Combined, this represents the best-of-breed minimum footprint embedded SQL database engine. |
| 15:06.48 | Kobaz | pretty cool |
| 15:07.41 | Kobaz | even though oracle is evil |
| 15:09.28 | Kobaz | i don't know if it's still open source or not :/ |
| 15:34.58 | *** join/#asterisk-dev tzafrir (~tzafrir@local.xorcom.com) |
| 15:34.58 | *** mode/#asterisk-dev [+o tzafrir] by ChanServ |
| 15:45.02 | *** join/#asterisk-dev anthm (~anthm@freeswitch/developer/anthm) |
| 16:19.31 | Kobaz | [2013-05-07 12:16:15] WARNING[17206]: db.c:329 ast_db_put: Couldn't execute statment 'INSERT OR REPLACE INTO astdb (key, value) VALUES (?, ?)' -- data: (SIP/Registry,/SIP/Registry/CallQueueTestAgent3) -- Error: not an error |
| 16:19.36 | Kobaz | well that's strange |
| 16:58.44 | *** join/#asterisk-dev pabelanger (~pabelange@asterisk/contributor-and-bug-marshal/pabelanger) |
| 16:58.44 | *** mode/#asterisk-dev [+o pabelanger] by ChanServ |
| 17:54.15 | mjordan | snuff-home: I like it |
| 17:57.49 | Qwell | mjordan: I think a merge into your ami-refactoring branch went wonky. I moved ast_system_topic() and such out of a #ifdef LOW_MEMORY, and now it's in your branch twice. |
| 17:58.52 | Qwell | (trunk r387738) |
| 18:12.46 | mjordan | weird... |
| 18:12.56 | mjordan | feel free to rip it out if you'd like |
| 18:13.14 | Qwell | I can just commit a fix there |
| 18:13.25 | mjordan | sure - I'm perfectly fine if you want to just work directly in it |
| 18:13.31 | Qwell | k |
| 18:13.34 | mjordan | it might save some time :-) |
| 19:12.00 | *** join/#asterisk-dev w9sh (~sph@50-79-224-193-static.hfc.comcastbusiness.net) |
| 19:36.42 | *** join/#asterisk-dev philipp64 (~chatzilla@66-232-81-197.ctcweb.net) |
| 19:39.07 | wedhorn | mjordan: have you had a chance to look at the philosophical debate in https://reviewboard.asterisk.org/r/2393/ |
| 20:07.17 | *** join/#asterisk-dev keiths_ (~keiths@goatfarm.vianet.ca) |
| 20:38.28 | *** join/#asterisk-dev pabelanger (~pabelange@asterisk/contributor-and-bug-marshal/pabelanger) |
| 20:38.28 | *** mode/#asterisk-dev [+o pabelanger] by ChanServ |
| 22:05.52 | *** join/#asterisk-dev serafie (~erin@nat/digium/x-hbvlghmvsxczcyep) |
| 23:31.48 | *** join/#asterisk-dev snuff-work (~snuffy@210.8.167.13) |
| 23:31.48 | *** mode/#asterisk-dev [+o snuff-work] by ChanServ |
| 23:36.02 | *** part/#asterisk-dev mjordan (~mjordan@nat/digium/x-vraguwspkabtvcwm) |
