0002568: log_ CREATE error on startup

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002568

[Resin]

minor

always

04-01-08 09:52

04-08-08 16:58

Reporter

sam

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.6

Product Version

3.1.6

Product Build

Summary

0002568: log_ CREATE error on startup

Description

(rep by wesley)

These lines in resin.conf will cause the problem:

<management path="${resin.root}/admin">
   <user name="admin" password="password" disable="true"/>

   <resin:if test="${resin.professional}">
     <deploy-service enable="true"/>
     <jmx-service enable="true"/>
     <log-service enable="true"/>
     <xa-log-service enable="true"/>
   </resin:if>
</management>

The first time I start the server, everything works fine.

But If I restart it, I get an error:

C:\resin-pro-3.1\conf\resin.conf:21: java.sql.SQLException: Table 'log_'
already
exists. CREATE can not override an existing table.

19: - Remote management requires at least one enabled admin user.
20: -->
21: <management path="${resin.root}/admin">
22: <user name="admin" password="password" disable="true"/>
23:

If I manually delete the two logs files in ${resin.root}/admin/log and start
resin again, it started with no error.

I think this problem is a bit like 0002065

The s080321 and s080331 snapshot both produce this problem

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0002949) ferg 04-08-08 16:58	db/0153

Issue History
Date Modified	Username	Field	Change
04-01-08 09:52	sam	New Issue
04-01-08 10:12	stbu	Issue Monitored: stbu
04-08-08 16:58	ferg	Note Added: 0002949
04-08-08 16:58	ferg	Assigned To	=> ferg
04-08-08 16:58	ferg	Status	new => closed
04-08-08 16:58	ferg	Resolution	open => fixed
04-08-08 16:58	ferg	Fixed in Version	=> 3.1.6

Mantis 1.0.0rc3[^]

32 total queries executed.
28 unique queries executed.