These are chat archives for collectiveaccess/support

9th
Sep 2016
Jeroen
@teranex
Sep 09 2016 12:04
Hi. I'm hosting a Collective Access instance, but I'm running in some serious trouble with high load on the server. This seems to be related to image processing. I already changed to queue processing, and setup the cron job to process the queue, but it seems that this causes the server to get a very high load. Initially I was using ImageMagick but due to some colorprofile problems I switched to GD. Is there a possibility to completely disable the tilepic generation, and just view the original image instead?
CollectiveAccess
@collectiveaccess
Sep 09 2016 12:05
Yeah, you can do that by modifying media_processing.conf to omit the tile pics versions
and then edit media_display.conf to use versions other than tilepic for display
Jeroen
@teranex
Sep 09 2016 12:05
@collectiveaccess ok, i'll give that a try, thx
CollectiveAccess
@collectiveaccess
Sep 09 2016 12:06
You might also want to try install GraphicsMagick + PHP gmagick
it's much much faster than anything else
Jeroen
@teranex
Sep 09 2016 12:06
aha, that is also interesting , thx!
CollectiveAccess
@collectiveaccess
Sep 09 2016 12:06
good luck
Jeroen
@teranex
Sep 09 2016 12:06
thx :)
CollectiveAccess
@collectiveaccess
Sep 09 2016 12:07
@eriwm If your system predates the new viewer you'll need to reprocess your media to generate zoomable versions of each page
ericwm
@eriwm
Sep 09 2016 14:03
@collectiveaccess . Thanks for the feedback. I was uploading my media via "add media representation" in an editor screen I named "Object Description" This screen is one of four others under my "Add New Object" . Since my latest update I can no longer access the "Object Description" screen. When I click on this I get a blank screen with Save, Cancel and Delete in the top left hand corner. Now I cannot delete or upload new media via this UI anymore. any suggestions.
stacia9904
@stacia9904_twitter
Sep 09 2016 15:20
Our CA site is slow and crashy, and we're getting the following message: [Fri Sep 09 11:06:45.947020 2016] [:error] [pid 5132:tid 880] [client 188.143.232.13:48991] PHP Fatal error: Maximum execution time of 120 seconds exceeded in D:\Apache24\htdocs\app\lib\core\Db\mysql.php on line 298, referer: http://libraryarchives.arlingtonva.us/index.php/Search/advanced/objects Any ideas?
Also The line 298 mentioned is this: if (!($r_res = mysql_query($vs_sql, $this->opr_db))) {
CollectiveAccess
@collectiveaccess
Sep 09 2016 15:21
sounds like a database query is hanging
I'd look at the MySQL log and process list
stacia9904
@stacia9904_twitter
Sep 09 2016 15:33
Hmm, nothing suspicious except perhaps: 2016-09-09 10:39:28 15504 [Note] InnoDB: The log sequence numbers 46823166251 and 46823166251 in ibdata files do not match the log sequence number 46824519938 in the ib_logfiles!
2016-09-09 10:39:28 15504 [Note] InnoDB: Database was not shutdown normally!
2016-09-09 10:39:28 15504 [Note] InnoDB: Starting crash recovery.
CollectiveAccess
@collectiveaccess
Sep 09 2016 15:42
do show processlist
are there processes hanging?
stacia9904
@stacia9904_twitter
Sep 09 2016 16:23
windows install - task manager shows top two processes:
Mysqld.exe (32-bit) is using 24% CPU and 1,364,188K RAM
Httpd.exe (32-bit) is using 0% CPU and 541,468K RAM
cascedu
@cascedu
Sep 09 2016 18:19
Hello, I'm having a bit of trouble with the objectSplitter during a Data Import (importing an XSLX file)...I'd like to have one of my source columns be split up into separate instances of the same metadata element: i.e. a record in the source column (S.W. Hason; R.T. Fuller) being split such that each of those two names becomes a separate "Name" value after an import. Right now, the mapping rule in my Excel importer spread looks like this: Mapping | 4 | ca_objects.names | objectSplitter | {"attributes":{"names":"^4"},"delimiter": ";"} but that throws me an error message. Am I missing a refinery parameter?
thanks for any help...sorry if that was all a little confusing!