Hi!
Probably a deadlock situation, but for only one stmt this seems like
you might have run into a bug. What is the statement and how are your
tables defined/what data do they contain?
BR
-- Martin
ch huang wrote:
> i have a huge data about one table,when i insert the data to DB in one sql
> node ,i get the error
>
> mysqlimport: Error: 1205, Lock wait timeout exceeded; try restarting
> transaction, when using table: trade
>
> also the another box that host the one data node disconnected
>
> is that the reason that the buffer memory i set using hold the data for
> transfer is too low that cause the error??
> here is my setting config.ini
>
>
> [TCP DEFAULT]
> SendBufferMemory=4M
> ReceiveBufferMemory=4M
>
> [NDB_MGMD DEFAULT]
> PortNumber=1186
> Datadir=/data/cluster7.0.7/
>
> [NDB_MGMD]
> Id=1
> Hostname=172.16.20.210
> LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
> ArbitrationRank=1
>
> [NDBD DEFAULT]
> NoOfReplicas=2
> Datadir=/var/ndbdata/cluster7.0.7/
> FileSystemPathDD=/var/ndbdata/cluster7.0.7/fsDD/
> FileSystemPathUndoFiles=/var/ndbdata/cluster7.0.7/undoFILE/
> FileSystemPathDataFiles=/var/ndbdata/cluster7.0.7/dataFILE/
> DataMemory=8192M
> IndexMemory=1024M
> LockPagesInMainMemory=0
>
> MaxNoOfConcurrentOperations=100000
>
> StringMemory=25
> MaxNoOfTables=20000
> MaxNoOfOrderedIndexes=10000
> MaxNoOfUniqueHashIndexes=2500
> MaxNoOfAttributes=120000
> DiskCheckpointSpeedInRestart=100M
> FragmentLogFileSize=256M
> InitFragmentLogFiles=FULL
> NoOfFragmentLogFiles=48
> RedoBuffer=32M
>
> TimeBetweenLocalCheckpoints=20
> TimeBetweenGlobalCheckpoints=1000
> TimeBetweenEpochs=100
>
> MemReportFrequency=30
> BackupReportFrequency=10
>
> ### Params for setting logging
> LogLevelStartup=15
> LogLevelShutdown=15
> LogLevelCheckpoint=8
> LogLevelNodeRestart=15
>
> ### Params for increasing Disk throughput
> BackupMaxWriteSize=1M
> BackupDataBufferSize=16M
> BackupLogBufferSize=4M
> BackupMemory=20M
> #Reports indicates that odirect=1 can cause io errors (os err code 5) on
> some systems. You must test.
> #ODirect=1
>
> ### Watchdog
> TimeBetweenWatchdogCheckInitial=60000
>
> ### TransactionInactiveTimeout - should be enabled in Production
> #TransactionInactiveTimeout=30000
> ### CGE 6.3 - REALTIME EXTENSIONS
> #RealTimeScheduler=1
> ### DISK DATA
> SharedGlobalMemory=384M
> #read my blog how to set this:
> DiskPageBufferMemory=8192M
> BatchSizePerLocalScan=512
> [NDBD]
> Id=2
> Hostname=172.16.2.44
> [MYSQLD DEFAULT]
> BatchSize=512
> BatchByteSize=2048
> #MaxScanBatchSize=2048
>
> most of the config data produced by the tool configurator
>
