Upgrade error: ALC-UPG-001-014: Failed to backup the LiveCycle 7 Database

[Former Community Member]

Hi,

We are trying to upgrade our existing Livecycle 7 to Livecycle ES 8.2.

The configuration manager completes the upgrade of JBoss successfully but when it proceeds to upgrade the MySQL database, it stops with the following error:

ALC-UPG-001-014: Failed to backup the LiveCycle 7 Database

There is no error present in the error log.

We also checked the configuration manager log file (lcm.0.log) and found the following entry:

--------------------------

[2010-04-20 09:30:21,307], INFO, Thread-279,  com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Backing up LiveCycle  7 database.

[2010-04-20 09:30:21,354], INFO, Thread-279,  com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running:  C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick --add-locks --lock-tables -c  --default-character-set=utf8 --skip-opt -padobe -u adobe -r  C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.sql -B  adobe --port=3306 --host=localhost

[2010-04-20 09:40:54,583], INFO, Thread-279,  com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value:  2

[2010-04-20 09:40:57,925], SEVERE, Thread-279,  com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Command failed on  return value: 2

[2010-04-20 09:40:58,300], SEVERE, Thread-279,  com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask,

---------------------------

We tried to backup the adobe MySQL database manually from the MySQL Administrator tool and that completes fine.

Can you please help us on how to proceed with the upgrade and what the problem could be?

Thanks

Vinay

[Hina_Rastogi]

Hi Vinay,

There are two screens related to database that you'd see while trying to upgrade from LiveCycle 7 to 8.

The first screen asks for information about your LiveCycle 7 MySQL which in most cases is on localhost:3306.

The LCM then connects to this database and migrates data to LiveCycle 8 MySQL in a subsequent step.

LiveCycle 8 MySQL in most cases is on localhost:1138 when you are performing an upgrade on the same machine which also has LiveCycle 7.

Could you confirm that you are providing correct ports in both the steps?

Thanks,

Hina

[Former Community Member]

Hi Hina,

There is no problem with the ports of MySQL of both Livecycle 7 and 8. (The Test connection button is successful as well).

During the MySQL upgrade step, the installation proceeds to around 8% and then stops with failure.

Also we further investigated this and noticed that the backup happens in the file adobe.sql present in C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql

Once the upgrade fails, we see that in this file, the back up process stops during the backing up of the MySQL table tb_form_data.

We are suspecting that the failure is due to some issue with backing up of this table.

Any further pointers will be appreciated.

Thanks

Vinay

[Hina_Rastogi]

Does this table contain a lot of entries?

I would like to have a look at the lcm and server logs.

Will it be possible for you to share them with me?

You can try one more thing.

Go to C:\Adobe\LiveCycle8.2\mysql and edit my.ini

