Bug #26487 | Bug in extent/page allocation when *using* >1gb datafiles | ||
---|---|---|---|
Submitted: | 20 Feb 2007 4:51 | Modified: | 9 Mar 2007 1:53 |
Reporter: | Tomas Ulin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Disk Data | Severity: | S3 (Non-critical) |
Version: | 5.1 | OS: | |
Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[20 Feb 2007 4:51]
Tomas Ulin
[20 Feb 2007 4:51]
Tomas Ulin
config.ini
Attachment: config.ini (application/octet-stream, text), 773 bytes.
[20 Feb 2007 4:54]
Tomas Ulin
truncated trace log
Attachment: ndb_1_trace.log.1.gz (application/x-tar, text), 5.26 KiB.
[20 Feb 2007 4:55]
Tomas Ulin
cluster log looks norma 2007-02-20 11:34:25 [MgmSrvr] INFO -- Node 1: Local checkpoint 82 started. Keep GCI = 4062 oldest restorable GCI = 4065 2007-02-20 11:34:44 [MgmSrvr] INFO -- Node 1: Local checkpoint 83 started. Keep GCI = 4095 oldest restorable GCI = 4098 2007-02-20 11:34:59 [MgmSrvr] INFO -- Node 1: Data usage is 61%(1573 32K pages of total 2560) 2007-02-20 11:34:59 [MgmSrvr] INFO -- Node 1: Index usage is 55%(1711 8K pages of total 3104) 2007-02-20 11:34:59 [MgmSrvr] INFO -- Node 1: Resource 0 min: 0 max: 639 curr: 268 2007-02-20 11:34:59 [MgmSrvr] INFO -- Node 1: Resource 1 min: 0 max: 0 curr: 3 2007-02-20 11:34:59 [MgmSrvr] INFO -- Node 1: Resource 2 min: 0 max: 0 curr: 9 2007-02-20 11:35:06 [MgmSrvr] INFO -- Node 1: Local checkpoint 84 started. Keep GCI = 4121 oldest restorable GCI = 4124 2007-02-20 11:35:27 [MgmSrvr] INFO -- Node 1: Local checkpoint 85 started. Keep GCI = 4156 oldest restorable GCI = 4159 2007-02-20 11:35:33 [MgmSrvr] ALERT -- Node 2: Node 1 Disconnected 2007-02-20 11:35:35 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 freed, m_reserved_nodes 00000000000000000000000000000000000 0000000000000000000000000000c. 2007-02-20 11:35:36 [MgmSrvr] ALERT -- Node 1: Forced node shutdown completed. Initiated by signal 6. Caused by error 2341: 'I nternal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Tempo rary error, restart node'.
[20 Feb 2007 4:59]
Tomas Ulin
cluster comes up alright after system restart master> select count(*) from TEST_DB.SUBS_DATA; +----------+ | count(*) | +----------+ | 959196 | +----------+ 1 row in set (0.06 sec)
[20 Feb 2007 5:05]
Tomas Ulin
master> select `FILES`.`FILE_NAME` AS `FILE_NAME`,(`FILES`.`TOTAL_EXTENTS` * `FILES`.`EXTENT_SIZE`) AS `Total`,(`FILES`.`FREE_EXTENTS` * `FILES`.`EXTENT_SIZE`) AS `Free`,(((`FILES`.`FREE_EXTENTS` * `FILES`.`EXTENT_SIZE`) * 100) / (`FILES`.`TOTAL_EXTENTS` * `FILES`.`EXTENT_SIZE`)) AS `% Free`,`FILES`.`EXTRA` AS `EXTRA` from `INFORMATION_SCHEMA`.`FILES` where ((`FILES`.`ENGINE` = _utf8'ndbcluster') and (`FILES`.`FILE_TYPE` = _utf8'DATAFILE')) order by `FILES`.`FILE_NAME`,`FILES`.`EXTRA`; +-------------------+------------+------------+---------+----------------+ | FILE_NAME | Total | Free | % Free | EXTRA | +-------------------+------------+------------+---------+----------------+ | data_preprov1.dat | 4294967296 | 2865758208 | 66.7236 | CLUSTER_NODE=1 | +-------------------+------------+------------+---------+----------------+
[20 Feb 2007 5:07]
Tomas Ulin
(after restart) tomas@poseidon:~/mysql-5.1-telco-6.1_2/storage/ndb/test> ../tools/ndb_desc lg_preprov1 Type: LogfileGroup Name: lg_preprov1 UndoBuffer size: 8388608 Version: 1 Free Words: 7320072 AutoGrow.min_free: 0 AutoGrow.max_size: 0 AutoGrow.file_size: 0 AutoGrow.filename_pattern: (null) NDBT_ProgramExit: 0 - OK tomas@poseidon:~/mysql-5.1-telco-6.1_2/storage/ndb/test> ../tools/ndb_desc ts_prepov1 Type: Tablespace Name: ts_prepov1 Object Version: 1 Extent Size: 1048576 Default Logfile Group: lg_preprov1 NDBT_ProgramExit: 0 - OK tomas@poseidon:~/mysql-5.1-telco-6.1_2/storage/ndb/test> ../tools/ndb_desc data_preprov1.dat Type: Datafile Name: data_preprov1.dat Node: 1 Path: data_preprov1.dat Size: 4294967296 Free: 2865758208 Tablespace: ts_prepov1 NDBT_ProgramExit: 0 - OK tomas@poseidon:~/mysql-5.1-telco-6.1_2/storage/ndb/test> ../tools/ndb_desc undo_preprov1.dat Type: Undofile Name: undo_preprov1.dat Node: 1 Path: undo_preprov1.dat Size: 33554432 Logfile Group: lg_preprov1 NDBT_ProgramExit: 0 - OK
[20 Feb 2007 5:11]
Tomas Ulin
information schema select (after restart)
Attachment: information_schema.txt (text/plain), 3.34 KiB.
[20 Feb 2007 5:20]
Tomas Ulin
ndb_1_out lots of stuff written there....
Attachment: ndb_1_out.log.gz (application/x-tar, text), 65.38 KiB.
[21 Feb 2007 13:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/20263 ChangeSet@1.2417, 2007-02-21 14:40:15+01:00, jonas@eel.(none) +1 -0 ndb - bug#26487 fix bug in extent/page allocation when *using* >1gb datafiles
[21 Feb 2007 18:17]
Jonas Oreland
pushed to 5.1-ndb, telco-6.1, 5.1-telco
[27 Feb 2007 6:27]
Jon Stephens
Documented bugfix in telco-5.1.15/6.1.3 changelog; left bug status unchanged.
[8 Mar 2007 16:46]
Tomas Ulin
5.1.17
[9 Mar 2007 1:53]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html Documented bugfix in 5.1.17 changelog; closed.