topic Re: Failed to create new space due to error: The transaction was in Alfresco Archive

Failed to create new space due to error: The transaction was

a5sk4s — Thu, 01 Sep 2005 20:38:17 GMT

I'm trying to follow the tutorial (more or less) after installing alfresco from source (with some manual steps involved - several config files weren't copied into the Tomcat directories and I had to manually move them over - not sure what went wrong - I used build-tomcat and deploy-tomcat).When tryi

Re: Failed to create new space due to error: The transaction was

gavinc — Fri, 02 Sep 2005 06:56:12 GMT

From the stack trace it looks like you have a transform rule setup on the parent space you are trying to create the new one in.

Did you define a rule to transform content on any of your spaces? If so, try removing the rule and attempt the create space action again.

Re: Failed to create new space due to error: The transaction was

leoditor — Fri, 02 Sep 2005 10:06:48 GMT

I have the same problem.
I follow the tutorial, so i define no rule.
But in step 2 (Spaces options) I don't have "copy existing space" option like the tutorial.
I have this message:

Note: Any content rules for spaces will also be copied.

Re: Failed to create new space due to error: The transaction was

leoditor — Fri, 02 Sep 2005 14:23:47 GMT

the same problem with transaction when using clipboard cpy/paste:

Unable to paste item due to system error: The transaction was not committed - Content conversion failed: reader: Content writer: Content file://2005%5C9%5C2%5C4f04d8ae-1bbc-11da-9afd-e9a994954d07.bin,

Re: Failed to create new space due to error: The transaction was

a5sk4s — Fri, 02 Sep 2005 15:23:17 GMT

Gavin:

Thanks for the quick response.

To my knowledge, I haven't set up any rules in any of the spaces created so far (Users with one subspace for a user and Projects as suggested in the tutorial). I double-checked those spaces using the UI and there are indeed none.

Is there anything else that I could do to track down the error?

Andreas

Re: Failed to create new space due to error: The transaction was

a5sk4s — Fri, 02 Sep 2005 19:26:57 GMT

I've tracked it down to some inconsistencies with the contentstore under %TOMCAT_HOME%/bin/alfresco. Not sure what caused those inconsistencies in the first place, but copying a document into the location of the reader's URL got me passed the original error. I am uncertain which document was actually supposed to be in that location and probably will redo the alfresco deployment.

Re: Failed to create new space due to error: The transaction was

davidc — Fri, 02 Sep 2005 20:57:22 GMT

From the stack trace, the transformation is a result of the indexing process (which transforms content to text) and not rules.

It's unclear why there wasn't any content at the URL. I notice you've run the unit tests, which will also use the same database schema (alfresco by default) and it's possible that something in the tests have left things in an inconsistent state. I'd either run tests in their own schema or clean out the schema (ant reset-database) after running the tests and before starting the application server.

Even so, it's still odd that a couple of you have seen this issue, so I'll perform the same tutorial steps and see what happens.

Re: Failed to create new space due to error: The transaction was

derek — Fri, 02 Sep 2005 23:07:08 GMT

Hi, All

This is fairly common when switching between the test environment and the live environment.

The file 'repository.properties' has a relative directory for storing indexes and content. But the database details are NOT relative. So, when you run some tests, you will get content created at a location A/…/alfresco/content but when you run under Tomcat, you will get content in B/…/alfresco/content.

But both the tests and the Tomcat will probably refer to the same database. Therefore, after running the tests and switching to Tomcat, you will effectively have URLs in the database that refer to non-existent content. This is exactly what has happened here.

When indexing attempted to do some indexing on the nodes, the content could not be found - definitely a very serious error.

To solve this (if you want to run unit tests):
After you unzip the code, and before you run anything, modify the repository.properties to point to an absolute location on your system. In that way, you will have both a common database and common content and index stores regardless of which tests you run or if you run Tomcat, JBoss, etc.

To fix your issue:
You could (a) drop and recreate the database schema or (b) copy all your many content stores and index file into one location and modify the repository.properties to refer to that location.

Regards

Re: Failed to create new space due to error: The transaction was

lucille_arkenst — Mon, 16 Aug 2010 20:41:16 GMT

Hello Derek / David,

I changed repository.properties to point to absolute path: dir.root=/opt/Alfresco/alf_data and I still got the error.
Version: Community - v3.3.0.
This happens on spaces where a content rule is applied, and to sub-spaces.
I went ahead and dropped/recreated the database schema and this solved the issue. (In Test.) However, you lose all your stuff when you do that. Do you create an acp file first and then import it after the drop/recreate or is there another way?

