SOLVED fwconsole reload error

[islandtech]

Crown Cloud had network issues in the Miami server node
when service was restored I'm getting this error: Unknown Error. Please Run: fwconsole reload --verbose

Reload Started

In DB_Helper.class.php line 174:
                                                                                    
  [PDOException (HY000)]                                                             
  SQLSTATE[HY000]: General error: 1712 Index kvstore_FreePBX_modules_Amd is corrupted
                                                                                    

Exception trace:
  at /var/www/html/admin/libraries/BMO/DB_Helper.class.php:174
 PDOStatement->execute() at /var/www/html/admin/libraries/BMO/DB_Helper.class.php:174
 FreePBX\DB_Helper->getConfig() at /var/www/html/admin/modules/amd/Amd.class.php:86
 FreePBX\modules\Amd->getAmdSettings() at /var/www/html/admin/modules/amd/Amd.class.php:103
 FreePBX\modules\Amd->genConfig() at /var/www/html/admin/libraries/BMO/FileHooks.class.php:99
 FreePBX\FileHooks->processNewHooks() at /var/www/html/admin/libraries/BMO/FileHooks.class.php:28
 FreePBX\FileHooks->processFileHooks() at /var/www/html/admin/libraries/Console/Reload.class.php:340
 FreePBX\Console\Command\Reload->reload() at /var/www/html/admin/libraries/Console/Reload.class.php:95
 FreePBX\Console\Command\Reload->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:312
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:1022
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:314
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:168
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:163

In the past running fwconsole chown would fix it

 

[wardmundy]

‎Google Gemini

Meet Gemini, Google’s AI assistant. Get help with writing, planning, brainstorming, and more. Experience the power of generative AI.

gemini.google.com

 

[Samot]

SQLSTATE[HY000]: General error: 1712 Index kvstore_FreePBX_modules_Amd is corrupted

That is the problem. You may want to check all the tables.

 

[islandtech]

I tried all google suggestions
I'll follow up with gemini later
system is usable till closing time

 

[wardmundy]

CrownCloud provides free snapshot backups. Do you have one?? A restore would be the easy solution.

 

[islandtech]

yes I have a snapshot
no I didn't restore
Gemini suggested disabling the AMD module
I uninstalled it (not using any of its functions)
Restarted asterisk no errors