[msql-list] mSQL errors
Doug Hardie
not seem to exhibit this error (at least on a few dozen tests each).
I rebuild the ledger table (dump-restore) and now it seems not to have
the error. However, this is only a short test at this point. The
ledger table is by far the largest table I have. Its not that large
by database standards though. There is less than 34,656 records in it.
> 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/