0002568: log_ CREATE error on startup

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

3.1.6

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

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.