Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Trouble reading from InnoDB and writing to MyISAM
Started 1 month ago by DEinspanjer Senior Member
I'm querying one MySQL database that uses InnoDB tables, and I'm ETLing the data into my data warehouse database that is using MyISAM. I need the read consistent view that InnoDB provides in a transaction, so I've enabled the option to make the transformation database transactional, but that surfaces a problem: When the transformation successfully finishes processing data, it tries...
Site: Pentaho Community Forums  Pentaho Community Forums - site profile
Forum: Pentaho Data Integration [Kettle]  Pentaho Data Integration [Kettle] - forum profile
Total authors: 4 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: pentaho.org

Other posts in this thread:

johndz Junior Member replied 1 month ago
Hi, Can you clarify what you did to enable the option to make your database transactional? Also, did you get an error # or can you post the specific text? Can you tell what transaction isolation you are using? I ran your ktr file on my system and didn't get any errors on my MySQL server.
Size: 304 bytes
Customize:  Customize "<b>Reply 1</b>: Trouble reading from InnoDB and writing to MyISAM :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums"

DEinspanjer Senior Member replied 1 month ago
You don't see a particular step list an error, but for me, I see an error in the transformation log: Code: 2009/10/29 14:03:34 - Test mixing InnoDB and MyISAM - All transaction of database connection 'localhost test' where committed at the end of the transformation. 2009/10/29 14:03:34 - localhost test - Connection to database closed! 2009/10/29 14:03:34 - Test mixing InnoDB and ...
Size: 2,616 bytes
Customize:  Customize "<b>Reply 2</b>: Trouble reading from InnoDB and writing to MyISAM :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums"

Bart.Farasyn Member replied 1 month ago
Hi, I seem to remember that it is possible to set "set autocommit = false" in the Advanced tab of your db connection Groeten, Bart
Size: 192 bytes
Customize:  Customize "<b>Reply 3</b>: Trouble reading from InnoDB and writing to MyISAM :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums"

Bart.Farasyn replied 1 month ago
Hi, I seem to remember that it is possible to set "set autocommit = false" in the Advanced tab of your db connection Groeten, Bart
Size: 741 bytes
Customize:  Customize "<b>Reply 4</b>: Trouble reading from InnoDB and writing to MyISAM :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums"

 

Top contributing authors

Name
Posts
DEinspanjer Senior Member
2
user's latest post:
Trouble reading from InnoDB and...
Published (2009-10-29 14:06:00)
You don't see a particular step list an error, but for me, I see an error in the transformation log: Code: 2009/10/29 14:03:34 - Test mixing InnoDB and MyISAM - All transaction of database connection 'localhost test' where committed at the end of the transformation. 2009/10/29 14:03:34 - localhost test - Connection to database closed! 2009/10/29 14:03:34 - Test mixing InnoDB and MyISAM - ERROR (version 3.2.1, build 1 from...
johndz Junior Member
1
user's latest post:
Trouble reading from InnoDB and...
Published (2009-10-29 13:40:00)
Hi, Can you clarify what you did to enable the option to make your database transactional? Also, did you get an error # or can you post the specific text? Can you tell what transaction isolation you are using? I ran your ktr file on my system and didn't get any errors on my MySQL server.
Bart.Farasyn Member
1
user's latest post:
Trouble reading from InnoDB and...
Published (2009-10-30 08:07:00)
Hi, I seem to remember that it is possible to set &quot;set autocommit = false&quot; in the Advanced tab of your db connection Groeten, Bart
Bart.Farasyn
1
user's latest post:
Trouble reading from InnoDB and...
Published (2009-10-30 08:07:00)
Hi, I seem to remember that it is possible to set &quot;set autocommit = false&quot; in the Advanced tab of your db connection Groeten, Bart

Related threads on "Pentaho Community Forums":

