Sharvanek

Member

Last active 9 years ago

  1. 9 years ago
    Wed Nov 18 15:15:47 2015
    Sharvanek posted in fop2GroupButton Table Crashing.

    Thanks, yea I've gone over everything and all is normal, I appreciate the detail. You'd be surprised what some zealous department operators can do ;)

    I've made some adjustments and we'll see how this goes, thank you for your responsiveness!!

  2. Tue Nov 17 13:39:09 2015
    Sharvanek posted in fop2GroupButton Table Crashing.

    Interesting, out of curiosity, why does it do this every time the fop2 manager is loaded?

  3. Mon Nov 16 17:10:11 2015
    Sharvanek posted in fop2GroupButton Table Crashing.

    There's free space, and no other tables exhibit this issue, every time you visit the manager home it deletes the entries in the fop2GroupButton table and recreates them, is this normal? It looks like multiple managers may be colliding on it in some way or something.

    Here's what I see when I load the manager home-

    | 147418 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Buttons' |
    | 147418 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Extensions' |
    | 147418 | asteriskuser | localhost | asterisk | Query | 0 | update | INSERT INTO fop2GroupButton (group_name,id_button,context_id) VALUES ('All Extensions','346','0') |
    | 147419 | asteriskuser | localhost | asterisk | Query | 0 | Sending data | SELECT extension, name, IF(dial IS null,CONCAT('VIRTUAL/',extension),dial) AS dial, IF(voicemail='no |
    | 147419 | asteriskuser | localhost | asterisk | Query | 1 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Extensions' |
    | 147419 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Queues' |

    Thoughts?

  4. Thu Nov 12 20:07:04 2015
    Sharvanek started the conversation fop2GroupButton Table Crashing.

    Hello,

    When we create a new button group, the table fop2GroupButton is dropped and recreated many many times, sometimes it crashes the table-

    ERROR 145 (HY000): Table './asterisk/fop2GroupButton' is marked as crashed and should be repaired

    We're able to recover the table but this shouldn't be happening and it's entirely reproducible, does anyone know if this is a known issue? A brief search of the forum didn't yield anything that seemed to be the same as what we're experiencing.

    Running the latest and greatest 2.30.02

    Thanks!!

  5. Thu Nov 12 20:04:30 2015
    Sharvanek joined the forum.