List:Cluster« Previous MessageNext Message »
From:Hoggins! Date:July 26 2013 2:15pm
Subject:Re: Error writing BLOB data to cluster
View as plain text  
On bothnodes, I get the following error in the logs :

2013-07-26 16:12:13 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci:
329690279575560 nodes:
0000000000000000000000000000000000000000000000000018000000000000
2013-07-26 16:12:13 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 76762/8)
ref: 0fa20034 from: 0fa20034

Le 26/07/2013 11:30, Andrew Morgan a écrit :
> The first step should be to take a look at the cluster and data node logs to see why
> one of the data nodes appears to be failing.
>
> Andrew.
>
>> -----Original Message-----
>> From: Hoggins! [mailto:fuckspam@stripped]
>> Sent: 25 July 2013 18:20
>> To: cluster@stripped
>> Subject: Error writing BLOB data to cluster
>>
>> Hello everyone,
>>
>> New to this list, as I'm setting up aMySQL Cluster and having problems
>> inserting existing data into it.
>> The cluster seems to work correctly, and creating"simple" tables with
>> text data is ok. Both of my nodes have the data, and I can access it
>> through two SQL nodes.
>>
>> But I'm trying to import data from an already running MySQL instance to
>> my MySQL Cluster, and it fails.
>> My table stores BLOB values. When I try to import the dump, it fails,
>> never on the same record, with the following error :
>>
>> ERROR 1297 (HY000) at line 1138: Got temporary error 4010 'Node failure
>> caused abort of transaction' from NDBCLUSTER
>> mysqldump: Got errno 32 on write
>>
>> I was previously randomly getting lock errors, but I increased the
>> valueof the timeout considering the lock dead, and the above is now the
>> only error I getwhen I try to import this table to my cluster.
>>
>> The biggestof the rows is approx 5MB. But the insert does not even fail
>> on one of the biggest records.
>>
>> Does anyone have an idea?
>>
>> I'm sure I'm missing something, and I'd like to move forward, as this
>> is the only missing step for a fully functionnal cluster on my side.
>>
>> FYI, the log shows the same error on both nodes :
>>
>> 2013-07-25 19:18:09 2653 [Note] NDB Binlog: Node: 1, down, Subscriber
>> bitmask 00
>> 2013-07-25 19:18:09 2653 [Note] NDB Binlog: Node: 2, down, Subscriber
>> bitmask 00
>> 2013-07-25 19:18:09 2653 [Note] NDB Binlog: cluster failure for
>> ./mysql/ndb_schema at epoch 40235/0.
>> 2013-07-25 19:18:09 2653 [Note] NDB Binlog: cluster failure for
>> ./mysql/ndb_apply_status at epoch 40235/0.
>>
>> Thanks for your help !
>>
>> --
>> MySQL Cluster Mailing List
>> For list archives: http://lists.mysql.com/cluster
>> To unsubscribe:    http://lists.mysql.com/cluster
>>

Thread
Error writing BLOB data to clusterHoggins!25 Jul
  • RE: Error writing BLOB data to clusterAndrew Morgan26 Jul
    • Re: Error writing BLOB data to clusterHoggins!26 Jul
      • Re: Error writing BLOB data to clusterHoggins!2 Aug