[ckan-dev] Problems with adding datasets (upload/link)

Denis Zgonjanin deniszgonjanin at gmail.com
Sat Jul 18 20:16:31 UTC 2015


Hi Filip,

Looks like a database permissions problem. Re-check these steps:
http://docs.ckan.org/en/latest/maintaining/installing/install-from-source.html#postgres-setup

Make sure the 'ckan_default' postgres user has access privileges to the
ckan databases

- Denis

On Sat, Jul 18, 2015 at 3:52 PM, Filip Radulovic <filiprd at gmail.com> wrote:

> Hi all,
>
> I've installed CKAN on Ubuntu 12.04 using packages and I have a problem
> with adding datasets. Before I describe the problem, I shall say that I
> have searched for solutions and I am still not able to solve it.
>
> I can open the CKAN in browser and I have created a sysadmin account, but
> I have problems when adding datasets. Regardless if I try to do it by
> uploading a file or by giving the link to a file, it gives me the 500
> internal server error.
> I have followed all the steps of the installation and I put special
> attention to www-data permissions.
>
> I have also tried to add a test data from the command line using paster
> command. After that, when I go to CKAN it says that there is one dataset
> found; however I can't see it at all. This is what came out in the terminal
> so you will see there is probably a permission problem:
>
> Running setup_app() from ckan.websetup
> 2015-07-18 21:17:09,251 INFO  [ckan.websetup] Creating tables: SUCCESS
> Creating basic test data
> /usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:79:
> SAWarning: Usage of the 'related attribute set' operation is not currently
> supported within the execution stage of the flush process. Results may not
> be consistent.  Consider using alternative event listeners or
> connection-level operations instead.
>   sess._flush_warning("related attribute set")
> 2015-07-18 21:17:11,068 ERROR [ckan.model.modification] (ProgrammingError)
> permission denied for relation _table_metadata
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'26cde6ab-c77e-4719-b696-8bec27bd52e1',)
> Traceback (most recent call last):
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/modification.py", line
> 84, in notify
>     observer.notify(entity, operation)
>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/search/__init__.py", line
> 128, in notify
>     {'id': entity.id}),
>   File "/usr/lib/ckan/default/src/ckan/ckan/logic/__init__.py", line 424,
> in wrapped
>     result = _action(context, data_dict, **kw)
>   File "/usr/lib/ckan/default/src/ckan/ckan/logic/action/get.py", line
> 975, in package_show
>     resource_dict = item.before_show(resource_dict)
>   File "/usr/lib/ckan/default/src/ckan/ckanext/datastore/plugin.py", line
> 284, in before_show
>     resource_dict['id']
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 719, in execute
>     return self._execute_text(object, multiparams, params)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 868, in _execute_text
>     statement, parameters
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 954, in _execute_context
>     context)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1116, in _handle_dbapi_exception
>     exc_info
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
> line 189, in raise_from_cause
>     reraise(type(exception), exception, tb=exc_tb)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 947, in _execute_context
>     context)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
> line 435, in do_execute
>     cursor.execute(statement, parameters)
> ProgrammingError: (ProgrammingError) permission denied for relation
> _table_metadata
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'26cde6ab-c77e-4719-b696-8bec27bd52e1',)
> Traceback (most recent call last):
>   File "/usr/lib/ckan/default/bin/paster", line 9, in <module>
>     load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/paste/script/command.py",
> line 104, in run
>     invoke(command, command_name, options, args[1:])
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/paste/script/command.py",
> line 143, in invoke
>     exit_code = runner.run(args)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/paste/script/command.py",
> line 238, in run
>     result = self.command()
>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 1443, in
> command
>     CreateTestData.create_basic_test_data()
>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/create_test_data.py", line
> 26, in create_basic_test_data
>     cls.create()
>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/create_test_data.py", line
> 517, in create
>     model.repo.commit_and_remove()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/vdm/sqlalchemy/tools.py",
> line 117, in commit_and_remove
>     self.commit()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/vdm/sqlalchemy/tools.py",
> line 107, in commit
>     self.session.commit()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py",
> line 149, in do
>     return getattr(self.registry(), name)(*args, **kwargs)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
> line 768, in commit
>     self.transaction.commit()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
> line 370, in commit
>     self._prepare_impl()
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
> line 339, in _prepare_impl
>     self.session.dispatch.before_commit(self.session)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py",
> line 257, in __call__
>     fn(*args, **kw)
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/extension.py", line 112,
> in before_commit
>     methodcaller('before_commit', session)
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/extension.py", line 92,
> in notify_observers
>     func(observer)
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/modification.py", line
> 35, in before_commit
>     self.notify_observers(session, self.notify)
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/modification.py", line
> 52, in notify_observers
>     method(obj, domain_object.DomainObjectOperation.new)
>   File "/usr/lib/ckan/default/src/ckan/ckan/model/modification.py", line
> 84, in notify
>     observer.notify(entity, operation)
>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/search/__init__.py", line
> 128, in notify
>     {'id': entity.id}),
>   File "/usr/lib/ckan/default/src/ckan/ckan/logic/__init__.py", line 424,
> in wrapped
>     result = _action(context, data_dict, **kw)
>   File "/usr/lib/ckan/default/src/ckan/ckan/logic/action/get.py", line
> 975, in package_show
>     resource_dict = item.before_show(resource_dict)
>   File "/usr/lib/ckan/default/src/ckan/ckanext/datastore/plugin.py", line
> 284, in before_show
>     resource_dict['id']
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 719, in execute
>     return self._execute_text(object, multiparams, params)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 868, in _execute_text
>     statement, parameters
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 954, in _execute_context
>     context)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1116, in _handle_dbapi_exception
>     exc_info
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
> line 189, in raise_from_cause
>     reraise(type(exception), exception, tb=exc_tb)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 947, in _execute_context
>     context)
>   File
> "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
> line 435, in do_execute
>     cursor.execute(statement, parameters)
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied for
> relation _table_metadata
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'26cde6ab-c77e-4719-b696-8bec27bd52e1',)
>
>
> In one of the previous threads someone mentioned the ps aux command, so I
> copy the output here if that will help to get some useful information about
> the problem.
>
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> root         1  0.0  0.0  24580  2448 ?        Ss   16:10   0:01 /sbin/init
> root         2  0.0  0.0      0     0 ?        S    16:10   0:00 [kthreadd]
> root         3  0.0  0.0      0     0 ?        S    16:10   0:02
> [ksoftirqd/0]
> root         5  0.0  0.0      0     0 ?        S<   16:10   0:00
> [kworker/0:0H]
> root         7  0.0  0.0      0     0 ?        S    16:10   0:17
> [rcu_sched]
> root         8  0.0  0.0      0     0 ?        S    16:10   0:18 [rcuos/0]
> root         9  0.0  0.0      0     0 ?        S    16:10   0:00 [rcu_bh]
> root        10  0.0  0.0      0     0 ?        S    16:10   0:00 [rcuob/0]
> root        11  0.0  0.0      0     0 ?        S    16:10   0:00
> [migration/0]
> root        12  0.0  0.0      0     0 ?        S    16:10   0:01
> [watchdog/0]
> root        13  0.0  0.0      0     0 ?        S<   16:10   0:00 [khelper]
> root        14  0.0  0.0      0     0 ?        S    16:10   0:00
> [kdevtmpfs]
> root        15  0.0  0.0      0     0 ?        S<   16:10   0:00 [netns]
> root        16  0.0  0.0      0     0 ?        S<   16:10   0:00
> [writeback]
> root        17  0.0  0.0      0     0 ?        S<   16:10   0:00
> [kintegrityd]
> root        18  0.0  0.0      0     0 ?        S<   16:10   0:00 [bioset]
> root        20  0.0  0.0      0     0 ?        S<   16:10   0:00 [kblockd]
> root        21  0.0  0.0      0     0 ?        S<   16:10   0:00 [ata_sff]
> root        22  0.0  0.0      0     0 ?        S    16:10   0:00 [khubd]
> root        23  0.0  0.0      0     0 ?        S<   16:10   0:00 [md]
> root        24  0.0  0.0      0     0 ?        S<   16:10   0:00
> [devfreq_wq]
> root        26  0.0  0.0      0     0 ?        S    16:10   0:00
> [khungtaskd]
> root        27  0.0  0.0      0     0 ?        S    16:10   0:00 [kswapd0]
> root        28  0.0  0.0      0     0 ?        SN   16:10   0:00 [ksmd]
> root        29  0.0  0.0      0     0 ?        SN   16:10   0:02
> [khugepaged]
> root        30  0.0  0.0      0     0 ?        S    16:10   0:00
> [fsnotify_mark]
> root        31  0.0  0.0      0     0 ?        S    16:10   0:00
> [ecryptfs-kthrea]
> root        32  0.0  0.0      0     0 ?        S<   16:10   0:00 [crypto]
> root        44  0.0  0.0      0     0 ?        S<   16:10   0:00 [kthrotld]
> root        46  0.0  0.0      0     0 ?        S    16:10   0:00
> [scsi_eh_0]
> root        47  0.0  0.0      0     0 ?        S    16:10   0:00
> [scsi_eh_1]
> root        68  0.0  0.0      0     0 ?        S<   16:10   0:00 [deferwq]
> root        69  0.0  0.0      0     0 ?        S<   16:10   0:00
> [charger_manager]
> root       177  0.0  0.0      0     0 ?        S    16:10   0:00
> [scsi_eh_2]
> root       203  0.0  0.0      0     0 ?        S    16:10   0:03
> [jbd2/sda1-8]
> root       204  0.0  0.0      0     0 ?        S<   16:10   0:00
> [ext4-rsv-conver]
> root       294  0.0  0.0  17240   636 ?        S    16:10   0:00
> upstart-udev-bridg
> root       299  0.0  0.0  21764  1608 ?        Ss   16:10   0:00
> /sbin/udevd --daem
> syslog     495  0.0  0.0 249480  1480 ?        Sl   16:10   0:00 rsyslogd
> -c5
> root       512  0.0  0.0      0     0 ?        S<   16:10   0:00 [iprt]
> root       537  0.0  0.0      0     0 ?        S<   16:10   0:00
> [kpsmoused]
> 102        540  0.0  0.0  25004  2200 ?        Ss   16:10   0:05
> dbus-daemon --syst
> root       598  0.0  0.0  21760  1152 ?        S    16:10   0:00
> /sbin/udevd --daem
> root       613  0.0  0.0  21760  1144 ?        S    16:10   0:00
> /sbin/udevd --daem
> root       623  0.0  0.0  21196  1696 ?        Ss   16:10   0:00
> /usr/sbin/bluetoot
> avahi      627  0.0  0.0  32320  1768 ?        S    16:10   0:00
> avahi-daemon: runn
> avahi      633  0.0  0.0  32188   468 ?        S    16:10   0:00
> avahi-daemon: chro
> root       682  0.0  0.1 104160  4184 ?        Ss   16:10   0:00
> /usr/sbin/cupsd -F
> root       697  0.0  0.0  15196   616 ?        S    16:10   0:00
> upstart-socket-bri
> root       717  0.0  0.0      0     0 ?        S<   16:10   0:00 [krfcommd]
> root       740  0.0  0.0  79048  3184 ?        Ss   16:11   0:00
> /usr/sbin/modem-ma
> root       771  0.0  0.1 249308  6012 ?        Ssl  16:11   0:00
> NetworkManager
> root       791  0.0  0.1 212372  4880 ?        Sl   16:11   0:00
> /usr/lib/policykit
> root       822  0.0  0.0   7272  1560 ?        S    16:11   0:00
> /sbin/dhclient -d
> root       863  0.0  0.0  19996   972 tty4     Ss+  16:11   0:00
> /sbin/getty -8 384
> root       869  0.0  0.0  19996   972 tty5     Ss+  16:11   0:00
> /sbin/getty -8 384
> root       881  0.0  0.0  19996   968 tty2     Ss+  16:11   0:00
> /sbin/getty -8 384
> root       882  0.0  0.0  19996   976 tty3     Ss+  16:11   0:00
> /sbin/getty -8 384
> root       884  0.0  0.0  19996   976 tty6     Ss+  16:11   0:00
> /sbin/getty -8 384
> root       890  0.0  0.0   4500   816 ?        Ss   16:11   0:00 acpid -c
> /etc/acpi
> root       892  0.0  0.0  19120  1024 ?        Ss   16:11   0:00 cron
> daemon     897  0.0  0.0  16916   376 ?        Ss   16:11   0:00 atd
> root       898  0.0  0.1 287600  6300 ?        Ssl  16:11   0:00 lightdm
> whoopsie   933  0.0  0.1 208864  5304 ?        Ssl  16:11   0:00 whoopsie
> root       936  3.1  2.1 263940 86964 tty7     Ss+  16:11   9:57
> /usr/bin/X :0 -aut
> root       966  0.0  0.0 241152  1328 ?        Sl   16:11   0:14
> /usr/sbin/VBoxServ
> root       975  0.0  0.0 584304  3848 ?        Sl   16:11   0:02
> /usr/sbin/console-
> nobody     976  0.0  0.0  33032  1512 ?        S    16:11   0:01
> /usr/sbin/dnsmasq
> root      1279  0.0  0.0  19996   976 tty1     Ss+  16:11   0:00
> /sbin/getty -8 384
> root      1284  0.0  0.1 169476  4220 ?        Sl   16:11   0:00 lightdm
> --session-
> root      1287  0.0  0.1 136164  4560 ?        Sl   16:11   0:01
> /usr/lib/accountss
> filiprd   1318  0.0  0.2 402944 11420 ?        Ssl  16:11   0:02
> gnome-session --se
> filiprd   1362  0.0  0.0  49244   300 ?        S    16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1363  0.0  0.0 117500  1840 ?        Sl   16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1371  0.0  0.0  49244   300 ?        S    16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1373  0.0  0.0 115444  1244 ?        Sl   16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1380  0.0  0.0  49244   304 ?        S    16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1381  0.0  0.0 115444  1056 ?        Sl   16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1386  0.0  0.0  49244   304 ?        S    16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1388  0.0  0.0 116224  1500 ?        Sl   16:11   0:00
> /usr/bin/VBoxClien
> filiprd   1393  0.0  0.0  12576   320 ?        Ss   16:11   0:00
> /usr/bin/ssh-agent
> filiprd   1396  0.0  0.0  26568   540 ?        S    16:11   0:00
> /usr/bin/dbus-laun
> filiprd   1397  0.1  0.0  27616  3392 ?        Ss   16:11   0:23
> //bin/dbus-daemon
> filiprd   1409  0.0  0.4 692628 19428 ?        Sl   16:11   0:10
> /usr/lib/gnome-set
> filiprd   1410  0.0  0.1 531984  6484 ?        Sl   16:11   0:00
> /usr/bin/gnome-key
> root      1420  0.0  0.1 219976  4424 ?        Sl   16:11   0:00
> /usr/lib/upower/up
> filiprd   1482  0.0  0.0  52392  2456 ?        S    16:11   0:00
> /usr/lib/gvfs/gvfs
> filiprd   1493  0.0  0.0 285912  3620 ?        Sl   16:11   0:00
> /usr/lib/gvfs//gvf
> colord    1526  0.0  0.3 507412 12380 ?        Sl   16:11   0:00
> /usr/lib/x86_64-li
> filiprd   1527  0.2  0.4 530380 17848 ?        Sl   16:11   0:56 metacity
> filiprd   1540  0.0  0.1 362896  5940 ?        S<l  16:11   0:05
> /usr/bin/pulseaudi
> rtkit     1542  0.0  0.0 168880  1328 ?        SNl  16:11   0:00
> /usr/lib/rtkit/rtk
> filiprd   1546  0.0  0.0  57764  3420 ?        S    16:11   0:00
> /usr/lib/x86_64-li
> filiprd   1547  0.1  0.8 620216 33832 ?        Sl   16:11   0:20
> unity-2d-panel
> filiprd   1550  0.3  2.0 1077580 83428 ?       Sl   16:11   1:07
> unity-2d-shell
> filiprd   1551  0.0  0.0  95964  2992 ?        S    16:11   0:00
> /usr/lib/pulseaudi
> filiprd   1556  0.0  0.2 315756 10368 ?        Sl   16:11   0:01
> /usr/lib/policykit
> filiprd   1557  0.0  0.2 461060 10112 ?        Sl   16:11   0:01
> /usr/lib/gnome-set
> filiprd   1558  0.0  0.3 440920 13564 ?        Sl   16:11   0:01
> bluetooth-applet
> filiprd   1560  0.0  0.4 515248 17188 ?        Sl   16:11   0:02 nm-applet
> filiprd   1566  0.2  1.1 1068264 45496 ?       Sl   16:11   0:57 nautilus
> -n
> filiprd   1568  0.1  0.2 400788 11768 ?        Sl   16:11   0:23
> /usr/lib/bamf/bamf
> filiprd   1587  0.0  0.1 228228  4892 ?        S    16:11   0:00
> /usr/lib/gvfs/gvfs
> root      1599  0.0  0.0 201748  3852 ?        Sl   16:11   0:00
> /usr/lib/udisks/ud
> root      1604  0.0  0.0  45524   800 ?        S    16:11   0:00
> udisks-daemon: not
> filiprd   1615  0.0  0.0  60348  2456 ?        S    16:11   0:00
> /usr/lib/gvfs/gvfs
> filiprd   1619  0.0  0.0 142092  2528 ?        Sl   16:11   0:00
> /usr/lib/gvfs/gvfs
> filiprd   1634  0.0  0.0 261968  2668 ?        Sl   16:11   0:00
> /usr/lib/dconf/dco
> filiprd   1640  0.0  0.1  69540  4124 ?        S    16:11   0:00
> /usr/lib/gvfs/gvfs
> filiprd   1647  0.1  0.7 543068 29604 ?        Sl   16:11   0:23
> /usr/lib/unity/uni
> filiprd   1649  0.0  0.0  52552  2616 ?        S    16:11   0:00
> /usr/lib/gvfs/gvfs
> filiprd   1655  0.0  0.1 421612  5076 ?        Sl   16:11   0:00
> /usr/lib/indicator
> filiprd   1657  0.0  0.2 377452  9056 ?        Sl   16:11   0:00
> /usr/lib/indicator
> filiprd   1664  0.0  0.2 431892 11752 ?        Sl   16:11   0:02
> /usr/lib/indicator
> filiprd   1696  0.0  0.2 339800 10672 ?        Sl   16:11   0:01
> /usr/lib/gnome-dis
> filiprd   1702  0.0  0.0  47868  2716 ?        S    16:11   0:00
> /usr/lib/geoclue/g
> filiprd   1714  0.0  0.1 339396  6736 ?        Sl   16:11   0:00
> /usr/lib/ubuntu-ge
> filiprd   1718  0.0  0.1 537120  7552 ?        Sl   16:11   0:00
> /usr/lib/indicator
> filiprd   1721  0.0  0.1 540424  7164 ?        Sl   16:11   0:00
> /usr/lib/indicator
> filiprd   1722  0.0  0.2 491112  8148 ?        Sl   16:11   0:00
> /usr/lib/indicator
> filiprd   1748  0.0  0.2 653672 10932 ?        Sl   16:11   0:13
> /usr/lib/indicator
> filiprd   1761  0.0  0.2 432380 11976 ?        Sl   16:11   0:01
> telepathy-indicato
> filiprd   1762  0.0  0.3 418336 12220 ?        Sl   16:11   0:02
> /usr/lib/unity-len
> filiprd   1763  0.0  0.1 485644  6840 ?        Sl   16:11   0:02
> /usr/lib/unity-len
> filiprd   1764  0.0  0.2 480492 10600 ?        Sl   16:11   0:01
> /usr/lib/unity-len
> filiprd   1766  0.0  0.4 519236 16712 ?        Sl   16:11   0:00
> /usr/bin/python /u
> filiprd   1785  0.0  0.1 295172  7720 ?        Sl   16:11   0:01
> /usr/bin/zeitgeist
> filiprd   1792  0.0  0.1 336052  7168 ?        Sl   16:11   0:00
> /usr/lib/telepathy
> filiprd   1801  0.0  0.2 249932  9464 ?        Sl   16:11   0:00
> /usr/lib/zeitgeist
> filiprd   1803  0.0  0.1 427184  6396 ?        Sl   16:11   0:02
> zeitgeist-datahub
> filiprd   1809  0.0  0.0  11392   356 ?        S    16:11   0:00 /bin/cat
> filiprd   1813  0.0  0.3 404440 13840 ?        Sl   16:11   0:00
> /usr/lib/gnome-onl
> filiprd   1825  0.0  0.1 324148  6376 ?        Sl   16:11   0:00
> /usr/lib/unity-len
> filiprd   1841  0.0  0.2 318152 10496 ?        Sl   16:11   0:02
> gnome-screensaver
> filiprd   1856  0.0  0.5 568232 22032 ?        Sl   16:11   0:01
> /usr/bin/python /u
> filiprd   1874  4.8  6.7 1056500 272812 ?      Sl   16:12  15:18
> /usr/lib/firefox/f
> filiprd   1893  0.0  0.1 293116  4360 ?        Sl   16:12   0:00
> /usr/lib/at-spi2-c
> filiprd   1921  0.0  0.3 488748 14116 ?        Sl   16:12   0:06
> update-notifier
> root      1957  0.0  0.3  95424 12332 ?        S    16:12   0:00
> /usr/bin/python /u
> filiprd   1977  0.0  0.1 294684  6620 ?        Sl   16:13   0:00
> /usr/lib/deja-dup/
> root      3164  0.0  0.0      0     0 ?        S<   16:18   0:00
> [kworker/u3:0]
> filiprd   3209  0.0  0.0  46196  2184 ?        S    16:19   0:00
> /usr/lib/gvfs/gvfs
> postgres  5792  0.0  0.2 131984 10156 ?        S    16:23   0:04
> /usr/lib/postgresq
> postgres  5794  0.0  0.1 132096  7344 ?        Ss   16:23   0:14 postgres:
> writer p
> postgres  5795  0.0  0.0 131984  2332 ?        Ss   16:23   0:11 postgres:
> wal writ
> postgres  5796  0.0  0.0 132888  3220 ?        Ss   16:23   0:04 postgres:
> autovacu
> postgres  5797  0.0  0.0 100696  1800 ?        Ss   16:23   0:03 postgres:
> stats co
> root      6811  0.0  0.0  26568   540 ?        S    16:45   0:00
> dbus-launch --auto
> root      6812  0.0  0.0  24088   972 ?        Ss   16:45   0:00
> //bin/dbus-daemon
> root      6816  0.0  0.0 261996  2720 ?        Sl   16:45   0:00
> /usr/lib/dconf/dco
> root      6821  0.0  0.1 360580  7532 ?        Sl   16:45   0:00
> /usr/bin/zeitgeist
> root      6828  0.0  0.2 249948  9320 ?        Sl   16:45   0:00
> /usr/lib/zeitgeist
> root      6830  0.0  0.1 426944  6288 ?        Sl   16:45   0:01
> zeitgeist-datahub
> root      6833  0.0  0.0  11392   356 ?        S    16:45   0:00 /bin/cat
> root      6835  0.0  0.0  52392  2396 ?        S    16:45   0:00
> /usr/lib/gvfs/gvfs
> root      6842  0.0  0.0 220376  3628 ?        Sl   16:45   0:00
> /usr/lib/gvfs//gvf
> filiprd  12680  0.0  0.5 531900 20808 ?        Sl   18:13   0:11
> gnome-terminal
> filiprd  12687  0.0  0.0  14796   824 ?        S    18:13   0:00
> gnome-pty-helper
> filiprd  12690  0.0  0.1  27372  4420 pts/0    Ss   18:13   0:01 bash
> root     13794  0.0  0.0      0     0 ?        S<   18:56   0:00
> [kworker/u3:2]
> root     16045  0.0  0.0  19080   384 ?        Ss   21:06   0:00 jsvc.exec
> -user je
> jetty    16047  0.7  1.8 1104540 75000 ?       Sl   21:06   0:10 jsvc.exec
> -user je
> root     16489  0.0  0.0  91028  3640 ?        Ss   21:09   0:00
> /usr/sbin/apache2
> www-data 16491  0.0  0.0  90760  2640 ?        S    21:09   0:00
> /usr/sbin/apache2
> www-data 16494  0.6  2.5 557860 103308 ?       Sl   21:09   0:08
> ckan_default
> www-data 16495  0.5  2.5 555756 103188 ?       Sl   21:09   0:07
> ckan_default
> www-data 16496  0.0  0.2 232236  8244 ?        Sl   21:09   0:00
> demo
> www-data 16497  0.0  0.2 839044 11800 ?        Sl   21:09   0:00
> /usr/sbin/apache2
> www-data 16498  0.0  0.2 511284 10936 ?        Sl   21:09   0:00
> /usr/sbin/apache2
> root     16612  0.0  0.0 107608  1400 ?        Ss   21:09   0:00 nginx:
> master proc
> www-data 16613  0.0  0.0 107920  1704 ?        S    21:09   0:00 nginx:
> worker proc
> www-data 16614  0.0  0.0 107920  1704 ?        S    21:09   0:00 nginx:
> worker proc
> www-data 16615  0.0  0.0 107920  1704 ?        S    21:09   0:00 nginx:
> worker proc
> www-data 16616  0.0  0.0 107920  2212 ?        S    21:09   0:00 nginx:
> worker proc
> www-data 16617  0.0  0.0 107764  1708 ?        S    21:09   0:00 nginx:
> cache manag
> postgres 16624  0.0  0.2 136592 11036 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16625  0.0  0.2 134184  8976 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16626  0.0  0.1 133888  7072 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16627  0.0  0.2 135652 10396 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16637  0.0  0.2 136452 10424 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16638  0.0  0.2 134184  8872 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16642  0.0  0.1 133888  7068 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16643  0.0  0.2 135496  9700 ?        Ss   21:09   0:00 postgres:
> ckan_def
> postgres 16647  0.0  0.1 134180  7892 ?        Ss   21:09   0:00 postgres:
> datastor
> root     16677  0.0  0.0      0     0 ?        S    21:16   0:00
> [kworker/u2:1]
> root     16728  0.0  0.0      0     0 ?        S    21:21   0:00
> [kworker/0:2]
> root     16730  0.0  0.0      0     0 ?        S    21:21   0:00
> [kworker/u2:0]
> root     16733  0.0  0.0      0     0 ?        S    21:22   0:00
> [kworker/0:3]
> root     16747  0.0  0.0      0     0 ?        S    21:27   0:00
> [kworker/u2:2]
> root     16751  0.0  0.0      0     0 ?        S    21:27   0:00
> [kworker/0:0]
> filiprd  16762  0.0  0.0  22368  1268 pts/0    R+   21:30   0:00 ps aux
>
> Any hint would be really helpful.
>
> Cheers
>
> --------
> Filip Radulovic
> www.filip.milstan.net
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150718/e3a3fb2f/attachment-0003.html>


More information about the ckan-dev mailing list