Change the value of max_allowed_packet from 25M to a larger value (let's say 30M or 50M), restart MySQL service and then try again.

Thanks and Regards

Hina Rastogi

[Former Community Member]

Hi Hina,

The table contains around 8000 records. We tried changing the max_allowed_packet parameter to 50 but it didnt work.

Since the attachment option is disabled in this forum and log file is huge, I'm copy pasting the relevant server log and lcm log dump.

Server log:

-------------------------------------------------------------------------------

2010-04-20 14:59:31,453 INFO  [org.jboss.naming.NamingService] Started jndi bootstrap jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
2010-04-20 14:59:41,640 INFO  [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] SNMP agent going active
2010-04-20 14:59:42,812 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] Initializing
2010-04-20 14:59:42,875 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is MNGKTR51993:1064 (additional data: 16 bytes)
-------------------------------------------------------
2010-04-20 14:59:44,875 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] Number of cluster members: 1
2010-04-20 14:59:44,875 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] Other members: 0
2010-04-20 14:59:44,875 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] Fetching state (will wait for 30000 milliseconds):
2010-04-20 14:59:44,890 INFO  [org.jboss.ha.framework.interfaces.HAPartition.lifecycle.DefaultPartition] New cluster view for partition DefaultPartition (id: 0, delta: 0) : [10.94.65.27:1099]
2010-04-20 14:59:44,890 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] I am (null) received membershipChanged event:
2010-04-20 14:59:44,890 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] Dead members: 0 ([])
2010-04-20 14:59:44,890 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] New Members : 0 ([])
2010-04-20 14:59:44,890 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] All Members : 1 ([10.94.65.27:1099])
2010-04-20 14:59:44,968 INFO  [org.jboss.ha.jndi.HANamingService] Started ha-jndi bootstrap jnpPort=1100, backlog=50, bindAddress=/0.0.0.0
2010-04-20 14:59:47,578 INFO  [jacorb.orb] ORB run
2010-04-20 14:59:47,875 INFO  [org.jboss.iiop.CorbaNamingService] Naming: [IOR:000000000000002B49444C3A6F6D672E6F72672F436F734E616D696E672F4E616D696E67436F6E746578744578743A312E3000000000000200000000000000D8000102000000000C31302E39342E36352E3237000DC80000000000114A426F73732F4E616D696E672F726F6F74000000000000050000000000000008000000004A414300000000010000001C000000000001000100000001050100010001010900000001050100010000002100000050000000000000000100000000000000240000001E0000007E00000000000000010000000C31302E39342E36352E3237000DC90000000000000000000000000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
2010-04-20 14:59:48,125 INFO  [org.jboss.tm.iiop.CorbaTransactionService] TransactionFactory: [IOR:000000000000003049444C3A6F72672F6A626F73732F746D2F69696F702F5472616E73616374696F6E466163746F72794578743A312E30000000000200000000000000D8000102000000000C31302E39342E36352E3237000DC80000000000144A426F73732F5472616E73616374696F6E732F46000000050000000000000008000000004A414300000000010000001C000000000001000100000001050100010001010900000001050100010000002100000050000000000000000100000000000000240000001E0000007E00000000000000010000000C31302E39342E36352E3237000DC90000000000000000000000000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
2010-04-20 14:59:50,015 INFO  [org.jboss.mail.MailService] Mail Service bound to java:/Mail
2010-04-20 14:59:50,625 INFO  [org.jboss.cache.TreeCache] setting cluster properties from xml to: UDP(ip_mcast=false;ip_ttl=8;loopback=false;mcast_addr=230.1.2.7;mcast_port=45577;mcast_recv_buf_size=80000;mcast_send_buf_size=150000;ucast_recv_buf_size=80000;ucast_send_buf_size=150000):PING(down_thread=false;num_initial_members=3;timeout=2000;up_thread=false):MERGE2(max_interval=20000;min_interval=10000):FD_SOCK:VERIFY_SUSPECT(down_thread=false;timeout=1500;up_thread=false):pbcast.NAKACK(down_thread=false;gc_lag=50;max_xmit_size=8192;retransmit_timeout=600,1200,2400,4800;up_thread=false):UNICAST(down_thread=false;min_threshold=10;timeout=600,1200,2400;window_size=100):pbcast.STABLE(desired_avg_gossip=20000;down_thread=false;up_thread=false):FRAG(down_thread=false;frag_size=8192;up_thread=false):pbcast.GMS(join_retry_timeout=2000;join_timeout=5000;print_local_addr=true;shun=true):pbcast.STATE_TRANSFER(down_thread=true;up_thread=true)
2010-04-20 14:59:50,656 INFO  [org.jboss.cache.TreeCache] interceptor chain is:
class org.jboss.cache.interceptors.CallInterceptor
class org.jboss.cache.interceptors.LockInterceptor
class org.jboss.cache.interceptors.UnlockInterceptor
class org.jboss.cache.interceptors.ReplicationInterceptor
2010-04-20 14:59:50,656 INFO  [org.jboss.cache.TreeCache] cache mode is REPL_ASYNC
2010-04-20 14:59:50,671 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is MNGKTR51993:1067
-------------------------------------------------------
2010-04-20 14:59:52,687 INFO  [org.jboss.cache.TreeCache] viewAccepted(): new members: [MNGKTR51993:1067]
2010-04-20 14:59:52,687 INFO  [org.jboss.cache.TreeCache] new cache is null (maybe first member in cluster)
2010-04-20 14:59:52,687 INFO  [org.jboss.cache.TreeCache] state could not be retrieved (must be first member in group)
2010-04-20 14:59:52,968 INFO  [org.apache.catalina.startup.Embedded] Catalina naming disabled
2010-04-20 14:59:54,484 INFO  [org.apache.coyote.http11.Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
2010-04-20 14:59:54,500 INFO  [org.apache.catalina.startup.Catalina] Initialization processed in 1454 ms
2010-04-20 14:59:54,500 INFO  [org.jboss.web.tomcat.tc5.StandardService] Starting service jboss.web
2010-04-20 14:59:54,500 INFO  [org.apache.catalina.core.StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5
2010-04-20 14:59:54,546 INFO  [org.apache.catalina.core.StandardHost] XML validation disabled
2010-04-20 14:59:54,843 INFO  [org.apache.catalina.startup.Catalina] Server startup in 343 ms
2010-04-20 14:59:55,062 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/httpha-invoker.sar/invoker.war/
2010-04-20 14:59:55,468 INFO  [org.apache.catalina.loader.WebappLoader] Dual registration of jndi stream handler: factory already defined
2010-04-20 14:59:56,953 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] deploy, ctxPath=/ws4ee, warUrl=.../tmp/deploy/tmp52026jboss-ws4ee-exp.war/
2010-04-20 14:59:57,718 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
2010-04-20 14:59:57,984 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] deploy, ctxPath=/juddi, warUrl=.../deploy/juddi-service.sar/juddiws.war/
2010-04-20 14:59:59,984 INFO  [org.apache.juddi.registry.RegistryServlet] Loading jUDDI configuration.
2010-04-20 15:00:00,000 INFO  [org.apache.juddi.registry.RegistryServlet] Resources loaded from: /WEB-INF/juddi.properties
2010-04-20 15:00:00,000 INFO  [org.apache.juddi.registry.RegistryServlet] Initializing jUDDI components.
2010-04-20 15:00:01,484 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy-hasingleton/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
2010-04-20 15:00:02,359 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
2010-04-20 15:00:03,046 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
2010-04-20 15:00:03,750 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
2010-04-20 15:00:04,359 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
2010-04-20 15:00:04,562 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
2010-04-20 15:00:04,968 INFO  [org.jboss.resource.deployment.RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
2010-04-20 15:00:05,640 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=IDP_DS' to JNDI name 'java:IDP_DS'
2010-04-20 15:00:05,875 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=EDC_DS' to JNDI name 'java:EDC_DS'
2010-04-20 15:00:05,875 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=com.celequest.metadata.metaDatasource' to JNDI name 'java:com.celequest.metadata.metaDatasource'
2010-04-20 15:00:06,296 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
2010-04-20 15:00:06,312 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=adobe_JmsQueueXA' to JNDI name 'java:adobe_JmsQueueXA'
2010-04-20 15:00:06,687 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=adobe_JmsTopicXA' to JNDI name 'java:adobe_JmsTopicXA'
2010-04-20 15:00:06,875 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
2010-04-20 15:00:09,703 INFO  [org.jboss.mq.server.jmx.Queue.A] Bound to JNDI name: queue/A
2010-04-20 15:00:09,890 INFO  [org.jboss.mq.server.jmx.Queue.B] Bound to JNDI name: queue/B
2010-04-20 15:00:10,046 INFO  [org.jboss.mq.server.jmx.Queue.C] Bound to JNDI name: queue/C
2010-04-20 15:00:10,187 INFO  [org.jboss.mq.server.jmx.Queue.D] Bound to JNDI name: queue/D
2010-04-20 15:00:10,359 INFO  [org.jboss.mq.server.jmx.Queue.ex] Bound to JNDI name: queue/ex
2010-04-20 15:00:10,562 INFO  [org.jboss.mq.server.jmx.Topic.testTopic] Bound to JNDI name: topic/testTopic
2010-04-20 15:00:10,781 INFO  [org.jboss.mq.server.jmx.Topic.securedTopic] Bound to JNDI name: topic/securedTopic
2010-04-20 15:00:10,968 INFO  [org.jboss.mq.server.jmx.Topic.testDurableTopic] Bound to JNDI name: topic/testDurableTopic
2010-04-20 15:00:11,125 INFO  [org.jboss.mq.server.jmx.Queue.testQueue] Bound to JNDI name: queue/testQueue
2010-04-20 15:00:11,171 INFO  [org.jboss.mq.il.uil2.UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
2010-04-20 15:00:11,406 INFO  [org.jboss.mq.server.jmx.Queue.DLQ] Bound to JNDI name: queue/DLQ
2010-04-20 15:00:11,640 INFO  [org.jboss.mq.server.jmx.Queue.adobe_PECommandQueue] Bound to JNDI name: queue/adobe_PECommandQueue
2010-04-20 15:00:11,812 INFO  [org.jboss.mq.server.jmx.Queue.adobe_PEDCommandQueue] Bound to JNDI name: queue/adobe_PEDCommandQueue
2010-04-20 15:00:11,984 INFO  [org.jboss.mq.server.jmx.Queue.adobe_PEInteractionQueue] Bound to JNDI name: queue/adobe_PEInteractionQueue
2010-04-20 15:00:12,218 INFO  [org.jboss.mq.server.jmx.Queue.adobe_JobManagerQueue] Bound to JNDI name: queue/adobe_JobManagerQueue
2010-04-20 15:00:12,375 INFO  [org.jboss.mq.server.jmx.Topic.adobe_TaskEventTopic] Bound to JNDI name: topic/adobe_TaskEventTopic
2010-04-20 15:00:13,031 INFO  [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
2010-04-20 15:00:13,484 INFO  [org.apache.jk.common.ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
2010-04-20 15:00:13,500 INFO  [org.apache.jk.server.JkMain] Jk running ID=0 time=0/375  config=null
2010-04-20 15:00:13,718 INFO  [org.jboss.system.server.Server] JBoss (MX MicroKernel) [4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231054)] Started in 52s:250ms

---------------------------------------------------------------------------------------------------------

LCM log:

[2010-04-19 16:32:52,354], INFO, Thread-178, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Starting the MySQL upgrade process...
[2010-04-19 16:32:52,370], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: sc query "MySQL for Adobe LiveCycle"
[2010-04-19 16:32:52,463], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 0
[2010-04-19 16:32:52,463], INFO, Thread-178, com.adobe.livecycle.lcm.util.ServiceUtils, State: 4,RUNNING
[2010-04-19 16:32:52,463], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: sc query "MySQL for Adobe LiveCycle ES"
[2010-04-19 16:32:52,557], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 0
[2010-04-19 16:32:52,557], INFO, Thread-178, com.adobe.livecycle.lcm.util.ServiceUtils, State: 4,RUNNING
[2010-04-19 16:32:52,557], INFO, Thread-178, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Backing up LiveCycle 7 database.
[2010-04-19 16:32:52,557], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick --add-locks --lock-tables -c --default-character-set=utf8 --skip-opt -padobe -u adobe -r C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.sql -B adobe --port=3306 --host=localhost 
[2010-04-19 16:32:52,932], INFO, Thread-178, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 2
[2010-04-19 16:32:52,932], SEVERE, Thread-178, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Command failed on return value: 2
[2010-04-19 16:32:52,932], SEVERE, Thread-178, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask,
[2010-04-19 16:33:59,364], INFO, AWT-EventQueue-0, com.adobe.livecycle.upgrade.gui.MysqlEngineUpgradeDialog, onExit(com.adobe.livecycle.lcm.gui.LCMDialogExitEvent: PREVIOUS)
[2010-04-19 16:33:59,364], INFO, AWT-EventQueue-0, com.adobe.livecycle.upgrade.gui.StopLiveCycle7Dialog, onEntry()
[2010-04-19 16:34:00,723], INFO, AWT-EventQueue-0, com.adobe.livecycle.upgrade.gui.StopLiveCycle7Dialog, onExit(com.adobe.livecycle.lcm.gui.LCMDialogExitEvent: NEXT)
[2010-04-19 16:34:00,738], INFO, AWT-EventQueue-0, com.adobe.livecycle.upgrade.gui.MysqlEngineUpgradeDialog, onEntry()
[2010-04-19 16:34:02,737], INFO, Thread-185, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Starting the MySQL upgrade process...
[2010-04-19 16:34:02,753], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: sc query "MySQL for Adobe LiveCycle"
[2010-04-19 16:34:02,815], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 0
[2010-04-19 16:34:02,815], INFO, Thread-185, com.adobe.livecycle.lcm.util.ServiceUtils, State: 4,RUNNING
[2010-04-19 16:34:02,815], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: sc query "MySQL for Adobe LiveCycle ES"
[2010-04-19 16:34:02,893], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 0
[2010-04-19 16:34:02,893], INFO, Thread-185, com.adobe.livecycle.lcm.util.ServiceUtils, State: 4,RUNNING
[2010-04-19 16:34:02,893], INFO, Thread-185, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Backing up LiveCycle 7 database.
[2010-04-19 16:34:02,909], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Running: C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick --add-locks --lock-tables -c --default-character-set=utf8 --skip-opt -padobe -u adobe -r C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.sql -B adobe --port=3306 --host=localhost 
[2010-04-19 16:34:03,221], INFO, Thread-185, com.adobe.livecycle.lcm.util.process.ProcessExecutor, Return value: 2
[2010-04-19 16:34:03,221], SEVERE, Thread-185, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask, Command failed on return value: 2
[2010-04-19 16:34:03,221], SEVERE, Thread-185, com.adobe.livecycle.upgrade.control.MysqlEngineUpgradeTask,

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks

Vinay

[Hina_Rastogi]

C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick --add-locks --lock-tables -c --default-character-set=utf8 --skip-opt -padobe -u adobe -r C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.sql -B adobe --port=3306 --host=localhost

Can you try running this command and let me know what is the error that comes in command prompt?

Thanks and Regards

Hina Rastogi

[Former Community Member]

Hi Hina,

The following error comes up in the command prompt:

-------------------------------------------

C:\Documents and Settings\bob>C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick
--add-locks --lock-tables -c --default-character-set=utf8 --skip-opt -padobe -u
adobe -r C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.
sql -B adobe --port=3306 --host=localhost
mysqldump: Out of memory (Needed 10380928 bytes)
mysqldump: Got error: 2008: MySQL client ran out of memory when retrieving data
from server

------------------------------------------

We also checked the MySQL error log present @ C:\Adobe\LiveCycle\mysql\data\ MNGKTR51993.err and noticed the following entry:

-------------------------------------------

100420 15:16:39  InnoDB: Error: cannot allocate 4814100 bytes  of memory for

InnoDB: a BLOB with malloc! Total allocated  memory

InnoDB: by InnoDB 33427880 bytes. Operating system errno:  2

InnoDB: Check if you should increase the swap file  or

InnoDB: ulimits of your operating system.

InnoDB: On FreeBSD check you have compiled the OS  with

InnoDB: a big enough maximum process size.

100420 15:16:40  InnoDB: Warning: could not allocate 3814100  + 1000000 bytes to retrieve

InnoDB: a big column. Table name  `adobe/tb_form_data`

--------------------------------------------

Thanks

Vinay

[Hina_Rastogi]

Hi Vinay,

Modify the following settings in my.ini of LiveCycle 7 MySQL database.

innodb_buffer_pool_size=1024M (Approx. 50% - 80% of system RAM. But don't set it too high)

innodb_additional_mem_pool_size=20M

I realize my earlier mistake.

Even the max_allowed_packet setting should have been changed for LiveCycle 7 MySQL database as LCM is connected to LiveCycle 7 MySQL database here.

Restart LiveCycle 7 MySQL database service and then try the command I sent in my earlier post.

Let me know the results.

Thanks and Regards

Hina Rastogi

[Former Community Member]

Hi Hina,

We tried the setttings suggested by you and observed the following error now:

Command prompt:

C:\Documents and  Settings\bob>C:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick

--add-locks --lock-tables -c --default-character-set=utf8  --skip-opt -padobe -u

adobe -r  C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.

sql -B adobe --port=3306 --host=localhost

mysqldump: Got error: 1030: Got error 139 from storage engine  when retrieving data from server

Error Log:

100421 12:12:53  InnoDB: Started; log sequence number 2  4008206866

C:\Adobe\LiveCycle\mysql\bin\mysqld-max-nt.exe: ready for  connections.

Version: '4.1.9-nt-max'  socket: ''  port: 3306  Source  distribution

100421 12:42:08  InnoDB: Error: cannot allocate 4814112 bytes  of memory for

InnoDB: a BLOB with malloc! Total allocated  memory

InnoDB: by InnoDB 1149039128 bytes. Operating system errno:  2

InnoDB: Check if you should increase the swap file  or

InnoDB: ulimits of your operating system.

InnoDB: On FreeBSD check you have compiled the OS  with

InnoDB: a big enough maximum process size.

100421 12:42:08  InnoDB: Warning: could not allocate 3814112  + 1000000 bytes to retrieve

InnoDB: a big column. Table name `adobe/tb_form_data`

Thanks

Vinay