I have two sites with MUCH information… dropping and recreating in Production is probably not the best option. Unless there is a safe way to do it. Suggestions?

Anything you can do to help will be greatly appreciated!

Re: Failed to create new space due to error: The transaction was

derek — Tue, 17 Aug 2010 11:47:42 GMT

Hi,
Your alfresco.log will say which dir.root is being used by the server. Locate it and set your dir.root to reference it using an absolute path. Locate any previously-used content stores (caused by the server using different relative locations) and merge them together. If you had some of those, you should probably reindex.

Re: Failed to create new space due to error: The transaction was

lucille_arkenst — Tue, 17 Aug 2010 19:19:23 GMT

Hello Derek,

Thanks for the quick response. I am already using an absolute path (The Alfresco root data directory ('dir.root') is: /opt/Alfresco/alf_data).

What do you mean by "locate any previously-used content stores and merge them together"? The only content store I know of is /opt/Alfresco/alf_data/contentstore. I'll re-index if I knew there was another one somewhere. Where should I look?

Merging the content stores should be done instead of dropping and recreating the database, right?

Thanks!

Re: Failed to create new space due to error: The transaction was

derek — Wed, 18 Aug 2010 09:08:40 GMT

You could copy the content from the contentstore.deleted, for example. But if you know which URLs are missing, then you could search for it. At any rate, I'm just going on the later analysis indicating that some content was missing.

Re: Failed to create new space due to error: The transaction was

lucille_arkenst — Wed, 18 Aug 2010 15:15:53 GMT

OK now I truly need your help.
There was nothing in contentstore.deleted, and I wanted to retrace my steps so I could say, "OK, if I dump contentstore.deleted into content store, that works." But now I cannot log in to Alfresco.

The error was:


Schema auto-update failed
Duplicate key name 'FK_BYTEBLOCK_FILE'

Statement execution failed:
   SQL:     alter table JBPM_BYTEBLOCK
        add index FK_BYTEBLOCK_FILE (PROCESSFILE_),
        add constraint FK_BYTEBLOCK_FILE
        foreign key (PROCESSFILE_)
        references JBPM_BYTEARRAY (ID_)
   Error: Duplicate key name 'FK_BYTEBLOCK_FILE'
   File: /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-61387559573437534.sql
‍‍‍‍‍‍‍‍‍‍‍‍‍

Here's what I did:


$ mysql -u root -p

mysql> drop database alfresco;
Query OK, 88 rows affected (0.10 sec)

mysql> create database alfresco default character set utf8 collate utf8_bin;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
Query OK, 0 rows affected (0.00 sec)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Help!

Re: Failed to create new space due to error: The transaction was

derek — Wed, 18 Aug 2010 15:21:25 GMT

Are we drifting from the original issue? You dropped your MySQL database after a failed upgrade? Did you try to upgrade an existing installation (from what to what) and then dropped the DB?
I am confused.

Re: Failed to create new space due to error: The transaction was

lucille_arkenst — Wed, 18 Aug 2010 15:55:41 GMT

Yes, sorry. We indeed drifted a bit because the fix that was originally advised did not work, plus I couldn't get Alfresco running again.

To fix your issue:
You could (a) drop and recreate the database schema…

After Googling, I am now back up and running.
So sorry for the confusion. Back to our discussion…

…(b) copy all your many content stores and index file into one location and modify the repository.properties to refer to that location.

I modified repository.properties such that dir.root now points to 1) an absolute path 2) alf_data, the location the content stores are in.
But I still got the error after doing that. So finally you and I were exploring "locate any previously-used content stores and merge them together", and I checked contentstore.deleted and there was nothing in that folder. I lost two sites that I created, plus all content.

Did I do something wrong in step (b)?
I just want to successfully apply a fix where my users can change the name of a space without getting any errors, and without taking away any of their functionality (i.e. content rule), and without losing their data. :wink:

Re: Failed to create new space due to error: The transaction was

derek — Thu, 19 Aug 2010 10:27:46 GMT

Have you found this content? file://2005\8\31\aa1f3ce4-1a3a-11da-ac62-f17d33e50603.bin

Re: Failed to create new space due to error: The transaction was

lucille_arkenst — Thu, 19 Aug 2010 15:41:11 GMT

All that kind of content is located in /opt/Alfresco/alf_data/contentstore/, only.

Re: Failed to create new space due to error: The transaction was

derek — Fri, 20 Aug 2010 09:16:43 GMT

OK. Is that specific file there (it was the one that was missing before)?