Topic: 90saildb_create Error 1069

[ldkeen]

Just upgraded to 2.3.1-9 and I get the following when booting:
Jun 20 16:30:37 server 90saildb_create: ERROR 1069 (42000) at line 30: Too many keys specified; max 64 keys allowed
Jun 20 16:30:37 server mysql.init: Loading 90saildb_create into mysql failed
CDR seems to be working OK.
Lloyd

[SARK devs]

Hmmm that is a new one on us.  We've never seen that error before. 


Is it reproduceable or did it just happen that once?  90saildb_create should only run after a post-upgrade.

the build SQL is in /home/selintra/stat/asterisk-stat-v2/cdr-mysql-setup.sql

It isn't our code, it's just the build SQL that comes with the Areski Stats package, we don't actually do anything with it other than run it.  I've just run it here and it seems to be OK if I run it by copying and pasting it into the mysql CLI.  If I just run it with mysql < then it seems to finish but then close the bash session.  No errors in the logs... very strange.

Best

Jeff 

[ldkeen]

Hey Jeff

Is it reproduceable or did it just happen that once?

Yes it happens every time I reboot the machine (whether after a post-upgrade or normal reboot). I've just upgraded to 2.3.1-13 but still getting the error. Here's what happens if I run it from the CLI:

Code: [Select]

[root@server asterisk-stat-v2]# mysql < cdr-mysql-setup.sql
ERROR 1069 (42000) at line 30: Too many keys specified; max 64 keys allowed
[root@server asterisk-stat-v2]#The machine is a new machine that has been risen from an affa backup. It all seems to be working OK so I'm not that worried.
Many Thanks,
Lloyd

[SARK devs]

Yes it happens every time I reboot

Then I think that something is not quite correct on your SME server.  The mySQL routine is stitched into the normal SME post-upgrade/migrate processing.  If it is running every time your machine reboots then there is something wrong somewhere.

To stop the mySQL create (you don't actually need to run it more than once), simply move 90saildb_create into another directory.  I have put a fix into the next point release to automatically move it once it has run.

Jeff