The problem with Barro is still with us. Mon Jul 13 23:11:37 2009 request: source: /home/aras/acis/bin/updareq [17370] collection: ACIS update: /r/b/rbarro@harvard.edu.xml () U DATAFILE_START: r/b/rbarro@harvard.edu.xml RECORD OLD: rbarro@harvard.edu Mon Jul 13 23:11:49 2009 Error: cannot store record 'repec:per:2005-04-12:robert_j_barro' in ObjectDB at /home/aras/acis/lib/ARDB.pm line 190. Barro and Heckman (the other case) are large aras@nebka:~$ ls -l acis/userdata/r/b/rbarro\@harvard.edu.xml -rw-r--r-- 1 aras aras 6165312 2009-07-10 16:53 acis/userdata/r/b/rbarro@harvard.edu.xml I suspect there is some size limitation that we are hitting. Cheers, Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel skype: thomaskrichel
check the sql.log, what does it say? -i On Tue, Jul 21, 2009 at 5:44 AM, Thomas Krichel<krichel@openlib.org> wrote:
The problem with Barro is still with us.
Mon Jul 13 23:11:37 2009 request: source: /home/aras/acis/bin/updareq [17370] collection: ACIS update: /r/b/rbarro@harvard.edu.xml () U DATAFILE_START: r/b/rbarro@harvard.edu.xml RECORD OLD: rbarro@harvard.edu Mon Jul 13 23:11:49 2009 Error: cannot store record 'repec:per:2005-04-12:robert_j_barro' in ObjectDB at /home/aras/acis/lib/ARDB.pm line 190.
Barro and Heckman (the other case) are large
aras@nebka:~$ ls -l acis/userdata/r/b/rbarro\@harvard.edu.xml -rw-r--r-- 1 aras aras 6165312 2009-07-10 16:53 acis/userdata/r/b/rbarro@harvard.edu.xml
I suspect there is some size limitation that we are hitting.
Cheers,
Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel skype: thomaskrichel
_______________________________________________ RAS-run mailing list RAS-run@lists.openlib.org http://lists.openlib.org/cgi-bin/mailman/listinfo/ras-run
Ivan Kurmanov writes
check the sql.log, what does it say?
execute res: Got a packet bigger than 'max_allowed_packet' bytes This gives you an idea about the size aras@nebka:~$ ls -lt /tmp/barro.log -rw-r--r-- 1 aras aras 4618246 2009-07-21 19:32 /tmp/barro.log Should I study the docs to see how to raise the limit? Cheers, Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel skype: thomaskrichel
I don't know what is /tmp/barro.log, but you definitely can solve this by setting max_allowed_packet to a large enough value. http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html says: "Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server." you should be able to set both server and client variables in /etc/my.cnf max_allowed_packet=16M in the [mysqld] section (for the server) and probably the [client] section for the client. -i On Wed, Jul 22, 2009 at 2:38 AM, Thomas Krichel<krichel@openlib.org> wrote:
Ivan Kurmanov writes
check the sql.log, what does it say?
execute res: Got a packet bigger than 'max_allowed_packet' bytes
This gives you an idea about the size
aras@nebka:~$ ls -lt /tmp/barro.log -rw-r--r-- 1 aras aras 4618246 2009-07-21 19:32 /tmp/barro.log
Should I study the docs to see how to raise the limit?
Cheers,
Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel skype: thomaskrichel
participants (2)
-
Ivan Kurmanov -
Thomas Krichel