Re: [OpenSIPS-Users] Mysql Crashes and panics

2009-04-19 Thread Geoffrey Mina
It sounds to me like your rating script is doing a full table lock and thus not allowing opensips to insert/update rows into the table until it completes. Are you using InnoDB or MyISAM tables? If you are using InnoDB I would do a "SHOW INNODB STATUS" at the time of the 'lockup' to verify that yo

Re: [OpenSIPS-Users] Mysql Crashes and panics

2009-04-16 Thread Bogdan-Andrei Iancu
Hi Brett, Brett Nemeroff wrote: > All, > Ok, so I fixed my kernel panic issue Cool, what was the cause ? > .. But I'm not real happy with the fix. I'm loading up like 157,000 > routes.. each route has between 1-4 gateways in the gwlist. however, > **I only have 1 actual route in the dr_gateway

[OpenSIPS-Users] Mysql Crashes and panics

2009-04-15 Thread Brett Nemeroff
All, Ok, so I fixed my kernel panic issue.. But I'm not real happy with the fix. I'm loading up like 157,000 routes.. each route has between 1-4 gateways in the gwlist. however, **I only have 1 actual route in the dr_gateways table**.. I hadn't added the other 3 gateways.. Now when dr_reload runs,