Wireless Access

Reply
Regular Contributor I
Posts: 236
Registered: ‎04-03-2007

wms (SQL) issues on master

Our master (lgrc-wac-106-1) spontaneously crashed a few minutes after we had a local crash last week. The master was the backup. A power cycle brought the master (and local) back online but since then the following SQL logs have been piling up. This week we went ahead with plans to upgrade AOS fro 6.3.1.8 (when it crashed) to 6.3.1.16 pushed onto the opposite partition. These logs began the moment the master came back up from crashing last week, none before, and apparently carried over to the recent AOS upgrade.

We had a couple of trouble tickets in and these devices (along with MANY others) are part of the SQL logs.

The syslog messages guide for 316041 is not very informative. I haven't had time to poll the crash data yet. Is the wms database corrupt? Is there a way to flush it? Anyone seen this before?


Apr  1 19:09:26 lgrc-wac-106-1 wms[1937]: <316041> <WARN> <lgrc-wac-106-1 128.119.3.236>  SQL Command INSERT INTO sta_table SET mac='00:xx:xx:xx:xx:xx', created_time=DATE_FORMAT(NOW(), "%Y%m%d%H%i%S"), probe_id='7491', ap_id='160183', is_ap='yes', status='
up', rsta_type='interfering', ht_type='none', ht_sec_channel='0', phy_type='80211b'; failed. Reason: Got error 127 from table handler
Apr  1 19:09:26 lgrc-wac-106-1 wms[1937]: <316041> <WARN> <lgrc-wac-106-1 128.119.3.236>  SQL Command INSERT INTO sta_table SET mac='11:xx:xx:xx:xx:xx', created_time=DATE_FORMAT(NOW(), "%Y%m%d%H%i%S"), probe_id='6853', ap_id='68728', is_ap='no', status='do
wn', rsta_type='interfering', ht_type='none', ht_sec_channel='0', phy_type='80211b'; failed. Reason: Got error 127 from table handler

Apr  1 19:09:26 lgrc-wac-106-1 wms[1937]: <316041> <WARN> <lgrc-wac-106-1 128.119.3.236>  SQL Command INSERT INTO sta_table SET mac='22:xx:xx:xx:xx:xx', created_time=DATE_FORMAT(NOW(), "%Y%m%d%H%i%S"), probe_id='7491', ap_id='160183', is_ap='no', status='u
p', rsta_type='interfering', ht_type='none', ht_sec_channel='0', phy_type='80211b'; failed. Reason: Duplicate entry 'interfering' for key 3
Apr  1 19:09:26 lgrc-wac-106-1 wms[1937]: <316041> <WARN> <lgrc-wac-106-1 128.119.3.236>  SQL Command INSERT INTO sta_table SET mac='33:xx:xx:xx:xx:xx', created_time=DATE_FORMAT(NOW(), "%Y%m%d%H%i%S"), probe_id='5726', ap_id='73034', is_ap='no', status='do
wn', rsta_type='interfering', ht_type='none', ht_sec_channel='0', phy_type='80211b'; failed. Reason: Duplicate entry 'interfering' for key 3

<etc. for hundreds of thousands of lines>

Search Airheads
Showing results for 
Search instead for 
Did you mean: