Forum Problems Installing LAMS: Some failure message in import_db.log


 
You may request notification for Some failure message in import_db.log.
Search: 

1: Some failure message in import_db.log
11/08/10 08:55 PM
[ Reply | Forward ]
When I installed LAMS 2.3, I checked the "C:\lams\install-logs\import-db.log" and found there were some failure message in this file. I really confused whether I install LAMS successfully or not.


[sql] Failed to execute: rename table lams_qtz_blob_triggers to lams_qtz_BLOB_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_blob_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_calendars to lams_qtz_CALENDARS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_calendars' already exists
[sql] Failed to execute: rename table lams_qtz_cron_triggers to lams_qtz_CRON_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_cron_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_fired_triggers to lams_qtz_FIRED_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_fired_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_job_details to lams_qtz_JOB_DETAILS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_job_details' already exists
[sql] Failed to execute: rename table lams_qtz_job_listeners to lams_qtz_JOB_LISTENERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_job_listeners' already exists
[sql] Failed to execute: rename table lams_qtz_locks to lams_qtz_LOCKS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_locks' already exists
[sql] Failed to execute: rename table lams_qtz_paused_trigger_grps to lams_qtz_PAUSED_TRIGGER_GRPS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_paused_trigger_grps' already exists
[sql] Failed to execute: rename table lams_qtz_scheduler_state to lams_qtz_SCHEDULER_STATE
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_scheduler_state' already exists
[sql] Failed to execute: rename table lams_qtz_simple_triggers to lams_qtz_SIMPLE_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_simple_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_triggers to lams_qtz_TRIGGERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_triggers' already exists
[sql] Failed to execute: rename table lams_qtz_trigger_listeners to lams_qtz_TRIGGER_LISTENERS
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lams_qtz_trigger_listeners' already exists
[sql] 11 of 23 SQL statements executed successfully

BUILD SUCCESSFUL
Total time: 15 seconds


Thanks in advance.
Michael

Posted by Hongliang Ma

2: Re: Some failure message in import_db.log
In response to 1 11/09/10 05:31 AM
[ Reply | Forward ]
Hi Michael,

It seems that the installer tried to create tables that they were already created. It did not give any fatal error, so the installation has gone alright for what I can tell.

BTW, what installer were you using?

Thanks,

Ernie

Posted by Ernie Ghiglione

3: Re: Re: Some failure message in import_db.log
In response to 2 11/25/10 03:19 AM
[ Reply | Forward ]
Our operating system is windows server 2003. The version of Windows (R) Installer is V 3.01.4000.3959.

Another problem was that the LAMS 2.3.4 could not be installed successfully unless the computer server was rebooted.

Do I need update my windows installer and install the LAMS from 2.3 to 2.3. 4 again?

You see, the LAMS could not work.

Posted by Hongliang Ma

Attachments:
4: Re: Re: Re: Some failure message in import_db.log
In response to 3 11/25/10 07:09 AM
[ Reply | Forward ]
Hi Michael,

The problems seems to be that there's another application running on the same port as LAMS. This is what I can see in your server.log:

> java.net.BindException: Address already in use: JVM_Bind:8080

Try to find out what application is using that port and switch it off. Or change the LAMS port number.

Thanks,

Ernie

Posted by Ernie Ghiglione

5: Re: Re: Re: Re: Some failure message in import_db.log
In response to 4 11/25/10 10:02 AM
[ Reply | Forward ]
Thank you very much. It's true that there is an application using 8080 port. I swithed it off, and then the LAMS service can be started again.

I have been struggling with this problem for several days. Your reply released me from this suffering immediately.

Thanks for your invaluable help.

Michael.

Posted by Hongliang Ma

Reply to first post on this page
Back to Problems Installing LAMS
.LRN Home