Failed to read auto-increment value

[md10024]

Hi,
I am getting started with Spring MVC Basic on a WinXP development platform. I'm new to Maven but have used Appfuse for several different projects.

I have two issues/questions:

When I run this command
mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes -DarchetypeArtifactId=appfuse-basic-spring -DremoteRepositories=http://static.appfuse.org/releases -DarchetypeVersion=2.0.2 -DgroupId=com.mycompany.app -DartifactId=myproject

first, I get a list of these warnings:

[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 50,column 26] : ${a
ppfuse.version} is not a valid reference.
[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 52,column 34] : ${a
mp.genericCore} is not a valid reference.
[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 53,column 33] : ${a
mp.fullSource} is not a valid reference.


Am I missing something?


Secondly, further down, I get this error:

Signup:
[INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException
Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000
[INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio
nReporter.logExceptions(78) | Failed to read auto-increment value from s
torage engine
[INFO] -----------------------------------------------------------------

I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables I see this in the app_user table:
-2 false false Denver US 80210 CO false [e-mail]....
-1 false false Denver US 80210 CO false [e-mail]...

I'm not sure how these got created with negative value ID's. Note, I am able to reproduce this with the JSF archetype also.

Any hints as to what is going on here would be much appreciated.

Mark

[Peter Schneider-Manzell]

Hi Mark!

The negative IDs are not created by the DB, these are default values inserted via dbunit during the maven test phase.
See sample-data.xml for these entries

Bye,

Peter

2008/10/6 md10024 <md@...>

Hi,
I am getting started with Spring MVC Basic on a WinXP development platform.
I'm new to Maven but have used Appfuse for several different projects.

I have two issues/questions:

When I run this command
mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes
-DarchetypeArtifactId=appfuse-basic-spring
-DremoteRepositories=http://static.appfuse.org/releases
-DarchetypeVersion=2.0.2 -DgroupId=com.mycompany.app -DartifactId=myproject

first, I get a list of these warnings:

[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 50,column 26] : ${a
ppfuse.version} is not a valid reference.
[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 52,column 34] : ${a
mp.genericCore} is not a valid reference.
[WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
rence : template = archetype-resources/pom.xml [line 53,column 33] : ${a
mp.fullSource} is not a valid reference.


Am I missing something?


Secondly, further down, I get this error:

Signup:
[INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException
Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000
[INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio
nReporter.logExceptions(78) | Failed to read auto-increment value from s
torage engine
[INFO] -----------------------------------------------------------------

I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables I
see this in the app_user table:
-2      false   false           Denver  US      80210   CO      false   matt@.......
-1      false   false           Denver  US      80210   CO      false   matt_raible@......

I'm not sure how these got created with negative value ID's. Note, I am able
to reproduce this with the JSF archetype also.

Any hints as to what is going on here would be much appreciated.

Mark
--
View this message in context: http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19831354.html
Sent from the AppFuse - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[md10024]

Ok, thanks for your response that is good to know.

That leaves my original questions. In a fresh installation:

why are these properties not found? ... ${appfuse.version}...

And why does the SIgnup test fail with this error? ... ("Failed to read auto-increment value from storage engine")

Any clues?

Mark

Peter Schneider-Manzell wrote:

Hi Mark!

The negative IDs are not created by the DB, these are default values
inserted via dbunit during the maven test phase.
See sample-data.xml for these entries

Bye,

Peter

2008/10/6 md10024 <[e-mail]>

>
>
> Hi,
> I am getting started with Spring MVC Basic on a WinXP development platform.
> I'm new to Maven but have used Appfuse for several different projects.
>
> I have two issues/questions:
>
> When I run this command
> mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes
> -DarchetypeArtifactId=appfuse-basic-spring
> -DremoteRepositories=http://static.appfuse.org/releases
> -DarchetypeVersion=2.0.2<http://static.appfuse.org/releases-DarchetypeVersion=2.0.2>-DgroupId=com.mycompany.app -DartifactId=myproject
>
> first, I get a list of these warnings:
>
> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
> rence : template = archetype-resources/pom.xml [line 50,column 26] : ${a
> ppfuse.version} is not a valid reference.
> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
> rence : template = archetype-resources/pom.xml [line 52,column 34] : ${a
> mp.genericCore} is not a valid reference.
> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
> rence : template = archetype-resources/pom.xml [line 53,column 33] : ${a
> mp.fullSource} is not a valid reference.
>
>
> Am I missing something?
>
>
> Secondly, further down, I get this error:
>
> Signup:
> [INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException
> Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000
> [INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio
> nReporter.logExceptions(78) | Failed to read auto-increment value from s
> torage engine
> [INFO] -----------------------------------------------------------------
>
> I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables I
> see this in the app_user table:
> -2      false   false           Denver  US      80210   CO      false
> [e-mail]....
> -1      false   false           Denver  US      80210   CO      false
> [e-mail]...
>
> I'm not sure how these got created with negative value ID's. Note, I am
> able
> to reproduce this with the JSF archetype also.
>
> Any hints as to what is going on here would be much appreciated.
>
> Mark
> --
> View this message in context:
> http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19831354.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>

[mraible]

On Mon, Oct 6, 2008 at 10:32 AM, md10024 <md@...> wrote:
>
>
>
> Ok, thanks for your response that is good to know.
>
> That leaves my original questions. In a fresh installation:
>
> why are these properties not found? ... ${appfuse.version}...

This is an issue with Maven that's not caused by AppFuse. From the
QuickStart Guide:

<quote>
The warnings you see when creating your project are expected. If you
see BUILD SUCCESSFUL at the end, your project was created
successfully.
</quote>

>
> And why does the SIgnup test fail with this error? ... ("Failed to read
> auto-increment value from storage engine")

Don't know, maybe MySQL isn't setup correctly? You might try dropping
your database and trying again.

Matt

>
> Any clues?
>
> Mark
>
>
>
> Peter Schneider-Manzell wrote:
>>
>> Hi Mark!
>>
>> The negative IDs are not created by the DB, these are default values
>> inserted via dbunit during the maven test phase.
>> See sample-data.xml for these entries
>>
>> Bye,
>>
>> Peter
>>
>> 2008/10/6 md10024 <md@...>
>>
>>>
>>>
>>> Hi,
>>> I am getting started with Spring MVC Basic on a WinXP development
>>> platform.
>>> I'm new to Maven but have used Appfuse for several different projects.
>>>
>>> I have two issues/questions:
>>>
>>> When I run this command
>>> mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes
>>> -DarchetypeArtifactId=appfuse-basic-spring
>>> -DremoteRepositories=http://static.appfuse.org/releases
>>> -DarchetypeVersion=2.0.2<http://static.appfuse.org/releases-DarchetypeVersion=2.0.2>-DgroupId=com.mycompany.app
>>> -DartifactId=myproject
>>>
>>> first, I get a list of these warnings:
>>>
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 50,column 26] : ${a
>>> ppfuse.version} is not a valid reference.
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 52,column 34] : ${a
>>> mp.genericCore} is not a valid reference.
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 53,column 33] : ${a
>>> mp.fullSource} is not a valid reference.
>>>
>>>
>>> Am I missing something?
>>>
>>>
>>> Secondly, further down, I get this error:
>>>
>>> Signup:
>>> [INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException
>>> Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000
>>> [INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio
>>> nReporter.logExceptions(78) | Failed to read auto-increment value from s
>>> torage engine
>>> [INFO] -----------------------------------------------------------------
>>>
>>> I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables
>>> I
>>> see this in the app_user table:
>>> -2      false   false           Denver  US      80210   CO      false
>>> matt@.......
>>> -1      false   false           Denver  US      80210   CO      false
>>> matt_raible@......
>>>
>>> I'm not sure how these got created with negative value ID's. Note, I am
>>> able
>>> to reproduce this with the JSF archetype also.
>>>
>>> Any hints as to what is going on here would be much appreciated.
>>>
>>> Mark
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19831354.html
>>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@...
>>> For additional commands, e-mail: users-help@...
>>>
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19841441.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[md10024]

Just to follow up for future posterity, this problem...."Failed to read auto-increment value from storage engine" is actually a MySQL bug as reported here: http://bugs.mysql.com/bug.php?id=36411

I rolled back from 5.1.28 to GA 5.0.67 and it works fine. Therefore, I don't recommend the 5.1.28 release until this problem is resolved.

mraible wrote:

On Mon, Oct 6, 2008 at 10:32 AM, md10024 <[e-mail]> wrote:
>
>
>
> Ok, thanks for your response that is good to know.
>
> That leaves my original questions. In a fresh installation:
>
> why are these properties not found? ... ${appfuse.version}...

This is an issue with Maven that's not caused by AppFuse. From the
QuickStart Guide:

The warnings you see when creating your project are expected. If you
see BUILD SUCCESSFUL at the end, your project was created
successfully.

>
> And why does the SIgnup test fail with this error? ... ("Failed to read
> auto-increment value from storage engine")

Don't know, maybe MySQL isn't setup correctly? You might try dropping
your database and trying again.

Matt

>
> Any clues?
>
> Mark
>
>
>
> Peter Schneider-Manzell wrote:
>>
>> Hi Mark!
>>
>> The negative IDs are not created by the DB, these are default values
>> inserted via dbunit during the maven test phase.
>> See sample-data.xml for these entries
>>
>> Bye,
>>
>> Peter
>>
>> 2008/10/6 md10024 <[e-mail]>
>>
>>>
>>>
>>> Hi,
>>> I am getting started with Spring MVC Basic on a WinXP development
>>> platform.
>>> I'm new to Maven but have used Appfuse for several different projects.
>>>
>>> I have two issues/questions:
>>>
>>> When I run this command
>>> mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes
>>> -DarchetypeArtifactId=appfuse-basic-spring
>>> -DremoteRepositories=http://static.appfuse.org/releases
>>> -DarchetypeVersion=2.0.2<http://static.appfuse.org/releases-DarchetypeVersion=2.0.2>-DgroupId=com.mycompany.app
>>> -DartifactId=myproject
>>>
>>> first, I get a list of these warnings:
>>>
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 50,column 26] : ${a
>>> ppfuse.version} is not a valid reference.
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 52,column 34] : ${a
>>> mp.genericCore} is not a valid reference.
>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: refe
>>> rence : template = archetype-resources/pom.xml [line 53,column 33] : ${a
>>> mp.fullSource} is not a valid reference.
>>>
>>>
>>> Am I missing something?
>>>
>>>
>>> Secondly, further down, I get this error:
>>>
>>> Signup:
>>> [INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException
>>> Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000
>>> [INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio
>>> nReporter.logExceptions(78) | Failed to read auto-increment value from s
>>> torage engine
>>> [INFO] -----------------------------------------------------------------
>>>
>>> I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables
>>> I
>>> see this in the app_user table:
>>> -2      false   false           Denver  US      80210   CO      false
>>> [e-mail]....
>>> -1      false   false           Denver  US      80210   CO      false
>>> [e-mail]...
>>>
>>> I'm not sure how these got created with negative value ID's. Note, I am
>>> able
>>> to reproduce this with the JSF archetype also.
>>>
>>> Any hints as to what is going on here would be much appreciated.
>>>
>>> Mark
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19831354.html
>>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [e-mail]
>>> For additional commands, e-mail: [e-mail]
>>>
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19841441.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]