Topic: Strategy column missing from route table

[compsos]

Hi Jeff
After updating to 3.1.1.39 we could not dial out. Do not know about in.

In the cli we had errors about

Code: [Select]

sarkhpe,OutRoute,wdp1,,: Database Prepare failed, retval is 1, query is SELECT auth,path1,path2,path3,path4,alternate,strategy FROM Route WHERE pkey='wdp1'
Running the query from the console showed the following

Code: [Select]

# sqlite3 sark.db "SELECT auth,path1,path2,path3,path4,alternate,strategy FROM Route WHERE pkey='wdp1'"
Error: no such column: strategy
without 'strategy'

Code: [Select]

# sqlite3 sark.db "SELECT auth,path1,path2,path3,path4,alternate FROM Route WHERE pkey='wdp1'"
NO|61740840650|61740580623|61990180256|DAHDIGroup5|
We have added the added the column. It appears 'strategy' is normally used in queues (ie) ringall. Please advise if we should modify somewhere else and return DB to normal.

Thanks

[SARK devs]

HI

The strategy column was added to the routes table in 3.1.1-29.   You will (or should) find the SQL fragment in /opt/sark/amacs/r1997.  Please check that this fragment exists in your release.  If it does not then we may have a problem with the rpm.   

You can leave the strategy you added manually as long as you defined it as TEXT.

Kind Regards

S

 

   

[compsos]

Hi Jeff
Yes the SQL statement is there but what should have fired it off as the column was not in the DB

Code: [Select]

ALTER TABLE route ADD COLUMN strategy TEXT;

[SARK devs]

When the rpm runs it should run a script called updatedb.sh which you will find in /opt/sark/scripts.     The script is idempotent (now there's a word that tells me I should get out more), it simply means that you can run the script as often as you like without breaking anything..

Code: [Select]

sh /opt/sark/scripts/updatedb.sh
It will generate lots of error messages - but in this case, that's a good thing.

Kind Regards

S

[compsos]

Hi Jeff
Yes to get out is a good idea. Actually leaving today for Switzerland but can you turn on some better weather!!!

The link is sh /opt/sark/scripts/update_db.sh with the underscore. But why would it not have run during the 3.1.1-27 to 3.1.1-39 or left out the column? The console sql statements show that it was not there.

Thanks