#16 1.0 RC2 mysql db fails to init

closed-works-for-me
nobody
None
9
2005-10-03
2005-09-24
hans_de
No

Test:
Setup clean system on fresh empty db

Versions:
1.0 RC2, mysql
C:\>mysqladmin --version
mysqladmin Ver 8.41 Distrib 4.1.14, for Win32 on ia32

Failure.
init DB stops here.
(log from tomcat.log)
----------------------------
alter table format
add index FKB45FF7F740A222C9 (format_id),
add constraint FKB45FF7F740A222C9
foreign key (format_id)
references BooleanMetadata (FIELD_METADATA_ID)
create table hibernate_unique_key (
next_hi integer
)
last step --> insert into hibernate_unique_key values ( 0 )
---------------------------------------

Best regards
Hans

Discussion

  • hans_de

    hans_de - 2005-09-24
    • priority: 5 --> 9
     
  • hans_de

    hans_de - 2005-09-24

    Logged In: YES
    user_id=1342391

    I forgot hibernate config:
    --------------
    <property
    name="connection.url">jdbc:mysql://localhost:3306/trackit_db_prod</property>

    <property name="connection.username">root</property>

    <property name="connection.password">root</property>

    <property
    name="connection.driver_class">com.mysql.jdbc.Driver</property>

    <property
    name="dialect">org.hibernate.dialect.MySQLDialect</property>

    <property name="hbm2ddl.auto">update</property>

    <property name="hibernate.connection.pool_size">50</property>

    <property name="show_sql">false</property>
    ---------------
    mapping not changed

     
  • hans_de

    hans_de - 2005-09-25

    Logged In: YES
    user_id=1342391

    Also important to know:
    within trackit.log, I don't have any error message.
    I couln't figure out exactly, why I stops at this point.
    It is not a connection problem (e.g. not enought free
    connections)
    on another mylsq server (3.x) the same problem appears.
    Maybe there's a solution in reconfiguring
    hibernate mysql connection, but I couldn't figure it out
    exactly.

     
  • Chris Bozic

    Chris Bozic - 2005-10-03
    • status: open --> closed-works-for-me
     
  • Chris Bozic

    Chris Bozic - 2005-10-03

    Logged In: YES
    user_id=1042211

    Thanks for posting this but we are unable to duplicate this
    problem using the version of mysql you mentioned.

     

Log in to post a comment.