Меню
Что нового?

NDBCLUSTER: Got error 4350 'Transaction already aborted'

440hz

440hz

php.ru
NDBCLUSTER: Got error 4350 'Transaction already aborted'

Стали падать вот такие сообщения. Куда рыть?

таблица:
[sql]
CREATE TABLE IF NOT EXISTS `go_agents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8 AUTO_INCREMENT=15345 ;
[/sql]
запрос
[sql]INSERT
IGNORE
INTO
`go_agents`
(`id`,`name`)
VALUES
(NULL,'Mozilla/4.0 [подрезал длинную строку])')
[/sql]
ошибка
Код: 
MySQL error: [1296] Got error 4350 'Transaction already aborted' from NDBCLUSTER
mysql
Код: 
master(root):~#>mysql --version
mysql  Ver 14.14 Distrib 5.1.26-rc, for portbld-freebsd7.0 (amd64) using  5.2
С нескольких нод идет вставка в таблицу агентов. что бы не заморачиваться проверкой наличия записи делаю INSERT IGNORE и поле уникальный ключ.

Если есть другие, более правильные, варианты решения такой задачи - скажу большое спасибо

p.s. гуглил...

о! ваще посыплось!!!

[sql]ALTER TABLE `clients_orders` ENGINE = NDBCLUSTER[/sql]

Код: 
Ответ MySQL: 
#1025 - Error on rename of './ts/#sql-936b_55a1a' to './ts/clients_orders' (errno: 708)
 

MiksIr

miksir@home:~$
Transaction already aborted - это скорее всего вторичная ошибка, т.е. если в транзакции случилось что-то, она помечается отмененной и на каждый новый инсерт в этой же транзакии будет такое сообщение. Искать нужно исходную ошибку. Боше ничем не помогу ;)
 
440hz

440hz

php.ru
MiksIr
спасибо. а по этому нету мыслей?

mysql> use ts
Database changed
mysql> ALTER TABLE `clients_orders` engine = ndbcluster;
ERROR 1025 (HY000): Error on rename of './ts/#sql-936b_55a8e' to './ts/clients_orders' (errno: 708)
 

MiksIr

miksir@home:~$
./perror --ndb 708
OS error code 708: No more attribute metadata records (increase MaxNoOfAttributes):

После увеличения нужно сделать full rolling restart (я хз что это) =)
 
440hz

440hz

php.ru
О! нашел! Может кому поможет:
Код: 
master(root):/var/lib/mysql-cluster#>/usr/local/libexec/ndb_mgmd -P
[NDB_MGMD]
HostName=*.*.*.*
DataDir=/var/lib/mysql-cluster
NodeId=1
PortNumber=1186
ArbitrationRank=1
ArbitrationDelay=0
[NDBD]
HostName=*.*.*.*
DataDir=/var/lib/mysql-cluster
NoOfReplicas=2
TimeBetweenWatchDogCheck=30000
MaxNoOfOrderedIndexes=512
MaxNoOfAttributes=2048
DataMemory=1048576000
IndexMemory=104857600
NodeId=10
MaxNoOfTables=128
MaxNoOfUniqueHashIndexes=64
MaxNoOfIndexes=128
MaxNoOfConcurrentIndexOperations=8192
MaxNoOfTriggers=768
MaxNoOfFiredTriggers=4000
MaxNoOfSavedMessages=25
LockPagesInMainMemory=0
TimeBetweenWatchDogCheckInitial=6000
StopOnError=1
RestartOnErrorInsert=2
MaxNoOfConcurrentOperations=32768
BatchSizePerLocalScan=64
MaxNoOfConcurrentTransactions=4096
MaxNoOfConcurrentScans=256
TransactionBufferMemory=1048576
UndoIndexBuffer=2097152
UndoDataBuffer=16777216
RedoBuffer=8388608
LongMessageBuffer=1048576
DiskPageBufferMemory=67108864
SharedGlobalMemory=20971520
StartPartialTimeout=30000
StartPartitionedTimeout=60000
StartFailureTimeout=0
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500
TimeBetweenLocalCheckpoints=20
TimeBetweenGlobalCheckpoints=2000
NoOfFragmentLogFiles=16
FragmentLogFileSize=16777216
MaxNoOfOpenFiles=0
InitialNoOfOpenFiles=27
TimeBetweenInactiveTransactionAbortCheck=1000
TransactionInactiveTimeout=4294967039
TransactionDeadlockDetectionTimeout=1200
NoOfDiskPagesToDiskDuringRestartTUP=40
NoOfDiskPagesToDiskAfterRestartTUP=40
NoOfDiskPagesToDiskDuringRestartACC=20
NoOfDiskPagesToDiskAfterRestartACC=20
Diskless=0
ArbitrationTimeout=3000
LogLevelStartup=1
LogLevelShutdown=0
LogLevelStatistic=0
LogLevelCheckpoint=0
LogLevelNodeRestart=0
LogLevelConnection=0
LogLevelCongestion=0
LogLevelError=0
LogLevelInfo=0
ParallelBackups=1
DiskSyncSize=4194304
DiskCheckpointSpeed=10485760
DiskCheckpointSpeedInRestart=104857600
BackupMemory=4194304
BackupDataBufferSize=2097152
BackupLogBufferSize=2097152
BackupWriteSize=32768
BackupMaxWriteSize=262144
StringMemory=0
MaxAllocate=33554432
MemReportFrequency=0
ODirect=0
FileSystemPath=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster
[NDBD]
HostName=*.*.*.*
DataDir=/var/lib/mysql-cluster
NoOfReplicas=2
TimeBetweenWatchDogCheck=30000
MaxNoOfOrderedIndexes=512
MaxNoOfAttributes=2048
DataMemory=1048576000
IndexMemory=104857600
NodeId=11
MaxNoOfTables=128
MaxNoOfUniqueHashIndexes=64
MaxNoOfIndexes=128
MaxNoOfConcurrentIndexOperations=8192
MaxNoOfTriggers=768
MaxNoOfFiredTriggers=4000
MaxNoOfSavedMessages=25
LockPagesInMainMemory=0
TimeBetweenWatchDogCheckInitial=6000
StopOnError=1
RestartOnErrorInsert=2
MaxNoOfConcurrentOperations=32768
BatchSizePerLocalScan=64
MaxNoOfConcurrentTransactions=4096
MaxNoOfConcurrentScans=256
TransactionBufferMemory=1048576
UndoIndexBuffer=2097152
UndoDataBuffer=16777216
RedoBuffer=8388608
LongMessageBuffer=1048576
DiskPageBufferMemory=67108864
SharedGlobalMemory=20971520
StartPartialTimeout=30000
StartPartitionedTimeout=60000
StartFailureTimeout=0
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500
TimeBetweenLocalCheckpoints=20
TimeBetweenGlobalCheckpoints=2000
NoOfFragmentLogFiles=16
FragmentLogFileSize=16777216
MaxNoOfOpenFiles=0
InitialNoOfOpenFiles=27
TimeBetweenInactiveTransactionAbortCheck=1000
TransactionInactiveTimeout=4294967039
TransactionDeadlockDetectionTimeout=1200
NoOfDiskPagesToDiskDuringRestartTUP=40
NoOfDiskPagesToDiskAfterRestartTUP=40
NoOfDiskPagesToDiskDuringRestartACC=20
NoOfDiskPagesToDiskAfterRestartACC=20
Diskless=0
ArbitrationTimeout=3000
LogLevelStartup=1
LogLevelShutdown=0
LogLevelStatistic=0
LogLevelCheckpoint=0
LogLevelNodeRestart=0
LogLevelConnection=0
LogLevelCongestion=0
LogLevelError=0
LogLevelInfo=0
ParallelBackups=1
DiskSyncSize=4194304
DiskCheckpointSpeed=10485760
DiskCheckpointSpeedInRestart=104857600
BackupMemory=4194304
BackupDataBufferSize=2097152
BackupLogBufferSize=2097152
BackupWriteSize=32768
BackupMaxWriteSize=262144
StringMemory=0
MaxAllocate=33554432
MemReportFrequency=0
ODirect=0
FileSystemPath=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster
[MYSQLD]
NodeId=20
HostName=
ArbitrationRank=0
ArbitrationDelay=0
MaxScanBatchSize=262144
BatchByteSize=32768
BatchSize=64
[MYSQLD]
NodeId=21
HostName=
ArbitrationRank=0
ArbitrationDelay=0
MaxScanBatchSize=262144
BatchByteSize=32768
BatchSize=64
[MYSQLD]
NodeId=22
HostName=
ArbitrationRank=0
ArbitrationDelay=0
MaxScanBatchSize=262144
BatchByteSize=32768
BatchSize=64
[MYSQLD]
NodeId=23
HostName=
ArbitrationRank=0
ArbitrationDelay=0
MaxScanBatchSize=262144
BatchByteSize=32768
BatchSize=64
[TCP]
NodeId1=10
NodeId2=11
HostName1=78.140.142.20
HostName2=78.140.142.23
NodeIdServer=10
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=20
NodeId2=10
HostName1=
HostName2=78.140.142.20
NodeIdServer=10
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=20
NodeId2=11
HostName1=
HostName2=78.140.142.23
NodeIdServer=11
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=21
NodeId2=10
HostName1=
HostName2=78.140.142.20
NodeIdServer=10
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=21
NodeId2=11
HostName1=
HostName2=78.140.142.23
NodeIdServer=11
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=22
NodeId2=10
HostName1=
HostName2=78.140.142.20
NodeIdServer=10
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=22
NodeId2=11
HostName1=
HostName2=78.140.142.23
NodeIdServer=11
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=23
NodeId2=10
HostName1=
HostName2=78.140.142.20
NodeIdServer=10
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=23
NodeId2=11
HostName1=
HostName2=78.140.142.23
NodeIdServer=11
PortNumber=0
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=1
NodeId2=10
HostName1=78.140.142.21
HostName2=78.140.142.20
NodeIdServer=1
PortNumber=1186
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
[TCP]
NodeId1=1
NodeId2=11
HostName1=78.140.142.21
HostName2=78.140.142.23
NodeIdServer=1
PortNumber=1186
Group=55
SendSignalId=1
Checksum=0
SendBufferMemory=262144
ReceiveBufferMemory=65536
-~{}~ 04.12.08 17:37:

собственно поправил конфиг. перезапустил кластер.
все пашет.
 
Войдите или зарегистрируйтесь для ответа.
Сверху