6.0.0-git
2019-04-24

[#5446] Problem in create.mysql.sql
Summary Problem in create.mysql.sql
Queue Horde Groupware Webmail Edition
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester helmut (at) 4schiefer (dot) de
Created 2007-06-07 (4339 days ago)
Due 06/08/2007 (4338 days ago)
Updated 2007-06-07 (4339 days ago)
Assigned 2007-06-07 (4339 days ago)
Resolved 2007-06-07 (4339 days ago)
Milestone
Patch No

History
2007-06-07 18:40:35 helmut (at) 4schiefer (dot) de Comment #14 Reply to this comment
You just need to change the table name in your sql sessions
configuration (in horde/config/conf.php). If you don't use sql-based
sessions then you don't need to do anything, and you don't even need
this table.
Thanks for your help
2007-06-07 18:29:39 Chuck Hagenbuch Comment #13 Reply to this comment
You just need to change the table name in your sql sessions 
configuration (in horde/config/conf.php). If you don't use sql-based 
sessions then you don't need to do anything, and you don't even need 
this table.
2007-06-07 18:08:09 helmut (at) 4schiefer (dot) de Comment #12 Reply to this comment
Thanks for your help. In the next days i'll ask my provider for an 
update of mysql.

One more question: If i'll use the name horde_sessions - what i have to do?



must i do a grep of all php and then change the name?



Thanks for your help and greetings from cologne.

[Show Quoted Text - 10 lines]
2007-06-07 18:02:23 Chuck Hagenbuch Comment #11
State ⇒ Not A Bug
Reply to this comment
I'm guessing there's a limit on table name length or something in 4.1 
with innodb. So just use a different table name for now.



You can also upgrade to MySQL 5 (which is probably a good idea 
anyway), or at least the latest 4.1 release (22, I think) which might 
remove the limitation.



Since you can always use a different table name I don't think there's 
much else we should do here; if it's a big problem "horde_sessions" 
might be an okay name if that one works.
2007-06-07 17:51:38 helmut (at) 4schiefer (dot) de Comment #10 Reply to this comment
I can't reproduce this at all. What MySQL version are you using?
Linux: SUSE 9.3



YAST say mysql: 4.1.10a




2007-06-07 17:49:13 Chuck Hagenbuch Comment #9 Reply to this comment
I can't reproduce this at all. What MySQL version are you using?
2007-06-07 17:37:15 helmut (at) 4schiefer (dot) de Comment #8 Reply to this comment
It's an interesting problem.

I try the following:

mysql> create table a (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

Query OK, 0 rows affected (0.01 sec)



mysql> rename table a to  horde_sessionhandler;

ERROR 1025 (HY000): Error on rename of './horde/a' to 
'./horde/horde_sessionhandler' (errno: 121)

mysql>


2007-06-07 17:25:01 helmut (at) 4schiefer (dot) de Comment #7 Reply to this comment
I do the same statement but i don't create a table called: 
horde_sessionhandler

I name it: a



So i do:

mysql> create table a (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

Query OK, 0 rows affected (0.01 sec)



So I think it's the name. Any idea?
2007-06-07 17:12:19 helmut (at) 4schiefer (dot) de Comment #6 Reply to this comment
Then what is the output of show engine innodb status after you try
creating the table _with_ the engine=innodb statement?
One more comment: Overall I think innodb works.

I try:

mysql> CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

Query OK, 0 rows affected (0.01 sec)


2007-06-07 16:59:59 helmut (at) 4schiefer (dot) de Comment #5 Reply to this comment
Then what is the output of show engine innodb status after you try
creating the table _with_ the engine=innodb statement?
Sorry, very long:

mysql> CREATE TABLE horde_sessionhandler (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

ERROR 1005 (HY000): Can't create table 
'./horde/horde_sessionhandler.frm' (errno: 121)

mysql> show engine innodb status;

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Status                                                               
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                              |

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

|

=====================================

070607 18:58:14 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 30 seconds

----------

SEMAPHORES

----------

OS WAIT ARRAY INFO: reservation count 9, signal count 9

Mutex spin waits 4, rounds 80, OS waits 0

RW-shared spins 19, OS waits 9; RW-excl spins 1, OS waits 0

------------

TRANSACTIONS

------------

Trx id counter 0 8229

Purge done for trx's n:o < 0 7035 undo n:o < 0 0

History list length 4

Total number of lock structs in row lock hash table 0

LIST OF TRANSACTIONS FOR EACH SESSION:

---TRANSACTION 0 0, not started, process no 13821, OS thread id 1099000752

MySQL thread id 6, query id 113 localhost root

show engine innodb status

--------

FILE I/O

--------

I/O thread 0 state: waiting for i/o request (insert buffer thread)

I/O thread 1 state: waiting for i/o request (log thread)

I/O thread 2 state: waiting for i/o request (read thread)

I/O thread 3 state: waiting for i/o request (write thread)

Pending normal aio reads: 0, aio writes: 0,

  ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0

Pending flushes (fsync) log: 0; buffer pool: 0

39 OS file reads, 33 OS file writes, 32 OS fsyncs

0.00 reads/s, 0 avg bytes/read, 0.13 writes/s, 0.13 fsyncs/s

-------------------------------------

INSERT BUFFER AND ADAPTIVE HASH INDEX

-------------------------------------

Ibuf for space 0: size 1, free list len 0, seg size 2, is empty

Ibuf for space 0: size 1, free list len 0, seg size 2,

0 inserts, 0 merged recs, 0 merges

Hash table size 34679, used cells 0, node heap has 0 buffer(s)

0.00 hash searches/s, 0.03 non-hash searches/s

---

LOG

---

Log sequence number 0 661038

Log flushed up to   0 661038

Last checkpoint at  0 661038

0 pending log writes, 0 pending chkp writes

23 log i/o's done, 0.07 log i/o's/second

----------------------

BUFFER POOL AND MEMORY

----------------------

Total memory allocated 18300220; in additional pool allocated 892800

Buffer pool size   512

Free buffers       479

Database pages     33

Modified db pages  0

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages read 33, created 0, written 8

0.00 reads/s, 0.00 creates/s, 0.03 writes/s

Buffer pool hit rate 1000 / 1000

--------------

ROW OPERATIONS

--------------

0 queries inside InnoDB, 0 queries in queue

Main thread process no. 13821, id 1105480624, state: waiting for 
server activity

Number of rows inserted 0, updated 0, deleted 0, read 12

0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

----------------------------

END OF INNODB MONITOR OUTPUT

============================

  |

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)


2007-06-07 16:55:17 Chuck Hagenbuch Comment #4 Reply to this comment
Then what is the output of show engine innodb status after you try 
creating the table _with_ the engine=innodb statement?
2007-06-07 16:50:06 helmut (at) 4schiefer (dot) de Comment #3 Reply to this comment
Hi,



if i create the table without the "engine=innodb" the statement works fine.

After that i do a "show engine innodb status" there is a ouput. So i 
think innodb is installed.
2007-06-07 16:09:54 Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
Do you have innodb support in MySQL?
2007-06-07 15:43:30 helmut (at) 4schiefer (dot) de Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Summary ⇒ Problem in create.mysql.sql
Due ⇒ 2007-06-08
Queue ⇒ Horde Groupware Webmail Edition
Reply to this comment
Dear guys,



hope that's the right place to ask these question. I've search the 
internet and i didn't find an answer. So i think there is a bug in the 
create.mysql.sql.



I run the script with following command:

mysql -u root -p < create.mysql.sql



I got the message:

ERROR 1005 (HY000) at line 154: Can't create table 
'./horde/horde_sessionhandler.frm' (errno: 121)



Any idea with problem?



- Sorry for my english - I hope it works and thanks for any help.

Helmut




Saved Queries