Running SQLite
Sid Agrawal
siagraw at cs.ubc.ca
Sun Jun 11 06:59:54 CEST 2023
Thanks you Christian.
I was also reaching the same conclusion. I made changes to
vfs_plugin.cc so that fcntl always returns success for F_SETLK. But
your patch is cleaner.
Best,
Sid
On Sat, Jun 10, 2023 at 9:20 PM Christian Prochaska
<christian.prochaska at genode-labs.com> wrote:
>
> [CAUTION: Non-UBC Email]
>
> Hi Sid,
>
> I had to patch the sqlite3 implementation that comes with Qt5
> because of missing F_SETLK support. Maybe it is the same problem?
>
> This is the patch:
>
> https://github.com/cproc/qt5/commit/c8b512db33a612e5026aa73fd8bfd257f967cdd8.patch
>
> Christian
>
> On 11.06.23 05:26, Sid Agrawal wrote:
> > Hi,
> > I am writing a simple program to exercise sqlite3. I have written it
> > using vfs_example_5 as a base, so I can access a file. Though the
> > program compiles (which is great), I am running into issues at
> > runtime. Looks like SQLite is calling fcntl with a command that the
> > vfs_plugin doesn't recognize.
> >
> > My gut tells me that I am missing some compile flags, i.e., I need to
> > compile the sqlite3.c file in a way that is better suited to the libc
> > version used by Genode, which, IIRC is BSD's libc. Or perhaps I need
> > to use an older version of SQLite? Or I could be way off :)
> >
> > It would be great if folks could point me in the right direction. My
> > code and steps to repro are below.
> >
> > Best,
> > Sid
> >
> >
> > Source Code:
> > https://github.com/sid-agrawal/genode/tree/sid-branch/repos/osmosis_examples/src/app/sqlite_example
> >
> >
> > Steps to reproduce:
> >
> > git clone https://github.com/sid-agrawal/genode.git
> > cd genode
> > git checkout sid-branch
> > ./tool/create_builddir x86_64
> > cd build/x86_64
> > # Update build.conf to
> > # - include osmosis_examples, libports and ports repos
> > # - comment out the -no-kvm option
> > <GENODE_DIR>/tool/ports/prepare_port grub2 libc
> > make KERNEL=hw run/sqlite_example
> >
> >
> > Output:
> > -----------------------START--------------------------------
> > kernel initialized
> > Warning: TSC calibration not yet implemented, using fixed value
> > Genode 21.05-2061-gcf807a62cb
> > 785 MiB RAM and 64533 caps assigned to init
> > [init -> sqlite_example] Starting example
> > [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> > [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> > [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> > [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> > [init] child "sqlite_example" exited with exit value 0
> >
> > Run script execution successful.
> > -----------------------END--------------------------------
> >
> >
> >
> >
> >
> > On Tue, Jun 6, 2023 at 9:26 AM Sid Agrawal <siagraw at cs.ubc.ca> wrote:
> >> Hi,
> >> I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
> >>
> >> Best,
> >> Sid
> >> PhD UBC
> >> sid-agrawal.ca
> > _______________________________________________
> > Genode users mailing list
> > users at lists.genode.org
> > https://lists.genode.org/listinfo/users
> > E�n�sڶ �z� ���z�b�� zz z��
> > �b���u: ����&��� ��$j ��ץi� �d^q�y��i��X ��^���r���f�� ��ץi� �l"� �L�� �n+�>�d
> > � eM7 ���h���k�z� ���z�b�� zz z��~�܆���&��� ��$j ��ץi� �d��]I�}��}9ۮ:�M�� �z+�u��X���}�^��m�� �� �� zz z��o)��X ��^���r���)���`�w��ε� ���&�� --wL�� -��`�Hp7����zZ)y��� ���w �X��� ��^��"wZ� =tӡ[�p �}u&���m��n���6�@� Ģ�v���� �Ƭ���ꠞ����Z�� ��Z��] X�� ��^��, m�M�*���N����� w(v)�
> > ��z{Sʗ�z�rN��Ԯn�+�����GzZK��O��K��@��b����'���r��x����S�+���-1�,j � 6�xZ蘉�z�rN�^}�ޝǬ0� U�슉�zw^�' �{^��
> > ��z{Cz�+��b�t^���
> > �^E� ��k�d^���I��z�^���N�^��� �^���1�,j � ����'z���' �c��� � M�m�&�a��t���b� �� ;) a��nZ�M8؎i��� =��y8,�ap� Ӧ/� T�CѠ� �6�C� � �����ӑ��N {�Hc�
> > ˨ � ? Ow��[�D�3&��Й�&�! Ζo��э�F�~'
> > �F�x��*s �7��L�7
> > T X�! W&�pV� { 2N�\� ���tIv��xۍd�c �b �9�ر��"� ��k�la 況���, �8��� �u����ٗ!�3x�-.�A ���;�w� ߳ t � � �`� ���g R���R��=��ƀyǢ��_�����hq�a��u��h _ׯ5�mvo)b�� zz z���+azɭ�Lb��x���zZ)y��� ���w �X��� ��^��"wZ� *��MNL� �}u&���m��n���6�D^q�y��i��W,�� k^6�M��V�+-� ��ר� "� ���lL����lL�� 1�E !1� -��`�Hp7�1�n=�g���h���k"j
> > ���.m� ��j� ��M5;��~����+-� ��ר� ��]I�}��}9ۭ��M�� �z+�u��f���5 _4�� ��(�f���5 _4�� ��(�m=��_4j�az{bq�^u���
> > �f���.m� �^v��w� ��D�L��� t ܝ6���슉L���g"� � ۞� ć 8n+l n��� �ߢ��z�%��l���u�+�&��Bn�m6�m6�]��M yǢ��[�f���5 _4�� ��(� ��# >'Z �\w]�{~{�x�� ����n����~����+-� ��ר� ��] �}��}�ۭwӽ4<4� c �Ơy+Z�� �W���M ��f�$h>�� Q���T�ӕE�}�6������8 �(�˦4A��Ǧ� \�PH� �#���+��� ��%y)��*.�ǀ q�g��֪~� 29� L̓ r� � �6v @ eP�
> > w*L ���g _<����� S���<K�W3��3��r|E� ���o-��f��uѽ;��6�G���"� �L���M6�M�k~���t�M4ѽ4�M k�毝�۞|�H6�^��w��u����] �}��}�ۭuӽ4<4� � z�"�}tE�ޭ��z���]�)���KE/ ��xm��
> > ��n ����-u � ��X&j)\�b'E�e�: �vT� �-- �>����4 at 4 2�a�
> > ��6���2x&j)`���r������� �� �Ț���r˛qƃjגj�t&���m��n��N��q�j)N�("��Lz� �� ��R�l=���� � 6 �� жv g ñx � ���&j)`���r��z� �� ��R�l=���� � 6 �� жv g ñx � ���&j)`���r�����r�^F��x @��y: zz z� �ɚ�X��X��� ��b�� zz z��\ ��8^��z�%��l���u�+�s �Y��W��*'�]�>��yקq�b���� ��u�z�&j)b� b�۬z�%��l���u�+����I칻 �&ކ�i����l���u�+��)�*'���z�&j)m�� ��ު笶X��� ��^��,���rО˛���m���+r �z m����l���u�+��b���j) �ǫ�����ٚ�[h�ǫ�X��� ��^�� ��GzZfj)m�� ��ު笶X��� ��^��,���r�zZK��R�� �&ކ�i����l���u�+��b�ا~���왨����z�+z����b�� zz z����y˲��r��y ��$� ��u�z�&j)b� b�۬z�%��l���u�+�*'���O*^��m��Z�w!j� � ���ק�:ڞ�ެIܡا���{� ��+�:.���n��q�%��l���u�+�t�jhh�ٚ�X ��^���r��J����+{oWJ����+z)���ҥ��j�ҥ��z�+� -4 _(� cD
> > � T �
> > 0 ы!$�P�� T N
> > ��]2�4@�U �,�� 0�MR K �H [H ܚ] [�� H �[\ H ��ܘ[H � ^ \��\�H �[ ] Lˈ H ]�H ܚ] [� ] �\�[�� ����^ [\ W�H \� H �\�K �� H �[� X��\�� H �[ K� �Y� B� ��ܘ[H ��\ [ \�
> > � X� \� ܙX]
> > K H [H �[��[�� [� � \��Y\� ] ��[� [YK� ���� Z�H �S ] H \� �[ [�� � �] H ��[X[� ] B����� Y�[� �\ۉ� �X��ۚ^�K���^H �] [ � YH ] H [H Z\��[�� ��YH ��\ [ H � Y�� K�K� H �YY ˜��\ [ H H �[ ] L˘� �[ H [� H �^H ] \� �] \� �Z] Y � H X� �\��[ۈ \�Y �H �[�� K � X� RT�� \� �� �� X�ˈ ܈ \� \ � H �YY � � \�H [� � \� �\��[ۈ و �S ] O� ܈ H ��[ �H �^H ٙ� �B��] ��[ �H ܙX] Y� �� �� ��[ �[� YH [� H �Y� \�X� [ۋ� ^B��� H [� � \ � � �\ �� \�H �[ �˂���\� ��Y �����\��H �� N�� ���] X����K��Y XYܘ]�[ ��[�� K� �YK��Y X��[�� ܙ\ �����[��\��^ [\ \��ܘ��\ ��[ ] W�^ [\ B���� \ � � �\ �� X�N����] � ۙH ���] X����K��Y XYܘ]�[ ��[�� K��] �� �[�� B��] � X���] �Y X��[�� � �� �� �ܙX] W؝Z[ \�
> > �͍ � � �Z[ �
> > �͍ �� \ ] H �Z[ ��ۙ� ˆ� H [�� Y H ��[��\��^ [\ \� X� ܝ � [� ܝ � �\ �ˆ� H ��[Y[� �] H [��ZݛH � [ۂ� �S�� W� T��� �� � ܝ �� �\ \�W� ܝ ܝX�� X�›XZ�H �T��S Z � �[���[ ] W�^ [\ B����] ] ��KKKKKKKKKKKKKKKKKKKKKKT� T� KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB��\��[ [�] X[ ^�Y ��\��[�Έ �� �[ X��] [ۈ �� Y] [\ [Y[� Y \�[�� �^ Y �[ YB��[�� H �K�
> > KL�
> > �KY�َ
> > �M����
> > H ZP� �SH [�
> > �
> > L�� �\ � \��YۙY � [�] ��[�] O� �[ ] W�^ [\ WH � \� [�� ^ [\ B��[�] O� �[ ] W�^ [\ WH \��� �
> >
> > N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
> >
> > N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
> >
> > N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
> >
> > N� ��[X[� L� �� �\ ܝ Y H ��–�[�] H � [ ��[ ] W�^ [\ H� ^ ] Y �] ^ ] �[ YH ���[� �ܚ\ ^ X�] [ۈ �X��\�ٝ[ ��KKKKKKKKKKKKKKKKKKKKKKQS� KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB������ۈ YK �[�
> > � � �� ] N����+�SH �Y Yܘ]�[ �XYܘ]� �˝X�˘�O� ܛ� N����� K �� H ��[ Z�H � �[� �S ] H [��Y H H �[�� H ���\�ˈ H ��[ �� �[� H �[� �X�\ H ܈ H \� [� X� ܝ ˈ \� ��Y[ۙH �YY [� H \� � Y� �� �[� [�H X\�H �[� YH [� H �Y� \�X� [ۏ ��� �\� �� �Y �� P� � �Y XYܘ]�[ ��B������������������������������������������������‘�[�� H \�\�� XZ[ [�� \� �\�\�� \� ˙�[�� K�ܙš �� \� ˙�[�� K�ܙ�� \� [����\�\��g===
>
>
> _______________________________________________
> Genode users mailing list
> users at lists.genode.org
> https://lists.genode.org/listinfo/users
More information about the users
mailing list