Trouble with Analysis Examples - Slice and Dice  Pentaho Community Forums - site profile Installation Issues - forum profile Trouble with Analysis Examples - Slice and Dice
Trouble with Analysis Examples - Slice and Dice
Trouble with Mondrian and Oracle  Pentaho Community Forums - site profile Mondrian [Pentaho Analysis Services] - forum profile Trouble with Mondrian and Oracle
Trouble with Mondrian and Oracle
Trouble exporting catalog as one xml file in 2.4 &...  Pentaho Community Forums - site profile Pentaho Data Integration [Kettle] - forum profile Trouble exporting catalog as one xml file in 2.4 & 2.5 used to work in 2.3?
Trouble exporting catalog as one xml file in 2.4 & 2.5 used to work in 2.3?
Trouble connecting to SQL SERVER 2005  Pentaho Community Forums - site profile Pentaho Data Integration [Kettle] - forum profile Trouble connecting to SQL SERVER 2005
Trouble connecting to SQL SERVER 2005

Related threads on other sites:

Innodb or myisam?...  Twitter / JasonBurton - site profile Jason Burton - forum profile Innodb or myisam? about 2 hours ago from web
Innodb or myisam? about 2 hours ago from web
MySQL Innodb or Myisam  Habbox UK Forum - site profile Designing & Development - forum profile MySQL Innodb or Myisam
MySQL Innodb or Myisam
Sphinx for indexing innodb or myisam  Invision Power Services - site profile Feature Suggestions and Ideas - forum profile Sphinx for indexing innodb or myisam
Sphinx for indexing innodb or myisam
InnoDB or MYISAM tables?  UK Affiliate Marketing Forum - site profile Databases - forum profile InnoDB or MYISAM tables?
InnoDB or MYISAM tables?
Apache, MySQL:InnoDB, MySQL:MyISAM, PHP, Linux, Ubuntu,...  Twitter / elektech - site profile elektech - forum profile Apache, MySQL:InnoDB, MySQL:MyISAM, PHP, Linux, Ubuntu, Tomcat, Moodle, & LAMS all working together! Posting "how to" on blog over weekend. 5:30 PM Mar 6th from TweetDeck
Apache, MySQL:InnoDB, MySQL:MyISAM, PHP, Linux, Ubuntu, Tomcat, Moodle, & LAMS all working together! Posting "how to" on blog over weekend. 5:30 PM Mar 6th from TweetDeck
Any MySQL gurus? vBulletin and InnoDB vs MyISAM  Bluelight - site profile Science & Technology - forum profile Any MySQL gurus? vBulletin and InnoDB vs MyISAM
Any MySQL gurus? vBulletin and InnoDB vs MyISAM
Mesclar innodb e myisam no mysql é punk... ha como usar...  Twitter / mingomax - site profile mingomax - forum profile Mesclar innodb e myisam no mysql é punk... ha como usar o melhor de cada numa mesma tabela? Jogar a responsa do negocio pro PHP? 2:31 PM Oct 22nd from TwitterFox
Mesclar innodb e myisam no mysql é punk... ha como usar o melhor de cada numa mesma tabela? Jogar a responsa do negocio pro PHP? 2:31 PM Oct 22nd from TwitterFox
O que acontece qdo vc mistura innodb e myisam numa...  waltercruz - Identi.ca - site profile waltercruz - forum profile O que acontece qdo vc mistura innodb e myisam numa transação? http://mysqlmusings.blogspot.com/2009/02/mixing-engines-in-transactions.html Published about 3 months ago From xmpp
O que acontece qdo vc mistura innodb e myisam numa transação? http://mysqlmusings.blogspot.com/2009/02/mixing-engines-in-transactions.html Published about 3 months ago From xmpp
Using Both Innodb And Myisam For Distributed Stats  Openads Community Forums - site profile 2.3 Administrators - Performance Tuning - forum profile Using Both Innodb And Myisam For Distributed Stats
Using Both Innodb And Myisam For Distributed Stats
InnoDB dan MyISAM geçiş  Ceviz Forum - site profile Veri Tabanı Tasarımı, Sistemleri, Araçları / SQL - forum profile InnoDB dan MyISAM geçiş
InnoDB dan MyISAM geçiş
Thread profile page for "Trouble reading from InnoDB and writing to MyISAM" on http://www.pentaho.org. This report page is a snippet summary view from a single thread "Trouble reading from InnoDB and writing to MyISAM", located on the Message Board at http://www.pentaho.org. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity