Re: Create Table Partition By xx - causes hung client.
I've created a trace & guess I've found the culprit...
The lines 1/2 way down with
'error: Write only -1 bytes, error: 9'
I would wildly guess it to be an issue with allocating the phyiscal tables.
T@6 : | query: CREATE TABLE test1 (
id INT NOT NULL DEFAULT 0,
seg INT NOT NULL DEFAULT 0,
PRIMARY KEY (id) )
PARTITION BY HASH(id) PARTITIONS 10
T@6 : | >mysql_parse
T@6 : | | >mysql_init_query
T@6 : | | | >lex_start
T@6 : | | | | >alloc_root
T@6 : | | | | | enter: root: 0x1807060
T@6 : | | | | | exit: ptr: 0x17fa488
T@6 : | | | | <alloc_root
T@6 : | | | <lex_start
T@6 : | | | >mysql_reset_thd_for_next_command
T@6 : | | | <mysql_reset_thd_for_next_command
T@6 : | | <mysql_init_query
.
.
.
T@6 : | | | | | >are_partitions_in_table
T@6 : | | | | | | enter: 10
T@6 : | | | | | | info: p0
T@6 : | | | | | | info: p1
T@6 : | | | | | | info: p2
T@6 : | | | | | | info: p3
T@6 : | | | | | | info: p4
T@6 : | | | | | | info: p5
T@6 : | | | | | | info: p6
T@6 : | | | | | | info: p7
T@6 : | | | | | | info: p8
T@6 : | | | | | | info: p9
T@6 : | | | | | <are_partitions_in_table
T@6 : | | | | | >_mymalloc
T@6 : | | | | | | enter: Size: 40
T@6 : | | | | | | exit: ptr: 0x17ea098
T@6 : | | | | | <_mymalloc
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | info: engine = 9
T@6 : | | | | | >check_engine_mix
T@6 : | | | | | <check_engine_mix
T@6 : | | | | | >_myfree
T@6 : | | | | | | enter: ptr: 0x17ea098
T@6 : | | | | | <_myfree
T@6 : | | | | <check_partition_info
T@6 : | | | | >generate_partition_syntax
T@6 : | | | | | >create_temp_file
T@6 : | | | | | | >my_create
T@6 : | | | | | | | my: Name: 'c:\data\temp\psy7' CreateFlags: 0 AccessFlags: 1024 MyFlags: 0
T@6 : | | | | | | <my_create
T@6 : | | | | | | >_mymalloc
T@6 : | | | | | | | enter: Size: 18
T@6 : | | | | | | | exit: ptr: 0x17ea098
T@6 : | | | | | | <_mymalloc
T@6 : | | | | | | exit: fd: 18
T@6 : | | | | | <create_temp_file
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2138 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0xa98a64 Count: 13 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c20c4 Count: 4 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2138 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2144 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x17fa445 Count: 2 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2140 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2138 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c29a8 Count: 11 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0xa98a64 Count: 2 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_write
T@6 : | | | | | | my: Fd: 18 Buffer: 0x8c2138 Count: 1 MyFlags: 0
T@6 : | | | | | | error: Write only -1 bytes, error: 9
T@6 : | | | | | <my_write
T@6 : | | | | | >my_close
T@6 : | | | | | | my: fd: 18 MyFlags: 0
T@6 : | | | | | | >_myfree
T@6 : | | | | | | | enter: ptr: 0x17ea098
T@6 : | | | | | | <_myfree
T@6 : | | | | | <my_close
T@6 : | | | | <generate_partition_syntax
Subject
Views
Written By
Posted
4083
February 22, 2006 02:58PM
3236
February 23, 2006 09:00AM
2589
February 23, 2006 07:07PM
Re: Create Table Partition By xx - causes hung client.
2542
February 24, 2006 03:47PM
2707
February 23, 2006 12:22PM
2342
February 23, 2006 03:56PM
2297
April 17, 2006 01:43AM
2137
April 17, 2006 11:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.