I just upgraded from a uni-processor to a multi-processor system. I
am running FreeBSD 7.0 with mSQL-3.8. I am now getting intermittent
msql errors like:

Query of table failed SELECT * FROM ledger where ledger=34656 -
Unknown field "ledger"

the first part is the actual query and the last part is msqlErrMsg.
These are intermittent as the same query done repeatedly will fail
about half the time and work the other half. These errors did not
occur with FreeBSD 6.2 on a uni-processor. msql.conf is:

[general]

Inst_Dir = /usr/local/msql3
DB_Dir = /msqldb
mSQL_User = daemon
Admin_User = root
Pid_File = /msql3d.pid
TCP_Port = 1114
UNIX_Port = /msql3.sock

[system]

Num_Children = 5
Msync_Timer = 30
Host_Lookup = True
Read_Only = False
Remote_Access = TRUE
Local_Access = True
Force_Munmap = False
Query_Log = False
Query_Log_File = /query.log
Update_Log = False
Update_Log_File = /update.log
Table_Cache = 8
Sort_Max_Mem = 1000



-----------------------------------------------------------------
This is the Mini SQL Mailing List operated by Hughes Technologies
To unsubscribe, go to http://www.Hughes.com.au/extras/email/