[Anthill-pro] Minimum mysql version requirements?
Peter Steele
psteele at maxiscale.com
Mon Oct 6 08:46:52 CDT 2008
I am in fact using the 5.1 driver. When I downloaded it the indication I had from the web site was that it was compatible with MySQL 4.1.22. I almost went with an older version but decided to use 5.1. Guess that was a bad decision. I'll get the 5.0 driver and try it on a clone database again. Thanks for the help.
Peter
-----Original Message-----
From: anthill-pro-bounces at lists.urbancode.com [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Russ Francis
Sent: Monday, October 06, 2008 6:31 AM
To: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Minimum mysql version requirements?
Peter,
What version of the MySQL db driver are you using? Many of those exceptions look very similar to exceptions we have seen when running against MySQL and using the 5.1 driver. Needless to say, the 5.1 driver does not work with Anthill and we recommend using the 5.0 JDBC driver.
Kind Regards,
Russ
2008/10/6 Peter Steele <psteele at maxiscale.com>:
> Are you referring the log4j.properties file associated with the server? I've adjusted settings in this file periodically to help track down server problems. If this isn't the file you are referring to, then how do I change the log level for the migrate script?
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Uldis
> Karlovs-Karlovskis
> Sent: Monday, October 06, 2008 5:49 AM
> To: 'AnthillPro user and support list.'
> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>
> So the scripts was the right ones and that wasn`t Your fault :) Imo
> You should rerun script with all debug information switched on. Only
> then it will be possible for anyone to help You.
>
> Regards,
> Uldis, C. T. Co
> uldis.karlovs-karlovskis at ctco.lv
>
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Peter
> Steele
> Sent: pirmdiena, 2008. gada 6. oktobrī 15:43
> To: AnthillPro user and support list.
> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>
> Sorry, I misunderstood. We're running 3.5.2_13271. I am using the
> migrate-db.sh script that is packaged with that release. I assume
> since it came from the same tarball that it is a version match to the Anthill server.
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Uldis
> Karlovs-Karlovskis
> Sent: Sunday, October 05, 2008 11:30 PM
> To: 'AnthillPro user and support list.'
> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>
> The main question is have You used the same Anthill migration tool
> version as Your current Anthill version?
>
> Regards,
> Uldis, C. T. Co
> uldis.karlovs-karlovskis at ctco.lv
>
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Peter
> Steele
> Sent: svētdiena, 2008. gada 5. oktobrī 20:19
> To: AnthillPro user and support list.
> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>
> Every agent is currently running 3.5.2, the same as the server. I have
> not done any serious post analysis of the before and after databases.
> The database is very large and quite frankly I wouldn't really know
> where to start. Unfortunately I'm not a Derby *or* MySQL guy...
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Uldis
> Sent: Sunday, October 05, 2008 9:21 AM
> To: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Minimum mysql version requirements?
>
> Are You sure that everywhere was the same version? When migrating it
> is strongly recommended to migrate with the same version as is Your
> current
>
> Anthill version. It seems that Your database is missing data. Have You
> compared old derby database with Your new MySQL?
>
> Peter Steele wrote:
>> Okay, not a complete disaster, but we're still running with Derby.
> There
>> were no obvious errors reported during the migration and the server
> came
>> up initially without problems. Lots of things are broken in the GUI
>> though. I can look anything under the System tab it seems, and I can
>> also look at job definitions without problems. However, if I try to
> open
>> a workflow either in the Dashboard I get errors. The dashboard error
> is
>>
>> PersistenceException: Error restoring object from database: Column
>> 'CLASS' not found.
>>
>> Attempting to open a workflow in the Administration tab generates
>> another error:
>>
>> JasperException: javax.servlet.jsp.el.ELException: An error occurred
>> while getting property "buildProfile" from an instance of class
>> com.urbancode.anthill3.domain.workflow.Workflow
>>
>> If I try to open an old workflow under the Search tab, I get this
> error:
>>
>> PersistenceRuntimeException: Error restoring object from database
>>
>> So, lots of things are broken. Fortunately I backed up the entire
> server
>> directory and was able to flip back to Derby without any trouble. The
>> little bit that I was able to play around with the mysql version
> though
>> showed my just how much faster our system will be once we get the
>> migration completed. The question is what went wrong and how do we
>> proceed. I've included several complete exceptions below, and I can
>> provide whatever else is needed to help diagnose this problem.
>>
>> 2008-10-04 16:45:42,409 ERROR http-0.0.0.0-8080-Processor19
>> com.urbancode.anthill3.web.controller.ControllerServlet -
> javax.servlet.
>> jsp.el.ELException: An error occurred while getting property
>> "buildProfile" from an instance of class
> com.urbancode.anthill3.domain.
>> workflow.Workflow
>> org.apache.jasper.JasperException: javax.servlet.jsp.el.ELException:
> An
>> error occurred while getting property "buildProfile" from an
>> instance of class com.urbancode.anthill3.domain.workflow.Workflow
>> at
>>
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServ
> le
>> tWrapper.java:460)
>> at
>>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.
> ja
>> va:355)
>> at
>>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:32
> 9)
>> at
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> ca
>> tionFilterChain.java:269)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lt
>> erChain.java:188)
>> at
>>
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispa
> tc
>> her.java:691)
>> at
>>
> org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicat
> io
>> nDispatcher.java:469)
>> at
>>
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDi
> sp
>> atcher.java:403)
>> at
>>
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDisp
> at
>> cher.java:301)
>> at
>>
> com.urbancode.anthill3.web.controller.ForwardResponse.respond(ForwardR
> es
>> ponse.java:47)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(Control
> le
>> rServlet.java:347)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doGet(Controll
> er
>> Servlet.java:160)
>> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> ca
>> tionFilterChain.java:269)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.j
> av
>> a:78)
>>
>> 2008-10-04 16:43:12,155 ERROR DefaultQuartzScheduler_Worker-3
>> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql - Errorresto
>> ring object from database: Column 'CLASS' not found.
>> java.sql.SQLException: Column 'CLASS' not found.
>> at
>> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
>> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
>> at
>> com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1080)
>> at
>> com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5474)
>> at
>> com.p6spy.engine.spy.P6ResultSet.getString(P6ResultSet.java:260)
>> at
>> com.p6spy.engine.spy.P6ResultSet.getString(P6ResultSet.java:266)
>> at
>>
> org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResult
> Se
>> t.java:174)
>> at
>>
> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql.restore(Build
> Pr
>> ofileDaoSql.java:236)
>> at
>>
> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql.restoreAll(Bu
> il
>> dProfileDaoSql.java:284)
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.restoreAll0(UnitO
> fW
>> orkDefault.java:335)
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWork.restoreAll(UnitOfWork.ja
> va
>> :553)
>>at
>>
> com.urbancode.anthill3.domain.profile.BuildProfileFactory.restoreAll(B
> ui
>> ldProfileFactory.java:71)
>> at
>>
> com.urbancode.anthill3.services.build.BuildServiceImplMerging.<init>(B
> ui
>> ldServiceImplMerging.java:87)
>> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> at
>>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructo
> rA
>> ccessorImpl.java:39)
>> at
>>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo
> ns
>> tructorAccessorImpl.java:27)
>> at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>> at
>>
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:10
> 0)
>> at
>>
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:76
> )
>> at
>>
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.
> in
>> stantiate(SimpleInstantiationStrategy.java:49)
>> at
>>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanF
> ac
>> tory.createBean(AbstractAutowireCapableBeanFactor
>> y.java:322)
>> at
>>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> Ab
>> stractBeanFactory.java:223)
>> at
>>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> Ab
>> stractBeanFactory.java:147)
>> at
>>
> com.urbancode.anthill3.spring.SpringSupport.getBean(SpringSupport.java
> :5
>> 2)
>> at
>>
> com.urbancode.anthill3.services.build.BuildService.getInstance(BuildSe
> rv
>> ice.java:28)
>> at
>>
> com.urbancode.anthill3.services.workflow.WorkflowServiceDefault$1.run(
> Wo
>> rkflowServiceDefault.java:419)
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWorkClosingRunnable.run(UnitO
> fW
>> orkClosingRunnable.java:30)
>> at
>>
> com.urbancode.anthill3.services.scheduler.Scheduler$OneTimeQuartzJob.e
> xe
>> cute(Scheduler.java:83)
>> at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
>> at
>>
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.ja
> va
>> :516)
>>
>> 2008-10-04 16:54:02,967 ERROR http-0.0.0.0-8080-Processor24
>> com.urbancode.anthill3.web.controller.ControllerServlet - Error
> restorin
>> g object from database
>> com.urbancode.anthill3.domain.persistent.PersistenceRuntimeException:
>> Error restoring object from database
>> at
>>
> com.urbancode.anthill3.domain.persistent.Handle.dereference(Handle.java:
>> 182)
>> at
>>
> com.urbancode.anthill3.domain.buildlife.BuildLife.getProfile(BuildLife
> .j
>> ava:141)
>> at
>>
> com.urbancode.anthill3.web.project.BuildLifeTasks.getTrail(BuildLifeTa
> sk
>> s.java:220)
>> at
>>
> com.urbancode.anthill3.web.project.BuildLifeTasks.getTrail(BuildLifeTa
> sk
>> s.java:232)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(Control
> le
>> rServlet.java:317)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doGet(Controll
> er
>> Servlet.java:160)
>> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> ca
>> tionFilterChain.java:269)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.j
> av
>> a:78)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> ca
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter
> .j
>> ava:132)
>> -----Original Message-----
>> From: anthill-pro-bounces at lists.urbancode.com
>> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Peter
>> Steele
>> Sent: Saturday, October 04, 2008 9:36 AM
>> To: AnthillPro user and support list.; rws at urbancode.com
>> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>>
>> Okay, got this figured out, or at least got something that worked. I
>> ended up upgrading the derbytools jar file from 10.1 to 10.4.2. The
>> command
>>
>> update anthill3.sec_user set password =
>> 'pbe{T2rXUa16K1UqX7tbpFcsVsc66NJ7XM+e}' where name = 'guest';
>>
>> worked as expected after that. There was no "system" account in
> SEC_USER
>> so there was nothing I could do about that. Now onward to the migrate
>> script...
>>
>> -----Original Message-----
>> From: anthill-pro-bounces at lists.urbancode.com
>> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Peter
>> Steele
>> Sent: Friday, October 03, 2008 4:54 PM
>> To: rws at urbancode.com
>> Cc: AnthillPro user and support list.
>> Subject: RE: [Anthill-pro] Minimum mysql version requirements?
>>
>> What derby command is intended for updating this password field? I'm
> not
>> getting much success, and the derby experts here seem to think these
>> commands should work:
>>
>> # java -cp derby.jar:derbytools.jar org.apache.derby.tools.ij -p
>> derby.properties ij version 10.1
>> CONNECTION0* - jdbc:derby:/opt/anthill3/server/var/db/data
>> * = current connection
>> ij> select * from SEC_USER;
>> ERROR 42X05: Table 'SEC_USER' does not exist.
>> ij> select * from dba.SEC_USER;
>> ERROR 42Y07: Schema 'DBA' does not exist
>> ij> show tables;
>> ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
>>
>> What am I missing?
>>
>> -----Original Message-----
>> From: Ryan Smith [mailto:rws at urbancode.com]
>> Sent: Friday, October 03, 2008 8:00 AM
>> To: Peter Steele
>> Cc: AnthillPro user and support list.
>> Subject: Re: [Anthill-pro] Minimum mysql version requirements?
>>
>> Peter, it should work as long as the password requirement is handled.
>> You still need to do this check even if you aren't using LDAP. There
> is
>> a system account without a password.
>>
>>
>> Ryan
>>
>> Peter Steele wrote:
>>
>>> I'll do this, thanks for the warning. We do not have Anthill tried
>>>
>> into
>>
>>> LDAP so I assume this would avoid the problem you are describing.
>>> Regardless, I'm not looking forward to this process--something
>>> *will*
>>>
>> go
>>
>>> wrong...
>>>
>>> -----Original Message-----
>>> From: Ryan Smith [mailto:rws at urbancode.com]
>>> Sent: Friday, October 03, 2008 7:49 AM
>>> To: Peter Steele
>>> Cc: AnthillPro user and support list.
>>> Subject: Re: [Anthill-pro] Minimum mysql version requirements?
>>>
>>> Peter,
>>>
>>> Unfortunately with Derby you do not get a accurate metric for the
> size
>>>
>>
>>
>>> of the database. The files always take up more space than the actual
>>> database, but it does sound large. The migration is not going to be
>>> extremely fast, probably will take several hours.
>>>
>>> The only know issue with the migration is if certain system users
>>> and
>
>>> LDAP users have a database entry of "". The import tool (dbunit)
> can't
>>>
>>
>>
>>> tell a emtpy string from a null and tries to insert a null,which is
>>>
>> not
>>
>>> allowed in the table.
>>>
>>> Before the migration, you should connect to the derby database and
>>>
>> check
>>
>>> if any SEC_USER entries have a empty or null entry for PASSWORD. If
>>>
>> so,
>>
>>> this value can be updated to:
>>>
>>> pbe{T2rXUa16K1UqX7tbpFcsVsc66NJ7XM+e}
>>>
>>>
>>> Ryan Smith
>>>
>>> Peter Steele wrote:
>>>
>>>
>>>> After a bit of work we managed to get our MySQL upgraded from
>>>> 4.1.20
>>>>
>>>>
>>> to
>>>
>>>
>>>> 4.1.22, so now we can proceed with the next step of migrating the
>>>> Anthill Derby DB to MySQL. I realize this isn't an easy question to
>>>> answer, but how long can we expect the migration script to run? The
>>>> derby data directory currently has 858596KB of information in it,
>>>> according to du. My plan is to do a backup of the Derby DB and then
>>>>
>>>>
>>> run
>>>
>>>
>>>> the migration script.
>>>>
>>>> Should we plan on backing up anything else? We could for example
>>>>
>>>>
>>> backup
>>>
>>>
>>>> the entire /opt/anthill/server directory, but this is huge and
>>>> would take hours. If this is recommended though, we'll do it.
>>>>
>>>>Peter
>>>>
>>>> -----Original Message-----
>>>> From: anthill-pro-bounces at lists.urbancode.com
>>>> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan
>>>>
>>>>
>>> Smith
>>>
>>>
>>>> Sent: Wednesday, October 01, 2008 8:39 AM
>>>> To: AnthillPro user and support list.
>>>> Subject: Re: [Anthill-pro] Minimum mysql version requirements?
>>>>
>>>> Peter,
>>>>
>>>> We have had it work with 4.1.22. We would recommend upgrading to
>>>>
>> MySQL
>>
>>>>
>>>>
>>> 5
>>>
>>>
>>>> if applicable. There are details on our site:
>>>>
>>>> http://www.anthillpro.com/html/products/anthillpro/installation.htm
>>>> l
>>>>
>>>>
>>>> Ryan Smith
>>>>
>>>> Peter Steele wrote:
>>>>
>>>>
>>>>
>>>>> We want to migrate our Anthill derby database to mysql. The
>>>>> version
>>>>>
>>>>>
>>> of
>>>
>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>> mysql currently running on our Anthill server box is 4.1.20, which
>>>>>
>> is
>>
>>>>>
>>>>>
>>>
>>>
>>>>> fairly old. Is this supported in the derby to mysql migration or
>>>>> do
>>>>>
>>>>>
>>> we
>>>
>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>> need a newer version of mysql?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
> ----------------------------------------------------------------------
> --
>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>> _______________________________________________
>>>>> Anthill-pro mailing list
>>>>> Anthill-pro at lists.urbancode.com
>>>>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>>>>>
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> Anthill-pro mailing list
>>>> Anthill-pro at lists.urbancode.com
>>>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>> _______________________________________________
>> Anthill-pro mailing list
>> Anthill-pro at lists.urbancode.com
>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>> _______________________________________________
>> Anthill-pro mailing list
>> Anthill-pro at lists.urbancode.com
>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>> _______________________________________________
>> Anthill-pro mailing list
>> Anthill-pro at lists.urbancode.com
>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>>
>>
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
More information about the Anthill-pro
mailing list