MySQL Forums
Forum List  »  Partitioning

Re: Create Table Partition By xx - causes hung client.
Posted by: J Jorgenson
Date: February 24, 2006 03:47PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Create Table Partition By xx - causes hung client.
2359
February 24, 2006 03:47PM


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.